X-Git-Url: http://git.vanrenterghem.biz/www.vanrenterghem.biz.git/blobdiff_plain/4b1ce0d83844cfd7c55e75a60ccb239882cd62e3..83ab5456767602f2a9860a7db7247f002ec96945:/phpBB2_old/admin/xs_edit_data.php diff --git a/phpBB2_old/admin/xs_edit_data.php b/phpBB2_old/admin/xs_edit_data.php deleted file mode 100644 index df1eb1e..0000000 --- a/phpBB2_old/admin/xs_edit_data.php +++ /dev/null @@ -1,357 +0,0 @@ -xs_version) || $template->xs_version !== 5) -{ - message_die(GENERAL_ERROR, 'eXtreme Styles mod is not installed. You forgot to upload includes/template.php'); -} - -define('IN_XS', true); -include_once('xs_include.' . $phpEx); - -$template->assign_block_vars('nav_left',array('ITEM' => '» ' . $lang['xs_edit_styles_data'] . '')); - -$lang['xs_edittpl_back_list'] = str_replace('{URL}', append_sid('xs_edit_data.'.$phpEx), $lang['xs_edittpl_back_list']); - -function xs_empty_name() -{ - global $db; - $sql = "SELECT * FROM " . THEMES_NAME_TABLE . " LIMIT 0, 1"; - if(!$result = $db->sql_query($sql)) - { - $data = array(); - } - $data = $db->sql_fetchrow($result); - if($data === false || !@count($data)) - { - $data = array( - 'themes_id' => 0, - 'tr_color1_name' => '', - 'tr_color2_name' => '', - 'tr_color3_name' => '', - 'tr_class1_name' => '', - 'tr_class2_name' => '', - 'tr_class3_name' => '', - 'th_color1_name' => '', - 'th_color2_name' => '', - 'th_color3_name' => '', - 'th_class1_name' => '', - 'th_class2_name' => '', - 'th_class3_name' => '', - 'td_color1_name' => '', - 'td_color2_name' => '', - 'td_color3_name' => '', - 'td_class1_name' => '', - 'td_class2_name' => '', - 'td_class3_name' => '', - 'fontface1_name' => '', - 'fontface2_name' => '', - 'fontface3_name' => '', - 'fontsize1_name' => '', - 'fontsize2_name' => '', - 'fontsize3_name' => '', - 'fontcolor1_name' => '', - 'fontcolor2_name' => '', - 'fontcolor3_name' => '', - 'span_class1_name' => '', - 'span_class2_name' => '', - 'span_class3_name' => '' - ); - - } - $arr = array(); - foreach($data as $var => $value) - { - if($var !== 'themes_id') - { - $arr[$var] = ''; - } - } - return $arr; -} - -function xs_get_vars($theme) -{ - $arr1 = array(); - $arr2 = array(); - $vars_100 = array('head_stylesheet', 'body_background'); - $vars_50 = array('fontface'); - $vars_30 = array('style_name'); - $vars_25 = array('tr_class', 'th_class', 'td_class', 'span_class'); - $vars_6 = array('body_bgcolor', 'body_text', 'body_link', 'body_vlink', 'body_alink', 'body_hlink', 'tr_color', 'th_color', 'td_color', 'fontcolor'); - $vars_5 = array('img_size_poll', 'img_size_privmsg'); - $vars_4 = array('fontsize', 'theme_public'); - foreach($theme as $var => $value) - { - if(!is_integer($var) && $var !== 'themes_id' && $var !== 'template_name') - { - // editable variable - $len = 0; - $sub = substr($var, 0, strlen($var) - 1); - if(xs_in_array($var, $vars_100) || xs_in_array($sub, $vars_100)) - { - $len = 100; - } - elseif(xs_in_array($var, $vars_50) || xs_in_array($sub, $vars_50)) - { - $len = 50; - } - elseif(xs_in_array($var, $vars_30) || xs_in_array($sub, $vars_30)) - { - $len = 30; - } - elseif(xs_in_array($var, $vars_25) || xs_in_array($sub, $vars_25)) - { - $len = 25; - } - elseif(xs_in_array($var, $vars_6) || xs_in_array($sub, $vars_6)) - { - $len = 6; - } - elseif(xs_in_array($var, $vars_5) || xs_in_array($sub, $vars_5)) - { - $len = 5; - } - elseif(xs_in_array($var, $vrs_4) || xs_in_array($sub, $vars_4)) - { - $len = 4; - } - elseif(strpos($var, 'class')) - { - $len = 25; - } - elseif(strpos($var, 'color')) - { - $len = 6; - } - if($len) - { - $item = array( - 'var' => $var, - 'len' => $len, - 'color' => $len == 6 ? true : false, - 'font' => $len == 25 ? true : false, - ); - if($var === 'style_name' || $var === 'head_stylesheet' || $var === 'body_background') - { - $arr1[$var] = $item; - } - else - { - $arr2[$var] = $item; - } - } - } - } - krsort($arr1); - ksort($arr2); - return array_merge($arr1, $arr2); -} - -// -// submit -// -if(!empty($HTTP_POST_VARS['edit']) && !defined('DEMO_MODE')) -{ - $id = intval($HTTP_POST_VARS['edit']); - $lang['xs_edittpl_back_edit'] = str_replace('{URL}', append_sid('xs_edit_data.'.$phpEx.'?edit='.$id), $lang['xs_edittpl_back_edit']); - $data_item = array(); - $data_item_update = array(); - $data_name = array(); - $data_name_insert_vars = array('themes_id'); - $data_name_insert_values = array($id); - $data_name_update = array(); - foreach($HTTP_POST_VARS as $var => $value) - { - if(substr($var, 0, 5) === 'edit_') - { - $var = substr($var, 5); - $value = stripslashes($value); - $data_item[$var] = $value; - $data_item_update[] = $var . "='" . xs_sql($value) . "'"; - } - elseif(substr($var, 0, 5) === 'name_') - { - $var = substr($var, 5).'_name'; - $value = stripslashes($value); - $data_name[$var] = $value; - $data_name_update[] = $var . "='" . xs_sql($value) . "'"; - $data_name_insert_vars[] = $var; - $data_name_insert_values[] = xs_sql($value); - } - } - // update item - $sql = "UPDATE " . THEMES_TABLE . " SET " . implode(',', $data_item_update) . " WHERE themes_id='{$id}'"; - if(!$result = $db->sql_query($sql)) - { - xs_error($lang['xs_edittpl_error_updating'] . '

