request mod for tbv 08
hello im looking for a request mod any one help with this as ive made a 08 site and need a request mod to complate the code will post the fully mod to blist when done it as it is nearly fully mod:drink:
rabtb
27th November 2012 22:41
think i got it all anything missing lemme know
SQL
Code:
CREATE TABLE IF NOT EXISTS `requests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`request` varchar(225) DEFAULT NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`hits` int(10) unsigned NOT NULL DEFAULT '0',
`cat` int(10) unsigned NOT NULL DEFAULT '0',
`filledby` int(10) unsigned NOT NULL DEFAULT '0',
`filledurl` varchar(70) DEFAULT NULL,
`filled` enum('yes','no') NOT NULL DEFAULT 'no',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `id_added` (`id`,`added`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1461 ;
viewrequests.php
Code:
require_once("include/bittorrent.php");
dbconn(false);
loggedinorreturn();
parked(); //=== uncomment if you use the parked mod
function bark($msg) {
stdhead("Requests Error");
stdmsg("Error!", $msg);
stdfoot();
exit;
}
if ($_GET["category"]){
$categ = isset($_GET['category']) ? (int)$_GET['category'] : 0;
if(!is_valid_id($categ))
stderr("Error", "I smell a rat!");
}
if ($_GET["requestorid"]){
$requestorid = 0 + htmlentities($_GET["requestorid"]);
if (ereg("^[0-9]+$", !$requestorid))
stderr("Error", "I smell a rat!");
}
if ($_GET["id"]){
$id = 0 + htmlentities($_GET["id"]);
if (ereg("^[0-9]+$", !$id))
stderr("Error", "I smell a rat!");
}
//==== add request
if ($_GET["add_request"]){
$add_request = 0 + $_GET["add_request"];
if($add_request != '1')
stderr("Error", "I smell a rat!");
stdhead("Requests Page");
if (get_user_class() < UC_LIGHT_WEIGHT) //=== requests for VIP and above
{
begin_frame("Sorry",true);
print("
Oups!
You must be VIP or above AND have a ratio above 1.0 to make a request. Please see the ".
"FAQ for more information on different user classes and what they can do.
" .$SITENAME." staff");
die();
}
//=== only allow users with a ratio of at least .5 who have uploaded at least 10 gigs or VIP and above
if ($CURUSER)
{
// ratio as a string
function format_ratio($up,$down, $color = True)
{
if ($down > 0)
{
$r = number_format($up / $down, 2);
if ($color)
$r = "$r";
}
else
if ($up > 0)
$r = "'Inf.'";
else
$r = "'---'";
return $r;
}
if ($CURUSER["class"] < UC_LIGHT_WEIGHT)
{
$gigsdowned = ($CURUSER["downloaded"]);
if ($gigsdowned >= 10737418240){
$gigs = $CURUSER["uploaded"] / (1024*1024*1024);
$ratio = (($CURUSER["downloaded"] > 0) ? ($CURUSER["uploaded"] / $CURUSER["downloaded"]) : 0);
}
}
//=== use this if you are using the Karma point system
/*begin_frame("Request Rules",true);
print("To make a request you must have a ratio of at least 1.0 AND have uploaded at least 10 GB.".
" A request will also cost you 5 Karma Points.... In your particular case ".
"" . $CURUSER['username'] . ", ");
*/
//=== use this if you are NOT using the Karma point system
begin_frame("Request Rules",true);
print("To make a request you must have a ratio of at least 1.0 AND have uploaded at least 10 GB. ".
"In your particular case " . $CURUSER['username'] . ", ");
//===karma //=== uncomment this bit if you are using the karma system
/*
if ($CURUSER["seedbonus"] <5.0)
print("you do not have enough Karma Points ...".
" you can not make requests.
\n");
//===end
*/
//=== if you are using the karma mod change this next line too
//elseif ($gigsupped < 10737418240)
if ($gigsupped < 10737418240)
print("you have not yet uploaded 10 GB... you can not make requests.
//=== added edit request
if ($_GET["edit_request"]) {
$edit_request = 0 + $_GET["edit_request"];
if($edit_request != '1')
stderr("Error", "I smell a rat!");
$id = 0+$_GET["id"];
$res = mysql_query("SELECT *,UNIX_TIMESTAMP(added) as utadded FROM requests WHERE id = $id") or sqlerr(__FILE__, __LINE__);
$num = mysql_fetch_array($res);
//$timezone = display_date_time($num["utadded"] , $CURUSER[tzoffset] ); //=== use this line if you have timezone mod
$timezone = get_date_time($num["utadded"]);
$s = $num["request"];
$id2 = $num["cat"];
if ($CURUSER["id"] != $num["userid"] && get_user_class() < UC_MODERATOR)
stderr("Error!", "This is not your Request to edit.");
$request = sqlesc($s);
$body = htmlspecialchars(unesc($num["descr"]));
$res2 = mysql_query("SELECT name FROM categories WHERE id=$id2")or sqlerr(__FILE__, __LINE__);
$num2 = mysql_fetch_array($res2);
$name = $num2["name"];
$s2 = "\n";
" : "") . ($row["warned"] == "yes" ? "