Merhaba, Hoşgeldin!

VSRO.org, Silkroad Online, Knight Online, Metin2 ve diğer çevrimiçi oyunlar için öncü bir yardım ve geliştirme platformudur. Misyonumuz, bilgi ve deneyim sahibi bireyleri, bilgiye ihtiyaç duyanlarla bir araya getirerek, zengin bir etkileşim ortamı yaratmak ve farklı bakış açılarını birleştirmektir. Topluluğumuzda güçlü bir işbirliği ve öğrenme kültürü oluşturarak, herkesin değerli katkılarda bulunmasını sağlıyoruz.

iSRO-R Paylaşım ISRO-R ACC-SHARD-LOG CLEAN QUERY

hanibal67

hanibal67

.
Katılım
18 Eyl 2020
Mesajlar
477
Çözümler
2
Tepkime puanı
249
Puanları
43
Konum
istanbul
Türk Lirası
0.00₺
Merhabalar

database temizleme kodlarını aşağıya bırakıyorum herkese kolay gelsin

SHARD_DB
USE SILKROAD_R_SHARD
GO
TRUNCATE TABLE [dbo].[_SurvivalPVPSeasons] -- truncate it too dont forget
TRUNCATE TABLE [dbo].[__Statistics_AbnormalChar]
TRUNCATE TABLE [dbo].[__Statistics_CharLastLogout]
TRUNCATE TABLE [dbo].[__Statistics_Gacha]
TRUNCATE TABLE [dbo].[__Statistics_ItemsAboveOpt8]
TRUNCATE TABLE [dbo].[__Statistics_ItemsCountInMall]
TRUNCATE TABLE [dbo].[__Statistics_ItemsGradeOptLevelRare]
TRUNCATE TABLE [dbo].[__Statistics_ItemsGradeOptLvRareMagOpt]
TRUNCATE TABLE [dbo].[__Statistics_ItemsOptLevel]
TRUNCATE TABLE [dbo].[__Statistics_PerformanceLog]
TRUNCATE TABLE [dbo].[__Statistics_PetCount]
TRUNCATE TABLE [dbo].[__Statistics_RentItem]
TRUNCATE TABLE [dbo].[__Statistics_SystemExchageCoupon]
TRUNCATE TABLE [dbo].[__StatisticsGachaByChanneling]
TRUNCATE TABLE [dbo].[_BindingOptionWithItem]
TRUNCATE TABLE [dbo].[_AchievementCondition]
TRUNCATE TABLE [dbo].[_ActiveUser]
TRUNCATE TABLE [dbo].[_ActiveUser_Rigid]
TRUNCATE TABLE [dbo].[_BlockedPartyInviter]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_BuyCashItemList_By_Web]
TRUNCATE TABLE [dbo].[_CharAlchemy_MK_Recipe]
TRUNCATE TABLE [dbo].[_CharCollectionBook]
TRUNCATE TABLE [dbo].[_CharImprisonment]
TRUNCATE TABLE [dbo].[_CharInstanceWorldData]
TRUNCATE TABLE [dbo].[_CharNameList]
TRUNCATE TABLE [dbo].[_CharNewTrade]
TRUNCATE TABLE [dbo].[_CharNickNameList]
TRUNCATE TABLE [dbo].[_CharQuest]
TRUNCATE TABLE [dbo].[_CharSkillMastery]
TRUNCATE TABLE [dbo].[_CharSkill]
TRUNCATE TABLE [dbo].[_CharSupportItemByLevel]
TRUNCATE TABLE [dbo].[_CharTeleport]
TRUNCATE TABLE [dbo].[_CharTitle]
TRUNCATE TABLE [dbo].[_CharTradeConflictJob]
TRUNCATE TABLE [dbo].[_CharTradeConflictJob_Kill]
TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]
TRUNCATE TABLE [dbo].[_CharUniqueKill]
TRUNCATE TABLE [dbo].[_Chest]
TRUNCATE TABLE [dbo].[_ChestInfo]
TRUNCATE TABLE [dbo].[_ClientConfig]
TRUNCATE TABLE [dbo].[_ConsignmentTrade_Invest]
TRUNCATE TABLE [dbo].[_ConsignmentTrade_Progress]
INSERT INTO _ConsignmentTrade_Progress
VALUES (1, 0, 29, 27, 0, 1004, 1004, 1, Getdate())
INSERT INTO _ConsignmentTrade_Progress
VALUES (2, 0, 52, 47, 0, 1002, 1002, 2, Getdate())
TRUNCATE TABLE [dbo].[_CraftedMacroUser]
TRUNCATE TABLE [dbo].[_DeletedChar]
TRUNCATE TABLE [dbo].[_DeleteEventItemList]
TRUNCATE TABLE [dbo].[_DeleteItemChestLog]
TRUNCATE TABLE [dbo].[_DelItem_N_RewardList]
TRUNCATE TABLE [dbo].[_EntryTicketCandidatesList]
TRUNCATE TABLE [dbo].[_EntryTicketDrawingList]
TRUNCATE TABLE [dbo].[_EntryTicketWinnerList]
TRUNCATE TABLE [dbo].[_EquipErrorCOS]
TRUNCATE TABLE [dbo].[_EquipInvCOS]
TRUNCATE TABLE [dbo].[_Event_HiSilkRoad_PrizeList]
TRUNCATE TABLE [dbo].[_EventBuffReceipt]
TRUNCATE TABLE [dbo].[_EventForgottenWorld]
TRUNCATE TABLE [dbo].[_EventRamadanVoucher]
TRUNCATE TABLE [dbo].[_EventSupportHighLevelUser]
TRUNCATE TABLE [dbo].[_EventTicket_Participants]
TRUNCATE TABLE [dbo].[_ExchangeItem_Payment_Data]
TRUNCATE TABLE [dbo].[_ExploitLog]
TRUNCATE TABLE [dbo].[_Fatigue_For_Shard]
TRUNCATE TABLE [dbo].[_FlagWorld_CoinRewardLog]
TRUNCATE TABLE [dbo].[_FlagWorld_EventParticipants]
TRUNCATE TABLE [dbo].[_FleaMarketNetwork]
TRUNCATE TABLE [dbo].[_FreeAccessBanLvl]
TRUNCATE TABLE [dbo].[_Friend]
TRUNCATE TABLE [dbo].[_FriendGroup]
TRUNCATE TABLE [dbo].[_GoldTrace]
TRUNCATE TABLE [dbo].[_GPHistory]
TRUNCATE TABLE [dbo].[_GuildChest]
TRUNCATE TABLE [dbo].[_GuildCrest]
TRUNCATE TABLE [dbo].[_GuildLogGuildChest]
TRUNCATE TABLE [dbo].[_GuildLogGuildMain]
TRUNCATE TABLE [dbo].[_GuildLogGuildPoint]
TRUNCATE TABLE [dbo].[_GuildMember]
TRUNCATE TABLE [dbo].[_GuildWar]
TRUNCATE TABLE [dbo].[_InvCOS]
TRUNCATE TABLE [dbo].[_Inventory]
TRUNCATE TABLE [dbo].[_InventoryForAvatar]
TRUNCATE TABLE [dbo].[_ItemPool]
TRUNCATE TABLE [dbo].[_ItemQuotation]
TRUNCATE TABLE [dbo].[_KeepDelCharName]
TRUNCATE TABLE [dbo].[_LastestOpenMarketPesnalID]
TRUNCATE TABLE [dbo].[_LOG_DEL_ITEM_N_REWARD_AMOUNT]
TRUNCATE TABLE [dbo].[_LOG_EVENT_LEVEL_RIGID]
TRUNCATE TABLE [dbo].[_LOG_EVENT_PAYMENT_ITEM_OCCUPY_SIEGEFORTRESS]
TRUNCATE TABLE [dbo].[_LOG_EVENT_PAYMENT_ITEM_OCCUPY_SIEGEFORTRESS_TEMP]
TRUNCATE TABLE [dbo].[_LOG_RESULT_REWARD_SILK]
TRUNCATE TABLE [dbo].[_Log_SEEK_N_DESTROY_ITEM_FAST]
TRUNCATE TABLE [dbo].[_LogEventGold]
TRUNCATE TABLE [dbo].[_LogEventGold_new]
TRUNCATE TABLE [dbo].[_LogEventGoldInfo]
TRUNCATE TABLE [dbo].[_LogEventItem_1_tt]
TRUNCATE TABLE [dbo].[_LogRepairList_Reward_3Job_Related_Item]
TRUNCATE TABLE [dbo].[_Memo]
TRUNCATE TABLE [dbo].[_MemoBlock]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_Notice_Detail]
TRUNCATE TABLE [dbo].[_OpenMarket]
TRUNCATE TABLE [dbo].[_OldTrijob]
TRUNCATE TABLE [dbo].[_OrphanItems]
TRUNCATE TABLE [dbo].[_PreoccupancyName]
TRUNCATE TABLE [dbo].[_RankingForChar]
TRUNCATE TABLE [dbo].[_RankingForGold]
TRUNCATE TABLE [dbo].[_RankingForGuild]
TRUNCATE TABLE [dbo].[_RankingForLevel]
TRUNCATE TABLE [dbo].[_RenameLog_Char]
TRUNCATE TABLE [dbo].[_RenameLog_Guild]
TRUNCATE TABLE [dbo].[_RentItemInfo]
TRUNCATE TABLE [dbo].[_RentItemRepairedLog]
TRUNCATE TABLE [dbo].[_ResultOfPackageItemToMappingWithServerSide]
TRUNCATE TABLE [dbo].[_RollBook_UserEventData]
TRUNCATE TABLE [dbo].[_RollBook_UserRollData]
TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]
TRUNCATE TABLE [dbo].[_SiegeFortressObject]
TRUNCATE TABLE [dbo].[_SroMacroConfigHunting]
TRUNCATE TABLE [dbo].[_SroMacroConfigPotion]
TRUNCATE TABLE [dbo].[_SroMacroConfigSkill]
TRUNCATE TABLE [dbo].[_StaticAvatar]
TRUNCATE TABLE [dbo].[_SurvivalPVPHallOfFame_LastSurviving]
TRUNCATE TABLE [dbo].[_SurvivalPVPHallOfFame_PartyMatching]
TRUNCATE TABLE [dbo].[_TimedJob]
TRUNCATE TABLE [dbo].[_TimedJobForPet]
TRUNCATE TABLE [dbo].[_TradeBagInventory]
TRUNCATE TABLE [dbo].[_TradeEquipInventory]
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
DELETE FROM [SILKROAD_R_SHARD].[dbo].[_TrainingCamp]
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_TrainingCamp]', RESEED, 0);
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)
TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
TRUNCATE TABLE [dbo].[_User]
TRUNCATE TABLE [dbo].[_UserTradeConflictJob]
DELETE FROM [dbo].[_AccountJID]
DELETE FROM [SILKROAD_R_SHARD].[dbo].[_Achievement] WHERE ID > 0
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_Achievement]', RESEED, 0);
DELETE FROM [SILKROAD_R_SHARD].[dbo].[_CharTrijob] WHERE CharID > 0
DELETE FROM [SILKROAD_R_SHARD].[dbo].[_Char] WHERE CharID > 0
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_Char]', RESEED, 0);
DELETE FROM [dbo].[_CharCOS] WHERE ID > 0
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_CharCOS]', RESEED, 0);
DELETE FROM [dbo].[_Items] WHERE ID64 > 0
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_Items]', RESEED, 0);
DELETE FROM [dbo].[_TEMP_ADDITEMEXTERN_CHEST_LOG] WHERE ID > 0
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_TEMP_ADDITEMEXTERN_CHEST_LOG]', RESEED, 0);
TRUNCATE TABLE [dbo].[_SiegeFortressStruct]
DELETE FROM [dbo].[_SiegeFortress]
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (4)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6)
DELETE FROM [dbo].[_Guild] WHERE ID > 0
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_Guild]', RESEED, 0);
TRUNCATE TABLE [dbo].[_AllianceCrest]
UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0'
DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0
DBCC CHECKIDENT ('[SILKROAD_R_SHARD].[dbo].[_AlliedClans]', RESEED, 0);

