*:#&[:alnum:][:space:]]+)", "", $new_name);
$result = @mysql_query("SELECT name FROM uo_chat_faction WHERE name='$new_name' AND chat='$chatpath'", $handler);
$row = @mysql_fetch_row($result);
@mysql_free_result($result);
if ($row[0] != $new_name) {
@mysql_query("INSERT INTO uo_chat_faction (chat,name) VALUES ('$chatpath','$new_name')", $handler);
echo "
Faction '$new_name' created.
";
} else {
echo "
Faction named '$new_name' already exists.
";
}
}
function RenameFaction($chatpath, $old_id, $new_name) {
global $handler;
$old_id += 0;
$new_name = eregi_replace("([^()-/´`~={}><*:#&[:alnum:][:space:]]+)", "", $new_name);
$result = @mysql_query("SELECT name FROM uo_chat_faction WHERE name='$new_name' AND chat='$chatpath'", $handler);
$row = @mysql_fetch_row($result);
@mysql_free_result($result);
if ($row[0] != $new_name) {
@mysql_query("UPDATE uo_chat_faction SET name='$new_name' WHERE id='$old_id' AND chat='$chatpath'", $handler);
echo "
Faction $old_id renamed to '$new_name'.
";
} else {
echo "
Faction named '$new_name' already exists.
";
}
}
function DeleteFaction($chatpath, $old_id) {
global $handler;
$old_id += 0;
@mysql_query("DELETE FROM uo_chat_faction WHERE id='$old_id' AND chat='$chatpath'", $handler);
@mysql_query("UPDATE uo_chat_database SET faction='0' WHERE faction='$old_id' AND chat='$chatpath'", $handler);
echo "
Faction '$old_id' deleted.
"; } function ListFactions($chatpath) { global $handler; $result = @mysql_query("SELECT name,id FROM uo_chat_faction WHERE chat='$chatpath' ORDER BY id ASC", $handler); echo "
Valid Factions | |
Name | Id # |
No Faction | 0 |
$row[0] | $row[1] |