[SHARE] Shaiya Server with Video Guide

database server bug pass login.
For example,
ID. 1234.
PASS 1234.
Server can be accessed by entering anything.

Quote:

---

Originally Posted by smc1985

database server bug pass login.
For example,
ID. 1234.
PASS 1234.
Server can be accessed by entering anything.

---

Just delete all the rows you don't want in the ps_userdata database...
tables Users_Master and Users_Detail.

That will fix your problem

Where can i download MMS 2000??

some one have understand what is wrong here:
Usp_Save_Char_Item_Add_E

checked and rechecked but seems all good

Ill be nice and give you all a little tip, fix your login check procedure :) RIght now you can login any account with any password lol

I just realised that Shaiya is full of quests lol. Just a few tips, u can play with admin account.

/char on/off to switch the invisibility.
/attack on/off to turn switch the mobs attack on you.

To get items
/getitem <Type> <TypeID>
Eg. /getitem 25 19 = Mini Healing Potion
Eg. /getitem 42 1 = Level 40 Horse Mount

Some Examples::
25 <Type> is potion, the second arguments will be the potion <TypeID>
Mini Healing Potion 25 19
Healing Potion 25 20
Great Healing Potion 25 21
Mini Stamina Potion 25 22
Stamina Potion 25 23
Grain Stamina Potion 25 24
Mini MP Potion 25 25
MP Potion 25 26
Great MP Potion 25 27

42<Type> is Mount
Lvl 40 Horse Mount 42 1
Lvl 40 Leopard Mount 42 2
Lvl 40 Basilisk Mount 42 3
Lvl 40 Lion Mount 42 4
Etc Mount goes from 42 1 to 42 24

To summon/create the mobs, use /mmake <Type> <ID>

I will attach untranslated items and mobs list which was distributed in CN language. so feel free to translate and experiment with it.

Help........
Instructions for adding EXP and Drop.

Quote:

---

Originally Posted by Twilight

http://files.filefront.com/SQLtoolsr.../fileinfo.html
Setup:
x86\setup\setupsql.exe

---

Thanks Twilight........:w00t:

Few more tips regarding user creation for those planning to revise a better php / asp script for it. To enable the user to obtain all modes (Hard, Ultimate), just insert into the PS_GameData, UserMaxGrow table.

<RowID> <ServerID> <UserUID> <Country> <MaxGrow> <Del>

• RowID - Auto

• ServerID - 1 (default if you use the server files configuration)

• UserUID - Same reference to the PS_UserData db, User_Master table

• Country - 0/1 (0 - Light, 1 - Dark)

• MaxGrow - 3 (All modes available)

• Del - 0

sod78
Help me...

how to set GM Account?

I set table PS_UserData > Users_Master >
Admin = 1
AdminLevel = 2
Status = 0

why My ID not GM account ?

