έγκυρο ID χρήστη.”;
}
else if ($countres > 1)
{
echo “Υπάρχει σημαντικό πρόβλημα στην βάση λύσεων όσον αφορά τον συγκεκριμένο χρήστη. Παρακαλώ αναφέρετε ΑΜΕΣΑ το πρόβλημα στους διαχειριστές.”;
}
else
{
$UserName = mysql_result($results, 0, “UserName”);
$WebSite = mysql_result($results, 0, “WebSite”);
$WebSite = ‘‘ . $WebSite . ‘‘;
$Date = date(“j-M-y”, mysql_result($results, 0, “Date”) + $servertimeoffset * 3600);
$query = “SELECT PID, Date FROM solman_solutions_queue WHERE UID=” . $UserID . ” AND State = 1 ORDER BY Date DESC”;
$PuzzlesHeSolved = mysql_query($query, $sqlconnection);
$resquant = mysql_num_rows($PuzzlesHeSolved);
$Score = 0;
for ($i = 0; $i < $resquant; $i++)
{
$PuzID = mysql_result($PuzzlesHeSolved, $i, "PID");
$query = "SELECT UID, Date FROM solman_solutions_queue WHERE PID=" . $PuzID . " AND State = 1 ORDER BY Date ASC";
$isHeTheFirst = mysql_query($query, $sqlconnection);
if (mysql_result($isHeTheFirst, 0, "UID") == $UserID)
{
$DateSolved = mysql_result($PuzzlesHeSolved, $i, "Date") + $servertimeoffset * 3600;
$query = "SELECT post_title, post_date FROM wp_posts WHERE ID=" . $PuzID;
$results = mysql_query($query, $sqlconnection);
$PuzTitle = mysql_result($results, 0, "post_title");
$PuzTitle = '‘ . $PuzTitle . ‘‘;
$DatePosted = strtotime(mysql_result($results, 0, “post_date”));
$Interval = intval(($DateSolved – $DatePosted) / 86400);
$DateSolvedArray[] = $DateSolved;
$PuzTitleArray[] = $PuzTitle;
$IntervalArray[] = $Interval;
$Score++;
}
}
$query = ‘SELECT Points FROM solman_users WHERE ID=’ . $UserID;
$results = mysql_query($query, $sqlconnection);
$Points = (mysql_result($results, 0, “Points”)) / 100;
?>
Λυμένοι Γρίφοι
| # | Τίτλος | Ημερομηνία λύσης | Αξία λύσης | ‘ . $aa . ‘ | ‘ . $PuzTitleArray[$i] . ‘ |
‘ . date(“j-M-y”, $DateSolvedArray[$i]) . ‘ ‘ . $IntervalString . ‘ |
‘ . ((intval(sqrt($IntervalArray[$i] + 1) * 100)) / 100) . ‘ |