$gfaq_url = "75920620";
$gfaq_number = "158";
$gfaq_url4 = "76030938";
$gfaq_number4 = "13";
if (!$link):
$error_flag = "Y";
$error_message = "Oops! Our online database is currently down. This is because hosting company is taking daily backups or server is under maintenance.";
else:
$error_flag = "N";
$sql = "select gfaq_name from member where current_admin = 'Y'";
$result = mysqli_query($link, $sql );
$row = mysqli_fetch_row($result);
$current_admin = $row[0];
if ($user_level == "X"):
$error_flag = "Y";
$error_message = "We regret to inform that Your OPSC account status is currently suspended due suspicious activity. While You can update Your pawns and account information, Your pawns are excluded from the spreadsheet until Your account status is set back to normal.";
endif;
if ($cmd == "login"):
$username=$_POST["username"];
$password=$_POST["password"];
$db_username = addslashes($username);
if ($username != "" && $password != ""):
$hashed_password = addslashes(crypt($password, $password));
$sql = "select member_id, password, activity_level, gfaq_name, hashed_password, user_level, motley_flag, username, temporary_password, DATEDIFF(NOW(),expire_time) from member where username = '$db_username'";
$result = mysqli_query($link, $sql );
$row = mysqli_fetch_row($result);
if ( $row[3] == "" ):
$sql = "select member_id, password, activity_level, gfaq_name, hashed_password, user_level, motley_flag, username, temporary_password, DATEDIFF(NOW(),expire_time) from member where email='$db_username'";
$result = mysqli_query($link, $sql );
$row = mysqli_fetch_row($result);
endif;
if ( $row[3] == "" ):
$login_id = 0;
$error_flag = "Y";
$error_message = "Invalid username/password! If you do not have an account yet, please sign-up by clicking 'Sign Up Now!' button.
";
$error_message = $error_message . "In case you have forgotten your username or password, please go to Forgot Password page to recover it.";
$sql = "insert into login_audit (audit_time, username, action_code, result, ip_address) values (NOW(), '$db_username', 'LOGIN', 'E', '$ip_address')";
$result = mysqli_query($link, $sql );
if(!$result):
$debug_msg = mysqli_error($link);
endif;
elseif ( $hashed_password == addslashes($row[4] )):
$login_id = $row[0];
$login_time = date("YmdHis",time());
$gfaq_name=$row[3];
$my_activity_level = $row[2];
$user_level = $row[5];
$motley_flag = $row[6];
$username = $row[7];
$login_key = crypt($login_id, $login_time);
setCookie("opsc_login_id",$login_id,time()+2592000);
setCookie("opsc_login_time",$login_time,time()+2592000);
setCookie("opsc_login_key",$login_key,time()+2592000);
$sql = "insert into login_audit (audit_time, username, action_code, result, ip_address) values (NOW(), '$db_username', 'LOGIN', 'S', '$ip_address')";
$result = mysqli_query($link, $sql );
if(!$result):
$debug_msg = mysqli_error($link);
endif;
elseif ( ( $hashed_password == addslashes($row[8] ) && ( $row[9] <= 0 ) ) ):
$login_id = $row[0];
$login_time = date("YmdHis",time());
$gfaq_name=$row[3];
$my_activity_level = $row[2];
$user_level = $row[5];
$motley_flag = $row[6];
$username = $row[7];
$login_key = crypt($login_id, $login_time);
setCookie("opsc_login_id",$login_id,time()+2592000);
setCookie("opsc_login_time",$login_time,time()+2592000);
setCookie("opsc_login_key",$login_key,time()+2592000);
$sql = "insert into login_audit (audit_time, username, action_code, result, ip_address) values (NOW(), '$db_username', 'LOGIN', 'S', '$ip_address')";
$result = mysqli_query($link, $sql );
if(!$result):
$debug_msg = mysqli_error($link);
endif;
$error_flag = "Y";
$error_message = "IMPORTANT: You are now logged in with a temporary password which expires 24 hours from resetting. Please click Settings and change your password immediately!";
else:
$login_id = 0;
$error_flag = "Y";
$error_message = "Invalid username/password! If you do not have an account yet, please sign-up by clicking 'Sign Up Now!' button.
";
$error_message = $error_message . "In case you have forgotten your username or password, please go to Forgot Password page to recover it.";
$sql = "insert into login_audit (audit_time, username, action_code, result, ip_address) values (NOW(), '$db_username', 'LOGIN', 'E', '$ip_address')";
$result = mysqli_query($link, $sql );
if(!$result):
$debug_msg = mysqli_error($link);
endif;
endif;
else:
$login_id = 0;
$error_flag = "Y";
$error_message = "You must enter username and password!";
endif;
elseif ($cmd == "logout"):
setCookie("opsc_login_id",0,time()+2592000);
$login_id=0;
$db_username = addslashes($username);
$sql = "insert into login_audit (audit_time, username, action_code, result, ip_address) values (NOW(), '$db_username', 'LOGOUT', 'S', '$ip_address')";
$result = mysqli_query($link, $sql );
if(!$result):
$debug_msg = mysqli_error($link);
endif;
elseif ($cmd == "update_activity"):
if ( $my_activity_level == 0):
$sql = "update member set creation_date = CURDATE() where member_id = $login_id";
mysqli_query($link, $sql );
endif;
$sql = "update member set activity_level = 5 where member_id = $login_id";
mysqli_query($link, $sql );
$my_activity_level = 5;
$success_message="You have now maxed your activity level.";
endif;
endif;?>
The best way to get hires is by hiring others and by being active in the current club topics at GameFAQs. Introducing yourself and your pawn(s) is a good start!
The club is here for fun, helping others, and the enjoyment of interacting with fellow players. Unfairly criticizing or pressurizing others with regards to rents or general trolling, whether publicly or via pm, may result in removal from the club. If any members feel they have been treated unfairly, please pm paasky with your concerns.
[Square]
in the "hire window" which shows the Arisen's name, PSN name and RC you gained,
and then you can view more detailed information; cycle through it with
[R1]. In case you missed the name who hired your pawn, go in the rift and do a search for pawns your main pawn knows. This will give a list of people that have hired you. The last one will be at the bottom of the list. There is no way to see any specific details of hire(s) afterwards so record them when you are in "hire window".
We also recommend that you read the Basic Pawn Hiring & Sharing Faq to learn about things like how to prevent body bags and other basics of pawn sharing.
Happy Hunting Everyone!