sorry dobble post :(:

twilight
thank you.

good job script!

Twilight help me again please

i set AdminLevel = 255

but
Account is default user :(:

PSMServer_Mgr.exe -> Login01->Command:

/help - allcommands
//adminopen

Quote:

---

Originally Posted by Twilight

PSMServer_Mgr.exe -> Login01->Command:

/help - allcommands
//adminopen

---

ok work:thumbup:

Why all account login to game has GM !! :O: same

HELP...

Assist [ /help ] in the opening game was not found to increase Item Drop
"Item Drop" adjust where?

Please help. Why my client error client doesn't match. I use client from runup and no update.

wath ever password i type it logs me in
no matter wath password i type correct or wrong

help!!

Quote:

---

Originally Posted by Twilight

mb AdminLevel = 255

Code:

---

/* This Proc for PHP/ASP scripts.
MaxGrow = 3 modes (Easy,Normal,Hard, Ultimate)
Twilight.
*/
CREATE PROCEDURE [dbo].[usp_set_MaxGrow]
@LoginName varchar(50)
AS
declare @UserUID int
SET NOCOUNT ON
SELECT @UserUID=UserUID FROM  PS_UserData.[dbo].[Users_Master] WHERE (UserID = @LoginName)
--print @UserUID
UPDATE UserMaxGrow SET MaxGrow=3 WHERE ServerID=1 AND UserUID=@UserUID

IF(@@ERROR = 0)
BEGIN
    RETURN 1
END
ELSE
BEGIN
    RETURN 1
END
SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---

:):

---

While this does work, it is not the best solution. The best solution is to automatically set it when the user logs in his/her account for the first time. the SP: 'usp_Save_Char_Country_E' is ran only once, when they first select which side they want to join. In there you can define how high you want unlocked, eg: 0,1,2,3. The user must relog to see the effects. If you did not want them to have to relog, a server or client modification would solve that.

Quote:

---

Originally Posted by AgMuN4o

wath ever password i type it logs me in
no matter wath password i type correct or wrong

help!!

---

I already posted in a past post that this was an issue, you just need to modify the login procedure to compare the sent password with the stored password.

Quote:

---

Originally Posted by reflax

I already posted in a past post that this was an issue, you just need to modify the login procedure to compare the sent password with the stored password.

---

help me to fix it please

My session keep stop when all started.............

Quote:

---

Originally Posted by AgMuN4o

help me to fix it please

---

just edit
usp_Try_GameLogin_Taiwan

Quote:

---

Originally Posted by Twilight

just edit
usp_Try_GameLogin_Taiwan

---

i swear people are lazy lol

add this
DECLARE @InPassword2 varchar(32)

change your query to match this
SELECT @UserUID=UserUID, @Status=Status, @InPassword2=Pw, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

somewhere in there add this
IF ( @InPassword <> @InPassword2 )
BEGIN
SET @Status = -1
END

presto... or you can use bits of their code and add md5 passwords instead to make it more secure.

Reflax can help me? My Session keep stop when all is connected.

check the log files, it will say in there the problem.

Quote:

---

Originally Posted by Twilight

i think u problem in ODBC connection string in INI files..
try NO IP ехаmple UserData=(local), PS_UserData, ....
or local ip 127.0.0.1

PS: now my problem GG in my english client lol

---

I have the same problem, i tried 127.0.0.1 but that doesn't work. My session server stop 6s after it started.
Any help ?

i found this its a hex edited game.exe GG was stripped entirely but only works for offical server (still works)
but dont work for connect to private server (dun tried) you can reference it when hex editing your own game.exe for your server

im not sure why i cant get it to work for private but maybe some of you that are having problems with GG
can ghave better luck

Please help "connection server has been disconnect." .I can't login to game.

Reflax the log file said my DB ERROR??

WTF !!! my login and game give me this error after 30 min UP

# /help
error console command write

LoL! People are lazy these days!

Anyhow i am guessing you have your hands full Twilight so i say just .. Hi there m8 :) it's been a while eh?

For know how many player is online
In PS_GameData, table Chars, add field LoginStatus as tinyint (default = 0)
In usp_Read_Chars_Detail2_R, change:
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
usp_Save_Char_LeaveDate_R, change:
UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID

===========
total players online:
SELECT COUNT(LoginStatus) AS PlayersON
FROM dbo.CHARS where LoginStatus = 1

==========
Who's online:
SELECT CharID, CharName,Level, JoinDate, LeaveDate, LoginStatus
FROM CHARS
WHERE (LoginStatus = 1)

you dont need make a group by on that query -------------.--------------

SELECT COUNT(LoginStatus) AS PlayersON
FROM dbo.CHARS where LoginStatus = 1

its the correct query.

Quote:

---

Originally Posted by kaipo

LoL! People are lazy these days!

---

Hi kaipo.

Quote:

---

Originally Posted by limpamesa

For know how many player is online
In PS_GameData, table Chars, add field LoginStatus as tinyint (default = 0)
In usp_Read_Chars_Detail2_R, change:
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
usp_Save_Char_LeaveDate_R, change:
UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID

===========
total players online:
SELECT COUNT(LoginStatus) AS PlayersON
FROM dbo.CHARS where LoginStatus = 1

==========
Who's online:
SELECT CharID, CharName,Level, JoinDate, LeaveDate, LoginStatus
FROM CHARS
WHERE (LoginStatus = 1)

