Re: [SHARE] Shaiya Server with Video Guide
Re: [SHARE] Shaiya Server with Video Guide
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
Re: [SHARE] Shaiya Server with Video Guide
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:
Re: [SHARE] Shaiya Server with Video Guide
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
Re: [SHARE] Shaiya Server with Video Guide
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>';
Re: [SHARE] Shaiya Server with Video Guide
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...
Re: [SHARE] Shaiya Server with Video Guide
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
Re: [SHARE] Shaiya Server with Video Guide
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
**************************************************************************
Re: [SHARE] Shaiya Server with Video Guide
How yo change levelup point given
Re: [SHARE] Shaiya Server with Video Guide
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.. ^^
:)
Re: [SHARE] Shaiya Server with Video Guide
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
Re: [SHARE] Shaiya Server with Video Guide
Hey Guy
i setting server same Tutoriais.
but i can login > select server list > "cannot connect disconncet server error 0"
Please help me.
Re: [SHARE] Shaiya Server with Video Guide
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
Re: [SHARE] Shaiya Server with Video Guide
All quests, shops, the monsters work perfectly.
Who have SAF tools PM me.
Re: [SHARE] Shaiya Server with Video Guide
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.
