Codezwiz >> Forums >> General PHP Nuke Help >> can any one help me with this little piece of code?

Register

Hi guys need your help on this code to work, any assistance would be greatly appreciated. thanks in advance.

OpenTable();
$result9 = "SELECT uname FROM ".$prefix."_nsngr_users WHERE qid='3'";
$uname2 = $db->sql_query($result9);
$result = $db->sql_query("SELECT qid, uid, uname, subject, timestamp, alanguage FROM ".$prefix."_queue WHERE uname='$uname2' THEN order by timestamp DESC");
if($db->sql_numrows($result) == 0) {
echo "<table width=\"100%\"><tr><td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._NOSUBMISSIONSPLATINUM."</b></td></tr></table>\n";
} else {
echo "<center><font class=\"content\"><b>"._NEWSUBMISSIONSPLATINUM."</b></font><form action=\"".$admin_file.".php\" method=\"post\"><table width=\"100%\" border=\"1\" bgcolor=\"$bgcolor2\"><tr><td><b> "._TITLE." </b></td>";
if ($multilingual == 1) {
echo "<td><b><center> "._LANGUAGE." </center></b></td>";
}
echo "<td><b><center> "._AUTHOR." </center></b></td><td><b><center> "._DATE." </center></b></td><td><b><center> "._FUNCTIONS." </center></b></td></tr>\n";
while (list($qid, $uid, $uname, $subject, $timestamp, $alanguage) = $db->sql_fetchrow($result)) {
$qid = intval($qid);
$uid = intval($uid);
/*
$hour = "AM";
ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $timestamp, $datetime);
if ($datetime[4] > 12) { $datetime[4] = $datetime[4]-12; $hour = "PM"; }
$datetime = date(""._DATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
*/
echo "<tr>\n";
echo "<td width=\"100%\"><font class=\"content\">\n";
if ($subject == "") {
echo " <a href=\"".$admin_file.".php?op=DisplayStory&qid=$qid\">"._NOSUBJECT."</a></font>\n";
} else {
echo " <a href=\"".$admin_file.".php?op=DisplayStory&qid=$qid\">$subject</a></font>\n";
}
if ($multilingual == 1) {
if ($alanguage == "") {
$alanguage = _ALL;
}
echo "</td><td align=\"center\"><font size=\"2\"> $alanguage </font>\n";
}
if ($uname != $anonymous) {
echo "</td><td align=\"center\" nowrap><font size=\"2\"> <a href='userinfo-.html$uname'>$uname</a> </font>\n";
} else {
echo "</td><td align=\"center\" nowrap><font size=\"2\"> $uname </font>\n";
}
$timestamp = explode(" ", $timestamp);
echo "</td><td align=\"right\" nowrap><font class=\"content\"> $timestamp[0] </font></td><td align=\"center\"><font class=\"content\"> <a href=\"".$admin_file.".php?op=DeleteStory&qid=$qid\">"._DELETE."</a> </td></tr>\n";
$dummy++;
}
if ($dummy < 1) {
echo "<tr><td bgcolor=\"$bgcolor1\" align=\"center\"><b>"._NOSUBMISSIONS."</b></form></td></tr></table>\n";
} else {
echo "</table></form>\n";
}
}
if ($radminsuper==1) {
echo "<br><center>"
."[ <a href=\"".$admin_file.".php?op=subdelete\">"._DELETE."</a> ]"
."</center><br>";
}
CloseTable();

Well, what is it supposed to do, and what isn't working about it? Include more detail for faster help

Gareth

Register

Hi gareth,

the code is an extension of the admin section of submitted news. I want to separate the news submitted by the website staff from the reqular members. i used the nsn groups to separate the staff from regular members my problem is the table _queue doesnt have the "gid" row for which to identify if a member is one of my staff. So i have to pull the group id info from the table _nsngr_users and integerate it in the code and im having problems on how to properly call the mysql database and be able to just show the news submitted by my staff.

I hope i was able to explain it properly.

Its realy hard to tell with out seeing whats going on. I can tell you that when you pull the username it should be in a loop or you will only get one row of data.

$uname2 = $db->sql_query($result9);

Register

Hi Telli, nice to hear from you.

I have been trying to implement the code you advised me but i can seem to place the closing } in the right place all i get always is a blank page.

here is the original code of the news admin index i hope you could pinpoint where to place the additional code. Thanks thanks thanks telli.

I'll just attach the file......