---

Wrong Count:
In Game: Login > Select Char -> Disconnect (No Exit) -> Select Other Char = Wrong Count

i think need add change in other proc on "Disconnect" :D:

Wrong area.

Quote:

---

Originally Posted by limpamesa

For know how many player is online
In PS_GameData, table Chars, add field LoginStatus as tinyint (default = 0)
In usp_Read_Chars_Detail2_R, change:
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
usp_Save_Char_LeaveDate_R, change:
UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID

===========
total players online:
SELECT COUNT(LoginStatus) AS PlayersON
FROM dbo.CHARS where LoginStatus = 1

==========
Who's online:
SELECT CharID, CharName,Level, JoinDate, LeaveDate, LoginStatus
FROM CHARS
WHERE (LoginStatus = 1)

---

this is working perfect good job

Quote:

---

Originally Posted by Twilight

This script very simple... Also has no protection... Use only for tests..
change 1.php
$myServer = "127.0.0.1";
$myUser = "USERDB";
$myPass = "PASSWDDB";

PS: mssql in php.ini must be - enabled

---

Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\reg\1.php on line 16

?????'help me man please your scrypt have error????:grr:

Quote:

---

Originally Posted by HASKOMAN

Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\reg\1.php on line 16

?????'help me man please your scrypt have error????:grr:

---

omg...
in php.ini change

[FONT=arial]; Directory in which the loadable extensions (modules) reside.
extension_dir = "./" <----- (path to)php_mssql.dll


;extension=php_msql.dll
extension=php_mssql.dll
extension=php_mysql.dll
;extension=php_mysqli.dll

save all


restart webserver

Quote:

---

Originally Posted by Twilight

yes.. i think add in : usp_Save_Char_Info_E

UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID
test my script :blush:

Code:

---

<?
$myServer = "127.0.0.1";
$myUser = "UserDB";
$myPass = "PassDB";
$myDB = "PS_GameData";
$conn=mssql_connect($myServer,$myUser,$myPass);
if (!$conn){exit("Connection Failed: " . $conn);}
$selected = mssql_select_db($myDB, $conn) or die("Couldn't open database $myDB");
$resultx0=mssql_query("SELECT COUNT(LoginStatus) AS Expr1 FROM  CHARS WHERE (Family = 0) AND (LoginStatus = 1)") or die;
$resultx1=mssql_query("SELECT COUNT(LoginStatus) AS Expr1 FROM  CHARS WHERE (Family = 1) AND (LoginStatus = 1)") or die;
$resultx2=mssql_query("SELECT COUNT(LoginStatus) AS Expr1 FROM  CHARS WHERE (Family = 2) AND (LoginStatus = 1)") or die;
$resultx3=mssql_query("SELECT COUNT(LoginStatus) AS Expr1 FROM  CHARS WHERE (Family = 3) AND (LoginStatus = 1)") or die;
$resultx4=mssql_query("SELECT COUNT(LoginStatus) AS Expr1 FROM  CHARS WHERE (LoginStatus = 1)") or die;
$row0 = mssql_fetch_array($resultx0);
$row1 = mssql_fetch_array($resultx1);
$row2 = mssql_fetch_array($resultx2);
$row3 = mssql_fetch_array($resultx3);
$row4 = mssql_fetch_array($resultx4);
//text format
//echo "Humans:" . $row0[0];
//echo "<br>Elves:" . $row1[0];
//echo "<br>Vail:" . $row2[0];
//echo "<br>Nordein:" . $row3[0];
//echo "<br>Total:" . $row4[0];

