phpBB.de

Code: Alles auswählen

<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata); 

$page_title = 'Allianz Statistik'; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
	'body' => 'alli.tpl')
);

//* ALLI STATS ANFANG *//

	$spieler = "SELECT id, x, y, vid, did, dorfname, uid, spieler, aid, allianz, einwohner FROM x_world WHERE aid = 2240 ORDER by einwohner DESC";

if( !($result = $db->sql_query($spieler)) )

{
	message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}

if ( $row = $db->sql_fetchrow($result) )

{
	$i = 1;
	do
	{
			$id = $row['id'];
			$x = $row['x'];
			$y = $row['y'];
			$vid = $row['vid'];
			$did = $row['did'];
			$dorfname = $row['dorfname'];
			$uid = $row['uid'];
			$spieler = $row['spieler'];
			$aid = $row['aid'];
			$allianz = $row['allianz'];
			$einwohner = $row['einwohner'];

		$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
		$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

		$template->assign_block_vars('posterrow', array(
			'ROW_COLOR' => '#' . $row_color,
			'ROW_CLASS' => $row_class,
			'ID' => $uid,
			'X' => $x,
			'Y' => $y,
			'VID' => $vid,
			'DID' => $did,
			'DORF' => $dorfname,
			'UID' => $uid,
			'SPIELER' => $spieler,
			'aid' => $aid,
			'ALLI' => $allianz,
			'EW' => $einwohner,
			'PLATZ' => $i,
			'SLINK' => append_sid("http://welt3.travian.de/spieler.php?uid=$uid"),
			'DLINK' => append_sid("http://welt3.travian.de/karte.php?d=$id"))
		);

		$i++;
	}
	while ( $row = $db->sql_fetchrow($result) );
	$db->sql_freeresult($result);
}

//* ALLI STATS ENDE *//

$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>