$value) { $sql=" insert into zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_POST['mail']."',id,'0' FROM zlo_users WHERE `group`=$value"; $result = mysql_query($sql) or die(mysql_error()); } } if ($_POST['form']['send_by']=='interest') { $userMass=''; foreach($_POST['form']['interest'] as $key=>$value) { $sql="SELECT u.id as user_id, u.interest FROM zlo_users as u WHERE u.`interest` LIKE '%$value%'"; $result = mysql_query($sql) or die(mysql_error()); if(mysql_affected_rows()!=0) { while ($user=mysql_fetch_assoc($result)) { $mass=explode(":",$user['interest']); foreach ($mass as $keys=>$valueSql){ if ($valueSql==$value) { $userMass[]=$user['user_id']; } } } } } if ($userMass!='') { // Äîáàâëÿåì â òàáëèöó $wait_users=implode(",",$userMass); $sql=" INSERT INTO zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_POST['mail']."',id,'".$_POST['form']['show']."' FROM zlo_users WHERE id IN ($wait_users)"; $result = mysql_query($sql) or die(mysql_error()); } } if ($_POST['form']['show']==1) { // ìåíÿåì ñòàòóñ íà àêòèâíî $sql="UPDATE zlo_mail SET `status`=1 WHERE id='".$_POST['mail']."' AND `status`=0 "; $result = mysql_query($sql) or die(mysql_error()); // ìåíÿåì ñòàòóñ íà àêòèâíî $sql="UPDATE zlo_mail_activity SET `status`=1 WHERE id='".$_POST['mail']."' AND `status`=0 "; $result = mysql_query($sql) or die(mysql_error()); } else { // ìåíÿåì ñòàòóñ íà íå àêòèâíî $sql="UPDATE zlo_mail SET `status`=0 WHERE id='".$_POST['mail']."' AND `status`=1"; $result = mysql_query($sql) or die(mysql_error()); // ìåíÿåì ñòàòóñ íà íå àêòèâíî $sql="UPDATE zlo_mail_activity SET `status`=0 WHERE id='".$_POST['mail']."' AND `status`=1 "; $result = mysql_query($sql) or die(mysql_error()); } echo ""; } else { echo (""); } } // ============= // ==== edit ==== // ============= if ((isset($_POST["send"])) && ($_POST["send"] == "edit")) { if (isset($_POST['form']['send_by'])) { //Îòáèðàåì ïàðàìåòðû ðàññûëêè äëÿ ñðàâíåíèÿ $sql1 = "SELECT * FROM zlo_mail WHERE id='".$_GET['mail']."'"; $result1 = mysql_query($sql1) or die(mysql_error()); if (mysql_affected_rows()!=0) { $mail=mysql_fetch_assoc($result1); if($mail['status']!=2) { $param=''; $MailParamMass =explode(":",$mail['param']); // ============================================================== // ======= Ïðîâåðÿåì íà èçìåíåíèå ïàðàìåòðîâ ðàññûëêè =========== // ============================================================== if ($_POST['form']['send_by']=='group') { $ChangesGroup = ChangesOfMass($_POST['form']['group'],$MailParamMass); } if ($_POST['form']['send_by']=='interest') { $ChangesInterest = ChangesOfMass($_POST['form']['interest'],$MailParamMass); } // ================= // ===== Group ===== // ================= /* if (isset($ChangesGroup['same'])) { $groups=implode(",",$ChangesGroup['same']); // Ñîáèðàåì â ìàññûâ ïîëüçîâàòåëåé êîòîðûì óæå áûëà ðàññûëêà $sql2 = "SELECT user_id FROM zlo_mail_activity WHERE mail_id='".$_GET['mail']."' AND `status`=2"; $result2 = mysql_query($sql2) or die(mysql_error()); if (mysql_affected_rows()!=0) { $recivedMass=''; while ($user_recived=mysql_fetch_assoc($result)){ $recivedMass[] = $user_recived['user_id']; } // Óäàëÿåì ñòàðîå $sql2 = "DELETE FROM zlo_mail_activity WHERE mail_id=".$_GET['mail']." AND `status`=1 OR `status`=0 AND user_id IN (SELECT id FROM zlo_users WHERE `group` IN ($groups))"; $result2 = mysql_query($sql2) or die(mysql_error()); // Äîáàâëÿåì íàíîâî çà èñêëþ÷åíèå óæå ïîëó÷èâøèõ ñòàðóþ âåðñèþ $recived_users=implode(",",$recivedMass); $sql2=" INSERT INTO zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_GET['mail']."',id,'0' FROM zlo_users WHERE `group` IN ($groups) AND user_id IS NOT IN (".$recived_users.") "; $result2 = mysql_query($sql2) or die(mysql_error()); } } */ // Äîáàâèëñÿ äîïîëíèòåëüíûé ïàðàìåòð if (isset($ChangesGroup['add'])) { $groups=implode(",",$ChangesGroup['add']); $sql2=" INSERT INTO zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_GET['mail']."',id,'0' FROM zlo_users WHERE `group` IN ($groups)"; $result2 = mysql_query($sql2) or die(mysql_error()); } // Óäàëèëñÿ äîïîëíèòåëüíûé ïàðàìåòð if (isset($ChangesGroup['del'])) { // Óäàëÿåì $groups=implode(",",$ChangesGroup['del']); $sql2 = "DELETE FROM zlo_mail_activity WHERE mail_id=".$_GET['mail']." AND `status`=1 OR `status`=0 AND user_id IN (SELECT id FROM zlo_users WHERE `group` IN ($groups))"; $result2 = mysql_query($sql2) or die(mysql_error()); } // ================= // === Interest ==== // ================= /* if (isset($ChangesInterest['same'])) { // Ñîáèðàåì â ìàññûâ ïîëüçîâàòåëåé êîòîðûì óæå áûëà ðàññûëêà $sql2 = "SELECT user_id FROM zlo_mail_activity WHERE mail_id='".$_GET['mail']."' AND `status`=2"; $result2 = mysql_query($sql2) or die(mysql_error()); if (mysql_affected_rows()!=0) { $recivedMass=''; while ($user_recived=mysql_fetch_assoc($result)){ $recivedMass[] = $user_recived['user_id']; } // Óäàëÿåì ñòàðîå $sql2 = "DELETE FROM zlo_mail_activity WHERE mail_id=".$_GET['mail']." AND `status`=1 OR `status`=0"; $result2 = mysql_query($sql2) or die(mysql_error()); // Îòáèðàåì ïîëüçîâàòå ó êîòîðûõ åñòü íóæíûå èíòåðåñû $userMass=''; foreach($ChangesInterest['add'] as $key=>$value) { $sql="SELECT u.id as user_id, i.interest FROM zlo_users as u LEFT JOIN zlo_users_info as i ON i.user_id=u.id WHERE i.`interest` LIKE '%$value%'"; $result = mysql_query($sql) or die(mysql_error()); if(mysql_affected_rows()!=0) { while ($user=mysql_fetch_assoc($result)) { $mass=explode(":",$user['interest']); foreach ($mass as $keys=>$valueSql){ if ($valueSql==$value) { $userMass[]=$user['user_id']; } } } } } if ($userMass!='') { // Äîáàâëÿåì â òàáëèöó çà èñêëþ÷åíèåì $wait_users=implode(",",$userMass); $recived_users=implode(",",$recivedMass); $sql=" INSERT INTO zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_POST['mail']."',id,'0' FROM zlo_users WHERE id IN ($wait_users) AND NOT IN ($recived_users)"; $result = mysql_query($sql) or die(mysql_error()); } } } */ // Äîáàâèëñÿ äîïîëíèòåëüíûé ïàðàìåòð if (isset($ChangesInterest['add'])) { // Îòáèðàåì ïîëüçîâàòå ó êîòîðûõ åñòü íóæíûå èíòåðåñû $userMass=''; foreach($ChangesInterest['add'] as $key=>$value) { $sql="SELECT u.id as user_id, u.interest FROM zlo_users as u WHERE u.`interest` LIKE '%$value%'"; $result = mysql_query($sql) or die(mysql_error()); if(mysql_affected_rows()!=0) { while ($user=mysql_fetch_assoc($result)) { $mass=explode(":",$user['interest']); foreach ($mass as $keys=>$valueSql){ if ($valueSql==$value) { $userMass[]=$user['user_id']; } } } } } // Äîáàâëÿåì â òàáëèöó $wait_users=implode(",",$userMass); $sql=" INSERT INTO zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_GET['mail']."',id,'0' FROM zlo_users WHERE id IN ($wait_users)"; $result = mysql_query($sql) or die(mysql_error()); } // Óäàëèëñÿ äîïîëíèòåëüíûé ïàðàìåòð if (isset($ChangesInterest['del'])) { // Îòáèðàåì ïîëüçîâàòå ó êîòîðûõ åñòü íóæíûå èíòåðåñû $userMass=''; foreach($ChangesInterest['del'] as $key=>$value) { $sql="SELECT u.id as user_id, u.interest FROM zlo_users as u WHERE u.`interest` LIKE '%$value%'"; $result = mysql_query($sql) or die(mysql_error()); if(mysql_affected_rows()!=0) { while ($user=mysql_fetch_assoc($result)) { $mass=explode(":",$user['interest']); foreach ($mass as $keys=>$valueSql){ if ($valueSql==$value) { $userMass[]=$user['user_id']; } } } } } // Óäàëÿåì $wait_users=implode(",",$userMass); $sql2 = "DELETE FROM zlo_mail_activity WHERE mail_id=".$_GET['mail']." AND `status`=1 OR `status`=0 AND user_id IN (SELECT id FROM zlo_users WHERE id IN ($wait_users))"; $result2 = mysql_query($sql2) or die(mysql_error()); $result = mysql_query($sql) or die(mysql_error()); } // ================= // ===== edit ====== // ================= if ($_POST['form']['date_start']=='') { $_POST['form']['date_start']=date('Y-m-d H:i:s'); } if ($_POST['form']['date_end']=='') { $_POST['form']['date_end']=date('Y-m-d H:i:s'); } // Îáíîâëÿåì $sql = sprintf("UPDATE zlo_mail SET subject=%s,email=%s,username=%s,`text`=%s,`send_by`=%s,`param`=%s,`interval`=%s,`limit`=%s,date_start=%s,date_end=%s,`show`=%s WHERE id=".$_GET['mail']."", GetSQLValueString($_POST['form']['subject'], "text"), GetSQLValueString($_POST['form']['email'], "text"), GetSQLValueString($_POST['form']['username'], "text"), GetSQLValueString($_POST['text'], "text"), GetSQLValueString($_POST['form']['send_by'], "text"), GetSQLValueString(implode(":",$_POST['form'][$_POST['form']['send_by']]), "text"), GetSQLValueString($_POST['form']['interval'], "text"), GetSQLValueString($_POST['form']['limit'], "text"), GetSQLValueString($_POST['form']['date_start'], "text"), GetSQLValueString($_POST['form']['date_end'], "text"), GetSQLValueString($_POST['form']['show'], "text")); $result = mysql_query($sql) or die(mysql_error()); if ($_POST['form']['show']==1) { // ìåíÿåì ñòàòóñ íà àêòèâíî $sql="UPDATE zlo_mail SET `status`=1 WHERE id='".$_GET['mail']."' AND `status`=0 "; $result = mysql_query($sql) or die(mysql_error()); // ìåíÿåì ñòàòóñ íà àêòèâíî $sql="UPDATE zlo_mail_activity SET `status`=1 WHERE mail_id='".$_GET['mail']."' AND `status`=0 "; $result = mysql_query($sql) or die(mysql_error()); } else { // ìåíÿåì ñòàòóñ íà íå àêòèâíî $sql="UPDATE zlo_mail SET `status`=0 WHERE id='".$_GET['mail']."' AND `status`=1"; $result = mysql_query($sql) or die(mysql_error()); // ìåíÿåì ñòàòóñ íà íå àêòèâíî $sql="UPDATE zlo_mail_activity SET `status`=0 WHERE mail_id='".$_GET['mail']."' AND `status`=1 "; $result = mysql_query($sql) or die(mysql_error()); } echo ""; } else { echo (""); echo ""; } } } else { echo (""); } } // ============= // ==== del ==== // ============= if ((isset($_GET["action"])) && ($_GET["action"] == "del")) { $sql = "DELETE FROM zlo_mail WHERE id='".$_GET['mail']."'"; $result = mysql_query($sql) or die(mysql_error()); $sql = "DELETE FROM zlo_mail_activity WHERE mail_id='".$_GET['mail']."'"; $result = mysql_query($sql) or die(mysql_error()); echo ""; } // ============= // === set ==== // ============= if ((isset($_GET["action"])) && ($_GET["action"] == "set")) { $sql = "SELECT * FROM zlo_mail WHERE id='".$_GET['mail']."' "; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { $mail=mysql_fetch_assoc($result); if($mail['status']==1 || $mail['status']==0) { // ìåíÿåì ñòàòóñ íà íå àêòèâíî $sql="UPDATE zlo_mail SET `show`='".$_GET['show']."',`status`='".$_GET['show']."' WHERE id='".$_GET['mail']."' AND `status`!=2"; $result = mysql_query($sql) or die(mysql_error()); // ìåíÿåì ñòàòóñ íà íå àêòèâíî $sql="UPDATE zlo_mail_activity SET `status`='".$_GET['show']."' WHERE mail_id='".$_GET['mail']."' AND `status`!=2 "; $result = mysql_query($sql) or die(mysql_error()); } else { echo ""; } echo ""; } else { echo "";} } // ============= // ==== send ==== // ============= if ((isset($_POST["send"])) && ($_POST["send"] == "send")) { if (isset($_POST['form']['group'])) { foreach($_POST['form']['group'] as $key=>$value) { $sql=" insert into zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_POST['mail']."',id,'1' FROM zlo_users WHERE `group`=$value"; $result = mysql_query($sql) or die(mysql_error()); } } if (isset($_POST['form']['interest'])) { foreach($_POST['form']['interest'] as $key=>$value) { $sql=" insert into zlo_mail_activity (mail_id, user_id,`status`) SELECT '".$_POST['mail']."',id,'1' FROM zlo_users WHERE `group`=$value"; $result = mysql_query($sql) or die(mysql_error()); } } $sql="UPDATE zlo_mail SET `status`=1 WHERE id='".$_POST['mail']."' "; $result = mysql_query($sql) or die(mysql_error()); echo ""; } // ============================== // ========== Âûâîä ============= // ============================== // ============= // ==== All ==== // ============= if (!isset($_GET['action'])) { echo"Äîáàâèòü"; $sql = "SELECT * FROM zlo_mail"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { echo""; while ($mail=mysql_fetch_assoc($result)){ echo""; echo""; } echo"
id Òåìà Èíòåðâàë Ïèñåì çà ðàç Íà÷àëà Îêîí÷àíèå
".$mail['id']." ".$mail['subject']." ".$mail['interval']." ".$mail['limit']." ".$mail['date_start']." ".$mail['date_end']."
"; // ***** Àäìèí ðåæèì ***** if($mail['status']!=2) { if (isset($_SESSION['admin']['edit'])) {echo"";} if (isset($_SESSION['admin']['del'])) { // Àêòèâíî/íå àêòèâíî if($mail['show']==1) { echo""; } else { echo""; } echo""; } } if (isset($_SESSION['admin']['del'])) { echo"
";} // ************************ echo"
"; } } // ============= // ==== add ==== // ============= if (isset($_GET['action']) && $_GET['action']=='add') { if (!isset($_POST['form'])) { $_POST['form']=''; } if (!isset($_POST['text'])) { $_POST['text']=''; } // Íàñòðîéêè ïîóèîë÷àíèþ__halt_compiler if (!isset($_POST['form']['limit'])) { $_POST['form']['limit']='4'; } if (!isset($_POST['form']['interval'])) { $_POST['form']['interval']='120'; } if (!isset($_POST['form']['date_start'])) { $_POST['form']['date_start']=date('Y-m-d'); } if (!isset($_POST['form']['date_end'])) { $_POST['form']['date_end']=date('Y-m-d'); } echo"
"; // ================= Ïî ãðóïïàì ================== echo ""; // ================= Ïî èíòåðåñàì ================== echo "
Òåìà ïèñüìà
email îòïðàâèòåëÿ
Èìÿ îòïðàâèòåëÿ
Èíòåðâàë âðåìåíè (ñåê.)
Ïèñåì çà ðàç
Íà÷àëî
Îêîí÷àíèå
Àêòèâíî
Îòïðàâêà ïî "; echo"
Ïî ãðóïïàì
"; $sql="SELECT * FROM zlo_users_group"; $result = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { echo "".$row['name']; } echo"
Ïî èíòåðåñàì
"; $sql="SELECT * FROM zlo_interest ORDER BY `common` DESC"; $result = mysql_query($sql) or die(mysql_error()); $o=0; while ($row = mysql_fetch_assoc($result)) { if ($row['common']==1) { echo "
";} if ($row['common']==0 && $o==0) { echo "