//table format
echo '<body leftmargin=0 topmargin=0><TABLE width=100 height=40 border=0 cellspacing=0 bordercolor=#dfe1db align=center';
echo '<TR><TD colspan=1 height=5 bgcolor=#dfe1db align=center><font size=-2 color=000000 face=Tahoma>Total: ' . $row4[0] . '</font></TD></TR>';
echo '<TR><TD width=100 height=5 bgcolor=#f7f88b><font size=-2 color=000000 face=Tahoma>Humans:' . $row0[0] . '</font></TR></TD>';
echo '<TR><TD width=100height=5 bgcolor=#8beaf8><font size=-2 color=000000 face=Tahoma>Elves:' . $row1[0] . '</font></TR></TD>';
echo '<TR><TD width=100 height=5 bgcolor=#c99cf8><font size=-2 color=000000 face=Tahoma>Vail:' . $row2[0] .  '</font></TR></TD>';
echo '<TR><TD width=100 height=5 bgcolor=#b8e648><font size=-2 color=000000 face=Tahoma>Nordein:' . $row3[0] . '</font></TR></TD>';
echo '</TABLE></body>';
?>

---

:D:

---

This script is complete garbage full errors

echo '<body leftmargin=0 topmargin=0><TABLE width=100 height=40 border=0 cellspacing=0 bordercolor=#dfe1db align=center';
echo '<body leftmargin=0 topmargin=0><table width="100" height="40" border="0" cellspacing="0" bordercolor="#dfe1db" align="center" >';

echo '<TR><TD width=100 height=5 bgcolor=#b8e648><font size=-2 color=000000 face=Tahoma>Nordein:' . $row3[0] . '</font></TR></TD>';
echo '<TR><TD width=100 height=5 bgcolor=#b8e648><font size=-2 color=000000 face=Tahoma>Nordein:' . $row3[0] . '</font></TD></TR>';

Quote:

---

Originally Posted by AgMuN4o

This script is complete garbage full errors

echo '<body leftmargin=0 topmargin=0><TABLE width=100 height=40 border=0 cellspacing=0 bordercolor=#dfe1db align=center';
echo '<body leftmargin=0 topmargin=0><table width="100" height="40" border="0" cellspacing="0" bordercolor="#dfe1db" align="center" >';

echo '<TR><TD width=100 height=5 bgcolor=#b8e648><font size=-2 color=000000 face=Tahoma>Nordein:' . $row3[0] . '</font></TR></TD>';
echo '<TR><TD width=100 height=5 bgcolor=#b8e648><font size=-2 color=000000 face=Tahoma>Nordein:' . $row3[0] . '</font></TD></TR>';

---

I do not write here more that. Has bothered.
To pattern the complete text of the code... The mind does not suffice...

I have always the same error, even with extension_dir = ". /" <----- (path to) php_mssql.dll

so you said?????

Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\reg\1.php on line 16

OMG-------OMG

Hello help me !!!!!!!

Item Drop a problem.
Old revisions before.

RowID MobID ItemOrder Grade DropRate
1 0 1 0 10
2 0 2 0 4
3 0 3 0 1
4 1 1 206 10
***************************************************************************
New edits but not Drop.
(Modify the "DropRate" wait, are the problem.)

RowID MobID ItemOrder Grade DropRate
1 0 1 0 5000
2 0 2 0 2000
3 0 3 0 500
4 1 1 206 5000
**************************************************************************

How yo change levelup point given

Hey guys, i got problem with changing the hex at game.exe .. im changing it but it says on start "Could not connect to login server" .. im wondering a bit whats going on cuz my login uses the same IP as i configured..

Edit: Fixed... ^^ Ive missed up some zeroes at the hex line.. ^^

:)

Quote:

---

Originally Posted by newreg

Hey guys, i got problem with changing the hex at game.exe .. im changing it but it says on start "Could not connect to login server" .. im wondering a bit whats going on cuz my login uses the same IP as i configured..

Edit: Fixed... ^^ Ive missed up some zeroes at the hex line.. ^^

:)

---

Yes


same you

Help Me Please

Hey Guy

i setting server same Tutoriais.
but i can login > select server list > "cannot connect disconncet server error 0"

Please help me.

Quote:

---

Originally Posted by kittipat303

Hey Guy

i setting server same Tutoriais.
but i can login > select server list > "cannot connect disconncet server error 0"

Please help me.

---

Im working over this one currently.
I believe its MSSQL unstable error over the Windows 2003 Server Enterprise but im not really sure. When i find out the cure for this type error i will write you again. :)

