flagi w team.php

GrubeJointy2 · Aug 21, 2011

Witam chce zrobić flagi w team.php i kiedy dodaje quera wywala błąd nie wiem czemu.

Fatal error: Call to a member function getCustomField() on a non-object in C:\xampp\htdocs\team.php on line 4

team.php

PHP:

<?php
$list = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC');
$showed_players = 0;
$flagg = $account->getCustomField("flag");
$groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>');
        foreach($groups->group as $g) 
            $groupList[(int)$g['id']] = $g['name']; 

$main_content .= '<center><h2>Support on ' . $config['server']['serverName'] . '</h2></center>';
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%>
	<tr bgcolor=\"".$config['site']['vdarkborder']."\">
	<td width=\"5%\"><font class=white><b>#</b></font></td>
	<td width=\"28%\"><font class=white><b>Group</b></font></td>
	<td width=\"33%\"><font class=white><b>Name</b></font></td>
	<td width=\"14%\"><font class=white><b>Status</b></font></td>
	<td width=\"20%\"><font class=white><b>World</b></font></td>";
	
foreach($list as $gm) {
	if($gm['online'] == 0)
		$player_list_status = '<font color="red">Offline</font>';
	else
		$player_list_status = '<font color="green">Online</font>';
		if(is_int($showed_players / 2))
			$bgcolor = $config['site']['darkborder'];
		else
			$bgcolor = $config['site']['lightborder'];
			
$showed_players++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><image src="images/flags/'.$flagg.'.png"/></td><td>' . $groupList[(int)$gm['group_id']] . '</td><td><a href="?subtopic=characters&name='.urlencode($gm['name']).'">'.$gm['name'].'</a></td><td>'.$player_list_status.'</td><td>'.$config['site']['worlds'][$gm['world_id']].'</td></tr>';
}

$main_content .= "</table>";
?>

polaczkowanie · Aug 21, 2011

players.group_id
masz taką tabelke ?

GrubeJointy2 · Aug 21, 2011

polaczkowanie said:
players.group_id
masz taką tabelke ?

Działa działa więc się nie czepiaj

powiedz lepiej dlaczego ten nowy quer nie działa

Azi · Aug 21, 2011

PHP:

$account = new nazwa_klasy_account;

trzeba pierw stworzyć objekt, żeby móc z niego i dostępnych w nim funkcji korzystać, c'nie?

GrubeJointy2 · Aug 21, 2011

Azi said:
PHP:

$account = new nazwa_klasy_account;

trzeba pierw stworzyć objekt, żeby móc z niego i dostępnych w nim funkcji korzystać, c'nie?

Nie zbyt rozumiem, znaczy wydaje mi sie że wiem jak to zrobić ale nie działa nadal

widocznie coś źle robie

@down wstydzę się

Azi · Aug 21, 2011

GrubeJointy2 said:
Nie zbyt rozumiem, znaczy wydaje mi sie że wiem jak to zrobić ale nie działa nadal widocznie coś źle robie

to pokaż jak żeś to zrobił...

Aleh · Aug 21, 2011

$account_db = new OTS_Account();
$account_db->find($reg_name);
$reg_country->getCustomField("country");

GrubeJointy2 · Aug 21, 2011

Aleh said:
$account_db = new OTS_Account();
$account_db->find($reg_name);
$reg_country->getCustomField("country");

Ten sam błąd co wcześniej ;/

Azi · Aug 21, 2011

nad tym:

PHP:

$flagg = $account->getCustomField("flag");

dodaj:

PHP:

$account = new OTS_Account();

: )

GrubeJointy2 · Aug 21, 2011

Coś się ruszyło

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Account.php:769 Stack trace: #0 C:\xampp\htdocs\team.php(5): OTS_Account->getCustomField('flag') #1 C:\xampp\htdocs\index.php(197): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 769

http://wklej.to/bFK03/text

