Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Share]Ep6 S2 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

Status
Not open for further replies.
Initiate Mage
Joined
Aug 20, 2006
Messages
98
Reaction score
29
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
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 =)

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"


please leave a comment if miss or something is wrong, kinda in a hurry ^_^
 

Attachments

You must be registered for see attachments list
Last edited:
Exploring The World
Joined
Apr 21, 2008
Messages
452
Reaction score
54
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

wew...tnx...sir jonluis...ran section is alive...hehehe...hope so...
 
Initiate Mage
Joined
Aug 18, 2006
Messages
37
Reaction score
4
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

nc share weeeeeeee. mabuhay ragezone... thanx a lot.
 
Junior Spellweaver
Joined
May 30, 2008
Messages
119
Reaction score
23
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

nice .... tq
 
Hell Yeah!
Member
Joined
Apr 14, 2009
Messages
1,248
Reaction score
133
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

this is upgrading database..
 
Experienced Elementalist
Joined
Apr 27, 2009
Messages
293
Reaction score
58
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

This is new database , i think . tsk .tsk
 
Initiate Mage
Joined
Aug 20, 2006
Messages
98
Reaction score
29
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

well originally, i got the database packed with my season 2 files that comes from a friend,. =)

well if some claims that its the same with the ep5, just try to compare it and see if there are some difference =)

i havent explore the ep5 that much =)
 
Junior Spellweaver
Joined
May 30, 2008
Messages
119
Reaction score
23
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

is md5 becouse my s2 is md5 hash
 
be good to beat evils
Member
Joined
Mar 27, 2008
Messages
1,027
Reaction score
292
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

more power brother ^_^
well originally, i got the database packed with my season 2 files that comes from a friend,. =)

well if some claims that its the same with the ep5, just try to compare it and see if there are some difference =)

i havent explore the ep5 that much =)
 
Junior Spellweaver
Joined
Jan 23, 2007
Messages
147
Reaction score
26
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

you can simply add set identity_insert rangame1.dbo.chainfo off or on after use rangame1 :D
 
Exploring The World
Joined
Apr 21, 2008
Messages
452
Reaction score
54
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

hehehe...the database is ok next is the rancp...nyahahaha...who will share it?hope that someone can share it....heheheh...
 
Junior Spellweaver
Joined
Jan 23, 2007
Messages
147
Reaction score
26
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

You can always use episode 4 RanCP Lolz
 
Exploring The World
Joined
Apr 21, 2008
Messages
452
Reaction score
54
Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

You can always use episode 4 RanCP Lolz


hehehe...yeah i can use that but im just asking if there someone can share there ep6 season 2 RanCP...that what i mean...hehehe...just asking...hehehe..
 
Status
Not open for further replies.
Back
Top