Another simple solution...
In search box you must enter user name with first Capital leter, CaSe SeNsItIVe
for example: If you tipe john you will get no results, if you type John
you will get results.
This is very confusing for users, and you will have to explain searching in help,
but, as we know users do not read help, they think that your site is not working, and they go away.
Ther is no need for this, here is simple solution: ucfirst
in your eAuction.pl find
Code:$query = {
'end' => q|$close_time - $the_time < ($config{'soon_time'} * 3600)|,
'hot' => q|$#bids > $config{'hot_num'}|,
'new' => q|$the_time - $start_time < ($config{'new_time'} * 3600)|,
'min' => q|$firstbid[2] == 1|,
'reserve' => q|$reserve <= $lastbid[2]|,
'keyword' => q|$title =~ /$form{'searchstring'}/i or $desc =~ /$form{'searchstring'}/i|,
'username' => q|$firstbid[0] eq $form{'searchstring'}|,
'itemnumber' => q|$item =~ /$form{'searchstring'}/o|,
'price' => q|$lastbid[2] <= $form{'searchstring'}|,
'buyitnow' => q|$firstbid[3] > 0|,
'items' => q|$cat eq $form{'searchstring'}|
};
In the row 'username' => q|$firstbid[0] eq $form{'searchstring'}|
add ucfirst before $form{'searchstring'}
Now it shoud be like this
Code:
$query = {
'end' => q|$close_time - $the_time < ($config{'soon_time'} * 3600)|,
'hot' => q|$#bids > $config{'hot_num'}|,
'new' => q|$the_time - $start_time < ($config{'new_time'} * 3600)|,
'min' => q|$firstbid[2] == 1|,
'reserve' => q|$reserve <= $lastbid[2]|,
'keyword' => q|$title =~ /$form{'searchstring'}/i or $desc =~ /$form{'searchstring'}/i|,
'username' => q|$firstbid[0] eq ucfirst $form{'searchstring'}|,#line with added ucfirst
'itemnumber' => q|$item =~ /$form{'searchstring'}/o|,
'price' => q|$lastbid[2] <= $form{'searchstring'}|,
'buyitnow' => q|$firstbid[3] > 0|,
'items' => q|$cat eq $form{'searchstring'}|
};
that is it
now try to search by username...
Home
Pages: 1 
Another simple solution... (Read 82 times)
