', strip_tags($ary_acquire_info_json['t'])); } $acquire_info_json = json_encode($ary_acquire_info_json, JSON_UNESCAPED_UNICODE); $ip = $_SERVER['REMOTE_ADDR'] ?? ''; $ua = $_SERVER['HTTP_USER_AGENT'] ?? ''; $ret = $wpdb->insert(self::TBL_LIBERAL_ACQUIRE , ['acquire_info_json'=>$acquire_info_json, 'sent'=>0, 'datetime'=>$now,'ip'=>$ip,'ua'=>$ua]); return $ret; } public static function fetch($id) { global$wpdb; $row = $wpdb->get_row('SELECT * FROM '.self::TBL_LIBERAL_ACQUIRE.' WHERE id='.$id); return $row; } public static function fetchTop5RowsWhichNeverSent() { return self::fetchBySent(0,5); } private static function fetchBySent($sent,$limit) { global$wpdb; $row = $wpdb->get_results('SELECT * FROM '.self::TBL_LIBERAL_ACQUIRE.' WHERE sent='.$sent.' ORDER BY `datetime` ASC LIMIT '.$limit); return $row; } public static function updateSent($id) { global$wpdb; return $wpdb->update(self::TBL_LIBERAL_ACQUIRE, ['sent'=>1], ['id'=>$id]); } }