addLocale("credits.credits"); $page['id'] = "jobs_create"; $page['name'] = 'Create Business'; $page['bodyid'] = "home"; $page['cat'] = "bussiness"; require_once('./templates/community_header.php'); ?> name == "Guest"){ header("Location: ".PATH); } $RankID = $input->FilterText($_GET['id']); $getCorpID = mysql_query("SELECT corp_id FROM jobs_ranks WHERE id = '".$RankID."';"); $CorpID = mysql_fetch_assoc($getCorpID); $checkUserQuery = mysql_query("SELECT * FROM jobs_corps WHERE owner = '".$user->id."' && id = '".$CorpID['corp_id']."';"); if(mysql_num_rows($checkUserQuery) == 0){ header("Location: ".PATH."/jobs_create"); } if(isset($_POST['rank_submit'])) { $rank_motto = strip_tags($input->FilterText($_POST['rank_motto'])); $rank_payout = strip_tags($input->FilterText($_POST['rank_payout'])); $rank_spots = strip_tags($input->FilterText($_POST['rank_spots'])); $rank_status = strip_tags($input->FilterText($_POST['rank_status'])); $rank_global = strip_tags($input->FilterText($_POST['rank_global'])); if($rank_motto == NULL || $rank_payout == NULL || $rank_spots == NULL || $rank_spots == NULL || $rank_status == NULL || $rank_global == NULL){ $error_message = 'You have left a field blank.

'; }else{ if(!is_numeric($rank_payout) || !is_numeric($rank_spots) || !is_numeric($rank_status) || !is_numeric($rank_global)){ $error_message = 'Please use numbers in the appropriate fields.

'; }else{ if($rank_payout < 0 || $rank_spots < 0 || $rank_status < 0 || $rank_global < 0){ $error_message = 'Numbers can not below the value of 0.

'; }else{ if($rank_payout > 100){ $error_message = 'You cannot make the payout more than 100 credits.

'; }else{ if($rank_spots > 500){ $error_message = 'You cannot open more than 500 spots.

'; }else{ if($rank_status > 2 || $rank_global > 1){ $error_message = 'What exactly are you trying to do?

'; }else{ mysql_query("UPDATE jobs_ranks SET motto = '".$rank_motto ."', manager_rank = '".$rank_status."', pay = '".$rank_payout."', open_spots = '".$rank_spots."', global = '".$rank_global."' WHERE id = '".$RankID."';"); $error_message = 'You have successfully edited this rank.

'; } } } } } } } $getRankInfoQuery = mysql_query("SELECT * FROM jobs_ranks WHERE id = '".$RankID."';"); $rankInfo = mysql_fetch_array($getRankInfoQuery); if(isset($_POST['rank_delete'])){ $getHighestRank = mysql_query("SELECT * FROM jobs_ranks WHERE corp_id = '".$CorpID['corp_id']."'"); if($rankInfo['job_rank'] != mysql_num_rows($getHighestRank)){ $error_message = 'To delete this rank, you must delete all ranks above it.

'; }else{ mysql_query("UPDATE users SET corp_id = '0', job_rank = '0', secure_id = '0' WHERE secure_id = '".$rankInfo['id']."'"); mysql_query("DELETE FROM jobs_rooms WHERE rank_id = '".$rankInfo['id']."'"); mysql_query("DELETE FROM jobs_ranks WHERE id = '".$rankInfo['id']."'"); header("Location: ".PATH."/jobs_edit?id=".$CorpID['corp_id'].""); } } if(isset($_POST['hire_submit'])){ $hire_user = strip_tags($input->FilterText($_POST['hire_user'])); $getUsersInfo = mysql_query("SELECT * FROM users WHERE name = '".$hire_user."'"); if(mysql_num_rows($getUsersInfo) == 0){ $error_message_one = ''.$hire_user.' does not exsist!

'; }else{ $UsersInfo = mysql_fetch_array($getUsersInfo); if($UsersInfo['corp_id'] != 0 || $UsersInfo['job_rank'] != 0 || $UsersInfo['secure_id'] != 0){ $error_message_one = ''.$UsersInfo['name'].' already has a job.

'; }else{ $error_message_one = ''.$UsersInfo['name'].' has recieved the job.

'; mysql_query("UPDATE users SET corp_id = '".$rankInfo['corp_id']."', job_rank = '".$rankInfo['job_rank']."', secure_id = '".$rankInfo['id']."' WHERE name = '".$UsersInfo['name']."'"); } } } $getUserSex = mysql_query("SELECT sex FROM users WHERE id = '".$user->id."';"); $userSex = mysql_fetch_assoc($getUserSex); if(isset($_POST['rank_uniform'])){ $getFigureData = mysql_query("SELECT figure FROM users WHERE id = '".$user->id."';"); $FigureData = mysql_fetch_assoc($getFigureData); mysql_query("UPDATE jobs_ranks SET figure_data_".$userSex['sex']." = '".$FigureData['figure']."'WHERE id = '".$RankID."';"); $error_message_two = 'You have set this ranks uniform to what you are currently wearing.

'; } if(isset($_POST['rooms_submit'])){ $rooms_room = strip_tags($input->FilterText($_POST['rooms_room'])); $getRooms = mysql_query("SELECT * FROM rooms WHERE id = '".$rooms_room."';"); if(!is_numeric($rooms_room)){ $error_message_three = 'The workroom must be a room ID.

'; }else{ if(mysql_num_rows($getRooms) == 0){ $error_message_three = 'Sorry, but that room does not exsist.

'; }else{ $getRoomCheck = mysql_query("SELECT * FROM rooms WHERE owner = '".$user->name."' && id = '".$rooms_room."'"); if(mysql_num_rows($getRoomCheck) < 1){ $error_message_three = 'Sorry, but you do not own that room.

'; }else{ mysql_query("INSERT into jobs_rooms (corp_id, rank_id, room_id) VALUES ('".$rankInfo['corp_id']."', '".$rankInfo['id']."', '".$rooms_room."');"); $error_message_three = 'You have successfully made room '.$rooms_room.' a workroom.

'; } } } } ?>

Uniform

'; ?>

Workrooms

Workrooms:

Hire User

Employees ()

'.$Users['name'].'
'.$Users['mission'].'

Last visit: '.$Users['lastvisit'].'
Promote | Demote | Fire

'; } ?>

My Business

name."'"); $info = mysql_fetch_array($getinfo); $getevenmoreinfo = mysql_query("SELECT * FROM jobs_corps WHERE owner = '".$info['id']."'"); $corpcount = mysql_num_rows($getevenmoreinfo); if($corpcount > 0) { while($s = mysql_fetch_array($getevenmoreinfo)) { echo ''.$s['corp_name'].'
'; } }else{ echo 'Sorry, but you do not have any corps.
'; } ?>
Create Business