{"id":294144,"date":"2019-09-02T09:00:25","date_gmt":"2019-09-02T09:00:25","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=294144"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=294144","title":{"rendered":"\u0422\u0435\u043b\u0435\u0444\u043e\u043d\u043d\u044b\u0439 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446 SQL Asterisk FreePBX (web-\u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a, \u0432\u044b\u0433\u0440\u0443\u0437\u043a\u0430 \u0432 xml-\u0444\u0430\u0439\u043b \u0434\u043b\u044f \u0442\u0435\u043b\u0435\u0444\u043e\u043d\u043e\u0432 Grandstream)"},"content":{"rendered":"\n
\u0414\u043b\u044f \u0438\u0437\u0443\u0447\u0435\u043d\u0438\u044f \u043c\u043e\u0433\u0443\u0442 \u043f\u0440\u0438\u0433\u043e\u0434\u0438\u0442\u044c\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b.<\/p>\n

1) \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u0441\u0435\u0440\u0432\u0435\u0440\u0443 SQL \u0434\u043b\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432:<\/p>\n

mysql -u freepbxuser -p \u043f\u043e\u0441\u043b\u0435 \u043d\u0430\u0436\u0430\u0442\u0438\u044f Enter \u0431\u0443\u0434\u0435\u0442 \u0437\u0430\u043f\u0440\u043e\u0448\u0435\u043d \u043f\u0430\u0440\u043e\u043b\u044c \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f.  \u041f\u043e\u0441\u043b\u0435 \u0432\u0432\u043e\u0434\u0430 \u043f\u0430\u0440\u043e\u043b\u044f \u0438 \u043d\u0430\u0436\u0430\u0442\u0438\u044f Enter, \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0432\u0435\u0434\u0435\u043d\u043e \u043f\u0440\u0438\u0433\u043b\u0430\u0448\u0435\u043d\u0438\u0435 MySQL: mysql>_ <\/code><\/pre>\n
  2) \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043a\u043e\u043c\u0430\u043d\u0434\u044b sql<\/p>\n
\u0412\u044b\u0432\u043e\u0434 \u0441\u043f\u0438\u0441\u043a\u0430 \u0438\u043c\u0435\u044e\u0449\u0438\u0445\u0441\u044f \u0431\u0430\u0437: SHOW DATABASES; \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0439 \u0431\u0430\u0437\u0435: USE dbtest; \u041f\u0440\u043e\u0441\u043c\u043e\u0442\u0440 \u0432\u0441\u0435\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0438\u0437 \u0431\u0430\u0437\u044b: SHOW tables; \u041f\u0440\u043e\u0441\u043c\u043e\u0442\u0440 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u044f \u043d\u0443\u0436\u043d\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b: SELECT * FROM page; \u041f\u0440\u043e\u0441\u043c\u043e\u0442\u0440 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b: DESCRIBE testtable; <\/code><\/pre>\n
<\/a>
  3) \u041f\u043e\u0434\u043b\u044e\u0447\u0435\u043d\u0438\u0435 \u043a sql \u0438\u0437 \u0432\u043d\u0435\u0448\u043d\u0435\u0439 \u0441\u0435\u0442\u0438:<\/p>\n
