| Zeile 3 | Zeile 3 |
|---|
* MyBB 1.6
* Copyright 2010 MyBB Group, All Rights Reserved
*
|
* MyBB 1.6
* Copyright 2010 MyBB Group, All Rights Reserved
*
|
* Website: http://www.mybboard.com
| * Website: http://www.mybb.com
|
* License: http://mybb.com/about/license
*
|
* License: http://mybb.com/about/license
*
|
* $Id: upgrade17.php 5151 2010-07-31 08:58:13Z RyanGordon $
| * $Id: upgrade17.php 5828 2012-05-08 16:06:16Z Tomm $
|
*/
/**
| */
/**
|
| Zeile 304 | Zeile 304 |
|---|
switch($db->type)
{
case "pgsql":
|
switch($db->type)
{
case "pgsql":
|
$db->rename_column("moderators", "uid", "id", "int NOT NULL default '0'");
| $db->rename_column("moderators", "uid", "id", "int", true, "'0'");
|
break;
default:
$db->rename_column("moderators", "uid", "id", "int unsigned NOT NULL default '0'");
| break;
default:
$db->rename_column("moderators", "uid", "id", "int unsigned NOT NULL default '0'");
|
| Zeile 371 | Zeile 371 |
|---|
forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)
|
forums text NOT NULL,
groups text NOT NULL,
PRIMARY KEY(pid)
|
) TYPE=MyISAM;");
| ) ENGINE=MyISAM;");
|
$db->write_query("CREATE TABLE ".TABLE_PREFIX."delayedmoderation (
did int unsigned NOT NULL auto_increment,
type varchar(30) NOT NULL default '',
| $db->write_query("CREATE TABLE ".TABLE_PREFIX."delayedmoderation (
did int unsigned NOT NULL auto_increment,
type varchar(30) NOT NULL default '',
|
| Zeile 382 | Zeile 382 |
|---|
dateline bigint(30) NOT NULL default '0',
inputs text NOT NULL,
PRIMARY KEY (did)
|
dateline bigint(30) NOT NULL default '0',
inputs text NOT NULL,
PRIMARY KEY (did)
|
) TYPE=MyISAM;");
| ) ENGINE=MyISAM;");
|
}
$added_tasks = sync_tasks();
| }
$added_tasks = sync_tasks();
|
| Zeile 509 | Zeile 509 |
|---|
$ipaddress = false;
|
$ipaddress = false;
|
$query = $db->simple_select("posts", "ipaddress, longipaddress, pid", "", array('limit_start' => $lower, 'limit' => $ipp));
| $query = $db->simple_select("posts", "ipaddress, pid", "", array('limit_start' => $lower, 'limit' => $ipp));
|
while($post = $db->fetch_array($query))
{
|
while($post = $db->fetch_array($query))
{
|
$db->update_query("posts", array('longipaddress' => my_ip2long($post['ipaddress'])), "pid = '{$post['pid']}'");
| $db->update_query("posts", array('longipaddress' => intval(my_ip2long($post['ipaddress']))), "pid = '{$post['pid']}'");
|
$ipaddress = true;
}
| $ipaddress = true;
}
|
| Zeile 577 | Zeile 577 |
|---|
$ipaddress = false;
$update_array = array();
|
$ipaddress = false;
$update_array = array();
|
$query = $db->simple_select("users", "regip, lastip, longlastip, longregip, uid", "", array('limit_start' => $lower, 'limit' => $ipp));
| $query = $db->simple_select("users", "regip, lastip, uid", "", array('limit_start' => $lower, 'limit' => $ipp));
|
while($user = $db->fetch_array($query))
{
$update_array = array(
| while($user = $db->fetch_array($query))
{
$update_array = array(
|
| Zeile 714 | Zeile 714 |
|---|
*
* Please see the MyBB Wiki for advanced
* database configuration for larger installations
|
*
* Please see the MyBB Wiki for advanced
* database configuration for larger installations
|
* http://wiki.mybboard.net/
| * http://wiki.mybb.com/
|
*/
{$database_config}
| */
{$database_config}
|