Shaiya Private Server - Instructions - English

07/20/2009 22:29 ImortalPain#136
Quote:
Originally Posted by linusji View Post
Some more progress. Now i get the server running (meaning that all progress are green triangles). What I found is that since my SQL database does not have the default name, so is the linked server. I change the property of the linked server to 127.0.0.1/game and ps_game connected fine.

So my next problem is to get the game running. I do find the IP stated in the beginning of this thread, and changed to my IP. When I started game it just crached. I guess there is more i need to do to make this work, so i will keep digging.

BTW this is a good chance for me to get more knowledge about SQL server, it took time though :)
have you do command /vchkoff and /nprotectoff ?

if not do it right click on login1/command/ and type /vchkoff
right click on game/command/nprotectoff
07/20/2009 22:43 walkerboh1#137
im still stuck on the error that i need to register the sql provider
soo yea

EDIT:
Anyone got a clue what i have to do?
this is my game log file

Code:
2009-07-20 16:08:35 PS_GAME__system log start (Game01)
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/sorp1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/croco1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/croco2
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Troll1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Spink1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/GoldenPig
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Sorp3
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/SorpNamed1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/SorpNamed2
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Sorp2
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/CrocoNamed1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/CrocoNamed2
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/CrocoNamed3
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/OrcNamed1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/OrcNamed2
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/OrcNamed3
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/TrollNamed1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Deinos
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Parridalis
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Alcarian
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/ZinAlcaria
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Belizabeth
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/Kirhiross
2009-07-20 16:08:35 Loaded Behavior In Factory : data/ai/CrypticOne
2009-07-20 16:08:36 [B]err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The OLE DB provider " SQLOLEDB" has not been registered., SQL STATE: 42000, NATIVE ERROR: 7403 (0x1CEB)[/B]
2009-07-20 16:08:36 CGameData::LoadItemLimit: err=-1, query=exec usp_Read_ItemCount_ByServer_R
2009-07-20 16:08:36 DB table load error item limit
2009-07-20 16:08:36 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-07-20 16:08:36 Call save all waiting...
2009-07-20 16:08:36 Call save all failed dbagent disconnected(user count = 0)...
2009-07-20 16:08:36 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0
2009-07-20 16:08:36 Save MobID=1963109
2009-07-20 16:08:36 PS_GAME__system log end (Game01)
2009-07-20 16:08:36 3 1 SService::ServiceCtrlDispatcher(): service shutdown
the bolded part is what i need to fix i think
07/20/2009 23:08 linusji#138
I changed "72.55.177.194" in game.exe and ran it with the batch file "game.exe start game IP", I ran vchkoff and nprotectoff, but when game loads it still says "hack found".

Any idea what i missed? Or it's the lastest version of the game does not work?

Can any one who has the lastest game client with a working server pls post game.exe
07/21/2009 00:35 walkerboh1#139
like immortal said, did you do that?

Quote:
have you do command /vchkoff and /nprotectoff ?

if not do it right click on login1/command/ and type /vchkoff
right click on game/command/nprotectoff
07/21/2009 00:46 linusji#140
Now I get it work. You need the lastest No-GG game.exe to get it start. Now my server is up and running! thax for all help and support :) And good luck every one
07/21/2009 00:57 walkerboh1#141
could you possibly help me out a bit? seeing as you got yours running

EDIT:
Ok i got it running but i got a login data load error?
anyone got a fix?

EDIT2:
ok when try to connect from by computer i get login data load error

but from a different computer i can get to the server select screen, then i get "failed to connect to game server"
07/21/2009 07:15 walkerboh1#142
anyone have a list of gm commands, r agezone forum is down it seems
07/21/2009 08:22 ZeroSignal#143
Quote:
Originally Posted by ImortalPain View Post
I know as well all your job, the guide for instal server is pretty nice, but so many time when i read your answer to peaple and i mean not expert peaple I saw not nice answer, for this I have to say this is not forum of expert user only, if you look for it should you open a new one reserved for an expert, when peaple noticed you and twilight are good programmer is normal for them ask to you, good and easy question because you got different parameter , i mean maybe for you is an easy question but for the user is big problem.
Personally I miss only 2 things on server for the rest fortunately my head and my time have made all very good without lots of help, but i noticed in those 2 forum some users are asking same question more than 1 time and none of you answer at them, and this is not because you dont know wich answer doing but is only for keep it for you.
For finish you tell me " So excuse me if u can't take 10 minutes of your time to write a "hello world" program! " ermm I work on comp for around 15 hours every days, offcourse i got a real life too and for certain things i dont have basic knowldge and MAYBE for dont lose 2 days or so I try to ask here.
Another thing, tell me the sense of post command list if 90% of them dont have explained what we need type for make it working and for what they are, post something when is complete please or dont post nothing.
I can give you a BIG feedback for instruction in english for the server, if you want i can update server files with some bug fixed, but it mean you change mind and stop you to answer rude and call nub other ppl ? ummm :pimp:
We r abrupt and straight to the point because we get asked the same questions over and over again even though we have answered them in prior posts. Or you could get an equivalent answer using a search engine, it's what we do. I have no problem sharing my info with those who contribute to the Shaiya Dev Scene, but if ur a leecher I don't waist my time nor should others.

