Changeset 4229 for extensions/Mail_supervisor/include
- Timestamp:
- Nov 8, 2009, 5:38:51 PM (15 years ago)
- Location:
- extensions/Mail_supervisor/include
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/Mail_supervisor/include/fonctions.php
r4224 r4229 595 595 SELECT ".$champs.",COUNT(`id`) as total 596 596 FROM `".MAIL_BLACK_LISTE_TABLE."` 597 WHERE `ip` LIKE '".$ip."'597 WHERE '".$ip."' LIKE `ip` 598 598 ;"; 599 599 $result = @pwg_query($query); … … 603 603 $result = @pwg_query($query); 604 604 } 605 $datas = mysql_fetch_array($result,MYSQL_ASSOC); 606 605 $datas = mysql_fetch_array($result,MYSQL_ASSOC); 607 606 $nb = $datas['total']; 607 608 608 if ($mails_options[5] == 'on') 609 609 { … … 635 635 if ( $nb > 0 ) 636 636 { 637 $erreur_message .= $ip . ' | ' . $pays . ' | ' . $region . ' | ' . $ville . ' ==> '; 637 $query = " 638 SELECT ".$champs.",COUNT(`id`) as total 639 FROM `".MAIL_BLACK_LISTE_TABLE."` 640 WHERE '".$ip."' = `ip` 641 ;"; 642 $result = @pwg_query($query); 643 644 if (!$result) { 645 vérif_base(); 646 $result = @pwg_query($query); 647 } 648 $datas = mysql_fetch_array($result,MYSQL_ASSOC); 649 $nb = $datas['total']; 650 638 651 $row = mysql_fetch_row(pwg_query($query)); 639 $nb = ($row[7])+1; 652 $nb = ($row[7]); 653 $erreur_message .= $ip . ' | ' . $pays . ' | ' . $region . ' | ' . $ville . ' ' . $nb . ' ==> '; 654 655 if ($nb == 0) 656 { 657 $valeurs=array( 'NULL', 658 "'".$ip."'", 659 "'".$pays."'", 660 "'".$region."'", 661 "'".$ville."'", 662 '"adresse"', 663 '"fai" ', 664 1 665 ); 666 ajout_ligne(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs, $valeurs,true) ; 667 668 } else { 669 $nb += 1; 640 670 $query =" 641 671 UPDATE " . MAIL_BLACK_LISTE_TABLE . " … … 649 679 $query .= " 650 680 `nb` = " . $nb . " 651 WHERE ip = '". $ip ."' ;681 WHERE '".$ip."' = `ip` 652 682 "; 653 pwg_query($query ); 683 684 pwg_query($query ); 685 } 654 686 //================================================================================ 655 687 -
extensions/Mail_supervisor/include/save_info.php
r4220 r4229 15 15 16 16 case 'ajout' : 17 18 $ip_black=str_replace("*","%",$ip_black); 17 19 18 20 … … 21 23 SELECT `ip` 22 24 FROM `".MAIL_BLACK_LISTE_TABLE."` 23 WHERE ip = '".$ip_black."'25 WHERE '".$ip_black."' LIKE ip 24 26 ;"; 25 //==============================================================================26 list($count) = mysql_fetch_row(pwg_query($query));27 //==============================================================================27 //============================================================================== 28 list($count) = mysql_fetch_row(pwg_query($query)); 29 //============================================================================== 28 30 $valeurs=array( 'NULL', 29 31 "'".$ip_black."'", … … 42 44 case 'raz': 43 45 $ip_black=str_replace('*',"%",$ip_black); 44 $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip` like '%".$ip_black."%'";46 $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip` like '%".$ip_black."%' "; 45 47 pwg_query($query); 46 48 break; … … 74 76 COUNT(H.`IP`) as total 75 77 FROM '.HISTORY_TABLE.' AS H 76 WHERE H.`IP` not LIKE "'.$_SERVER['REMOTE_ADDR'].'"78 WHERE "'.$_SERVER['REMOTE_ADDR'].'"not LIKE H.`IP` 77 79 ';// 78 80 if (count($liste_bl)>0)
Note: See TracChangeset
for help on using the changeset viewer.