"; $o=1;} echo "".$row['title']; } echo"
Òåêñò
"; echo''; echo''; } // ============= // === Edit ==== // ============= if (isset($_GET['action']) && $_GET['action']=='edit') { $sql = "SELECT * FROM zlo_mail WHERE id='".$_GET['mail']."'"; $result = mysql_query($sql) or die(mysql_error()); $mail=mysql_fetch_assoc($result); if (mysql_affected_rows()!=0) { echo"
"; // ================= Ïî ãðóïïàì ================== if ($mail['send_by'] == 'group') {$selectedd="checked='checked'"; $param=$mail['param']; echo ""; } if ($mail['send_by'] == 'interest') {$selectedd="checked='checked'"; $param=$mail['param']; // ================= Ïî èíòåðåñàì ================== echo ""; } echo""; echo"
Òåìà ïèñüìà
email îòïðàâèòåëÿ
Èìÿ îòïðàâèòåëÿ
Èíòåðâàë âðåìåíè (ñåê.)
Ïèñåì çà ðàç
Íà÷àëî
Îêîí÷àíèå
Àêòèâíî
Îòïðàâêà ïî Ïî ãðóïïàì"; echo"
"; $sql="SELECT * FROM zlo_users_group"; $result = mysql_query($sql) or die(mysql_error()); $mass2=explode(":",$param); $o=0; while ($row = mysql_fetch_assoc($result)) { if ($row['common']==1) { echo "
";} if ($row['common']==0 && $o==0) { echo "