Do you know how much IT experts usually charge minimum for a consultation fee? Usually is at least an advance of a few hundred US dollars for a few hours, then charged hourly after that. All our tools, work, code through blood, sweat and tears we give people for ABSOLUTELY FREE!! If u don't like the way we act then tough, put up with it or go find ur info elsewhere. Allot of us work fucking hard on research & development, and for someone to use most of our work and because he can't get some details on a few commands call us selfish is complete scum.

We had more info on the GM commands on paste it or something but it was removed. You contribute something worthy back and I'll help u, if not quit wasting my time.
07/21/2009 09:07 walkerboh1#144
is it that hard to post the gm commands, i mean i wouldnt be asking if i had saved them when i saw them on r agezone
but whatever, im currently working on my server so i dont know what i can contribute yet because i need to figure out how to do all this stuff


P.S. if you maybe help people get ther servers running, then maybe they will be able to contribute
07/21/2009 09:13 linusji#145
Walkerboh1 you got your server and client running now? I only have a few GM command:

/set "Player" level "levels"
/set "Player" skillpoint "point"
/set "Player" str "str" (also other states)
/giveitem "item nummer"

These can at least get you a 60UM toon with good stuff :)
I'm looking after a full list of items, but still haven't found yet.

PS I noticed that EP4 new stuffs not working, I'm hoping for database update from EP4 (which i guess can take long...)
07/21/2009 12:42 linusji#146
I I got a better list of GM code :)

/alert
/char on
/char off
/attack on
/attack off
/amove
/bmove
/cmove
/itemlv
/xcall
/tacticszone
/fogstart
/fogend
/gmove
/warning
/watch
/cwatch
/cwatch off
/silence off
/silence
/stopon
/stopoff
/quiry
/asummon
/bsummon
/partysummon
/item
/mob
/guildrade
/guildrank
/guildpoint
/gmnotice
/cnotice
/wnotice
/notice
/znotice
/bnotice
/cure
/autocure
/npautocure
/iclear
/eclear
/queston
/questoff
/questadd
/pvpon
/pvpoff
/questrem
/event off
/eventadd
/eventrem
/kick
/bancan
/kick
/ban
/set
/imake
/recallitem
/getitem
/mmake
/mera t
/mera
/nmake
/nera
/akick
/abancan
/aban
/server on
/server off
/shutdown
/chatcolor
/apower
/apowercan
/party
/town
/join
/time
/wire
/point
/basic
/UQGET
/UQCOUNT

I haven't had time to test these so good luck and if you find somwthing interesting please tell me :)
07/22/2009 03:24 walkerboh1#147
hmm, anyone else ran into the problem of the skills messing up after every relog?
07/22/2009 03:46 ZeroSignal#148
Quote:
Originally Posted by walkerboh1 View Post
hmm, anyone else ran into the problem of the skills messing up after every relog?
That's because of Ep4, You need to have an Ep3 Client (Up to Version 51).
07/22/2009 03:53 walkerboh1#149
oh ok thanks, but how can i get that version

(will look for it though)

EDIT:
Ok, well i found it and updated till i got to version 51
then i put the GG bypass on and i had the same problem with the skills
I tried just not updating, and leaving the version at 40
but now i get data has been altered error

so idk
07/22/2009 09:07 linusji#150
I've been testing my server yesterday. When skill get messed up, I just go to cash shop and buy a skill reset stone, that can help for the moment.

I also remember when I tried some old no-gg version of Game.exe, it patched my Game.exe and when I log in to the game the start screen reminds me of EP3 (or even older). I will try if I can find that one and test.

Also another possibility: there are other private servers open for public, I guess that they do not have EP4 database either, so maybe their client works? Worth a try.