Menu
▾
▴
[mxbb-commits] mx_smartor Smartor_album.pak, 1.7, 1.8 album.php, 1.13, 1.14 album_lists.php, 1.16, 1.17 db_install.php, 1.14, 1.15 db_uninstall.php, 1.9, 1.10 db_upgrade.php, 1.14, 1.15 mx_install_readme.htm, 1.7, 1.8
Update of /cvsroot/mxbb/mx_smartor In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9232 Modified Files: Smartor_album.pak album.php album_lists.php db_install.php db_uninstall.php db_upgrade.php mx_install_readme.htm Log Message: Index: db_uninstall.php =================================================================== RCS file: /cvsroot/mxbb/mx_smartor/db_uninstall.php,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** db_uninstall.php 2 May 2006 23:29:32 -0000 1.9 --- db_uninstall.php 7 Jun 2007 20:13:00 -0000 1.10 *************** *** 4,50 **** * @package mxBB Portal Module - mx_smartor * @version $Id$ ! * @copyright (c) 2002-2006 [Smartor, Volodymyr (CLowN) Skoryk, IdleVoid, Jon Ohlsson] mxBB Project Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * */ ! define( 'IN_PORTAL', true ); ! if ( !defined( 'IN_ADMIN' ) ) { ! $mx_root_path = './../../'; ! $phpEx = substr(strrchr(__FILE__, '.'), 1); ! include( $mx_root_path . 'common.' . $phpEx ); ! // Start session management ! $$mx_user->init($user_ip, PAGE_INDEX); ! ! if ( !$userdata['session_logged_in'] ) ! { ! die( "Hacking attempt(1)" ); ! } ! if ( $userdata['user_level'] != ADMIN ) ! { ! die( "Hacking attempt(2)" ); } ! // End session management } ! $sql = array( "DROP TABLE " . $mx_table_prefix . "smartor_album ", ! "DROP TABLE " . $mx_table_prefix . "smartor_album_rate ", ! "DROP TABLE " . $mx_table_prefix . "smartor_album_comment ", ! "DROP TABLE " . $mx_table_prefix . "smartor_album_cat ", ! "DROP TABLE " . $mx_table_prefix . "smartor_album_config ", ! "DROP TABLE " . $mx_table_prefix . "smartor_album_sp_config " ! ); echo "<br /><br />"; ! echo "<table width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">"; ! echo "<tr><th class=\"thHead\" align=\"center\">Module Installation/Upgrading/Uninstalling Information - module specific db tables</th></tr>"; ! echo "<tr><td class=\"row1\" align=\"left\"><span class=\"gen\">" . mx_do_install_upgrade( $sql ) . "</span></td></tr>"; echo "</table><br />"; --- 4,74 ---- * @package mxBB Portal Module - mx_smartor * @version $Id$ ! * @copyright (c) 2003 [sma...@ho..., Smartor] mxBB Project Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * */ ! define('IN_PORTAL', true); ! if ( !defined('IN_ADMIN') ) { ! $mx_root_path = '../../'; ! $phpEx = substr(strrchr(__FILE__, '.'), 1); ! include($mx_root_path . 'common.'.$phpEx); ! ! // ! // Start session management ! // ! $mx_user->init($user_ip, PAGE_INDEX); ! ! if( !$userdata['session_logged_in'] ) ! { ! die("Hacking attempt(3)"); ! } ! if( $userdata['user_level'] != ADMIN ) ! { ! die("Hacking attempt(4)"); } ! // ! // End session management ! // ! } + $sql = array( + "DROP TABLE ".$mx_table_prefix."smartor_album ", ! "DROP TABLE ".$mx_table_prefix."smartor_album_rate ", ! "DROP TABLE ".$mx_table_prefix."smartor_album_comment ", ! "DROP TABLE ".$mx_table_prefix."smartor_album_cat ", ! "DROP TABLE ".$mx_table_prefix."smartor_album_config ", ! "DROP TABLE ".$mx_table_prefix."smartor_album_sp_config " ! ); ! $n = 0; ! $message = "<b>This list is a result of the SQL queries needed for smartor module</b><br /><br />"; + while($sql[$n]) + { + $message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br />' : ''; + if(!$result = $db->sql_query($sql[$n])) + { + $message .= '<b><font color=#FF0000>[Error, Already deleted or updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />'; + } + else + { + $message .='<b><font color=#0000fF>[Deleted/Updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />'; + } + $n++; + } + + $message .= '<br /> If you get some Error, Already Deleted or Updated, relax, this is normal ;)'; echo "<br /><br />"; ! echo "<table cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">"; ! echo "<tr><th class=\"thHead\" align=\"center\">Module Uninstallation Information</th></tr>"; ! echo "<tr><td class=\"row1\" align=\"center\"><span class=\"gen\">" . $message . "</span></td></tr>"; echo "</table><br />"; Index: album.php =================================================================== RCS file: /cvsroot/mxbb/mx_smartor/album.php,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** album.php 30 Jun 2006 21:10:55 -0000 1.13 --- album.php 7 Jun 2007 20:13:00 -0000 1.14 *************** *** 4,99 **** * @package mxBB Portal Module - mx_smartor * @version $Id$ ! * @copyright (c) 2002-2006 [Smartor, Volodymyr (CLowN) Skoryk, IdleVoid, Jon Ohlsson] mxBB Project Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * */ ! // +--------------------------------------------------------+ ! // | Powered by Photo Album 2.x.x (c) 2002-2003 Smartor | ! // | with Volodymyr (CLowN) Skoryk's Service Pack 1 © 2003 | [...1649 lines suppressed...] ! // if (empty($album_view_mode)) ! // { ! album_display_index($album_user_id, ALBUM_ROOT_CATEGORY, true, true, true); ! // } ! // Generate the page ! $template->pparse('body'); ! if ( !is_object($mx_block)) ! { ! include($mx_root_path . 'includes/page_tail.'.$phpEx); ! } ! // +--------------------------------------------------------+ ! // | Powered by Photo Album 2.x.x (c) 2002-2003 Smartor | ! // | with Volodymyr (CLowN) Skoryk's Service Pack 1 © 2003 | ! // +--------------------------------------------------------+ } ?> \ No newline at end of file Index: db_upgrade.php =================================================================== RCS file: /cvsroot/mxbb/mx_smartor/db_upgrade.php,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** db_upgrade.php 30 Jan 2007 16:26:10 -0000 1.14 --- db_upgrade.php 7 Jun 2007 20:13:01 -0000 1.15 *************** *** 4,8 **** * @package mxBB Portal Module - mx_smartor * @version $Id$ ! * @copyright (c) 2002-2006 [Smartor, Volodymyr (CLowN) Skoryk, IdleVoid, Jon Ohlsson] mxBB Project Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * --- 4,8 ---- * @package mxBB Portal Module - mx_smartor * @version $Id$ ! * @copyright (c) 2002-2006 [Markus, Jon Ohlsson] mxBB Project Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * *************** *** 30,101 **** } ! $mx_module_version = '2.0.0-beta'; ! $mx_module_copy = 'Original phpBB <i>Album</i> MOD by <a href="http://smartor.is-root.com" target="_blank">Smartor & Clown</a> :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>'; $sql = array(); // Precheck ! if ( $result = $db->sql_query( "SELECT config_name from " . $mx_table_prefix . "kb_config" ) ) { // Upgrade checks ! $upgrade_101 = 0; ! $upgrade_102 = 0; ! $upgrade_103 = 0; ! // validate before 1.03 ! if ( !$result = $db->sql_query( "SELECT comment_cat_id from " . $mx_table_prefix . "smartor_album_comment" ) ) { ! $upgrade_103 = 1; } ! // validate before 1.04 ! if ( !$result = $db->sql_query( "SELECT cat_parent from " . $mx_table_prefix . "smartor_album_cat" ) ) { ! $upgrade_104 = 1; } $message = "<b>Upgrading!</b><br/><br/>"; ! if ( $upgrade_103 == 1 ) { ! $message .= "<b>Upgrading to v. 1.03...</b><br/><br/>"; ! // $sql[] ="INSERT INTO ".$mx_table_prefix."kb_config VALUES ('votes_check_userid', '1')"; ! // $sql[] ="INSERT INTO ".$mx_table_prefix."kb_config VALUES ('votes_check_ip', '1')"; ! // $sql[] ="INSERT INTO ".$mx_table_prefix."kb_config VALUES ('art_pagination', '5')"; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "smartor_album_comment ADD comment_cat_id int(11) NOT NULL AFTER comment_pic_id"; ! $sql[] = "UPDATE " . $mx_table_prefix . "smartor_album_config" . " ! SET config_value = '.0.53' ! WHERE config_name = 'album_version'"; ! } ! if ( $upgrade_104 == 1 ) { ! $message .= "<b>Upgrading to v. 1.04...subcats</b><br/><br/>"; ! ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "smartor_album_cat ADD cat_parent MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER cat_approval"; ! $sql[] = "ALTER TABLE " . $mx_table_prefix . "smartor_album_cat ADD cat_user_id MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER cat_parent"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_thumb', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_total_pics', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_last_pic', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_pics', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('line_break_subcats', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_subcats', '1')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_total_comments', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_comments', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_index_last_comment', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_recent_in_subcats', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_recent_instead_of_nopics', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_personal_gallery_link', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('personal_allow_gallery_mod', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('personal_allow_sub_categories', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('personal_sub_category_limit', '-1')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('personal_show_subcats_in_index', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('personal_show_recent_in_subcats', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('personal_show_recent_instead_of_nopics', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('album_category_sorting', 'cat_order')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('album_category_sorting_direction', 'ASC')"; ! // --- version 1.2.0 ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('album_debug_mode', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('show_all_in_personal_gallery', '0')"; ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('new_pic_check_interval', '1M')"; ! // --- version 1.3.0 ! $sql[] = "INSERT INTO " . $mx_table_prefix . "smartor_album_config ( config_name , config_value ) VALUES ('index_enable_supercells', '1')"; } else --- 30,160 ---- } ! $mx_module_version = '2.0.0'; ! $mx_module_copy = 'mxBB <i> - smartor album FAP </i> module by Mighty Gorgon & <a href="http://www.mxbb.net" target="_blank">The mxBB Development Team</a>'; $sql = array(); + + // // Precheck ! // ! if ( $result = $db->sql_query( "SELECT config_name from " . $mx_table_prefix . "smartor_album_config" ) ) { + // // Upgrade checks ! // ! $upgrade_2000 = 0; ! $upgrade_2001 = 0; ! ! // ! // validate before 2.00 ! // ! $result = $db->sql_query( "SELECT config_value from " . $mx_table_prefix . "smartor_album_config WHERE config_name = 'enable_integration'" ); ! if ( $db->sql_numrows( $result ) == 0 ) { ! $upgrade_2000 = 1; } ! ! $result = $db->sql_query( "SELECT config_value from " . $mx_table_prefix . "smartor_album_config WHERE config_name = 'show_otf_link'" ); ! if ( $db->sql_numrows( $result ) == 0 ) { ! $upgrade_2001 = 1; } $message = "<b>Upgrading!</b><br/><br/>"; ! if ( $upgrade_2000 == 1 ) { ! $message .= "<b>Upgrading to v. 2.00 Beta 1...</b><br/><br/>"; ! $sql[] = "UPDATE ". $mx_table_prefix ."smartor_album_config ! SET config_value = '0.54' ! WHERE config_name = 'album_version'"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_cat ADD cat_wm TEXT AFTER cat_desc"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_cat ADD cat_parent MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER cat_approval"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_cat ADD cat_user_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER cat_parent"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('fap_version', '1.4.0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_thumb', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_total_pics', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_total_comments', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_comments', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_comment', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_pic', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_pics', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_recent_in_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_recent_instead_of_nopics', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('line_break_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_gallery_mod', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_sub_categories', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_sub_category_limit', '-1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_subcats_in_index', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_recent_in_subcats', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_recent_instead_of_nopics', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_personal_gallery_link', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_category_sorting', 'cat_order')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_category_sorting_direction', 'ASC')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_debug_mode', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_all_in_personal_gallery', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('new_pic_check_interval', '1M')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('index_enable_supercells', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('email_notification', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_download', '2')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_slideshow', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_pic_size_on_thumb', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_files_to_upload', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_pregenerated_fields', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('dynamic_fields', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('pregenerate_fields', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('propercase_pic_title', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_pic_lv', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_pics_approval', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_img_no_gd', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('dynamic_pic_resampling', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_file_size_resampling', '1024000')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('switch_nuffload', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('path_to_bin', './modules/mx_smartor/cgi-bin/')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('perl_uploader', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_progress_bar', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('close_on_finish', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_pause', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('simple_format', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('multiple_uploads', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_uploads', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('zip_uploads', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_pic', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_width', '600')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_height', '600')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_quality', '70')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_pics_nav', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_inline_copyright', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_nuffimage', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_sepia_bw', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_avatar_gallery', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_gif_mid_thumb', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('slideshow_script', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_exif', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_bbcode', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('quick_thumbs', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('set_memory', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('lb_preview', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('use_old_pics_gen', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_last_comments', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_mooshow', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_integration', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('override_default_pages', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('index', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('disp_mostv', '1')"; ! } ! if ( $upgrade_2001 == 1 ) { ! $message .= "<b>Upgrading to v. 2.00 Beta 2...</b><br/><br/>"; ! $sql[] = "UPDATE ". $mx_table_prefix ."smartor_album_config ! SET config_value = '1.4.1' ! WHERE config_name = 'fap_version'"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('invert_nav_arrows', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_otf_link', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_all_pics_link', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_personal_galleries_link', '1')"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_comment ADD comment_cat_id int(11) NOT NULL default '0' AFTER comment_pic_id"; } else *************** *** 113,117 **** --- 172,178 ---- else { + // // If not installed + // $message = "<b>Module is not installed...and thus cannot be upgraded ;)</b><br/><br/>"; } *************** *** 123,130 **** echo "</table><br />"; - if ( $upgrade_104 == 1 || 1 == 1 ) - { - include( 'hierarchy_db_migrate.' . $phpEx ); - } - ?> --- 184,186 ---- Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_smartor/db_install.php,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** db_install.php 30 Jan 2007 16:26:10 -0000 1.14 --- db_install.php 7 Jun 2007 20:13:00 -0000 1.15 *************** *** 4,13 **** * @package mxBB Portal Module - mx_smartor * @version $Id$ ! * @copyright (c) 2002-2006 [Smartor, Volodymyr (CLowN) Skoryk, IdleVoid, Jon Ohlsson] mxBB Project Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * */ - define( 'IN_PORTAL', true ); if ( !defined( 'IN_ADMIN' ) ) { --- 4,13 ---- * @package mxBB Portal Module - mx_smartor * @version $Id$ ! * @copyright (c) 2003 [ory...@rd..., OryNider] mxBB Development Team * @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2 * */ define( 'IN_PORTAL', true ); + if ( !defined( 'IN_ADMIN' ) ) { *************** *** 15,20 **** --- 15,22 ---- $phpEx = substr(strrchr(__FILE__, '.'), 1); include( $mx_root_path . 'common.' . $phpEx ); + // Start session management $mx_user->init($user_ip, PAGE_INDEX); + // End session management if ( !$userdata['session_logged_in'] ) *************** *** 27,245 **** die( "Hacking attempt(2)" ); } ! // End session management } ! $mx_module_version = '2.0.0-beta'; ! $mx_module_copy = 'Original phpBB <i>Album</i> MOD by <a href="http://smartor.is-root.com" target="_blank">Smartor & Clown</a> :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>'; // If upgrading from old mx album ! if ( $result = $db->sql_query( "SELECT config_name from " . $mx_table_prefix . "album_config" ) ) ! { ! $message = "<b>Upgrading!...to use Clown SP...from old mx album </b><br/><br/>"; ! $sql = array( "RENAME TABLE " . $mx_table_prefix . "album TO " . $mx_table_prefix . "smartor_album, ! " . $mx_table_prefix . "album_rate TO " . $mx_table_prefix . "smartor_album_rate, ! " . $mx_table_prefix . "album_comment TO " . $mx_table_prefix . "smartor_album_comment, ! " . $mx_table_prefix . "album_cat TO " . $mx_table_prefix . "smartor_album_cat, ! " . $mx_table_prefix . "album_config TO " . $mx_table_prefix . "smartor_album_config", ! "CREATE TABLE " . $mx_table_prefix . "smartor_album_sp_config ( ! config_name varchar(255) NOT NULL, ! config_value varchar(255) NOT NULL, ! PRIMARY KEY (config_name))", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_late', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('rate_type', '2')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_high', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_rand', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('img_rows', '2')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('img_cols', '3')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('use_watermark', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('wut_users', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_watermark_at', '3')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_times', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_sep', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_where', '')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_users', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_use', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_height', '500')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_width', '500')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_cache', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('jaime_lettering', '0')", ! "ALTER TABLE " . $mx_table_prefix . "smartor_album_rate ADD rate_hon_point TINYINT(3) DEFAULT '0' NOT NULL ", ! "ALTER TABLE " . $mx_table_prefix . "smartor_album_comment ADD comment_cat_id int(11) NOT NULL AFTER comment_pic_id" ! ); $n = 0; $message .= "<b>OK...</b><br /><br />"; ! while ( $sql[$n] ) { ! $message .= ( $mods[$n-1] != $mods[$n] ) ? '<p><b><font size=3>' . $mods[$n] . '</font></b><br />' : ''; ! if ( !$result = $db->sql_query( $sql[$n] ) ) ! { ! $message .= '<b><font color=#FF0000>[Error or Already added]</font></b> line: ' . ( $n + 1 ) . ' , ' . $sql[$n] . '<br />'; ! } ! else ! { ! $message .= '<b><font color=#0000fF>[Added/Updated]</font></b> line: ' . ( $n + 1 ) . ' , ' . $sql[$n] . '<br />'; ! } ! $n++; } } // If fresh install ! elseif ( !$result = $db->sql_query( "SELECT config_name from " . $mx_table_prefix . "smartor_album_sp_config" ) ) ! { ! $message = "<b>This is a fresh install!</b><br/><br/>"; ! $sql = array( "CREATE TABLE " . $mx_table_prefix . "smartor_album ( ! pic_id int(11) UNSIGNED NOT NULL auto_increment, ! pic_filename varchar(255) NOT NULL, ! pic_thumbnail varchar(255), ! pic_title varchar(255) NOT NULL, ! pic_desc text, ! pic_user_id mediumint(8) NOT NULL, ! pic_username varchar(32), ! pic_user_ip char(8) NOT NULL DEFAULT '0', ! pic_time int(11) UNSIGNED NOT NULL, ! pic_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1', ! pic_view_count int(11) UNSIGNED NOT NULL DEFAULT '0', ! pic_lock tinyint(3) NOT NULL DEFAULT '0', ! pic_approval tinyint(3) NOT NULL DEFAULT '1', ! PRIMARY KEY (pic_id), ! KEY pic_cat_id (pic_cat_id), ! KEY pic_user_id (pic_user_id), ! KEY pic_time (pic_time))", ! "CREATE TABLE " . $mx_table_prefix . "smartor_album_rate ( ! rate_pic_id int(11) UNSIGNED NOT NULL, ! rate_user_id mediumint(8) NOT NULL, ! rate_user_ip char(8) NOT NULL, ! rate_point tinyint(3) UNSIGNED NOT NULL, ! KEY rate_pic_id (rate_pic_id), ! KEY rate_user_id (rate_user_id), ! KEY rate_user_ip (rate_user_ip), ! KEY rate_point (rate_point))", ! "CREATE TABLE " . $mx_table_prefix . "smartor_album_comment ( ! comment_id int(11) UNSIGNED NOT NULL auto_increment, ! comment_pic_id int(11) UNSIGNED NOT NULL, ! comment_cat_id int(11) NOT NULL, ! comment_user_id mediumint(8) NOT NULL, ! comment_username varchar(32), ! comment_user_ip char(8) NOT NULL, ! comment_time int(11) UNSIGNED NOT NULL, ! comment_text TEXT, ! comment_edit_time int(11) UNSIGNED, ! comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0', ! comment_edit_user_id mediumint(8), ! PRIMARY KEY(comment_id), ! KEY comment_pic_id (comment_pic_id), ! KEY comment_user_id (comment_user_id), ! KEY comment_user_ip (comment_user_ip), ! KEY comment_time (comment_time))", ! "CREATE TABLE " . $mx_table_prefix . "smartor_album_cat ( ! cat_id mediumint(8) UNSIGNED NOT NULL auto_increment, ! cat_title varchar(255) NOT NULL, ! cat_desc text, ! cat_order mediumint(8) NOT NULL, ! cat_view_level tinyint(3) NOT NULL DEFAULT '-1', ! cat_upload_level tinyint(3) NOT NULL DEFAULT '0', ! cat_rate_level tinyint(3) NOT NULL DEFAULT '0', ! cat_comment_level tinyint(3) NOT NULL DEFAULT '0', ! cat_edit_level tinyint(3) NOT NULL DEFAULT '0', ! cat_delete_level tinyint(3) NOT NULL DEFAULT '2', ! cat_view_groups varchar(255), ! cat_upload_groups varchar(255), ! cat_rate_groups varchar(255), ! cat_comment_groups varchar(255), ! cat_edit_groups varchar(255), ! cat_delete_groups varchar(255), ! cat_moderator_groups varchar(255), ! cat_approval tinyint(3) NOT NULL DEFAULT '0', ! PRIMARY KEY (cat_id), ! KEY cat_order (cat_order))", - "CREATE TABLE " . $mx_table_prefix . "smartor_album_config ( - config_name varchar(255) NOT NULL, - config_value varchar(255) NOT NULL, - PRIMARY KEY (config_name))", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('max_pics', '1024')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('user_pics_limit', '50')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('mod_pics_limit', '250')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('max_file_size', '128000')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('max_width', '800')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('max_height', '600')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('rows_per_page', '3')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('cols_per_page', '4')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('fullpic_popup', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('thumbnail_quality', '50')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('thumbnail_size', '150')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('thumbnail_cache', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('sort_method', 'pic_time')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('sort_order', 'DESC')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('jpg_allowed', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('png_allowed', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('gif_allowed', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('desc_length', '512')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('hotlink_prevent', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('personal_gallery', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('personal_gallery_private', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('personal_gallery_limit', '10')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('personal_gallery_view', '-1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('rate', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('rate_scale', '10')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('comment', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('gd_version', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_config VALUES ('album_version', '.0.51')", ! "CREATE TABLE " . $mx_table_prefix . "smartor_album_sp_config ( ! config_name varchar(255) NOT NULL, ! config_value varchar(255) NOT NULL, ! PRIMARY KEY (config_name))", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_late', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('rate_type', '2')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_high', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_rand', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('img_rows', '2')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('img_cols', '3')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('use_watermark', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('wut_users', '0')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('disp_watermark_at', '3')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_times', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_sep', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_where', '')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('hon_rate_users', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_use', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_height', '500')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_width', '500')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('midthumb_cache', '1')", ! "INSERT INTO " . $mx_table_prefix . "smartor_album_sp_config VALUES ('jaime_lettering', '0')", ! "ALTER TABLE " . $mx_table_prefix . "smartor_album_rate ADD rate_hon_point TINYINT(3) DEFAULT '0' NOT NULL " ! ); ! $sql[] = "UPDATE " . $mx_table_prefix . "module" . " SET module_version = '" . $mx_module_version . "', module_copy = '" . $mx_module_copy . "' WHERE module_id = '" . $mx_module_id . "'"; ! $message .= mx_do_install_upgrade( $sql ); } else { // If already installed ! $message = "<b>Module is already installed...consider upgrading ;)</b><br/><br/>"; } echo "<br /><br />"; echo "<table width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">"; ! echo "<tr><th class=\"thHead\" align=\"center\">Module Installation/Upgrading/Uninstalling Information - module specific db tables</th></tr>"; echo "<tr><td class=\"row1\" align=\"left\"><span class=\"gen\">" . $message . "</span></td></tr>"; echo "</table><br />"; --- 29,419 ---- die( "Hacking attempt(2)" ); } ! } ! $mx_module_version = '2.0.0'; ! $mx_module_copy = 'mxBB <i> - smartor album FAP </i> module by Mighty Gorgon & <a href="http://www.mxbb.net" target="_blank">The mxBB Development Team</a>'; ! // If upgrading from old mx album ! if( $result = $db->sql_query("SELECT config_name from ".$mx_table_prefix."album_config")) ! { ! $message = "<b>Upgrading!...to use Clown SP...from old mx album </b><br/><br/>"; ! $sql = array(); ! $sql[] = "RENAME TABLE ".$mx_table_prefix."album TO ".$mx_table_prefix."smartor_album"; ! $sql[] = "RENAME TABLE ".$mx_table_prefix."album_rate TO ".$mx_table_prefix."smartor_album_rate"; ! $sql[] = "RENAME TABLE ".$mx_table_prefix."album_comment TO ".$mx_table_prefix."smartor_album_comment"; ! $sql[] = "RENAME TABLE ".$mx_table_prefix."album_cat TO ".$mx_table_prefix."smartor_album_cat"; ! $sql[] = "RENAME TABLE ".$mx_table_prefix."album_config TO ".$mx_table_prefix."smartor_album_config"; ! $sql[] = "CREATE TABLE ".$mx_table_prefix."smartor_album_sp_config ( ! config_name varchar(255) NOT NULL, ! config_value varchar(255) NOT NULL, ! PRIMARY KEY (config_name) ! ) TYPE=MyISAM"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('disp_late', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('rate_type', '2')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('disp_high', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('disp_mostv', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('disp_rand', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('img_rows', '2')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('img_cols', '3')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('use_watermark', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('wut_users', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('disp_watermark_at', '3')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('hon_rate_times', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('hon_rate_sep', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('hon_rate_where', '')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('hon_rate_users', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('midthumb_use', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('midthumb_height', '500')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('midthumb_width', '500')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('midthumb_cache', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_sp_config VALUES ('jaime_lettering', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('fap_version', '1.4.1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_thumb', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_total_pics', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_total_comments', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_comments', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_comment', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_pic', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_pics', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_recent_in_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_recent_instead_of_nopics', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('line_break_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_gallery_mod', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_sub_categories', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_sub_category_limit', '-1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_subcats_in_index', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_recent_in_subcats', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_recent_instead_of_nopics', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_personal_gallery_link', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_category_sorting', 'cat_order')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_category_sorting_direction', 'ASC')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_debug_mode', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_all_in_personal_gallery', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('new_pic_check_interval', '1M')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('index_enable_supercells', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('email_notification', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_download', '2')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_slideshow', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_pic_size_on_thumb', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_files_to_upload', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_pregenerated_fields', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('dynamic_fields', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('pregenerate_fields', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('propercase_pic_title', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_pic_lv', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_pics_approval', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_img_no_gd', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('dynamic_pic_resampling', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_file_size_resampling', '1024000')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('switch_nuffload', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('path_to_bin', './modules/mx_smartor/cgi-bin/')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('perl_uploader', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_progress_bar', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('close_on_finish', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_pause', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('simple_format', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('multiple_uploads', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_uploads', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('zip_uploads', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_pic', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_width', '600')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_height', '600')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_quality', '70')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_pics_nav', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_inline_copyright', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_nuffimage', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_sepia_bw', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_avatar_gallery', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_gif_mid_thumb', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('slideshow_script', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_exif', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_bbcode', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('quick_thumbs', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('set_memory', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('lb_preview', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('use_old_pics_gen', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_last_comments', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_mooshow', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_integration', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('override_default_pages', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('index', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('invert_nav_arrows', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_otf_link', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_all_pics_link', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_personal_galleries_link', '1')"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_rate ADD rate_hon_point TINYINT(3) DEFAULT '0' NOT NULL"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_cat ADD cat_wm TEXT AFTER cat_desc"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_cat ADD cat_parent MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER cat_approval"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_cat ADD cat_user_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER cat_parent"; ! $sql[] = "ALTER TABLE ".$mx_table_prefix."smartor_album_comment ADD comment_cat_id int(11) NOT NULL default '0' AFTER comment_pic_id"; $n = 0; + $message .= "<b>OK...</b><br /><br />"; ! while($sql[$n]) ! { ! $message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br />' : ''; ! if(!$result = $db->sql_query($sql[$n])) { ! $message .= '<b><font color=#FF0000>[Error or Already added]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />'; ! } ! else ! { ! $message .='<b><font color=#0000fF>[Added/Updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />'; } + $n++; } + } + + // // If fresh install ! // ! elseif( !$result = $db->sql_query("SELECT config_name from ".$mx_table_prefix."smartor_album_sp_config")) ! { ! $message = "<b>This is a fresh install!</b><br/><br/>"; ! $sql = array(); ! $sql[] = "CREATE TABLE ".$mx_table_prefix."smartor_album ( ! pic_id int(11) UNSIGNED NOT NULL auto_increment, ! pic_filename varchar(255) NOT NULL, ! pic_thumbnail varchar(255), ! pic_title varchar(255) NOT NULL, ! pic_desc text, ! pic_user_id mediumint(8) NOT NULL, ! pic_username varchar(32), ! pic_user_ip char(8) NOT NULL DEFAULT '0', ! pic_time int(11) UNSIGNED NOT NULL, ! pic_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1', ! pic_view_count int(11) UNSIGNED NOT NULL DEFAULT '0', ! pic_lock tinyint(3) NOT NULL DEFAULT '0', ! pic_approval tinyint(3) NOT NULL DEFAULT '1', ! PRIMARY KEY (pic_id), ! KEY pic_cat_id (pic_cat_id), ! KEY pic_user_id (pic_user_id), ! KEY pic_time (pic_time) ! ) TYPE=MyISAM"; ! $sql[] = "CREATE TABLE ".$mx_table_prefix."smartor_album_rate ( ! rate_pic_id int(11) UNSIGNED NOT NULL, ! rate_user_id mediumint(8) NOT NULL, ! rate_user_ip char(8) NOT NULL, ! rate_point tinyint(3) UNSIGNED NOT NULL, ! KEY rate_pic_id (rate_pic_id), ! KEY rate_user_id (rate_user_id), ! KEY rate_user_ip (rate_user_ip), ! KEY rate_point (rate_point) ! ) TYPE=MyISAM"; ! $sql[] = "CREATE TABLE ".$mx_table_prefix."smartor_album_comment ( ! comment_id int(11) UNSIGNED NOT NULL auto_increment, ! comment_pic_id int(11) UNSIGNED NOT NULL, ! comment_cat_id int(11) NOT NULL default '0', ! comment_user_id mediumint(8) NOT NULL, ! comment_username varchar(32), ! comment_user_ip char(8) NOT NULL, ! comment_time int(11) UNSIGNED NOT NULL, ! comment_text TEXT, ! comment_edit_time int(11) UNSIGNED, ! comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0', ! comment_edit_user_id mediumint(8), ! PRIMARY KEY(comment_id), ! KEY comment_pic_id (comment_pic_id), ! KEY comment_user_id (comment_user_id), ! KEY comment_user_ip (comment_user_ip), ! KEY comment_time (comment_time) ! ) TYPE=MyISAM"; ! $sql[] = "CREATE TABLE ".$mx_table_prefix."smartor_album_cat ( ! cat_id mediumint(8) UNSIGNED NOT NULL auto_increment, ! cat_title varchar(255) NOT NULL, ! cat_desc text, ! cat_wm text, ! cat_order mediumint(8) NOT NULL, ! cat_view_level tinyint(3) NOT NULL DEFAULT '-1', ! cat_upload_level tinyint(3) NOT NULL DEFAULT '0', ! cat_rate_level tinyint(3) NOT NULL DEFAULT '0', ! cat_comment_level tinyint(3) NOT NULL DEFAULT '0', ! cat_edit_level tinyint(3) NOT NULL DEFAULT '0', ! cat_delete_level tinyint(3) NOT NULL DEFAULT '2', ! cat_view_groups varchar(255), ! cat_upload_groups varchar(255), ! cat_rate_groups varchar(255), ! cat_comment_groups varchar(255), ! cat_edit_groups varchar(255), ! cat_delete_groups varchar(255), ! cat_moderator_groups varchar(255), ! cat_approval tinyint(3) NOT NULL DEFAULT '0', ! cat_parent mediumint(8) unsigned default '0', ! cat_user_id mediumint(8) unsigned default '0', ! PRIMARY KEY (cat_id), ! KEY cat_order (cat_order) ! ) TYPE=MyISAM"; ! $sql[] = "CREATE TABLE ".$mx_table_prefix."smartor_album_config ( ! config_name varchar(255) NOT NULL, ! config_value varchar(255) NOT NULL, ! PRIMARY KEY (config_name) ! ) TYPE=MyISAM"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_pics', '1024')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('user_pics_limit', '50')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('mod_pics_limit', '250')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_file_size', '128000')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_width', '1024')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_height', '768')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('rows_per_page', '3')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('cols_per_page', '4')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('fullpic_popup', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('thumbnail_quality', '50')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('thumbnail_size', '150')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('thumbnail_cache', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('sort_method', 'pic_time')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('sort_order', 'DESC')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('jpg_allowed', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('png_allowed', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('gif_allowed', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('desc_length', '512')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('hotlink_prevent', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_gallery', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_gallery_private', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_gallery_limit', '10')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_gallery_view', '-1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('rate', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('rate_scale', '10')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('comment', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('gd_version', '2')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_version', '.0.54')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('fap_version', '1.4.1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_thumb', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_total_pics', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_total_comments', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_comments', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_comment', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_pic', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_pics', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_recent_in_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_recent_instead_of_nopics', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('line_break_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_subcats', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_gallery_mod', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_sub_categories', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_sub_category_limit', '-1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_subcats_in_index', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_recent_in_subcats', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_show_recent_instead_of_nopics', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_personal_gallery_link', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_category_sorting', 'cat_order')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_category_sorting_direction', 'ASC')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('album_debug_mode', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_all_in_personal_gallery', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('new_pic_check_interval', '1M')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('index_enable_supercells', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('email_notification', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_download', '2')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_slideshow', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_pic_size_on_thumb', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_files_to_upload', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_pregenerated_fields', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('dynamic_fields', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('pregenerate_fields', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('propercase_pic_title', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_index_last_pic_lv', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_pics_approval', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_img_no_gd', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('dynamic_pic_resampling', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_file_size_resampling', '1024000')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('switch_nuffload', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('path_to_bin', './modules/mx_smartor/cgi-bin/')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('perl_uploader', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_progress_bar', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('close_on_finish', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_pause', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('simple_format', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('multiple_uploads', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('max_uploads', '5')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('zip_uploads', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_pic', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_width', '600')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_height', '600')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('resize_quality', '70')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_pics_nav', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('show_inline_copyright', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_nuffimage', '1')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('enable_sepia_bw', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_prefix."smartor_album_config VALUES ('personal_allow_avatar_gallery', '0')"; ! $sql[] = "INSERT INTO ".$mx_table_pr... [truncated message content] |