Thanks for the offcomment.php
and nevermind the error i posted before, i managed to debug the script and correct it.
Bump: @ rabtb: cheers!
Does the torrenttable in your browse.php have the same way to sort like your viewrequests.php, with this code?
if ($sort == "votes") $sort = " ORDER BY hits DESC"; elseif ($sort == "cat") $sort = " ORDER BY cat "; else if ($sort == "request") $sort = " ORDER BY request "; else if ($sort == "added") $sort = " ORDER BY added ASC"; else $sort = " ORDER BY added DESC"; list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, $_SERVER["PHP_SELF"] ."?" . "category=" . $_GET[category] .
"&sort=" . $_GET["sort"] . "&" ); print("<center>"); $res = mysql_query("SELECT users.downloaded, users.uploaded, users.username, requests.filled, requests.filledby, requests.id, requests.userid, requests.request, requests.added, requests.hits, requests.filledurl, categories.image, categories.name as cat FROM requests inner join categories on requests.cat = categories.id inner join users on requests.userid = users.id $categ $filter $search
$sort $limit") or sqlerr(__FILE__, __LINE__); $num = mysql_num_rows($res); print("<div align=center><form method=get action=viewrequests.php><select name=category><option value=0>(Show All)</option>"); echo $pagertop; ?> <script language = "Javascript"> <!-- var form='viewreq' function SetChecked(val,chkName) { dml=document.forms[form]; len = dml.elements.length; var i=0; for( i=0 ; i<len ; i++) { if (dml.elements[i].name==chkName) { dml.elements[i].checked=val; } } } // --> </script> <? print("<form method=post name=viewreq action=viewrequests.php?staff_delete=1 onSubmit=\"return ValidateForm(this,'delreq')\">". "<table border=1 width=100% cellspacing=0 cellpadding=5><tr><td class=colhead align=left width=50><a class=altlink href=". $_SERVER[PHP_SELF] ."?category=" . (int)$_GET[category] . "&filter=" . $_GET[filter] .
"&sort=cat>Type</a></td>". "<td class=colhead align=center><a class=altlink href=". $_SERVER[PHP_SELF] ."?category=" . (int)$_GET[category] . "&filter=" . $_GET[filter] .
"&sort=request>Name</a></td>". "<td class=colhead align=center width=150><a class=altlink href=" . $_SERVER[PHP_SELF] ."?category=" . (int)$_GET[category] . "&filter=" . $_GET[filter] .
"&sort=added>Added</a></td>". "<td class=colhead align=center>Requested by</td><td class=colhead align=center>Filled?</td><td class=colhead align=center>Filled By</td>". "<td class=colhead align=center><a class=altlink href=" . $_SERVER[PHP_SELF] . "?category=" . (int)$_GET[category] . "&filter=" . $_GET[filter] .
"&sort=votes>Votes</a></td>");
Bump:
Quote:
|
Your Offer has been voted on. you are allowed to upload "blah blah blah". You will find a new option on the upload page.
|
so, i guess i missed something to put at upload.php
anyone can help?