Edit:
As for a first release its really good pack.. but the most important feature doesnt work... the disconnect button doesnt dc you as it should be, all mobs are missing, you cant buy, i saw for now 3-4 quests bugged/not working .. and i cant buy weapons or whatever i want from shops.. oh yea and some shops are empty

All quests, shops, the monsters work perfectly.
Who have SAF tools PM me.

Quote:

---

Originally Posted by Twilight

All quests, shops, the monsters work perfectly.
Who have SAF tools PM me.

---

Hmm , why they dont work here then? Ive tried to buy weapons/armors and i only see the icons , cant do anything else.

2009-05-03 16:13:32 PS_SESSION__system log start (Session)
2009-05-03 16:13:35 userlog connect failed
2009-05-03 16:13:35 initserver() failed
2009-05-03 16:13:35 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-03 16:13:35 PS_SESSION__system log end (Session)
2009-05-03 16:13:35 3 1 SService::ServiceCtrlDispatcher(): service shutdown


2009-05-03 18:23:23 PS_USERLOG__system log start (UserLog)
2009-05-03 18:23:39 DB userlog connect error, Server=127.0.0.1 DBName=PS_UserData, User=sa, Pass=987654
2009-05-03 18:23:39 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-03 18:23:39 PS_USERLOG__system log end (UserLog)
2009-05-03 18:23:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown

pass and user is good so where is a mistake? :(:

Quote:

---

Originally Posted by Dubik

2009-05-03 16:13:32 PS_SESSION__system log start (Session)
2009-05-03 16:13:35 userlog connect failed
2009-05-03 16:13:35 initserver() failed
2009-05-03 16:13:35 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-03 16:13:35 PS_SESSION__system log end (Session)
2009-05-03 16:13:35 3 1 SService::ServiceCtrlDispatcher(): service shutdown


2009-05-03 18:23:23 PS_USERLOG__system log start (UserLog)
2009-05-03 18:23:39 DB userlog connect error, Server=127.0.0.1 DBName=PS_UserData, User=sa, Pass=987654
2009-05-03 18:23:39 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-03 18:23:39 PS_USERLOG__system log end (UserLog)
2009-05-03 18:23:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown

pass and user is good so where is a mistake? :(:

---

try open some ports for shaiya:
1433 - SQL (for remote connections like link server used by session)
30800 - ps_login.exe
30810 - ps_game.exe
30900 - ps_session.exe
30901 - ps_userLog.exe, ps_userLog.exe, ps_userLog.exe
30911 - ps_dbAgent.exe
30912 - ps_gameLog.exe
40900 - PSM_Agent.exe

Quote:

---

Originally Posted by Twilight

All quests, shops, the monsters work perfectly.
Who have SAF tools PM me.

---

Hi

called me you already know something about SAF tools
because you can buy anything in the shop, mark the object that exists:thumbdown:http://img135.imageshack.us/img135/7503/adadad.jpg

i know how to add points.... but i neededthis pict : )
my problem is,whenitry to buy an item,that say, the itemdoes not exist....
i checked the data base but i dont understand where is the prob....
someone can help me :) ?

i opened all ports but... nothing i have still same problem :*:

Quote:

---

Originally Posted by HASKOMAN

Hi

called me you already know something about SAF tools
because you can buy anything in the shop, mark the object that exists:thumbdown:

i know how to add points.... but i neededthis pict : )
my problem is,whenitry to buy an item,that say, the itemdoes not exist....
i checked the data base but i dont understand where is the prob....
someone can help me :) ?

---

US client is not completely compatible to a server (display of the status not correctly works, helmets are not displayed, not correct system messages and another). CN the client is compatible to a server but it is necessary to translate all.
That all to correct it is necessary saf unpacker <-> packer
Now I try other client on compatibility.

k so i joined the shaiya devs today! :p
i setup the server using sql2005, ill test clients when i get home...
@ dubik
to fix ur problem, go to PSM_Client\bin\config , dbAgent config, copy the hashed password (the numbers after ur "sa, ") , now go to all the rest of the files in same folder, and delete the other numbers and paste the one u just copied....

