// $result = mysql_query($sql);
// check points
$sql = "Select name, ra2pes5 from {$playerstable} where approved = 'yes' and pes5games > 0 order by ra2pes5 desc";
$result = mysql_query($sql);
$checkPointsRes = "";
$vers = "'A', 'B', 'C'";
while ($row = mysql_fetch_array($result)) {
$name = $row['name'];
$ra2pes5 = $row['ra2pes5'];
$sql1 = "SELECT sum( winpoints ) as winpts FROM {$gamestable} " . "WHERE (winner LIKE '{$name}' OR winner2 LIKE '{$name}') AND deleted = 'no' AND season = '{$season}' AND version in (" . $vers . ") AND teamLadder = 0";
$result1 = mysql_query($sql1);
$row1 = mysql_fetch_array($result1);
$winpts = $row1['winpts'];
$sql2 = "SELECT sum(losepoints) as losepts1 FROM {$gamestable} " . "WHERE (loser LIKE '{$name}') AND deleted = 'no' AND season = '{$season}' AND version in (" . $vers . ") AND teamLadder = 0";
$result2 = mysql_query($sql2);
$row2 = mysql_fetch_array($result2);
$losepts1 = $row2['losepts1'];
$sql3 = "SELECT sum(losepoints2) as losepts2 FROM {$gamestable} " . "WHERE (loser2 LIKE '{$name}') AND deleted = 'no' and season = '{$season}' AND teamLadder = 0";
$result3 = mysql_query($sql3);
$row3 = mysql_fetch_array($result3);
$losepts2 = $row3['losepts2'];
$total = $winpts - $losepts1 - $losepts2;
if ($total != $ra2pes5) {
$checkPointsRes .= "player [" . $name . "] has [" . $ra2pes5 . "] points but should have [" . $total . "]\n";
}
}
if (!empty($checkPointsRes)) {
$adminSubject = "[{$leaguename} FIFA] errors detected";
sendAdminMail($adminSubject, $checkPointsRes);
}
$log->logInfo('runDaily: end');
#!/usr/bin/php
<?php
require '/var/www/yoursite/http/variables.php';
require '/var/www/yoursite/http/variablesdb.php';
require_once '/var/www/yoursite/http/Admin/functions.php';
require '/var/www/yoursite/http/log/KLogger.php';
$log = new KLogger('/var/www/yoursite/http/log/cron/', KLogger::INFO);
$backSpan = 60 * 60 * 24 * 14;
$sql = "SELECT * from {$playerstable} where approved='no' AND signupSent=0 AND rejected=0 and UNIX_TIMESTAMP() - joindate < {$backSpan} " . "ORDER BY joindate ASC limit 0, 20";
$num = mysql_num_rows(mysql_query($sql));
if ($num > 1) {
$adminSubject = "[" . $leaguename . " admin] " . $num . " to approve";
$adminMessage = "http://www.yoursite/Admin/approvePlayers.php";
sendAdminMail($adminSubject, $adminMessage);
}
