Vergleich install/resources/upgrade17.php - 1.6.0 - 1.6.5

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 3Zeile 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 5404 2011-03-19 01:17:10Z jammerx2 $

 */

/**

 */

/**

Zeile 304Zeile 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 371Zeile 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 382Zeile 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 509Zeile 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 577Zeile 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 714Zeile 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}