// Check if lottery time is met
$result = dbquery("SELECT * FROM ".DB_PREFIX."point_lotto_drawings ORDER BY draw_id DESC LIMIT 0,1");
$data = dbarray($result);
if($data['draw_time'] < time() && $data['draw_over'] == 0){
// if so, get how many tickets were bought
$check = dbquery("SELECT * FROM ".DB_PREFIX."point_lotto_tickets WHERE ticket_draw='".$data['draw_id']."'");
// make sure it's more than 1 ticket
if(dbrows($check) >= 2){
// get the number to start/end at for the rnd() number
$start = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."point_lotto_tickets WHERE ticket_draw='".$data['draw_id']."' ORDER BY ticket_id ASC LIMIT 0,1"));
$start = $start['ticket_id'];
$end = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."point_lotto_tickets WHERE ticket_draw='".$data['draw_id']."' ORDER BY ticket_id DESC LIMIT 0,1"));
$end = $end['ticket_id'];
// alright, pick the number!!
$pick = rand($start, $end);
// check who's ticket it is
$check = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."point_lotto_tickets WHERE ticket_id='".$pick."' AND ticket_draw='".$data['draw_id']."'"));
$winner = $check['ticket_holder'];
//----------------------------------\\
// send a PM to the Site Owner
$result = dbquery("INSERT INTO ".DB_PREFIX."messages VALUES('', '1', '80', 'Winner', 'The winner was user #".$winner."', '0', '0', '".time()."', '0')");
// send a PM to the WINNER
$result = dbquery("INSERT INTO ".DB_PREFIX."messages VALUES('', '".$winner."', '80', 'Winner)', 'You won the lottery!', '0', '0', '".time()."', '0')");
// update the winner's points
$result = dbquery("UPDATE ".DB_PREFIX."users SET user_points=user_points+".$data['draw_win']." WHERE user_id='".$winner."'");
// make it so drawing won't be checked again
$result = dbquery("UPDATE ".DB_PREFIX."point_lotto_drawings SET draw_over='1' WHERE draw_id='".$data['draw_id']."'");
// start another lottery
$draw_time = time() + 24 * 3600;
$result = dbquery("INSERT INTO ".DB_PREFIX."point_lotto_drawings VALUES('', '10', '50', '550', '".$draw_time."', '0')");
//----------------------------------\\
} else {
// PM site owner that there weren't enough tickets to pick a person
$result = dbquery("INSERT INTO ".DB_PREFIX."messages VALUES('', '1', '80', 'No winner', 'There weren\'t enough ticket holders to get a random number', '0', '0', '".time()."', '0')");
// make it so drawing won't be checked again
$result = dbquery("UPDATE ".DB_PREFIX."point_lotto_drawings SET draw_over='1' WHERE draw_id='".$data['draw_id']."'");
// start another lottery
$draw_time = time() + 24 * 3600;
$result = dbquery("INSERT INTO ".DB_PREFIX."point_lotto_drawings VALUES('', '10', '50', '550', '".$draw_time."', '0')");
//----------------------------------\\
}
}

// Check if POWERBALL lottery time is met
$result = dbquery("SELECT * FROM ".DB_PREFIX."point_pb_drawings ORDER BY draw_id DESC LIMIT 0,1");
$data = dbarray($result);
if($data['draw_time'] < time() && $data['draw_over'] == 0){
// if so, get how many tickets were bought
$check = dbquery("SELECT * FROM ".DB_PREFIX."point_pb_tickets WHERE ticket_draw='".$data['draw_id']."'");
// make sure it's more than 1 ticket
if(dbrows($check) >= 2){
// get the number to start/end at for the rnd() number
$start = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."point_pb_tickets WHERE ticket_draw='".$data['draw_id']."' ORDER BY ticket_id ASC LIMIT 0,1"));
$start = $start['ticket_id'];
$end = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."point_pb_tickets WHERE ticket_draw='".$data['draw_id']."' ORDER BY ticket_id DESC LIMIT 0,1"));
$end = $end['ticket_id'];
// alright, pick the number!!
$pick = rand($start, $end);
// check who's ticket it is
$check = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."point_pb_tickets WHERE ticket_id='".$pick."' AND ticket_draw='".$data['draw_id']."'"));
$winner = $check['ticket_holder'];
//----------------------------------\\
// send a PM to the Site Owner
$result = dbquery("INSERT INTO ".DB_PREFIX."messages VALUES('', '1', '80', 'Winner (PB)', 'The winner was user #".$winner."', '0', '0', '".time()."', '0')");
// send a PM to the WINNER
$result = dbquery("INSERT INTO ".DB_PREFIX."messages VALUES('', '".$winner."', '80', 'Winner (PB)', 'You won the powerball lottery!', '0', '0', '".time()."', '0')");
// update the winner's points
$result = dbquery("UPDATE ".DB_PREFIX."users SET user_points=user_points+".$data['draw_win']." WHERE user_id='".$winner."'");
// make it so drawing won't be checked again
$result = dbquery("UPDATE ".DB_PREFIX."point_pb_drawings SET draw_over='1' WHERE draw_id='".$data['draw_id']."'");
// start another lottery
$draw_time = time() + 24 * 3600;
$result = dbquery("INSERT INTO ".DB_PREFIX."point_pb_drawings VALUES('', '10', '500', '1500', '".$draw_time."', '0')");
//----------------------------------\\
} else {
// PM site owner that there weren't enough tickets to pick a person
$result = dbquery("UPDATE ".DB_PREFIX."point_pb_drawings SET draw_over='1' WHERE draw_id='".$data['draw_id']."'");
$result = dbquery("INSERT INTO ".DB_PREFIX."messages VALUES('', '1', '80', 'No winner (PB)', 'There weren\'t enough ticket holders to get a random number', '0', '0', '".time()."', '0')");
// start another lottery
$draw_time = time() + 24 * 3600;
$result = dbquery("INSERT INTO ".DB_PREFIX."point_pb_drawings VALUES('', '10', '500', '1500', '".$draw_time."', '0')");
//----------------------------------\\
}
}

