}
}
}
}
}
// END 1 === count($arrUser)
// No records found for this username & password
exit(json::encode(array(array('msg', 'Invalid login combination!'))));
} else {
if (isset($_POST['pwdvergeten'])) {
$q = db_query("SELECT id,email,password FROM planets WHERE email = '{$_POST['email']}';");
if (0 < mysql_num_rows($q)) {
$i = mysql_fetch_assoc($q);
$newpwd = substr(md5(time()), 0, 12);
db_query("UPDATE planets SET password ='******'id'] . ':' . $newpwd) . "' WHERE id = " . (int) $i['id'] . ";");
logbook('pwd_reminder', 'email=' . $i['email'] . '&new=' . $newpwd, (int) $i['id']);
$gameaddress = str_replace("index.php", "misc.php", $_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME']);
$gamename0 = str_replace("www.", "", $_SERVER['HTTP_HOST']);
$gamename = "PS " . $gamename0 . " LOGIN";
$headers = "From: PornStarS PASSWORD <pornstars@" . $gamename0 . ">\r\n";
$headers .= "Return-Path: <pornstars@" . $gamename0 . ">\r\n";
$headers .= "X-Sender: <pornstars@" . $gamename0 . ">\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$mailed = mail($i['email'], "PORNSTARS - Forgotten Password", "Your new password: "******"Your password has been sent to \"<b>" . htmlspecialchars($i['email']) . "\"" : "We have failed in sending you your password. Wrong e-mail server";
$color = $mailed ? "green" : "red";
Save_Msg($msg, $color);
Go();
}
Save_Msg("Cant find the emailaddress \"<b>" . htmlspecialchars($_POST['email']) . "</b>\"", "red");
Go();
function Make_GC($f_iGalaxyId)
{
$arrGalaxy = db_select('galaxies', 'id = ' . (int) $f_iGalaxyId);
$arrGalaxy = $arrGalaxy[0];
$iPlanetsInGalaxy = db_count('planets', 'galaxy_id = ' . (int) $f_iGalaxyId);
$iVotesNeeded = floor($iPlanetsInGalaxy / 2) + 1;
$iNewGCPlanetId = (int) db_select_one('planets', 'voted_for_planet_id', 'galaxy_id = ' . (int) $f_iGalaxyId . ' group by voted_for_planet_id having count(1) >= ' . $iVotesNeeded);
if ($iNewGCPlanetId && $iNewGCPlanetId !== (int) $arrGalaxy['gc_planet_id']) {
// Enough votes and not the same as before and the planet is in the galaxy
db_update('galaxies', 'gc_planet_id = ' . (int) $iNewGCPlanetId . ', moc_planet_id = NULL, mow_planet_id = NULL', 'id = ' . (int) $f_iGalaxyId);
logbook('election', 'galaxy_id=' . $f_iGalaxyId . '&gc=' . $iNewGCPlanetId . '&x=' . $arrGalaxy['x'] . '&y=' . $arrGalaxy['y']);
} else {
if (!$iNewGCPlanetId) {
// No planets has enough votes
db_update('galaxies', 'gc_planet_id = NULL, moc_planet_id = NULL, mow_planet_id = NULL', 'id = ' . (int) $f_iGalaxyId);
}
}
}