"; $o=1;} if (in_array($row['id'],$mass2)) { echo "".$row['name']; } else { echo "".$row['name']; } } echo"
"; echo "
Ïî èíòåðåñàì"; echo"
"; $sql="SELECT * FROM zlo_interest ORDER BY `common` DESC"; $result = mysql_query($sql) or die(mysql_error()); $mass2=explode(":",$param); while ($row = mysql_fetch_assoc($result)) { if ($row['common']==1) { echo "
";} if ($row['common']==0 && $o==0) { echo "

"; $o=1;} if (in_array($row['id'],$mass2)) { echo "".$row['title']; } else { echo "".$row['title']; } } echo"
Òåêñò
"; } echo''; echo''; } // ============= // ==== send ==== // ============= /* if (isset($_GET['action']) && $_GET['action']=='send') { // Ïðîâåðÿåì èëè ðàññûëêà íåàêòèâíà $sql="SELECT `status` FROM zlo_mail WHERE id='".$_GET['mail']."'"; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($result); if ($row['status']==0) { echo"
"; // ================= Ïî ãðóïïàì ================== if (isset($_GET['send_by']) && $_GET['send_by']=='group') { echo ""; } if (isset($_GET['send_by']) && $_GET['send_by']=='interest') { // ================= Ïî èíòåðåñàì ================== echo ""; } echo"
Ïî ãðóïïàì "; $sql="SELECT * FROM zlo_users_group"; $result = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { if (in_array($row[$field[0]],$value)) { echo "".$row['name']; } else { echo "".$row['name']; } } echo "
Ïî èíòåðåñàì "; $sql="SELECT * FROM zlo_interest"; $result = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { if (in_array($row[$field[0]],$value)) { echo "".$row['title']; } else { echo "".$row['title']; } } echo "
"; } elseif ($row['status']==1) { echo"Ðàññûëêà óæå çàïóùåíà"; } elseif ($row['status']==2) { echo"Ðàññûëêà çàâåðøåíà";} } */ ?>