MFS Team Web 0.5 Free

[diablo71]

if you got the error means it cannot connect to db

[bushwhack_77]

Diablo, I suggest you display character name instead of username in "online accounts".

Also, better if there's a log-in screen first so users dont have to input their login details over and over again. tyvm.

[diablo71]

the web is maded without login, making it more easy and faster

[bushwhack_77]

how about displaying the online character name instead of the account name?

Can you make necessary edits? I believe this will only take a few lines.

[realhunter]

someone help me...

i got this error

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\_inc\phpcheck.php on line 12

---------- Post added at 02:31 PM ---------- Previous post was at 02:16 PM ----------

..i already used 1.7.1 xampp still disame.. problem..

[diablo71]

how about displaying the online character name instead of the account name?

Can you make necessary edits? I believe this will only take a few lines.

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 = 1

for the error if you had readed before posts you will know why you got the error

[bushwhack_77]

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 = 1

How exactly?

[diablo71]

open _mods/online.php and replace the code with this:

<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>&nbsp;ID</center></td>
<td width=82 class=mem align=left>&nbsp;Character</center></td>
<td class=mem align=left>&nbsp;In Game</center></td>
<td width=32 class=mem align=left>&nbsp;Level</center></td>
<td width=32 class=mem align=left>&nbsp;Reset</center></td>
<td class=mem align=left>&nbsp;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>&nbsp;$rank</center></b></font></td>
<td class=mem align=left><font size=1>&nbsp;$char[0]</center></td>
<td class=mem align=left><font size=1>&nbsp;$row[2]</center></td>
<td class=mem align=left><font size=1><b>&nbsp;$char[2]</center></b></td>
<td class=mem align=left><font size=1><b>&nbsp;[$char[3]]</center></b></td>
<td class=mem align=left><font size=1><b>&nbsp;$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>
";
?>

[bushwhack_77]

Sweet.

Tyvm.

[Takamura]

diablo, when i click Rankings

no characters displayed?

how do i fix that?

[diablo71]

what version you use old version or new ?
did you import the sql code ?

[Takamura]

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

[diablo71]

view first page

[Takamura]

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

[mekels]

This Web Rocks! but i want have some problem and request. hehehe ^^