|
';
switch ($_GET['action']) {
case 'admin': // done
admin(); break;
case 'mail_liste': // done
mail_liste(); break;
case 'edit_mail_liste': //done
edit_mail_liste(); break;
case 'settings_mail_liste': // done
settings_mail_liste(); break;
case 'step_1': // done, NEED TO TRANSLATE
step_1(); break;
case 'approve_step_1': // done, NEED TO TRANSLATE
approve_step_1(); break;
case 'preveri': // done, NEED TO TRANSLATE
preveri(); break;
case 'pregled': // done, NEED TO TRANSLATE
pregled(); break;
case 'prijavi':
prijavi(); break;
case 'send':
send(); break;
default: // done
prijava_odjava(); break;
}
echo ' |
';
site_foot();
html_food();
function admin() {
global $site_configure;
// prikazi, ce si prijavljen v sistem
if (checkPermission('','','') != true) {
break 2;
}
echo '
';
}
function check_rows($relative,$mail) {
global $site_configure;
$check = mysql_query("SELECT id
FROM ecosyc_maillist_email
WHERE relative={$relative} AND
email = '{$mail}'")
or die('Query failed: '. mysql_error());
$hm = mysql_num_rows($check);
return $hm;
}
function prijava_odjava() {
global $site_configure;
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_name
WHERE visible = 1
ORDER BY id ASC")
or die('Query failed: '. mysql_error());
echo '
';
}
function mail_liste() {
global $site_configure;
// prikazi, ce si prijavljen v sistem
if (checkPermission('','','') != true) {
break 2;
}
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_name
ORDER BY id ASC")
or die('Query failed: '. mysql_error());
if (checkPermission('','','')) {
echo "[".translate_key($_SESSION[lang], 'maillist', 'add_mail_list')."]
"; }
echo "\n\n";
while ($ShowRow = mysql_fetch_array($Show)) {
echo "
| {$ShowRow[id]} |
{$ShowRow[name]} |
![\"".translate_key($_SESSION[lang],](\"images/edit.gif\")
|
\n";
}
echo "
\n";
}
function edit_mail_liste() {
global $site_configure;
// prikazi, ce si prijavljen v sistem
if (checkPermission('','','') != true) {
exit;
}
if ($_GET[id] != "0") {
// Show selected news
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_name
WHERE id='{$_GET[id]}'")
or die('Query failed: '. mysql_error());
$ShowRow = mysql_fetch_array($Show);
$ShowListName = stripslashes($ShowRow["name"]);
$ShowSubject = stripslashes($ShowRow["subject"]);
$ShowVisible = $ShowRow["visible"];
mysql_free_result($Show);
} else {
$ShowVisible = 1;
}
echo '
';
}
function settings_mail_liste() {
global $site_configure;
// prikazi, ce si prijavljen v sistem
if (checkPermission('','','') != true) {
exit;
}
// Show selected news
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_settings")
or die('Query failed: '. mysql_error());
$ShowRow = mysql_fetch_array($Show);
$ShowOwner = stripslashes($ShowRow["owner"]);
$ShowConfirmSubject = stripslashes($ShowRow["confirm_subject"]);
$ShowConfirmBody = stripslashes($ShowRow["confirm_body"]);
$ShowWelcomeSubject = stripslashes($ShowRow["welcome_subject"]);
$ShowWelcomeBody = stripslashes($ShowRow["welcome_body"]);
$ShowGoodbyeSubject = stripslashes($ShowRow["goodbye_subject"]);
$ShowGoodbyeBody = stripslashes($ShowRow["goodbye_body"]);
$ShowMaillistFood = stripslashes($ShowRow["maillist_food"]);
$ShowMaillistFoodVisible = $ShowRow["maillist_food_visible"];
mysql_free_result($Show);
echo '
';
}
function step_1() {
global $site_configure;
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_confirm c,
ecosyc_maillist_name n
WHERE c.relative = n.id AND
c.email = '{$_GET[mail]}' AND
c.status = '{$_GET[status]}' AND
c.timestamp = '{$_GET[stamp]}' AND
n.visible = 1
ORDER BY name ASC")
or die('Query failed: '. mysql_error());
$num_rows = mysql_num_rows($Show);
if ($num_rows == 0)
exit;
echo ($_GET[status] ? ''.translate_key($_SESSION[lang], 'maillist', 'first_step_subscribe').'
' : ''.translate_key($_SESSION[lang], 'maillist', 'first_step_unsubscribe').'
');
echo '
'.translate_key($_SESSION[lang], 'maillist', 'check_your_mail').'
'.translate_key($_SESSION[lang], 'maillist', 'choosed_lists').'
';
while ($ShowRow = mysql_fetch_array($Show)) {
echo '* '. $ShowRow[name] .'
';
}
echo '
';
}
function approve_step_1() {
global $site_configure;
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_confirm c,
ecosyc_maillist_name n
WHERE c.relative = n.id AND
c.email = '{$_GET[mail]}' AND
c.status = '{$_GET[status]}' AND
c.timestamp = '{$_GET[stamp]}' AND
n.visible = 1
ORDER BY name ASC")
or die('Query failed: '. mysql_error());
$num_rows = mysql_num_rows($Show);
if ($num_rows == 0)
exit;
echo ($_GET[status] ? ''.translate_key($_SESSION[lang], 'maillist', 'successful_subscription').'
' : ''.translate_key($_SESSION[lang], 'maillist', 'successful_unsubscribe').'
');
echo '
';
echo ($_GET[status] ? ''.translate_key($_SESSION[lang], 'maillist', 'successful_subscription_mailing_list').'' : ''.translate_key($_SESSION[lang], 'maillist', 'successful_unsubscription_mailing_list').'');
echo '
'.translate_key($_SESSION[lang], 'maillist', 'choosed_lists').'
';
while ($ShowRow = mysql_fetch_array($Show)) {
if ($_GET[status]) {
$insert = mysql_query("INSERT INTO ecosyc_maillist_log
VALUES ('',
'WEB',
'{$ShowRow[relative]}',
'{$_GET[mail]}',
'{$_GET[status]}',
'{$_SERVER["REMOTE_ADDR"]}',
NOW())")
or die('Query failed: '. mysql_error());
$insert_approve = mysql_query("INSERT INTO ecosyc_maillist_email
VALUES ('',
'{$ShowRow[relative]}',
'{$ShowRow[email]}')")
or die('Query failed: '. mysql_error());
$delete = mysql_query("DELETE FROM ecosyc_maillist_confirm
WHERE id={$ShowRow[0]}")
or die('Query failed: '. mysql_error());
} else {
$insert = mysql_query("INSERT INTO ecosyc_maillist_log
VALUES ('',
'WEB',
'{$ShowRow[relative]}',
'{$_GET[mail]}',
'{$_GET[status]}',
'{$_SERVER["REMOTE_ADDR"]}',
NOW())")
or die('Query failed: '. mysql_error());
$delete_approve = mysql_query("DELETE FROM ecosyc_maillist_email
WHERE relative={$ShowRow[relative]} AND
email='{$ShowRow[email]}'")
or die('Query failed: '. mysql_error());
$delete = mysql_query("DELETE FROM ecosyc_maillist_confirm
WHERE id={$ShowRow[0]}")
or die('Query failed: '. mysql_error());
}
echo '* '.$ShowRow[name].'
';
}
echo '
';
if ($_GET[status]) {
// Show selected news
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_settings")
or die('Query failed: '. mysql_error());
$ShowRow = mysql_fetch_array($Show);
$ShowOwner = stripslashes($ShowRow["owner"]);
$ShowWelcomeSubject = stripslashes($ShowRow["welcome_subject"]);
$ShowWelcomeBody = nl2br(stripslashes($ShowRow["welcome_body"]));
mysql_free_result($Show);
// emailbody
$emailbody = '
'.
$ShowWelcomeBody .'
';
$mail = new Mailer();
$mail->from = $ShowOwner;
$mail->body = $emailbody;
$mail->subject = $ShowWelcomeSubject;
$mail->type = "text/html";
$mail->to = $_GET[mail];
$mail->send();
}
}
function preveri() {
global $site_configure;
echo '
'.translate_key($_SESSION[lang], 'maillist', 'check_e_mail_present_mail_list').'
';
}
function pregled() {
global $site_configure;
// prikazi, ce si prijavljen v sistem
if (checkPermission('','','') != true) {
break 2;
}
echo '
';
}
function prijavi() {
global $site_configure;
// prikazi, ce si prijavljen v sistem
if (checkPermission('','','') != true) {
break 2;
}
echo ''.translate_key($_SESSION[lang], 'maillist', 'admin').' - '.translate_key($_SESSION[lang], 'maillist', 'subscribe').'
';
$Show = mysql_query("SELECT *
FROM ecosyc_maillist_name
ORDER BY id ASC")
or die('Query failed: '. mysql_error());
echo '
';
}
function send() {
global $site_configure;
// prikazi, ce si prijavljen v sistem
if (checkPermission('','','') != true) {
break 2;
}
// Show selected maillist settings
$show = mysql_query("SELECT owner,
maillist_food,
maillist_food_visible
FROM {$site_configure[db_prefix]}_maillist_settings")
or die('Query failed: '. mysql_error());
$rowMailListConf = mysql_fetch_array($show);
mysql_free_result($show);
$show = mysql_query("SELECT `mail_replay-to`,
mail_subject,
mail_body
FROM {$site_configure[db_prefix]}_maillist_send")
or die('Query failed: '. mysql_error());
$rowMailListSend = mysql_fetch_array($show);
mysql_free_result($show);
echo ''.translate_key($_SESSION[lang], 'maillist', 'admin').' - SEND MAIL
';
echo '
';
}
?>