74 lines
2.4 KiB
PHP
74 lines
2.4 KiB
PHP
|
|
<?
|
||
|
|
$page = "admin_birthdayEmails";
|
||
|
|
include "admin_header.php";
|
||
|
|
|
||
|
|
if(isset($_POST['submit']))
|
||
|
|
{
|
||
|
|
$bSubmit = true;
|
||
|
|
$sql = "SELECT * FROM `birthdayEmails_options`";
|
||
|
|
$result = $database->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";
|
||
|
|
?>
|