CREATE USER '\u0418\u041c\u042f-\u041d\u041e\u0412\u041e\u0413\u041e-\u041f\u041e\u041b\u042c\u0417\u041e\u0412\u0410\u0422\u0415\u041b\u042f'@'localhost' IDENTIFIED BY '!!!\u041f\u0410\u0420\u041e\u041b\u042c!!!'; GRANT ALL PRIVILEGES ON * . * TO '\u0418\u041c\u042f-\u041d\u041e\u0412\u041e\u0413\u041e-\u041f\u041e\u041b\u042c\u0417\u041e\u0412\u0410\u0422\u0415\u041b\u042f'@'localhost';  GRANT SELECT ON * . * TO '\u0418\u041c\u042f-\u041d\u041e\u0412\u041e\u0413\u041e-\u041f\u041e\u041b\u042c\u0417\u041e\u0412\u0410\u0422\u0415\u041b\u042f'@'localhost';  use mysql SELECT Host,User,Password FROM user;  UPDATE user SET Host='%' WHERE User='\u0418\u041c\u042f-\u041d\u041e\u0412\u041e\u0413\u041e-\u041f\u041e\u041b\u042c\u0417\u041e\u0412\u0410\u0422\u0415\u041b\u042f' AND Host='localhost'; FLUSH PRIVILEGES; <\/code><\/pre>\n
  4) \u0424\u043e\u0440\u043c\u0430\u0442 xml-\u0444\u0430\u0439\u043b\u0430:<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?> <AddressBook> \t<pbgroup> \t\t<id>70<\/id> \t\t<name>User Manager Group<\/name> \t<\/pbgroup> \t<Contact> \t\t<id>760<\/id> \t\t<FirstName>\u0418\u0432\u0430\u043d\u043e\u0432<\/FirstName> \t\t<LastName>\u0418\u0432\u0430\u043d<\/LastName> \t\t<Frequent>0<\/Frequent> \t\t<Phone type=\"Work\"> \t\t\t<phonenumber>101<\/phonenumber> \t\t\t<accountindex>1<\/accountindex> \t\t<\/Phone> \t\t<Group>70<\/Group> \t\t<Primary>0<\/Primary> \t<\/Contact> <\/AddressBook> <\/code><\/pre>\n
  \u0428\u0430\u0433 1. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 php-\u0441\u043a\u0440\u0438\u043f\u0442\u0430 \u0447\u0442\u0435\u043d\u0438\u044f sql-\u0442\u0430\u0431\u043b\u0438\u0446\u044b Asterisk \u0438 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f xml-\u0444\u0430\u0439\u043b\u0430<\/b><\/p>\n
  \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0434\u0432\u0430 \u0444\u0430\u0439\u043b\u0430 config.php \u0438 phonebook.php, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044f \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u044b\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b.<\/p>\n
  \u0424\u0430\u0439\u043b config.php<\/p>\n