the problem is that the svr manager doesn't do his job properly xd, and gl after taht ;d

Quote:

---

Originally Posted by newreg

Im working over this one currently.
I believe its MSSQL unstable error over the Windows 2003 Server Enterprise but im not really sure. When i find out the cure for this type error i will write you again. :)

Edit:
As for a first release its really good pack.. but the most important feature doesnt work... the disconnect button doesnt dc you as it should be, all mobs are missing, you cant buy, i saw for now 3-4 quests bugged/not working .. and i cant buy weapons or whatever i want from shops.. oh yea and some shops are empty

---

kittipat303 i same you

Login successful to play a little, but the other is "cannot connect disconncet server error". - -"
help meeee

back home ^^
ye im gettin the "disconnected from server , ERROR 0" azwel, ill see what it is

Item Store and stats fixed.

Does anyone know why login server cmds wont give any respose, they simply dont get recognized...
they used to give an answer like "cmd version chk off" but now it doesn't recognize it ...
it simply responds "/vchkoff" and im guessing thats why i get the disconnection error.

even "/help" returns "/help" ...

looking at logs, it says i was given teh right output like "cmd version chk off" even tho i saw something else...
but anyways, still dno why i get the disconnect error 0

Quote:

---

Originally Posted by Wanteds

Does anyone know why login server cmds wont give any respose, they simply dont get recognized...
they used to give an answer like "cmd version chk off" but now it doesn't recognize it ...
it simply responds "/vchkoff" and im guessing thats why i get the disconnection error.

even "/help" returns "/help" ...

---

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

and use command Game-> /nprotectoff

still it just responds with "/help" or "/vchkoff" but tehy actualy work ...

i found the error 0 i think , but its kinda weird?

Quote:

---

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not locate entry in sysdatabases for database 'OMG_GameWeb'.
No entry found with that name. Make sure that the name is entered correctly., SQL STATE: 08004, NATIVE ERROR: 911 (0x38F)

2009-05-06 23:35:53 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan '1234','1234', 2687937546272374785,'192.168.2.2', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

---

why is it lookin in a DB called OMG_GameWeb ?


EDIT : anyways, after setting up OMG_GameWeb db, and making a account with the create sp it has, i managed to login and select server, and couldn't connect to game server, next issue ;D

===> Server logs show no errors, so i dont know why after SERVER SELECTION, i get "Cannot connect to game server!!!" error? anyone?

Anybody else notice DC's and rollbacks with 30-100 people on?

Quote:

---

Originally Posted by Twilight

Item Store and stats fixed.

---

How to fix them?
Good job Twilight :thumbup1:

Somebody can only helps in a thing
I to me conf everything sertinho that when I try league the server it I bind and later disconnect as decides this?

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

Quote:

---

Originally Posted by Twilight

http://www.nirsoft.net/utils/cports.html

---

thk you Twilight ^^

EDIT, problem solved

Quote:

---

Originally Posted by Twilight

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

---

Sorry, but I still don't get it. :?:

I've already added a new item B2_HwgLM4801, it's a "Termit Long Mantle", but now I need the right ItemID so when someone buys it, gets the right item.
Where I can find thouse Items ID? On the data.saf file, I only found the ProductCode.

Maybe it's impossible and I should create my own Products and edit the description on data.saf?

Thanks for all your help.

