Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- require_once 'sms_class.php';
- $dbconnect = mysql_connect($host, $user, $password) or die(mysql_error());
- mysql_select_db($db) or die (mysql_error());
- mysql_query("SET NAMES 'cp1251'");
- $query =
- "SELECT
- sm.index2 AS `index2`,
- m.message AS `message`,
- s.telephone AS `telephone`
- FROM
- `vixen_erps_services_messages` AS sm
- INNER JOIN
- `vixen_erps_messages_sms` AS m ON m.index2 = sm.message
- INNER JOIN
- `vixen_erps_services_sms` AS s ON s.pay = sm.service OR s.orders = sm.service OR s.news = sm.service
- OR s.other = sm.service";
- $res = mysql_query($query);
- while ($row = mysql_fetch_assoc($res)){
- $arr[] = $row;
- }
- $sms = new Sms();
- foreach ($arr as $r){
- $sms->SendSmsWorld($r['telephone'], $r['message'], 0);
- }
Add Comment
Please, Sign In to add comment