{"id":307500,"date":"2020-07-26T09:00:26","date_gmt":"2020-07-26T09:00:26","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=307500"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=307500","title":{"rendered":"\u041a\u0430\u043a \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u043f\u0440\u043e\u0441\u0442\u0443\u044e \u0421\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u0443\u044e \u0441\u0435\u0442\u044c"},"content":{"rendered":"\n

\u0412 \u043c\u043e\u0435\u0439 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u044b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438:
\u2014 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0441\u0432\u043e\u0438\u0445 HTML \u0430\u043d\u043a\u0435\u0442;
\u2014 \u043e\u0431\u043c\u0435\u043d \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f\u043c\u0438, \u0444\u043e\u0442\u043e, \u0430\u0443\u0434\u0438\u043e \u0438 \u0432\u0438\u0434\u0435\u043e;
\u2014 \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0439 \u043f\u043b\u0435\u0435\u0440 \u043e\u0431\u043b\u0430\u0447\u043d\u043e\u0433\u043e \u0430\u0443\u0434\u0438\u043e;
\u2014 \u0447\u0430\u0442 \u043a\u043e\u043c\u043d\u0430\u0442\u044b \u0434\u043b\u044f \u043e\u0431\u0449\u0435\u043d\u0438\u044f;
\u2014 \u0438\u0433\u0440\u0430 \u0432 \u0441\u0438\u043c\u043f\u0430\u0442\u0438\u0438.
<\/a>
\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u043c\u043d\u043e\u044e \u0431\u044b\u043b \u043d\u0430\u043f\u0438\u0441\u0430\u043d API \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439:<\/p>\n
API \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u0430<\/b> <\/p>\n
var svlaboratoryBaseUrl = \u00absvlaboratory.org<\/a>\u00bb;<\/p>\n

var addProfileUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/addprofile";
\u2014 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0444\u0438\u043b\u044f \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445;<\/p>\n

var loginProfileUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/profilelogin";
\u2014 \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f;<\/p>\n

var getFotosUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getfotos";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0432\u0441\u0435\u0445 \u0444\u0430\u0439\u043b\u043e\u0432 \u0430\u043d\u043a\u0435\u0442\u044b \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f (\u0444\u043e\u0442\u043e, \u0432\u0438\u0434\u0435\u043e, \u043c\u0443\u0437\u044b\u043a\u0438);<\/p>\n

var delFotoUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/deletefoto";
\u2014 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0444\u043e\u0442\u043e \u0438\u0437 \u0430\u043d\u043a\u0435\u0442\u044b;<\/p>\n

var selectFotoUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/selectfoto";
\u2014 \u0432\u044b\u0431\u043e\u0440 \u0444\u043e\u0442\u043e \u0434\u043b\u044f \u0433\u043b\u0430\u0432\u043d\u043e\u0433\u043e \u0444\u043e\u0442\u043e;<\/p>\n

var searchProfilesUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/searchprofiles";
\u2014 \u043f\u043e\u0438\u0441\u043a \u0430\u043d\u043a\u0435\u0442 \u043f\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430\u043c;<\/p>\n

var instaProfilesUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/instaprofiles";
\u2014 \u043f\u043e\u0438\u0441\u043a \u0430\u043d\u043a\u0435\u0442 \u043f\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430\u043c \u0438\u0437 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u043d\u043e\u0432\u044b\u0445 \u0444\u043e\u0442\u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439;<\/p>\n

var getAnketaUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getanketa";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u043e \u043f\u0440\u043e\u0444\u0438\u043b\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f;<\/p>\n

var sendProfileMsgUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/sendmsg";
\u2014 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f \u0434\u0440\u0443\u0433\u043e\u043c\u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e;<\/p>\n

var getAllProfileMsgsUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getallmsgs";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439;<\/p>\n

var getProfilesMsgsUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getprofilesmsgs";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u043e\u0442\u043f\u0440\u0430\u0432\u0438\u0432\u0448\u0438\u0445 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f;<\/p>\n

var updateProfileUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/updateprofile";
\u2014 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u043e\u0437\u0438\u0446\u0438\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0432 \u0441\u043f\u0438\u0441\u043a\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439;<\/p>\n

var visitProfilesUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getvisithistory";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439, \u043f\u0440\u043e\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0432\u0448\u0438\u0445 \u0430\u043d\u043a\u0435\u0442\u0443;<\/p>\n

var getSmallavatarUrl = svlaboratoryBaseUrl + ":8080\/file\/chatbotmin\/";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u043c\u0430\u043b\u0435\u043d\u044c\u043a\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u0438\u0437\u043e\u0431\u0440\u0430\u0436\u0435\u043d\u0438\u044f;<\/p>\n

var getImgUrl = svlaboratoryBaseUrl + ":8080\/file\/chatbotnorm\/";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u043e\u0431\u044b\u0447\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u0438\u0437\u043e\u0431\u0440\u0430\u0436\u0435\u043d\u0438\u044f;<\/p>\n

var getSmallavatarUrl2 = svlaboratoryBaseUrl + "\/application\/smallavatar?url=";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u043c\u0430\u043b\u0435\u043d\u044c\u043a\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u0430\u0432\u0430\u0442\u0430\u0440\u0430;<\/p>\n

var getLikeProfilesUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getlikeprofiles";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0434\u043b\u044f \u0438\u0433\u0440\u044b \u0432 \u0441\u0438\u043c\u043f\u0430\u0442\u0438\u0438;<\/p>\n

var likeProfileUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/likeprofile";
\u2014 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0438\u0442\u044c \u043f\u043b\u044e\u0441 \u0430\u043d\u043a\u0435\u0442\u044b;<\/p>\n

var getLikesUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getlikes";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0441\u043f\u0438\u0441\u043e\u043a \u0432\u0441\u0435\u0445 \u043f\u043b\u044e\u0441\u043e\u0432;<\/p>\n

var getModerProfilesUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getmoderprofiles";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u043f\u043e\u0434\u043b\u0435\u0436\u0430\u0449\u0438\u0445 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u043c\u043e\u0434\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u043c;<\/p>\n

var moderProfileUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/moderprofile";
\u2014 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u043c\u043e\u0434\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f;<\/p>\n

var getModerUrl = svlaboratoryBaseUrl + "\/admin\/chatbot\/getmoder";
\u2014 \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u043f\u0440\u043e\u0448\u0435\u0434\u0448\u0438\u0445 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443 \u043c\u043e\u0434\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u043c; <\/div>\n<\/p><\/div>\n

\u0418 \u0441\u043f\u0438\u0441\u043e\u043a \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0441 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\u043c\u0438: <\/p>\n

API \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439<\/b> <\/p>\n
var getUserorder = svlaboratoryBaseUrl + "\/application\/getuserorder";
var getUserfromorderlist = svlaboratoryBaseUrl + "\/application\/getuserfromorderlist";
var getUsertoorderlist = svlaboratoryBaseUrl + "\/application\/getusertoorderlist";
var addUserorder = svlaboratoryBaseUrl + "\/application\/adduserorder";
var getUsermyorderlist = svlaboratoryBaseUrl + "\/application\/getusermyorderlist"; <\/div>\n<\/p><\/div>\n

API \u0431\u044b\u043b \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d \u043a\u0430\u043a \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u043a\u0430\u0440\u043a\u0430\u0441\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 Zend Framework.<\/p>\n

\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043a API \u0431\u044b\u043b\u0438 JSON \u0441\u0442\u0440\u043e\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n

$response = array(             "success" => true,             "complete" => true,             "data" => $data         ); echo json_encode($response); <\/code><\/pre>\n
  \u041a\u043b\u0438\u0435\u043d\u0442 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0431\u044b\u043b \u0441\u043e\u0437\u0434\u0430\u043d \u043a\u0430\u043a \u0435\u0434\u0438\u043d\u043e\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u043d\u0430 Bootstrap \u0438 JQuery.<\/p>\n
  \u0412\u0441\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f API \u0432\u044b\u0437\u044b\u0432\u0430\u043b\u0438\u0441\u044c \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b AJAX.<\/p>\n
  \u041f\u0440\u0438\u0432\u0435\u0434\u0443 \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u043e\u0431\u0440\u0430\u0437\u0446\u043e\u0432 \u043a\u043e\u0434\u0430 \u0434\u043b\u044f \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u0435\u043d\u0438\u044f CRUD \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439:
  \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u0430 \u043a\u0430\u043a \u0444\u0443\u043d\u043a\u0446\u0438\u044f sendProfileMsg \u043d\u0430 \u0441\u0442\u043e\u0440\u043e\u043d\u0435 \u043a\u043b\u0438\u0435\u043d\u0442\u0430 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 JS:<\/p>\n
function sendProfileMsg(text) { \tvar data = { \t\tuserid: anketaUserId, \t\tmsg: text \t}; \tdata["token"] = token; \t$.post(sendProfileMsgUrl, \t\tdata, \t\tfunction(data) { \t\t\tif (data.complete) { \t\t\t\tgetAllProfileMsgs(); \t\t\t} \t\t}, \t\t"json" \t); } <\/code><\/pre>\n
  \u0418 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043a \u0441\u0435\u0440\u0432\u0435\u0440\u0443 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 PHP \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c \u043a\u0430\u0440\u043a\u0430\u0441\u0430 Zend Framework<\/p>\n
public function sendmsgAction() {         header('Access-Control-Allow-Origin: http:\/\/svlaboratory.org:8080');         $this->_helper->layout->disableLayout();         $this->_helper->viewRenderer->setNoRender(true);         $userId = $this->_getParam('userid');         $msg = $this->_getParam('msg');         $authHelper = new Ext_Controller_Action_Helper_Auth();                  $token = $this->_getParam('token', null);         $ip = $_SERVER['REMOTE_ADDR'];         $myUserId = $authHelper->getUserId($token, $ip);                  $response = array(             "success" => true,             "complete" => true         );         $modelChat = new Model_Chat();                  $data = array(             "message" => $msg,             "user_id_from" => $myUserId,             "user_id_to" => $userId,         );                  $modelChat->save($data);         $this->notificateUser($userId, $myUserId);         echo json_encode($response);     } <\/code><\/pre>\n
  \u0414\u043b\u044f \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0442\u0443\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043b\u0441\u044f \u043a\u043b\u0430\u0441\u0441 Model<\/p>\n
class Ext_Model { protected $_dbAdapter;           \/**      *      * @var array      *\/     protected $_fields = array();     protected $_primaryKey = array();      \/**      *      * @var Zend_Db_Table_Abstract      *\/     protected $_dbTable = null;      \/**      *      * @var string      *\/     protected $_dbTableClass = null;      protected $_id=null;          public function getId()     {         return $this->_id;     }          public function setId($id)     {         $this->_id=$id;     }   public function save($data)     {         $insertId = null;                  $data = $this->_beforeSave($data);         \/\/ \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u0434\u043b\u044f \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0438\u0441\u0438         $cleanData = array();         $pk = array();         foreach ($this->_fields as $field) {             if (array_key_exists($field, $data)) {                 $cleanData[$field] = $data[$field];             }         }         foreach ($this->_primaryKey as $field => $value) {             if (isset($cleanData[$value])) {                 $pk[$value] = $cleanData[$value];             }         }          if (!empty($cleanData)) {             if (empty($pk)) {                 $insertId = $this->insert($cleanData);                 $data["id"] = $insertId;             } else {                 $this->update($pk, $cleanData);             }         }                 $this->_afterSave($data);         return $insertId;     }  public function update($id, $data)     {         $data = $this->_beforeUpdate($data);         $where = "";         foreach ($this->_primaryKey as $key => $values) {             if ($key > 0 and $key <= count($this->_primaryKey)) {                 $where .= ' and ';             }             $where .= "`$values`" . " = " . "$id[$values]";              unset($data[$values]);         }         $this->getDBTable()->update($data, $where);         $data=$id+$data;         $this->_afterUpdate($data);     }      public function insert($data)     {         $data = $this->_beforeInsert($data);         $this->getDBTable()->insert($data);         $this->setId($this->getDBTable()->getAdapter()->lastInsertId());         $this->_afterInsert($data);         return $this->getDBTable()->getAdapter()->lastInsertId();     }  public function fetchRowManyWhere($conditions = array())     {         $select = $this->getDBTable()->select();         $this->_beforeFetch($select);         foreach ($conditions as $field => $value) {             $select->where("`$field` = ?", $value);         }         $row = $this->getDBTable()->fetchRow($select);         if (!$row) {             return array();         }         return $row->toArray();     }      public function fetchAllManyWhere($conditions = array(), $limit = null, $offset = null, $order = null)     {         $select = $this->getDBTable()->select();         $this->_beforeFetch($select);         foreach ($conditions as $field => $value) {             $select->where("`$field` = ?", $value);         }                  if ($order !== null) {             $select->order($order);         }                  if ($limit !== null || $offset !== null) {             $select->limit($limit, $offset);         }                  $rows = $this->getDBTable()->fetchAll($select);         if (!$rows) {             return array();         }         return $rows->toArray();     }  public function delete($id)     {         $id=$this->_beforeDelete($id);         $this->getDBTable()->delete("id = " . (int) $id);         $this->_afterDelete($id);     }      public function deleteByAttrib($att, $value)     {         $select = $this->getDBTable()->select();         $where = $this->getDBTable()->getAdapter()->quoteInto("`$att` = ?", $value);         $this->getDBTable()->delete($where);     }  public function getDBTable()     {         if (!$this->_dbTable) {             if (!$this->_dbTableClass) {                 throw new Ext_Model_Exception('DB table class is not set');             }             $this->_dbTable = new $this->_dbTableClass;         }         return $this->_dbTable;     }  public function setDBTable(Zend_Db_Table_Abstract $table)     {         $this->_dbTable = $table;         return $this;     }          public function lastInsertId()     {         return $this->getDBTable()->getAdapter()->lastInsertId();     }          protected function _beforeFetch($select)     {      }          protected function _beforeSave($data)     {         return $data;     }     protected function _afterSave($data)     {         return $data;     }     protected function _beforeUpdate($data)     {         return $data;     }     protected function _afterUpdate($data)     {         return $data;     }     protected function _beforeInsert($data)     {         return $data;     }     protected function _afterInsert($data)     {         return $data;     }     protected function _beforeDelete($id)     {         return $id;     }     protected function _afterDelete($id)     {         return $id;     } } <\/code><\/pre>\n
  \u0414\u0440\u0443\u0433\u0438\u0435 \u043c\u0435\u0442\u043e\u0434\u044b \u0442\u0438\u043f\u0430 delete \u0438\u043b\u0438 fetchRow, find, fetchAll
  \u0440\u0435\u0430\u043b\u0438\u0437\u0443\u044e\u0442\u0441\u044f \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u0432\u043d\u0435\u0434\u0440\u044f\u044f \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u044b MySQL.
  \u041a\u043b\u0430\u0441\u0441 \u043c\u043e\u0434\u0435\u043b\u0438 \u0441 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439 \u0441 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 MySQL \u043d\u0430\u0441\u043b\u0435\u0434\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b MySQL:<\/p>\n
class Model_DbTable_Chat extends Zend_Db_Table_Abstract {     protected $_name = 'chat'; } <\/code><\/pre>\n
class Model_Chat extends Ext_Model {     protected $_dbTableClass = 'Model_DbTable_Chat';      protected $_fields = array( \t'id',         'message',         'description',         'user_id_from',         'user_id_to', \t'date',     );      protected $_primaryKey = array('id');          protected function _beforeInsert($data)     {         $data['date'] = date("Y-m-d H:i:s", time());         return $data;     }          public function fetchAllMsg($iser_id1, $iser_id2)     {         $select = $this->getDBTable()->select();         $this->_beforeFetch($select);                  $sql = "SELECT * FROM chatbotchat WHERE (user_id_from = :userid1 AND user_id_to = :userid2) OR (user_id_from = :userid2 AND user_id_to = :userid1) Order by date ASC";         $rows = $this->getDBTable()->getAdapter()->fetchAll($sql, array("userid1" => $iser_id1, "userid2" => $iser_id2));         if (!$rows) {             return array();         }         return $rows;     }          public function fetchReadAllMsg($iser_id1, $iser_id2)     {         $select = $this->getDBTable()->select();         $this->_beforeFetch($select);          $sql = "UPDATE chatbotchat SET is_read = 1 WHERE (user_id_from = :userid2 AND user_id_to = :userid1)";         $this->getDBTable()->getAdapter()->query($sql, array("userid1" => $iser_id1, "userid2" => $iser_id2));     }          public function fetchProfilesMsg($user_id)     {         $select = $this->getDBTable()->select();         $this->_beforeFetch($select);         $sql = "SELECT * FROM chatbotchat WHERE (user_id_from = :userid OR user_id_to = :userid) Order by date DESC";         $rows = $this->getDBTable()->getAdapter()->fetchAll($sql, array("userid" => $user_id));         if (!$rows) {             return array();         }         return $rows;     } } <\/code><\/pre>\n
  \u0414\u043b\u044f \u0432\u0432\u043e\u0434\u0430 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 \u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0444\u043e\u0440\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043b\u0441\u044f CSS \u043a\u0430\u0440\u043a\u0430\u0441\u0430 Bootstrap.
  \u0414\u043b\u044f \u0434\u0438\u043d\u0430\u043c\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0435\u043d\u0438\u044f \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043b\u0441\u044f JavaScript \u0438 JQuery.<\/p>\n
  \u0412 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 MySQL \u0431\u044b\u043b\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u044b \u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0438: 
  user 
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0438 \u0438\u0445 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432;<\/p>\n
  \u041a \u043f\u0440\u0438\u043c\u0435\u0440\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 user:<\/p>\n
-- ----------------------------------------------------- -- Table `svlab`.`user` -- ----------------------------------------------------- CREATE  TABLE IF NOT EXISTS `svlab`.`user` (   `id` INT   AUTO_INCREMENT ,   `first_name` VARCHAR(45) DEFAULT NULL,   `last_name` VARCHAR(200) DEFAULT NULL,   `nickname` VARCHAR(200) DEFAULT NULL,   `gender` VARCHAR(200) DEFAULT NULL,   `birth_date` DATETIME DEFAULT NULL,   `avatar_url` VARCHAR(200) DEFAULT NULL,   `min_avatar_url` VARCHAR(200) DEFAULT NULL,   `email` VARCHAR(45) NOT NULL,   `password` VARCHAR(45) DEFAULT "12345",   `password_recover` VARCHAR(15) DEFAULT NULL,   `country` VARCHAR(200) DEFAULT NULL,   `region` VARCHAR(200) DEFAULT NULL,   `city` VARCHAR(200) DEFAULT NULL,   `postal_code` VARCHAR(200) DEFAULT NULL,   `street` VARCHAR(200) DEFAULT NULL,   `house_number` VARCHAR(200) DEFAULT NULL,   `add_address_info` VARCHAR(200) DEFAULT NULL,   `site` VARCHAR(200) DEFAULT NULL,   `about_me_info` TEXT DEFAULT NULL,   `registration_date` DATETIME NOT NULL,   `comment_rating` FLOAT DEFAULT 0,   `comment_rating_pos` FLOAT DEFAULT 0,   `comment_rating_neg` FLOAT DEFAULT 0,   `white_ips` TEXT,    `is_active` TINYINT(1) DEFAULT false,   PRIMARY KEY (`id`) ,   UNIQUE INDEX `user_id_unique` (`id` ASC) ,   UNIQUE INDEX `user_email_unique` (`email` ASC)) ENGINE = InnoDB; <\/code><\/pre>\n
  profile
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0430\u043d\u043a\u0435\u0442 \u0438 \u0438\u0445 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432;<\/p>\n
  chat
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439;<\/p>\n
-- ----------------------------------------------------- -- Table `svlab`.`chat` -- ----------------------------------------------------- CREATE  TABLE IF NOT EXISTS `svlab`.`chat` (   `id` INT NOT NULL AUTO_INCREMENT,   `message` TEXT,   `user_id_from` INT NOT NULL,   `user_id_to` INT NOT NULL,   `date` DATETIME,   `is_read` TINYINT(1) DEFAULT false,   PRIMARY KEY (`id`),   UNIQUE INDEX `chatbotchat_id_unique` (`id` ASC)) ENGINE=MyISAM DEFAULT CHARSET=utf8; <\/code><\/pre>\n
  file
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0444\u0430\u0439\u043b\u043e\u0432;<\/p>\n
  foto
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0444\u043e\u0442\u043e;<\/p>\n
  like
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u043f\u043b\u044e\u0441\u043e\u0432;<\/p>\n
  token
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u043a\u043b\u044e\u0447\u0435\u0439 \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438;<\/p>\n
  moder
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u0430\u043d\u043a\u0435\u0442 \u043c\u043e\u0434\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u043c;<\/p>\n
  userorder
   \u2014 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f;<\/p>\n
  \u0422\u0430\u043a\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u043e\u0433\u043e \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0438 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u043a\u043b\u0438\u0435\u043d\u0442\u0430 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430 \u043b\u0435\u0433\u043a\u043e \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0431\u043e\u043b\u0435\u0435 \u043c\u0435\u043d\u0435\u0435 \u043e\u043f\u044b\u0442\u043d\u043e\u043c\u0443 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u0443 \u043e\u0441\u0432\u043e\u0438\u0432\u0448\u0435\u043c\u0443 \u043a\u043d\u0438\u0433\u0438 \u043f\u043e 
  CSS, HTML, JS, PHP, SQL.<\/p>\n
  \u041b\u0438\u0447\u043d\u044b\u0439 \u043f\u043b\u0435\u0435\u0440 \u0430\u0443\u0434\u0438\u043e \u0437\u0430\u0433\u0440\u0443\u0437\u043e\u043a \u0438 \u0447\u0430\u0442\u044b \u0431\u044b\u043b\u0438 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u044b \u043a\u0430\u043a \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0430\u0435\u043c\u044b\u0435 \u0432\u043e frame \u0442\u0435\u0433\u0435 \u043a\u043e\u0434\u0430 HTML \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u043a\u043b\u0438\u0435\u043d\u0442\u0430 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430.<\/p>\n
  \u0422\u0430\u043a\u0436\u0435 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u0430\u044f \u0441\u0435\u0442\u044c \u0438\u043c\u0435\u0435\u0442 \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u043c \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u043c \u0438 \u0438\u0433\u0440\u0430\u043c \u043c\u043e\u0435\u0433\u043e \u0430\u0432\u0442\u043e\u0440\u0441\u0442\u0432\u0430 \u0432\u043e \u0432\u043a\u043b\u0430\u0434\u043a\u0435 \u0438\u0433\u0440\u044b. \u041f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043b\u0435\u0433\u043a\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u0432\u043e\u0438 \u0438\u0433\u0440\u044b \u0437\u0430\u043f\u043e\u043b\u043d\u0438\u0432 \u0444\u043e\u0440\u043c\u0443 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u0438\u0433\u0440\u044b. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u043c \u043f\u043e\u043b\u0435\u043c \u044d\u0442\u043e\u0439 \u0444\u043e\u0440\u043c\u044b \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f URL WEB \u0430\u0434\u0440\u0435\u0441 \u043f\u0443\u0431\u043b\u0438\u043a\u0443\u0435\u043c\u043e\u0433\u043e \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0438\u043b\u0438 \u0438\u0433\u0440\u044b. \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0438\u043b\u0438 \u0438\u0433\u0440\u0430 \u0431\u0443\u0434\u0443\u0442 \u043f\u043e\u043a\u0430\u0437\u0430\u043d\u044b \u0432\u043e frame \u0442\u0435\u0433\u0435 HTML \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438.<\/p>\n
  \u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0433\u043e\u0442\u043e\u0432\u043e\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u043c\u043e\u0436\u043d\u043e \u043f\u043e \u0441\u0441\u044b\u043b\u043a\u0435:
  \u0421\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u0430\u044f \u0441\u0435\u0442\u044c \u041b\u044e\u0431\u043e\u0432\u044c SVLAB<\/a>
  \u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u0421\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u0438 \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u043e\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435<\/b> \u0442\u0443\u0442:
  http:\/\/svlaboratory.org\/blog\/blog-single\/articleid\/59<\/a>
  \u0438\u043b\u0438 \u043d\u0430 4PDA: \u0421\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u0430\u044f \u0441\u0435\u0442\u044c \u041b\u044e\u0431\u043e\u0432\u044c SVLAB<\/a><\/div>\n
 \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  https:\/\/habr.com\/ru\/post\/479558\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\n

  \u0412 \u043c\u043e\u0435\u0439 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u044b \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438:
   \u2014 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0441\u0432\u043e\u0438\u0445 HTML \u0430\u043d\u043a\u0435\u0442;
   \u2014 \u043e\u0431\u043c\u0435\u043d \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u044f\u043c\u0438, \u0444\u043e\u0442\u043e, \u0430\u0443\u0434\u0438\u043e \u0438 \u0432\u0438\u0434\u0435\u043e;
   \u2014 \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u044b\u0439 \u043f\u043b\u0435\u0435\u0440 \u043e\u0431\u043b\u0430\u0447\u043d\u043e\u0433\u043e \u0430\u0443\u0434\u0438\u043e;
   \u2014 \u0447\u0430\u0442 \u043a\u043e\u043c\u043d\u0430\u0442\u044b \u0434\u043b\u044f \u043e\u0431\u0449\u0435\u043d\u0438\u044f;
   \u2014 \u0438\u0433\u0440\u0430 \u0432 \u0441\u0438\u043c\u043f\u0430\u0442\u0438\u0438.  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-307500","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/307500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=307500"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/307500\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=307500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=307500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=307500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}