prefix . 'author_chat'; $linesCount = $wpdb->get_var("SELECT COUNT(*) FROM $author_chat_table"); $log = $linesCount; break; case('getState'): global $wpdb; $author_chat_table = $wpdb->prefix . 'author_chat'; $newLinesCount = $wpdb->get_var("SELECT COUNT(*) FROM $author_chat_table"); $log = $newLinesCount; break; case('send'): $nickname = strip_tags(filter_var($_POST['nickname'], FILTER_SANITIZE_STRING)); $reg_exUrl = "/(http|https|ftp|ftps)\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/"; $message = strip_tags(filter_var($_POST['message'], FILTER_SANITIZE_STRING)); if(($message) != "\n"){ if(preg_match($reg_exUrl, $message, $url)) { $message = preg_replace($reg_exUrl, ''.$url[0].'', $message); } global $wpdb; $author_chat_table = $wpdb->prefix . 'author_chat'; $wpdb->query($wpdb->prepare( "INSERT INTO $author_chat_table (nickname, content, date) VALUES (%s, %s, NOW())", $nickname, $message )); } break; case('update'): global $wpdb; $author_chat_table = $wpdb->prefix . 'author_chat'; $lines = $wpdb->get_results("SELECT nickname, content, date FROM $author_chat_table ORDER BY id ASC", ARRAY_A); $text = array(); foreach ($lines as $line){ $text[] = $line; } $log = array_column($text, 'nickname'); $log2 = array_column($text, 'content'); $log3 = array_column($text, 'date'); array_walk_recursive($log3, function(&$element){ $element = strtotime($element); $element = date('j-m-Y <\s\p\a\n \i\d="\t\i\m\e">G:i:s', $element); }); break; case('initiate'): global $wpdb; $author_chat_table = $wpdb->prefix . 'author_chat'; $lines = $wpdb->get_results("SELECT nickname, content, date FROM $author_chat_table ORDER BY id ASC", ARRAY_A); $text = array(); foreach ($lines as $line){ $text[] = $line; } $log = array_column($text, 'nickname'); $log2 = array_column($text, 'content'); $log3 = array_column($text, 'date'); array_walk_recursive($log3, function(&$element){ $element = strtotime($element); $element = date('j-m-Y <\s\p\a\n \i\d="\t\i\m\e">G:i:s', $element); }); break; } if(isset($log2)){ echo wp_send_json(array('result1'=>$log, 'result2'=>$log2, 'result3'=>$log3)); }else{ echo wp_send_json($log); } } ?>