function callbackAction($msgnum, $bounce_type, $email, $subject, $xheader, $remove, $rule_no = false, $rule_cat = false, $totalFetched = 0)
{
$currentTime = date('Y-m-d H:i:s', time());
$displayData = prepData($email, $bounce_type, $remove);
$bounce_type = $displayData[bounce_type];
$emailName = $displayData[emailName];
$emailAddy = $displayData[emailAddy];
$remove = $displayData[remove];
$removeraw = $displayData[removestat];
$msg = $msgnum . ',' . $currentTime . ',' . $rule_no . ',' . $rule_cat . ',' . $bounce_type . ',' . $removeraw . ',' . $email . ',' . $subject;
$filename = 'logs/bouncelog_' . date('m') . date('Y') . '.csv';
if (!file_exists($filename)) {
$tmsg = 'Msg#,Current Time,Rule Number,Rule Category,Bounce Type,Status,Email,Subject' . "\n" . $msg;
} else {
$fileContents = file_get_contents($filename);
if (stristr($fileContents, "\n" . $msgnum . ',')) {
$doPutFile = false;
} else {
}
$tmsg = $msg;
}
if ($handle = fopen($filename, 'a')) {
if (fwrite($handle, $tmsg . "\n") === FALSE) {
echo 'Cannot write message<br />';
}
fclose($handle);
} else {
echo 'Cannot open file to append<br />';
}
echo $msgnum . ': ' . $rule_no . ' | ' . $rule_cat . ' | ' . $bounce_type . ' | ' . $remove . ' | ' . $email . ' | ' . $subject . "<br />\n";
return true;
}
function callbackAction($msgnum, $bounce_type, $email, $subject, $xheader, $remove, $rule_no = false, $rule_cat = false, $totalFetched = 0)
{
// sample mysql code
if ($remove == true || $remove == '1') {
echo "note: sample code would have set the database to allowed='false'<br />";
/*
$conn = mysql_connect("localhost","username","password");
$sql = "SELECT id FROM mailinglist WHERE email = '" . $email . "'";
$result = mysql_query($sql);
if ( $result ) {
while($row = mysql_fetch_array($result)) {
$sql_update = "UPDATE mailinglist SET allowed='false' WHERE email = '" . $email . "'";
$result_update = mysql_query($sql_update);
}
}
mysql_close($conn);
*/
}
$displayData = prepData($email, $bounce_type, $remove);
$bounce_type = $displayData['bounce_type'];
$emailName = $displayData['emailName'];
$emailAddy = $displayData['emailAddy'];
$remove = $displayData['remove'];
echo $msgnum . ': ' . $rule_no . ' | ' . $rule_cat . ' | ' . $bounce_type . ' | ' . $remove . ' | ' . $email . ' | ' . $subject . "<br />\n";
return true;
}
function callbackAction($msgnum, $bounce_type, $email, $subject, $xheader, $remove, $rule_no = false, $rule_cat = false, $totalFetched = 0)
{
$displayData = prepData($email, $bounce_type, $remove);
$bounce_type = $displayData['bounce_type'];
$emailName = $displayData['emailName'];
$emailAddy = $displayData['emailAddy'];
$remove = $displayData['remove'];
echo $msgnum . ': ' . $rule_no . ' | ' . $rule_cat . ' | ' . $bounce_type . ' | ' . $remove . ' | ' . $email . ' | ' . $subject . "<br />\n";
return true;
}
function callbackAction($msgnum, $bounce_type, $email, $subject, $xheader, $remove, $rule_no = false, $rule_cat = false, $totalFetched = 0, $type)
{
$displayData = prepData($email, $bounce_type, $remove);
$bounce_type = $displayData[bounce_type];
$emailName = $displayData[emailName];
$emailAddy = $displayData[emailAddy];
$remove = $displayData[remove];
echo $msgnum . ': ' . $type . ': ' . $rule_no . ' | ' . $rule_cat . ' | ' . $bounce_type . ' | ' . $remove . ' | ' . $email . ' | ' . $subject . "<br />\n";
global $table_prefix;
if ($rule_no != 00) {
$emailadvtrow = mysql_query("select id from " . $table_prefix . "email_advt where email='{$email}' and unsubstatus='0'");
$advtrowcount = mysql_num_rows($emailadvtrow);
if ($advtrowcount > 0) {
$advtrow = mysql_fetch_row($emailadvtrow);
$emailrow = mysql_query("select id from " . $table_prefix . "bounce_mail_details where email='{$email}'");
$rowcount = mysql_num_rows($emailrow);
if ($rowcount == 0) {
mysql_query("insert into " . $table_prefix . "bounce_mail_details values('0','{$rule_no}','{$bounce_type}','{$email}','{$subject}','{$advtrow['0']}')");
}
}
}
return true;
}
?>
---</option>
<?php
function prepData($value)
{
global $qPHP;
$value = $qPHP->istr_replace("container.", "", $value);
$value = $qPHP->istr_replace("item.", "", $value);
$value = $qPHP->istr_replace(".", " : ", $value);
return $value;
}
$sql = "SELECT `CLASS` FROM `OBJECTS` GROUP BY `CLASS`";
$res = $db->query($sql);
while ($zeilen = $res->fetchArray()) {
$zeilen['CLASS'] == $_SESSION['fclass'] ? $class_sel = " selected='selected'" : ($class_sel = "");
print "<option value='" . $zeilen['CLASS'] . "'{$class_sel}>" . prepData($zeilen['CLASS']) . "</option>\n";
}
?>
</select>
<input type="submit" name="senden" value="<?php
print $mlng['search'];
?>
" />
</form>
</td>
</tr>
<tr>
<td class="einstellungen">
<form method="post" action="." name="frm_sort">
<b><?php
print $mlng['sort'];
function check_online($user) { /*Verifies if user is logged in*/
$user = prepData($user);
$sql = "
SELECT username
FROM users
WHERE
last_session<>''
AND last_ip<>''
AND id='$user'
AND last_seen BETWEEN NOW()- INTERVAL 2 HOUR AND NOW()
AND validado=1
";
//echo $sql;
$result = mysql_query($sql);
if (!$result) echo mysql_error();
$row = mysql_fetch_assoc($result);
if (is_array($row)) {
return 1;
} else {
return 0;
}
}
if (isset($_POST['edita_grava'])) {
/*Serialized vars*/
foreach ($languages as $chave => $lingua) {
$text[$lingua] = $_POST['text_'.$lingua];
$title[$lingua] = $_POST['title_'.$lingua];
$seo_desc[$lingua] = $_POST['seo_desc_'.$lingua];
}
$user = cleanQuery($_GET['user']);
$id = cleanQuery($_GET['id']);
$text_bd = prepData(serialize($text));
$title_bd = prepData(serialize($title));
$seo_desc_bd = prepData(serialize($seo_desc));
$sql = "
INSERT INTO `posts` (`id` ,`user` ,`title` ,`text` ,`seo_desc`, `date_created`)
VALUES ('$id', '$user', '$title_bd', '$text_bd', '$seo_desc_bd',NOW())
ON DUPLICATE KEY UPDATE
`title`='$title_bd',
`text`='$text_bd',
`date_change` = NOW(),
`seo_desc` = '$seo_desc_bd'
";
mysql_query($sql) or die(mysql_error());
if($id=='') $id = mysql_insert_id();
/*SLUG*/
foreach ($languages as $chave => $lingua) {
function logger($msg)
{
$usuario = getSession("uid");
$usuario = empty($usuario) ? "SYSTEM" : $usuario;
// Ugly fix pra nao permitir salvar senha em banco.
unset($_POST["senha"]);
$mensagem = $msg;
$datahora = "now()";
$dados_post = prepData(serialize($_POST));
$dados_get = prepData(serialize($_GET));
$dados_session = prepData(serialize($_SESSION));
$ipaddr = $_SERVER["REMOTE_ADDR"];
$query = "insert into sis_log (usuario,mensagem,datahora,dados_get,dados_post,ipaddr) values('{$usuario}','{$mensagem}',{$datahora},'{$dados_get}','{$dados_post}','{$ipaddr}')";
execQuery($query) or die("Erro logando");
}
