Files
Testing/bwadmin/admin_birthdayEmails.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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";
?>