Архивы автора: stas2000

Convert sound for Asterisk Mp3 to Wav

$i = 0; while ($i <= 101) { $i++; shell_exec(«lame —decode /tmp/mp3/$i.mp3 — | sox -v 0.5 -t wav — -t wav -b 16 -r 8000 -c 1 /tmp/wav/1/$i.wav»); }

Раздел: Php

Asterisk php ivr

public function inputToInt($sound, $maxDigits = 1, $repetitions = 3) { for ($ok = 0; $ok < $repetitions; $ok++) { $input = $this->agi->get_data($sound, 3000, $maxDigits)[‘result’]; if ($input) { return $input; } elseif ($ok == 2) { $this->agi->stream_file($this->path . ‘akasha-error’); exit(); } $this->agi->stream_file($this->path . ‘maharehet-mamtina-le-phira’); } }

View MySql log online

mysql -u username -p password SET GLOBAL general_log = ‘ON’; SHOW VARIABLES LIKE «general_log%»; tail -f /var/lib/mysql/localhost.log

Last_Id

$selectquery=»SELECT id FROM table ORDER BY id DESC LIMIT 1″; $result = $mysqli->query($selectquery); $row = $result->fetch_assoc(); echo $row[‘id’];

Asterisk ivr

[main-entry] exten => s,1,Answer exten => s,n,Playback(sound) exten => s,n,Set(numTries=0) exten => s,n(naberite),Background(sound) exten => s,n,WaitExten(3) exten => 1,1,Goto(blacklist,s,1) exten => 2,1,Dial(IAX2/asterisk/1000,,m) exten => 3,1,Dial(IAX2/asterisk/1000,,m) exten => 4,1,Dial(IAX2/asterisk/1000,,m) exten => 0,1,Dial(IAX2/asterisk/1000,,m) exten => i,1,Playback(/var/lib/asterisk/agi-bin/register/sound/pbx-invalid) exten => i,n,Goto(s,naberite) exten => t,1,Set(numTries=$[${numTries} + 1]) exten => t,n,GotoIf($[«${numTries}» < «3»]?s,naberite) exten => t,n,Dial(IAX2/asterisk/1000,,m)

Asterisk start Agi

#!/usr/bin/php -q <?php require(‘/var/lib/asterisk/agi-bin/phpagi.php’); $agi = new AGI(); $agi->answer();

Api geocoding google

$data = json_decode(file_get_contents(‘https://maps.googleapis.com/maps/api/geocode/json?&address=מצדה+7+בני+בק&key=XXXX&language=iw’)); //echo json_encode($data); echo ‘<pre>’; //var_dump($data->results[0]->address_components); $test = array(); foreach ($data->results[0]->address_components as $item) { $test[] = $item->long_name; } print_r($test);

Раздел: Php

php mysql pdo SELECT SUM

php mysql pdo SELECT SUM $sql = $pdo->prepare(«SELECT SUM(quantity) FROM card WHERE phone=’$phone'»); $sql->execute(); $row = $sql->fetchColumn(0);

Раздел: Php

Agi php back to extensions

Agi php back to extensions $agi->exec_goto(‘menu-change-address,s,1’); $agi->exec(‘Goto’, «app-daynight,1,1»);