' . $lang['xs_edittpl_back_edit'] . '

' . $lang['xs_edittpl_back_list'], __LINE__, __FILE__); - } - // check if there is name - $sql = "SELECT themes_id FROM " . THEMES_NAME_TABLE . " WHERE themes_id='{$id}'"; - if(!$result = $db->sql_query($sql)) - { - $sql = "INSERT INTO " . THEMES_NAME_TABLE . " (" . implode(',', $data_name_insert_vars) . ") VALUES ('" . implode("', '", $data_name_insert_values) . "')"; - } - $item = $db->sql_fetchrow($result); - if(!is_array($item)) - { - $sql = "INSERT INTO " . THEMES_NAME_TABLE . " (" . implode(',', $data_name_insert_vars) . ") VALUES ('" . implode("', '", $data_name_insert_values) . "')"; - } - else - { - $sql = "UPDATE " . THEMES_NAME_TABLE . " SET " . implode(',', $data_name_update) . " WHERE themes_id='{$id}'"; - } - $db->sql_query($sql); - xs_message($lang['Information'], $lang['xs_edittpl_style_updated'] . '

' . $lang['xs_edittpl_back_edit'] . '

' . $lang['xs_edittpl_back_list']); -} - -// -// edit style -// -if(!empty($HTTP_GET_VARS['edit'])) -{ - $id = intval($HTTP_GET_VARS['edit']); - $sql = "SELECT * FROM " . THEMES_TABLE . " WHERE themes_id='{$id}'"; - if(!$result = $db->sql_query($sql)) - { - xs_error($lang['xs_no_style_info'], __LINE__, __FILE__); - } - $item = $db->sql_fetchrow($result); - if(empty($item['themes_id'])) - { - xs_error($lang['xs_invalid_style_id'] . '

' . $lang['xs_edittpl_back_list']); - } - $sql = "SELECT * FROM " . THEMES_NAME_TABLE . " WHERE themes_id='{$id}'"; - if(!$result = $db->sql_query($sql)) - { - $item_name = array(); - } - $item_name = $db->sql_fetchrow($result); - if($item_name === false || !@count($item_name)) - { - $item_name = xs_empty_name(); - } - $vars = xs_get_vars($item); - // show variables - $template->assign_vars(array( - 'U_ACTION' => append_sid('xs_edit_data.'.$phpEx), - 'TPL' => htmlspecialchars($item['template-name']), - 'STYLE' => htmlspecialchars($item['style_name']), - 'ID' => $id - ) - ); - // all variables - $i = 0; - foreach($vars as $var => $value) - { - $row_class = $xs_row_class[$i % 2]; - $i++; - if(isset($lang['xs_data_'.$var])) - { - $text = $lang['xs_data_'.$var]; - } - else - { - $str = substr($var, 0, strlen($var) - 1); - if(isset($lang['xs_data_'.$str])) - { - $str1 = substr($var, strlen($var) - 1); - $text = sprintf($lang['xs_data_'.$str], $str1); - } - else - { - $text = sprintf($lang['xs_data_unknown'], $var); - } - } - $template->assign_block_vars('row', array( - 'ROW_CLASS' => $row_class, - 'VAR' => $var, - 'VALUE' => isset($item[$var]) ? htmlspecialchars($item[$var]) : '', - 'LEN' => $value['len'], - 'SIZE' => $value['len'] < 10 ? 10 : 30, - 'TEXT' => htmlspecialchars($text), - ) - ); - if($value['color']) - { - $template->assign_block_vars('row.color', array()); - } - if($value['font']) - { - $template->assign_block_vars('row.font', array()); - } - if(isset($item_name[$var.'_name'])) - { - $template->assign_block_vars('row.name', array( - 'DATA' => $item_name[$var.'_name'] - ) - ); - } - else - { - $template->assign_block_vars('row.noname', array()); - } - } - $template->set_filenames(array('body' => XS_TPL_PATH . 'edit_data.tpl')); - $template->pparse('body'); - xs_exit(); -} - - -// -// show list of installed styles -// -$sql = 'SELECT themes_id, template_name, style_name FROM ' . THEMES_TABLE . ' ORDER BY style_name'; -if(!$result = $db->sql_query($sql)) -{ - xs_error($lang['xs_no_style_info'], __LINE__, __FILE__); -} -$style_rowset = $db->sql_fetchrowset($result); - -$template->set_filenames(array('body' => XS_TPL_PATH . 'edit_data_list.tpl')); -for($i=0; $iassign_block_vars('styles', array( - 'ROW_CLASS' => $row_class, - 'TPL' => htmlspecialchars($item['template_name']), - 'STYLE' => htmlspecialchars($item['style_name']), - 'U_EDIT' => append_sid('xs_edit_data.'.$phpEx.'?edit='.$item['themes_id']) - ) - ); -} - -$template->pparse('body'); -xs_exit(); - -?> \ No newline at end of file