erro

Erro no Latest News

Por kk44, 22 de abr. de 2014 em Archived

1.5k

kk44 KCampones

info

Grupo: Campones

Registrado: 18/04/14

Posts: 17

Reputação: 0

22 de abril de 2014 às 22:16

Warning: Invalid argument supplied for foreach() in

C:\Users\User\Desktop\xampp\htdocs\pages\latestnews.php on line 237

Ja coloquei diversos latestnews.php mas nenhum vai, n consigo colocar noticias nem tickets estou usando gesior tfs 1.0 e o ot alissow 5.1

Editado Abril 22 por kk44

Gabrielphilippi GCampones

info

Grupo: Campones

Registrado: 04/12/12

Posts: 15

Reputação: -1

Char no Tibia: Gabriel

22 de abril de 2014 às 22:19

É bug do servidor, Rep ae Ajuda!!

grilado13RAWRGCampones

info

Grupo: Campones

Registrado: 20/01/11

Posts: 75

Reputação: +41

22 de abril de 2014 às 22:22

Tenta mudar de gesior e reinstale o mesmo.

https://github.com/gesior/Gesior2012/branches

Baixe o TFS-0.4_rev_3703+ ou o TFS-0.3.6_and_0.4_to_rev_3703 que deve ser compatível

kk44 KCampones

info

Grupo: Campones

Registrado: 18/04/14

Posts: 17

Reputação: 0

22 de abril de 2014 às 22:22

consegui colocar um que funciona mais tem o erro agr na linha 237

mas o ot e tfs 1.0

Editado Abril 22 por kk44

grilado13RAWRGCampones

info

Grupo: Campones

Registrado: 20/01/11

Posts: 75

Reputação: +41

22 de abril de 2014 às 22:34

Ah ta, o Victor estava dando umas modificações no TFS para ficar compatível com o TFS 1.0, não sei se ele já terminou. Aguarde a resposta dele pois não tenho informações sobre o projeto

kk44 KCampones

info

Grupo: Campones

Registrado: 18/04/14

Posts: 17

Reputação: 0

22 de abril de 2014 às 23:45

latestnews.php:

<?PHP header("Content-Type: text/html; charset=UTF-8",true);

date_default_timezone_set('America/Sao_Paulo');

//######################## SHOW TICKERS AND NEWS #######################

if ($logged){

$players_from_account = $SQL->query("SELECT `players`.`name`, `players`.`id` FROM `players` WHERE `players`.`account_id` = ".(int) $account_logged->getId())->fetchAll();

foreach($players_from_account as $player)

{

$str .= '<option value="'.$player['id'].'"';

if($player['id'] == $char_id)

$strt .= ' selected="selected"';

$str .= '>'.$player['name'].'</option>';

}

$time = time();

$news_content .= '

<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="TickerEntry-1-ShortText" class="NewsTickerShortText">';

$news_content .= '<a href="index.php?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="index.php?subtopic=latestnews&action=deleteticker&id='.$time.'"><img src="'.$layout_name.'/images/news/delete.png" border="0"></a>';

$news_content .= $ticker_text.'

</div>

</div><hr/>';

}

else

{

$news_content .= 'You don\'t have admin rights. You can\'t add new ticker.';

}

$news_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>';

}

//#################### DELETE (HIDE only!) TICKER ############################

