And my solution to updates all needed is to fine tune and in a few days will have a bare system setup which unix can then make easy simple mods and upload it.
<?php
################################################## #############
# Script Title: "OGGS" Open graal guild management system
# File: admincontrol.php
# Description: This is a function is for guild admins only.
# Author: Benjamin Kerensa A.K.A. Nova
# Email:
[email protected]
# Web:
http://www.graalmessenger.com
# Version: 0.1
#
#
################################################## #############
if($action == "goback") { header("Location: update.php"); }
include('OGGSconfig.php');
include('checkuser.php');
if($user_logged_in == "0") { die("Hacking Attempt, Must enter through the roster system."); }
if($adminflag != "1") { die("Wrong access level."); }
$action = $HTTP_POST_VARS['action'];
if($action == "submitupdate") {
mysql_select_db($database, $mydb);
$query_submitup1 = "UPDATE roster SET name = '$name', last = '$last', rank = '$rank', level = '$level', epic = '$epic', lastupdate = '$date', magelo = '$magelo', charstatus = '$status' WHERE id = '$u_id'";
$submitup1 = mysql_query($query_submitup1, $mydb) or die(mysql_error());
$msgcode = "Character Updated";
}
if($action == "remove") {
mysql_select_db($database, $mydb);
$query_removechar1 = "DELETE FROM roster WHERE id = '$removecharid'";
$removechar1 = mysql_query($query_removechar1, $mydb) or die(mysql_error());
$msgcode = "Character Removed";
}
mysql_select_db($database, $mydb);
$query_Recordset1 = "SELECT roster.id, roster.name FROM roster";
$Recordset1 = mysql_query($query_Recordset1, $mydb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
if($action == "getupdate") {
mysql_select_db($database, $mydb);
$query_Recordset2 = "SELECT roster.id, roster.name, roster.last, roster.rank, roster.`level`, roster.epic, roster.magelo, roster.charstatus FROM roster WHERE roster.id = '$u_id' LIMIT 1";
$Recordset2 = mysql_query($query_Recordset2, $mydb) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
}
?>