Hey all,
im trying to code something that will echo text and vars into a widgts, while using echo it works but it outputs at the begining of the page instead of inside th wigit it self,
could you try and assit me in altering the code so it would work?
PHP Code:
$Hostname = "SERVER";
$Username = "USER";
$Password = "PASS";
$CharacterDatabase = 'characters';
$RealmDatabase = 'realmd';
$WorldDatabase = 'world';
$CharacterDatabaseEncoding = 'utf8';
$toutput='';
$conn = mysql_connect($Hostname, $Username, $Password);
mysql_select_db($CharacterDatabase, $conn);
$sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`";
$result = mysql_query($sql, $conn);
$count = 0;
$realm_db = mysql_connect($Hostname, $Username, $Password);
mysql_select_db($RealmDatabase, $realm_db);
$db_result = mysql_query("SET NAMES $CharacterDatabaseEncoding", $realm_db);
$world_db = mysql_connect($Hostname, $Username, $Password, TRUE);
mysql_select_db($CharacterDatabase, $world_db);
$db_result = mysql_query("SET NAMES $CharacterDatabaseEncoding", $world_db);
$uptime_query = mysql_query("SELECT * FROM $RealmDatabase.`uptime` ORDER BY `starttime` DESC LIMIT 1", $realm_db);
$uptime_results = mysql_fetch_array($uptime_query);
$maxplayers = $uptime_results['maxplayers'];
if ($uptime_results['uptime'] > 86400) { //days
$uptime = round(($uptime_results['uptime'] / 24 / 60 / 60),2)." ימים";
}
elseif($uptime_results['uptime'] > 3600) { //hours
$uptime = round(($uptime_results['uptime'] / 60 / 60),2)." שעות";
}
else { //minutes
$uptime = round(($uptime_results['uptime'] / 60),2)." דקות";
}
$player_query = mysql_query("SELECT (SELECT COUNT(guid) FROM $CharacterDatabase.`characters` WHERE race IN(2,5,6,8,10) AND `online`='1') as horde, (SELECT COUNT(guid) FROM $CharacterDatabase.`characters` WHERE race IN(1,3,4,7,11) AND `online`='1') as alliance FROM $CharacterDatabase.`characters`", $world_db);
$player_results = mysql_fetch_array($player_query);
$horde = $player_results['horde'];
$alliance = $player_results['alliance'];
$total = $horde + $alliance;
echo "<table width=\"100%\" border=0 cellspacing=0 cellpadding=3 class=\"alt2\">
<tr>
<td class=\"alt2\">פעילות:</td>
<td class=\"alt2\">$uptime</td>
<tr>
<td class=\"alt2\">מחוברים:</td>
<td class=\"alt2\">$total</td>
</tr>
</tr>
<tr>
<td class=\"alt2\">אלליאנס:</td>
<td class=\"alt2\">$alliance</td>
</tr>
<tr>
<td class=\"alt2\">הורד:</td>
<td class=\"alt2\">$horde</td>
</tr>
</table>";