Заинтересовавшийся
Регистрация: 23.12.2008
Сообщений: 31
Отблагодарили 0 раз(а)
Рейтинг мнений:
|
Re: Сайт показывает Off
Случайно не ети строки отвечают за показ сервера онлаин или офлаин??
Цитата:
<?
mysql_selectdb ("$db3");
mysql_query("SET NAMES $database_encoding");
$online = mysql_query ("select count(*) from characters where online = 1");
$online = mysql_result ($online,0);
$aonline = mysql_query ("select count(*) from characters where online = 1 and race in (1,3,4,7,11)");
$aonline = mysql_result ($aonline,0);
$honline = mysql_query ("select count(*) from characters where online = 1 and race in (2,5,6,8,10)");
$honline = mysql_result ($honline,0);
?>
<?php
$procent_aonline = round(($aonline/$online)*100);
$procent_honline = round(($honline/$online)*100);
?>
|
Добавлено через 29 минут
вот гляньте может тут чтота надо переделать online.php
Цитата:
<?
include("config.php");
if($module_online==on)
{
?>
<style type="text/css" media="screen">
<!--
@import url("modules/jscss/qTip.css");
-->
</style>
<script language="JavaScript" src="modules/jscss/qTip.js" type="text/JavaScript"></script>
<script language="JavaScript" src="modules/jscss/sorttable.js" type="text/JavaScript"></script>
<?
$def = Array(
'character_side' => Array(
1 => 'Alliance',
2 => 'Horde',
),
'character_race' => Array(
1 => 'Human',
2 => 'Orc',
3 => 'Dwarf',
4 => 'Night Elf',
5 => 'Undead',
6 => 'Tauren',
7 => 'Gnome',
8 => 'Troll',
10 => 'Blood Elf',
11 => 'Draenei',
),
'character_class' => Array(
1 => 'Warrior',
2 => 'Paladin',
3 => 'Hunter',
4 => 'Rogue',
5 => 'Priest',
6 => 'Death Knight',
7 => 'Shaman',
8 => 'Mage',
9 => 'Warlock',
11 => 'Druid',
),
);
class DBLayer
{
var $link_id;
var $query_result;
var $saved_queries = array();
var $num_queries = 0;
function DBLayer($host, $user, $pass, $dbr)
{
$this->link_id = @mysql_connect($host, $user, $pass, true);
if ($this->link_id)
{
if (@mysql_select_db($dbr, $this->link_id))
return $this->link_id;
else
error('Unable to select database. MySQL reported: '.mysql_error(), __FILE__, __LINE__);
}
else
error('Unable to connect to MySQL server. MySQL reported: '.mysql_error(), __FILE__, __LINE__);
}
function query($sql)
{
$this->query_result = @mysql_query($sql, $this->link_id);
if ($this->query_result)
{
++$this->num_queries;
return $this->query_result;
}
else
{
return false;
}
}
function result($query_id = 0, $row = 0)
{
return ($query_id) ? @mysql_result($query_id, $row) : false;
}
function fetch_assoc($query_id = 0)
{
return ($query_id) ? @mysql_fetch_assoc($query_id) : false;
}
function fetch_row($query_id = 0)
{
return ($query_id) ? @mysql_fetch_row($query_id) : false;
}
function num_rows($query_id = 0)
{
return ($query_id) ? @mysql_num_rows($query_id) : false;
}
function affected_rows()
{
return ($this->link_id) ? @mysql_affected_rows($this->link_id) : false;
}
function insert_id()
{
return ($this->link_id) ? @mysql_insert_id($this->link_id) : false;
}
function get_num_queries()
{
return $this->num_queries;
}
function get_saved_queries()
{
return $this->saved_queries;
}
function free_result($query_id = false)
{
return ($query_id) ? @mysql_free_result($query_id) : false;
}
function escape($str)
{
if (function_exists('mysql_real_escape_string'))
return mysql_real_escape_string($str, $this->link_id);
else
return mysql_escape_string($str);
}
function error()
{
$result['error_sql'] = @current(@end($this->saved_queries));
$result['error_no'] = @mysql_errno($this->link_id);
$result['error_msg'] = @mysql_error($this->link_id);
return $result;
}
function close()
{
if ($this->link_id)
{
if ($this->query_result)
@mysql_free_result($this->query_result);
return @mysql_close($this->link_id);
}
else
return false;
}
}
function error($message, $file, $line, $db_error = false)
{
global $siteerrors;
$s = "\t\t".'Error: <strong>'.$message.'.</strong>'."\n";
echo $s;
}
function get_zone_name($mapid, $x, $y)
{
global $maps_a, $zone;
if (!empty($maps_a[$mapid]))
{
$zmap=$maps_a[$mapid];
if (($mapid==0) or ($mapid==1) or ($mapid==530))
{
$i=0;
$c=count($zone[$mapid]);
while ($i<$c)
{
if ($zone[$mapid][$i][2] < $x AND $zone[$mapid][$i][3] > $x AND $zone[$mapid][$i][1] < $y AND $zone[$mapid][$i][0] > $y) $zmap=$zone[$mapid][$i][4];
$i++;
}
}
} else $zmap="Unknown zone";
return $zmap;
}
function test_realm(){
global $server, $port;
$s = @fsockopen("$server", $port, $ERROR_NO, $ERROR_STR,(float)0.5);
if($s){@fclose($s);return true;} else return false;
$realm_db->close();
unset($realm_db);
}
function make_players_array(){
global $host, $user, $pass, $db3, $database_encoding, $pl_array;
$i=0;
$characters_db = new DBLayer($host, $user, $pass, $db3);
$characters_db->query("SET NAMES $database_encoding");
$query = $characters_db->query("SELECT * FROM `characters` WHERE `online`='1' ORDER BY `name`");
while($result = $characters_db->fetch_assoc($query))
{
$char_data = explode(' ',$result['data']);
$char_gender = dechex($char_data[53]);
$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
$char_gender = $char_gender{3};
$res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']);
if ($result['race'] == 1 || $result['race'] == 3 || $result['race'] == 4 || $result['race'] == 7 || $result['race'] == 11) { $char_side=1; } else { $char_side=2; };
$pl_array[$i] = Array($result['name'], $result['race'], $result['class'], $result['level'], $res_pos, $char_gender, $char_side, $result['guid'], $char_data[31], $char_data[84], $char_data[85], $char_data[86], $char_data[87], $char_data[88], $char_data[99], $result['money'],);
$i++;
}
$characters_db->close();
unset($characters_db);
return $i;
}
$onlineplayers=make_players_array();
if (!$sort = &$_GET['s']) $sort=0;
if (!$flag = &$_GET['f']) $flag=0;
if ($flag==0) { $flag=1; $sort_type='<'; }
else { $flag=0; $sort_type='>'; }
$link=$_SERVER['PHP_SELF']."?f=".$flag."&s=";
if (!empty($pl_array))
{
usort($pl_array, create_function('$a, $b', 'if ( $a['.$sort.'] == $b['.$sort.'] ) return 0; if ( $a['.$sort.'] '.$sort_type.' $b['.$sort.'] ) return -1; return 1;'));
}
$list="";
$i=0;
while ($i < $onlineplayers)
{
$name=$pl_array[$i][0];
$race=$pl_array[$i][1];
$class=$pl_array[$i][2];
$res_class = $def['character_class'][$class];
$res_race = $def['character_race'][$race];
$lvl=$pl_array[$i][3];
$loc=$pl_array[$i][4];
$gender=$pl_array[$i][5];
if ($pl_array[$i][6]==1) {$side='alliance';} else { $side='horde'; };
$res_side = $def['character_side'][$pl_array[$i][6]];
$guild = $pl_array[$i][5];
$guid=$pl_array[$i][7];
$list.= "
<tr class=txt>
<td>-<a href=index.php?page=char&guid=$guid>$name</a></td>
<td align='center'><img alt=$res_race src='img/online/".$race."-".$gender.".gif' height='20' width='20'></td>
<td align='center'><img alt=$res_class src='img/online/".$class.".gif' height='20' width='20'></td>
<td align='center'><img alt=$res_side src='img/online/".$side.".gif' height='20' width='20'></td>
</td>
<td align='center'><b>$lvl</b></td>
</tr>";
$i++;
}
// Main part !!!
?>
<HTML>
<table width="100%" border="0" align='center' class="sortable" cellpadding=1 cellspacing=0 id="onlinetable">
<tbody>
<tr class=title>
<td width=40 height="15" align='center' nowrap='nowrap'><b><? echo "$txt[19]"; ?></b></td>
<td align='center' nowrap='nowrap' width=30><b><? echo "$txt[20]"; ?></b></td>
<td align='center' nowrap='nowrap' width=30><b><? echo "$txt[21]"; ?></b></td>
<td align='center' nowrap='nowrap' width=30><b><? echo "$txt[22]"; ?></b></td>
<td align='center' nowrap='nowrap' width=30><b><? echo "$txt[23]"; ?></b></td>
</tr>
<?php print $list ?>
</tbody>
</table>
<br>
</td>
</tr>
<?
}
if($module_online==off)
{
echo "<center>$txt[module_off]</center>";
}
?>
|
Последний раз редактировалось Eaglevs; 16.09.2010 в 14:40.
Причина: Добавлено сообщение
|