Author: Normal users can not upload pictures anymore to photo album ( only admins and mods now.
i tried to go to ACP=>PHotoAlbum=>CLowN SP Config
But when i click on CLowN SP Config i get following Critical Error
phpBB : Critical Error
Could not query SP config information
DEBUG MODE
SQL Error : 1146 Table 'mbclubnew.ALBUM_SP_CONFIG_TABLE' doesn't exist
SELECT * FROM ALBUM_SP_CONFIG_TABLE
Line : 42
File : admin_album_clown_SP.php
here under you can see the php file :
- Code: Select all
<?php /*************************************************************************** * admin_album_clown_SP_config.php * ------------------- * begin : Thursday, August 28, 2003 * copyright : (C) 2003 Volodymyr (CLowN) Skoryk * email : <a>clown@pimprig.com</a> * ***************************************************************************/ /*************************************************************************** * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * ***************************************************************************/ define('IN_PHPBB', true); if( !empty($setmodules) ) { $filename = basename(__FILE__); $module['Photo_Album']['CLowN_SP_Config'] = $filename; return; } // // Let's set the root dir for phpBB // $phpbb_root_path = '../'; require($phpbb_root_path . 'extension.inc'); require('./pagestart.' . $phpEx); require($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_album.' . $phpEx); require($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_album.' . $phpEx); require($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_clown_album.' . $phpEx); //update values for config $sql = "SELECT * FROM " . ALBUM_SP_CONFIG_TABLE; if(!$result = $db->sql_query($sql)) { message_die(CRITICAL_ERROR, "Could not query SP config information", "", __LINE__, __FILE__, $sql); } else { while( $row = $db->sql_fetchrow($result) ) { $config_name = $row['config_name']; $config_value = $row['config_value']; $default_config[$config_name] = $config_value; $new[$config_name] = ( isset($HTTP_POST_VARS[$config_name]) ) ? $HTTP_POST_VARS[$config_name] : $default_config[$config_name]; if( isset($HTTP_POST_VARS['submit']) ) { $sql = "UPDATE " . ALBUM_SP_CONFIG_TABLE . " SET config_value = '" . str_replace("'", "''", $new[$config_name]) . "' WHERE config_name = '$config_name'"; if( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, "Failed to update Album configuration for $config_name", "", __LINE__, __FILE__, $sql); } } } if( isset($HTTP_POST_VARS['submit']) ) { $message = $lang['Album_config_updated'] . "<br><br>" . sprintf($lang['Click_return_album_config'], "<a>", "</a>") . "<br><br>" . sprintf($lang['Click_return_admin_index'], "<a>", "</a>"); message_die(GENERAL_MESSAGE, $message); } } $template->set_filenames(array( "body" => "admin/album_clown_sp_body.tpl") ); $template->assign_vars(array( //top header info 'L_ALBUM_CONFIG' => $lang['Album_config'], 'L_ALBUM_CONFIG_EXPLAIN' => $lang['Album_config_explain'], 'S_ALBUM_CONFIG_ACTION' => append_sid('admin_album_clown_SP.'.$phpEx),//to submit form //cat names 'L_ALBUM_SP_GENERAL' => $lang['Album_sp_general'], 'L_ALBUM_SP_WATERMARK' => $lang['Album_sp_watermark'], 'L_ALBUM_SP_HOTORNOT' => $lang['Album_sp_hotornot'], //config blocks //-------------------- //General Config Section //-------------------- //rate type 'L_RATE_TYPE' => $lang['Rate_type'], 'L_RATE_TYPE_0' => $lang['Rate_type_0'], 'RATE_TYPE_0' => ($new['rate_type'] == 0) ? 'selected="selected"' : '', 'L_RATE_TYPE_1' => $lang['Rate_type_1'], 'RATE_TYPE_1' => ($new['rate_type'] == 1) ? 'selected="selected"' : '', 'L_RATE_TYPE_2' => $lang['Rate_type_2'], 'RATE_TYPE_2' => ($new['rate_type'] == 2) ? 'selected="selected"' : '', //display latest 'L_DISPLAY_LATEST' => $lang['Display_latest'], 'DISPLAY_LATEST_ENABLED' => ($new['disp_late'] == 1) ? 'checked="checked"' : '', 'DISPLAY_LATEST_DISABLED' => ($new['disp_late'] == 0) ? 'checked="checked"' : '', //display highest 'L_DISPLAY_HIGHEST' => $lang['Display_highest'], 'DISPLAY_HIGHEST_ENABLED' => ($new['disp_high'] == 1) ? 'checked="checked"' : '', 'DISPLAY_HIGHEST_DISABLED' => ($new['disp_high'] == 0) ? 'checked="checked"' : '', //display random 'L_DISPLAY_RANDOM' => $lang['Display_random'], 'DISPLAY_RANDOM_ENABLED' => ($new['disp_rand'] == 1) ? 'checked="checked"' : '', 'DISPLAY_RANDOM_DISABLED' => ($new['disp_rand'] == 0) ? 'checked="checked"' : '', //how many pics 'L_PIC_ROW' => $lang['Pic_row'], 'L_PIC_COL' => $lang['Pic_col'], 'PIC_ROW' => $new['img_rows'], 'PIC_COL' => $new['img_cols'], //mid thumbnail 'L_MIDTHUMB_USE' => $lang['Midthumb_use'], 'MIDTHUMB_ENABLED' => ($new['midthumb_use'] == 1) ? 'checked="checked"' : '', 'MIDTHUMB_DISABLED' => ($new['midthumb_use'] == 0) ? 'checked="checked"' : '', //mid thumbnail cache 'L_MIDTHUMB_CACHE' => $lang['Midthumb_cache'], 'MIDTHUMB_CACHE_ENABLED' => ($new['midthumb_cache'] == 1) ? 'checked="checked"' : '', 'MIDTHUMB_CACHE_DISABLED' => ($new['midthumb_cache'] == 0) ? 'checked="checked"' : '', //wut size fo midthumbnail 'L_MIDTHUMB_HEIGHT' => $lang['Midthumb_high'], 'MIDTHUMB_HEIGHT' => $new['midthumb_height'], 'L_MIDTHUMB_WIDTH' => $lang['Midthumb_width'], 'MIDTHUMB_WIDTH' => $new['midthumb_width'], //-------------------- //WaterMark Section //-------------------- //watermark 'L_WATERMARK' => $lang['Watermark'], 'WATERMARK_ENABLED' => ($new['use_watermark'] == 1) ? 'checked="checked"' : '', 'WATERMARK_DISABLED' => ($new['use_watermark'] == 0) ? 'checked="checked"' : '', //fo wut users 'L_WATERMARK_USERS' => $lang['Watermark_users'], 'WATERMARK_USERS_ENABLED' => ($new['wut_users'] == 1) ? 'checked="checked"' : '', 'WATERMARK_USERS_DISABLED' => ($new['wut_users'] == 0) ? 'checked="checked"' : '', //watermark placement 'L_WATERMARK_PLACENT' => $lang['Watermark_placent'], 'WATERMAR_PLACEMENT_0' => ($new['disp_watermark_at'] == 0) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_1' => ($new['disp_watermark_at'] == 1) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_2' => ($new['disp_watermark_at'] == 2) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_3' => ($new['disp_watermark_at'] == 3) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_4' => ($new['disp_watermark_at'] == 4) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_5' => ($new['disp_watermark_at'] == 5) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_6' => ($new['disp_watermark_at'] == 6) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_7' => ($new['disp_watermark_at'] == 7) ? 'checked="checked"' : '', 'WATERMAR_PLACEMENT_8' => ($new['disp_watermark_at'] == <s8><img><s8> ? 'checked="checked"' : '', //-------------------- //Hot or Not Config Section //-------------------- //already rated? 'L_HON_ALREDY_RATED' => $lang['Hon_already_rated'], 'HON_ALREADY_RATED_ENABLED' => ($new['hon_rate_times'] == 1) ? 'checked="checked"' : '', 'HON_ALREADY_RATED_DISABLED' => ($new['hon_rate_times'] == 0) ? 'checked="checked"' : '', //use sep table for hon rating? 'L_HON_SEP_RATING' => $lang['Hon_sep_rating'], 'HON_SEP_RATING_ENABLED' => ($new['hon_rate_sep'] == 1) ? 'checked="checked"' : '', 'HON_SEP_RATING_DISABLED' => ($new['hon_rate_sep'] == 0) ? 'checked="checked"' : '', //take pics from 'L_HON_WHERE' => $lang['Hon_where'], 'HON_WHERE' => $new['hon_rate_where'], //if user anon 'L_HON_USERS' => $lang['Hon_users'], 'HON_USERS_ENABLED' => ($new['hon_rate_users'] == 1) ? 'checked="checked"' : '', 'HON_USERS_DISABLED' => ($new['hon_rate_users'] == 0) ? 'checked="checked"' : '', 'L_DISABLED' => $lang['Disabled'], 'L_ENABLED' => $lang['Enabled'], 'L_YES' => $lang['yes'], 'L_NO' => $lang['No'], 'L_SUBMIT' => $lang['Submit'], 'L_RESET' => $lang['Reset']) ); $template->pparse("body"); include('./page_footer_admin.'.$phpEx); ?>
