[Chez]

Thanks -> Clickable thank you button by be4i
posted on tbdev.net on 30 July 2005 by Angel
modded by 9bz for nzbstrike


add to SQL :

PHP Code:

CREATE TABLE `thanks` (
    `nzbid` int(5) NOT NULL default '0',
    `userid` int(5) NOT NULL default '0',
    UNIQUE KEY `thanks` (`nzbid`,`userid`)
) 


make a thanks.php with this:

PHP Code:

<?
require_once("include/bittorrent.php");
dbconn();
loggedinorreturn();
/*
parked();
*/
$userid = $CURUSER["id"];
$nzbid = $_POST["nzbid"];
if (isset($userid) && isset($nzbid))
{
$res = mysql_query("INSERT INTO thanks (nzbid, userid) VALUES ($nzbid, $userid)");
header("Location: $BASEURL/nzbdetails.php?id=$nzbid&thanks=1");
}
else {
header("Location: $BASEURL/nzbbrowse.php");
}
hit_end()
?>

in details.php
find :

PHP Code:

print("</table></p>\n"); 


add above:

PHP Code:

$nzbid = $_GET["id"];
          $thanks_sql = mysql_query("SELECT * FROM thanks where nzbid=$nzbid");
    $thanks_all = mysql_numrows($thanks_sql);
    if ($thanks_all) {
    while($rows_t = mysql_fetch_array($thanks_sql)) {
    $thanks_userid = $rows_t["userid"];
    $user_sql = mysql_query("SELECT * FROM users where id=$thanks_userid");
    $rows_a = mysql_fetch_array($user_sql);
    $username_t = $rows_a["username"];
    $thanksby =  $thanksby."<a href='userdetails.php?id=$thanks_userid'>$username_t</a>, ";
    }
    $t_userid = $CURUSER["id"];
    $tsql = mysql_query("SELECT COUNT(*) FROM thanks where nzbid=$nzbid and userid=$t_userid");
    $trows = mysql_fetch_array($tsql);
    $t_ab = $trows[0];
    if ($t_ab == "0") {
    $thanksby = $thanksby." <form action=\"thanks.php\" method=\"post\">
<input type=\"submit\" name=\"submit\" value=\"Thanks!\">
<input type=\"hidden\" name=\"nzbid\" value=\"$nzbid\">
</form>";
    }
    else {
    $thanksby = $thanksby." <form action=\"thanks.php\" method=\"post\">
<input type=\"submit\" name=\"submit\" value=\"Thanks!\" disabled>
<input type=\"hidden\" name=\"nzbid\" value=\"$nzbid\">
</form>";
    }
    }
    else {
    $thanksby = "None yet 
    <form action=\"thanks.php\" method=\"post\">
<input type=\"submit\" name=\"submit\" value=\"Thanks!\">
<input type=\"hidden\" name=\"nzbid\" value=\"$nzbid\">
</form>
    ";
    }
        tr("Thanks by:",$thanksby,1); 


then find :

PHP Code:

 if ($_GET["uploaded"]) {
  print("<h2>Successfully uploaded!</h2>\n"); 


add after

PHP Code:

 }
        elseif ($_GET["rated"]) {
                print("<h2>Rating added!</h2>\n");
        }
        elseif ($_GET["thanks"])
                print("<h2>Thanks added!</h2>\n"); 


see how much Thanks
Add this in userdetails.php

PHP Code:

$tnxres = mysql_query("SELECT COUNT(*) FROM thanks WHERE userid = '$id'") or die(mysql_error());
$tnxarr = mysql_fetch_row($tnxres);
  $thanks = $tnxarr[0];
print("<tr><td class=rowhead>Thanks for nzbs</td><td align=left>$thanks</td></tr>\n"); 


after

PHP Code:

print("<tr><td class=rowhead>Class</td><td align=left>" . get_user_class_name($user["class"]) . "</td></tr>\n");