/**
* @param $user User
*/
public static function createNewScenario($user)
{
global $db, $PARTY_IDS, $PARTY_NAMES;
//Figure out what job the user has
if ($user->job_id == JOB_IDS::REPORTER) {
$effected_party_id = rand(1, count($PARTY_IDS));
$is_users_party = $effected_party_id == $user->party_id;
$target_name = Scenario::generateRandomName();
//Is the news good or bad? And how bad?
$severity_scale = rand(1, 100);
// 50 is neutral, 1 is terrible, 100 very good
$random_event = null;
$options = array();
if ($severity_scale < 10) {
//terrible event
$random_event = $db->query_one("SELECT scenario_description, scenario_title FROM scenario_descriptions WHERE job_id = {$user->job_id} AND severity_scale = " . SEVERITY_SCALE::TERRIBLE . " ORDER BY RAND() LIMIT 1");
} else {
if ($severity_scale <= 50) {
//mildly bad event
$random_event = $db->query_one("SELECT scenario_description, scenario_title FROM scenario_descriptions WHERE job_id = {$user->job_id} AND severity_scale = " . SEVERITY_SCALE::MILDLY_BAD . " ORDER BY RAND() LIMIT 1");
} else {
if ($severity_scale <= 90) {
//mildly good event
$random_event = $db->query_one("SELECT scenario_description, scenario_title FROM scenario_descriptions WHERE job_id = {$user->job_id} AND severity_scale = " . SEVERITY_SCALE::MILDLY_GOOD . " ORDER BY RAND() LIMIT 1");
} else {
//amazing event.
$random_event = $db->query_one("SELECT scenario_description, scenario_title FROM scenario_descriptions WHERE job_id = {$user->job_id} AND severity_scale = " . SEVERITY_SCALE::AMAZING . " ORDER BY RAND() LIMIT 1");
}
}
}
$options[0] = array("text" => "Stretch the negatives");
$options[1] = array("text" => "Report just the facts");
$options[2] = array("text" => "Downplay/minimize with facts");
$options[3] = array("text" => "Stretch the positive angles");
//add the NAME and PARTY into the event.
// event: "[name] ([party]) was speeding and got out of a ticket because they are a politician.
$scenario_description = str_replace(array("[name]", "[party]"), array($target_name, $PARTY_IDS[$effected_party_id]), $random_event['scenario_description']);
$scenario_title = str_replace(array("[name]", "[party]"), array($target_name, $PARTY_IDS[$effected_party_id]), $random_event['scenario_title']);
//save to database
$scenario_id = $db->query("INSERT INTO scenarios\n (user_id, job_id,\n description, name,\n scenario_status, scenario_date, severity,\n target_name, effected_party_id)\n VALUES\n ({$user->user_id}, {$user->job_id}, x'" . bin2hex($scenario_description) . "', x'" . bin2hex($scenario_title) . "', 0, DATE(NOW()), {$severity_scale}, x'" . bin2hex($target_name) . "', {$effected_party_id})");
//insert the options
$option_inserts = array();
foreach ($options as $option) {
$empty_array = serialize(array());
$option_inserts[] = "({$scenario_id}, x'" . bin2hex($option['text']) . "',x'" . bin2hex($empty_array) . "')";
}
$db->query("INSERT INTO scenario_options (scenario_id, scenario_option_description, scenario_option_result) VALUES " . implode(",", $option_inserts));
}
return new Scenario($scenario_id);
}