if($action == "deleteticker") {

if($group_id_of_acc_logged >= $config['site']['access_tickers']) {

$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 M Y", $date).'</b> has been deleted.<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></center>';

}

else

{

$news_content .= '<center>You don\'t have admin rights. You can\'t delete tickers.<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></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 4;');

$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 .= '

<span class="NewsTickerDate">'.date("j M Y", $ticker['date']).' -</span>

<div id="TickerEntry-'.$number_of_tickers.'-ShortText" class="NewsTickerShortText">';

//if admin show button to delete (hide) ticker

if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {

$tickers_to_add .= '<a href="index.php?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) ticker

if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {

$tickers_to_add .= '<a href="index.php?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>';

$number_of_tickers++;

}

if(!empty($tickers_to_add)) {

//show table with tickers

if($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="index.php?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="'.$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="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>';

//end of tickers, news part

//adding news

if($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 query

if(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.';}

}

//####################Show script with new news panel############################

if($group_id_of_acc_logged >= $config['site']['access_news'] && $action != 'newnews')

{

$main_content .= '

<tr>

<td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td>

<td>

</tr>

</tr>

</table>

</td>

</tr>

<tr>

<td align="center" bgcolor="F1E0C6"><b>Topic:</b></td>

</tr>

<tr>

</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>

</table>

<hr/>';

$zapytanie = $SQL->query("SELECT `z_forum`.`icon_id`,`z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 3;")->fetchAll();

}

///show news

$announcements = $SQL->query("SELECT * FROM `announcements` WHERE id ORDER BY `date` DESC LIMIT 1");

foreach ($announcements as $announcementsRow){

$news_content .= '<div id="featuredarticle" class="Box">

<div style="font-size:18px; font-weight:bold;">'.$announcementsRow['title'].'</div>

</div>

'.$announcementsRow['text'].'

<br />

<small style="float: right;">Posted by <font color="red">'.$announcementsRow['author'].'</font> - '.date("d M Y", $announcementsRow['date']).'</small>';

if ($logged)if ($account_logged->getCustomField("page_access") > 6 ){ $news_content .='<input class="btn btn-small btn-danger" type="button" value="Deletar" OnClick="location.href=\'index.php?subtopic=cpanel&action=deletar_ann&id='.$announcementsRow['id'].'\'" />';}

$news_content .='

</div>

</div>

}

$zapytanie = $SQL->query("SELECT `z_forum`.`icon_id`, `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 3;")->fetchAll();

foreach ($zapytanie as $row)

{

$BB = array(

'/\[youtube\](.*?)\[\/youtube\]/is' => '<center><object width="500" height="405"><param name="movie" value="http://www.youtube.com/watch?v=$1&hl=pt-br&fs=1&rel=0&color1=0x3a3a3a&color2=0x999999&border=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/watch?v=$1&hl=pt-br&fs=1&rel=0&color1=0x3a3a3a&color2=0x999999&border=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="500" height="405"></embed></object></center>',

'/\[b\](.*?)\[\/b\]/is' => '<strong>$1</strong>',

'/\[center\](.*?)\[\/center\]/is' => '<center>$1</center>',

'/\

(.*?)\[\/quote\]/is' => '<table cellpadding="0" style="background-color: #c4c4c4; width: 480px; border-style: dotted; border-color: #007900; border-width: 2px"><tr><td>$1</td></tr></table>',

'/\[u\](.*?)\[\/u\]/is' => '<u>$1</u>',

'/\[i\](.*?)\[\/i\]/is' => '<i>$1</i>',

'/\[letter\](.*?)\[\/letter\]/is' => '<img src=images/letters/$1.gif alt=$1 />',

'/\(.*?)\[\/url\]/is' => '<a href=$1>$1</a>',

'/\[color\=(.*?)\](.*?)\[\/color\]/is' => '<span style="color: $1;">$2</span>',

'/\[img\](.*?)\[\/img\]/is' => '<img src=$1 alt=$1 />',

'/\[player\](.*?)\[\/player\]/is' => '<a href='.$server['ip'].'index.php?subtopic=characters&name=$1>$1</a>',

'/\[code\](.*?)\[\/code\]/is' => '<div dir="ltr" style="margin: 0px;padding: 2px;border: 1px inset;width: 500px;height: 290px;text-align: left;overflow: auto"><code style="white-space:nowrap">$1</code></div>'

);

$message = preg_replace(array_keys($BB), array_values($BB), nl2br($row['post_text']));

$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/icon_'.$row['icon_id'].'_big.gif" class="NewsHeadlineIcon" />

<div class="NewsHeadlineDate">'.date('j M Y', $row['post_date']).' - </div>

<div class="NewsHeadlineText">'.$row['post_topic'].'</div>

</div>

</div>

<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'><tr>

<td><img src="'.$layout_name.'/images/global/general/blank.gif" width=10 height=1 border=0 alt=\'\' /></td>';

if($group_id_of_acc_logged >= $config['site']['access_admin_panel'])

{

$main_content .='<td width="100%">'.$message.'<br><p align="right"><a href="index.php?subtopic=forum&action=remove_post&id='.$row['id'].'"><font color="red">[Delete this news]</font></a> <a href="index.php?subtopic=forum&action=edit_post&id='.$row['id'].'"><font color="green">[Edit this news]</font></a>';

}

else

{

$main_content .='<td width="100%">'.$message.'<br /><br />';

}

$main_content .= '</td>

<td><img src="'.$layout_name.'/images/global/general/blank.gif" width=10 height=1 border=0 alt=\'\' /></td>

</tr></table>';

}

?>

Editado Abril 22 por kk44

grilado13RAWRGCampones

info

Grupo: Campones

Registrado: 20/01/11

Posts: 75

Reputação: +41

23 de abril de 2014 às 00:25

SELECT * FROM `announcements` WHERE id ORDER BY `date` DESC LIMIT 1

Coloque isso no seu banco de dados (otserv, theforgottenserver, etc) e veja há alguma resposta

VictorWEBMaster<?PHP print ("Hello xTibia"); ?>VMarquês

info

Grupo: Marquês

Registrado: 26/02/12

Posts: 1.1k

Reputação: +369

Gênero: Masculino

Char no Tibia: Tibjohiand Tito

24 de abril de 2014 às 16:51

SELECT * FROM `announcements` WHERE id ORDER BY `date` DESC LIMIT 1
Coloque isso no seu banco de dados (otserv, theforgottenserver, etc) e veja há alguma resposta

É isso mesmo.

Duvida sanada?