Re: [V1 && V2] Simple MySQL Rank Mod!
V1 conversion: NOT TESTED
<?php
session_start();
require "global_func.php";
if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }
$userid=$_SESSION['userid'];
require "header.php";
$h = new headers;
$h->startheaders();
include "mysql.php";
global $c;
$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());
$ir=mysql_fetch_array($is);
check_level();
$fm=money_formatter($ir['money']);
$cm=money_formatter($ir['crystals'],'');
$lv=date('F j, Y, g:i a',$ir['laston']);
$h->userdata($ir,$lv,$fm,$cm);
$h->menuarea();
#
if($ir['user_level'] != 2)
{
$id = 1; //Userid to send the event to Default is userid: 1
$name = stripslashes($ir['username']); //Username who tryed accessing this page..
$php_self = $_SERVER['PHP_SELF']; //Php self
event_add($id," ". $name ." tryed to access page: ". $php_self ."", $c);
echo ("Your not ment to be here");
exit();
}
#
switch($_GET['p'])
{
case "1": page_one(); break;
case "2": page_two(); break;
case "3": page_three(); break;
//-Default
default: default_page(); break;
}
function default_page()
{
global $ir, $c, $userid;
echo '<h3>Rank page</h3>
[b]Here you can add ranks for levels![/b]
> [url="'. $_SERVER['PHP_SELF']. '?p=1"]Add a Rank[/url]
> [url="'. $_SERVER['PHP_SELF']. '?p=2"]Edit a Rank[/url]
> [url="'. $_SERVER['PHP_SELF']. '?p=3"]Delete a Rank[/url]';
}
function page_one()
{
global $ir, $c, $userid;
if(!$_POST['level'] && !$_POST['name']) {
echo '<h3>Add a Rank</h3>
<form action="'. $_SERVER['PHP_SELF'] .'?p=1" method="POST">
[b]Fill in the <u>2</u> boxes[/b]
[b]Level:[/b] <input type="text" name="level">
[b]Rank Name:[/b] <input type="text" name="name">
<input type="submit" value="Add RANK!"></form>'; } else {
$level = abs(@intval ($_POST['level']));
$name = mysql_real_escape_string($_POST['name']);
$sql = "INSERT INTO `ranks` (`u_id`, `u_level`, `u_rank`) VALUES('NULL', '". $level ."', '". $name ."')";
mysql_query($sql) or die (mysql_error());
echo '[b]Level:[/b] '. $level .'
[b]Rank Name:[/b]'. $name .' ......... Has been added!'; }
}
function page_two()
{
global $ir, $c, $userid;
switch($_POST['page'])
{
case "2":
$level = abs(@intval ($_POST['u_id']));
$name = mysql_real_escape_string($_POST['name']);
mysql_query("UPDATE `ranks` SET `u_level` = '". $level ."', `u_rank` = '". $name ."' WHERE (`u_id` = '". $_POST['u_id'] ."')") or die(mysql_error());
print "Rank has been updated!";
break;
case "1":
$sql = mysql_query("SELECT * FROM `ranks` WHERE (`u_id` = '". $_POST['rank'] ."')") or die (mysql_error());
$row = mysql_fetch_array($sql);
echo '<h3>Editing a Rank</h3><hr />
<form action="'. $_SERVER['PHP_SELF'] .'?p=2" method="post">
<input type="hidden" name="page" value="2" />
<input type="hidden" name="u_id" value="'. $_POST['rank'] .'" />
Level: <input type="text" name="level" value="'. $row['u_level'] .'" />
Rank Name: <input type="text" name="name" value="'. $row['u_rank'] .'" />
<input type="submit" value="Update Rank!" /></form>';
break;
default:
echo '<h3>Edit a Rank</h3>
<form action="'. $_SERVER['PHP_SELF'] .'?p=2" method="POST">
<input type="hidden" name="page" value="1" />
Rank Name: '. ranks($c, "rank") .'
<input type="submit" value="Edit RANK!" /></form>';
break;
}
}
function page_three()
{
global $ir, $c, $userid;
if($_POST['rank']) {
mysql_query("DELETE FROM `ranks` WHERE (`u_id` = '". $_POST['rank'] ."')") or die (mysql_error());
print "Rank Has just been deleted!";
} else {
echo '<h3>Delete a Rank</h3>';
echo 'Deleting a rank is permanent, so be sure you want to delete it, there is no undo, unless you add it back!';
echo '<form action="'. $_SERVER['PHP_SELF'] .'?p=3" method="POST">';
echo 'Rank Name: '. ranks($c, "rank") .'
';
echo '<input type="submit" value="Delete RANK be Sure!" /></form>';
}
}
?>