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

[jonluis]

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 ^_^

 

[LabTech]

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

wew...tnx...sir jonluis...ran section is alive...hehehe...hope so...

 

[SeiferXIII]

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

idol haha nice share again

 

[sasayking]

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

nc share weeeeeeee. mabuhay ragezone... thanx a lot.

 

[alamo2007]

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

nice .... tq

 

[killersaskil999]

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

i think this is they same database of zentrix??

 

[laklakbangi]

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

this is upgrading database..

 

[weg123]

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

This is new database , i think . tsk .tsk

 

[jonluis]

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 =)

 

[alamo2007]

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

is md5 becouse my s2 is md5 hash

 

[killersaskil999]

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

hehehee srry now i know.. ^^ tnx jon.

 

[ramispo]

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 =)

 

[j@zz123]

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

how about sharing full ep6 season 2 database??

 

[jonluis]

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

how about sharing full ep6 season 2 database??

the attachment was the ep6 s2 database =)

 

[Pinoyrealm]

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

 

[Trust]

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

thks sir...

 

[LabTech]

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

 

[Pinoyrealm]

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

You can always use episode 4 RanCP Lolz

 

[LabTech]

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

 

[enzokeen]

Thank You Sir.