// Stock price update engine
$result = dbarray(dbquery("SELECT * FROM ".DB_PREFIX."point_stox_update"));
$last = $result['last_time'];
$nextupdate = $last + 3600 * 1;
if(time() > $nextupdate){
	$result = dbquery("SELECT * FROM ".DB_PREFIX."point_stox_companies");
	while($data = dbarray($result)){
		$check = dbquery("SELECT * FROM ".DB_PREFIX."point_stox_changes WHERE change_company='".$data['company_id']."'");
		
		$start = 0 - 2;
		
		// PRICE CRASH [TURNED OFF]
		
		//$crash1 = rand(0, 50);
		//$crash2 = rand(0, 50);
		//if($crash1 == $crash2){
		//$current = -5;
		//}
		
		// [END]
		
		$current = $data['company_pps'];
		$change = rand(-2, 2);
	
		$new = $current + $change;
		
		// CRASH FAILSAFE
		if($new > 5){
		$new = $current + $change;
		} else {
		$new = 6;
		}
		// [END]
		
		// OVERFLOW FAILSAFE
		
		if($new < 40){
		$new = $current + $change;
		} else {
		$new = 30;
		}
		
		// [END]
		
		if(dbrows($check) !== 0){
		
			$query = dbquery("UPDATE ".DB_PREFIX."point_stox_changes SET change_change='".$change."', change_new='".$new."' WHERE change_company='".$data['company_id']."'");
			$query = dbquery("UPDATE ".DB_PREFIX."point_stox_companies SET company_pps='".$new."' WHERE company_id='".$data['company_id']."'");
		
		
		} else {
			$query = dbquery("INSERT INTO ".DB_PREFIX."point_stox_changes VALUES('".$data['company_id']."', '".$change."', '".$new."')");
			$query = dbquery("UPDATE ".DB_PREFIX."point_stox_companies SET company_pps='".$new."' WHERE company_id='".$data['company_id']."'");
		
		}
		$result2 = dbquery("INSERT INTO ".DB_PREFIX."scl VALUES('', '".$data['company_id']."', '".time()."', '".$change."', '".$new."')");
	}
	
	$result = dbquery("UPDATE ".DB_PREFIX."point_stox_update SET last_time='".time()."'");
}

// stock engine latest changes
function se_changes($company, $times){

	global $settings;
	
	$stuff .= "<center><table width=500><tr><td><b>Change</b></td><td><b>New</b></td><td><b>Time</b></td></tr>";
	
	if($_GET['show'] == "all"){
	$result = dbquery("SELECT * FROM ".DB_PREFIX."scl WHERE log_stock='".$company."' ORDER BY log_id DESC");
	} else {
	$result = dbquery("SELECT * FROM ".DB_PREFIX."scl WHERE log_stock='".$company."' ORDER BY log_id DESC LIMIT 0, ".$times."");
	}
	while($data = dbarray($result)){
		$stuff .= "<tr><td>".$data['log_change']."</td><td>".$data['log_new']."</td><td>";;
		$stuff .= ucwords(showdate("%B %d %Y %H:%M:%S", $data['log_time']))."</td></tr>";
	}
	
	$stuff .= "</table><br><br>";
	
	$stuff .= "<a href='".FUSION_SELF."?company_id=".$company."&show=all'>Show all history</a></center>";
	
	return $stuff;
}