/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071500.php |
---|
New file |
0,0 → 1,8 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the message-table with an index for unapproved messages |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} CHANGE list_length list_length_flat INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD list_length_threaded INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `list_length_flat` "; |
$upgrade_queries[]="UPDATE {$PHORUM['forums_table']} SET list_length_threaded = list_length_flat/2 "; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005091400.php |
---|
New file |
0,0 → 1,87 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// Create tables for the new PM system. |
$upgrade_queries[]= "CREATE TABLE {$PHORUM["pm_messages_table"]} ( |
pm_message_id int(10) unsigned NOT NULL auto_increment, |
from_user_id int(10) unsigned NOT NULL default '0', |
from_username varchar(50) NOT NULL default '', |
subject varchar(100) NOT NULL default '', |
message text NOT NULL default '', |
datestamp int(10) unsigned NOT NULL default '0', |
meta mediumtext NOT NULL default '', |
PRIMARY KEY (pm_message_id) |
) TYPE=MyISAM"; |
$upgrade_queries[] = "CREATE TABLE {$PHORUM["pm_folders_table"]} ( |
pm_folder_id int(10) unsigned NOT NULL auto_increment, |
user_id int(10) unsigned NOT NULL default '0', |
foldername varchar(20) NOT NULL default '', |
KEY user_id (user_id), |
PRIMARY KEY (pm_folder_id) |
) TYPE=MyISAM"; |
$upgrade_queries[] = "CREATE TABLE {$PHORUM["pm_xref_table"]} ( |
pm_xref_id int(10) unsigned NOT NULL auto_increment, |
user_id int(10) unsigned NOT NULL default '0', |
pm_folder_id int(10) unsigned NOT NULL default '0', |
special_folder varchar(10), |
pm_message_id int(10) unsigned NOT NULL default '0', |
read_flag tinyint(1) NOT NULL default '0', |
reply_flag tinyint(1) NOT NULL default '0', |
PRIMARY KEY (pm_xref_id), |
KEY xref (user_id,pm_folder_id,pm_message_id), |
KEY read_flag (read_flag) |
) TYPE=MyISAM"; |
// converting the old PM system to the new one. |
$old_table = "{$PHORUM['DBCONFIG']['table_prefix']}_private_messages"; |
$res=mysql_query("SELECT * FROM $old_table"); |
while($row=mysql_fetch_assoc($res)) |
{ |
// Put the message in the message table. |
$meta = serialize(array( |
'recipients' => array( |
$row["to_user_id"] => array ( |
'user_id' => $row["to_user_id"], |
'username' => $row["to_username"], |
'read_flag' => $row["read_flag"], |
) |
) |
)); |
$sql = "INSERT INTO {$PHORUM["pm_messages_table"]} SET " . |
"pm_message_id = {$row["private_message_id"]}, " . |
"from_user_id = {$row["from_user_id"]}, " . |
"from_username = '" . addslashes($row["from_username"]) . "', " . |
"subject = '" . addslashes($row['subject']) . "', " . |
"message = '" . addslashes($row['message']) . "', " . |
"datestamp = {$row["datestamp"]}, " . |
"meta = '" . addslashes($meta) . "'"; |
$upgrade_queries[] = $sql; |
// Link message to recipient inbox. |
if (! $row["to_del_flag"]) { |
$sql = "INSERT INTO {$PHORUM["pm_xref_table"]} SET " . |
"user_id = {$row["to_user_id"]}, " . |
"pm_folder_id = 0, " . |
"special_folder = '" . PHORUM_PM_INBOX . "', " . |
"pm_message_id = {$row["private_message_id"]}, " . |
"read_flag = {$row["read_flag"]}, " . |
"reply_flag = {$row["reply_flag"]}"; |
$upgrade_queries[] = $sql; |
} |
// Link message to sender outbox. |
if (! $row["from_del_flag"]) { |
$sql = "INSERT INTO {$PHORUM["pm_xref_table"]} SET " . |
"user_id = {$row["from_user_id"]}, " . |
"pm_folder_id = 0, " . |
"special_folder = '" . PHORUM_PM_OUTBOX . "', " . |
"pm_message_id = {$row["private_message_id"]}, " . |
"read_flag = 1, " . |
"reply_flag = 0"; |
$upgrade_queries[] = $sql; |
} |
} |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071900.php |
---|
New file |
0,0 → 1,5 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD display_fixed TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004081900.php |
---|
New file |
0,0 → 1,10 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key forum_max_message"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key forum_max_message (forum_id, message_id, status, parent_id)"; |
$upgrade_queries[]="insert into {$PHORUM['settings_table']} values ('show_new_on_index', 'V', '1')"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004012400.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the tables for the mixed mode |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} CHANGE threaded threaded_list TINYINT( 4 ) DEFAULT '0' NOT NULL, ADD threaded_read TINYINT( 4 ) DEFAULT '0' NOT NULL"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} CHANGE threaded threaded_list TINYINT( 4 ) DEFAULT '0' NOT NULL, ADD threaded_read TINYINT( 4 ) DEFAULT '0' NOT NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003082100.php |
---|
New file |
0,0 → 1,17 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_thread"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY modifystamp_thread"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_mod"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_thread"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY message_status_thread"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY message_status_mod"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_id"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop KEY parent_status_forum"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY list_page_flat (thread,forum_id,status,parent_id,sort)"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY special_threads (sort,forum_id)"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add KEY list_page_float (modifystamp,forum_id,status,parent_id,sort)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080300.php |
---|
New file |
0,0 → 1,37 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// wow doing it all by hand this time :( |
$cid=phorum_db_mysql_connect(); |
// adding the new field |
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} ADD message_id INT( 11 ) NOT NULL",$cid); |
// removing old primary-key |
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} DROP PRIMARY KEY",$cid); |
// adding new primary-key |
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} ADD PRIMARY KEY ( user_id , forum_id , message_id )",$cid); |
// converting the newflags |
$res=mysql_query("SELECT * FROM {$PHORUM['user_newflags_table']} where message_id=0",$cid); |
$olduser=$GLOBALS['PHORUM']['user']['user_id']; |
while($row=mysql_fetch_assoc($res)) { |
$forum=$row['forum_id']; |
$data=unserialize($row['newflags']); |
$GLOBALS['PHORUM']['user']['user_id']=$row['user_id']; |
$newdata=array(); |
foreach($data as $mid1 => $mid2) { |
if(is_int($mid1)) { |
$newdata[]=array("id"=>$mid1,"forum"=>$forum); |
} |
} |
phorum_db_newflag_add_read($newdata); |
unset($data); |
unset($newdata); |
} |
$GLOBALS['PHORUM']['user']['user_id']=$olduser; |
mysql_query("DELETE FROM {$PHORUM['user_newflags_table']} where message_id=0",$cid); |
// remove old column |
mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} DROP newflags",$cid); |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003060600.php |
---|
New file |
0,0 → 1,4 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD posts int(10) NOT NULL default '0'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005101800.php |
---|
New file |
0,0 → 1,5 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} add column sticky_count int(10) unsigned NOT NULL default '0'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005101801.php |
---|
New file |
0,0 → 1,10 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// Refresh all forum statistics for making bringing thread_count up to date. |
$forums = phorum_db_get_forums(); |
foreach ($forums as $forum) { |
$GLOBALS["PHORUM"]["forum_id"] = $forum["forum_id"]; |
phorum_db_update_forum_stats(true); |
} |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080500.php |
---|
New file |
0,0 → 1,11 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key list_page_float"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key list_page_flat"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key list_page_float (forum_id, parent_id, modifystamp)"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key list_page_flat (forum_id, parent_id, thread)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005082300.php |
---|
New file |
0,0 → 1,10 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['files_table']} add column link varchar(10) NOT NULL DEFAULT ''"; |
$upgrade_queries[]="drop index message_id on {$PHORUM['files_table']}"; |
$upgrade_queries[]="create index message_id_link on {$PHORUM['files_table']} (message_id, link)"; |
$upgrade_queries[]="update {$PHORUM['files_table']} set link='message' where message_id != 0"; |
$upgrade_queries[]="update {$PHORUM['files_table']} set link='user' where message_id = 0"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080700.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} CHANGE email_temp email_temp VARCHAR( 110 )"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092300.php |
---|
New file |
0,0 → 1,12 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]= "CREATE TABLE {$PHORUM["pm_buddies_table"]} ( |
pm_buddy_id int(10) unsigned NOT NULL auto_increment, |
user_id int(10) unsigned NOT NULL, |
buddy_user_id int(10) unsigned NOT NULL, |
PRIMARY KEY pm_buddy_id (pm_buddy_id), |
UNIQUE KEY userids (user_id, buddy_user_id) |
) TYPE=MyISAM"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004090700.php |
---|
New file |
0,0 → 1,10 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} ADD last_active_forum INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER date_last_active"; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} drop key activity"; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add key activity (date_last_active,hide_activity,last_active_forum)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003092700.php |
---|
New file |
0,0 → 1,5 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="CREATE TABLE {$PHORUM['banlist_table']} ( id int(11) NOT NULL auto_increment, forum_id int(11) NOT NULL default '0', type tinyint(4) NOT NULL default '0', pcre tinyint(4) NOT NULL default '0', string varchar(255) NOT NULL default '', PRIMARY KEY (id), KEY forum_id (forum_id)) TYPE=MyISAM"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031000.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} drop index `search`"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004021200.php |
---|
New file |
0,0 → 1,8 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="ALTER TABLE {$PHORUM['files_table']} add message_id int unsigned not null default 0"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['files_table']} add key (message_id)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031200.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="UPDATE {$PHORUM['forums_table']} set active=1"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100400.php |
---|
New file |
0,0 → 1,12 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]= "alter table {$PHORUM["forums_table"]} modify inherit_id int(10) unsigned default '0'"; |
$upgrade_queries[]= "update {$PHORUM["forums_table"]} set inherit_id=NULL where inherit_id=0"; |
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='default_forum_options', type='S', data='".mysql_escape_string('a:24:{s:8:"forum_id";s:1:"0";s:10:"moderation";s:1:"0";s:16:"email_moderators";s:1:"0";s:9:"pub_perms";i:1;s:9:"reg_perms";i:15;s:13:"display_fixed";i:0;s:8:"template";s:7:"default";s:8:"language";s:7:"english";s:13:"threaded_list";s:1:"0";s:13:"threaded_read";s:1:"0";s:17:"reverse_threading";s:1:"0";s:12:"float_to_top";s:1:"1";s:16:"list_length_flat";i:30;s:20:"list_length_threaded";i:30;s:11:"read_length";s:2:"30";s:18:"display_ip_address";s:1:"0";s:18:"allow_email_notify";s:1:"0";s:15:"check_duplicate";s:1:"1";s:11:"count_views";s:1:"2";s:15:"max_attachments";i:0;s:22:"allow_attachment_types";s:0:"";s:19:"max_attachment_size";i:0;s:24:"max_totalattachment_size";i:0;s:5:"vroot";i:0;}')."'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031201.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="ALTER TABLE {$PHORUM['private_message_table']} add key `read_flag` (`to_user_id`,`read_flag`)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100600.php |
---|
New file |
0,0 → 1,13 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]= "alter table {$PHORUM["user_table"]} add sessid_st_timeout int(10) unsigned not null default 0"; |
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='short_session_timeout', type='V', data='60'"; |
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='tight_security', type='V', data='0'"; |
$upgrade_queries[]= "insert into {$PHORUM["settings_table"]} set name='admin_session_salt', type='V', data='".microtime()."'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004100700.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key post_count, add key post_count (forum_id, status, parent_id)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003112500.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['forums_table']} drop email_outgoing_address, drop email_incoming_address, drop email_subject_tag"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071000.php |
---|
New file |
0,0 → 1,8 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the message-table with an index for unapproved messages |
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} ADD INDEX status_forum ( status , forum_id )"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005120400.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]= "alter table {$PHORUM["user_table"]} add moderation_email tinyint(2) unsigned not null default 1"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112600.php |
---|
New file |
0,0 → 1,10 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD `show_signature` TINYINT( 1 ) DEFAULT '0' NOT NULL , |
ADD `email_notify` TINYINT( 1 ) DEFAULT '0' NOT NULL , |
ADD `tz_offset` TINYINT( 2 ) DEFAULT '-99' NOT NULL, |
ADD `is_dst` TINYINT( 1 ) DEFAULT '0' NOT NULL , |
ADD `user_language` VARCHAR( 100 ) NOT NULL , |
ADD `user_template` VARCHAR( 100 ) NOT NULL "; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112601.php |
---|
New file |
0,0 → 1,9 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="CREATE TABLE {$PHORUM['user_custom_fields_table']} ( |
user_id INT DEFAULT '0' NOT NULL , |
type INT DEFAULT '0' NOT NULL , |
data TEXT NOT NULL , |
PRIMARY KEY ( user_id , type )) TYPE=MyISAM"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004061400.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the user tables for email-changes |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD email_temp VARCHAR( 101 ) NOT NULL AFTER email" ; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD INDEX ( email_temp ) "; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004073100.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} CHANGE email email VARCHAR( 100 ) NOT NULL"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} CHANGE email email VARCHAR( 100 ) NOT NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005102700.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['search_table']} ADD COLUMN forum_id int(10) UNSIGNED NOT NULL DEFAULT '0', ADD KEY forum_id (forum_id)"; |
$upgrade_queries[]="UPDATE {$PHORUM['search_table']}, {$PHORUM['message_table']} set {$PHORUM['search_table']}.forum_id={$PHORUM['message_table']}.forum_id where {$PHORUM['search_table']}.message_id={$PHORUM['message_table']}.message_id"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112800.php |
---|
New file |
0,0 → 1,5 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD `vroot` INT( 10 ) DEFAULT '0' NOT NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112602.php |
---|
New file |
0,0 → 1,28 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
/* |
ALTER TABLE {$PHORUM['user_table']} ADD `show_signature` TINYINT( 1 ) DEFAULT '0' NOT NULL , |
ADD `email_notify` TINYINT( 1 ) DEFAULT '0' NOT NULL , |
ADD `tz_offset` TINYINT( 2 ) DEFAULT NULL , |
ADD `is_dst` TINYINT( 1 ) DEFAULT '0' NOT NULL , |
ADD `user_language` VARCHAR( 100 ) NOT NULL , |
ADD `user_template` VARCHAR( 100 ) NOT NULL ; |
create additional table for custom-fields |
*/ |
// converting custom-field settings |
if(!isset($PHORUM['PROFILE_FIELDS']['num_fields'])) { |
$new_profile_fields=array(); |
foreach($PHORUM['PROFILE_FIELDS'] as $id => $name) { |
$new_profile_fields[$id]=array('name'=>$name,'length'=>255,'html_disabled'=>0); |
} |
$new_profile_fields['num_fields']=count($new_profile_fields); |
$PHORUM['PROFILE_FIELDS']=$new_profile_fields; |
// saving them |
phorum_db_update_settings(array('PROFILE_FIELDS'=>$new_profile_fields)); |
} |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004112603.php |
---|
New file |
0,0 → 1,70 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$cid=phorum_db_mysql_connect(); |
// converting the custom-fields |
$res=mysql_query("SELECT user_id,user_data FROM {$PHORUM['user_table']}",$cid); |
while($row=mysql_fetch_assoc($res)) { |
$userdata=array('user_id'=>$row['user_id']); |
$user_data_new=array(); |
$user_data_old=unserialize($row['user_data']); |
// converting meta-data to fields |
if(isset($user_data_old['show_signature']) && !empty($user_data_old['show_signature'])) |
$userdata['show_signature']=$user_data_old['show_signature']; |
if(isset($user_data_old['email_notify']) && !empty($user_data_old['email_notify'])) |
$userdata['email_notify']=$user_data_old['email_notify']; |
if(isset($user_data_old['tz_offset']) && !empty($user_data_old['tz_offset'])) |
$userdata['tz_offset']=$user_data_old['tz_offset']; |
if(isset($user_data_old['is_dst']) && !empty($user_data_old['is_dst'])) |
$userdata['is_dst']=$user_data_old['is_dst']; |
if(isset($user_data_old['user_language']) && !empty($user_data_old['user_language'])) |
$userdata['user_language']=$user_data_old['user_language']; |
if(isset($user_data_old['user_template']) && !empty($user_data_old['user_template'])) |
$userdata['user_template']=$user_data_old['user_template']; |
unset($user_data_old['user_template']); |
unset($user_data_old['user_language']); |
unset($user_data_old['is_dst']); |
unset($user_data_old['tz_offset']); |
unset($user_data_old['email_notify']); |
unset($user_data_old['show_signature']); |
// converting custom-fields now |
if(is_array($user_data_old) && count($user_data_old)) { |
foreach($user_data_old as $old_key => $old_val) { |
$type=-1; |
// find out which ID that custom-field has |
foreach($PHORUM['PROFILE_FIELDS'] as $ctype => $cdata) { |
if($cdata['name'] == $old_key) { |
$type=$ctype; |
break; |
} |
} |
if($type != -1) { // store it only if we found it |
if( $old_val!=="" ) { |
if(!is_array($old_val)) { |
$user_data_new[$type] = substr($old_val,0,$PHORUM['PROFILE_FIELDS'][$type]['length']); |
} else { |
$user_data_new[$type] = $old_val; |
} |
} |
} |
} |
} |
$userdata['user_data']=$user_data_new; |
phorum_user_save($userdata); |
} |
// remove old column |
//mysql_query("ALTER TABLE {$PHORUM['user_newflags_table']} DROP newflags",$cid); |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005031900.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD `sessid` varchar(50) NOT NULL default '',add key sessid (sessid)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003091700.php |
---|
New file |
0,0 → 1,10 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop attachments"; |
$upgrade_queries[]="CREATE TABLE {$PHORUM['files_table']} ( file_id int(11) NOT NULL auto_increment, user_id int(11) NOT NULL default '0', filename varchar(255) NOT NULL default '', filesize int(11) NOT NULL default '0', file_data mediumtext NOT NULL, add_datetime int(10) unsigned NOT NULL default '0', PRIMARY KEY (file_id), KEY add_datetime (add_datetime) ) TYPE=MyISAM"; |
$upgrade_queries[]="CREATE TABLE {$PHORUM['message_files_xref_table']} ( message_id int(11) NOT NULL default '0', file_id int(11) NOT NULL default '0', PRIMARY KEY (message_id, file_id) ) TYPE=MyISAM"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003103000.php |
---|
New file |
0,0 → 1,11 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} drop allow_html"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} add registration_control tinyint(1) NOT NULL default '0'"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} change sec_public pub_perms int(10) unsigned NOT NULL default '0'"; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} change sec_reg reg_perms int(10) unsigned NOT NULL default '0'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003060100.php |
---|
New file |
0,0 → 1,4 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['user_table']} ADD password_temp varchar(50) NOT NULL default ''"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003022400.php |
---|
New file |
0,0 → 1,4 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD edit_post TINYINT unsigned NOT NULL DEFAULT 1"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003072000.php |
---|
New file |
0,0 → 1,4 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD check_duplicate tinyint(4) NOT NULL default '0'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005062000.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD `reverse_threading` tinyint(1) NOT NULL default '0'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005101700.php |
---|
New file |
0,0 → 1,5 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} change column inherit_id inherit_id int(10) unsigned default NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003052600.php |
---|
New file |
0,0 → 1,4 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD template_settings text NOT NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005022800.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="CREATE TABLE {$PHORUM['search_table']} ( message_id int(10) unsigned NOT NULL default '0', search_text mediumtext NOT NULL, PRIMARY KEY (message_id), FULLTEXT KEY search_text (search_text) ) TYPE=MyISAM"; |
$upgrade_queries[]="insert into {$PHORUM['search_table']} select message_id, concat(author, ' | ', subject, ' | ', body) from {$PHORUM['message_table']}"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005070500.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add column moderator_data text not null default '';"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080600.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['forums_table']} modify description text not null default ''"; |
$upgrade_queries[]="alter table {$PHORUM['user_newflags_table']} drop newflags"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004032900.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['private_message_table']} drop KEY read_flag"; |
$upgrade_queries[]="alter table {$PHORUM['private_message_table']} add KEY read_flag (to_user_id,read_flag,to_del_flag)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092200.php |
---|
New file |
0,0 → 1,35 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// Check if all the tables from version 2005091400 were created, |
// before dropping the old private messages table. |
$old_table = "{$PHORUM['DBCONFIG']['table_prefix']}_private_messages"; |
$cid=phorum_db_mysql_connect(); |
$check_tables = array( |
$PHORUM["pm_messages_table"] => 1, |
$PHORUM["pm_folders_table"] => 1, |
$PHORUM["pm_xref_table"] => 1, |
); |
$res = mysql_query("show tables"); |
if ($res) { |
while (($row = mysql_fetch_array($res))) { |
if (isset($check_tables[$row[0]])) { |
unset($check_tables[$row[0]]); |
} |
} |
} |
if (count($check_tables)) { ?> |
<br/> |
<b>Warning: database upgrade 2005091400 does not seem to have |
completed successfully. The old style private messages table |
<?php print $old_table ?> will be kept for backup. <?php |
} else { |
$upgrade_queries[] = "DROP TABLE $old_table"; |
} |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080601.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key post_count (forum_id,status,parent_id)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004032901.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="alter table {$PHORUM['forums_table']} drop registration_control;"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005062600.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['forums_table']} ADD `inherit_id` int(10) unsigned default '0' not null"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092201.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add column pm_email_notify tinyint ( 1 ) default '1' not null"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004052900.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add viewcount int(10) unsigned NOT NULL default '0'"; |
$upgrade_queries[]="alter table {$PHORUM['forums_table']} add count_views tinyint(1) unsigned NOT NULL default '0'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004080800.php |
---|
New file |
0,0 → 1,17 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add closed tinyint(4) NOT NULL default '0'"; |
$upgrade_queries[]="update {$PHORUM['message_table']} set closed=1, status=2 where status=1"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key dup_check (forum_id,author,subject,datestamp)"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} drop key message_id"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key forum_max_message (forum_id, message_id)"; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} add key last_post_time (forum_id, status, modifystamp)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005072600.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} CHANGE meta meta mediumtext NOT NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005092400.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]= "alter table {$PHORUM['user_table']} add column cookie_sessid_lt varchar(50) NOT NULL default '',change column sessid sessid_st varchar(50) NOT NULL default '',add index sessid_st (sessid_st),add index cookie_sessid_lt (cookie_sessid_lt),drop index sessid"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005082800.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['forums_table']} add column max_totalattachment_size int(10) unsigned default 0"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003112001.php |
---|
New file |
0,0 → 1,7 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="CREATE TABLE {$PHORUM['private_message_table']} ( private_message_id int(10) unsigned NOT NULL auto_increment, from_username varchar(50) NOT NULL default '', to_username varchar(50) NOT NULL default '', from_user_id int(10) unsigned NOT NULL default '0', to_user_id int(10) unsigned NOT NULL default '0', subject varchar(100) NOT NULL default '', message text NOT NULL, datestamp int(10) unsigned NOT NULL default '0', read_flag tinyint(1) NOT NULL default '0', reply_flag tinyint(1) NOT NULL default '0', to_del_flag tinyint(1) NOT NULL default '0', from_del_flag tinyint(1) NOT NULL default '0', PRIMARY KEY (private_message_id), KEY to_user_id (to_user_id,to_del_flag,datestamp), KEY from_user_id (from_user_id,from_del_flag,datestamp), KEY to_del_flag (to_del_flag,from_del_flag) ) TYPE=MyISAM"; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} modify active tinyint(1) NOT NULL default '0'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100300.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]= "alter table {$PHORUM["pm_buddies_table"]} add index buddy_user_id (buddy_user_id)"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004071100.php |
---|
New file |
0,0 → 1,8 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the message-table with an index for unapproved messages |
$upgrade_queries[]="ALTER TABLE {$PHORUM['groups_table']} ADD open tinyint(3) NOT NULL default '0' AFTER name"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004061300.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="alter table {$PHORUM['user_group_xref_table']} add status tinyint(3) NOT NULL default '1'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2003011801.php |
---|
New file |
0,0 → 1,4 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} ADD edit_count TINYINT unsigned NOT NULL DEFAULT 0, ADD edit_date datetime NOT NULL default '0000-00-00 00:00:00'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005081000.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="insert into {$PHORUM['settings_table']} set name='installed', type='V', data='1'"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005100701.php |
---|
New file |
0,0 → 1,5 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="ALTER TABLE {$PHORUM['message_table']} ADD INDEX next_prev_thread ( forum_id , status , thread ) "; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2004031700.php |
---|
New file |
0,0 → 1,14 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
// altering the files tables |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add `date_added` int(10) unsigned NOT NULL default '0'"; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add `date_last_active` int(10) unsigned NOT NULL default '0'"; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add `hide_activity` tinyint(1) NOT NULL default '0'"; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add KEY `activity` (`date_last_active`,`hide_activity`)"; |
$upgrade_queries[]="alter table {$PHORUM['user_table']} add KEY `date_added` (`date_added`)"; |
$upgrade_queries[]="update {$PHORUM['user_table']} set date_last_active=UNIX_TIMESTAMP(NOW()), date_added=UNIX_TIMESTAMP(NOW())"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysql/2005071200.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]="alter table {$PHORUM['message_table']} CHANGE ip ip VARCHAR( 255 ) NOT NULL"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysqli/2005120400.php |
---|
New file |
0,0 → 1,6 |
<?php |
if(!defined("PHORUM_ADMIN")) return; |
$upgrade_queries[]= "alter table {$PHORUM["user_table"]} add moderation_email tinyint(2) unsigned not null default 1"; |
?> |
/trunk/client/phorum/bibliotheque/phorum/include/db/upgrade/mysqli/2005102700.php |
---|