'ex_header,ex_footer', 'FROM' => "{$dbprefix}stats" ]; $result = $SQL->build($query); //is there any change ! $affected = false; $extras = $SQL->fetch_array($result); //when submit if (ip('submit')) { $update_sql = ''; if (g('smt') == 'fe') { $ex_footer = p('ex_footer', 'str'); $update_sql = "ex_footer = '" . $SQL->real_escape(htmlspecialchars_decode($ex_footer)) . "'"; } else { $ex_header = p('ex_header', 'str'); $update_sql = "ex_header = '" . $SQL->real_escape(htmlspecialchars_decode($ex_header)) . "'"; } //update $update_query = [ 'UPDATE' => "{$dbprefix}stats", 'SET' => $update_sql ]; $SQL->build($update_query); if ($SQL->affected()) { $affected = true; //delete cache .. delete_cache('data_extra'); } } else { extract($extras); } //reverse //$ex_header = htmlspecialchars_decode($ex_header); //$ex_footer = htmlspecialchars_decode($ex_footer); $SQL->freeresult($result); //after submit if (ip('submit')) { kleeja_admin_info(($affected ? $lang['EXTRA_UPDATED'] : $lang['NO_UP_CHANGE_S']), true, '', true, $action); } //secondary menu $go_menu = [ 'he' => ['name'=>$lang['ADD_HEADER_EXTRA'], 'link'=> basename(ADMIN_PATH) . '?cp=n_extra&smt=he', 'goto'=>'he', 'current'=> $current_smt == 'he'], 'fe' => ['name'=>$lang['ADD_FOOTER_EXTRA'], 'link'=> basename(ADMIN_PATH) . '?cp=n_extra&smt=fe', 'goto'=>'fe', 'current'=> $current_smt == 'fe'], ];