Sorry for that John but I?m waiting for the confirmation email from
http://www.jlmzone.com for a couple of hours, so I?ll post here
===========
First of all, thanks for such nice release. I liked the Mod very much.
I?m planing to use Jobs 1.9 on a production site but i?m a little apprehensive with the further versions, specially with the "resumes" feature.
Do You think that the upgrade process will be easy with any kind of update script?
Follows some considerations:
1. Missing language constant for the word "for" on the template file "jobs_item.html", here:
<{$submitter}>
for <{$company}>
2. After the install, I can?t get rid of the word " Per hour" on the price?s drop down menu . I can?t found it on the DB too.
3. It seems that the search fucnction can?t do a search on some desirable fields ( at least for me
) such:
a. job?s requirements
b. salary
c. contact information
d. localization (city, state....)
So in order to get those fields searchable I did a test to include the "requirements" field and It?s working pretty well:
In the "search_inc.php" file I?ve just included the "requirements" field like that(just in case someone could be interested too):
function jobs_search($queryarray, $andor, $limit, $offset, $userid){
global $xoopsDB;
$sql = "select lid,usid,title,date,requirements FROM ".$xoopsDB->prefix("jobs_listing")." WHERE valid='Yes' AND date<=".time()."";
if ( $userid != 0 ) {
$sql .= " AND usid=".$userid." ";
}
// because count() returns 1 even if a supplied variable
// is not an array, we must check if $querryarray is really an array
if ( is_array($queryarray) && $count = count($queryarray) ) {
$sql .= " AND ((description LIKE '%$queryarray[0]%' OR title LIKE '%$queryarray[0]%' OR requirements LIKE '%$queryarray[0]%')";
for($i=1;$i<$count;$i++){
$sql .= " $andor ";
$sql .= "(description LIKE '%$queryarray[$i]%' OR title LIKE '%$queryarray[$i]%' OR requirements LIKE '%$queryarray[$i]%')";
}
$sql .= ") ";
}
I guess i?ll include the others fields too.
Thanks for sharing that module
