الموقع العربي الاول للعبة Silkroad Online - انا دلوقتى عدلت فى Database وعاوز اعملها save منين

اقتباس:

المشاركة الأصلية كتبت بواسطة SkyWaY (المشاركة 4438699)

انا دلوقتى عدلت فى Database وعاوز اعملها save على جهازى مش save على SQL
تدوس File وبعدين تختار Save As

وطلب ثانى انا لو عاوز افضى منها كل الاكونتات وكدا لازم اعود اعمل Delete لكل عمود من SQL

أنا مش فهمك قوي هنا عايز تعمل delete لل Charcters ولا Accounts
المهم عشان تعمل delete لل Accounts أهو

كود:

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]

أما el-Charcters بقى أهو

كود:

USE [SRO_VT_SHARD]

GO

truncate table _CharSkill

truncate table _CharSkillMastery

truncate table _GuildMember

truncate table _BlockedWhisperers

truncate table _Inventory

truncate table _InventoryForAvatar

truncate table _InventoryForLinkedStorage

truncate table _TrainingCampMember

truncate table _TrainingCampSubMentorHonorPoint

truncate table _TrainingCampHonorRank

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 _SiegeFortressStruct

truncate table _SiegeFortressStoneState

truncate table _SiegeFortressRequest

truncate table _SiegeFortressObject

truncate table _SiegeFortressItemForge

truncate table _SiegeFortressBattleRecord

delete from _SiegeFortress

truncate table _OpenMarket