Printable View
its preatty easy you will change the hole table to display the online users but the oder will still be the same From MEMB_Stat where Connectstat = 1Quote:
Originally Posted by bushwhack_77
for the error if you had readed before posts you will know why you got the error
How exactly?Quote:
Originally Posted by diablo71
open _mods/online.php and replace the code with this:
Code:<br />
<center><TABLE border=0 cellPadding=2 cellSpacing=2>
<table class=memoss border="0" bordercolor=#333333 width="440" cellpadding="1" cellspacing="1" align="center">
<thead>
<tr>
<td width=17 class=mem align=left> ID</center></td>
<td width=82 class=mem align=left> Character</center></td>
<td class=mem align=left> In Game</center></td>
<td width=32 class=mem align=left> Level</center></td>
<td width=32 class=mem align=left> Reset</center></td>
<td class=mem align=left> Map</center></td>
</tr></center><center>
<?php
$lines = '65';
if(!isset($_GET['pages']))
{
$limit='0';
}
else
{
$page = secure($_GET['pages']);
$pages = $page - 1;
$limit = $lines * $pages;
}
$query = mssql_query("Select TOP $lines memb___id,ServerName,ConnectTM From MEMB_STAT where memb___id not in (Select TOP $limit memb___id from MEMB_STAT where connectstat='1' order by ConnectTM desc) and connectstat='1' order by ConnectTM desc");
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1+$limit;
$query2 = mssql_query("Select GameIDC From AccountCharacter where Id='$row[0]'");
$row2 = mssql_fetch_row($query2);
$query3 = mssql_query("Select Name,Class,clevel,resets,MapNumber From Character where Name='$row2[0]'");
$char = mssql_fetch_row($query3);
if ($char[4] == 0) { $map = 'Lorencia'; }
if ($char[4] == 1) { $map = 'Dungeon'; }
if ($char[4] == 2) { $map = 'Davias'; }
if ($char[4] == 3) { $map = 'Noria'; }
if ($char[4] == 4) { $map = 'Lost tower'; }
if ($char[4] == 5) { $map = 'Excile'; }
if ($char[4] == 6) { $map = 'Arena'; }
if ($char[4] == 7) { $map = 'Atlans'; }
if ($char[4] == 8) { $map = 'Tarkan'; }
if ($char[4] == 9) { $map = 'Devil Square'; }
if ($char[4] == 32) { $map = 'Devil Square'; }
if ($char[4] == 10) { $map = 'Icarus'; }
if ($char[4] == 11) { $map = 'Blood castle 1'; }
if ($char[4] == 12) { $map = 'Blood castle 2'; }
if ($char[4] == 13) { $map = 'Blood castle 3'; }
if ($char[4] == 14) { $map = 'Blood castle 4'; }
if ($char[4] == 15) { $map = 'Blood castle 5'; }
if ($char[4] == 16) { $map = 'Blood castle 6'; }
if ($char[4] == 17) { $map = 'Blood castle 7'; }
if ($char[4] == 18) { $map = 'Chaos castle 1'; }
if ($char[4] == 19) { $map = 'Chaos castle 2'; }
if ($char[4] == 20) { $map = 'Chaos castle 3'; }
if ($char[4] == 21) { $map = 'Chaos castle 4'; }
if ($char[4] == 22) { $map = 'Chaos castle 5'; }
if ($char[4] == 23) { $map = 'Chaos castle 6'; }
if ($char[4] == 24) { $map = 'Kalima 1'; }
if ($char[4] == 25) { $map = 'Kalima 2'; }
if ($char[4] == 26) { $map = 'Kalima 3'; }
if ($char[4] == 27) { $map = 'Kalima 4'; }
if ($char[4] == 28) { $map = 'Kalima 5'; }
if ($char[4] == 29) { $map = 'Kalima 6'; }
if ($char[4] == 36) { $map = 'Kalima 7'; }
if ($char[4] == 30) { $map = 'Valery Of Loren'; }
if ($char[4] == 55) { $map = 'Valery Of Loren'; }
if ($char[4] == 31) { $map = 'Land of Trial'; }
if ($char[4] == 54) { $map = 'Aida'; }
if ($char[4] == 33) { $map = 'Aida 2'; }
if ($char[4] == 34) { $map = 'Cry Wolf'; }
if ($char[4] == 35) { $map = 'Silent Map'; }
if ($char[4] == 37) { $map = 'Kanturu Ruin'; }
if ($char[4] == 38) { $map = 'Kanturu Remain'; }
if ($char[4] == 39) { $map = 'Kanturu Tower'; }
echo"
<center><tr>
<td class=mem align=left><font size=1><b> $rank</center></b></font></td>
<td class=mem align=left><font size=1> $char[0]</center></td>
<td class=mem align=left><font size=1> $row[2]</center></td>
<td class=mem align=left><font size=1><b> $char[2]</center></b></td>
<td class=mem align=left><font size=1><b> [$char[3]]</center></b></td>
<td class=mem align=left><font size=1><b> $map</center></b></td>
</center></tr>
";
}
?>
</table><br />
<?php
if(!isset($_GET['pages'])) { $page = '1'; }
$result1 = 1+$limit;
$result2 = $result1+$lines-1;
$count = mssql_query("Select count(*) From Character");
$resultyeah = mssql_result($count, 0, 0);
$next = $page + 1;
$prev = $page - 1;
if($resultyeah > $result2) { $nextpage = " <a href='?page=online&pages=$next' title='Next Page'>-> </a> "; }
if($page >= "2") { $prevpage = "<a href=?page=online&pages=$prev title='Previous Page'><- </a> "; }
echo"
<table width='500' border='0' align='center' cellpadding='0' cellspacing='0' class='mem'><thead>
<td title='Currently see Page: $page'>$prevpage [$page || <b>$result1-$result2</b>] <span class='text-information'>$nextpage</span></td></thead></table>
";
?>
Sweet.
Tyvm.
diablo, when i click Rankings
no characters displayed?
how do i fix that?
what version you use old version or new ?
did you import the sql code ?
I am using season 5 server files from enc.
what sql code?
and where do i get that code?
i just edit settings at config.php
view first page
oh so i need to run the sql code in query analyzer to MuOnline database?
ok thnx bro^^
i'll post here if there are problems again. thnx for your help
This Web Rocks! but i want have some problem and request. hehehe ^^
http://img517.imageshack.us/img517/3457/eventskm.jpg
code works fine
works good for me but i cant get rankings or download links to work.
Loading php_gd2.dll Failed!
Please Enable php_gd2.dll in your php.ini");} $connect = mssql_connect($host,$user,$password); $db = mssql_select_db($database,$connect); if(!$db) die('
Connection with SQL Server failed!
* i always get that error ( new to this ) also im using wamp
it works for me but seems to make server run weird,players get disconnected when site is up.when i take it down everything is ok.any idea's on whats problem.
can anyone help me with rankings ? when i preess rankings it shows me account ID-s, i want it to show just character names( no Id)s and also to shop Top 100 players of the server
already awnsered about that read the previous postsQuote:
Originally Posted by thendmu
then i how to login webadmin page ? sry my bad englishQuote:
Originally Posted by diablo71
this web dont have admin or gm panels its simple website
Mnogo mersi brat ;) i get it , but i how to fix news page ?
_mods/news.php
diablo, what lines i have to add in config if i want bonus points to be different for different chars, for example for MG 700 for DK 500 for DW 600 for elf 800 and for DL 650 , can you help me with this ?
Good Releases
can i add Crywolf event and Kanturu event information in Event Information where Blood Castle Devil square and chaos castle is shown ?
if you know how yes
i don't know that's why i am asking