· Your First Name"; $errorCNT = $errorCNT+1; } if ($lName==""){ $error.="
· Your Last Name"; $errorCNT = $errorCNT+1; } if ($email=="" && $phone ==""){ $error.="
· Your Email Address or Phone Number"; $errorCNT = $errorCNT+1; } // if no error, do input /////////////////////////////////// if ($errorCNT =="0"){ // check if user exists in db $getUserID= mysql_query("SELECT id FROM phplist_user_user where email='$email' AND email <> ''")or die (mysql_error()); if (mysql_num_rows($getUserID) == "0"){ // if not in the db add them //uniqueid function function uuid() { // The field names refer to RFC 4122 section 4.1.2 return sprintf('%04x%04x-%04x-%03x4-%04x-%04x%04x%04x', mt_rand(0, 65535), mt_rand(0, 65535), // 32 bits for "time_low" mt_rand(0, 65535), // 16 bits for "time_mid" mt_rand(0, 4095), // 12 bits before the 0100 of (version) 4 for "time_hi_and_version" bindec(substr_replace(sprintf('%016b', mt_rand(0, 65535)), '01', 6, 2)), // 8 bits, the last two of which (positions 6 and 7) are 01, for "clk_seq_hi_res" // (hence, the 2nd hex digit after the 3rd hyphen can only be 1, 5, 9 or d) // 8 bits for "clk_seq_low" mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(0, 65535) // 48 bits for "node" ); } $theDate=date("Y-m-d H:i:s"); // create a unique id $uniqid = uuid(); mysql_query("INSERT INTO phplist_user_user (email,htmlemail, confirmed, entered, modified, subscribepage, uniqid) VALUES ('$email', '1', '1', '$theDate','$theDate','1', '$uniqid')") or die ("user_user = ".mysql_error()); ///////////////// grab the new id /////////////////////// $getNewId = mysql_query ("SELECT id from phplist_user_user ORDER BY id DESC"); $newID = mysql_fetch_array($getNewId); $theNewID = $newID['id']; /////////////// attributes Values//////////////////////// //// 1. First name $VALUES .="('1','$theNewID','$fName')"; //// 2. last name $VALUES .=",('2','$theNewID','$lName')"; //echo " ".$lName; $VALUES .=",('3','$theNewID','$phone')"; //echo " ".$lName; mysql_query ("INSERT INTO phplist_user_user_attribute (attributeid, userid,value) VALUES $VALUES ") or die (mysql_error()); $userID=$theNewID; // then add them as a member of czar filthy updates $theDate = date("Y-m-d H:i:s"); mysql_query ("INSERT INTO phplist_listuser (userid,listid,entered,modified) values ('$userID','13','$theDate','$theDate')"); } else // the user exists { // grab user id $userIDArr = mysql_fetch_array($getUserID); $userID = $userIDArr['id']; //check if they are a member of czar filthy updates $theDate = date("Y-m-d H:i:s"); $getCheckFilthy = mysql_query ("SELECT * FROM phplist_listuser where userid = '$userID' AND listid = '13'"); if (mysql_num_rows($getCheckFilthy) == "0") { // they are not on the czar filthy updates // add them mysql_query ("INSERT INTO phplist_listuser (userid,listid,entered,modified) values ('$userID','13','$theDate','$theDate')"); } //update the status of the user to confirmed mysql_query ("UPDATE phplist_user_user set confirmed = '1' where id = '$userID'"); $getPhone= mysql_query("SELECT value FROM phplist_user_user_attribute where attributeid='3' AND userid = '$userID'")or die (mysql_error()); if (mysql_num_rows($getPhone) == "0"){ $VALUES ="('3','$userID','$phone')"; mysql_query ("INSERT INTO phplist_user_user_attribute (attributeid, userid,value) VALUES $VALUES ") or die ("error here".mysql_error()); }else if ($phone <>""){ //update phone mysql_query ("UPDATE phplist_user_user_attribute set value = '$phone' where userid = '$userID' and attributeid='3'") or die ("ahhh"); } } //add the user to the guestlist on specified date $getUserList = mysql_query ("SELECT fName from team_guestlist where userID = '$userID' and resDate='2000-01-01' and isOn=1"); if (mysql_num_rows($getUserList) == "0"){ mysql_query("INSERT INTO team_guestlist (enterDate , resDate, userID, fName, lName, email, type, location, isOn, ip, thought) VALUES('$theDate', '2000-01-01','$userID','$fName','$lName','$email', 'online','filthy','1','$ip','$thought') "); //add them to the email reminder list //mysql_query ("INSERT INTO phplist_listuser (userid,listid,entered,modified) values ('$userID','3','$theDate','$theDate')"); } else{ $onList= 1; } $listshow = "done"; } else { $listshow = "guestlist"; } } ?> FILTHY RICHARD - The Filthiest Party In Town! :)

Citizens & Comrades!

CZAR NATION and FILTHY RICHARD can no longer be found in the RITZ YBOR.

We can now be described as traveling hustlers of culture. Our Czar family and friends are taking the party on the road!

Join the rEVOLUTION... our new pop up and takeover parties launching Soon.


Thank you, you were already on the list to be notified!


Thank you for signing up for our updates! You will be notified of our pop-up parties & takeovers soon!

Sign Up For Updates Here...

and get the up to the minute scoop on our first brand new, dirty party location

First Name
Last Name
Email Address
Phone Number
Filthy Thought?