[Warning system by Demonas (aka snapsas). Version: v1.1.]
[Tested on PHP-Fusion v6.01.13]




[Installation:]

[copy all files (profile.php if it's already been modified) to your ftp]

[Go to Custom pages admin and insert this code:]


<?php
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."warnings");
$result = dbquery("CREATE TABLE ".$db_prefix."warnings (
user_id smallint(5) unsigned NOT NULL default '0',
warning_number smallint(1) NOT NULL DEFAULT '0',
give_user smallint(5) NOT NULL default '0',
couse text NOT NULL
) TYPE=MyISAM;");
?>


[Press [Preview Page] BUT DONT SAVE THE PAGE!]






[if in your site profile.php file have already been modified you will not need to
copy these files to your ftp. You will ned to take these steps:]



open profile.php and find:


include LOCALE.LOCALESET."user_fields.php";


below it:



//warns\\
if (file_exists(LOCALE.LOCALESET."warns.php")) {
	include LOCALE.LOCALESET."warns.php";
} else {
	include LOCALE."English/warns.php";
}
$result2=dbquery("SELECT tw.*, tu.user_id,user_name FROM ".$db_prefix."warnings tw
LEFT JOIN ".$db_prefix."users tu ON tw.give_user=tu.user_id WHERE tw.user_id='$lookup' ORDER BY warning_number ASC");
if (dbrows($result2)) {
$warns=dbrows($result2);
} else {$warns='0'; }
//------\\







find:






</table>
</td>
<tr>
<td align='center' width='150' rowspan='5' class='tbl2'>\n";





below it:






//show warns
		if ($data['user_level'] == 101) {
echo "<img src='".IMAGES."warns/$warns.gif' alt='".$locale['warns_04']." $warns ".$locale['warns_05']."' title='".$locale['warns_04']." $warns ".$locale['warns_05']."' border='0' style='padding-bottom:5px;'><br>";
}
//







find:






<td class='tbl2'>".($data['user_yahoo'] ? $data['user_yahoo'] : $locale['u048'])."</td>
</tr>
</table>\n";





change to:





<td class='tbl2'>".($data['user_yahoo'] ? $data['user_yahoo'] : $locale['u048'])."</td>
</tr>\n";

//warns\\
if (!isset($warn)) {
if (dbrows($result2)) {
echo "<tr>\n
<td colspan='3' class='tbl1'>";
while ($wdata=dbarray($result2)) {
echo "<img src='".IMAGES."warns/".$wdata['warning_number'].".gif' alt='' border='0'>| <a href='profile.php?lookup=".$wdata['user_id']."' class='side'><b>".$wdata['user_name']."</b></a>".($wdata['couse'] ? ": ".$wdata['couse'] : "")."<br>";
}
echo "</td>\n</tr>";
}
} else {
if (checkrights("M")) {
echo "<tr>\n
<td colspan='3' class='tbl1' align='center'>
<form name='submitform' method='post' action='".FUSION_SELF."?lookup=$lookup'>
".$locale['warns_11']." <input type='textbox' class='textbox' name='priezastis'>&nbsp;
<input type='submit' class='button' name='warn' value='".$locale['warns_07']."'>
</form>
</td>";
}
}
//----------\\
echo "</table>\n";

	//warns start
	if (checkrights("M")) {
	//give warn
	if ($_POST['warn']) {
	$warnnumb=$warns+1;
	$priezastis=stripinput($_POST['priezastis']);
	$result = dbquery("INSERT INTO ".$db_prefix."warnings (user_id, warning_number, give_user, couse) VALUES ('$lookup','$warnnumb','".$userdata['user_id']."','$priezastis')");
	if ($warns == "4") { $result=dbquery("UPDATE ".$db_prefix."users SET user_status='1' WHERE user_id='$lookup'"); }
	redirect(FUSION_SELF."?lookup=$lookup");
	}
	//unwarn
	if ($_POST['unwarn']) {
	$result = dbquery("DELETE FROM ".$db_prefix."warnings WHERE warning_number='$warns' AND user_id='$lookup'");
	redirect(FUSION_SELF."?lookup=$lookup");
	}
	//delete user
	if ($_POST['delete']) {
		$result = dbquery("DELETE FROM ".$db_prefix."users WHERE user_id='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."articles WHERE article_name='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."comments WHERE comment_name='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."messages WHERE message_to='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."messages WHERE message_from='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."news WHERE news_name='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."poll_votes WHERE vote_user='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."ratings WHERE rating_user='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."shoutbox WHERE shout_name='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."threads WHERE thread_author='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."posts WHERE post_author='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."thread_notify WHERE notify_user='$lookup'");
		$result = dbquery("DELETE FROM ".$db_prefix."warnings WHERE user_id='$lookup'");
	redirect("index.php");
	}
	//ban
		if ($_POST['ban']) {
	$result = dbquery("UPDATE ".$db_prefix."users SET user_status=1 WHERE user_id='$lookup'");
	redirect(FUSION_SELF."?lookup=$lookup");
	}
	//unban
			if ($_POST['unban']) {
	$result = dbquery("UPDATE ".$db_prefix."users SET user_status=0 WHERE user_id='$lookup'");
	redirect(FUSION_SELF."?lookup=$lookup");
	}
	//form
	if ($data['user_status'] == 1) { $act = unban; $title = $locale['warns_02']; } else { $act = ban; $title = $locale['warns_01']; }
	tablebreak();
	echo "<table cellpadding='0' cellspadding='0' align='center' width='400' style='border: 1px solid #ccc;'><tr>";
	
	echo "<td class='tbl1'><form method='post' action='".ADMIN."members.php".$aidlink."&step=edit&user_id=$lookup'><input class='button' value='".$locale['warns_10']."' type='submit' name='edit' title='".$locale['warns_10']."'></form></td>";
	echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'><input class='button' value='$title' type='submit' name='$act' title='$title ".$locale['warns_09']."'  OnClick=\"if (confirm('".$locale['warns_06']."')) return true; else return false;\"></form></td>";
	echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'><input class='button' value='".$locale['warns_03']."' type='submit' name='delete' title='".$locale['warns_03']."' OnClick=\"if (confirm('".$locale['warns_06']."')) return true; else return false;\"></form></td>";
	
	
	
			//for admins
		if ($data['user_level'] == 101 && $data['user_status'] != 1) {
echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup&warn'>";
echo "<input type='submit' name='warning' value='".$locale['warns_07']."' class='button'>";
echo "</form></td>";
}
	if ($warns) {
echo "<td class='tbl1'><form method='post' action='".FUSION_SELF."?lookup=$lookup'>";
echo "<input type='submit' name='unwarn' value='".$locale['warns_08']."' class='button'>";
echo "</form></td>";
}
	
	
	echo "</tr></table>";
	}
	
	tablebreak();
	//warnings ends






find:





	} else {
		fallback(BASEDIR."index.php");
	}
}
closetable();





below it (optional):




//user sign
if ($data['user_sig']) {
opentable("Vartotojo Paraas");
echo "<center>".parseubb(parsesmileys($data['user_sig']))."</center>";
closetable();
}
//

//comments
include INCLUDES."comments_include.php";
	showcomments("U","users","user_id",$lookup,BASEDIR."profile.php?lookup=$lookup");
//






If You want to show user warnings in forum threads follow these steps:


open forum/viewthread.php

find:



		if ($data['user_avatar'] != "") {
			echo "<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$locale['567']."'><br><br>\n";
			$height = "185";
		} else {
			$height = "70";
		}





below it:





		//show warnings\\
		
if (file_exists(LOCALE.LOCALESET."warns.php")) {
	include LOCALE.LOCALESET."warns.php";
} else {
	include LOCALE."English/warns.php";
}
$warnings=dbquery("SELECT tw.*, tu.user_id,user_name FROM ".$db_prefix."warnings tw
LEFT JOIN ".$db_prefix."users tu ON tw.give_user=tu.user_id WHERE tw.user_id='".$data['user_id']."' ORDER BY warning_number ASC");
if (dbrows($warnings)) {
$warns=dbrows($warnings);
} else {$warns='0'; }
		
		if ($data['user_level'] == 101) {
echo "<img src='".IMAGES."warns/$warns.gif' alt='".$locale['warns_04']." $warns ".$locale['warns_05']."' title='".$locale['warns_04']." $warns ".$locale['warns_05']."' border='0'><br>";
}
		
		//--------\\



done :) enjoy the mod :)