new_user2.pl: my $query = "SELECT `Login` FROM `Account_Info` WHERE `Login` = '$username'"; new_user2.pl: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$login_name', '$pw', '$email', '$league_id', '', '', '$first_name', '$last_name', '$title', '$phone', '$wphone', '$mphone', '$zip');"; player_report.php: $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Reg_Player_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Reg_Year` = '$reg_year' AND c.`Active` = '1' AND a.`Key` = b.`Account_ID`"; player_report.php: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$sid'"; player_reportb.php: $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Reg_Player_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Reg_Year` = '$reg_year' AND c.`Active` = '1' AND a.`Key` = b.`Account_ID`"; player_reportb.php: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$sid'"; pyb_lib.pm: my $query = "SELECT b.`Login`, b.`Firstname`, b.`Lastname`, b.`Key` FROM `Permissions_Info` a, `Account_Info` b WHERE a.`Access_Type` = 'ORG' AND pyb_lib.pm: my $query = "SELECT * FROM `Account_Info` WHERE `Key` = '$user_id'"; pyb_lib.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; pyb_lib.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; pyb_lib.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; pyb_lib.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; pyb_lib.pm: $query = "SELECT * FROM `Account_Info` WHERE `Login` = '$user' AND `Password` = '$pass'"; pyb_lib.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; pyb_lib.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; pyb_lib.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; pyb_lib.pm: my $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; reg_lib.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_admin.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_admin.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; reg_lib_admin_v1.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_admin_v1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; reg_lib_admin_v1_1.pm: my $query = "SELECT email FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id' AND `Key` = '$user_key'"; reg_lib_admin_v1_1.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_admin_v1_1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; reg_lib_admin_v1_1_sponser.pm: my $query = "SELECT email FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id' AND `Key` = '$user_key'"; reg_lib_admin_v1_1_sponser.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_admin_v1_1_sponser.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; reg_lib_admin_v1_1jm.pm: my $query = "SELECT email FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id' AND `Key` = '$user_key'"; reg_lib_admin_v1_1jm.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_admin_v1_1jm.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; reg_lib_v1.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_v1_1.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_v1_1_oswego.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_lib_v1_1_sponser.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_shared_v1_2.pm: my $query = "SELECT email FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id' AND `Key` = '$user_key'"; reg_shared_v1_2.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; reg_shared_v1_2.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_shared_v1_2.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; reg_shared_v1_2.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; reg_shared_v1_2.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; reg_shared_v1_2.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; reg_shared_v1_2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; reg_shared_v1_2.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; reg_shared_v1_2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; reg_shared_v1_2.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; reg_shared_v1_2.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE (`email` = '$new_email' OR `Login` = '$new_email')"; reg_shared_v1_2jyf.pm: my $query = "SELECT email FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id' AND `Key` = '$user_key'"; reg_shared_v1_2jyf.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; reg_shared_v1_2jyf.pm: my $query = "SELECT a.`Firstname`, a.`Lastname`, a.`email`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE a.`Key` = '$user_key' AND a.`Key` = b.`Account_ID`;"; reg_shared_v1_2jyf.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; reg_shared_v1_2jyf.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; reg_shared_v1_2jyf.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; reg_shared_v1_2jyf.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; reg_shared_v1_2jyf.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; reg_shared_v1_2jyf.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; reg_shared_v1_2jyf.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; reg_shared_v1_2jyf.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; reg_shared_v1_2jyf.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE (`email` = '$new_email' OR `Login` = '$new_email')"; registration.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_Manual_Adjustment` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration2.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration2.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration2.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration2.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_Manual_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration2.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_Manual_Adjustment` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration2.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration2.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration2.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration2.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration2.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration2.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration2.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration2.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration2.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration2.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration2.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_admin_jg.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_admin_jg.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_jg.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_jg.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_jg.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_jg.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID` ORDER BY a.`Date`;"; registration_admin_jg.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration_admin_jg.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_jg.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_jg.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_admin_jg.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_jg.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_jg.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_jg.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_jg.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_admin_jg.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_admin_jg.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_admin_jg.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_admin_v1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_admin_v1.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID` ORDER BY a.`Date`;"; registration_admin_v1.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration_admin_v1.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_admin_v1.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_admin_v1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_admin_v1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_admin_v1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_admin_v1_1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_admin_v1_1.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1_1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1_1.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1_1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1_1.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID` ORDER BY a.`Date`;"; registration_admin_v1_1.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration_admin_v1_1.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1_1.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1_1.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_admin_v1_1.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1_1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1_1.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1_1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1_1.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_admin_v1_1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID` $user_filter"; registration_admin_v1_1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_admin_v1_1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_admin_v1_1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_admin_v1_1_sponser.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_admin_v1_1_sponser.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1_1_sponser.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1_1_sponser.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1_1_sponser.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1_1_sponser.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID` ORDER BY a.`Date`;"; registration_admin_v1_1_sponser.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration_admin_v1_1_sponser.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1_1_sponser.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1_1_sponser.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_admin_v1_1_sponser.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1_1_sponser.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1_1_sponser.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1_1_sponser.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1_1_sponser.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_admin_v1_1_sponser.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID` $user_filter"; registration_admin_v1_1_sponser.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_admin_v1_1_sponser.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_admin_v1_1_sponser.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_admin_v1_1jm.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_admin_v1_1jm.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1_1jm.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1_1jm.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1_1jm.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1_1jm.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID` ORDER BY a.`Date`;"; registration_admin_v1_1jm.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration_admin_v1_1jm.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1_1jm.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1_1jm.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_admin_v1_1jm.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1_1jm.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1_1jm.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1_1jm.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1_1jm.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_admin_v1_1jm.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID` $user_filter"; registration_admin_v1_1jm.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID` AND a.`Password` = 'ryan88'"; registration_admin_v1_1jm.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_admin_v1_1jm.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_admin_v1_2.pm: $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_admin_v1_2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_admin_v1_2.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_admin_v1_2.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_admin_v1_2.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID` ORDER BY a.`Date`;"; registration_admin_v1_2.pm: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_All_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; registration_admin_v1_2.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_admin_v1_2.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_admin_v1_2.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID` $user_filter"; registration_admin_v1_2.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_jg.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_jg.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_jg.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_jg.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_jg.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_jg.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_jg.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_jg.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_jg.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_jg.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_jg.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_jg.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_v1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_v1.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_v1.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_v1.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_v1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_v1.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_v1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_v1.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_v1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_v1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_v1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_v1_1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_v1_1.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_v1_1.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_v1_1.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_v1_1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_v1_1.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_v1_1.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_v1_1.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_v1_1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_v1_1.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Org_Reg_Link` b WHERE b.`Org_ID` = '$org_id' AND (a.`email` = '$email' OR a.`Login` = '$email') AND b.`Account_ID` = a.`Key`"; registration_v1_1.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_v1_1.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_v1_1_oswego.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_v1_1_oswego.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_v1_1_oswego.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_v1_1_oswego.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_v1_1_oswego.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_v1_1_oswego.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_v1_1_oswego.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_v1_1_oswego.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_v1_1_oswego.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_v1_1_oswego.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Org_Reg_Link` b WHERE b.`Org_ID` = '$org_id' AND (a.`email` = '$email' OR a.`Login` = '$email') AND b.`Account_ID` = a.`Key`"; registration_v1_1_oswego.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1_oswego.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1_oswego.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_v1_1_oswego.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_v1_1_sponser.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_v1_1_sponser.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_v1_1_sponser.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_v1_1_sponser.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_v1_1_sponser.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_v1_1_sponser.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_v1_1_sponser.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_v1_1_sponser.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_v1_1_sponser.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_v1_1_sponser.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Org_Reg_Link` b WHERE b.`Org_ID` = '$org_id' AND (a.`email` = '$email' OR a.`Login` = '$email') AND b.`Account_ID` = a.`Key`"; registration_v1_1_sponser.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1_sponser.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1_sponser.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_v1_1_sponser.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_v1_1_waysc.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `Last_Access_ID` = '$session'"; registration_v1_1_waysc.pm: my $query = "UPDATE `Account_Info` a, `Account_Extra_Info` b SET a.`Firstname`='$fname', a.`Lastname`='$lname', a.`Home_Phone`='$phone', a.`Mobile_Phone`='$mphone', a.`Zip_Code`='$zip', b.`Address1`='$ad1' , b.`Address2`='$ad2' , b.`City`='$city', b.`State`='$state' WHERE a.`email`='$email' AND a.`Key` = b.`Account_ID`;"; registration_v1_1_waysc.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_v1_1_waysc.pm: my $query = "SELECT * FROM `Account_Info` WHERE (`Login` = '$user' OR `email` = '$user') AND `Password` = '$pass'"; registration_v1_1_waysc.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date', `Last_Access_ID`='$session_id' WHERE `Key` = $Key;"; registration_v1_1_waysc.pm: $query = "SELECT * FROM `Account_Info` WHERE `Last_Access_ID` = '$session_id'"; registration_v1_1_waysc.pm: $update = "UPDATE `Account_Info` SET `Last_Access`='$current_date' WHERE `Key` = $Key;"; registration_v1_1_waysc.pm: my $query = "SELECT `Password` FROM `Account_Info` WHERE `email` = '$email';"; registration_v1_1_waysc.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b, `Account_Org_Reg_Link` c WHERE c.`Org_ID` = '$org_id' AND c.`Account_ID` = a.`Key` AND c.`Account_ID` = b.`Account_ID`"; registration_v1_1_waysc.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Org_Reg_Link` b WHERE b.`Org_ID` = '$org_id' AND (a.`email` = '$email' OR a.`Login` = '$email') AND b.`Account_ID` = a.`Key`"; registration_v1_1_waysc.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1_waysc.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_1_waysc.pm: my $query = "SELECT a.`Key`, a.`email`, a.`Firstname`, a.`Lastname`, a.`Home_Phone`, a.`Work_Phone`, a.`Mobile_Phone`, a.`Zip_Code`, b.`Address1`, b.`Address2`, b.`City`, b.`State` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and a.`Key` = '$user_key'"; registration_v1_1_waysc.pm: my $query = "SELECT `Key` FROM `Account_Info` WHERE `email` = '$new_email'"; registration_v1_2.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_v1_2.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Org_Reg_Link` b WHERE b.`Org_ID` = '$org_id' AND (a.`email` = '$email' OR a.`Login` = '$email') AND b.`Account_ID` = a.`Key`"; registration_v1_2.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; registration_v1_2jyf.pm: my $query = "INSERT INTO `Account_Info` ( `Key` , `Login` , `Password` , `email` , `League_ID`, `Last_Access`, `Last_Access_ID`, `Firstname`, `Lastname`, `Title`, `Home_Phone`, `Work_Phone`, `Mobile_Phone`, `Zip_Code`) VALUES ('', '$email', '$pw1', '$email', '', '', '', '$fname', '$lname', 'USER', '$phone', '', '$mphone', '$zip');"; registration_v1_2jyf.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Org_Reg_Link` b WHERE b.`Org_ID` = '$org_id' AND (a.`email` = '$email' OR a.`Login` = '$email') AND b.`Account_ID` = a.`Key`"; registration_v1_2jyf.pm: my $query = "SELECT a.`Key` FROM `Account_Info` a, `Account_Extra_Info` b WHERE b.`Account_ID` = a.`Key` and (a.`email` = '$email' OR a.`Login` = '$email')"; remove_user2.pl: #my $query = "SELECT a.Key from `Permissions_Info` a, `Account_Info` b, `Menu_Info` c WHERE a.`Login_ID` = '$ID' AND a.`Login_ID`= b.`Key` AND (a.`Access_Type` = 'INFO' OR a.`Access_Type` = 'LEAGUE') AND a.`Access_ID`= c.`Key` AND c.`Org_ID` = '$org'"; remove_user2.pl: my $query = "SELECT a.`Key` from `Permissions_Info` a, `Account_Info` b, `Menu_Info` c WHERE a.`Login_ID` = '$ID' AND a.`Login_ID`= b.`Key` AND ((a.`Access_Type` = 'INFO' AND a.`Access_ID`= c.`Key`) OR (a.`Access_Type` = 'LEAGUE' AND a.`Access_ID`= c.`League_ID`) ) AND c.`Org_ID` = '$org'"; remove_user2.pl: my $query2 = "DELETE FROM `Account_Info` WHERE `Key` = '$login_id' LIMIT 1"; update_perms.pl: $query = "SELECT a.`Access_Level`, b.`Login`, b.`Firstname`, b.`Lastname`, b.`Key` FROM `Permissions_Info` a, `Account_Info` b WHERE a.`Access_Type` = 'ORG' and a.`Access_ID` = '$org_id' and a.`Login_ID` = b.`Key`"; update_perms.pl: $query = "SELECT a.`Access_Level`, b.`Login`, b.`Firstname`, b.`Lastname`, b.`Key`, a.`Key` FROM `Permissions_Info` a, `Account_Info` b WHERE a.`Access_Type` = '$type' and a.`Access_ID` = '$ID' and a.`Login_ID` = b.`Key`"; update_reg_player_adjustment.pl: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_Manual_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; update_reg_player_paid.pl: my $query = "SELECT a.`Amount`, a.`Check_ID`, a.`Date`, b.`Login` FROM `Reg_Manual_Transaction` a, `Account_Info` b WHERE a.`Player_ID` = '$player_key' AND b.`Key` = a.`Update_Account_ID`;"; update_user2.pl: $query = "UPDATE `Account_Info` SET `Firstname`='$first_name', `Lastname`='$last_name', `email`='$email', `Title`='$title', `Home_Phone`='$phone', `Work_Phone`='$wphone', `Mobile_Phone`='$mphone', `Zip_Code`='$zip' WHERE `Key` = $user_id LIMIT 1;"; update_user2.pl: $query = "UPDATE `Account_Info` SET `Firstname`='$first_name', `Lastname`='$last_name', `Password`='$pw',`email`='$email', `Title`='$title', `Home_Phone`='$phone', `Work_Phone`='$wphone', `Mobile_Phone`='$mphone', `Zip_Code`='$zip' WHERE `Key` = $user_id LIMIT 1;";