120 cap Database Running in Mssql 2005

for users who use the mysql 2005 ^ ^ I've seen many topics asking for someone to upload these databases running on mssql 2005 then be here

@Update

Stored Procedures Add ^^
btw this is original databases posted by Artuuro_lv
have some bugs use u mind for fix! ^.^

@Update v2

Ksro Data.pk2 already extracted Upload By me copy to u server folder
kSro Data.pk2 already extracted

Spoiler:

PW = saynotosopa.ragezone.com

Media.pk2 Upload by me ^^
Multiupload.com - upload your files to multiple file hosting sites!

Spoiler:

PW = saynotosopa.ragezone.com

Fix Erro "S1030" when create a char
Dc when u try to buy itens from item mall

@Update v3

120_Cap_v3@Statiic@.rar

Spoiler:

PW = saynotosopa.ragezone.com

120 skill , weapons , sets ,jupiter area + mobs working! 100%.
Fixed crash when try to teleport to jupiter
Create a char chine
Some pictures

Spoiler:

http://img94.imageshack.us/img94/800...2712083100.jpg
http://img853.imageshack.us/img853/4...2621562094.jpg
http://img846.imageshack.us/img846/7...0215481220.jpg
http://img64.imageshack.us/img64/559...0215510188.jpg
http://img577.imageshack.us/img577/6...0214393419.jpg
http://img440.imageshack.us/img440/6...3021385288.jpg
http://3.bp.blogspot.com/-JHb2N6pt0g...roll-dance.gif

Create by me no others... Based on Database posted by Artuuro_lv
soon new mobs spawn
some charge in item mall
and new teleports add
if u found a bug post here ^.^
and "LIKE" THX :D

Quote:

---

Originally Posted by Statiic

for users who use the mysql 2005 ^ ^ I've seen many topics asking for someone to upload these databases running on mysql 2005 then be here 120_Cap_2005.rar

Spoiler:

PW = saynotosopa.ragezone.com

---

Nice work thank you xD

Quote:

---

Originally Posted by statiic

for users who use the mysql 2005 ^ ^ i've seen many topics asking for someone to upload these databases running on mysql 2005 then be here 120_cap_2005.rar

Spoiler:

pw = saynotosopa.ragezone.com

---

not workinng in shardmanger and rr_gameserver got error

Quote:

---

Originally Posted by shadowfuuk

not workinng in shardmanger and rr_gameserver got error

---

what erro?

because the complete stored procedures are not included ;-)

THAT in attachment
:thumbdown:
:thumbdown:
:thumbdown:

Quote:

---

Originally Posted by xTrunksx

because the complete stored procedures are not included ;-)

---

ya -.- just 1 minute i will add this

Quote:

---

Originally Posted by shadowfuuk

THAT in attachment
:thumbdown:
:thumbdown:
:thumbdown:

---

try now with Stored Procedures add!
120_Cap_2005.rar @ Working!

thx now work :D

Great work, I think I will try it out ;)

for me it says "Failed to create a Character. (S1030)" When I create a char...

http://img7.imagebanana.com/img/qpfr94t6/region.jpg
Hm, I already deactivated some regions. Any fix? :/

Quote:

---

Originally Posted by xTrunksx

Great work, I think I will try it out ;)

for me it says "Failed to create a Character. (S1030)" When I create a char...

http://img7.imagebanana.com/img/qpfr94t6/region.jpg
Hm, I already deactivated some regions. Any fix? :/

---

enabled jangan and const ^^

dose it really works ?

i mean can i modify the npc tables and the server will run ?

Quote:

---

Originally Posted by Statiic

for users who use the mysql 2005 ^ ^ I've seen many topics asking for someone to upload these databases running on mysql 2005 then be here 120_Cap_2005.rar @ Working!

Spoiler:

PW = saynotosopa.ragezone.com

@Update
Stored Procedures Add ^^
btw this is original databases posted by Artuuro_lv
for use jupiter temple u need download lasted ksro client want UPDATE and extract data.pk2 with pk2 tools and replace in u server folder!
have some bugs use u mind for fix! ^.^

---

work 100% all sure?

Quote:

---

Originally Posted by Statiic

ya -.- just 1 minute i will add this