--------------------------------
ACCOUNT_DB

USE [SILKROAD_R_ACCOUNT]
GO
truncate table [SILKROAD_R_ACCOUNT].[dbo].[__OldUsers__]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_BlockedUser]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_CraftedMacroPunishmentHistory]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_FreeAccess]
TRUNCATE TABLE [SILKROAD_R_ACCOUNT].[dbo].[_ModuleVersion]
GO
SET IDENTITY_INSERT [dbo].[_ModuleVersion] ON
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (1, 65, 65, 1, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (2, 65, 65, 2, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (3, 65, 65, 3, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (4, 65, 65, 4, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (5, 65, 65, 5, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (6, 65, 65, 6, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (7, 65, 65, 7, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (8, 65, 65, 8, 1, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (9, 65, 65, 9, 228, N'initial version', N'', 1)
GO
INSERT [dbo].[_ModuleVersion] ([nID], [nDivisionID], [nContentID], [nModuleID], [nVersion], [szVersion], [szDesc], [nValid]) VALUES (10, 65, 65, 14, 1, N'initial version', N'', 1)
GO
SET IDENTITY_INSERT [dbo].[_ModuleVersion] OFF
GO
TRUNCATE TABLE [SILKROAD_R_ACCOUNT].[dbo].[_ModuleVersionFile]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_PrivilegedIP]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_PrivilegedSMCIP]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_Punishment]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_Rigid_Donation_Log_2018]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_Rigid_Login_Event]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_Rigid_Login_Event_Calendar]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_Rigid_Login_Event_Calendar_Playtime]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_Rigid_Login_Event_Reward_Log]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_SecondaryPassword]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_ShardCurrentUser]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_ShardCurrentUserByChanneling]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[_SMCLog]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[ASPSessionState]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering_1]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering_2]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering_3]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering_4]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering_5]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering_6]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LoginGathering_7]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering_1]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering_2]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering_3]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering_4]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering_5]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering_6]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_LogoutGathering_7]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering_1]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering_2]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering_3]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering_4]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering_5]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering_6]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[JC_CRM_R_ServerGathering_7]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[MagicLamp_Cleaner]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[MagicLamp_Cleaner_history]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[SR_ShardCharNames]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[SupAdmin]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[SupAdminLog]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[TB_User]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[SK_Silk]
delete FROM [SILKROAD_R_ACCOUNT].[dbo].[TB_User_backup]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[TB_User_Channel]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[WEB_ACTION_LOG]
TRUNCATE TABLE [SILKROAD_R_ACCOUNT].[dbo].[WEB_ITEM_CERTIFYKEY]
TRUNCATE TABLE [SILKROAD_R_ACCOUNT].[dbo].[WEB_ITEM_GIVE_LIST]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[WEB_ITEM_GIVE_LIST_DETAIL]
truncate table [SILKROAD_R_ACCOUNT].[dbo].[WEB_ITEM_RESERVED]