what is that ? :(:
http://img19.imageshack.us/img19/6400/shaiya0000xyj.jpg

ok, today i wake up, to find a very big problem >.>

EVERY account is admin, i set ADMIN = 0, ADMINLEVEL = 0 (i used reg script yes)
and when i go ingame, no matter what, characters are GM...
the same character wasnt GM yesterday, i dont understand anymore

Quote:

---

Originally Posted by Wanteds

ok, today i wake up, to find a very big problem >.>

EVERY account is admin, i set ADMIN = 0, ADMINLEVEL = 0 (i used reg script yes)
and when i go ingame, no matter what, characters are GM...
the same character wasnt GM yesterday, i dont understand anymore

---

type /adminclose in your login server command.
somehow the /adminopen run up by itself :8:

Quote:

---

Originally Posted by LightRitual

type /adminclose in your login server command.
somehow the /adminopen run up by itself :8:

---

the problem is taht when u run /adminclose, u cannot have GMs ingame ...
i used to login as normal player with adminopen on, for two days, now it wont work today O_O
===> obviously i didnt pay enough attention, with adminopen everyone is admin xD, how do u use the GMTool ?

NVM , u just have to code a tool to use the GMTool db's SP's, ill do it when i get teh time ^^

Quote:

---

Originally Posted by Twilight

For Example:Movement Rune

---

Thank you Twilight, that was very helpfull, now I have all the shop items working.

Hi Twilight

im sorry i have the 2 DBs from this site and restored them many times but i dont get any npc
so where are they?????

Quote:

---

For All: For mobs,items,npc's ,store proc need correct restore two db PS_GameDefs.rar and PS_GameData.rar
All ID and other in PS_GameDefs tables.

---

i can make all items and all monsters but no npc, so tell me how u make a gatekeeper, or a merchant...

Quote:

---

Originally Posted by Destroyer6666

Hi Twilight

im sorry i have the 2 DBs from this site and restored them many times but i dont get any npc
so where are they?????



i can make all items and all monsters but no npc, so tell me how u make a gatekeeper, or a merchant...

---

All errors in :
PSM_Client\Bin\Log

EDIT :

I found out how to make NPCs now, but i cant find them in the databases.....so where are they???

/nmake <Type> <ID>

e.g. /nmake 9 1 will make a cow

Types so far i found out:

1 Merchants
2 GateKeeper
3 Blacksmith
4 WarriorManager
5 GamblingHouse
6 Warehouse Keeper
7 other NPCs
8 Guards
9 Animals
10 App. Task Master
11 GuildMaster
12 Battle Instructor

Check up logs.. example in PS_Game_system.log_XXX
and full files and folders in PSM_Client\Bin\Data

I to not understand the Chinese language. If you understand this language that download the this tool....
http://wangyou.pcgames.com.cn/zhuant...2/1343666.html

Increase drop rate permanently.

Code:

---

use PS_GameDefs;
update MobItems SET DropRate = (DropRate * 2);

---

Multiplier above is times 2.

Hi guys,
I am trying to start the server, but I get the following error in the "PSM_Client\Bin\Log\PS_DBAGENT__system.log__*" files:

Code:

---

2009-05-11 21:54:35 PS_DBAGENT__system log start (DBAgent01)

2009-05-11 21:54:35 DB gamedata connect error

2009-05-11 21:54:35 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2009-05-11 21:54:35 DBKillCountSave db alloc failed

2009-05-11 21:54:35 SAVE kill count ERROR

2009-05-11 21:54:35 CKeepObeliskMgr::DBSave db alloc failed

2009-05-11 21:54:35 SAVE g_KeepObeliskMgr ERROR

2009-05-11 21:54:35 GuildMgrSave::DBSave db alloc failed

2009-05-11 21:54:35 SAVE g_GuildMgrSave ERROR

2009-05-11 21:54:35 PS_DBAGENT__system log end (DBAgent01)


2009-05-11 21:54:35 3 1 SService::ServiceCtrlDispatcher(): service shutdown

---

PSM_Client\Bin\Config\ps_dbAgent.ini

Code:

---

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=10.3.20.43, PS_GameData, sa, ECC664A5BF515B2B0F173BCE4BB6ADF85105037BC788F79D15447C6CC1E8E54DB4ACBC69A98C02151DC82C260075DA466ABAE7694F434FCF19624949CFD58E77B2F32F1978BE1F061460582DCE6F06721278CEDA3A4809ADE740FA4C1FD3DEF3DE865C24BE7F4569D2C27621BEB71E0E5B7493F30556337CE28F886A8149A724
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

---

Does someone have any ideas how to solve this?

Quote:

---

Originally Posted by dot

Hi guys,

[/code]PSM_Client\Bin\Config\ps_dbAgent.ini

Code:

---

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=10.3.20.43, PS_GameData, sa, ECC664A5BF515B2B0F173BCE4BB6ADF85105037BC788F79D15447C6CC1E8E54DB4ACBC69A98C02151DC82C260075DA466ABAE7694F434FCF19624949CFD58E77B2F32F1978BE1F061460582DCE6F06721278CEDA3A4809ADE740FA4C1FD3DEF3DE865C24BE7F4569D2C27621BEB71E0E5B7493F30556337CE28F886A8149A724

---

Does someone have any ideas how to solve this?

---

Check GameData=10.3.20.43, PS_GameData, sa,
if local server db set 127.0.0.1 or (local) or enable remote connection

Quote:

---

Originally Posted by reflax

Anybody else notice DC's and rollbacks with 30-100 people on?

---

my server DC's and rollback same. :blushing:

Edit money drop from monster ? (Gold)

Anyone know how to parse parameters to services by default?

So parsing to:
ps_login /vchkoff
ps_game /nprotectoff

Everytime instead of manually having to enter it in each time?

I tried:

Code:

---

net start ps_login /vchkoff
-OR-
sc start ps_login /vchkoff

---

But did not work. Anyone know how to do this?

Quote:

---

Originally Posted by anticool

Edit money drop from monster ? (Gold)

---

Database PS_GameDefs, Table Mobs, Need to alter Money1 and Money2 fields.
Just adapt my previous update statement to multiply the Money1 and Money2 fields instead.
Don't ask for exact syntax, google SQL UPDATE statements in order to LEARN what your actually doing.

edit:
In-game GM Commands. Some show what type arguments are required after command (%d = integer, %s = string etc).
http://img12.imageshack.us/img12/566...gmcommands.jpg

TOP players

Code:

---

<?php
    $sql_server = "127.0.0.1";
    $sql_user = "sa";
    $sql_pass = "123456";
    $sql_data = "PS_GameData";
        $conn=mssql_connect($sql_server,$sql_user,$sql_pass);
        $xadb = mssql_select_db($sql_data,$conn) or die("$uwebmsg_cerr");

        $toplvlq = "SELECT * FROM CHARS ORDER BY Level DESC";
        $toplvlr = mssql_query($toplvlq);
        $toplvl_num = 0;
        echo "<p><b>TOP PLAYERS<b></p><p>";
        echo "<Table width=100% border=1><TR><TD><B>RANK NUMBER</B></td><TD><B>PLAYER NAME</B></td><TD><B>PLAYER LEVEL</B></td></tr>";
        while ($toplvlrow = mssql_fetch_array($toplvlr))
        {
                $toplvl_num++;
                echo "<TR><TD>$toplvl_num</td><TD>".$toplvlrow[CharName]."</td><TD>".$toplvlrow[Level]."</td>";
                if ($toplvl_num >= 100) break;
        }
        echo "</table></p>";
?>

---

Whos online

Code:

---

<?php
    $sql_server = "127.0.0.1";
    $sql_user = "sa";
    $sql_pass = "123456";
    $sql_data = "PS_GameData";
        $conn=mssql_connect($sql_server,$sql_user,$sql_pass);
        $xadb = mssql_select_db($sql_data,$conn) or die("$uwebmsg_cerr");

        $toplvlq = "SELECT * FROM CHARS WHERE (LoginStatus = 1) ORDER BY Level DESC";
        $toplvlr = mssql_query($toplvlq);
        $toplvl_num = 0;
        echo "<p><b>TOP PLAYERS<b></p><p>";
        echo "<Table width=100% border=1><TR><TD><B>RANK NUMBER</B></td><TD><B>PLAYER NAME</B></td><TD><B>PLAYER LEVEL</B></td></tr>";
        while ($toplvlrow = mssql_fetch_array($toplvlr))
        {
                $toplvl_num++;
                echo "<TR><TD>$toplvl_num</td><TD>".$toplvlrow[CharName]."</td><TD>".$toplvlrow[Level]."</td>";
                if ($toplvl_num >= 100) break;
        }
        echo "</table></p>";
?>

---