$v) $options['userlevels'][$k] = trim($v); $smarty->assign('aOptions', $options); $aUserLevels = array(); $sql = 'SELECT `level_id`, `level_name` FROM `se_levels` '; $result = mysql_query($sql); while( $aRow=mysql_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 = mysql_query($sql); while( $aRow=mysql_fetch_assoc($result) ) $aBdayFields[ $aRow['id'] ] = stripslashes($aRow['title']); $smarty->assign('aBdayFields', $aBdayFields); /*$sql = "SELECT `profilevalue_id` FROM `se_profilevalues` "; $result = mysql_query($sql); while($aRow=mysql_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 = mysql_query($sql); }*/ include "admin_footer.php"; ?>