1. Reklam


    1. joysro
      ledas
      jungler
      keasro
      zeus
      karantina

[VSRO] Database Temizleme [QUERY]


  1. Sir Valek

    Sir Valek Tanınıyorum rank8

    Kayıt:
    23 Haziran 2008
    Mesajlar:
    404
    Beğenilen Mesajlar:
    0
    Ödül Puanları:
    0
    Meslek:
    Ağır işsiz
    Gerekli olan ama silinmiş kodlardı. Bu kodları New Query ile Execute ederseniz tüm database temizlenir.

    Kod:
    USE [SRO_VT_ACCOUNT]
    GO
    TRUNCATE TABLE [dbo].[TB_User]
    TRUNCATE TABLE [dbo].[TB_User_Bak]
    TRUNCATE TABLE [dbo].[SK_CharRenameLog]
    TRUNCATE TABLE [dbo].[_Punishment]
    TRUNCATE TABLE [dbo].[_ServiceManagerLog]
    TRUNCATE TABLE [dbo].[Test_HN]
    TRUNCATE TABLE [dbo].[_BlockedUser]
    TRUNCATE TABLE [dbo].[_CasGMChatLog]
    TRUNCATE TABLE [dbo].[_Notice]
    TRUNCATE TABLE [dbo].[_SMCLog]
    TRUNCATE TABLE [dbo].[QuaySoEpoint]
    TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
    TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
    TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
    TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
    TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
    TRUNCATE TABLE [dbo].[SK_Silk]
    TRUNCATE TABLE [dbo].[SK_SilkBuyList]
    TRUNCATE TABLE [dbo].[SK_SilkGoods]
    TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
    TRUNCATE TABLE [dbo].[SR_ShardCharNames]
    TRUNCATE TABLE [dbo].[TB_Net2e]
    TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
    TRUNCATE TABLE [dbo].[tb_paygate_trans]
    Kod:
    USE [SRO_VT_LOG]
    GO 
    TRUNCATE TABLE [dbo].[_LogCashItem] 
    TRUNCATE TABLE [dbo].[_LogEventChar] 
    TRUNCATE TABLE [dbo].[_LogEventItem] 
    TRUNCATE TABLE [dbo].[_LogEventSiegeFortress] 
    TRUNCATE TABLE [dbo].[_LogSchedule] 
    TRUNCATE TABLE [dbo].[_LogServerEvent]
    Kod:
    USE [SRO_VT_SHARD] 
    GO 
    truncate table _CharSkill 
    truncate table _CharSkillMastery 
    truncate table _GuildMember 
    truncate table _BlockedWhisperers 
    truncate table _OpenMarket 
    truncate table _Inventory 
    truncate table _InventoryForAvatar 
    truncate table _InventoryForLinkedStorage 
    truncate table _TrainingCampMember 
    truncate table _TrainingCampSubMentorHonorPoint 
    truncate table _TrainingCampBuffStatus 
    delete from _TrainingCamp 
    truncate table _StaticAvatar 
    truncate table _User 
    truncate table _Friend 
    truncate table _Memo 
    truncate table _TimedJob 
    truncate table _CharTrijobSafeTrade 
    delete from _CharTrijob 
    truncate table _InvCOS 
    delete from _CharCOS where ID > 0 
    delete from _Char where charid > 0 
    truncate table _Chest 
    truncate table _ChestInfo 
    truncate table _ItemPool 
    delete from _Items where ID64 > 0 
    delete from _AccountJID 
    truncate table _GuildChest 
    update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 
    truncate table _GuildWar 
    delete from _Guild where ID > 0 
    delete from _AlliedClans where ID > 0 
    truncate table _CharNameList 
    truncate table _CharQuest 
    truncate table _ClientConfig 
    truncate table _DeletedChar 
    truncate table _SiegeFortressStoneState 
    truncate table _SiegeFortressRequest 
    truncate table _SiegeFortressObject 
    truncate table _SiegeFortressItemForge 
    truncate table _SiegeFortressBattleRecord 
    delete from _SiegeFortress
     
  2. lemonade

    lemonade   exlmanager rank8

    Kayıt:
    3 Ocak 2009
    Mesajlar:
    11.368
    Beğenilen Mesajlar:
    18
    Ödül Puanları:
    48
    Meslek:
    студент
    Şehir:
    Белгород
    Ellerine sağlık hacım :beer:
    /Sabit.