########################################################
##
## Hack Title:		PM Limitation
## Hack Version:	1.1.0
## Author:		Christoph "Toxic" Hellings (toxic@freenet.de)
## Date Created:	09-02-02
## Date Updated:	09-02-02
## Thread Location:	http://www.tforumhacks.com/tforum/viewtopic.php?TopicID=1028
## Working Example:	
## Description:		User can't receive more PMs when their Inbox is full
##			the limit depends on the user level and can be set in admin area
##			
##			
## Installation Level:	Intermediate
## Installation Time:	10 Minutes
## Files To Edit:	3
## Edit Database:	yes
## Included Files:	none
##
########################################################
## 
## Installation/Author Notes:
##
##	I think it works but no warranty...
##	
##	UPGRADING INSTRUCTIONS 1.0.0 -> 1.1.0:
##	do all instructions for the database 
##	do all instructions for adminfunctions.php
##	do the 1st instruction for pm.php
##	delete the following line from pm.php:
##	$limit = 20;
##	END OF UPGRADING INSTRUCTIONS
##
########################################################
#
#-----[ ACTION: BACKUP ]------------------------------------------
#
	Every time you edit your files, you should always back them
	up first. Although all of these hacks have been tested on various
	systems, they may not work with your configuration or you may not
	like what it does. Backing up protects yourself and your users
	from downtime.
#
#-----[ ACTION:  EDIT DATABASE ]----------------------------------
#
ALTER TABLE t_UserLevel ADD PMlimit SMALLINT(5) UNSIGNED NOT NULL DEFAULT '20';
#
#-----[ ACTION:  OPEN ]-------------------------------------------
#
	admin_functions.php
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
	function ViewUserCat()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
			<td><b>Color</b></td>
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
			<td><b>PM Limit</b></td>
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
			<td align="center" width="100%" nowrap><?
				if ($row[textColor])
				{?><font color=<?echo $row[textColor]?>><?echo $row[textColor]?></font><?
				}
				else
				{	echo "N/A";
				}?></td>
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
			<td align="center" width="100%" nowrap><?echo $row[PMlimit]?></td>
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
			<td colspan=6>Power Definition:<br>1-Admin 2-SuperModerator 3-Senior 4-Normal 5-Junior</td>
		</tr>
		<tr>
			<td colspan=6>It should be noted that the default for any new user is 5.<BR>
#
#-----[ ACTION:  REPLACE ]----------------------------------------
#
			<td colspan=7>Power Definition:<br>1-Admin 2-SuperModerator 3-Senior 4-Normal 5-Junior</td>
		</tr>
		<tr>
			<td colspan=7>It should be noted that the default for any new user is 5.<BR>
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
function EditUserCat()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
{	global $fSettings,$UserCatID,$Submit,$Level,$textColor,$Icon,$PostNeed;
#
#-----[ ACTION:  REPLACE ]----------------------------------------
#
{	global $fSettings,$UserCatID,$Submit,$Level,$textColor,$Icon,$PostNeed,$PMlimit;
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
	{	$query = "UPDATE t_UserLevel set Level='$Level',textColor='$textColor',Icon='$Icon',PostNeed='$PostNeed' WHERE ID = $UserCatID";
#
#-----[ ACTION:  REPLACE ]----------------------------------------
#
	{	$query = "UPDATE t_UserLevel set Level='$Level',textColor='$textColor',Icon='$Icon',PostNeed='$PostNeed',PMlimit='$PMlimit' WHERE ID = $UserCatID";
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
	<tr valign="top">
		<td>Icon:</td>
		<td><input type="text" name="Icon" value="<?echo $row[Icon]?>" size=30 maxlength=125></td>
	</tr>
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
	<tr valign="top">
		<td>PM Limit:</td>
		<td><input type="text" name="PMlimit" value="<?echo $row[PMlimit]?>" size=30 maxlength=125></td>
	</tr>
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
	function AddUserCat()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
{	global $fSettings,$UserCatID,$Submit,$Level,$textColor,$Icon,$PostNeed;
#
#-----[ ACTION:  REPLACE ]----------------------------------------
#
{	global $fSettings,$UserCatID,$Submit,$Level,$textColor,$Icon,$PostNeed,$PMlimit;
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
	{	$query = "INSERT INTO t_UserLevel (Level,textColor,Icon,PostNeed) VALUES('$Level','$textColor','$Icon','$PostNeed')";
#
#-----[ ACTION:  REPLACE ]----------------------------------------
#
	{	$query = "INSERT INTO t_UserLevel (Level,textColor,Icon,PostNeed,PMlimit) VALUES('$Level','$textColor','$Icon','$PostNeed','$PMlimit')";
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
		<tr valign="top">
			<td>Color:</td>
			<td><input type="text" name="textColor" value="<?echo $row[textColor]?>" size=30 maxlength=125></td>
		</tr>
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
		<tr valign="top">
			<td>PM Limit:</td>
			<td><input type="text" name="PMlimit" value="<?echo $row[PMlimit]?>" size=30 maxlength=125></td>
		</tr>
#
#-----[ ACTION:  OPEN ]-------------------------------------------
#
	pm.php
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
	function ShowPM()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
		{ UhOh($txt['PMLogin']);}
		else
		{?><P>
#
#-----[ ACTION:  REPLACE ]----------------------------------------
#
		{ UhOh($txt['PMLogin']);}
		else
		{
			$query = "SELECT PMlimit FROM t_UserLevel WHERE ID='".$UserInfo["LevelID"]."'";
			$result=mysql_query($query);
			if ($row=mysql_fetch_array($result)) 
				$limit = $row[0];
			else
				$limit = 20;
		?><P>
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
	</tr><? $query = "SELECT * FROM t_pm WHERE ToUser='".AddSlash($username)."' ORDER BY Date DESC";
#
#-----[ ACTION:  REPLACE ]----------------------------------------
#
	</tr><? $query = "SELECT * FROM t_pm WHERE ToUser='".AddSlash($username)."' ORDER BY Date ASC LIMIT 0,$limit";
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
		<td><?echo FormatDate($row["Date"],$UserInfo["timezone"])." ".$txt['at']." ".FormatTime($row["Date"],$UserInfo["timezone"])?></td>
	</tr><?	}?>
</table></td></tr></table>
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
<?if (mysql_num_rows($result) == $limit) echo "<br><br><b>".$txt["PMInboxFull"]."</b><br><br>";?>
#
#-----[ ACTION:  OPEN ]-------------------------------------------
#
	english_lg.php
#
#-----[ ACTION:  ADD ]--------------------------------------------
#
$txt["PMInboxFull"] = "Your PM Inbox is full. Please delete some PMs to be able to receive new ones.";
#
#-----[ ACTION: SAVE & UPLOAD ]-----------------------------------
#
	admin_functions.php
	pm.php
	english_lg.php
#
#-----------------------------------------------------------------
#
EOF