Ir para conteúdo

[Encerrado] [Encerrado] Problema ao entrar no website


Caronte

Posts Recomendados

 


Não estou conseguindo postar na área correta, que seria websites, e também em outras, favor corrigir esse problema com minhas permissões e mover tópico.

 

 

Problema:

Fatal error: Call to a member function fetch() on boolean in C:\xampp\htdocs\pages\latestnews.php on line 64

ao entrar no meu 127.0.0.1 , acredito que seja porque peguei uma database errada 

// linha 60$tickerSql = $SQL->query("SELECT ");//NEWSTICKER$time = time();$vTick = $SQL->query("SELECT " .$SQL->fieldName('date'). " FROM " .$SQL->tableName('z_news_tickers'). " WHERE " .$SQL->fieldName('hide_ticker'). " = '0'")->fetch();if(isset($vTick['date'])){//$news_content .= '// linha 67

Caso precise do latestnews todo:

Spoiler

 

 

<?php$main_content .= '<div class="InnerTableContainer">	<table>		<tbody>			<tr>				<td>					<div class="TableShadowContainerRightTop">						<div class="TableShadowRightTop" style="background-image: url('.$layout_name.'/images/content/table-shadow-rt.gif);"></div>					</div>						<div class="TableContentAndRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-rm.gif);">							<div class="TableContentContainer">								<table class="TableContent" style="border: 1px solid #faf0d7;">									<tbody>										<tr style="background-color: #505050;">										</tr>											<tr class="Table" style="background-color: #d4c0a1;">												<td style="width: 800; border: 1px; border-style: solid; border-color: #FAF0D7;">													<div class="NewsHeadline">														<div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">															<table border="0">																<tr>																	<td style="text-align: center; font-weight: bold;">																		<font color="white">Most powerful guilds</font>																	</td>																</tr>															</table>														</div>													</div>												<table border="0" cellspacing="3" cellpadding="4" width="100%">											<tr>';												foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;') as $guild)												$main_content .= '              													<td style="width: 25%; text-align: center;">														<a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="/guild_image.php?id=' . $guild['id'] . '" width="64" height="64" border="0"/><br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills													</td>';												$main_content .= '																			</tr>																		</table>																	</td>																</tr>															</tbody>														</table>													</div>												</div>											<div class="TableShadowContainer">										<div class="TableBottomShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bm.gif);">									<div class="TableBottomLeftShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-bl.gif);"></div>								<div class="TableBottomRightShadow" style="background-image: url('.$layout_name.'/images/content/table-shadow-br.gif);"></div>							</div>						</div>					</td>				</tr>			</tbody>		</table>	</div><br />';if(!defined('INITIALIZED'))	exit;$tickerSql = $SQL->query("SELECT ");//NEWSTICKER$time = time();$vTick = $SQL->query("SELECT " .$SQL->fieldName('date'). " FROM " .$SQL->tableName('z_news_tickers'). " WHERE " .$SQL->fieldName('hide_ticker'). " = '0'")->fetch();if(isset($vTick['date'])){$news_content .= '	<div id="NewsTicker" class="Box">    	<div class="Corner-tl" style="background-image: url('.$layout_name.'/images/content/corner-tl.gif);"></div>    	<div class="Corner-tr" style="background-image: url('.$layout_name.'/images/content/corner-tr.gif);"></div>    	<div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>    	<div class="BorderTitleText" style="background-image: url('.$layout_name.'/images/content/title-background-green.gif);"></div>    	<img class="Title" src="'.$layout_name.'/images/header/headline-newsticker.gif" alt="Contentbox headline" />    		<div class="Border_2">      			<div class="Border_3">        			<div class="BoxContent" style="background-image: url('.$layout_name.'/images/content/scroll.gif);">';					//##################### ADD NEW TICKER #####################					if($action == "newticker") {						if($group_id_of_acc_logged >= $config['site']['access_tickers']) {							$ticker_text = stripslashes(trim($_POST['new_ticker']));							$ticker_icon = (int) $_POST['icon_id'];							if(empty($ticker_text)) {								$news_content .= 'You can\'t add empty ticker.';							}							else							{							if(empty($ticker_icon)) {								$news_icon = 0;							}					$SQL->query('INSERT INTO '.$SQL->tableName('z_news_tickers').' (date, author, image_id, text, hide_ticker) VALUES ('.$SQL->quote($time).', '.$account_logged->getId().', '.$ticker_icon.', '.$SQL->quote($ticker_text).', 0)');					$news_content .= '						<center>							<h2>								<font color="red">Added new ticker:</font>							</h2>						</center>						<hr/>						<div id="newsticker" class="Box">							<div id="TickerEntry-1" class="Row" onclick=\'TickerAction("TickerEntry-1")\'>  								<div class="Odd">    								<div class="NewsTickerIcon" style="background-image: url('.$layout_name.'/images/news/icon_'.$ticker['image_id'].'.gif);"></div>    								<div id="TickerEntry-1-Button" class="NewsTickerExtend" style="background-image: url('.$layout_name.'/images/general/plus.gif);"></div>    								<div class="NewsTickerText">      										<span class="NewsTickerDate">'.date("d/m/Y", $time).' -</span>       										<div id="TickerEntry-1-ShortText" class="NewsTickerShortText">';					$news_content .= '						<a href="?subtopic=latestnews&action=deleteticker&id='.$time.'">							<img src="'.$layout_name.'/images/news/delete.png" border="0">						</a>';					$news_content .= short_text($ticker_text, 60).'</div>      					<div id="TickerEntry-1-FullText" class="NewsTickerFullText">';					$news_content .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$time.'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>';					$news_content .= $ticker_text.'						</div>    				</div>  				</div>			</div>		</div>	<hr/>';	}}else{	$news_content .= 'You don\'t have admin rights. You can\'t add new ticker.';}	$news_content .= '<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form>';}//#################### DELETE (HIDE only!) TICKER ############################if($action == "deleteticker") {if($group_id_of_acc_logged >= $config['site']['access_tickers']) {header("Location: ");$date = (int) $_REQUEST['id'];$SQL->query('UPDATE '.$SQL->tableName('z_news_tickers').' SET hide_ticker = 1 WHERE '.$SQL->fieldName('date').' = '.$date.';');$news_content .= '<center>News tickets with <b>date '.date("j F Y, g:i a", $date).'</b> has been deleted.<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center></div></div>    </div>    <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>    <div class="CornerWrapper-b"><div class="Corner-bl" style="background-image: url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>    <div class="CornerWrapper-b"><div class="Corner-br" style="background-image: url('.$layout_name.'/images/content/corner-br.gif);"></div></div>  </div>';}else{$news_content .= '<center>You don\'t have admin rights. You can\'t delete tickers.<form action="?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';}}//show tickers if any in database or not blocked (tickers limit = 0)$tickers = $SQL->query('SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 5;');$number_of_tickers = 0;if(is_object($tickers)) {foreach($tickers as $ticker) {if(is_int($number_of_tickers / 2))        $color = "Odd";else        $color = "Even";$tickers_to_add .= '<div id="TickerEntry-'.$number_of_tickers.'" class="Row" onclick=\'TickerAction("TickerEntry-'.$number_of_tickers.'")\'>  <div class="'.$color.'">    <div class="NewsTickerIcon" style="background-image: url('.$layout_name.'/images/news/icon_'.$ticker['image_id'].'.gif);"></div>    <div id="TickerEntry-'.$number_of_tickers.'-Button" class="NewsTickerExtend" style="background-image: url('.$layout_name.'/images/general/plus.gif);"></div>    <div class="NewsTickerText">      <span class="NewsTickerDate">'.date("d/m/Y", $ticker['date']).' -</span>      <div id="TickerEntry-'.$number_of_tickers.'-ShortText" class="NewsTickerShortText">';//if admin show button to delete (hide) tickerif($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {$tickers_to_add .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$ticker['date'].'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>';}$tickers_to_add .= short_text($ticker['text'], 60).'</div>      <div id="TickerEntry-'.$number_of_tickers.'-FullText" class="NewsTickerFullText">';//if admin show button to delete (hide) tickerif($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {$tickers_to_add .= '<a href="?subtopic=latestnews&action=deleteticker&id='.$ticker['date'].'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>';}$tickers_to_add .= $ticker['text'].'</div>    </div>  </div></div>';$number_of_tickers++;}}}//adding newsif($action == "newnews") {if($group_id_of_acc_logged >= $config['site']['access_news']) {$text = ($_REQUEST['text']);$char_id = (int) $_REQUEST['char_id'];$post_topic = stripslashes(trim($_REQUEST['topic']));$smile = (int) $_REQUEST['smile'];$news_icon = (int) $_REQUEST['icon_id'];if(empty($news_icon)) {$news_icon = 0;}if(empty($post_topic)) {$an_errors[] .= 'You can\'t add news without topic.';}if(empty($text)) {$an_errors[] .= 'You can\'t add empty news.';}if(empty($char_id)) {$an_errors[] .= 'Select character.';}//execute queryif(empty($an_errors)) {$SQL->query("INSERT INTO `z_forum` (`id` ,`first_post` ,`last_post` ,`section` ,`replies` ,`views` ,`author_aid` ,`author_guid` ,`post_text` ,`post_topic` ,`post_smile` ,`post_date` ,`last_edit_aid` ,`edit_date`, `post_ip`, `icon_id`) VALUES ('NULL', '0', '".time()."', '1', '0', '0', '".$account_logged->getId()."', '".(int) $char_id."', ".$SQL->quote($text).", ".$SQL->quote($post_topic).", '".(int) $smile."', '".time()."', '0', '0', '".$_SERVER['REMOTE_ADDR']."', '".$news_icon."')");$thread_id = $SQL->lastInsertId();$SQL->query("UPDATE `z_forum` SET `first_post`=".(int) $thread_id." WHERE `id` = ".(int) $thread_id);//show added data$main_content .= '<form action="index.php?subtopic=latestnews" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form>';}else{//show errors$main_content .= '<div class="SmallBox" >  <div class="MessageContainer" >    <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div>    <div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>    <div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>    <div class="ErrorMessage" >      <div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div>      <div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div>      <div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif);" /></div><b>The Following Errors Have Occurred:</b><br/>';foreach($an_errors as $an_error) {	$main_content .= '<li>'.$an_error;}$main_content .= '</div>    <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div>    <div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>    <div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>  </div></div><br/>';//okno edycji newsa z wpisanymi danymi przeslanymi wczesniej$main_content .= '<form action="index.php?subtopic=latestnews&action=newnews" method="post" ><table border="0"><tr><td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td><td><table border="0" bgcolor="F1E0C6"><tr><td><img src="'.$layout_name.'/images/news/icon_0.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_1.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_2.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_3.gif" width="20"></td><td><img src="'.$layout_name.'/images/news/icon_4.gif" width="20"></td></tr><tr><td><input type="radio" name="icon_id" value="0" checked="checked"></td><td><input type="radio" name="icon_id" value="1"></td><td><input type="radio" name="icon_id" value="2"></td><td><input type="radio" name="icon_id" value="3"></td><td><input type="radio" name="icon_id" value="4"></td></tr></table></td></tr><tr><td align="center" bgcolor="F1E0C6"><b>Topic:</b></td><td><input type="text" name="topic" maxlenght="50" style="width: 300px" value="'.$post_topic.'"></td></tr><tr><td align="center" bgcolor="D4C0A1"><b>News<br>text:</b></td><td bgcolor="F1E0C6"><textarea name="text" rows="6" cols="60">'.$text.'</textarea></td></tr><tr><td width="180"><b>Character:</b></td><td><select name="char_id"><option value="0">(Choose character)</option>'.$str.'</select></td></tr><tr><td><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></form><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="CancelAddNews" src="'.$layout_name.'/images/buttons/_sbutton_cancel.gif" onClick="location.href=\'index.php?subtopic=latestnews\';" alt="CancelAddNews" /></div></div></td></tr></table>';}}else{$main_content .= 'You don\'t have site-admin rights. You can\'t add news.';}}if(!empty($tickers_to_add)) {//show table with tickersif($group_id_of_acc_logged >= $config['site']['access_admin_panel'] && $action!=newticker)$news_content .= '<script type="text/javascript">var showednewticker_state = "0";function showNewTickerForm(){if(showednewticker_state == "0") {document.getElementById("newtickerform").innerHTML = \'<form action="?subtopic=latestnews&action=newticker" method="post" ><table border="0"><tr><td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td><td><table border="0" bgcolor="F1E0C6"><tr><td><img src="images/news/icon_0.gif" width="20"></td><td><img src="images/news/icon_1.gif" width="20"></td><td><img src="images/news/icon_2.gif" width="20"></td><td><img src="images/news/icon_3.gif" width="20"></td><td><img src="images/news/icon_4.gif" width="20"></td></tr><tr><td><input type="radio" name="icon_id" value="0" checked="checked"></td><td><input type="radio" name="icon_id" value="1"></td><td><input type="radio" name="icon_id" value="2"></td><td><input type="radio" name="icon_id" value="3"></td><td><input type="radio" name="icon_id" value="4"></td></tr></table></td></tr><tr><td align="center" bgcolor="D4C0A1"><b>New<br>ticker<br>text:</b></td><td bgcolor="F1E0C6"><textarea name="new_ticker" rows="3" cols="45"></textarea></td></tr><tr><td><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></form><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/_sbutton_cancel.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></td></tr></table>\';document.getElementById("jajo").innerHTML = \'\';showednewticker_state = "1";}else {document.getElementById("newtickerform").innerHTML = \'\';document.getElementById("jajo").innerHTML = \'<div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/addticker.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div>\';showednewticker_state = "0";}}</script><div id="newtickerform"></div><div id="jajo"><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/addticker.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></div><hr/>';//add tickers list$news_content .= $tickers_to_add;//koniec$news_content .= '</div>      </div>    </div>    <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>    <div class="CornerWrapper-b"><div class="Corner-bl" style="background-image: url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>    <div class="CornerWrapper-b"><div class="Corner-br" style="background-image: url('.$layout_name.'/images/content/corner-br.gif);"></div></div>  </div>';}//NEWSTICKER END//featured article//sem creditos do autor, apenas postado por Dhenyz Shady no X-tibia.///Queries ///$query = $SQL->query('SELECT `name`,`id`,`level`,`experience`,`group_id` FROM `players` WHERE `group_id` < 2 ORDER BY `level` DESC LIMIT 1;')->fetch(); $query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();$banned = $SQL->query('SELECT COUNT(*) FROM `account_bans` WHERE `account_id`>0;')->fetch();$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();///End Queries ///$news_content .= '    <div id="news" class="Box">    <div class="Corner-tl" style="background-image:url('.$layout_name.'/images/content/corner-tl.gif);"></div>    <div class="Corner-tr" style="background-image:url('.$layout_name.'/images/content/corner-tr.gif);"></div>    <div class="Border_1" style="background-image:url('.$layout_name.'/images/content/border-1.gif);"></div>    <div class="BorderTitleText" style="background-image:url(layouts/tibiacom/images/content/title-background-green.gif);"></div>   <img class="Title" src="/images/head/Featured Article.png" alt="Contentbox headline" />    <div class="Border_2">        <div class="Border_3">            <div class="BoxContent" style="background-image:url('.$layout_name.'/images/content/scroll.gif);">	<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=1 cellspacing=1 width=100%>    <tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>Bem-vindo ao '.$config['server']['serverName'].' Global</b></td></tr>    <tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>     <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>IP:</b> seuotserv.com.br</center></td>    <td><center><b>Version:</b> 10.94/98</center></td><td><center><b>Porta:</b> 7171</center></td></tr>          <table border=0 cellpadding=1 cellspacing=1 width=100%>    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Novo Player Criado</b>: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>, player number '.$query2['id'].'. Bem-vindo e tenha um bom jogo!</center></td></tr>    <table border=0 cellpadding=0 cellspacing=1 width=100%>    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Casas Vazias:</b> '.$housesfree[0].'</center></td>    <td><center><b>Casas Alugadas:</b> '.$housesrented[0].'</center></td></tr>          <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts Criadas</b>: '.$accounts[0].'</center></td>    <td><center><b>Players Criados</b>: '.$players[0].'</center></td></tr>    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Contas Banidas</b>: '.$banned[0].'</center></td>    <td><center><b>Guilds Fundadas</b>: '.$guilds[0].'</center></td></tr>    </table></td></tr></table></table>				</br></br>				<table border="0" align="center" width=100%">						<tr>							<td><p align="center"><img src="http://i.imgur.com/323oQjP.jpg" border="0"></p></td>							<td><p align="center"><img src="http://i.imgur.com/2faKDeC.jpg" border="0"></p></td>							<td><p align="center"><img src="http://i.imgur.com/lxTvrnv.jpg" border="0"></p></td>							<td><p align="center"><img src="http://i.imgur.com/nYJ0cbK.jpg" border="0"></p></td>						</tr>						<tr>							<td><p align="center"><a href="/index.php?subtopic=serverinfo">[CLIQUE AQUI]</a></p></td>							<td><p align="center"><a href="http://www.tibiawiki.com.br/wiki/Quests" target="_blank">[CLIQUE AQUI]</a></p></td>							<td><p align="center"><a href="#">[CLIQUE AQUI]</a></p></td>							<td><p align="center"><a href="/index.php?subtopic=downloads">[CLIQUE AQUI]</a></p></td>						</tr></table>				</div>				</div>            </div>    <div class="Border_1" style="background-image: url('.$layout_name.'/images/content/border-1.gif);"></div>    <div class="CornerWrapper-b"><div class="Corner-bl" style="background-image: url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>    <div class="CornerWrapper-b"><div class="Corner-br" style="background-image: url('.$layout_name.'/images/content/corner-br.gif);"></div></div>    </div>';//Fim do featured Article		function replaceSmile($text, $smile){    $smileys = array(						':p' => 1, 						':eek:' => 2, 						':rolleyes:' => 3, 						';)' => 4, 						':o' => 5, 						':D' => 6,  						':(' => 7, 						':mad:' => 8,						':)' => 9,						':cool:' => 10					);    if($smile == 1)        return $text;    else    {        foreach($smileys as $search => $replace)            $text = str_replace($search, '<img src="layouts/tibiarl/images/forum/smile/'.$replace.'.gif" />', $text);        return $text;    }}function replaceAll($text, $smile){    $rows = 0;    while(stripos($text, '
') !== false && stripos($text, '

