1. Reklam


    1. joysro
      ledas
      jungler
      keasro
      zeus
      karantina

VSRO Database Temizleme QUERY


  1. AqRa

    AqRa Gözlemliyorum rank8

    Kayıt:
    27 Kasım 2012
    Mesajlar:
    79
    Beğenilen Mesajlar:
    0
    Ödül Puanları:
    6
    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]
    ---------------------------------------------

    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]

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

    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. sweetCHIEF

    sweetCHIEF   globalmod playboy rank8

    Kayıt:
    24 Temmuz 2009
    Mesajlar:
    19.853
    Beğenilen Mesajlar:
    17
    Ödül Puanları:
    38
    Şehir:
    Beykoz
    sagolasin, sunlari arsivliyim ben olmayanlari :D