09 Personal Shitlist Mod

Started by Mindless, July 21, 2012, 10:00:21 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.




Hi :)
my staff wanted a function like this, so I threw it together last night...

problem: sure we do have a watched members thing, but it can get pretty big and unruly, so our staff wanted a more "personal Sh*t List" so they could keep track of the members they wanted to keep their eyes on personally...
solution: the personal Sh*t list for staff :D

simple tool, and little skill is needed to add it to your site...


simple to add to the list
a space for making notes about the member
a Sh*t-o-meter scale so you can set the level of sh*ttynes of the member (and the worst are at the top of the page)
some simple info on the main page like when joined, when added to the list, last seen
one button to remove them from the list
one button to PM the member
a nice layout completely stolen from the friends code :pardon:
you could add it anywhere... forums, comments etc. but I think the userdetails page is fine :)
and I'm sure you have it, I think it's default, but just in case I'll add the pic... put it in /pic/smilies/shit.gif
hope ya like it :)

Credits to snuggles.
Xhtml Valid.

This mod is the Shitzs - excuse the pun  :lol:

Run the sql :

Code (sql) Select

CREATE TABLE `shit_list` (
  `userid` int(10) unsigned NOT NULL default '0',
  `suspect` int(10) unsigned NOT NULL default '0',
  `shittyness` int(2) unsigned NOT NULL default '0',
  `added` int(11) NOT NULL default '0',
  `text` text collate utf8_unicode_ci,
  PRIMARY KEY  (`userid`)

Save and upload shit_list.php to root :

Code (php) Select
require_once "include/bittorrent.php";
//parked(); //=== uncomment if using parked mod

$lang array_mergeload_language('global'));


