include WWW_ROOT . 'lib/members.lib.php';
include WWW_ROOT . 'lib/networking.lib.php';
include WWW_ROOT . 'lib/version.lib.php';
include WWW_ROOT . 'lib/cluster.lib.php';
include WWW_ROOT . 'lib/mail.lib.php';
$db = new sql_db(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$whereCond = "m_mailer_enable = 1 AND m_state != 'deleted'";
while ($m = $db->find("members", $whereCond)) {
$member = member_load($m["m_id"]);
if ($member->m["m_paid_until"] - time() <= 604800) {
$subject = $cluster_cfg->get("mailer_tpl_payment_warning_subj");
$subject = str_replace("%member%", $m["m_nick"], $subject);
$content = $cluster_cfg->get("mailer_tpl_payment_warning");
$content = str_replace("%member%", $m["m_nick"], $content);
$content = str_replace("%memberid%", $m["m_id"], $content);
$content = str_replace("%expiredate%", $m["m_paid_until"] ? strftime("%Y-%m-%d", $m["m_paid_until"]) : '---', $content);
$content = str_replace("%monthly%", $m["m_monthly_payment"], $content);
send_mail($m["m_mail"], $subject, $content, $cluster_cfg->get("mailer_admins_in_cc") ? explode(",", $cluster_cfg->get("mailer_admins_cc_mails")) : array());
}
}
$rs = $db->query("SELECT v.vps_id, vps_expiration, m_nick, m_mail FROM vps v\n INNER JOIN members m ON v.m_id = m.m_id\n WHERE m_mailer_enable = 1\n AND vps_expiration IS NOT NULL\n AND vps_deleted IS NULL\n AND DATE_SUB(FROM_UNIXTIME(vps_expiration), INTERVAL 7 DAY) < NOW()\n AND FROM_UNIXTIME(vps_expiration) > NOW()");
while ($row = $db->fetch_array($rs)) {
$subject = $cluster_cfg->get("mailer_tpl_vps_expiration_subj");
$subject = str_replace("%member%", $row["m_nick"], $subject);
$subject = str_replace("%vpsid%", $row["vps_id"], $subject);
$content = $cluster_cfg->get("mailer_tpl_vps_expiration");
$content = str_replace("%member%", $row["m_nick"], $content);
$content = str_replace("%vpsid%", $row["vps_id"], $content);
$content = str_replace("%datetime%", strftime("%Y-%m-%d %H:%M", $row["vps_expiration"]), $content);
send_mail($row["m_mail"], $subject, $content);
}
echo '<option value="' . $tpl["templ_id"] . '">' . $tpl["templ_label"] . '</option>';
}
?>
</select>
<span>Preferovaná lokace pro VPS:</span>
<select name="location" id="location">
<?php
$sql = 'SELECT location_id, location_label
FROM locations l
INNER JOIN servers s ON l.location_id = s.server_location
WHERE s.environment_id = ' . $db->check(ENVIRONMENT_ID) . '
GROUP BY location_id
ORDER BY location_id';
$rs = $db->query($sql);
while ($loc = $db->fetch_array($rs)) {
echo '<option value="' . $loc["location_id"] . '">Master Internet ' . $loc["location_label"] . '</option>';
}
?>
</select>
<span>Měna platby:</span>
<select name="currency" id="currency">
<option value="CZK">členský poplatek 900 Kč na tři měsíce</option>
<option value="EUR">členský poplatek 36 eur na tři měsíce</option>
</select>
<input type="submit" name="send" id="send" class="largeButton" value="Odeslat" onclick="signup(); return false;">
</form>
</div>
</section>
$_SESSION["is_admin"] = true;
define('CRON_MODE', true);
define('DEMO_MODE', false);
// Include libraries
include WWW_ROOT . 'lib/db.lib.php';
include WWW_ROOT . 'lib/functions.lib.php';
include WWW_ROOT . 'lib/version.lib.php';
include WWW_ROOT . 'lib/cluster.lib.php';
$db = new sql_db(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($cluster_cfg->get("maintenance_mode")) {
echo "MAINTENANCE";
exit;
}
$rs = $db->query("SELECT server_id, server_name\n FROM locations l\n INNER JOIN servers s ON l.location_id = s.server_location\n WHERE server_maintenance = 0\n ORDER BY l.location_id, s.server_id");
$bad = false;
while ($row = $db->fetch_array($rs)) {
$sql = 'SELECT * FROM servers_status WHERE server_id ="' . $row["server_id"] . '"';
if ($result = $db->query($sql)) {
$status = $db->fetch_array($result);
}
if (time() - $status["timestamp"] > 150) {
if (!$bad) {
$bad = true;
header('HTTP/1.1 503 Service Unavailable');
}
echo $row["server_name"] . "\n";
}
}
if (!$bad) {
echo "OK";
}
