[SHARE] Shaiya Server with Video Guide

Quote:

---

Originally Posted by Twilight

1. Client http://shaiya.runup.com.my/en/04-download/04-01.php (need change IP(hex)-game.exe)
2. Stats: K1,K2,K3,K4 in CHARS table
3. Item Store: Example
find itemcode in data.saf (HEX) PK_ (this new packages) or B1_ , B2_ for example: PK_primm0001 and others....
Add this items and packages in two tables PS_GameDefs -> ProductList and PS_GameDefs -> Items

------------------
and for correct online users count
edit usp_Read_Chars_Detail2_R add:
.
.
DECLARE @UID varchar (18)
.
.
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
UPDATE CHARS SET LoginStatus = 0 WHERE (CharID<>@CharID) AND (UserID=@UID)

:):

---

Thank you! And can you tell me how to edit table Items in GameDefs. Everytimes i managed to change it. It said that cannot located for updating, some value may have changed while i'm not run up my server :?:

Edit: i added PK_primm0001 into ProductList with a Clean Hit Nostrum ID at ItemID1 and ItemCount1 = 10 but when i went to game. the premium package do not change it's name and when i buy it. it said no item on that spot. I think it should change the name to the name which entered in the ProductList like in your pics ??? any help ?

Srr for my bad eng.

Quote:

---

Originally Posted by Twilight

Stop all servises.Close PSMServer_Mgr.exe
and run again...

and use command Game-> /nprotectoff

---

Thank you ! Thank you!
Game-> /nprotectoff
not "disconnected from server , ERROR 0" ^^ Yheee

can anyone post a .SAF editor cuz using hex editor on a 1.6GB file is kinda annoying...
it would be nice to get all the IDs

EDIT : cant login to my own game anymore, some weird error :

Quote:

---

2009-05-07 17:25:22 err=-1, [Microsoft][ODBC SQL Server Driver]Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2009-05-07 17:25:22 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

---

in game error :

Quote:

---

cannot download force data

---

and my Users_Product table is empty so i dont get it :/

Quote:

---

Originally Posted by Twilight

1. Client http://shaiya.runup.com.my/en/04-download/04-01.php (need change IP(hex)-game.exe)

---

Can you share your game.exe file?

Quote:

---

Originally Posted by Twilight

Change ALL my IP's 10.0.0.88

http://files.filefront.com/RunUp+SG+.../fileinfo.html

---

Thank you :thumbup:

Well i read the last new posts since my last visit so i discovered that maybe all of my problems are because im using US client... right!? Im still at the beginning guys... its a bit heavy over here... :) ive manage to log and etc but i still cant buy anything. (As i said, im using US client) Anybody any solutions?

Do i need too this saf editor?

ok so guys, if u find new bugs can u post them please, ty :D
ill be tryin to fix them, i got everything to work so far (not all shop items cuz i cba look for all the IDs yet xD)

Twilight, what HEX editor are u using for the Data.saf ? , NVM HxD does the work

==> EDIT : Where can u find a item's SPECIAL ID ? and what is it exactly
and Effect IDs, and their effect ? and type ids :p

Excuse me, If I want to open public server ,I must forward port ? protocol ?
Thank you....

Hi all!

My server is running...yay...only prob i have atm is i cant find any NPC related data in the databases.
I was on eXtreme and see they didnt have the Cape Merchs in Iris too like me :((
In Mobs i found the relics and guards but no town guards or other npcs so i assume we all misses them. But i wonder why they are in game then?? so any help in that direction would be nice^^

Thnx

HELLO.. " Twilight"

How to add Points "charactor" in database?

thx

http://img80.imageshack.us/img80/8911/1101u.jpg

Hi smc

u can add points for item store in PS_UserData -> dbo.Users_Master -> Point

its in the table after ModiDate!

but u cant buy anything cause u must fix item store like Twillight described otherwise u get error: No item locatet on that spot^^

http://img23.imageshack.us/img23/7726/storepointsw.jpg

nice work twilight this is going nicely maybe sometime soon we can get a fixed repack of these files :)



@ anticool you only need to port forward if you are behind a router

twilight, i dont mean the ones that are allready tehre, i mean for the new Mall items we are adding like Premium pack...

This makes it allot faster to setup a Private Server.

Shaiya Private Server - Instructions - English

:D

Quote:

---

Originally Posted by Wanteds

twilight, i dont mean the ones that are allready tehre, i mean for the new Mall items we are adding like Premium pack...

---

New ID items in data.saf
Search new ID only use HEX editor now bcoz need saf packer-unpacker.

For Web Item Mall need use PS_GMTOOL store proc's