'mysql:host=' . $config['db']['host'] . ';dbname=' . $config['db']['name'], 'user' => $config['db']['user'] , 'password' => $config['db']['password'] , 'cache' => 'temp/' , 'debugConsole' => $config['db']['debug'] ) ); $db -> query( 'SET NAMES utf8' ); $mdb = new medoo( [ 'database_type' => 'mysql', 'database_name' => $config['db']['name'], 'server' => $config['db']['host'], 'username' => $config['db']['user'], 'password' => $config['db']['password'], 'charset' => 'utf8' ] ); if ( \S::get( 'd4s-id' ) ) $mdb -> update( 'pro_rr_phrases', [ 'ds_ready' => 1 ], [ 'ds_id' => \S::get( 'd4s-id' ) ] ); // function _in_logit_POST( $id_message, $data ) { // @file_put_contents(__DIR__."/postback_url_example.log", PHP_EOL.date("Y-m-d H:i:s").": ".$id_message.PHP_EOL."---------".PHP_EOL.print_r($data, true).PHP_EOL."---------", FILE_APPEND); // } // $post_data_in = file_get_contents( 'php://input' ); // if ( !empty( $post_data_in ) ) // { // $post_arr = json_decode( $post_data_in, true ); // if ( ( !empty( $post_arr ) ) AND ( $post_arr["status"] == "ok" ) ) // { // foreach( $post_arr["results"]["organic"] as $tasks_row ) // { // $phrase_id = $mdb -> get( 'pro_rr_phrases', 'id', [ 'ds_id' => $tasks_row['task_id'] ] ); // if ( $mdb -> count( 'pro_rr_phrases_positions', [ 'AND' => [ 'phrase_id' => $phrase_id, 'date' => date( 'Y-m-d' ) ] ] ) ) // { // $mdb -> update( 'pro_rr_phrases_positions', [ // 'position' => (int)$tasks_row['result_position'], // ], [ // 'AND' => [ // 'phrase_id' => $phrase_id, // 'date' => date( 'Y-m-d' ) // ] // ] ); // } // else // { // $mdb -> insert( 'pro_rr_phrases_positions', [ // 'phrase_id' => $phrase_id, // 'position' => (int)$tasks_row['result_position'], // 'url' => $tasks_row['result_url'], // 'map' => 0, // 'date' => date( 'Y-m-d' ) // ] ); // $last_id = $mdb -> get( 'phrase_positions_statistic', 'id', [ 'phrase_id' => $phrase_id, 'ORDER' => [ 'date' => 'DESC' ] ] ); // if ( $last_id ) // $mdb -> query( 'DELETE FROM phrase_positions_statistic WHERE phrase_id = ' . $phrase_id . ' AND id NOT IN ( ' . $last_id . ' )' ); // $mdb -> insert( 'phrase_positions_statistic', [ // 'phrase_id' => $phrase_id, // 'position' => (int)$tasks_row['result_position'], // 'date' => date( 'Y-m-d' ) // ] ); // } // $mdb -> update( 'pro_rr_phrases', [ 'last_checked' => date( 'Y-m-d' ), 'filled_missing_positions' => 0, 'ds_id' => null ], [ 'id' => $phrase_id ] ); // } // echo "ok"; // } else { // echo "error"; // } // } else { // echo "empty POST"; // }