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"); }