- Joined
- Feb 1, 2010
- Messages
- 94
- Reaction score
- 4
Здравейте как да направя на muweb 0.8 този
модула онлине плеярс да показва кой е онлине в момента щото тоя сега не го показва :s моля ви за помощ
Редактирай си с ИПто в админпанела
Да това искам за да ми показва кой е онлинеЯ я чакай мисля,че момчето просто иска да му дадеме Онлайн модул за този Уеб Сайт ако сам разбрал правилно?
<center><?php
require 'config.php';
$query = 'Select memb___id, ConnectTM, ConnectTm From MEMB_STAT where Connectstat=1 order by ConnectTM desc';
$result = mssql_query( $query );
echo '<TABLE border=0 cellPadding=2 cellSpacing=2>
<table id="mutable" class="alt5" height=30 border="1" bordercolor="333333" cellpadding="0" cellspacing="1" >
<tr>
<td align=center><font color=#545454><b>ID</b></font></td>
<td align=center><font color=#545454><b>Герой</b></font></td>
<td align=center><font color=#545454><b>В игра от</b></font></td>
<td align=center><font color=#545454><b>Ниво</b></font></td>
<td align=center><font color=#545454><b>Resets</b></font></td>
<td align=center><font color=#545454><b>Местоположение</b></font></td>
</tr>';
$waw = mssql_query("SELECT count(*) From MEMB_STAT where Connectstat=1");
$xex = mssql_result($waw, 0, 0);
$color = 'darkblue';
for($i=0;$i < $xex;++$i)
{
$row = mssql_fetch_row($result);
$querychar = "Select GameIDC From AccountCharacter where Id='$row[0]'";
$resultchar = mssql_query( $querychar );
$accchar = mssql_fetch_row($resultchar);
$querychar = "Select Name,Class,MapNumber,clevel,resets From Character where Name='$accchar[0]'";
$resultchar = mssql_query( $querychar );
$charr = mssql_fetch_row($resultchar);
$rank = $i+1;
//Class
if ($charr['1'] == 0) { $charr[1] = "Dark Wizard"; }
if ($charr['1'] == 1) { $charr[1] = "Soul Master"; }
if ($charr['1'] == 16) { $charr[1] = "Dark Knight"; }
if ($charr['1'] == 17) { $charr[1] = "Blade Knight"; }
if ($charr['1'] == 32) { $charr[1] = "Elf"; }
if ($charr['1'] == 33) { $charr[1] = "Muse Elf"; }
if ($charr['1'] == 48) { $charr[1] = "Magic Gladiator"; }
//Location
if ($charr['2'] == 0) { $charr[2] = 'Lorencia'; }
if ($charr['2'] == 1) { $charr[2] = 'Dungeon'; }
if ($charr['2'] == 2) { $charr[2] = 'Davias'; }
if ($charr['2'] == 3) { $charr[2] = 'Noria'; }
if ($charr['2'] == 4) { $charr[2] = 'Lost tower'; }
if ($charr['2'] == 5) { $charr[2] = 'Excile'; }
if ($charr['2'] == 6) { $charr[2] = 'Arena'; }
if ($charr['2'] == 7) { $charr[2] = 'Atlans'; }
if ($charr['2'] == 8) { $charr[2] = 'Tarkan'; }
if ($charr['2'] == 9) { $charr[2] = 'Devil Square'; }
if ($charr['2'] == 32) { $charr[2] = 'Devil Square'; }
if ($charr['2'] == 10) { $charr[2] = 'Icarus'; }
if ($charr['2'] == 11) { $charr[2] = 'Blood castle 1'; }
if ($charr['2'] == 12) { $charr[2] = 'Blood castle 2'; }
if ($charr['2'] == 13) { $charr[2] = 'Blood castle 3'; }
if ($charr['2'] == 14) { $charr[2] = 'Blood castle 4'; }
if ($charr['2'] == 15) { $charr[2] = 'Blood castle 5'; }
if ($charr['2'] == 16) { $charr[2] = 'Blood castle 6'; }
if ($charr['2'] == 17) { $charr[2] = 'Blood castle 7'; }
if ($charr['2'] == 18) { $charr[2] = 'Chaos castle 1'; }
if ($charr['2'] == 19) { $charr[2] = 'Chaos castle 2'; }
if ($charr['2'] == 20) { $charr[2] = 'Chaos castle 3'; }
if ($charr['2'] == 21) { $charr[2] = 'Chaos castle 4'; }
if ($charr['2'] == 22) { $charr[2] = 'Chaos castle 5'; }
if ($charr['2'] == 23) { $charr[2] = 'Chaos castle 6'; }
if ($charr['2'] == 24) { $charr[2] = 'Kalima 1'; }
if ($charr['2'] == 25) { $charr[2] = 'Kalima 2'; }
if ($charr['2'] == 26) { $charr[2] = 'Kalima 3'; }
if ($charr['2'] == 27) { $charr[2] = 'Kalima 4'; }
if ($charr['2'] == 28) { $charr[2] = 'Kalima 5'; }
if ($charr['2'] == 29) { $charr[2] = 'Kalima 6'; }
if ($charr['2'] == 36) { $charr[2] = 'Kalima 7'; }
if ($charr['2'] == 30) { $charr[2] = 'Valery Of Loren'; }
if ($charr['2'] == 31) { $charr[2] = 'Land of Trial'; }
if ($charr['2'] == 33) { $charr[2] = 'Aida'; }
if ($charr['2'] == 34) { $charr[2] = 'Cry Wolf'; }
if ($charr['2'] == 35) { $charr[2] = 'Silent Map'; }
if ($charr['2'] == 37) { $charr[2] = 'Kanturu Ruin'; }
if ($charr['2'] == 38) { $charr[2] = 'Kanturu Remain'; }
if ($charr['2'] == 39) { $charr[2] = 'Kanturu Tower'; }
echo "<tr>
<td align=center><font size=1 color=#545454><b>$rank.</b></font></td>
<td align=center><font size=1 color=#999999><b>$accchar[0]</b></td>
<td align=center><font size=1 color=#39b44a>$row[2]</td>
<td align=center><font size=1 color=#FFFFFF><b>$charr[3]</b></td>
<td align=center><font size=1 color=#545454><b>[<font color=#e11616><b>$charr[4]</b></font>]</b></td>
<td align=center><font size=1 color=#545454><b>$charr[2]</b></td>
</tr>
";
}
?></center>
</table>
Другият път пояснявай
PHP:<center><?php require 'config.php'; $query = 'Select memb___id, ConnectTM, ConnectTm From MEMB_STAT where Connectstat=1 order by ConnectTM desc'; $result = mssql_query( $query ); echo '<TABLE border=0 cellPadding=2 cellSpacing=2> <table id="mutable" class="alt5" height=30 border="1" bordercolor="333333" cellpadding="0" cellspacing="1" > <tr> <td align=center><font color=#545454><b>ID</b></font></td> <td align=center><font color=#545454><b>Герой</b></font></td> <td align=center><font color=#545454><b>В игра от</b></font></td> <td align=center><font color=#545454><b>Ниво</b></font></td> <td align=center><font color=#545454><b>Resets</b></font></td> <td align=center><font color=#545454><b>Местоположение</b></font></td> </tr>'; $waw = mssql_query("SELECT count(*) From MEMB_STAT where Connectstat=1"); $xex = mssql_result($waw, 0, 0); $color = 'darkblue'; for($i=0;$i < $xex;++$i) { $row = mssql_fetch_row($result); $querychar = "Select GameIDC From AccountCharacter where Id='$row[0]'"; $resultchar = mssql_query( $querychar ); $accchar = mssql_fetch_row($resultchar); $querychar = "Select Name,Class,MapNumber,clevel,resets From Character where Name='$accchar[0]'"; $resultchar = mssql_query( $querychar ); $charr = mssql_fetch_row($resultchar); $rank = $i+1; //Class if ($charr['1'] == 0) { $charr[1] = "Dark Wizard"; } if ($charr['1'] == 1) { $charr[1] = "Soul Master"; } if ($charr['1'] == 16) { $charr[1] = "Dark Knight"; } if ($charr['1'] == 17) { $charr[1] = "Blade Knight"; } if ($charr['1'] == 32) { $charr[1] = "Elf"; } if ($charr['1'] == 33) { $charr[1] = "Muse Elf"; } if ($charr['1'] == 48) { $charr[1] = "Magic Gladiator"; } //Location if ($charr['2'] == 0) { $charr[2] = 'Lorencia'; } if ($charr['2'] == 1) { $charr[2] = 'Dungeon'; } if ($charr['2'] == 2) { $charr[2] = 'Davias'; } if ($charr['2'] == 3) { $charr[2] = 'Noria'; } if ($charr['2'] == 4) { $charr[2] = 'Lost tower'; } if ($charr['2'] == 5) { $charr[2] = 'Excile'; } if ($charr['2'] == 6) { $charr[2] = 'Arena'; } if ($charr['2'] == 7) { $charr[2] = 'Atlans'; } if ($charr['2'] == 8) { $charr[2] = 'Tarkan'; } if ($charr['2'] == 9) { $charr[2] = 'Devil Square'; } if ($charr['2'] == 32) { $charr[2] = 'Devil Square'; } if ($charr['2'] == 10) { $charr[2] = 'Icarus'; } if ($charr['2'] == 11) { $charr[2] = 'Blood castle 1'; } if ($charr['2'] == 12) { $charr[2] = 'Blood castle 2'; } if ($charr['2'] == 13) { $charr[2] = 'Blood castle 3'; } if ($charr['2'] == 14) { $charr[2] = 'Blood castle 4'; } if ($charr['2'] == 15) { $charr[2] = 'Blood castle 5'; } if ($charr['2'] == 16) { $charr[2] = 'Blood castle 6'; } if ($charr['2'] == 17) { $charr[2] = 'Blood castle 7'; } if ($charr['2'] == 18) { $charr[2] = 'Chaos castle 1'; } if ($charr['2'] == 19) { $charr[2] = 'Chaos castle 2'; } if ($charr['2'] == 20) { $charr[2] = 'Chaos castle 3'; } if ($charr['2'] == 21) { $charr[2] = 'Chaos castle 4'; } if ($charr['2'] == 22) { $charr[2] = 'Chaos castle 5'; } if ($charr['2'] == 23) { $charr[2] = 'Chaos castle 6'; } if ($charr['2'] == 24) { $charr[2] = 'Kalima 1'; } if ($charr['2'] == 25) { $charr[2] = 'Kalima 2'; } if ($charr['2'] == 26) { $charr[2] = 'Kalima 3'; } if ($charr['2'] == 27) { $charr[2] = 'Kalima 4'; } if ($charr['2'] == 28) { $charr[2] = 'Kalima 5'; } if ($charr['2'] == 29) { $charr[2] = 'Kalima 6'; } if ($charr['2'] == 36) { $charr[2] = 'Kalima 7'; } if ($charr['2'] == 30) { $charr[2] = 'Valery Of Loren'; } if ($charr['2'] == 31) { $charr[2] = 'Land of Trial'; } if ($charr['2'] == 33) { $charr[2] = 'Aida'; } if ($charr['2'] == 34) { $charr[2] = 'Cry Wolf'; } if ($charr['2'] == 35) { $charr[2] = 'Silent Map'; } if ($charr['2'] == 37) { $charr[2] = 'Kanturu Ruin'; } if ($charr['2'] == 38) { $charr[2] = 'Kanturu Remain'; } if ($charr['2'] == 39) { $charr[2] = 'Kanturu Tower'; } echo "<tr> <td align=center><font size=1 color=#545454><b>$rank.</b></font></td> <td align=center><font size=1 color=#999999><b>$accchar[0]</b></td> <td align=center><font size=1 color=#39b44a>$row[2]</td> <td align=center><font size=1 color=#FFFFFF><b>$charr[3]</b></td> <td align=center><font size=1 color=#545454><b>[<font color=#e11616><b>$charr[4]</b></font>]</b></td> <td align=center><font size=1 color=#545454><b>$charr[2]</b></td> </tr> "; } ?></center> </table>
Я я чакай мисля,че момчето просто иска да му дадеме Онлайн модул за този Уеб Сайт ако сам разбрал правилно?
Сложих кода и не става, не показва кой е онлайн
Моля ви за помощ да не трябва нещо да се пише в Query Analyzer за да покаже кой е онлине - моля ви помощ
Добре кажи какво да го оправям сложих горе споменатия код във модула online.php и после какво да направя ?не просто, не можеш да го направиш
<?php require("config.php");
$status = mssql_query("SELECT DISTINCT
AccountCharacter.GameIDC,
memb_stat.ServerName, memb_stat.ServerName,
memb_stat.IP, memb_stat.ConnectTM,
memb_stat.DisConnectTM
from
Memb_stat
join
AccountCharacter
on
Memb_stat.memb___id = AccountCharacter.ID
collate Latin1_general_CI_AS
where Memb_stat.connectstat = 1");
?>
<link href="images/muweb_default.css" rel="stylesheet" type="text/css">
<style type="text/css">
</style>
<div align="center">
<table class="sort-table" id="table-1" height=0 border="0" cellpadding="4" cellspacing="0">
<thead><tr>
<td width="104" align="center"><div align="left"><span class="Estilo1"><font color="#33FF33">Nick:</font></span></div></td>
<td width="131" align="center"><span class="Estilo1"><font color="#33FF33">Status:</font></span></td>
<td width="63" align="center"><span class="Estilo1"><font color="#33FF33">Level:</font></span></td>
<td width="78" align="center"><span class="Estilo1"><font color="#33FF33">Resets:</font></span></td>
<td width="53" align="center"><span class="Estilo1"><font color="#33FF33">Map:</font></span></td>
<td width="40" align="center"><span class="Estilo1"><font color="#33FF33">Vip:</font></span></td>
</tr></thead>
<?php
while($row=mssql_fetch_array($status)) {
$dados_query = mssql_query("SELECT * FROM Character WHERE Name='$row[GameIDC]'");
$dados = mssql_fetch_array($dados_query);
$membstat_query = mssql_query("SELECT * FROM MEMB_STAT WHERE memb___id='$dados[AccountID]'");
$membstat = mssql_fetch_array($membstat_query);
$membinfo_query = mssql_query("SELECT * FROM MEMB_INFO WHERE memb___id='$dados[AccountID]'");
$membinfo = mssql_fetch_array($membinfo_query);
if ($dados[MapNumber] == 0) {$dados[MapNumber] = 'Lorencia';}
if ($dados[MapNumber] == 1) {$dados[MapNumber] = 'Dungeon';}
if ($dados[MapNumber] == 2) {$dados[MapNumber] = 'Davias';}
if ($dados[MapNumber] == 3) {$dados[MapNumber] = 'Noria';}
if ($dados[MapNumber] == 4) {$dados[MapNumber] = 'Lost tower';}
if ($dados[MapNumber] == 5) {$dados[MapNumber] = 'Excile';}
if ($dados[MapNumber] == 6) {$dados[MapNumber] = 'Arena';}
if ($dados[MapNumber] == 7) {$dados[MapNumber] = 'Atlans';}
if ($dados[MapNumber] == 8) {$dados[MapNumber] = 'Tarkan';}
if ($dados[MapNumber] == 9) {$dados[MapNumber] = 'Devil Square';}
if ($dados[MapNumber] == 10) {$dados[MapNumber] = 'Icarus';}
if ($dados[MapNumber] == 11) {$dados[MapNumber] = 'BC 1';}
if ($dados[MapNumber] == 12) {$dados[MapNumber] = 'BC 2';}
if ($dados[MapNumber] == 13) {$dados[MapNumber] = 'BC 3';}
if ($dados[MapNumber] == 14) {$dados[MapNumber] = 'BC 4';}
if ($dados[MapNumber] == 15) {$dados[MapNumber] = 'BC 5';}
if ($dados[MapNumber] == 16) {$dados[MapNumber] = 'BC 6';}
if ($dados[MapNumber] == 17) {$dados[MapNumber] = 'BC 6';}
if ($dados[MapNumber] == 18) {$dados[MapNumber] = 'CC 1';}
if ($dados[MapNumber] == 19) {$dados[MapNumber] = 'CC 2';}
if ($dados[MapNumber] == 20) {$dados[MapNumber] = 'CC 3';}
if ($dados[MapNumber] == 21) {$dados[MapNumber] = 'CC 4';}
if ($dados[MapNumber] == 22) {$dados[MapNumber] = 'CC 5';}
if ($dados[MapNumber] == 23) {$dados[MapNumber] = 'CC 6';}
if ($dados[MapNumber] == 24) {$dados[MapNumber] = 'Kalima';}
if ($dados[MapNumber] == 25) {$dados[MapNumber] = 'Kalima';}
if ($dados[MapNumber] == 26) {$dados[MapNumber] = 'Kalima';}
if ($dados[MapNumber] == 27) {$dados[MapNumber] = 'Kalima';}
if ($dados[MapNumber] == 28) {$dados[MapNumber] = 'Kalima';}
if ($dados[MapNumber] == 29) {$dados[MapNumber] = 'Kalima';}
if ($dados[MapNumber] == 30) {$dados[MapNumber] = 'Valey of Loren';}
if ($dados[MapNumber] == 31) {$dados[MapNumber] = 'Land of Trial';}
if ($dados[MapNumber] == 33) {$dados[MapNumber] = 'Aida';}
if ($dados[MapNumber] == 34) {$dados[MapNumber] = 'CryWolf';}
if ($dados[MapNumber] == 37) {$dados[MapNumber] = 'Kantrun';}
if ($dados[MapNumber] == 38) {$dados[MapNumber] = 'Kantrun 2';}
if ($dados[MapNumber] == 39) {$dados[MapNumber] = 'Refineria';}
if ($dados[MapNumber] == 41) {$dados[MapNumber] = 'Barranka';}
if ($dados[MapNumber] == 42) {$dados[MapNumber] = 'Refuge';}
if ($membinfo[vip] == 1) { $vip = "<img src='images/vip.gif'>"; }
if ($membinfo[vip] == 0) { $vip = "<img src='images/vip-no.gif'>"; }
echo "<tr>";
echo "<td align='left'><div class='link_rankings'><a href=index.php?op=character&character=$row[0]>$row[0]</a></div></td>";
echo "<td align='center'><img src='images/online.gif'></td>";
echo "<td align='center'>$dados[cLevel]</td>";
echo "<td align='center'>$dados[Resets]</td>";
echo "<td align='center'>$dados[MapNumber]</td>";
echo "<td align='center'>$vip</td>";
echo "</tr>";
}
?>
</div>
</form></td>
</table>
</div>