// $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); }