database_query($sql); if( is_array($_POST['userlevels']) ) $_POST['userlevels'] = implode(",", $_POST['userlevels']); else $_POST['userlevels'] = ""; while($row = $database->database_fetch_array($result)) { $var = $row['var']; if(isset($_POST[$var])) { $sql2 = "UPDATE `birthdayEmails_options` SET `value` = '" . $_POST[$var] . "' WHERE `var` = '$var' LIMIT 1"; $result2 = $database->database_query($sql2); } } } $sql = "SELECT * FROM `birthdayEmails_options`"; $result = $database->database_query($sql); while($row = $database->database_fetch_array($result)){ $var = $row['var']; $value = stripslashes($row['value']); $options[$var] = $value; } $options['userlevels'] = explode(",", $options['userlevels']); foreach($options['userlevels'] as $k=>$v) $options['userlevels'][$k] = trim($v); $smarty->assign('aOptions', $options); $aUserLevels = array(); $sql = 'SELECT `level_id`, `level_name` FROM `se_levels` '; $result = $database->database_query($sql); while( $aRow=$database->database_fetch_assoc($result) ) { $aUserLevels[ $aRow['level_id'] ]['name'] = $aRow['level_name']; if( is_numeric(array_search($aRow['level_id'], $options['userlevels'])) ) $aUserLevels[ $aRow['level_id'] ]['sel'] = 1; } $smarty->assign('aUserLevels', $aUserLevels); $aBdayFields = array(); $sql = 'SELECT `f`.`profilefield_id` AS `id`, `l`.`languagevar_value` AS `title` FROM `se_profilefields` AS `f` INNER JOIN `se_languagevars` AS `l` ON `l`.`languagevar_id` = `f`.`profilefield_title` WHERE `f`.`profilefield_type` = "5" && `f`.`profilefield_special` = "1" '; $result = $database->database_query($sql); while( $aRow=$database->database_fetch_assoc($result) ) $aBdayFields[ $aRow['id'] ] = stripslashes($aRow['title']); $smarty->assign('aBdayFields', $aBdayFields); /*$sql = "SELECT `profilevalue_id` FROM `se_profilevalues` "; $result = $database->database_query($sql); while($aRow=$database->database_fetch_assoc($result) ) { $sDate = rand(1900,1997)."-".rand(1,12)."-".rand(1,30); $sql = "UPDATE `se_profilevalues` SET `profilevalue_4` = '{$sDate}' WHERE `profilevalue_id` = '{$aRow['profilevalue_id']}' "; $result2 = $database->database_query($sql); }*/ include "admin_footer.php"; ?>