'

) !== false ) { $code = substr($text, stripos($text, '
')+6, stripos($text, '

'

) - stripos($text, '
') - 6);        if(!is_int($rows / 2)) { $bgcolor = 'ABED25'; } else { $bgcolor = '23ED25'; } $rows++;        $text = str_ireplace('[code]'.$code.'

'

, '<i>Code:</i><br /><table cellpadding="0" style="background-color: #'.$bgcolor.'; width: 480px; border-style: dotted; border-color: #CCCCCC; border-width: 2px"><tr><td>'.$code.'</td></tr></table>', $text); } $rows = 0; while(stripos($text, '
') !== false && stripos($text, '
') !== false ) { $quote = substr($text, stripos($text, '
')+7, stripos($text, '
') - stripos($text, '
') - 7); if(!is_int($rows / 2)) { $bgcolor = 'AAAAAA'; } else { $bgcolor = 'CCCCCC'; } $rows++; $text = str_ireplace('
'.$quote.'
', '<table cellpadding="0" style="background-color: #'.$bgcolor.'; width: 480px; border-style: dotted; border-color: #007900; border-width: 2px"><tr><td>'.$quote.'</td></tr></table>', $text); } $rows = 0; while(stripos($text, 'http://') !== false && stripos($text, '') !== false ) { $url = substr($text, stripos($text, 'http://')+5, stripos($text, '') - stripos($text, 'http://') - 5); $text = str_ireplace(''.$url.'', '<a href="'.$url.'" target="_blank">'.$url.'</a>', $text); } while(stripos($text, ') !== false && stripos($text, '" target="_blank">') !== false && stripos($text, '') !== false ) { $player = substr($text, stripos($text, ')+8, stripos($text, '" target="_blank">')+8, stripos($text, '') - stripos($text, ') - 8); $text = str_ireplace('[player]'.$player.'" target="_blank">') - 8); $text = str_ireplace('[player]'.$player.'', '<a href="?subtopic=&name='.urlencode($player).'">'.$player.'</a>', $text); } while(stripos($text, '[letter]') !== false && stripos($text, '[/letter]') !== false ) { $letter = substr($text, stripos($text, '[letter]')+8, stripos($text, '[/letter]') - stripos($text, '[letter]') - 8); $text = str_ireplace('[letter]'.$letter.'[/letter]', '<img src="images/letters/letter_martel_'.$letter.'.gif">', $text); } while(stripos($text, ') !== false && stripos($text, '' alt='span>''>') !== false ) { $img = substr($text, stripos($text, ')+5, stripos($text, '' alt='span>''>') - stripos($text, ') - 5); $text = str_ireplace(''.$img.'' alt='span>''>', '<img src="'.$img.'">', $text); } while(stripos($text, '') !== false && stripos($text, '') !== false ) { $b = substr($text, stripos($text, '')+3, stripos($text, '') - stripos($text, '') - 3); $text = str_ireplace(''.$b.'', '<b>'.$b.'</b>', $text); } while(stripos($text, '') !== false && stripos($text, '') !== false ) { $i = substr($text, stripos($text, '')+3, stripos($text, '') - stripos($text, '') - 3); $text = str_ireplace(''.$i.'', '<i>'.$i.'</i>', $text); } while(stripos($text, '') !== false && stripos($text, '') !== false ) { $u = substr($text, stripos($text, '')+3, stripos($text, '') - stripos($text, '') - 3); $text = str_ireplace(''.$u.'', '<u>'.$u.'</u>', $text); } return replaceSmile($text, $smile);}function showPost($topic, $text, $smile){ $text = nl2br($text); $post = ''; if(!empty($topic)) $post .= '<b>'.replaceSmile($topic, $smile).'</b>'; $post .= replaceAll($text, $smile); return $post;}if($group_id_of_acc_logged >= $config['site']['access_admin_panel'] && $action != 'newnews') { $main_content .= ' <font style="font-size: 16px; font-weight: bold; margin-left: 20px;">Adding News</font> <form action="index.php?subtopic=latestnews&action=newnews" method="post" > <table border="0"> <tr> <td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td> <td> <table border="0"> <tr bgcolor="F1E0C6"> <td><img src="'.$layout_name.'/images/news/icon_0.gif" width="20"></td> <td><img src="'.$layout_name.'/images/news/icon_1.gif" width="20"></td> <td><img src="'.$layout_name.'/images/news/icon_2.gif" width="20"></td> <td><img src="'.$layout_name.'/images/news/icon_3.gif" width="20"></td> <td><img src="'.$layout_name.'/images/news/icon_4.gif" width="20"></td> </tr> <tr bgcolor="D4C0A1"> <td><input type="radio" name="icon_id" value="0" checked="checked"></td> <td><input type="radio" name="icon_id" value="1" /></td> <td><input type="radio" name="icon_id" value="2" /></td> <td><input type="radio" name="icon_id" value="3" /></td> <td><input type="radio" name="icon_id" value="4" /></td> </tr> </table> </td> </tr> <tr> <td align="center" bgcolor="F1E0C6"><b>Topic:</b></td> <td><input type="text" name="topic" maxlenght="50" style="width: 300px" ></td> </tr> <tr> <td align="center" bgcolor="D4C0A1"><b>News<br>text:</b></td>'; //Tiny Editor $main_content .= ' <script type="text/javascript" src="'.$layout_name.'/tiny_mce/tiny_mce.js"></script> <script type="text/javascript"> tinyMCE.init({ // General options mode : "textareas", theme : "advanced", plugins : "autolink,lists,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave,visualblocks", // Theme options theme_advanced_buttons1 : "newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect", theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,link,unlink,anchor,image,cleanup,code,|,insertdate,inserttime,preview,|,forecolor,backcolor", theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,ltr,rtl", theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft,visualblocks", theme_advanced_toolbar_location : "top", theme_advanced_toolbar_align : "left", theme_advanced_statusbar_location : "bottom", theme_advanced_resizing : true, // Example content CSS (should be your site CSS) content_css : "css/content.css", // Drop lists for link/image/media/template dialogs template_external_list_url : "lists/template_list.js", external_link_list_url : "lists/link_list.js", external_image_list_url : "lists/image_list.js", media_external_list_url : "lists/media_list.js", // Style formats style_formats : [ {title : \'Bold text\', inline : \'b\'}, {title : \'Red text\', inline : \'span\', styles : {color : \'#ff0000\'}}, {title : \'Red header\', block : \'h1\', styles : {color : \'#ff0000\'}}, {title : \'Example 1\', inline : \'span\', classes : \'example1\'}, {title : \'Example 2\', inline : \'span\', classes : \'example2\'}, {title : \'Table styles\'}, {title : \'Table row 1\', selector : \'tr\', classes : \'tablerow1\'} ], // Replace values for the template plugin template_replace_values : { username : "Some User", staffid : "991234" } }); </script>'; $main_content .= ' <td bgcolor="F1E0C6"> <textarea name="text" id="elm1" rows="6" cols="60"></textarea> </td> </tr> <tr> <td width="180"><b>Character:</b></td> <td> <select name="char_id"> <option value="0">(Choose character)</option>'; foreach($account_logged->getPlayers() as $player) { $main_content .= '<option value="'.$player->getID().'">'.$player->getName().'</option>'; } $main_content .= ' </select> </td> </tr> <tr> <td> <div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div> <input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" > </div> </div> </form> </td> </tr></table><hr/>';} $last_threads = $SQL->query('SELECT ' . $SQL->tableName('players') . '.' . $SQL->fieldName('name') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_text') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_topic') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('icon_id') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_smile') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('replies') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_date') . ' FROM ' . $SQL->tableName('players') . ', ' . $SQL->tableName('z_forum') . ' WHERE ' . $SQL->tableName('players') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('author_guid') . ' AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('section') . ' = 1 AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('first_post') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ' ORDER BY ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('last_post') . ' DESC LIMIT ' . $config['site']['news_limit'])->fetchAll(); //Here start news if(isset($last_threads[0])) { foreach($last_threads as $thread) { $main_content .= ' <div class="NewsHeadline"> <div class="NewsHeadlineBackground" style="background-image:url('.$layout_name.'/images/news/newsheadline_background.gif)"> <img src="'.$layout_name.'/images/news/icons/newsicon_'.$thread['icon_id'].'.gif" class="NewsHeadlineIcon" alt=\'\' /> <div class="NewsHeadlineDate">'.date('M m Y', $thread['post_date']).' -</div> <div class="NewsHeadlineText">'.htmlspecialchars($thread['post_topic']).'</div> </div> </div> <table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'> <tr>'; $main_content .= ' <td style=\'padding-left:10px;padding-right:10px;\' >' . showPost('', $thread['post_text'], $thread['post_smile']) . '<br><p align="right"><a href="?subtopic=forum&action=show_thread&id=' . $thread['id'] . '">» Comment on this news</a></p></td>'; $main_content .= ' <td> <img src="'.$layout_name.'/images/global/general/blank.gif" width=10 height=1 border=0 alt=\'\' /> </td> </tr> </table><br />'; } } else $main_content .= '<h3>No news. Go forum and make new thread on board News.</h3>';

 

Esse é o OTServer que contém o site que estou tentando abrir:

 

 

Editado por Caronte
Link para o comentário
Compartilhar em outros sites

Agora, Deadpool disse:

vai em localhost/admin e ver as tabelas se tem "z_news_tickers"

 

Tem não, por isso eu quero uma database que já tenha elas, não achei e tô fazendo várias coisas ao mesmo tempo.

Link para o comentário
Compartilhar em outros sites

Spoiler

qual versão? te mando uma,

 mas tenta executar esses comandos:

 

DROP TABLE IF EXISTS `z_news_tickers`;CREATE TABLE IF NOT EXISTS `z_news_tickers` (  `date` int(11) NOT NULL DEFAULT '1',  `author` int(11) NOT NULL,  `image_id` int(3) NOT NULL DEFAULT '0',  `text` text NOT NULL,  `hide_ticker` tinyint(1) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `z_ots_comunication`;CREATE TABLE IF NOT EXISTS `z_ots_comunication` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(255) NOT NULL,  `type` varchar(255) NOT NULL,  `action` varchar(255) NOT NULL,  `param1` varchar(255) NOT NULL,  `param2` varchar(255) NOT NULL,  `param3` varchar(255) NOT NULL,  `param4` varchar(255) NOT NULL,  `param5` varchar(255) NOT NULL,  `param6` varchar(255) NOT NULL,  `param7` varchar(255) NOT NULL,  `delete_it` int(2) NOT NULL DEFAULT '1',  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_polls`;CREATE TABLE IF NOT EXISTS `z_polls` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `question` varchar(255) NOT NULL,  `end` int(11) NOT NULL,  `start` int(11) NOT NULL,  `answers` int(11) NOT NULL,  `votes_all` int(11) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_polls_answers`;CREATE TABLE IF NOT EXISTS `z_polls_answers` (  `poll_id` int(11) NOT NULL,  `answer_id` int(11) NOT NULL,  `answer` varchar(255) NOT NULL,  `votes` int(11) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `z_poll_votes`;CREATE TABLE IF NOT EXISTS `z_poll_votes` (`id` int(11) NOT NULL AUTO_INCREMENT,`answer_id` int(11) ,`poll_id` int(11) ,`account_id` int(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_shop_history_item`;CREATE TABLE IF NOT EXISTS `z_shop_history_item` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `to_name` varchar(255) NOT NULL DEFAULT '0',  `to_account` int(11) NOT NULL DEFAULT '0',  `from_nick` varchar(255) NOT NULL,  `from_account` int(11) NOT NULL DEFAULT '0',  `price` int(11) NOT NULL DEFAULT '0',  `offer_id` varchar(255) NOT NULL DEFAULT '',  `trans_state` varchar(255) NOT NULL,  `trans_start` int(11) NOT NULL DEFAULT '0',  `trans_real` int(11) NOT NULL DEFAULT '0',  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_shop_history_pacc`;CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `to_name` varchar(255) NOT NULL DEFAULT '0',  `to_account` int(11) NOT NULL DEFAULT '0',  `from_nick` varchar(255) NOT NULL,  `from_account` int(11) NOT NULL DEFAULT '0',  `price` int(11) NOT NULL DEFAULT '0',  `pacc_days` int(11) NOT NULL DEFAULT '0',  `trans_state` varchar(255) NOT NULL,  `trans_start` int(11) NOT NULL DEFAULT '0',  `trans_real` int(11) NOT NULL DEFAULT '0',  PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_shop_offer`;CREATE TABLE IF NOT EXISTS `z_shop_offer` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `points` int(11) NOT NULL DEFAULT '0',  `itemid1` int(11) NOT NULL DEFAULT '0',  `count1` int(11) NOT NULL DEFAULT '0',  `itemid2` int(11) NOT NULL DEFAULT '0',  `count2` int(11) NOT NULL DEFAULT '0',  `offer_type` varchar(255) DEFAULT NULL,  `offer_description` text NOT NULL,  `offer_name` varchar(255) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_news_big`;CREATE TABLE IF NOT EXISTS `z_news_big` (`hide_news` tinyint(1) NOT NULL DEFAULT '0',`date` int(11) NOT NULL DEFAULT '0',`author` varchar(255) NOT NULL,`author_id` int(11) NOT NULL,`image_id` int(3) NOT NULL DEFAULT '0',`topic` varchar(255) NOT NULL,`text` text NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Link para o comentário
Compartilhar em outros sites

21 minutos atrás, Deadpool disse:
  Mostrar conteúdo oculto

qual versão? te mando uma,

 mas tenta executar esses comandos:

 

DROP TABLE IF EXISTS `z_news_tickers`;CREATE TABLE IF NOT EXISTS `z_news_tickers` (  `date` int(11) NOT NULL DEFAULT '1',  `author` int(11) NOT NULL,  `image_id` int(3) NOT NULL DEFAULT '0',  `text` text NOT NULL,  `hide_ticker` tinyint(1) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `z_ots_comunication`;CREATE TABLE IF NOT EXISTS `z_ots_comunication` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(255) NOT NULL,  `type` varchar(255) NOT NULL,  `action` varchar(255) NOT NULL,  `param1` varchar(255) NOT NULL,  `param2` varchar(255) NOT NULL,  `param3` varchar(255) NOT NULL,  `param4` varchar(255) NOT NULL,  `param5` varchar(255) NOT NULL,  `param6` varchar(255) NOT NULL,  `param7` varchar(255) NOT NULL,  `delete_it` int(2) NOT NULL DEFAULT '1',  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_polls`;CREATE TABLE IF NOT EXISTS `z_polls` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `question` varchar(255) NOT NULL,  `end` int(11) NOT NULL,  `start` int(11) NOT NULL,  `answers` int(11) NOT NULL,  `votes_all` int(11) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_polls_answers`;CREATE TABLE IF NOT EXISTS `z_polls_answers` (  `poll_id` int(11) NOT NULL,  `answer_id` int(11) NOT NULL,  `answer` varchar(255) NOT NULL,  `votes` int(11) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `z_poll_votes`;CREATE TABLE IF NOT EXISTS `z_poll_votes` (`id` int(11) NOT NULL AUTO_INCREMENT,`answer_id` int(11) ,`poll_id` int(11) ,`account_id` int(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_shop_history_item`;CREATE TABLE IF NOT EXISTS `z_shop_history_item` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `to_name` varchar(255) NOT NULL DEFAULT '0',  `to_account` int(11) NOT NULL DEFAULT '0',  `from_nick` varchar(255) NOT NULL,  `from_account` int(11) NOT NULL DEFAULT '0',  `price` int(11) NOT NULL DEFAULT '0',  `offer_id` varchar(255) NOT NULL DEFAULT '',  `trans_state` varchar(255) NOT NULL,  `trans_start` int(11) NOT NULL DEFAULT '0',  `trans_real` int(11) NOT NULL DEFAULT '0',  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_shop_history_pacc`;CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `to_name` varchar(255) NOT NULL DEFAULT '0',  `to_account` int(11) NOT NULL DEFAULT '0',  `from_nick` varchar(255) NOT NULL,  `from_account` int(11) NOT NULL DEFAULT '0',  `price` int(11) NOT NULL DEFAULT '0',  `pacc_days` int(11) NOT NULL DEFAULT '0',  `trans_state` varchar(255) NOT NULL,  `trans_start` int(11) NOT NULL DEFAULT '0',  `trans_real` int(11) NOT NULL DEFAULT '0',  PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_shop_offer`;CREATE TABLE IF NOT EXISTS `z_shop_offer` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `points` int(11) NOT NULL DEFAULT '0',  `itemid1` int(11) NOT NULL DEFAULT '0',  `count1` int(11) NOT NULL DEFAULT '0',  `itemid2` int(11) NOT NULL DEFAULT '0',  `count2` int(11) NOT NULL DEFAULT '0',  `offer_type` varchar(255) DEFAULT NULL,  `offer_description` text NOT NULL,  `offer_name` varchar(255) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `z_news_big`;CREATE TABLE IF NOT EXISTS `z_news_big` (`hide_news` tinyint(1) NOT NULL DEFAULT '0',`date` int(11) NOT NULL DEFAULT '0',`author` varchar(255) NOT NULL,`author_id` int(11) NOT NULL,`image_id` int(3) NOT NULL DEFAULT '0',`topic` varchar(255) NOT NULL,`text` text NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

 

Tu que fez esses querys? 

 

Falta só mais umas tabelas, pulamos para linha 523:

    $last_threads = $SQL->query('SELECT ' . $SQL->tableName('players') . '.' . $SQL->fieldName('name') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_text') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_topic') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('icon_id') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_smile') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('replies') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_date') . ' FROM ' . $SQL->tableName('players') . ', ' . $SQL->tableName('z_forum') . ' WHERE ' . $SQL->tableName('players') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('author_guid') . ' AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('section') . ' = 1 AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('first_post') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ' ORDER BY ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('last_post') . ' DESC LIMIT ' . $config['site']['news_limit'])->fetchAll();		//Here start news    if(isset($last_threads[0]))    {        foreach($last_threads as $thread)        {            $main_content .= '				<div class="NewsHeadline">					<div class="NewsHeadlineBackground" style="background-image:url('.$layout_name.'/images/news/newsheadline_background.gif)">						<img src="'.$layout_name.'/images/news/icons/newsicon_'.$thread['icon_id'].'.gif" class="NewsHeadlineIcon" alt=\'\' />						<div class="NewsHeadlineDate">'.date('M m Y', $thread['post_date']).' -</div>    					<div class="NewsHeadlineText">'.htmlspecialchars($thread['post_topic']).'</div>					</div>				</div>				<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'>				<tr>';            $main_content .= '				<td style=\'padding-left:10px;padding-right:10px;\' >' . showPost('', $thread['post_text'], $thread['post_smile']) . '<br><p align="right"><a href="?subtopic=forum&action=show_thread&id=' . $thread['id'] . '">» Comment on this news</a></p></td>';        			$main_content .= '				<td>					<img src="'.$layout_name.'/images/global/general/blank.gif" width=10 height=1 border=0 alt=\'\' />				</td>			</tr>		</table><br />';		}    }    else        $main_content .= '<h3>No news. Go forum and make new thread on board News.</h3>';

 

Link para o comentário
Compartilhar em outros sites

aqui:

CREATE TABLE `z_forum` (	`id` int(11) NOT NULL auto_increment,	`sticky` tinyint(1) NOT NULL DEFAULT '0',	`closed` tinyint(1) NOT NULL DEFAULT '0',	`first_post` int(11) NOT NULL default '0',	`last_post` int(11) NOT NULL default '0',	`section` int(3) NOT NULL default '0',	`icon_id` int(3) NOT NULL default '1',	`replies` int(20) NOT NULL default '0',	`views` int(20) NOT NULL default '0',	`author_aid` int(20) NOT NULL default '0',	`author_guid` int(20) NOT NULL default '0',	`post_text` text NOT NULL,	`post_topic` varchar(255) NOT NULL,	`post_smile` tinyint(1) NOT NULL default '0',	`post_date` int(20) NOT NULL default '0',	`last_edit_aid` int(20) NOT NULL default '0',	`edit_date` int(20) NOT NULL default '0',	`post_ip` varchar(32) NOT NULL default '0.0.0.0',	PRIMARY KEY  (`id`),	KEY `section` (`section`)) ENGINE=MyISAM AUTO_INCREMENT=1;

mais ou menos, eu tenho salvo aqui kk qualquer coisa avisa ae

Editado por Deadpool
Link para o comentário
Compartilhar em outros sites

  • 5 months later...
Visitante
Este tópico está impedido de receber novos posts.
  • Quem Está Navegando   0 membros estão online

    • Nenhum usuário registrado visualizando esta página.
×
×
  • Criar Novo...