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;
}
