Revcms Errors

[Sab]

mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\tpl\class.forms.php in line 87

and

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\app\tpl\skins\Custom-Habbo\includes\head.php on line 16

 

[Sledmore]

You expect us to know your error by this? You could at-least show us the queries from the files, also 'head.php' doesn't by default come w/ RevCMS.

 

[Sab]

It's in the custom-habbo/includes/head.

Line 16: $get2 = mysql_fetch_assoc($alertinfo);

 

[Legion]

What version of RevCMS is it?

 

[Wickd]

Change class.forms.php to this:
<?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', '&laquo; <a href="index.php?url=news&id='.$news1["id"].'">' . $news1['title'] . '</a><br/>');
}

$news = $engine->fetch_assoc("SELECT title, shortstory, longstory, author, date FROM cms_news WHERE id = '" . $engine->secure($_GET['id']) . "' LIMIT 1");
$template->setParams('newsTitle', $news['title']);
$template->setParams('newsContent', $news['longstory']);
$template->setParams('newsAuthor', $news['author']);
$template->setParams('newsDate', date("d-m-y", $news['date']));
$template->setParams('newsPreview', $news['shortstory']);

unset($result);
unset($news1);
unset($news);
}

final public function getPageHome()
{
global $template, $engine;
$a = 1;
$data = mysql_query("SELECT title, id, date, 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['date']));
$template->setParams('newsCaption-' . $a, $news['shortstory']);
$template->setParams('newsIMG-' . $a, $news['image']);
$a++;
}

unset($news);
unset($data);
}

}

?>

 

[bodge]

lol go into config add:

error_reporting(0);

under the opening php tag.