Guest User

Untitled

a guest
Jul 1st, 2016
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?
  2. require_once 'sms_class.php';
  3.  
  4. $dbconnect = mysql_connect($host, $user, $password) or die(mysql_error());
  5. mysql_select_db($db) or die (mysql_error());
  6.  
  7. mysql_query("SET NAMES 'cp1251'");
  8.  
  9. $query =
  10. "SELECT
  11. sm.index2 AS `index2`,
  12. m.message AS `message`,
  13. s.telephone AS `telephone`
  14. FROM
  15. `vixen_erps_services_messages` AS sm
  16. INNER JOIN
  17. `vixen_erps_messages_sms` AS m ON m.index2 = sm.message
  18. INNER JOIN
  19. `vixen_erps_services_sms` AS s ON s.pay = sm.service OR s.orders = sm.service OR s.news = sm.service
  20. OR s.other = sm.service";
  21.  
  22. $res = mysql_query($query);
  23.  
  24. while ($row = mysql_fetch_assoc($res)){
  25. $arr[] = $row;
  26. }
  27.  
  28. $sms = new Sms();
  29. foreach ($arr as $r){
  30. $sms->SendSmsWorld($r['telephone'], $r['message'], 0);
  31. }
Add Comment
Please, Sign In to add comment