"Please select...", 'S' => "S", 'M' => "M", 'L' => "L", 'XL' => "XL", '2XL' => "2XL", '3XL' => "3XL", '4XL' => "4XL", '5XL' => "5XL", 'S-G' => "S Girl", 'M-G' => "M Girl", 'L-G' => "L Girl", 'XL-G' => "XL Girl" ); function user_reset_ical_key($user) { $user['ical_key'] = md5($user['Nick'] . time() . rand()); sql_query("UPDATE `User` SET `ical_key`='" . sql_escape($user['ical_key']) . "' WHERE `UID`='" . sql_escape($user['UID']) . "' LIMIT 1"); } function UID2Nick($UID) { if ($UID > 0) $SQL = "SELECT Nick FROM `User` WHERE UID='" . sql_escape($UID) . "'"; else $SQL = "SELECT Name FROM `Groups` WHERE UID='" . sql_escape($UID) . "'"; $Erg = sql_select($SQL); if (count($Erg) > 0) { if ($UID > 0) return $Erg[0]['Nick']; else return "Group-" . $Erg[0]['Name']; } else { if ($UID == -1) return "Guest"; else return "UserID $UID not found"; } } function TID2Type($TID) { global $con; $SQL = "SELECT Name FROM `EngelType` WHERE TID='" . sql_escape($TID) . "'"; $Erg = mysql_query($SQL, $con); if (mysql_num_rows($Erg)) return mysql_result($Erg, 0); else return ""; } function ReplaceSmilies($neueckig) { $neueckig = str_replace(";o))", "", $neueckig); $neueckig = str_replace(":-))", "", $neueckig); $neueckig = str_replace(";o)", "", $neueckig); $neueckig = str_replace(":)", "", $neueckig); $neueckig = str_replace(":-)", "", $neueckig); $neueckig = str_replace(":(", "", $neueckig); $neueckig = str_replace(":-(", "", $neueckig); $neueckig = str_replace(":o(", "", $neueckig); $neueckig = str_replace(":o)", "", $neueckig); $neueckig = str_replace(";o(", "", $neueckig); $neueckig = str_replace(";(", "", $neueckig); $neueckig = str_replace(";-(", "", $neueckig); $neueckig = str_replace("8)", "", $neueckig); $neueckig = str_replace("8o)", "", $neueckig); $neueckig = str_replace(":P", "", $neueckig); $neueckig = str_replace(":-P", "", $neueckig); $neueckig = str_replace(":oP", "", $neueckig); $neueckig = str_replace(";P", "", $neueckig); $neueckig = str_replace(";oP", "", $neueckig); $neueckig = str_replace("?)", "", $neueckig); return $neueckig; } function GetPictureShow($UID) { global $con; $SQL = "SELECT `show` FROM `UserPicture` WHERE `UID`='" . sql_escape($UID) . "'"; $res = mysql_query($SQL, $con); if (mysql_num_rows($res) == 1) return mysql_result($res, 0, 0); else return ""; } function displayPicture($UID, $height = "30") { global $url, $ENGEL_ROOT; if ($height > 0) return ("
\"picture
"); else return ("
\"picture
"); } function displayavatar($UID, $height = "30") { global $con, $url, $ENGEL_ROOT; if (GetPictureShow($UID) == 'Y') return " " . displayPicture($UID, $height); $user = sql_select("SELECT * FROM `User` WHERE `UID`=" . sql_escape($UID) . " LIMIT 1"); if (count($user) > 0) if ($user[0]['Avatar'] > 0) return '
' . (" ") . '
'; } function UIDgekommen($UID) { global $con; $SQL = "SELECT `Gekommen` FROM `User` WHERE UID='" . sql_escape($UID) . "'"; $Erg = mysql_query($SQL, $con); if (mysql_num_rows($Erg)) return mysql_result($Erg, 0); else return "0"; } ?>