To już nie moje progi ;(

Azi · Aug 21, 2011

PHP:

$list = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC');

na:

Code:

$list = $SQL->query('SELECT name,online,group_id,world_id,[b][SIZE=3][COLOR="#FF0000"]flag[/COLOR][/SIZE][/b] FROM players WHERE players.group_id > 1 ORDER BY group_id DESC']

oczywiście sprawdź czy masz w bazie takie pole "flag"...

GrubeJointy2 · Aug 21, 2011

Azi said:

PHP:

$list = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC');

na:

Code:

$list = $SQL->query('SELECT name,online,group_id,world_id,[b][SIZE=3][COLOR="#FF0000"]flag[/COLOR][/SIZE][/b] FROM players WHERE players.group_id > 1 ORDER BY group_id DESC']

oczywiście sprawdź czy masz w bazie takie pole "flag"...

Mam w account flags ale i tak nie działa. W highscores i characters nie ma takich kombinacji a jakoś działa normalnie, nie ogarniam : (

edit: a może zrobić <image src="http://otland.net/images/flags/pl.png"/> i po problemie

Aleh · Aug 21, 2011

PHP:

$list = $SQL->query('SELECT `name`, `online`, `group_id`, `world_id`,` lastlogin`, `account_id` FROM `players` WHERE `group_id` > 1 ORDER BY `group_id` DESC');

po foreach dodaj (foreach($list as $gm))

PHP:

$flag = $SQL->query('SELECT `flag` FROM `accounts` WHERE `id` = '.$gm['account_id'].';')->fetch();

<image src="http://otland.net/images/flags/'.$flag['flag'].'.png"/>
a jak nie to

PHP:

$player = $ots->createObject('Player');
$player->find($name);
$account = $player->getAccount(); 
$account_db = new OTS_Account(); 
$flaga = $account->getCustomField("flag");

GrubeJointy2 · Aug 21, 2011

Aleh said:

PHP:

$list = $SQL->query('SELECT `name`, `online`, `group_id`, `world_id`,` lastlogin`, `account_id` FROM `players` WHERE `group_id` > 1 ORDER BY `group_id` DESC');

po foreach dodaj (foreach($list as $gm))

PHP:

$flag = $SQL->query('SELECT `flag` FROM `accounts` WHERE `id` = '.$gm['account_id'].';')->fetch();

<image src="http://otland.net/images/flags/'.$flag['flag'].'.png"/>
a jak nie to

PHP:

$player = $ots->createObject('Player');
$player->find($name);
$account = $player->getAccount(); 
$account_db = new OTS_Account(); 
$flaga = $account->getCustomField("flag");

Do 1

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1' in C:\xampp\htdocs\team.php:4 Stack trace: #0 C:\xampp\htdocs\team.php(4): PDO->query('SELECT `flag` F...') #1 C:\xampp\htdocs\index.php(197): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\team.php on line 4

Do 2
Błędu nie ma ale adres url grafiki to http://localhost/images/flags/.png

team.php

<?php
$list = $SQL->query('SELECT name,online,group_id,world_id FROM players WHERE players.group_id > 1 ORDER BY group_id DESC');
$showed_players = 0;

// Aleh
$player = $ots->createObject('Player');
$player->find($name);
$account = $player->getAccount();
$account_db = new OTS_Account();
$flaga = $account->getCustomField("flag");

$groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('Could not load groups!');
foreach($groups->group as $g)
$groupList[(int)$g['id']] = $g['name'];

$main_content .= '<center><h2>Support on ' . $config['server']['serverName'] . '</h2></center>';
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%>
<tr bgcolor=\"".$config['site']['vdarkborder']."\">
<td width=\"5%\">#</td>
<td width=\"28%\">Group</td>
<td width=\"33%\">Name</td>
<td width=\"14%\">Status</td>
<td width=\"20%\">World</td>";

foreach($list as $gm) {
if($gm['online'] == 0)
$player_list_status = 'Offline';
else
$player_list_status = 'Online';
if(is_int($showed_players / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];

$showed_players++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><image src="images/flags/'.$flag['flag'].'.png"/></td><td>' . $groupList[(int)$gm['group_id']] . '</td><td><a href="?subtopic=characters&name='.urlencode($gm['name']).'">'.$gm['name'].'</a></td><td>'.$player_list_status.'</td><td>'.$config['site']['worlds'][$gm['world_id']].'</td></tr>';
}

$main_content .= "</table>";
?>

Aleh · Aug 21, 2011

PHP:

$list = $SQL->query('SELECT `name`, `online`, `group_id`, `world_id`, `lastlogin`, `account_id` FROM `players` WHERE `group_id` > 1 ORDER BY `group_id` DESC');

PHP:

<?php
$list = $SQL->query('SELECT `name`, `online`, `group_id`, `world_id`, `lastlogin`, `account_id` FROM `players` WHERE `group_id` > 1 ORDER BY `group_id` DESC');  
$showed_players = 0; 

$groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>');
foreach($groups->group as $g) 
$groupList[(int)$g['id']] = $g['name']; 

$main_content .= '<center><h2>Support on ' . $config['server']['serverName'] . '</h2></center>';
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%>
<tr bgcolor=\"".$config['site']['vdarkborder']."\">
<td width=\"5%\"><font class=white><b>#</b></font></td>
<td width=\"28%\"><font class=white><b>Group</b></font></td>
<td width=\"33%\"><font class=white><b>Name</b></font></td>
<td width=\"14%\"><font class=white><b>Status</b></font></td>
<td width=\"20%\"><font class=white><b>World</b></font></td>";

foreach($list as $gm) {
$flag = $SQL->query('SELECT `flag` FROM `accounts` WHERE `id` = '.$gm['account_id'].';')->fetch();
if($gm['online'] == 0)
$player_list_status = '<font color="red">Offline</font>';
else
$player_list_status = '<font color="green">Online</font>';
if(is_int($showed_players / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];


$showed_players++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><image src="images/flags/'.$flag['flag'].'.png"/></td><td>' . $groupList[(int)$gm['group_id']] . '</td><td><a href="?subtopic=characters&name='.urlencode($gm['name']).'">'.$gm['name'].'</a></td><td>'.$player_list_status.'</td><td>'.$config['site']['worlds'][$gm['world_id']].'</td></tr>';
}

$main_content .= "</table>";
?>

GrubeJointy2 · Aug 21, 2011

Aleh said:

Bez przesady

@edit: Wielkie dzięki, nareszcie działa. Rep ++

Temat do Zamknięcia

flagi w team.php

GrubeJointy2

nIe Ma PrObLeMu

polaczkowanie

Banned User

GrubeJointy2

nIe Ma PrObLeMu

Azi

Banned User

GrubeJointy2

nIe Ma PrObLeMu

Azi

Banned User

Aleh

Active Member

GrubeJointy2

nIe Ma PrObLeMu

Azi

Banned User

GrubeJointy2

nIe Ma PrObLeMu

Azi

Banned User

GrubeJointy2

nIe Ma PrObLeMu

Aleh

Active Member

GrubeJointy2

nIe Ma PrObLeMu

Aleh

Active Member

GrubeJointy2

nIe Ma PrObLeMu

Similar threads