<?php return array( \"db\" => \"mysql:host=localhost;dbname=asterisk\", \"pb_file_gs\" => \"\/var\/www\/html\/phonebook\/phonebook.xml\", \"username\" => \"freepbxuser\", \/\/Mysql login \"password\" => \"\u043f\u0430\u0440\u043e\u043b\u044c freepbxuser\", \/\/Mysql password \"options\" => array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8') ); <\/code><\/pre>\n
  \u0424\u0430\u0439\u043b phonebook.php<\/p>\n
<?php $config = include(\"db\/config.php\");  $db = new PDO($config[\"db\"], $config[\"username\"], $config[\"password\"], $config[\"options\"]);  \/\/ \u0414\u0435\u043b\u0430\u0435\u043c \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u043a\u043d\u0438\u0433\u0438 $sql = \"SELECT userman_users.username, userman_users.displayname, contactmanager_group_entries.groupid FROM asterisk.userman_users, asterisk.contactmanager_group_entries, asterisk.contactmanager_groups WHERE contactmanager_group_entries.user = userman_users.id AND contactmanager_group_entries.groupid = contactmanager_groups.id\";   \/\/ \u0414\u0435\u043b\u0430\u0435\u043c \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u043a\u043d\u0438\u0433\u0438 $sqlgrp = \"SELECT contactmanager_groups.name,contactmanager_groups.id FROM asterisk.contactmanager_groups\";  \/\/\u0413\u0440\u0443\u0437\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u043d\u043e\u043c\u0435\u0440\u0430\u043c\u0438 \u0438 \u0438\u043c\u0435\u043d\u0430\u043c\u0438 $q = $db->prepare($sql); $q->execute(); $rows = $q->fetchAll();  \/\/\u0413\u0440\u0443\u0437\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u0433\u0440\u0443\u043f\u043f\u0430\u043c\u0438 $q2 = $db->prepare($sqlgrp); $q2->execute(); $rows2 = $q2->fetchAll();  unlink($config[\"pb_file_gs\"]);  \/\/ \u0423\u0434\u0430\u043b\u0438\u043c \u0441\u0442\u0430\u0440\u044b\u0439 \u0444\u0430\u0439\u043b  $fp = fopen($config[\"pb_file_gs\"],\"w+\"); fputs($fp, '<?xml version=\"1.0\" encoding=\"UTF-8\"?><AddressBook>');  foreach($rows2 as $row) {         \/\/ \u041f\u0440\u043e\u0431\u0435\u0436\u0438\u043c \u043f\u043e \u0432\u0441\u0435\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c, \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0433\u0440\u0443\u043f\u043f\u044b fputs($fp,'<pbgroup>'); fputs($fp,'<id>'.$row['id'].'<\/id>'); fputs($fp,'<name>'.$row['name'].'<\/name>'); fputs($fp,'<\/pbgroup>'); }  foreach($rows as $row) {         \/\/ \u041f\u0440\u043e\u0431\u0435\u0436\u0438\u043c \u043f\u043e \u0432\u0441\u0435\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c, \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u0432 XML \u0444\u0430\u0439\u043b \u043d\u0443\u0436\u043d\u043e\u0433\u043e \u0432\u0438\u0434\u0430     if (strlen($row['username']) === 3) { \t\t$alln = $row['displayname']; \t\t\/\/if ($alln = '') #alln = $row['username']; \t\t$ln = strstr($alln, ' ', true); \t\t$fn = strstr($alln, ' ', false); \t\t$fn = trim($fn); \t\t$i++; \t\tfputs($fp, '<Contact> \t\t\t<id>'.$i.'<\/id> \t\t\t<FirstName>'.$ln.'<\/FirstName>                         <LastName>'.$fn.'<\/LastName>                         <Phone type=\"Work\">                                    <phonenumber>'.$row['username'].'<\/phonenumber>                                    <accountindex>1<\/accountindex>                         <\/Phone> \t\t\t\t\t\t<Group>' \t\t\t\t\t\t.$row['groupid'].\t\t\t\t\t\t \t\t\t\t\t\t'<\/Group>             <\/Contact>         '); \t} } fputs($fp,'<\/AddressBook>'); fclose($fp); ?> <\/code><\/pre>\n
  \u0428\u0430\u0433 2. \u041d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c \u0442\u0435\u043b\u0435\u0444\u043e\u043d Grandstream \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f \u0442\u0435\u043b\u0435\u0444\u043e\u043d\u043d\u043e\u0439 \u043a\u043d\u0438\u0433\u0438 \u0438\u0437 xml-\u0444\u0430\u0439\u043b\u0430<\/b><\/p>\n
  \u0412\u043d\u0438\u043c\u0430\u043d\u0438\u0435, \u0432\u0430\u0436\u043d\u043e \u043f\u0440\u0438 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435 \u00abPhonebook Management\u00bb \u043d\u0430 \u0442\u0435\u043b\u0435\u0444\u043e\u043d\u0435 Grandstream GXP16xx \u0432 \u043f\u043e\u043b\u0435 \u00ab\u041f\u0443\u0442\u044c \u043a \u0441\u0435\u0440\u0432\u0435\u0440\u0443 XML\u00bb (Phonebook XML Server Path) \u0443\u043a\u0430\u0437\u0430\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0443\u0442\u044c \u0431\u0435\u0437 \u0438\u043c\u0435\u043d\u0438 \u0444\u0430\u0439\u043b\u0430.<\/p>\n
    \n
  1. \u0412 \u043f\u043e\u043b\u0435 \u00abEnable Phonebook XML Download\u00bb \u0432\u044b\u0431\u0440\u0430\u0442\u044c \u00abEnabled, use HTTP\u00bb<\/li>\n
  2. \u0412 \u043f\u043e\u043b\u0435 \u00abPhonebook XML Server Path\u00bb \u0443\u043a\u0430\u0437\u0430\u0442\u044c \u043f\u0443\u0442\u044c \u043a \u0444\u0430\u0439\u043b\u0443 xml, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440: \u00ab192.168.0.220\/phonebook\u00bb<\/li>\n<\/ol>\n
      \u041e\u0441\u0442\u0430\u043b\u044c\u043d\u044b\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c \u043f\u043e \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044e.<\/p>\n
      \u0428\u0430\u0433 3. \u0421\u043e\u0437\u0434\u0430\u0435\u043c web-\u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a \u0442\u0435\u043b\u0435\u0444\u043e\u043d\u043d\u043e\u0439 \u043a\u043d\u0438\u0433\u0438<\/b><\/p>\n
      <\/p>\n
      \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u0430\u0439\u043b pb.php.<\/p>\n
      \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043c\u043e\u043c\u0435\u043d\u0442\u044b.<\/p>\n
      \n
    1. \u0421\u043d\u0430\u0447\u0430\u043b\u0430 \u0437\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u044c \u0438\u0437 xml-\u0444\u0430\u0439\u043b\u0430 \u0438 \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u044b \u043a\u043e\u043d\u0442\u0430\u043a\u0442\u043e\u0432<\/li>\n
    2. \u041e\u0431\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0442\u044c \u0432\u044b\u0431\u043e\u0440 \u0433\u0440\u0443\u043f\u043f\u044b \u0438 \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0430\u0442\u044c \u043a\u043e\u043d\u0442\u0430\u043a\u0442\u044b \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u043e\u0439 \u0433\u0440\u0443\u043f\u043f\u044b.<\/li>\n<\/ol>\n
        <\/p>\n
      \u0424\u0430\u0439\u043b config.php<\/b><\/p>\n
      \n
      <html>  <style> <!-- \/* \u043d\u0430\u0448\u0430 HTML \u0442\u0430\u0431\u043b\u0438\u0446\u0430 *\/ table.sort{ \tborder-spacing:0em; \tmargin-bottom:1em; \tmargin-top:1em }  \/* \u044f\u0447\u0435\u0439\u043a\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b *\/ table.sort td{ \tborder:1px solid #CCCCCC; \tpadding:0.3em 1em }  \/* \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043a\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b *\/ table.sort thead td{ \tcursor:pointer; \tcursor:hand; \tfont-weight:bold; \ttext-align:center; \tvertical-align:middle }      tbody tr:hover {     background: #999999; \/* \u0426\u0432\u0435\u0442 \u0444\u043e\u043d\u0430 \u043f\u0440\u0438 \u043d\u0430\u0432\u0435\u0434\u0435\u043d\u0438\u0438 *\/     color: #FFFFFF; \/* \u0426\u0432\u0435\u0442 \u0442\u0435\u043a\u0441\u0442\u0430 \u043f\u0440\u0438 \u043d\u0430\u0432\u0435\u0434\u0435\u043d\u0438\u0438 *\/    }   \/* \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a \u043e\u0442\u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0433\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u0430 *\/ table.sort thead td.curcol{ \tbackground-color:#999999; \tcolor:#FFFFFF } --> <\/style>  <script type=\"text\/javascript\">  initial_sort_id = 0; \/\/ \u043d\u043e\u043c\u0435\u0440 \u043d\u0430\u0447\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u043e\u0442\u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0433\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u0430, \u043d\u0430\u0447\u0438\u043d\u0430\u044f \u0441 \u043d\u0443\u043b\u044f initial_sort_up = 0; \/\/ 0 - \u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u0432\u043d\u0438\u0437, 1 - \u0432\u0432\u0435\u0440\u0445 var sort_case_sensitive = false; \/\/ \u0447\u0443\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0432\u0442\u044c \u043a \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0443 \u043f\u0440\u0438 \u0441\u043e\u0442\u0440\u0438\u0440\u043e\u0432\u043a\u0435  function _sort(a, b) { \tvar a = a[0]; \tvar b = b[0]; \tvar _a = (a + '').replace(\/,\/, '.'); \tvar _b = (b + '').replace(\/,\/, '.'); \tif (parseInt(_a) && parseInt(_b)) return sort_numbers(parseInt(_a), parseInt(_b)); \telse if (!sort_case_sensitive) return sort_insensitive(a, b); \telse return sort_sensitive(a, b); }  function sort_numbers(a, b) { \treturn a - b; }  function sort_insensitive(a, b) { \tvar anew = a.toLowerCase(); \tvar bnew = b.toLowerCase(); \tif (anew < bnew) return -1; \tif (anew > bnew) return 1; \treturn 0; }  function sort_sensitive(a, b) { \tif (a < b) return -1; \tif (a > b) return 1; \treturn 0; }  function getConcatenedTextContent(node) { \tvar _result = \"\"; \tif (node == null) { \t\treturn _result; \t} \tvar childrens = node.childNodes; \tvar i = 0; \twhile (i < childrens.length) { \t\tvar child = childrens.item(i); \t\tswitch (child.nodeType) { \t\t\tcase 1: \/\/ ELEMENT_NODE \t\t\tcase 5: \/\/ ENTITY_REFERENCE_NODE \t\t\t\t_result += getConcatenedTextContent(child); \t\t\t\tbreak; \t\t\tcase 3: \/\/ TEXT_NODE \t\t\tcase 2: \/\/ ATTRIBUTE_NODE \t\t\tcase 4: \/\/ CDATA_SECTION_NODE \t\t\t\t_result += child.nodeValue; \t\t\t\tbreak; \t\t\tcase 6: \/\/ ENTITY_NODE \t\t\tcase 7: \/\/ PROCESSING_INSTRUCTION_NODE \t\t\tcase 8: \/\/ COMMENT_NODE \t\t\tcase 9: \/\/ DOCUMENT_NODE \t\t\tcase 10: \/\/ DOCUMENT_TYPE_NODE \t\t\tcase 11: \/\/ DOCUMENT_FRAGMENT_NODE \t\t\tcase 12: \/\/ NOTATION_NODE \t\t\t\/\/ skip \t\t\tbreak; \t\t} \t\ti++; \t} \treturn _result; }  function sort(e) { \tvar el = window.event ? window.event.srcElement : e.currentTarget;  \twhile (el.tagName.toLowerCase() != \"td\") el = el.parentNode;  \tvar a = new Array(); \tvar name = el.lastChild.nodeValue; \tvar dad = el.parentNode; \tvar table = dad.parentNode.parentNode; \tvar up = table.up; \/\/ no set\/getAttribute!  \tvar node, arrow, curcol; \tfor (var i = 0; (node = dad.getElementsByTagName(\"td\").item(i)); i++) { \t\tif (node.lastChild.nodeValue == name){ \t\t\tcurcol = i; \t\t\tif (node.className == \"curcol\"){ \t\t\t\tarrow = node.firstChild; \t\t\t\ttable.up = Number(!up); \t\t\t}else{ \t\t\t\tnode.className = \"curcol\"; \t\t\t\tarrow = node.insertBefore(document.createElement(\"span\"),node.firstChild); \t\t\t        arrow.appendChild(document.createTextNode(\"\")); \t\t\t\ttable.up = 0; \t\t\t} \t\t\tarrow.innerHTML=((table.up==0)?\"\u2193\":\"\u2191\")+\"\u00a0\"; \t\t}else{ \t\t\tif (node.className == \"curcol\"){ \t\t\t\tnode.className = \"\"; \t\t\t\tif (node.firstChild) node.removeChild(node.firstChild); \t\t\t} \t\t} \t}  \tvar tbody = table.getElementsByTagName(\"tbody\").item(0); \tfor (var i = 0; (node = tbody.getElementsByTagName(\"tr\").item(i)); i++) { \t\ta[i] = new Array(); \t\ta[i][0] = getConcatenedTextContent(node.getElementsByTagName(\"td\").item(curcol)); \t\ta[i][1] = getConcatenedTextContent(node.getElementsByTagName(\"td\").item(1)); \t\ta[i][2] = getConcatenedTextContent(node.getElementsByTagName(\"td\").item(0)); \t\ta[i][3] = node; \t}  \ta.sort(_sort);  \tif (table.up) a.reverse();  \tfor (var i = 0; i < a.length; i++) { \t\ttbody.appendChild(a[i][3]); \t} }  function init(e) { \tif (!document.getElementsByTagName) return; \t \tif (document.createEvent) function click_elem(elem){ \t\tvar evt = document.createEvent(\"MouseEvents\"); \t\tevt.initMouseEvent(\"click\", false, false, window, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, elem); \t\telem.dispatchEvent(evt); \t}  \tfor (var j = 0; (thead = document.getElementsByTagName(\"thead\").item(j)); j++) { \t\tvar node; \t\tfor (var i = 0; (node = thead.getElementsByTagName(\"td\").item(i)); i++) { \t\t\tif (node.addEventListener) node.addEventListener(\"click\", sort, false); \t\t\telse if (node.attachEvent) node.attachEvent(\"onclick\", sort); \t\t\tnode.title = \"\u041d\u0430\u0436\u043c\u0438\u0442\u0435 \u043d\u0430 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a, \u0447\u0442\u043e\u0431\u044b \u043e\u0442\u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043a\u043e\u043b\u043e\u043d\u043a\u0443\"; \t\t} \t\tthead.parentNode.up = 0; \t\t \t\tif (typeof(initial_sort_id) != \"undefined\"){ \t\t\ttd_for_event = thead.getElementsByTagName(\"td\").item(initial_sort_id); \t\t\tif (td_for_event.dispatchEvent) click_elem(td_for_event); \t\t\telse if (td_for_event.fireEvent) td_for_event.fireEvent(\"onclick\"); \t\t\tif (typeof(initial_sort_up) != \"undefined\" && initial_sort_up){ \t\t\t\tif (td_for_event.dispatchEvent) click_elem(td_for_event); \t\t\t\telse if (td_for_event.fireEvent) td_for_event.fireEvent(\"onclick\"); \t\t\t} \t\t} \t} }  var root = window.addEventListener || window.attachEvent ? window : document.addEventListener ? document : null; if (root){ \tif (root.addEventListener) root.addEventListener(\"load\", init, false); \telse if (root.attachEvent) root.attachEvent(\"onload\", init); }  \t \/\/\u043f\u0435\u0440\u0435\u0434\u0430\u0447\u0430 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0439\t function getCookie(name) { \tvar cookie = \" \" + document.cookie; \tvar search = \" \" + name + \"=\"; \tvar setStr = null; \tvar offset = 0; \tvar end = 0; \tif (cookie.length > 0) { \t\toffset = cookie.indexOf(search); \t\tif (offset != -1) { \t\t\toffset += search.length; \t\t\tend = cookie.indexOf(\";\", offset) \t\t\tif (end == -1) { \t\t\t\tend = cookie.length; \t\t\t} \t\t\tsetStr = unescape(cookie.substring(offset, end)); \t\t} \t} \treturn(setStr); }  \/\/\u041e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u043d\u0430\u0436\u0430\u0442\u0438\u044f \u0432\u044b\u0431\u043e\u0440\u0430 \u0433\u0440\u0443\u043f\u043f\u044b function selectChanged() { \tvar sel = document.getElementById('myselect'); \tvar str = sel.selectedIndex+1 ? (sel.options[sel.selectedIndex].innerHTML) : '\u041d\u0438\u0447\u0435\u0433\u043e \u043d\u0435 \u0432\u044b\u0431\u0440\u0430\u043d\u043e'; \t \tdocument.cookie = \"sgrp=\"+str+\";\"; \t\/\/document.getElementById('nameslist').innerHTML = '<?php $hello = $_COOKIE[\"sgrp\"]; echo $hello; ?>'; \tlocation.reload(); } \t <\/script> \t \t <strong> <div style=\"text-align: center;\">\u0422\u0415\u041b\u0415\u0424\u041e\u041d\u041d\u042b\u0419 \u0421\u041f\u0420\u0410\u0412\u041e\u0427\u041d\u0418\u041a<\/div> <br> <\/strong>  <?php  $xml = simplexml_load_file('http:\/\/192.168.0.220\/phonebook\/phonebook.xml'); $conts_cnt = count($xml->Contact);  $grp_cnt = count($xml->pbgroup);  \/\/\u0417\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u0433\u0440\u0443\u043f\u043f \u0432 \u0441\u043f\u0438\u0441\u043e\u043a echo '<div id=\"groupslist\" style=\"width: 20%; float:left\"> \t<strong>\u0413\u0420\u0423\u041f\u041f\u042b:<\/strong> <br> <br> \t<select id=\"myselect\" size=\"20\" onchange=\"javascript:selectChanged();\">'; echo \"<option>\u0412\u0441\u0435<\/option>\"; for($ig = 0; $ig < $grp_cnt; $ig++) {         $Groups = $xml->pbgroup[$ig]; \t\tif ($Groups->name <> 'User Manager Group') echo \"<option>{$Groups->name}<\/option>\";     } echo \"<\/select> <\/div>\";  \/\/\u041e\u0442\u043e\u0431\u0440\u0430\u0436\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043a\u043e\u043d\u0442\u0430\u043a\u0442\u043e\u0432 echo '<div id=\"nameslist\" style=\"width: 80%; float:right\">'; echo \"<strong>{$_COOKIE['sgrp']}<\/strong>\"; echo \"<table class=sort align=center width=100%>\"; echo \"<thead>\"; echo \"<tr>\"; echo \"<td>\u0424\u0430\u043c\u0438\u043b\u0438\u044f<\/td>\"; echo \"<td>\u0418\u043c\u044f<\/td>\"; echo \"<td>\u041d\u043e\u043c\u0435\u0440<\/td>\"; \/\/echo \"<td>\u0413\u0440\u0443\u043f\u043f\u0430<\/td>\"; echo \"<\/tr>\"; echo \"<\/thead>\"; echo \"<tbody>\";  for($i = 0; $i < $conts_cnt; $i++) { \t$Contacts = $xml->Contact[$i];  \t$FirstName = $Contacts->FirstName; \t$LastName = $Contacts->LastName; \t$phonenumber = $Contacts->Phone->phonenumber;     echo \"<tr>\"; \tfor($ig = 0; $ig < $grp_cnt; $ig++) {         $Groups = $xml->pbgroup[$ig];         if (strcasecmp($Contacts->Group, $Groups->id) == 0) { \t\t\tif ($_COOKIE[\"sgrp\"] == trim($Groups->name)) {             \techo \"<td class=col1>{$FirstName}<\/td>\";     \t\t\techo \"<td class=col1>{$LastName}<\/td>\";     \t\t\techo \"<td class=col1>{$phonenumber}<\/td>\";\t\t\t \t\t\t\t\/\/echo \"<td class=col1>{$Groups->name}<\/td>\"; \t\t\t} else if (\"\u0412\u0441\u0435\" == $_COOKIE[\"sgrp\"]) {             \techo \"<td class=col1>{$FirstName}<\/td>\";     \t\t\techo \"<td class=col1>{$LastName}<\/td>\";     \t\t\techo \"<td class=col1>{$phonenumber}<\/td>\"; \t\t\t} \t\t}     }      echo \"<\/tr>\"; }     echo \"<\/tbody>\";     echo \"<\/table>\"; echo '<\/div>'; ?>  <\/html> <\/code><\/pre>\n
        <\/div>\n<\/div>\n<\/div>\n