recording conference system

1. [conferencesys]
2. exten=>_x.,1,Answer()
3. ;same=>n,System(php /var/www/html/conference/insert.php ${UNIQUEID} ${CDR(billsec)} ${CALLERID(num)} ${UNIQUEID})
4. same=>n,Set(Id=${SHELL(php /var/www/html/conference/insert.php ${UNIQUEID} ${CDR(billsec)} ${CALLERID(num)} ${UNIQUEID})})
5. same=>n,Playback(confirm-number-is)
6. same=>n,Saydigits(${Id})
7. same=>n,Set(CONFBRIDGE(bridge,record_conference)=yes)
8. same=>n,Set(CONFBRIDGE(bridge,record_file)=/var/www/html/conference/${UNIQUEID}.wav)
9. same=>n,Set(CONFBRIDGE(bridge,max_members)=1)
10. same=>n,ConfBridge(${UNIQUEID})
11. same=>n,hangup()
12. exten=>h,1,Noop(${UNIQUEID} ..)
13. same=>n,Set(path=${SHELL(find /var/www/html/conference -name ${UNIQUEID}*)})
14. same=>n,System(mysql --user=root --password='1234' conferences -e "update recordings set path='${path:0:-1}',duration='${CDR(billsec)}' where Id='${Id}'")
17. [listenrec]
18. exten=>_x.,1,Answer()
19. same=>n,read(idnum,enter-conf-call-number)
20. same=>n,Set(Id=${SHELL(mysql --user=root --password='1234' --skip-column-names  conferences -e "select path from recordings where Id='${idnum}'")})
21. same=>n,Noop(${Id:0:-5})
22. same=>n,Playback(${Id:0:-5})
27. <?php
28. $link = mysqli_connect("localhost", "root", "1234", "conferences");
30. /* check connection */
31. if (mysqli_connect_errno()) {
32.     printf("Connect failed: %s\n", mysqli_connect_error());
33.     exit();
34. }
36. $conf_name=$argv[1];
37. $duration=$argv[2];
38. $cid=$argv[3];
39. $path="/var/www/html/conference/$argv[4]";
40. $query = "INSERT INTO  `conferences`.`recordings` (
41. `id` ,
42. `path` ,
43. `conference_name` ,
44. `duration` ,
45. `callerid` ,
46. `date` ,
47. `reserved1` ,
48. `reserved2`
49. )
50. VALUES (
51. NULL ,  '$path',  '$conf_name',  '$duration',  '$cid',
52. CURRENT_TIMESTAMP , NULL , NULL
53. )";
54. if(mysqli_query($link, $query)) {
56. printf(mysqli_insert_id($link));
57. exit();
58. }
60. else {
62.  printf("Error: %s\n", mysqli_error($link));
64. }
65. /* close connection */
66. mysqli_close($link);
67. ?>
68. Creating table

CREATE TABLE IF NOT EXISTS `recordings` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `path` varchar(150) DEFAULT NULL,

  `conference_name` varchar(20) NOT NULL,

  `duration` varchar(10) NOT NULL,

  `callerid` varchar(20) DEFAULT NULL,

  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `reserved1` varchar(20) DEFAULT NULL,

  `reserved2` varchar(20) DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `id` (`id`,`conference_name`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

RAW Paste Data