try now with Stored Procedures add!
120_Cap_2005.rar @ Working!

---

not working
:thumbdown:
:thumbdown:
:thumbdown:
:thumbdown:

and if i want to create new char
:thumbdown:
:thumbdown:
:thumbdown:
:thumbdown:

Quote:

---

Originally Posted by Statiic

enabled jangan and const ^^

---

Isnt helping. Still invalid areas.
http://img6.imagebanana.com/img/s6uipjr7/addchar.jpg
this is the char creation error. I already checked the addchar procedure and its ok.

i get dc after 1min idk why and the game server says failed to getting silk data http://www.imagebanana.com/view/0b5k...ervererror.jpg

wtf ??

Can i extract isro for server files ?

the vt_shard is full bug, dont hav dependences in the tables

http://troll-face.ru/static/images/lol_guy_original.jpg

@Update v2

120_Cap_v2.rar @ Working! without erros

Spoiler:

PW = saynotosopa.ragezone.com

Fix Erro "S1030" when creat a char
Dc when u try to buy itens from item mall
120 skill , weapon , set ,jupiter area + mobs working! 100%.
if u found a bug post here ^.^
and "like" :D
Fist post update.

can u share pk files to use

and thx bro ur awesome

Statiic check create guild..i cant create guild
And if some 1 can tell what a table create guilds and allies?

Please help me I have changed Log_DB, did not open D12 :?: :?: :?:

Can I change log_bak. has or Log_DB. Buck, SRO_VT_ACCOUNT. Buck, SRO_VT_SHARD_INIT.bak

can you share Tables Only not Full Data base
cuz i have registerd user and have 600 player at my server
i need Edited table which contain D12
please if you can

my arab ahmed bro my need all 12 d yas gife mai plqyers 6000 yas plez all faq your mather thx so much

Quote:

---

Originally Posted by stemale

Statiic check create guild..i cant create guild
And if some 1 can tell what a table create guilds and allies?

---

no problem ^^ check ur configs
http://img208.imageshack.us/img208/8...2712083100.jpg

Quote:

---

Originally Posted by Nah001

my arab ahmed bro my need all 12 d yas gife mai plqyers 6000 yas plez all faq your mather thx so much

---

that work 4 u now ? :D

Quote:

---

Originally Posted by arabcart

can you share Tables Only not Full Data base
cuz i have registerd user and have 600 player at my server
i need Edited table which contain D12
please if you can

---

u can creat a new database with that and copy the tables :D :thumbup1:

@admin idk why u banned my ip ^^

Can u share how did u fix the dc after buying from item mall system

Quote:

---

Originally Posted by Statiic

u can creat a new database with that and copy the tables :D :thumbup1:

---

first thanks for Help and for your answer
can please tell me which Tables

Quote:

---

Originally Posted by ipad95

i get dc after 1min idk why and the game server says failed to getting silk data Gameservererror.jpg - Bilder und Fotos kostenlos auf ImageBanana hochladen

---

Check ur DBConnect Setting

Quote:

---

Originally Posted by Statiic

no problem ^^ check ur configs
http://img208.imageshack.us/img208/8...2712083100.jpg

---

plzs Can you help me I've switched Data if open, D12 :?: :?: :?:

can please type please which table ??

Quote:

---

Originally Posted by arabcart

can please type please which table ??

---

dbo._RefObjChar
dbo._RefObjCommon
dbo._RefRegion
dbo._RefSkill
dbo._RefSkillMastery
dbo._RefSkillGroup
dbo._RefTeleport
dbo._RefTeleLink
dbo.RefNest
:thumbup:

Quote:

---

Originally Posted by ahmedelgend

plzs Can you help me I've switched Data if open, D12 :?: :?: :?:

---

u problem is?

