korhox
New Member
- Oct 31, 2013
- 4
- 1
Hello buddies!
I get this error on my "me"-page and every other page where is news.
and the file content:
AND, I've lost my Public rooms on my Habbo-retro (r63b). Can I download them somewhere?
Thank you
I get this error on my "me"-page and every other page where is news.
Code:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\tpl\class.forms.php on line 87
PHP:
while($news = mysql_fetch_array($data, MYSQL_ASSOC))
PHP:
<?php
namespace Revolution;
if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); }
class forms implements iForms
{
public $error;
final public function setData()
{
global $engine;
foreach($_POST as $key => $value)
{
if($value != null)
{
$this->$key = $engine->secure($value);
}
else
{
$this->error = 'Please fill in all fields';
return;
}
}
}
final public function unsetData()
{
global $template;
foreach($this as $key => $value)
{
unset($this->$key);
}
}
final public function writeData($key)
{
global $template;
echo $this->$key;
}
final public function outputError()
{
global $template;
if(isset($this->error))
{
echo "<div id='message'> " . $this->error . " </div>";
}
}
/* Manage different pages */
final public function getPageNews()
{
global $template, $engine;
if(!isset($_GET['id']) || !is_numeric($_GET['id']))
{
$_GET['id'] = 1;
}
$result = mysql_query("SELECT title, id FROM cms_news WHERE id != '" . $engine->secure($_GET['id']) . "' ORDER BY id DESC");
while($news1 = mysql_fetch_array($result))
{
$template->setParams('newsList', '« <a href="index.php?url=news&id='.$news1["id"].'">' . $news1['title'] . '</a><br/>');
}
$news = $engine->fetch_assoc("SELECT id, title, shortstory, longstory, author, published FROM cms_news WHERE id = '" . $engine->secure($_GET['id']) . "' LIMIT 1");
$template->setParams('newsID', $news['id']);
$template->setParams('newsTitle', $news['title']);
$template->setParams('newsContent', $news['longstory']);
$template->setParams('newsAuthor', $news['author']);
$template->setParams('newsDate', date("d-m-y", $news['published']));
unset($result);
unset($news1);
unset($news);
}
final public function getPageHome()
{
global $template, $engine;
$a = 1;
$data = mysql_query("SELECT title, id, published, shortstory, image FROM cms_news ORDER BY id DESC LIMIT 5");
while($news = mysql_fetch_array($data, MYSQL_ASSOC))
{
$template->setParams('newsTitle-' . $a, $news['title']);
$template->setParams('newsID-' . $a, $news['id']);
$template->setParams('newsDate-' . $a, date("d-m-y", $news['published']));
$template->setParams('newsCaption-' . $a, $news['shortstory']);
$template->setParams('newsIMG-' . $a, $news['image']);
$a++;
}
unset($news);
unset($data);
}
}
?>
AND, I've lost my Public rooms on my Habbo-retro (r63b). Can I download them somewhere?
Thank you