· 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"; } } ?> <?=$ogTitle?>

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..

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

THANK YOU..

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?
 

TO OUR DEDICATED FILTHY AND CZAR
CITIZENS AND COMRADES


SOME OF YOU MAY OR MAY NOT KNOW... WE ARE IN A FIGHT FOR OUR RIGHTS IN OUR PREVIOUS VENUE, THE RITZ YBOR.

The court has set our hearing for August 4th.

What does this mean to you?

IT MEANS THERE WILL BE NO CZAR RELATED EVENTS AT THE RITZ YBOR UNTIL FURTHER NOTICE. Stay tuned for further updates.

Please hang tight, and keep the faith! We love you all.

Stay Filthy,
CZAR NATION & FILTHY RICHARD