function vc_search_handler() { vc_disable_caching(); $q = sanitize_text_field($_POST['query']); $user_id = get_current_user_id(); $block_usernames = get_option('vicichat_block_username_search', 'no'); global $wpdb; $post_ids = []; // --- USERNAME SEARCH LOGIC --- if (strpos($q, '@') === 0 && !preg_match('/[ +a-zA-Z0-9]@/', $q) && strpos($q, ' ') === false) { $pure_username = ltrim($q, '@'); if ($block_usernames === 'yes') { $user_exists = get_user_by('slug', $pure_username) || get_user_by('login', $pure_username); if ($user_exists) wp_send_json_error('My Gee Vicilook, searching specific usernames is restricted.'); } // Changed ID to ASC because array_reverse() is called later $sql_user = $wpdb->prepare( "SELECT p.ID FROM {$wpdb->posts} p LEFT JOIN {$wpdb->users} u ON p.post_author = u.ID WHERE p.post_status = 'publish' AND p.post_type = 'vicichats' AND (u.user_nicename = %s OR u.user_login = %s) ORDER BY p.ID ASC LIMIT 50", $pure_username, $pure_username ); $post_ids = $wpdb->get_col($sql_user); } // --- CONTENT TAG SEARCH LOGIC (STRICT RELEVANCE + PRIORITY) --- if (empty($post_ids)) { $standardized = str_replace('+', ' ', $q); $words = array_filter(explode(' ', $standardized)); $where_clauses = []; $search_terms = []; foreach ($words as $word) { $word = trim($word); if (empty($word)) continue; $clean_word = (substr(strtolower($word), -1) === 's') ? substr($word, 0, -1) : $word; $search_terms[] = $clean_word; $where_clauses[] = $wpdb->prepare("p.post_content LIKE %s", '%' . $wpdb->esc_like($clean_word) . '%'); } if (!empty($where_clauses)) { /** * THE FIX: * 1. Priority: Verified Vicilook URLs last in the initial list (Priority 2). * 2. Chronology: Oldest ID first (ID ASC). * 3. Result: After array_reverse(), the Latest Verified posts appear at the BOTTOM. */ $sql_content = "SELECT DISTINCT p.ID FROM {$wpdb->posts} p WHERE p.post_status = 'publish' AND p.post_type = 'vicichats' AND (" . implode(' AND ', $where_clauses) . ") ORDER BY CASE WHEN p.post_content LIKE '%vicilook.com/places%' THEN 2 ELSE 1 END ASC, p.ID ASC LIMIT 50"; $post_ids = $wpdb->get_col($sql_content); } } $results = []; if (!empty($post_ids)) { /** * CHAT-STYLE ORDERING: * Flips the priority group to the end and makes the newest IDs appear last. */ $post_ids = array_reverse($post_ids); foreach ($post_ids as $pid) { $post = get_post($pid); $author_id = $post->post_author; $likers = get_post_meta($pid, '_vici_heart_user_ids', true) ?: []; $user_liked = is_array($likers) && in_array($user_id, $likers); $results[] = [ 'user' => '@' . get_the_author_meta('user_nicename', $author_id), 'content' => (string)vicichat_format_content($post->post_content), 'time' => get_the_time('M j, Y g:i A', $pid), 'hearts' => (int)get_post_meta($pid, '_vici_heart_count', true) ?: 0, 'id' => $pid, 'user_liked' => $user_liked, 'can_delete' => vc_can_user_delete($post, $user_id) ]; } } wp_send_json_success(array_values($results)); } Vicinity Content
Showing 1 - 18 of 1,330
Dimma Homes Estate ServicesDimma Homes Estate Services
DIMMA HOMES REAL ESTATE SERVICES, NSUKKA
Mobil Filling Station, opposite Total Filling Station, 1 Enugu Rd,Nsukka, Enugu State, Nigeria
Our Work Hours
Mon-Sat, 9am-6pm
Asogwa OliverAsogwa Oliver
ASOBROS MULTI GLOBAL NIG. LTD. RC1348273, NSUKKA HEAD OFFICE
115 Urban Girls Road, Opposite Building Materials, Nsukka, Enugu State, Nigeria
Our Work Hours
Mon-Sat, 7:30am-6:00pm
Our Union or Cooperative

NZATA

Jude Chukwuma Ezugwu, EsqJude Chukwuma Ezugwu, Esq
ODA-OPUE & ASSOCIATES (ST. JUDE CHAMBERS) NSUKKA
Flat 4, Wisdom Arcade, No. 9 Urban Girls Road, Echara, Nsukka, Enugu State, Nigeria
Our Work Hours
Mon-Sat, 8am-5pm
Chamber’s Principal Counsel
Jude Chukwuma Ezugwu, Esq. ACIArb
Chamber’s Associate Counsels

David C. Omeke, Esq.
John O. Chukwu, Esq.
Gabriel Ikeogu, Esq.
C.C Okonkwo, Esq.

Tochukwu Nnaedozie OkwuchukwuTochukwu Nnaedozie Okwuchukwu
ALIVE UNTO GOD COLLEGE OF NURSING SCIENCES, OTOLO, NNEWI
Otolo, Nnewi, Anambra State, Nigeria
Our Work Hours
Mon-Fri, 8am-4pm
Chika Ijeoma AdeniyiChika Ijeoma Adeniyi
CETIKA DESIGNS, NSUKKA
113 Edem Rd, Nsukka, Enugu State, Nigeria
Our Work Hours
Mon-Sat, 7:30am-7:30pm
Unegbu Perpetual AdaugoUnegbu Perpetual Adaugo
SOLID GOLD COSMETICS AND MOTHER CARE STORES, AWKA
WE DO DELIVERIES
Shop A30, First Floor, De Signature Plaza, Awka, Anambra,
Our Work Hours
Mon-Sat, 8am-7pm
Vicilook NigeriaVicilook Nigeria
ADON DONAC RICE MILL, ANAKU
Anaku, Anambra, Nigeria
Our Work Hours
Mon-Sat, 8am-6pm
Vicilook AnambraVicilook Anambra
OUR SAVIOUR’S ANGLICAN CHURCH, OBIOFIA, IBOLO ORAIFITE
Obiofia, Ibollo Oraifite, Oraifite, Anambra, Nigeria
Diocese / Parish / Branch
Nnewi
Current Priests & Workers

LAYREADERS
.

1. Mr Simon Chukwuemeka

2. Mr Stephen Ilodibe

Boys Secondary School OraifiteBoys Secondary School Oraifite
BOYS’ SECONDARY SCHOOL ORAIFITE
Boys’ Secondary School, Oraifite, Anambra, Nigeria
Our Work Hours
Mon-Fri, 8am-4pm
Henry Nzubechukwu NdukaHenry Nzubechukwu Nduka
ST. MICHAEL AND ALL ANGELS ANGLICAN CHURCH, INYABA UMUDIM, NNEWI
St. Michael and all Angels' Anglican Church, Inyaba, Umudim, (Opposite Etiaba Event Centre), Nnewi, Anambra, Nigeria
Diocese / Parish / Branch
Umudim South Archdeaconry Headquarters
Current Priests & Workers

1. Mrs. Afam-Nkwoka (Clerk)
2. Bro. Chigbo Godwin (Sexton)

Vicilook Nsukka HubVicilook Nsukka Hub
OUTSTANDING SUPERMARKET, NSUKKA
Beside Oloto Junction, Odenigbo Road, Nsukka, Enugu, Nigeria
Our Work Hours
Mon-Sun, 8am-9pm
Vicilook Nsukka HubVicilook Nsukka Hub
DANDICO ART, OZUBULU
Amakwa, Ozubulu, Anambra, Nigeria
Our Work Hours
Tue-Sat, 8am-6pm
Ofortube KenechukwuOfortube Kenechukwu
TOPHILL VENTURES, GSM VILLA, NNEWI
Shop 16, Mandela Line, GSM Villa, Nnewi, Anambra
Our Work Hours
Tue-Sat, 7:30am-6pm
Emmanuel Ebuka UdechukwuEmmanuel Ebuka Udechukwu
iSMITH PHONES, NNEWI
NO 27, GOODLUCK LINE, GSM VILLA, NNEWI, ANAMBRA STATE, NIGERIA
Our Work Hours
Mon-Sat, 7:30am-5pm
Mmadubuko Chike EmmanuelMmadubuko Chike Emmanuel
EMMA GLOBAL COMMUNICATIONS, NNEWI
No Shop 23, Mandela line, Gsm Villa, Nnewi, Anambra, Nigeria
Our Work Hours
Tue-Sat, 7:30am-5:30pm
Chibuzor Eucharia Oge.Chibuzor Eucharia Oge.
ROYAL APPAREL BOUTIQUE, NNEWI
Shop 1, Kano Line, GSM Villa, Nkwo Nnewi, Nnewi, Anambra, Nigeria
Our Work Hours
Tue-Sat, 8am-5:30pm
Vicilook Nsukka HubVicilook Nsukka Hub
DE BURNA COMMUNICATION, NNEWI
Shop 2, Lagos Line, GSM Villa, Nkwo Nnewi, Nnewi, Anambra, Nigeria
Our Work Hours
Tue-Sat, 8am-6pm
Vicilook Nsukka HubVicilook Nsukka Hub
ABLE POINT AUTO NIGERIA, NKWO NNEWI
AW2/10 Agbo-Edo Market Nkwo Nnewi, Nnewi, Anambra, Nigeria
Our Work Hours
Tue-Sat, 7:30am-5:30am
Show Me More

 

TAP THE IMAGE BELOW TO SCAN A VICILOOK QRCODE

×