Database , need help guys please !

Game characters seamlessly,
are not deleted how to move to another Database?

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


That is query to delete char's from ur db or if u need to move it to another db u will need to move

1- FROM SRO_VT_ACCOUNT

GET TB_USER

2- FROM SRO_VT_SHARD

GET _CHAR , _USER

But you wont have any item or anything just chars with level etc if you want to get items get the tables at up

Quote:

Originally Posted by [GM]Tensa 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 That is query to delete char's from ur db or if u need to move it to another db u will need to move 1- FROM SRO_VT_ACCOUNT GET TB_USER 2- FROM SRO_VT_SHARD GET _CHAR , _USER But you wont have any item or anything just chars with level etc if you want to get items get the tables at up

So, can I carry a seamless manner? I know you all had a single doubt about the characters, I wonder if he moved. Thank you is I hope.

if you want to copy the char's to another db just copy this tables with char id you want

table _CharSkill
table _CharSkillMastery
table _GuildMember
table _BlockedWhisperers
table _Inventory
table _InventoryForAvatar
table _InventoryForLinkedStorage
table _TrainingCampMember
table _TrainingCampSubMentorHonorPoint
table _TrainingCampHonorRank
table _TrainingCampBuffStatus
table _TrainingCamp
table _StaticAvatar
table _User
table _Friend
table _Memo
table _TimedJob
table _CharTrijobSafeTrade
table _CharTrijob
table _InvCOS
table _CharCOS
table _Char
table _Chest
table _ChestInfo
table _ItemPool
table _Items
table _AccountJID
table _GuildChest
table _CharNameList
table _CharQuest
table _SiegeFortressStruct
table _SiegeFortressStoneState
table _SiegeFortressRequest
table _SiegeFortressObject
table _SiegeFortressItemForge
table _SiegeFortressBattleRecord
table _SiegeFortress