User '$new_name' was added with password '$new_pass', faction '$new_faction' and email '$new_mail'.
\n";
$new_name = ucwords($new_name);
$ad_name = ucwords($ad_name);
$fc = fopen("wizard_locked/actionlog.log", "a");
fwrite($fc, stripslashes(date("F d, Y T - H:i:s").": User '$new_name' added as level '$new_level' - $ad_name\n"));
fclose($fc);
return 1;
}
return 0;
}
function ChangePass($username, $password, $chatpath) {
global $handler;
if (CheckFlags("M", GetFlags($username, $chatpath))) {
echo "Nice try.";
return 0;
}
@count_mysql_query("UPDATE uo_chat_database SET password='".md5($password)."' WHERE chat='$chatpath' AND username='$username'", $handler);
$username = ucwords($username);
$fc = fopen("wizard_locked/actionlog.log", "a");
fwrite($fc, stripslashes(date("F d, Y T - H:i:s").": User '$username' changed password.\n"));
fclose($fc);
return 1;
}
function ChangePrefs($username, $password, $newpref, $nmail, $chatpath, $icq, $aim, $ym, $msn, $site, $skype='') {
global $handler;
if (VerifyLogin($username, $password, $chatpath)) {
@count_mysql_query("UPDATE uo_chat_database SET prefs='$newpref', email='$nmail', icq='$icq', aim='$aim', ym='$ym', msn='$msn', site='$site',skype='$skype' WHERE chat='$chatpath' AND username='$username'", $handler);
echo "
Preferences for '$username' set to '$newpref', '$nmail', '$icq', '$aim', '$ym', '$msn', '$skype'.
";
return 1;
}
return 0;
}
function ChangeChatPrefs($username, $password, $newpref, $chatpath) {
global $handler;
if (CheckFlags("ZmM", VerifyLogin($username, $password, $chatpath))) {
$result = @count_mysql_query("UPDATE uo_chat_last SET prefs='$newpref' WHERE chat='$chatpath'", $handler);
echo "
Preferences for the chat was set to '$newpref'..
";
return 1;
}
return 0;
}
function GetPrefs($username, $chatpath) {
global $handler;
$result = @count_mysql_query("SELECT prefs,email,aim,ym,icq,msn,site,skype FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_array($result);
@mysql_free_result($result);
return $cuser;
}
function GetChatPrefs($chatpath) {
global $handler;
$result = @count_mysql_query("SELECT chat,prefs,chat_id FROM uo_chat_last WHERE chat='$chatpath'", $handler);
$cuser = mysql_fetch_array($result);
$GLOBALS['biglog']['chat_id'] = intval($cuser['chat_id']+0);
@mysql_free_result($result);
return $cuser;
}
function GetFaction($username, $chatpath) {
global $handler;
$result = @count_mysql_query("SELECT faction FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
return $cuser[0];
}
function GetFactionDetails($chatpath, $faction) {
global $handler;
$result = @count_mysql_query("SELECT chat,id,name,icon FROM uo_chat_faction WHERE chat='$chatpath' AND id='$faction'", $handler);
$cuser = mysql_fetch_row($result);
@mysql_free_result($result);
return $cuser;
}
function AlterFaction($faction, $ficon) {
global $handler;
@count_mysql_query("UPDATE uo_chat_faction SET icon='$ficon' WHERE id='$faction'", $handler);
echo "
".ucwords($faction)." edited.";
}
function GetEmail($username, $chatpath) {
global $handler;
$result = @count_mysql_query("SELECT email FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
return $cuser[0];
}
function GetFlags($username, $chatpath) {
global $handler;
$result = @count_mysql_query("SELECT flags FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
return $cuser[0];
}
function DeleteUser($ad_name, $ad_pass, $username, $chatpath) {
global $handler;
$flags = VerifyLogin($ad_name, $ad_pass, $chatpath);
if (CheckFlags("DXZmM", $flags)) {
$result = @count_mysql_query("SELECT username,flags FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
if (CheckFlags("M", $cuser[1])) {
echo "
System Administrators cannot be deleted.
\n";
return -2;
} else if (CheckFlags("m", $cuser[1]) && !CheckFlags("M", $flags)) {
echo "
You cannot delete Chat Masters.
\n";
return -2;
} else if (CheckFlags("ZP", $cuser[1]) && !CheckFlags("mM", $flags)) {
echo "
You cannot delete Masters or Protected users.
\n";
return -2;
}
@count_mysql_query("DELETE FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
echo "
User '$username' was deleted.
\n";
$username = ucwords($username);
$ad_name = ucwords($ad_name);
$fc = fopen("wizard_locked/actionlog.log", "a");
fwrite($fc, stripslashes(date("F d, Y T - H:i:s").": User '$username' deleted - $ad_name\n"));
fclose($fc);
return 1;
}
return -1;
}
function ChangeUser($ad_name, $ad_pass, $username, $userlevel, $chatpath) {
global $handler;
$flags = VerifyLogin($ad_name, $ad_pass, $chatpath);
if (!empty($username) && CheckFlags("fZmM", $flags)) {
$result = @count_mysql_query("SELECT username,flags FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
if (CheckFlags("M", $cuser[1])) {
echo "
System Administrators cannot be altered.
\n";
return -2;
} else if (CheckFlags("m", $cuser[1]) && !CheckFlags("M", $flags)) {
echo "
You cannot alter Chat Masters.
\n";
return -2;
} else if (CheckFlags("ZP", $cuser[1]) && !CheckFlags("mM", $flags)) {
echo "
You cannot alter Masters or Protected users.
\n";
return -2;
}
if (CheckFlags("M", $userlevel))
$userlevel = str_replace("M", "", $userlevel);
if (CheckFlags("m", $userlevel) && !CheckFlags("M", $flags))
$userlevel = str_replace("m", "", $userlevel);
if (CheckFlags("Z", $userlevel) && !CheckFlags("mM", $flags))
$userlevel = str_replace("Z", "", $userlevel);
if (CheckFlags("f", $userlevel) && !CheckFlags("ZmM", $flags))
$userlevel = str_replace("f", "", $userlevel);
if (CheckFlags("P", $userlevel) && !CheckFlags("ZmM", $flags))
$userlevel = str_replace("P", "", $userlevel);
@count_mysql_query("UPDATE uo_chat_database SET flags='$userlevel' WHERE chat='$chatpath' AND username='$username'", $handler);
echo "
User '$username' was given flags '$userlevel'.
\n";
$username = ucwords($username);
$ad_name = ucwords($ad_name);
$fc = fopen("wizard_locked/actionlog.log", "a");
fwrite($fc, stripslashes(date("F d, Y T - H:i:s").": User '$username' made '$userlevel' - $ad_name\n"));
fclose($fc);
return 1;
}
return -1;
}
function ResetPass($username, $ad_name, $ad_pass, $chatpath) {
global $handler;
$flags = VerifyLogin($ad_name, $ad_pass, $chatpath);
if (CheckFlags("pXZmM", $flags)) {
$result = @count_mysql_query("SELECT username,flags FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
if (CheckFlags("M", $cuser[1])) {
echo "
System Administrators know their passwords.
\n";
return -2;
} else if (CheckFlags("m", $cuser[1])) {
echo "
You cannot reset Chat Masters.
\n";
return -2;
} else if (CheckFlags("ZP", $cuser[1]) && !CheckFlags("mM", $flags)) {
echo "
You cannot reset Masters or Protected users.
\n";
return -2;
}
@count_mysql_query("UPDATE uo_chat_database SET password='".md5("defpass")."' WHERE chat='$chatpath' AND username='$username'", $handler);
echo "
Password for user '$username' was reset to 'defpass'.
\n";
$username = ucwords($username);
$ad_name = ucwords($ad_name);
$fc = fopen("wizard_locked/actionlog.log", "a");
fwrite($fc, stripslashes(date("F d, Y T - H:i:s").": Reset password for user '$username' - $ad_name\n"));
fclose($fc);
return 1;
}
return -1;
}
function RenameUser($username, $ad_name, $ad_pass, $new_name, $chatpath) {
global $handler, $master_name_filter;
$flags = VerifyLogin($ad_name, $ad_pass, $chatpath);
if (!empty($username) && !empty($new_name) && CheckFlags("RXZmM", $flags)) {
$new_name = strtolower($new_name);
$new_name = eregi_replace($master_name_filter, "", $new_name);
$result = @count_mysql_query("SELECT flags FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
if (CheckFlags("M", $cuser[0])) {
echo "
System Administrators only have 1 name.
\n";
return -2;
} else if (CheckFlags("m", $cuser[0]) && !CheckFlags("mM", $flags)) {
echo "
You cannot rename Chat Masters.
\n";
return -2;
} else if (CheckFlags("ZP", $cuser[0]) && !CheckFlags("mM", $flags)) {
echo "
You cannot rename Masters or Protected users.
\n";
return -2;
}
$result = @count_mysql_query("SELECT username FROM uo_chat_database WHERE chat='$chatpath' AND username='$new_name'", $handler);
$cuser = mysql_fetch_row($result);
if ($cuser[0] != "") {
echo "
User '$new_name' already exists.
\n";
return 1;
}
@count_mysql_query("UPDATE uo_chat_database SET username='$new_name' WHERE chat='$chatpath' AND username='$username'", $handler);
echo "
User '$username' renamed to '$new_name'.
\n";
$username = ucwords($username);
$ad_name = ucwords($ad_name);
$fc = fopen("wizard_locked/actionlog.log", "a");
fwrite($fc, stripslashes(date("F d, Y T - H:i:s").": '$username' renamed to '$new_name' - $ad_name\n"));
fclose($fc);
return 1;
}
return -1;
}
function ChangeFaction($username, $ad_name, $ad_pass, $new_name, $chatpath) {
global $handler;
$flags = VerifyLogin($ad_name, $ad_pass, $chatpath);
if (CheckFlags("FXZmM", $flags)) {
$new_name = strtolower($new_name);
$new_name = trim($new_name);
$new_name = str_replace("_", " ", $new_name);
$new_name = str_replace(":", " ", $new_name);
$new_name = str_replace("'", "", $new_name);
$new_name = str_replace("´", "", $new_name);
$new_name = str_replace("`", "", $new_name);
$new_name = str_replace("\"", "", $new_name);
$result = @count_mysql_query("SELECT flags FROM uo_chat_database WHERE chat='$chatpath' AND username='$username'", $handler);
$cuser = mysql_fetch_row($result);
if (CheckFlags("M", $cuser[0])) {
echo "
System Administrators are not in factions.
\n";
return -2;
} else if (CheckFlags("P", $cuser[0]) && !CheckFlags("mM", $flags)) {
echo "
You cannot change the faction of Protected users.
\n";
return -2;
}
@count_mysql_query("UPDATE uo_chat_database SET faction='$new_name' WHERE chat='$chatpath' AND username='$username'", $handler);
echo "
User '$username' is now part of '$new_name'.
\n";
}
return -1;
}
function ListUsers($sfact="", $sort="username") {
global $handler;
include("../settings.php");
include("../options.php");
include("../../common/faction_help.php");
if ($altdata != "")
$chatpath = $altdata;
else {
$chatpath = eregi_replace(".*/([^/]+)/register/biglist.php$", "chat\\1", $_SERVER['PHP_SELF']);
if (strstr($_SERVER['HTTP_HOST'], '.pjj.cc'))
$chatpath = preg_replace('/(.*?)\.pjj\.cc/is', 'chat\1', $_SERVER['HTTP_HOST']);
}
$arr = GetFactionNames($chatpath);
$sort = eregi_replace('[^,[:alnum:]]+', '', $sort);
if (empty($sort))
$sort = 'username';
$sort = mysql_escape_string($sort);
if (!empty($sfact)) {
$sfact = mysql_escape_string($sfact)+0;
$result = @count_mysql_query("SELECT username,flags,faction,lastlogin,prefs,email,icq,aim FROM uo_chat_database WHERE chat='$chatpath' AND faction='$sfact' AND BINARY flags!='M' ORDER BY $sort ASC", $handler);
} else
$result = @count_mysql_query("SELECT username,flags,faction,lastlogin,prefs,email,icq,aim FROM uo_chat_database WHERE chat='$chatpath' AND BINARY flags!='M' ORDER BY $sort ASC", $handler);
echo "
| Username | Flags | Faction | Last Seen | Contact (email,icq,aim) | |
| {$cuser['username']} | {$cuser['flags']} | "; $fname = $arr[$cuser['faction']+0]; echo "$fname | "; if ($cuser['lastlogin'] > 0) echo "".date($dtcalc, $cuser['lastlogin']+($tzone*3600))." | "; else echo "Unknown | "; echo ""; if (CheckFlags("M", $cuser['prefs'])) echo "Email "; if (CheckFlags("Q", $cuser['prefs'])) echo "ICQ: {$cuser['icq']} "; if (CheckFlags("a", $cuser['prefs'])) echo "AIM: {$cuser['aim']}"; echo " | "; echo "
| Action:
| User:
| New Name/Faction: |
| # | Name | Url | $cc | "; echo ""; echo " | "; echo " |
| $aa | "; echo ""; echo " | "; echo " | "; echo " |