function adr_get_alignment_infos($alignment_id) { global $db, $lang, $phpEx, $phpbb_root_path, $board_config, $table_prefix; define('IN_ADR_CHARACTER', 1); include_once $phpbb_root_path . 'adr/includes/adr_constants.' . $phpEx; $alignment_id = intval($alignment_id); $cache_config = explode('-', $board_config['Adr_use_cache_system']); if ($cache_config[0]) { // All the following code has been made by Ptirhiik @(include $phpbb_root_path . './adr/cache/cache_alignments.' . $phpEx); if (!empty($adr_alignments)) { $cached_adr_alignments = $adr_alignments[$alignment_id]; } else { $sql = "SELECT * FROM " . ADR_ALIGNMENTS_TABLE . "\n\t\t\t\tWHERE alignment_id = '{$alignment_id}'"; if (!($result = $db->sql_query($sql))) { message_die(GENERAL_ERROR, 'Unable to query alignment infos (cache)', '', __LINE__, __FILE__, $sql); } @(include $phpbb_root_path . './adr/cache/cache_alignments.' . $phpEx); if (empty($adr_alignments)) { adr_update_alignment_infos(); include $phpbb_root_path . './adr/cache/cache_alignments.' . $phpEx; $cached_adr_alignments = $adr_alignments[$alignment_id]; } } } else { $alignment_sql = "SELECT * FROM " . ADR_ALIGNMENTS_TABLE . "\n\t\t\tWHERE alignment_id = '{$alignment_id}'"; if (!($alignment_result = $db->sql_query($alignment_sql))) { message_die(GENERAL_ERROR, 'Unable to query element infos (non-cache)', '', __LINE__, __FILE__, $sql); } $cached_adr_alignments = $db->sql_fetchrow($alignment_result); } return $cached_adr_alignments; }
$fields_data = $db->sql_fetchrow($result); $alignment_name = isset($_POST['alignment_name']) ? trim($_POST['alignment_name']) : trim($_GET['alignment_name']); $alignment_img = isset($_POST['alignment_img']) ? trim($_POST['alignment_img']) : trim($_GET['alignment_img']); $alignment_desc = isset($_POST['alignment_desc']) ? trim($_POST['alignment_desc']) : trim($_GET['alignment_desc']); $level = intval($_POST['level']); $alignment_id = $fields_data['alignment_id'] + 1; if ($alignment_name == '') { message_die(MESSAGE, $lang['Fields_empty']); } $sql = "INSERT INTO " . ADR_ALIGNMENTS_TABLE . " \n\t\t\t\t( alignment_id , alignment_name , alignment_desc , alignment_level , alignment_img )\n\t\t\t\tVALUES ( {$alignment_id},'" . str_replace("\\'", "''", $alignment_name) . "', '" . str_replace("\\'", "''", $alignment_desc) . "' , {$level} , '" . str_replace("\\'", "''", $alignment_img) . "' )"; $result = $db->sql_query($sql); if (!$result) { message_die(GENERAL_ERROR, "Couldn't insert new alignment", "", __LINE__, __FILE__, $sql); } // Update cache adr_update_alignment_infos(); adr_previous(Adr_alignment_successful_added, admin_adr_alignments, ''); break; } } else { adr_template_file('admin/config_adr_alignments_list_body.tpl'); $sql = "SELECT *\n\t\tFROM " . ADR_ALIGNMENTS_TABLE; $result = $db->sql_query($sql); if (!$result) { message_die(GENERAL_ERROR, 'Could not obtain alignments information', "", __LINE__, __FILE__, $sql); } $alignments = $db->sql_fetchrowset($result); for ($i = 0; $i < count($alignments); $i++) { $row_class = !($i % 2) ? $theme['td_class1'] : $theme['td_class2']; $level[0] = $lang['Adr_races_level_all']; $level[1] = $lang['Adr_races_level_admin'];
function adr_get_alignment_infos($alignment_id) { global $db, $lang, $phpEx, $phpbb_root_path, $board_config, $table_prefix; redefine('IN_ADR_CHARACTER', 1); include_once $phpbb_root_path . 'adr/includes/adr_constants.' . $phpEx; $alignment_id = intval($alignment_id); // All the following code has been made by Ptirhiik @(include $phpbb_root_path . './adr/cache/cache_alignments.' . $phpEx); if (!empty($adr_alignments)) { $cached_adr_alignments = $adr_alignments[$alignment_id]; } else { adr_update_alignment_infos(); include $phpbb_root_path . './adr/cache/cache_alignments.' . $phpEx; $cached_adr_alignments = $adr_alignments[$alignment_id]; } return $cached_adr_alignments; }