--------------------------------
LOG_DB

USE [SILKROAD_R_SHARD_LOG]
GO
truncate table [dbo].[_ConsignmentTrade_PrevInvestCharLog]
truncate table [dbo].[_CompeltedConsignmentTradeLOG]
truncate table [dbo].[_ConsignmentTrade_Reward]
truncate table [dbo].[_ConsignmentTrade_Progress_RuntimeLog]
truncate table [dbo].[_LogEventItem]
truncate table [dbo].[_LogEventChar]
truncate table [dbo].[_LogRollBookItemPay]
truncate table [dbo].[_LogServerEvent]
truncate table [dbo].[_LogBot]
truncate table [dbo].[_LogCashItem]
truncate table [dbo].[_LogInstanceWorldInfo]
truncate table [dbo].[_LogWebCashItem]
truncate table [dbo].[_LogChatMessage]
truncate table [dbo].[_LogInitializeCharSkill]
truncate table [dbo].[_LogInitializeCharSkillMastery]
truncate table [dbo].[_LogUseInitializeSkillItem]
truncate table [dbo].[_LogSchedule]
truncate table [dbo].[_LogEventSiegeFortress]
truncate table [dbo].[_EntryTicketLog]

--------------------------------------

gbportal

truncate table [GB_JoymaxPortal].[dbo].[MU_AuthInfo]
truncate table [GB_JoymaxPortal].[dbo].[MU_Email]
truncate table [GB_JoymaxPortal].[dbo].[MU_EventUser]
truncate table [GB_JoymaxPortal].[dbo].[MUH_EmailCertification]
truncate table [GB_JoymaxPortal].[dbo].[MU_JCPlanet]
truncate table [GB_JoymaxPortal].[dbo].[MU_JoiningInfo]
truncate table [GB_JoymaxPortal].[dbo].[MU_MobileNumber]
truncate table [GB_JoymaxPortal].[dbo].[MU_Motp]
truncate table [GB_JoymaxPortal].[dbo].[MU_SecederInfo]
DELETE FROM [GB_JoymaxPortal].[dbo].[MUH_AlteredInfo]
truncate table [GB_JoymaxPortal].[dbo].[AUH_AgreedService]
truncate table [GB_JoymaxPortal].[dbo].[AUH_Abusing]
DELETE FROM [GB_JoymaxPortal].[dbo].[APH_SilkBalance]
DELETE FROM [GB_JoymaxPortal].[dbo].[APH_CPItemSaleDetails]
DELETE FROM [GB_JoymaxPortal].[dbo].[APH_ChangedSilk]
DBCC CHECKIDENT ('[GB_JoymaxPortal].[dbo].[APH_ChangedSilk]', RESEED, 0);
DELETE FROM [GB_JoymaxPortal].[dbo].[MU_User]
DBCC CHECKIDENT ('[GB_JoymaxPortal].[dbo].[MU_User]', RESEED, 0);
truncate table [GB_JoymaxPortal].[dbo].[mu_user_test_silk]
truncate table [GB_JoymaxPortal].[dbo].[MU_UserNEW]
truncate table [GB_JoymaxPortal].[dbo].[MU_VIP_FreeUseList]
truncate table [GB_JoymaxPortal].[dbo].[MU_VIP_Info]
truncate table [GB_JoymaxPortal].[dbo].[MU_VIP_UpdateLog]
truncate table [GB_JoymaxPortal].[dbo].[MU_Vip1]
truncate table [GB_JoymaxPortal].[dbo].[MU_Vip3]
 