if (
$CURUSER['class'] < UC_MODERATOR//=== change to minimum staff level
stderr('Error''I smell a rat!');

//=== Check if action is sent (either $_POST or $_GET) if so make sure it's what you want it to be
$action = (isset($_GET['action']) ? $_GET['action'] : (isset($_POST['action']) ? $_POST['action'] : ''));
$good_stuff = array('new','add','delete');
$action = (($action && in_array($action,$good_stuff,true)) ? $action '');

//=== Action: new
if ($action == 'new'){
$shit_list_id $_GET['shit_list_id'];
$return_to htmlspecialchars($_GET['return_to']);
 if (!
stderr('Error''Invalid ID');
$res_name mysql_query("SELECT username FROM users WHERE id=".sqlesc($shit_list_id)) or sqlerr(__FILE____LINE__);
$arr_name mysql_fetch_assoc($res_name);
$check_if_there mysql_query("SELECT suspect FROM shit_list WHERE userid=$CURUSER[id] AND suspect=".sqlesc($shit_list_id)) or sqlerr(__FILE____LINE__);
 if (
mysql_num_rows($check_if_there) == 1)
stderr('Error''The member '.$arr_name['username'].' is already on your shit list!');
$level_of_shittyness .= "<select name='shittyness'><option value='0'>level of shittyness</option>";
$i 1;
$i <= 10){
$level_of_shittyness .= "<option value='".$i."'>".$i." out of 10</option>";
$i $i 1;
$level_of_shittyness .= "</select>";
$HTMLOUT.="<h1><img src='pic/smilies/shit.gif' alt='Shit' title='Shit' />Add ".$arr_name['username']." to your Shit List<img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /></h1><form method='post' action='?action=add'><table><tr><td class='colhead' colspan='2'>new</td></tr>".
"<tr><td align='right' valign='top'><b>Shittyness:</b></td><td align='left' valign='top'>".$level_of_shittyness." just how shitty is this member?<br /><br />".
"<img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /><img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /><img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /><img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /><img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /><img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /><img src='pic/smilies/shit.gif' alt='Shit' title='Shit' />".
" out of 10, 1 being not so shitty, 10 being really shitty... Please select one.</td></tr>".
"<tr><td align='right' valign='top'><b>Reason:</b></td><td align='left' valign='top'><textarea cols='60' rows='5' name='text'></textarea></td></tr>".
"<tr><td align='right' valign='top'><input type='hidden' name='shit_list_id' value='".$shit_list_id."' /><input type='hidden' name='return_to' value='".$return_to."' /></td></tr>".
"<tr><td align='center' colspan='2'><input class='button' type='submit' value='add this shit bag!' /></td></tr></table></form>";
stdhead('Shitlist'false) . $HTMLOUT stdfoot();


//=== Action: add 
if ($action == 'add'){
$shit_list_id $_POST['shit_list_id'];
$shittyness $_POST['shittyness'];
$return_to htmlspecialchars($_POST['return_to']);
  if (!
is_valid_id($shit_list_id) || !is_valid_id($shittyness))
stderr('Error''Invalid ID');
  if (
$shit_list_id == $CURUSER["id"])
stderr("Error","Cant add yerself");
$check_if_there mysql_query("SELECT suspect FROM shit_list WHERE userid=$CURUSER[id] AND suspect=".sqlesc($shit_list_id)) or sqlerr(__FILE____LINE__);
  if (
mysql_num_rows($check_if_there) == 1)
stderr('Error''That user is already on your shit list.');
mysql_query("INSERT INTO shit_list VALUES ($CURUSER[id],".sqlesc($shit_list_id).", ".sqlesc($shittyness).", ".sqlesc(time()).", ".sqlesc($_POST['text']).")") or sqlerr(__FILE____LINE__);
$message "<h1>Success! Member added to your personal shitlist!</h1><br /><a class='altlink' href='".$return_to."'>go back to where you were?</a><br />";

//=== Action: delete 
elseif ($action == 'delete'){
$shit_list_id $_GET['shit_list_id'];
  if (!
$res_name mysql_query("SELECT username FROM users WHERE id=".sqlesc($shit_list_id)) or sqlerr(__FILE____LINE__);
$arr_name mysql_fetch_assoc($res_name);
$sure = (int)isset($_GET['sure']) && (int) $_GET['sure'];
  if (!
stderr('Delete '.$arr_name['username'].' from shit list','Do you really want to delete <b>'.$arr_name['username'].'</b> from your shit list? <br /><a class="altlink" href="?action=delete&amp;shit_list_id='.$shit_list_id.'&amp;sure=1">here</a> if you are sure.');
mysql_query("DELETE FROM shit_list WHERE userid=$CURUSER[id] AND suspect=".sqlesc($shit_list_id)) or sqlerr(__FILE____LINE__);
if (mysql_affected_rows() == 0)
stderr('Error''No member found to delete!');
$message "<h1>Success! <b>".$arr_name['username']."</b> deleted from your shit list!</h1>";

//=== Default page
$HTMLOUT .= $message."<br />
 <table width='750' border='0' cellspacing='0' cellpadding='0'>
 <tr><td class='colhead' align='center' valign='top'>
 <h1>Shit List for "
"<img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /> shittiest at the top 
 <img src='pic/smilies/shit.gif' alt='Shit' title='Shit' /></td></tr>"
"<tr><td class='embedded'>
 <table width='750' border='1' cellspacing='0' cellpadding='5'><tr><td>"

$i 0;
$res mysql_query("SELECT s.suspect as id, s.text, s.shittyness, s.added AS shit_list_added, u.username AS name, u.id, u.username, u.added, u.class, u.avatar, u.donor, u.warned, u.enabled, u.last_access FROM shit_list AS s LEFT JOIN users as u ON s.suspect = u.id WHERE userid=$CURUSER[id] ORDER BY shittyness DESC") or sqlerr(__FILE____LINE__);
mysql_num_rows($res) == 0)
$shit_list "<p align='center'>Your shit list is empty.</p>";
 while (
$shit_list mysql_fetch_array($res)){
$class_name get_user_class_name($shit_list['class']);
$poop 1;
 while (
$poop <= $shit_list['shittyness']):
$shit .= "<img src='pic/smilies/shit.gif' alt='".$shit_list['shittyness']."' title='".$shit_list['shittyness']." out of 10 on the Shittyness scale' />";
$main "<a class='altlink' href='userdetails.php?id=".$shit_list['id']."'><b>".$shit_list['name']."</b></a>".
get_user_icons($shit_list)."<b> [ ".$class_name." ]</b> ".$shit."<br /><b>Joined : </b>  [ ".get_date($shit_list['added'], 'DATE',0,1)." ]".
"<br /><b>Added to shit list : </b>[ ".get_date($shit_list['shit_list_added'], 'DATE',0,1)." ]<br />".
"<b>Last seen : </b>[ ".get_date($shit_list['last_access'], 'DATE',0,1)." ]<hr />".format_comment($shit_list['text']);
$buttons ="<br /><a class='altlink' href='?action=delete&amp;shit_list_id=".$shit_list['id']."'>Remove</a>"."<br /><br /><a class='altlink' href='sendmessage.php?receiver=".$shit_list['id']."'>PM</a>";
$avatar = (!$shit_list['avatar'] ? "pic/default_avatar.gif" htmlspecialchars($shit_list['avatar']));
$avatar = ($CURUSER['avatars'] == "yes" $avatar "");
$HTMLOUT .=(($i == 0) ? "<table width='100%'><tr><td width='50%' align='center'>" "<td width='50%' align='center'>");
$HTMLOUT .="<table width='100%'><tr valign='top'>
 <td width='80' align='center' valign='top'>"
.($avatar "<img width='80px' src=".$avatar.">" "")."</td>
 <td><table width='420'><tr><td class='embedded'>"
"<td class='embedded' valign='top' align='center'>".$buttons."</td></tr>
$HTMLOUT .=(($i == 1) ? "</td></tr></table>" "</td>");
$shit '';
$HTMLOUT .=(($i == 1) ? "<td width='50%'>&nbsp;</td></tr></table>" "").$shit_list."</td></tr></table>".
"</td></tr></table><p align='center'><a class='altlink' href='users.php'><b>Find User/Browse User List</b></a></p>";
stdhead("Shit list for " $CURUSER['username']) . $HTMLOUT stdfoot();

If you have others in your get_user_icons function remember to add those entrys to the user query on shit_list.php

Add this to userdetails.php where ever you want the link - i have mine just under the friends links

Code (php) Select
//== 09 Shitlist by Sir_Snuggles
    if ($CURUSER['class'] >= UC_MODERATOR){
    $shitty = '';
    $check_if_theyre_shitty = mysql_query("SELECT suspect FROM shit_list WHERE userid=$CURUSER[id] AND suspect=".$id) or sqlerr(__FILE__, __LINE__);
    if (mysql_num_rows($check_if_theyre_shitty) !== 0){
    $HTMLOUT .="<br /><b>This member is on your shit list click <a class='altlink' href='shit_list.php'>HERE</a> to see your shit list</b>";
    $shitty = "<img src='pic/smilies/shit.gif' alt='Shit' title='Shit' />";
    $HTMLOUT .="<br />".$shitty."&nbsp;<a class='altlink' href='shit_list.php?action=new&amp;shit_list_id=".$id."&amp;return_to=userdetails.php?id=".$id."'><b>Add member to your shit list</b></a>&nbsp;".$shitty."";

And thats all.