This works fine, except when you refresh more than once quickly. If you refresh at a faster rate than about 1 second, you get:
Code: Select all
Error Type : 256 :: Error: Duplicate entry '7002e886904e59041bf4f11655a2eaed' for key 1
SQL: INSERT INTO `sessions` SET `sessionID` = '7002e886904e59041bf4f11655a2eaed', `userID` = '-1', `session_begin` = '1114827569', `session_time` = '1114827569', `referer` = 'http://www.yogler.net/beta_test.4.26.05.php' :: File: /home/yogle/includes/classes/db/db.class.php :: Line: 179Code: Select all
$refresh = new DB();
$refresh->prepare( CURRENT_TIME, $referer, $this->identifier );
$refresh->query("e;UPDATE `sessions` SET `session_time` = ':1', `referer` = ':2' WHERE `sessionID` = ':3'"e;);
//
// If no affected rows, then we have to create a session
//
if ( $refresh->affected_rows() < 1 )
{
$create = new DB();
$create->prepare( $this->identifier, $userID, CURRENT_TIME, $referer);
$create->query("e;INSERT INTO `sessions` SET `sessionID` = ':1', `userID` = ':2', `session_begin` = ':3', `session_time` = ':3', `referer` = ':4'"e;);
}Thanks,
- Monkey