Zeile 6 | Zeile 6 |
---|
* Website: http://www.mybboard.net * License: http://www.mybboard.net/about/license *
|
* Website: http://www.mybboard.net * License: http://www.mybboard.net/about/license *
|
* $Id: functions_indicators.php 3928 2008-06-20 06:35:10Z Tikitiki $
| * $Id: functions_indicators.php 5379 2011-02-21 11:06:42Z Tomm $
|
*/
/**
| */
/**
|
Zeile 26 | Zeile 26 |
---|
switch($db->type) { case "pgsql":
|
switch($db->type) { case "pgsql":
|
| case "sqlite2": case "sqlite3":
|
$db->shutdown_query($db->build_replace_query("threadsread", array('tid' => $tid, 'uid' => $mybb->user['uid'], 'dateline' => TIME_NOW), "tid")); break; default:
| $db->shutdown_query($db->build_replace_query("threadsread", array('tid' => $tid, 'uid' => $mybb->user['uid'], 'dateline' => TIME_NOW), "tid")); break; default:
|
Zeile 188 | Zeile 190 |
---|
$mark_query = ''; $done = 0; foreach(array_keys($forums) as $fid)
|
$mark_query = ''; $done = 0; foreach(array_keys($forums) as $fid)
|
{ if($mark_query != '') $mark_query .= ', ';
$mark_query .= "('{$fid}', '{$mybb->user['uid']}', '".TIME_NOW."')";
| { switch($db->type) { case "pgsql": $mark_query[] = array('fid' => $fid, 'uid' => $mybb->user['uid'], 'dateline' => TIME_NOW); break; default: if($mark_query != '') $mark_query .= ', '; $mark_query .= "('{$fid}', '{$mybb->user['uid']}', '".TIME_NOW."')"; }
|
++$done;
|
++$done;
|
|
|
// Only do this in loops of $update_count, save query time if($done % $update_count)
|
// Only do this in loops of $update_count, save query time if($done % $update_count)
|
{ $db->shutdown_query(" REPLACE INTO ".TABLE_PREFIX."forumsread (fid, uid, dateline) VALUES {$mark_query} "); $mark_query = ''; }
| { switch($db->type) { case "pgsql": foreach($mark_query as $replace_query) { $db->shutdown_query($db->build_replace_query("forumsread", $replace_query, "fid")); } $mark_query = array(); break; default: $db->shutdown_query(" REPLACE INTO ".TABLE_PREFIX."forumsread (fid, uid, dateline) VALUES {$mark_query} "); $mark_query = ''; } }
|
}
|
}
|
|
|
if($mark_query != '') {
|
if($mark_query != '') {
|
$db->shutdown_query(" REPLACE INTO ".TABLE_PREFIX."forumsread (fid, uid, dateline) VALUES {$mark_query} ");
| switch($db->type) { case "pgsql": foreach($mark_query as $replace_query) { $db->shutdown_query($db->build_replace_query("forumsread", $replace_query, "fid")); } break; default: $db->shutdown_query(" REPLACE INTO ".TABLE_PREFIX."forumsread (fid, uid, dateline) VALUES {$mark_query} "); }
|
} } }
| } } }
|