[ADMIN]Roy Admin
Posts : 93 WDM-Points : 266 Join date : 2009-03-24
| Subject: Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2 Tue Jun 15, 2010 4:03 pm | |
| First Restore and rename your databases Old Database( ep4 - ep5) Rangame2 RanUser2 New Episode 6 Database Rangame1 RanGame1 Now we have to modify something on our New Ep6 database so that the data on the columns to be copied on our old database will be accepted by the new database. Right click on ChaInfo Design and look for the ChaNum Column then look for Identify Specification Set it to NO then save table (refres with the screenshot) after that heres the script that we will use to copy the datas on the columns =) now take note to copy all the important columns , just delete or add if the columns does or does not exist on your table =) then execute this query - Spoiler:
Quote: use rangame1
insert into chainfo (chanum, SGNum, UserNum, GuNum, GuPosition, ChaName, ChaGuName, ChaTribe, ChaClass, ChaSchool, ChaHair, ChaFace, ChaLiving, ChaLevel, ChaMoney, ChaPower, ChaStrong, ChaStrength, ChaSpirit, ChaDex, ChaIntel, ChaStRemain, ChaExp, ChaViewRange, ChaHP, ChaMP, ChaStartMap, ChaStartGate, ChaPosX, ChaPosY, ChaPosZ, ChaSaveMap, ChaSavePosX, ChaSavePosY, ChaSavePosZ, ChaReturnMap, ChaReturnPosX, ChaReturnPosY, ChaReturnPosZ, ChaBright, ChaAttackP, ChaDefenseP, ChaFightA, ChaShootA, ChaSP, ChaPK, ChaSkillPoint, ChaInvenLine, ChaDeleted, ChaOnline, ChaCreateDate, ChaDeletedDate, ChaStorage2, ChaStorage3, ChaStorage4, ChaGuSecede, ChaQuest, ChaSkills, ChaSkillSlot, ChaActionSlot, ChaPutOnItems, ChaInven, ChaSex, ChaReborn, ChaHairColor
)
select
ChaNum, SGNum, UserNum, GuNum, GuPosition, ChaName, ChaGuName, ChaTribe, ChaClass, ChaSchool, ChaHair, ChaFace, ChaLiving, ChaLevel, ChaMoney, ChaPower, ChaStrong, ChaStrength, ChaSpirit, ChaDex, ChaIntel, ChaStRemain, ChaExp, ChaViewRange, ChaHP, ChaMP, ChaStartMap, ChaStartGate, ChaPosX, ChaPosY, ChaPosZ, ChaSaveMap, ChaSavePosX, ChaSavePosY, ChaSavePosZ, ChaReturnMap, ChaReturnPosX, ChaReturnPosY, ChaReturnPosZ, ChaBright, ChaAttackP, ChaDefenseP, ChaFightA, ChaShootA, ChaSP, ChaPK, ChaSkillPoint, ChaInvenLine, ChaDeleted, ChaOnline, ChaCreateDate, ChaDeletedDate, ChaStorage2, ChaStorage3, ChaStorage4, ChaGuSecede, ChaQuest, ChaSkills, ChaSkillSlot, ChaActionSlot, ChaPutOnItems, ChaInven, ChaSex, ChaReborn, ChaHairColor
from rangame2.dbo.chainfo
after the copying of datas is done we have to remodify the ChaNum again to set it to its default option Right click on ChaInfo Design and look for the ChaNum Column then look for Identify Specification Set it to YES then save table there you go.. =) it will be just the same with the ranuser, just modify the script with the columns you want to copy =) i forgot to truncate the ep6 database, just execute this query first =) - Spoiler:
Quote: use rangame1 truncate table "chafriend" truncate table "chafriendbackup" truncate table "chainfo" truncate table "chanameinfo" truncate table "gdcn_filterword" truncate table "gdcn_tgy_active_user" truncate table "guildAlliance" truncate table "guildinfo" truncate table "guildregion" truncate table "itemcustomize" truncate table "logpartymatch" truncate table "petinfo" truncate table "petinven" truncate table "petstyleflag" truncate table "pettypeflag" truncate table "userinven" truncate table "vehicleInfo"
use ranlog
truncate table "hackprogramlist" truncate table "itemlist" truncate table "logaction" truncate table "logexchangeflag" truncate table "loghackprogram" truncate table "logitemexchange" truncate table "logitemmax" truncate table "logitemrandom" truncate table "logmaketype" truncate table "logpetaction" truncate table "logpetactionflag" truncate table "logserverstate" truncate table "logshoppurchase" truncate table "logvehicleaction" truncate table "logvehicleactionflag" truncate table "shopitemmap" truncate table "shoppurchase" truncate table "shoppurflag" truncate table "skilllist"
use ranshop
truncate table "award" truncate table "awarduserlist" truncate table "dtproperties" truncate table "itemlisttemp" truncate table "logshoppurchase" truncate table "masteradm" truncate table "shopitemmap" truncate table "shopitemtype" truncate table "shoppurchase" truncate table "shoppurflag"
use ranuser
truncate table "accountinfo" truncate table "addattlog" truncate table "blockaddress" truncate table "checkid" truncate table "daumloggametime" truncate table "daumloglogin" truncate table "daumuserinfo" truncate table "fulluserinfo" truncate table "htlog" truncate table "ipinfo" truncate table "lockzblog" truncate table "logaction" truncate table "loggametime" truncate table "loggmcmd" truncate table "loglogin" truncate table "logserverstate" truncate table "lvlist" truncate table "manage" truncate table "newcheckid" truncate table "newtype" truncate table "shopgoumaiinfo" truncate table "shophjf" truncate table "statgametime" truncate table "statlogin" truncate table "user_tjj" truncate table "userinfo" truncate table "userpoint" truncate table "userpointlog" truncate table "web" truncate table "web_admin" truncate table "web_download" truncate table "web_links" truncate table "web_mail" truncate table "web_mail_store" truncate table "web_news" truncate table "web_servers" truncate table "web_siteck" truncate table "web_siteckbak" truncate table "xf_tjlog" truncate table "xy_sendzblog" truncate table "xy_sskilllog" truncate table "xy_zbdhlog" truncate table "zbsjlog"
|
|