:/ after download v2 :S i got dc after buy from item mall :( any help

Quote:

---

Originally Posted by MR5

:/ after download v2 :S i got dc after buy from item mall :( any help

---

with my database is impossible ^^

Quote:

---

Originally Posted by Statiic

with my database is impossible ^^

---

i swear by ur database :( u can see by teamviewer if u have time

Quote:

---

Originally Posted by Statiic

dbo._RefObjChar
dbo._RefObjCommon
dbo._RefRegion
dbo._RefSkill
dbo._RefSkillMastery
dbo._RefSkillGroup
dbo._RefTeleport
dbo._RefTeleLink
dbo.RefNest
:thumbup:



u problem is?

---

im changed the files did not open :w00t: :?: :?: :?:

Statiic any answer !!
what is client u used Statiic !

Quote:

---

Originally Posted by MR5

Statiic any answer !!
what is client u used Statiic !

---

Yes what V :?: :?: :thumbup:

can u tell as wich media pk we should use with this database ? or upload textdata or ... ?

Crap DB?

Cannot Teleport into the Jupiter Map:glare:

i use the v2 db

http://img689.imageshack.us/img689/7...0103524116.jpg

:D

Quote:

---

Originally Posted by toni009

http://img689.imageshack.us/img689/7...0103524116.jpg

:D

---

^_^ some noobs can fix everything but they keep it for them selfs xD


.. tnx for make me sad xD :lol:

Hey static! its this the one Arturo released inthis thread?http://forum.ragezone.com/f722/relea...120cap-796354/

but for sql server 2005?

My MachineManager.exe crash when trying to open >.<

Quote:

---

Originally Posted by Frezze1

Crap DB?

Cannot Teleport into the Jupiter Map:glare:

i use the v2 db

---

Same here just DC after use teleport to jupiter :?:

Quote:

---

Originally Posted by Statiic

no problem ^^ check ur configs
http://img208.imageshack.us/img208/8...2712083100.jpg



that work 4 u now ? :D


u can creat a new database with that and copy the tables :D :thumbup1:

@admin idk why u banned my ip ^^

---

hello,
i didn't try it yet but i need just Question
Can i add items in npc with this database ?

Quote:

---

Originally Posted by Juilet

hello,
i didn't try it yet but i need just Question
Can i add items in npc with this database ?

---

NO you can't :)

Quote:

---

Originally Posted by egsro

no you can't :)

---

:o :(

are u sure ?

Quote:

---

Originally Posted by Statiic

dbo._RefObjChar
dbo._RefObjCommon
dbo._RefRegion
dbo._RefSkill
dbo._RefSkillMastery
dbo._RefSkillGroup
dbo._RefTeleport
dbo._RefTeleLink
dbo.RefNest
:thumbup:

---

and in media side which txt files ?
sorry for noon question

hen i use teleport jangan --> Jupiter got Dc and Gs show this

CGObj::EnterWorld Failed!!! at ResolveCellAndHeight() GAMEWORLDID[1,1], Pos(253.000,-204.000,1519.000)

im using ksro data and violent client, any help?

any one answer me
i can add items in npc with this database or not ? :(

fatal CGObj::EnterWorld Failed!!! at MoveTo() GAMEWORLDID[1,1] Pos(261.893,-204.757, 1542.135) Reason(1) Err(0) 2011-11-28 14:57:05 990
fatal CGame::EnterWorld() => CGObj::EnterWorld() Failed!!! nikand [JID:1417, CharID:8226][rid: 0x5bca(x:202, y:91)][worldid : 1, pos: 261.893, -204.757, 1542.135] 2011-11-28 14:57:05 993
fatal Char Login Failed(Invalid Pos): nikand 2011-11-28 14:57:05 997
warnning SR_READY_TO_PLAY, Game::EnterWorld() failed!! [JID: 1417] 2011-11-28 14:57:06 000



on game server :(( and client disconected

im using ksro data and violent client, any help?

can anyone know the solution

Quote:

---

Originally Posted by nikkyandrei

fatal CGObj::EnterWorld Failed!!! at MoveTo() GAMEWORLDID[1,1] Pos(261.893,-204.757, 1542.135) Reason(1) Err(0) 2011-11-28 14:57:05 990
fatal CGame::EnterWorld() => CGObj::EnterWorld() Failed!!! nikand [JID:1417, CharID:8226][rid: 0x5bca(x:202, y:91)][worldid : 1, pos: 261.893, -204.757, 1542.135] 2011-11-28 14:57:05 993
fatal Char Login Failed(Invalid Pos): nikand 2011-11-28 14:57:05 997
warnning SR_READY_TO_PLAY, Game::EnterWorld() failed!! [JID: 1417] 2011-11-28 14:57:06 000



on game server :(( and client disconected

im using ksro data and violent client, any help?

can anyone know the solution

---

Same for me! please someone know how to fix ?

any one tell me
i can add items in npc or not with this database ? :@

Quote:

---

Originally Posted by MR5

Statiic any answer !!
what is client u used Statiic !

---

again :/ what is client u used statiic or any one know :S

Quote:

---

Originally Posted by MR5

again :/ what is client u used statiic or any one know :S

---

u can use any1 client with d12 ^^
i use wing sro client + data , map , particles of ksro and my media.pk2

Quote:

---

dbo._RefObjChar
dbo._RefObjCommon
dbo._RefRegion
dbo._RefSkill
dbo._RefSkillMastery
dbo._RefSkillGroup
dbo._RefTeleport
dbo._RefTeleLink
dbo.RefNest

---

which TXT in media please static ?

Quote:

---

Originally Posted by arabcart

which TXT in media please static ?

---

textdata.rar:thumbup1:

Thanks for the work :D

This Database works only with Ksro files or i can use files from DATA.pk2 from isro ?

Quote:

---

Originally Posted by Statiic

u can use any1 client with d12 ^^
i use wing sro client + data , map , particles of ksro and my media.pk2

---

Ok bro i will download Ksro Full Cilent < So can i ask u for some help :blush: if u can upload ur "media.pk2" and sorry to bother u !!
and i wana ask u about something too :blush:
to start game ksro v1.770 i have to do something in database to active this version :?:

Quote:

---

Originally Posted by KomatozNick

This Database works only with Ksro files or i can use files from DATA.pk2 from isro ?

---

idk not tested

Quote:

---

Originally Posted by MR5

Ok bro i will download Ksro Full Cilent < So can i ask u for some help :blush: if u can upload ur "media.pk2" and sorry to bother u !!
and i wana ask u about something too :blush:
to start game ksro v1.770 i have to do something in database to active this version :?:

---

ok i will upload it for u

Quote:

---

Originally Posted by Statiic

idk not tested



ok i will upload it for u

---

Really Thank u so much Bro :thumbup: you are awesome
what about 2nd Question!!
to start game ksro v1.770 i have to do something in database to active this version

Quote:

---

Originally Posted by MR5

Really Thank u so much Bro :thumbup: you are awesome
what about 2nd Question!!
to start game ksro v1.770 i have to do something in database to active this version

---

start? ksro = korean silkroad u need just extract data.pk2 ^^ why u need start?

Quote:

---

Originally Posted by Statiic

start? ksro = korean silkroad u need just extract data.pk2 ^^ why u need start?

---

Sorry I mean, To start my server On Clinet Ksro with ur Media this will work !! with out error
Or i should to Actavi version clinet on database from SRo_VT_AVVOUNT>> Moudel Version i mean this table
sorry i am not sure the right name of table coz i am @ work and i haven't the SQl here !!
and sorry about my english is very bad :blush:

Can you give me ksro's date ? Not ksro's date.pk2 Thx

Quote:

---

Originally Posted by Kekox

Hey static! its this the one Arturo released inthis thread?http://forum.ragezone.com/f722/relea...120cap-796354/

but for sql server 2005?

My MachineManager.exe crash when trying to open >.<

---

he released for sql 2008 r2

Quote:

---

Originally Posted by MR5

Sorry I mean, To start my server On Clinet Ksro with ur Media this will work !! with out error
Or i should to Actavi version clinet on database from SRo_VT_AVVOUNT>> Moudel Version i mean this table
sorry i am not sure the right name of table coz i am @ work and i haven't the SQl here !!
and sorry about my english is very bad :blush:

---

any answer about it !! Statiic :blush:

Full DATA.pk2 files from Ksro. Multiupload.com - upload your files to multiple file hosting sites!

Pass: sro

Quote:

---

Originally Posted by KomatozNick

Full DATA.pk2 files from Ksro. Multiupload.com - upload your files to multiple file hosting sites!

Pass: sro

---

can i post on fist post? :)

Quote:

---

Originally Posted by MR5

any answer about it !! Statiic :blush:

---

yes u can u need just replace the media :thumbup1:

Quote:

---

Originally Posted by Statiic

can i post on fist post? :)

---

Yeah... ofc :)

Quote:

---

Originally Posted by KomatozNick

Yeah... ofc :)

---

btw already extracted or still need to extract?

Quote:

---

Originally Posted by MR5

Ok bro i will download Ksro Full Cilent < So can i ask u for some help :blush: if u can upload ur "media.pk2" and sorry to bother u !!
and i wana ask u about something too :blush:
to start game ksro v1.770 i have to do something in database to active this version :?:

---

@update fist post

for users who use the mssql 2005 ^ ^ I've seen many topics asking for someone to upload these databases running on mysql 2005 then be here

@Update

Stored Procedures Add ^^
btw this is original databases posted by Artuuro_lv
have some bugs use u mind for fix! ^.^

@Update v2

120_Cap_v2.rar @ Working! without erros

Spoiler:

PW = saynotosopa.ragezone.com

Ksro Data.pk2 Upload By KomatozNick copy to u server folder
Multiupload.com - upload your files to multiple file hosting sites!

Spoiler:

PW = sro

Media.pk2 Upload by me ^^
Multiupload.com - upload your files to multiple file hosting sites!

Spoiler:

PW = saynotosopa.ragezone.com

Fix Erro "S1030" when create a char
Dc when u try to buy itens from item mall
120 skill , weapons , sets ,jupiter area + mobs working! 100%.
if u found a bug post here ^.^
and "like" :D

I've switched Data does not work

http://store2.up-00.com/Nov11/fOo32959.jpg :?: :grr: :grr: :grr:

Quote:

---

Originally Posted by ahmedelgend

I've switched Data does not work

http://store2.up-00.com/Nov11/fOo32959.jpg :?: :grr: :grr: :grr:

---

you have enabled the item in database?

Quote:

---

Originally Posted by terzo

you have enabled the item in database?

---

Yes :?: :?: :?:

I have a problem :grr: everything was work with me be4 to use the database 12d :closedeyes:
The Sr_gameserver crash and close after finsh load :glare: i use the Sr_gameserver here in this thread so any idea to fix this problem plz :sleep:

Quote:

---

Originally Posted by MR5

I have a problem :grr: everything was work with me be4 to use the database 12d :closedeyes:
The Sr_gameserver crash and close after finsh load :glare: i use the Sr_gameserver here in this thread so any idea to fix this problem plz :sleep:

---

when u game server try to load region at 90% right? and crash?

Quote:

---

Originally Posted by Statiic

when u game server try to load region at 90% right? and crash?

---

Yeah xD any fix for this !:rolleyes:

Quote:

---

Originally Posted by ahmedelgend

I've switched Data does not work

http://store2.up-00.com/Nov11/fOo32959.jpg :?: :grr: :grr: :grr:

---

the problem is u database no the data ^^

Quote:

---

Originally Posted by MR5

Yeah xD any fix for this !:rolleyes:

---

ya the region 90% is jupiter temple so u need data of ksro i will upload it by myself today i compressed it now
+- 2h i post here :thumbup1:

Quote:

---

Originally Posted by Statiic

the problem is u database no the data ^^



ya the region 90% is jupiter temple so u need data of ksro i will upload it by myself today i compressed it now
+- 2h i post here :thumbup1:

---

^_^ i have Ksro full cilent and i get data.pk exetra it and i put it in folder file Vsro O.o so what the problem xD :sneaky2:

Quote:

---

Originally Posted by MR5

^_^ i have Ksro full cilent and i get data.pk exetra it and i put it in folder file Vsro O.o so what the problem xD :sneaky2:

---

check u res folder data/ress if have this all
http://img835.imageshack.us/img835/3497/ressx.png
@edit u have team view?
give me u ip and pw

Quote:

---

Originally Posted by Statiic

check u res folder data/ress if have this all
http://img835.imageshack.us/img835/3497/ressx.png
@edit u have team view?
give me u ip and pw

---

i am @ work now bro i make my server on home so when i go to home i iwll pm u
but tell me how much Size this folder:blush:

Quote:

---

Originally Posted by MR5

i am @ work now bro i make my server on home so when i go to home i iwll pm u
but tell me how much Size this folder:blush:

---

9,78 mb

Quote:

---

Originally Posted by Statiic

9,78 mb

---

i have this folder but name is res
and ress and size 9.24 MB

Quote:

---

Originally Posted by MR5

i have this folder but name is res
and ress and size 9.24 MB

---

Res.rar

Statiic i used your database with ksro data and the SR_Gameserver doesnt load all regions and show a msg it say Loading Gameworld set[91] Regions!
there is no assigned region check out _RefRegion Table!!! and the same for regions 87, 88, 89 ,90 , 92 , 94.

Whats wrong please a need a litle help

Thank you.

Quote:

---

Originally Posted by links2007

Statiic i used your database with ksro data and the SR_Gameserver doesnt load all regions and show a msg it say Loading Gameworld set[91] Regions!
there is no assigned region check out _RefRegion Table!!! and the same for regions 87, 88, 89 ,90 , 92 , 94.

Whats wrong please a need a litle help

Thank you.

---

I trying to solve this because the database that Artuuro_lv have also posted this same problem.

http://img408.imageshack.us/img408/4903/errorhi.jpg

Pls how to fix it? I already have ksro data and particles, media the one that you upload statiic the data folder with all ksro things... Pls help me :) I know someone else have the same problem.

Quote:

---

Originally Posted by antho1302

http://img408.imageshack.us/img408/4903/errorhi.jpg

Pls how to fix it? I already have ksro data and particles, media the one that you upload statiic the data folder with all ksro things... Pls help me :) I know someone else have the same problem.

---

Yep same here and i dont know what to do :grr:

Quote:

---

Originally Posted by links2007

Yep same here and i dont know what to do :grr:

---

you get this error when trying to teleport teleport in what? > Jupiter

I get it when i teleport to jupiter... When i use the teleport i appear in the map and you cant move u get DC and gameserver sais that

Quote:

---

Originally Posted by Statiic

you get this error when trying to teleport teleport in what? > Jupiter

---

The error appears after use the teleport... I cant do anything inside jupiter even move after few seconds get dc and thats the error in gameserver

please Statiici have Problem see picture

http://www6.0zz0.com/2011/11/30/14/898927584.jpg

what should i do ?

Quote:

---

Originally Posted by Statiic

you get this error when trying to teleport teleport in what? > Jupiter

---

Jangan -> Jupiter and Consta -> Jupiter

Quote:

---

Originally Posted by SuperHer0

please Statiici have Problem see picture

http://www6.0zz0.com/2011/11/30/14/898927584.jpg

what should i do ?

---

i think u make some shits in u db ^^ restore or try to fix :D

Quote:

---

Originally Posted by links2007

Jangan -> Jupiter and Consta -> Jupiter

---

i will check

[QUOTE=Statiic;6681169]i think u make some shits in u db ^^ restore or try to fix :D

So Statiic :) i restore me db again and same problem and all program work fine see :P

http://www2.0zz0.com/2011/11/30/15/803181904.jpg

[quote=SuperHer0;6681217]

Quote:

---

Originally Posted by Statiic

i think u make some shits in u db ^^ restore or try to fix :D

So Statiic :) i restore me db again and same problem and all program work fine see :P

http://www2.0zz0.com/2011/11/30/15/803181904.jpg

---

u ram?

Statiic can u share your complete Data Folder? maybe there's the problem.

[quote=Statiic;6681218]

Quote:

---

Originally Posted by SuperHer0

u ram?

---

my ram 2Giga cpu core2due E7500 Vga 1giga

and in dg11 Gameserver work fine ? :( please help

[quote=SuperHer0;6681226]

Quote:

---

Originally Posted by Statiic

my ram 2Giga cpu core2due E7500 Vga 1giga

and in dg11 Gameserver work fine ? :( please help

---

its the problem i u have 2gb ^^
what regions u enabled?

Quote:

---

Originally Posted by links2007

Statiic can u share your complete Data Folder? maybe there's the problem.

---

fist pag

[quote=Statiic;6681244]

Quote:

---

Originally Posted by SuperHer0

its the problem i u have 2gb ^^
what regions u enabled?



fist pag

---

all regions open CHINA-TQ-Eu-Thief Village-SD and moreee when i download ur db i retore and i dont change any thing :) ineed see my server 1 in my life :D and say problem not in ram i make server dg11 and work fine so please help if u have 5min please come see with team viewer :)