| 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 4335 2009-03-22 18:34:20Z Tikitiki $
|
*/
/**
| */
/**
|
| 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}
");
}
|
}
}
}
| }
}
}
|