<*:#&[: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 ""; echo ""; echo ""; echo ""; while($row = @mysql_fetch_row($result)) { echo ""; } @mysql_free_result($result); echo "
Valid Factions
NameId #
No Faction0
$row[0]$row[1]
"; } function GetFactionNames($chatpath) { global $handler; $result = @mysql_query("SELECT id,name FROM uo_chat_faction WHERE chat='$chatpath'", $handler); $arr = array("No Faction"); while($row = @mysql_fetch_row($result)) { $arr[$row[0]+0] = $row[1]; } @mysql_free_result($result); return $arr; } function GetFactionIcon($chatpath, $faction) { global $handler; $faction = intval($faction); $result = count_mysql_query("SELECT icon FROM uo_chat_faction WHERE id={$faction} AND chat='$chatpath'", $handler); if (mysql_num_rows($result) && $row = mysql_fetch_row($result)) { return $row[0]; } mysql_free_result($result); return NULL; } ?>