| 1 |
<?php |
| 2 |
$SQL_FROM = $wpdb->users; |
| 3 |
$SQL_WHERE = 'display_name'; |
| 4 |
$searchq = stripslashes($_GET['q']); |
| 5 |
$search = '%'.$searchq.'%'; |
| 6 |
$getRecord_sql = $wpdb->prepare("SELECT ID,user_login,display_name FROM {$SQL_FROM} WHERE {$SQL_WHERE} LIKE %s LIMIT 5",$search); |
| 7 |
$rows = $wpdb->get_results($getRecord_sql); |
| 8 |
if(strlen($searchq)>0) |
| 9 |
{ |
| 10 |
echo "<ul>"; |
| 11 |
if ($wpdb->num_rows) |
| 12 |
{ |
| 13 |
foreach($rows as $row) |
| 14 |
{ |
| 15 |
if($row->ID != $user_ID) //Don't let users message themselves |
| 16 |
{ |
| 17 |
|
| 18 |
?> |
| 19 |
<li><a href="#" onClick="fepfillText('<?php echo $row->user_login; ?>','<?php echo $row->display_name; ?>');return false;"><?php echo $row->display_name; ?></a></li> |
| 20 |
<?php |
| 21 |
|
| 22 |
} |
| 23 |
} |
| 24 |
} |
| 25 |
else |
| 26 |
echo "<li>".__("No Matches Found", "cartpaujpm")."</li>"; |
| 27 |
echo "</ul>"; |
| 28 |
} |
| 29 |
die(); |
| 30 |
?> |