Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function send_sms($code)
- {
- $sch=0; global $tel; global $mac; global $code;global $ip;
- $host = 'localhost';
- $database = 'datausers';
- $user = 'root';
- $pass = 'toor';
- $link = mysqli_connect($host,$user,$pass,$database);
- if(!$link)
- {
- die("Database connection failed: " . mysqli_error());
- }
- $db_secelect = mysqli_select_db($link,$database);
- if(!$db_secelect)
- {
- die("Database connection failed: " .mysqli_error($link));
- }
- $dbtel = mysqli_query($link,"SELECT phone FROM `dataconnection`");
- $dbip = mysqli_query($link,"SELECT ip FROM `dataconnection`");
- $dbmac = mysqli_query($link,"SELECT mac FROM `dataconnection`");
- $dbdate = mysqli_query($link,"SELECT date FROM `dataconnection`");
- $dbenable = mysqli_query($link,"SELECT enable FROM `dataconnection`");
- $rows_db = mysqli_num_rows($dbtel);
- for ($i=0;$i<$rows_db;$i++)
- {
- $dbmac_i = mysqli_result($dbmac, $i);
- if ($dbmac_i == $mac)
- { $sch++; $time = mysqli_result($dbdate, $i); $time_los = date("U") - $time;
- if ($time_los < 60)
- {
- {echo ("<p align='center' style='font-size:24px; color: #666;'>Повторно выслать смс можно через 1 минуту...</p>
- <form method='POST' name='user_code'>
- <p align='center' style='font-size:24px; color: #666;'>
- Введите код, полученный в смс<br>
- <input type='text' name='access_code' maxlength='6' autofocus='autofocus'
- style='2px solid; background:#fff; width:90px; font-size:24px; color: #666;'>
- <input type='submit' name='submit' value='Отправить' style='2px solid; background:#aefedf;
- width:150px; font-size:24px; color: #666;'>
- </p></form>"); break;}
- }
- else
- {
- $col = mysqli_result($dbenable, $i);
- if ($col > 1) {
- {
- echo("<p align='center' style='font-size:24px; color: #666;'>Возможно, какие-то проблемы на стороне оператора.
- <br> Для получения доступа обратитесь к администратору.</p> <form method='POST' name='user_code'>
- <p align='center' style='font-size:24px; color: #666;'>
- Введите код, полученный в смс</p>
- <p align='center' style='font-size:24px; color: #666;'>
- <input type='text' name='access_code' maxlength='6' autofocus='autofocus'
- style='2px solid; background:#fff; width:90px; font-size:24px; color: #666;'>
- <input type='submit' name='submit' value='Отправить' style='2px solid; background:#aefedf; width:150px; font-size:24px; color: #666;'>
- </p></form>");
- break;
- }
- }
- else
- {
- echo ("<p align='center' style='font-size:24px; color: #666;'><b>Смс с кодом выслано</b>.</p>
- <form method='POST' name='user_code'>
- <p align='center' style='font-size:24px; color: #666;'>
- Введите код, полученный в смс:</p>
- <p align='center' style='font-size:24px; color: #666;'>
- <input type='text' name='access_code' maxlength='6' autofocus='autofocus' style='2px solid; background:#fff; width:90px;
- font-size:24px; color: #666;'>
- <input type='submit' name='submit' value='Отправить' style='2px solid; background:#aefedf; width:150px; font-size:24px; color: #666;'>
- </p></form> ");break; }}}}
- #т.е. в базе такого macа нет, тогда записываем и шлем смс
- if ($sch == 0){$time = date("U");
- mysqli_query($link,"INSERT INTO dataconnection(phone,ip,mac,enable) VALUE ('$tel'.'$ip','$mac',1)");
- $sms_token = new SMSRU('09B77005-27A7-18B8-F53E-4DFFAA153CEA');
- $data = new stdClass();
- $data->to = $_POST['tel'];
- $data->text = $code;
- $sms = $sms_token->send_one($data);
- echo ("<p align='center' style='font-size:24px; color: #666;'>Смс с кодом выслано.</p>
- <form method='POST' name='user_code'>
- <p align='center' style='font-size:24px; color: #666;'>
- Введите код, полученный в смс<br>
- <input type='text' name='access_code' maxlength='6' autofocus='autofocus'
- style='2px solid; background:#fff; width:90px; font-size:24px; color: #666;'>
- <input type='submit' name='submit' value='Отправить' style='2px solid; background:#aefedf; width:150px; font-size:24px; color: #666;'>
- </p></form>");}
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement