Shaiya Private Server Video Tutorial

[cata121]

Ok so heres my problem guys i got this error when i try to install sql express 2005 everything goes allright but once i finish the instalation and i wanna oppen the config it shows like that

[philli29]

@adamkoolkid

yes i did that all, first i started install.bat, then the server patch config opened. i clicked "apply windows registry" and exit. then the "restore shaiya database" window in cmd said that windows would restart now. then i got a message that "shutdown" got written wrong or couldnt be found. i restarted computer manually and opened server mgr. but when i clicked "install all service" nothing happened.

did i do anything wrong or do i have to change anything in install.bat ?

help would be nice :)

[R1C3]

I got my server work before..but now i came back to try play it again I have this problem. After I made my toon and try log in i keep get this error(SS). I dont know what i did wrong. I did type in the /vchkoff and /nprotectoff already but still have that error. Not to sure but before, I remember I type in 3 command not just two. If anyone can help..would be great.....ty advance

[rea1]

hey guys,

I'm having trouble creating a new character .. When I enter the character name "This name is in use" error.

Logs;PS_DBAGENT__system.log

2011-02-01 15:13:54 PS_DBAGENT__system log start (DBAgent01)

2011-02-01 15:14:14 connect game, Name=



2011-02-01 15:14:14 1 1 SAgent::Disconnect: (4, 64)

2011-02-01 15:14:14 1 1 T=000:00:00:000, RC=2,RCS=0, RB=41,RBS=0, SC=2,SCS=0, SB=2060,SBS=0

2011-02-01 15:14:14 disconnect game, Name=Game254



2011-02-01 15:14:15 connect game, Name=



2011-02-01 15:14:15 connect game, Name=



2011-02-01 15:15:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:30 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:30 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:32 VerifyReConnect : The Connection has been lost, SQLHDBC=6b2db0

2011-02-01 15:15:32 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:33 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:33 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:35 VerifyReConnect : The Connection has been lost, SQLHDBC=6c4208

2011-02-01 15:15:37 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:37 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:37 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:42 VerifyReConnect : The Connection has been lost, SQLHDBC=6c4208

2011-02-01 15:15:42 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:42 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:42 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:45 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:15:45 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:45 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:45 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:47 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:15:47 SDatabasePool::Reconnect:: success...

2011-02-01 15:15:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:15:47 ::CreateCharacter 0 sdkjalkdja retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'sdkjalkdja', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:15:47 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:15:55 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:15:55 SDatabasePool::Reconnect:: success...

2011-02-01 15:16:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB., SQL STATE: HY000, NATIVE ERROR: 9100 (0x238C)

2011-02-01 15:16:15 ::CreateCharacter 0 ceemcmeedsa retVal=-1, qerr=-1, {?=call Usp_Create_Char_R(1,'vodkasexual',1,'ceemcmeedsa', 2,0,3,0,0,2,5,0, 1,0,0, 8,9,10,12,12,14, 3261,4501,452, 1,0, 0,0, 577.979980,78.559998,1762.119995, 0,200,0,0,0)}

2011-02-01 15:16:15 err=-1, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2011-02-01 15:16:18 VerifyReConnect : The Connection has been lost, SQLHDBC=6b3590

2011-02-01 15:16:18 SDatabasePool::Reconnect:: success...

2011-02-01 15:16:31 3 1 SERVICE_CONTROL_STOP

2011-02-01 15:16:42 1 1 SAgent::Disconnect: (4, 64)

2011-02-01 15:16:42 1 1 T=000:02:00:000, RC=47,RCS=0, RB=2720,RBS=18, SC=81,SCS=0, SB=28479,SBS=193

2011-02-01 15:16:42 disconnect game, Name=Game01



2011-02-01 15:16:42 1 1 SAgent::Disconnect: (4, 64)

2011-02-01 15:16:42 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=29,SCS=0, SB=47363,SBS=322

2011-02-01 15:16:42 disconnect game, Name=Game01



2011-02-01 15:16:42 save market... wait plz...



2011-02-01 15:16:42 save all... wait plz... enter /uc



2011-02-01 15:16:43 PS_DBAGENT__system log end (DBAgent01)


2011-02-01 15:16:43 3 1 SService::ServiceCtrlDispatcher(): service shutdown

error seems.

How do I resolve this problem. Waiting for your help.

Thanks

[jakoo]

hi ppl.
im a newb. only 3 days tried to make a server.
i have some probs. how to fix? when i use name change scroll and try change char name says "name already in use"
thank you

[maixyne]

hey can anyone help me to upgrade or make a shaiya on ep5 (with lvl 70 weps and new armor... if you could..) thanx <3

[Backmaan95]

Ive got a problem when i shall enter the IP in HxD. What i se in ur video is 72.55. and it doesnt work. Do you know the ip on the latest EP? ty...

[theowner121]

can you get SP3 on windows 7 and is that causing my green arrows not to stay there

[[GM]Recover]

This needs to be moved to the Devolment section and be stickied

Thanks ShaiyaToplist

[Bаne]

thread moved to the dev section

[DEvolver]

Originally Posted by arutema

Hi all i'm new here and not the kind of guy who talks in forums... Anyway i see alot of post asking about the server not working or why i have red cross etc. So i make this Video tutorial to help all ppl here and make life easy for everyone.

First here u will see step by step how to Install and configure SQL and SSMSEE



Theres a better tutorial here

Here it will show how to setup the server and shows how to fix the "name in use" too

Part 1

Part 2

Now here is the code to fix the "Name in use"



Here you all can find how to Configure the server and download SHAIYA_LITE_SERVER

And here how to setup Shaiya with EP4


From here you can download the EP4 NO-GG game.exe (just need to change ip for 127.0.0.1)


Hope this can help ALOT of ppl here and i will just say i'm just a noob so don't ask things because i'm sure i will not be able of answer...


I want to say thx to ProfNerwosol and ZeroSignal for their guides it helped me alot.
And thx to KaliKid for his Video and guide about SQL and SSMSEE.

COMMENTS: I'm using windows UE because of that i had to start the process manually but i had done that on windows xp Profesional and it worked without doing that

PS: a friend of mine gave me the code so idk to who belongs but anyway i will give thx because of that person now i can fix that problem.
And sorry for my english is not my main language

sorry for this newb post but where/how do i inject the code you supplied above? ><

[DotG]

delete this post pls, got it working <.<

[badgones]

hello all ! i have the name already use error ! in the tuto video the guys got a files dbo.usp_Save_Char_Item_Add_E ! where he got it ? i don't found this file pls help me for that ...

[JohnHeatz]

That is one of the procedures that are built-in on the shaiya database, just look for all the procedures and you will find it out; yet, to solve your problem (as it has been said over and over again) you need to run a query which has been posted several times, you might want to check full threads before asking for it though

[Baby_Doll]

hey guys i have a little problem in all that vids i see green X but when i start my one i have always red X and i cant install to get the X to > . could ay1 help me with that?