Shaiya Server Mod Help

[trimlink]

WOOOT! Thirty hours straight of wanting to murder my private server and finally my efforts paid off Had soo many issues with db replacement refusals and file not found bsht. Had to rescript the entire restore batch file and it turns out one DOES NOT need a virtual D: drive to run the server

Anyway, as I said I have been up for thirty hours working on this project and am a little tired. Thus I am sure I have missed a thread here or there during my google and forums searches so I am asking for help on finding the following info:

I am using the PSM Server of Shaiya (think thats the most used >.> anyway)

I would like to know or be pointed in the right direction on how to:

Add items to NPCs I dont see them in DBs but then again this isn't a WoW PS
Change drop rates/amounts and increase exp rates
And if anyone has a link to an item ID list for Shaiya it would save me alot of "table surfing" lol
And adding AP to user accounts - is there any tool for this if not what is manual way or SQL Query?

Thank you.

[charmingwolf1979]

Originally Posted by trimlink

WOOOT!

Add items to NPCs I dont see them in DBs but then again this isn't a WoW PS
Change drop rates/amounts and increase exp rates
And if anyone has a link to an item ID list for Shaiya it would save me alot of "table surfing" lol
And adding AP to user accounts - is there any tool for this if not what is manual way or SQL Query?

Thank you.

I'll only answer what I know...
Alright... there is a [tut] for adding items to NPCs..

exp rates... in your server patch config... when you right click game > commands... just like you're going to put in the /nprotectoff ... you can do
/exp2xenable (multiplier) so for 10x exp it would be /exp2xenable 10

there was just an Item ID post... so I won't dup it...
adding AP to user accounts... I assume you have MSQL... so use the MSQL server manager... and go to the PS_UserData database.... dbo.Users_Master table... the field you're looking for is the Point field... that's the AP amount... btw this table is also where you add new users...

Hope this helps

[trimlink]

Originally Posted by charmingwolf1979

I'll only answer what I know...
Alright... there is a [tut] for adding items to NPCs..

exp rates... in your server patch config... when you right click game > commands... just like you're going to put in the /nprotectoff ... you can do
/exp2xenable (multiplier) so for 10x exp it would be /exp2xenable 10

there was just an Item ID post... so I won't dup it...
adding AP to user accounts... I assume you have MSQL... so use the MSQL server manager... and go to the PS_UserData database.... dbo.Users_Master table... the field you're looking for is the Point field... that's the AP amount... btw this table is also where you add new users...

Hope this helps

Hey thanks alot for the info much appreciated also I was the one that posted the Item ID list lol I figured it out and said "Lets share it!" haha

[charmingwolf1979]

no problem

[speccie]

trimlink pls add my msn:/..... then i will can help u. Thy

[ProfNerwosol]

Originally Posted by trimlink

WOOOT! Thirty hours straight of wanting to murder my private server and finally my efforts paid off Had soo many issues with db replacement refusals and file not found bsht. Had to rescript the entire restore batch file and it turns out one DOES NOT need a virtual D: drive to run the server

Anyway, as I said I have been up for thirty hours working on this project and am a little tired. Thus I am sure I have missed a thread here or there during my google and forums searches so I am asking for help on finding the following info:

I am using the PSM Server of Shaiya (think thats the most used >.> anyway)

I would like to know or be pointed in the right direction on how to:

Add items to NPCs I dont see them in DBs but then again this isn't a WoW PS
Change drop rates/amounts and increase exp rates
And if anyone has a link to an item ID list for Shaiya it would save me alot of "table surfing" lol
And adding AP to user accounts - is there any tool for this if not what is manual way or SQL Query?

Thank you.

1) To change items sold by merchant you need Hex editor. Then edit NPCQuest.SData ... (I think that's the one) ... find name of the merchant you want and change values. The ones you need is Type and TypeID.

2) To change drop rate, edit PS_GameDefs.dbo.MobsItems ... what drops is controled by Grade ... and on the right you have % chance of drop.

3) There's a topic here about extracting data from data.saf with attached program to do so. It has builtin 'viewer' of *.SData files. It's quite handy, however in chinese, yet easy to understand.

[baldracca]

mmm i cant add AP. Added points on table, restarted all but in game i have always 0 AP.

Added on PS_userdata --> dbo.Users_Master --> Point (Int, Null) ... is this the right place?

Then another noob question: i read to put online the server i need only to change ip on Public IP on server... well.. i done but wont works... what am i doinig wrong? im only a poor noob or is there another reason?

ty

[ravyneubanks]

Just a quick question--one of my friends is starting a private server of his own and knows he has to change the Public IP to get the server to go public, but is questioning on what to change it to...his own IP or something else? We're both a little confused on this. Thank you. When he tries to use his own IP, the server gives him "Checking notice board" as if it was server maint.