pedido erro site

[kleitonalan321 6]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'stream_status' in 'where clause'' in C:\xampp\htdocs\livestreams.php:39 Stack trace: #0 C:\xampp\htdocs\livestreams.php(39): PDO->query('SELECT * FROM p...') #1 C:\xampp\htdocs\index.php(91): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\livestreams.php on line 39

 

alguem sabe resolver isso?

[luanluciano93 38]

Poste aqui o arquivo 'livestreams.php' !

[kleitonalan321 6]

livestreams.phpFetching info...

 

so a pagina no site nao quer abrir da o erro de cima nao tem que adicionar nenhuma coluna no banco de dados da database?

Editado Setembro 16, 2013 por kleitonalan321

[luanluciano93 38]

Edite e coloque ela em código e spoiler! Obrigado!

[kleitonalan321 6]

 

  Mostrar conteúdo oculto

 

<?PHP
$update_interval = 2;
if(count($config['site']['worlds']) > 1)
{
$worlds .= '<i>Select world:</i> ';
foreach($config['site']['worlds'] as $id => $world_n)
{
$worlds .= ' <a href="?subtopic=livestreams&world='.$id.'">'.$world_n.'</a> , ';
if($id == (int) $_GET['world'])
{
$world_id = $id;
$world_name = $world_n;
}
}
$main_content .= substr($worlds, 0, strlen($worlds)-3);
}
if(!isset($world_id))
{
$world_id = 0;
$world_name = $config['server']['serverName'];
}
// Sorting type
$order = $_REQUEST['order'];
if($order == 'level')
$orderby = 'level';
elseif($order == 'vocation')
$orderby = 'vocation';
if(empty($orderby))
$orderby = 'name';
$tmp_file_name = 'cache/livestreams-'.$orderby.'-'.$world_id.'.tmp';
if(file_exists($tmp_file_name) && filemtime($tmp_file_name) > (time() - $update_interval))
{
$tmp_file_content = explode(",", file_get_contents($tmp_file_name));
$number_of_players_online = $tmp_file_content[0];
$players_rows = $tmp_file_content[1];
}
else
{
$players_online_data = $SQL->query('SELECT * FROM players WHERE world_id = '.(int) $world_id.' AND stream_status > 0 AND online > 0 ORDER BY '.$orderby);
$number_of_players_online = 0;
foreach($players_online_data as $player)
{
$number_of_players_online++;
$acc = $SQL->query('SELECT flag, vip_time FROM '.$SQL->tableName('accounts').' WHERE '.$SQL->fieldName('id').' = '.$player['account_id'].' LIMIT 1;')->fetch();
if(is_int($number_of_players_online / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];

$skull = '';
if($config['site']['show_skull']) {
if ($player['skulltime'] > 0 && $player['skull'] == 3)
$skull = '<right><image src="./images/whiteskull.gif"/></right>';
elseif ($player['skulltime'] = $player['skull'] == 4)
$skull = '<right><image src="./images/redskull.gif"/></right>';
elseif ($player['skulltime'] = $player['skull'] == 5)
$skull = '<right><image src="./images/blackskull.gif"/></right>';
}
$players_outfit_row = '';
if($config['site']['show_outfit'])
$players_outfit_row .= '<TD ALIGN="right">'.$skull.'<center><image src="'.getOutfitLink($player['id']).'"/></center></TD>';
$players_rows .= '
<TR BGCOLOR='.$bgcolor.'>
<TD><center><image src="images/flags/'.$acc['flag'].'.png"/></center></TD>
'.$players_outfit_row.'
<TD><A HREF="?subtopic=characters&name='.$player['name'].'">'.$player['name'].'</A></TD>
<TD>'.$player['stream_desc'].'</TD>
<TD>'.$player['level'].'</TD>
<TD>'.$vocation_name[$world_id][$player['promotion']][$player['vocation']].'</TD>
<TD>'.($acc['vip_time'] > 0 ? '<font color="green"><b>VIP</b></font>' : '<font color="red"><b>NO</b></font></TD>').'
</TR>';
}
file_put_contents($tmp_file_name, $number_of_players_online.','.$players_rows);
}

if($number_of_players_online == 0)
//server status - server empty
$main_content .= '
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR>
<TR BGCOLOR='.$config['site']['darkborder'].'>
<TD>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>
<TR><TD>There are no players streaming right now on <b>'.$config['site']['worlds'][$world_id].'</b>.</TD></TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR>';
else
{
//Vocations pics
$vocs = array();
foreach($SQL->query('SELECT `vocation`, COUNT(`id`) AS `count` FROM `players` WHERE `world_id` = "'.$world_id.'" AND `online` > 0 GROUP BY `vocation`') as $entry)
$vocs[$entry['vocation']] = $entry['count'];


$main_content .= '
<div class="TableContainer" >
<table class="Table1" cellpadding="0" cellspacing="0" >
<div class="CaptionContainer" >
<div class="CaptionInnerContainer" >
<span class="CaptionEdgeLeftTop" style="background-image:url(http://static.tibia.com/images/global/content/box-frame-edge.gif);" /></span>
<span class="CaptionEdgeRightTop" style="background-image:url(http://static.tibia.com/images/global/content/box-frame-edge.gif);" /></span>
<span class="CaptionBorderTop" style="background-image:url(http://static.tibia.com/images/global/content/table-headline-border.gif);" ></span>
<span class="CaptionVerticalLeft" style="background-image:url(http://static.tibia.com/images/global/content/box-frame-vertical.gif);" /></span>
<div class="Text" >World Information</div>
<span class="CaptionVerticalRight" style="background-image:url(http://static.tibia.com/images/global/content/box-frame-vertical.gif);" /></span>
<span class="CaptionBorderBottom" style="background-image:url(http://static.tibia.com/images/global/content/table-headline-border.gif);" ></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url(http://static.tibia.com/images/global/content/box-frame-edge.gif);" /></span>
<span class="CaptionEdgeRightBottom" style="background-image:url(http://static.tibia.com/images/global/content/box-frame-edge.gif);" /></span>
</div>
</div>
<tr>
<td>
<div class="InnerTableContainer" >
<table style="width:100%;" >
<tr>
<td class="LabelV150" ><b>Status:</b></td>
<td>Online</td></tr><tr><td class="LabelV150" ><b>Live Streams:</b></td>
<td>'.$number_of_players_online.'</td></tr><tr><td class="LabelV150" ><b>Creation Date:</b></td>
<td>30/11/2010</td></tr>
<tr><td class="LabelV150" ><b>Location:</b></td><td>Brazil</td></tr>
<tr><td class="LabelV150" ><b>PvP Type:</b></td><td>Open PvP</td></tr>
<tr>
<td class="LabelV150" ><b>World Quest Titles:</b></td>
<td><a href="?subtopic=lightbearer">Lightbearer</a></td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</div>
<br>';



//list of players
$width_name = 35;
if($config['site']['show_outfit']) {
$players_outfit_row = '<TD WIDTH=5%><a href="" CLASS=white >Outfit</a></TD>';
$width_name = 30;
}
$main_content .= '
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
<TD WIDTH=5%><a href="" CLASS=white >Country</a></TD>
'.$players_outfit_row.'
<TD WIDTH='.width_name.'%><A HREF="?subtopic=livestreams&order=name&world='.$world_id.'" CLASS=white>Name</A></TD>
<TD WIDTH=40%><A HREF="?subtopic=livestreams&order=stream_desc&world='.$world_id.'" CLASS=white>Stream Description</A></TD>
<TD WIDTH=5%><A HREF="?subtopic=livestreams&order=level&world='.$world_id.'" CLASS=white>Level</A></TD>
<TD WIDTH=10%><A HREF="?subtopic=livestreams&order=vocation&world='.$world_id.'" CLASS=white>Vocation</TD>
<TD WIDTH="5%><a href="" CLASS=white >VIP</a></TD></TR>'.$players_rows.'</TABLE>';
//search bar
$main_content .= '
<BR>
<FORM ACTION="?subtopic=characters" METHOD=post>
<TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4>
<TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR>
<TR>
<TD BGCOLOR="'.$config['site']['darkborder'].'">
<TABLE BORDER=0 CELLPADDING=1>
<TR>
<TD>Name:</TD>
<TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD>
<TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</FORM>';
}
?>

 

Editado Setembro 16, 2013 por kleitonalan321

[luanluciano93 38]

não é um arquivo php? lol! clica em código, coloca ele dentro, e entro os códigos coloca no começo [.spoiler] e no final [./spoiler] (sem os pontos).

[kleitonalan321 6]

pronto

[luanluciano93 38]

Qual a função desse arquivo? Oque ele deve fazer?

[kleitonalan321 6]

esse arquivo é parte do cast system para ver os player online no site e os comandos

 

é para ser assim essa pagina olha o link desse otserver http://novarro.no-ip.info/?subtopic=cast

Editado Setembro 16, 2013 por kleitonalan321

[luanluciano93 38]

Tenta essa ...

Cast.php

  Mostrar conteúdo oculto

<?PHP
$order = $_REQUEST['order'];
if($order == 'name') {
	$orderby = 'name';
}
if($order == 'level') {
	$orderby = 'level';
}
if($order == 'vocation') {
	$orderby = 'vocation';
}
if(empty($orderby)) {
	$orderby = 'name';
}
if(count($config['site']['worlds']) > 1)
{
	$worlds .= '<i>Select world:</i> ';
	foreach($config['site']['worlds'] as $idd => $world_n)
	{
		if($idd == (int) $_GET['world'])
		{
			$world_id = $idd;
			$world_name = $world_n;
		}
	}
}
if($idd == (int) $_GET['world'])
{
	$world_id = $idd;
	$world_name = $world_n;
}
if(!isset($world_id))
{
	$world_id = 0;
	$world_name = $config['server']['serverName'];
}
if(count($config['site']['worlds']) > 1)
{
	$main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD>
		<FORM ACTION="?subtopic=whoisonline" METHOD=get><INPUT TYPE=hidden NAME=subtopic VALUE=whoisonline><INPUT TYPE=hidden NAME=list VALUE=experience>
		<TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>World Selection</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['lightborder'].'">
		<TABLE BORDER=0 CELLPADDING=1><TR><TD>World: </TD><TD><SELECT SIZE="1" NAME="world"><OPTION VALUE="" SELECTED>(choose world)</OPTION>';
		foreach($config['site']['worlds'] as $id => $world_n)
		{
			$main_content .= '<OPTION VALUE="'.$id.'">'.$world_n.'</OPTION>';
		}
		$main_content .= '</SELECT> </TD><TD><INPUT TYPE=image NAME="Submit" ALT="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18>
		</TD></TR></TABLE></TABLE></FORM></TABLE><br>';
}
$players_online_data = $SQL->query('SELECT * FROM players WHERE online > 0 AND cast = 1 AND world_id = '.$world_id.' ORDER BY '.$orderby);
$number_of_players_online = 0;
foreach($players_online_data as $player) 
{
	$number_of_players_online++;
	if($config['site']['show_flag'])
	{
		$account = $SQL->query('SELECT * FROM accounts WHERE id = '.$player['account_id'].'')->fetch();
		$flag = '<image src="images/flags/'.$account['flag'].'.png"/> ';
	}
	if(is_int($number_of_players_online / 2)) 
	{
		$bgcolor = $config['site']['darkborder'];
	}
	else
	{
		$bgcolor = $config['site']['lightborder'];
	}
	$players_rows .= '
	<TR BGCOLOR='.$bgcolor.'>
		<TD WIDTH=40%>'.$flag.'<A HREF="index.php?subtopic=characters&name='.urlencode($player['name']).'">'.$player['name'].'</A><br/>'.$player['level'].' '.$vocation_name[$player['world_id']][$player['promotion']][$player['vocation']].'</TD>
		<TD WIDTH=40%>'.($player['castDescription'] == "" ? '-' : $player['castDescription']).'</TD>
		<TD WIDTH=20%>'.$player['castViewers'].'/50</TD>
	</TR>';
}
if($number_of_players_online == 0) 
{
	//server status - server empty
	$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently there are no active casts on '.$config['server']['serverName'].'.</TD></TR></TABLE></TD></TR></TABLE><BR>';
}
else
{
	//server status - someone is online
	$main_content .= '
	<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
		<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
			<TD CLASS=white><B>Server Status</B></TD>
		</TR>
		<TR BGCOLOR='.$config['site']['darkborder'].'>
			<TD>';
			$main_content .= 'Currently there are '.$number_of_players_online.' active live casts';
			$main_content .= ' on '.$world_name.' gameworlds.<br>
			</TD>
		</TR>
	</TABLE><BR>';
	//list of players
	$main_content .= '
	<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
		<TR BGCOLOR="'.$config['site']['vdarkborder'].'">
			<TD><A HREF="index.php?subtopic=whoisonline&order=name" CLASS=white>Name</A></TD>
			<TD><A HREF="index.php?subtopic=whoisonline&order=level" CLASS=white>Description</A></TD>
			<TD><A HREF="index.php?subtopic=whoisonline&order=vocation" CLASS=white>Viewers</TD>
		</TR>
	'.$players_rows.'</TABLE>';
	//search bar
	//$main_content .= '<BR><FORM ACTION="index.php?subtopic=characters" METHOD=post>  <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';
}
	$main_content .= '<BR><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Description</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><h4 style="margin: 0px;">Commands (owner):</h4><i>/cast {on/off}</i> - Create or close your own cast<br/><i>/cast password |password|</i> - Sets a password for the cast<br/><i>/cast desc |description|</i> - Set a description for the cast<br/><i>/cast status</i> - Information about your cast (viewer amount, description, password)<br/><i>/cast viewers</i> - Displays the name of all viewers<br/><i>/cast {ban/unban} "name"</i> - Bans a viewer from joining your cast/Removes the ban<br/><i>/cast {mute/unmute} "name"</i> - Mutes a viewer on your cast/Removes the mute<br/><i>/cast bans</i> - Displays a list of banned viewers<br/><i>/cast mutes</i> - Displays a list of muted viewers<br/><i>/cast update</i> - Updates the description and status on the website<br/><br/><h4 style="margin: 0px;">Commands (viewer):</h4><i>/nick newNick</i> - Changes the viewer\'s name<br><i>/info</i> - Displays a list of all viewers</TD></TR></TABLE>';

?>

 

SQL:

  Mostrar conteúdo oculto

 

ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0',

ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0',

ADD `castDescription` VARCHAR( 255 ) NOT NULL

Espero ter ajudado, qualquer erro poste aqui!

Ajudei rep+

Editado Setembro 16, 2013 por luanluciano93

[kleitonalan321 6]

vlw cara deu certo muito obg vo te da REP por uma semana por me ajudar.

[luanluciano93 38]

Obrigado! Se tiver mais dúvidas sobre website pode mandar ...