Cevap yazmak için giriş yap yada kayıt ol.

Benzer konular

M
  • Soru Soru
vSRO Çözüldü can someone here please pass me link of weapons d13 + d14 + 15, set, weapon, acc, stones etc = isro
Cevaplar
0
Görüntüleme
656
maicon linkon
M
Venice-R
90 Cap VENICE-R ONLINE | 90 CAP EU & CH | 1x Rate | ISRO - R FILES | Beta Açılış 25.10.2024 21:00 ! | BÜYÜK AÇILIŞ 01.11.2024 21:00 !
Cevaplar
8
Görüntüleme
185
Venice-R
Venice-R
JoySilkroad
110 Cap JoySilkroad | 110 Cap CH & EU | ISRO System | Full Activity & Job Based | Happy Event | Beta 14.09.2024 | G.O 18.10.2024
2
Cevaplar
10
Görüntüleme
973
Sieger
Sieger
Venom
Tanıtım ALPS-R Server Atlantis | 100 CAP EU-CH | ISRO-R Files | G.O 11.10.2024 Saat 20:00
2
Cevaplar
13
Görüntüleme
1K
Venom
Venom
Thor
iSRO-R Paylaşım Agate Online DB ISRO-R
2 3
Cevaplar
29
Görüntüleme
844
stamina
S
Geri
Üst Alt