Admin\n";
$id=$_GET['id'];
$mode=$_GET['mode'];
if ($id=="clear"){
session_destroy();
}
if (is_member_moderator($_SESSION['user'],$handle)==false){
die ("You do not have admin or moderator position on this forum.");
}
if($mode=="owner"){
if(is_numeric($id)==false)
die("Value is not numeric!ie: admin.php?mode=owner&id=MODID");
$res = mysql_query("SELECT * FROM mods WHERE mod_id=$id",$handle) or SQLerror("MySQL Query Error","Error on searching database.mods.mod_id for '$id'");
$hash = mysql_fetch_assoc($res);
echo "
Change owner of '{$hash['name']}'
\n";
$owner=$_POST['owner'];
$ov=$_POST['override'];
$message="Change the owner of the entry {$hash['name']}";
if (!$owner==""){
$user = mysql_real_escape_string ($owner);
$ur = mysql_query("SELECT * FROM users WHERE name='$user'",$handle);
if (mysql_num_rows($ur)<1){
if ($ov==false){
$message="User '$owner' does not exist";
}else{
addUser($user,"temp_pass","temp_pass","temp@email.co.uk",$handle);
$ur = mysql_query("SELECT * FROM users WHERE name='$user'",$handle);
$user = mysql_fetch_array($ur);
$ow_id=$user['id'];
mysql_query("UPDATE mods SET owner=$ow_id WHERE mod_id=$id",$handle)or die("error on setting owner");
header("location: viewmod.php?id=$id");
}
}else{
$user = mysql_fetch_array($ur);
$ow_id=$user['id'];
mysql_query("UPDATE mods SET owner=$ow_id WHERE mod_id=$id",$handle)or die("error on setting owner");
header("location: viewmod.php?id=$id");
}
}
$q=0;
$q = mysql_query("SELECT * FROM users WHERE id=".$hash['owner']);
if ($q){
echo "";
$qr = mysql_fetch_array($q) or print("");
$qr=$qr['name'];
}else{
echo "";
$qr = $hash['owner'];
}
echo "$message
";
}else if ($mode=="likes"){
echo "starting script...
\n";
$starttime = microtime(true);
$res = mysql_query("SELECT * FROM mods",$handle) or SQLerror("MySQL Query Error","Error on searching database.mods.tags for '$query'");
while ($hash = mysql_fetch_assoc($res)){
updateLikes($hash['mod_id'],$handle);
}
$endtime = microtime(true);
$duration = $endtime - $starttime; //calculates total time taken
echo "script completed in $duration seconds";
}else if ($mode=="clean_users"){
$res = mysql_query("SELECT * FROM users",$handle) or SQLerror("MySQL Query Error","Error on searching database.mods.tags for '$query'");
echo "starting script...
\n\n";
$starttime = microtime(true);
while ($hash = mysql_fetch_assoc($res)){
if (updateUser($hash['id'],$handle)==false){
echo "- deleting user: ".$hash['name']."
\n";
mysql_query("DELETE FROM users WHERE id=".$hash['id'],$handle);
}else{
echo "- updating user: ".$hash['name']."
\n";
}
}
$endtime = microtime(true);
$duration = $endtime - $starttime; //calculates total time taken
echo "
\nscript completed in $duration seconds\n";
}else{
?>Welcome to the admin console.