Hoş Geldin, Ziyaretçi!

Forum içeriğine ve tüm hizmetlerimize erişim sağlamak için foruma kayıt olmalı ya da giriş yapmalısınız. Foruma üye olmak tamamen ücretsizdir.

Giriş yapŞimdi kayıt ol
dsgn kguard
ROLLET remastered
vsupload kguardedgeakademi
cleopatra legacy
ecr-online rebels reklam

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

hanibal67

hanibal67

Premium
.
Katılım
18 Eyl 2020
Mesajlar
438
Alınan Beğeni
181
Ödül Puanları
43
Konum
istanbul
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]
 
N

nouvolx01

.
.
Katılım
22 Eyl 2020
Mesajlar
42
Alınan Beğeni
29
Ödül Puanları
18
Konum
viet nam
Bu kullanıcıyla bir anlaşma yapmak istiyorsanız, bu forumdan uzaklaştırıldığını lütfen unutmayın.
thanks
 
A

abezyth

.
Katılım
21 Nis 2022
Mesajlar
82
Alınan Beğeni
3
Ödül Puanları
8
Konum
COLOMBIA
ty
Üst üste post gönderildiği için tek mesajda birleştirildi:

ty
 
Cevap yazmak için giriş yap yada kayıt ol.
  Benzer konular Forum Tarih
iSRO-R Paylaşım ISRO-R Blue Query ISRO-R - Genel Paylaşım 3 169
iSRO-R Yardım ISRO-R RIGID FILES ITEM MOB SORUNU ISRO-R - Sorunlar ve Çözümleri 0 104
iSRO-R Yardım ISRO-R Webmall Hatası ISRO-R - Sorunlar ve Çözümleri 0 82
iSRO-R Çözüldü iSro-R webmall hatası ISRO-R - Sorunlar ve Çözümleri 0 93
iSRO-R Çözüldü iSro-R webmall hatası image files! ISRO-R - Sorunlar ve Çözümleri 3 180

Benzer konular

Konular

10.2K

Mesajlar

120.4K

Kullanıcılar

10.1K

Son üye

canowar

Uyarı
vSRO.ORG; 5651 Sayılı Kanun kapsamında BTK tarafından onaylı Yer Sağlayıcı'dır. Bu sebeple içerikleri kontrol etme ya da araştırma yükümlülüğü yoktur. Hukuka ve mevzuata aykırı olduğunu düşündüğünüz içeriği BURADAN bildirebilirsiniz. İletişime geçilmesi halinde ilgili kanunlar ve yönetmelikler çerçevesinde gerekli işlemler yapılacaktır.
Community platform by XenForo® © 2010-2021 XenForo Ltd.
XenForo Style eTiKeT™ 2020
XenForo 2 Türkçe 🇹🇷 eTiKeT™ 2021
Tepki lideri konular
AdBlock Detected

Anlıyoruz, reklamlar can sıkıcı!

Elbette, reklam engelleme yazılımı reklamları engellemede harika bir iş çıkarır, ancak aynı zamanda web sitemizin faydalı özelliklerini de engeller. En iyi site deneyimi için lütfen AdBlocker'ınızı devre dışı bırakın.

AdBlock'u Devre Dışı Bıraktım.