1
I get an error on a admin page of a module i made. This is my first module and the admin section is giving me trouble. Once i turned on the php debug I get the error
Quote:
Fatal error: Call to a member function on a non-object in /home/tamkin/public_html/redemptionmg/modules/qmagic/admin/index.php on line 102
Line 102 contains
$xoopsTpl->assign('quotes', $quotes);
Here is the entire code(minus begining and end tags and info):
$xoopsOption['template_main'] = 'quote_admin.html';
include ('admin_header.php');
xoops_cp_header();
$table = $xoopsDB->prefix('qmagic');
//check to see if there is a quote to be deleted
if (isset($_POST['Delete']))
{
$dindex = $_POST['qindex'];
$query = "DELETE FROM $table WHERE index='$dindex'";
$xoopsDB -> query($query);
$xoopsTpl->assign('message', _MD_QM_DELETED);
}
//checks to see if a quote needs approved
if (isset($_POST['Approve']))
{
$uindex = $_POST['qindex'];
$query = "UPDATE $table SET $table.approved = '1' WHERE index='$uindex'";
$xoopsTpl->assign('message', _MD_QM_APPROVED);
}
//checks to see if a quote needs updated
if (isset($_POST['S1']))
{
$uindex = $_POST['qindex'];
$quote = $_POST['S1'];
$query = "UPDATE $table SET $table.quote = '$quote' WHERE index='$uindex'";
$xoopsTpl->assign('message', _MD_QM_UPDATED);
}
//gets all the quotes and lines them up with the user names of the submitters
$userdb = $xoopsDB->prefix('users');
$query = "SELECT $table.qid, $table.quote, $userdb.uname FROM $table, $userdb WHERE $table.uid = $userdb.uid AND $table.approved = 0 ORDER by $table.qid desc";
$result = $xoopsDB -> query($query);
//$R = mysql_num_rows($result);
$R = $xoopsDB -> getRowsNum($result);
$i = 0;
while ($i < $R) {
@$qaprove=mysql_result($result,$i,"approved");
@$qindex=mysql_result($result,$i,"index");
@$qcontent=mysql_result($result,$i,"quote");
@$quser_name=mysql_result($result,$i,"uname");
$quotes = $quotes."<table border="1" width="552" height="1">"
."<tr>"
."<form method="POST" action="">"
."<td width="63" height="1"><input type="submit value="_MD_QM_DELETE" name=Delete"></td>"
."<input type="hidden" value="$qindex" name="$qindex">"
."</form>";
if ($qaprove = 0)
{
$quotes = $quotes."<form method="POST" action="">"
."<td width="64"><input type="submit" value="_MD_QM_APPROVE" name="Approve">"
."<input type="hidden" value="$qindex" name="$qindex">"
."</form>";
}
$quotes = $quotes."<td width="160" height="1">"
."User: $quser_name"
."</td>"
."</tr>"
."</table>"
."<form method="POST" action="">"
."<p><textarea rows="5" name="S1" cols=50" value="$qcontent"></textarea></p>"
."<input type="hidden" value="$qindex" name="$qindex">"
."</form>";
++$i;
}
$xoopsTpl->assign('quotes', $quotes);
xoops_cp_footer();
I don't know what the problem is...
