6
I am having a problem that deals with administratino script.
I went and looked at newbb and it uses "echo" statements in the administration page and some other functions so I copied off it. However when I got there the header/footer of admin panel are displayed but my data is not. Anyone know why?
le="color: #000000"><?php <? include '../../../include/cp_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); echo _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'"; echo _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'"; echo _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.index, $table.quote, $table.approved, $userdb.uname, from $table, $userdb order by $table.index desc WHERE $table.user_id = $userdb.uid"; $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"); echo "<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) { Echo "<form method="POST" action="">" ."<td width="64"><input type="submit" value="_MD_QM_APPROVE" name="Approve">" ."<input type="hidden" value="$qindex" name="$qindex">" ."</form>"; } echo "<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; } xoops_cp_footer(); ?>
