Joblite Upgrade Blog

Joblite now comes complete with a new streamlined admin interface making it much easier for you to control and manage your job board.

To view a example of this, please visit our demo software at http://www.onlinejobhunt.com/siteadmin
username: admin
password: demo

Joblite is now integrated with Google Translator. This will allow users to translate the Joblite software into their desired language on the fly. You do not need to add additional language packs and you do not need to spend time translating any files.

To view a example of this, please visit our demo software at http://www.onlinejobhunt.com/ and test the translator just below the top banner.

We have upgraded the job search function on the Joblite software to allow multiple keywords. Users can now search using multiple keywords which will make the job search function more easy to use and also more precise.

To view a example of this, please visit http://www.onlinejobhunt.com/ and test the search jobs function.

To upgrade this on your website simply replace the code on the following files:

results.php
results2.php
jobseekers/results.php
jobseekers/results2.php

Replace:

if (!empty($kw))
{
$sch[] = “(jobref like ‘%$kw%’ || country like ‘%$kw%’ || subcounty like ‘%$kw%’ || contract like ‘%$kw%’ || hour like ‘%$kw%’ || position like ‘%$kw%’ || category like ‘%$kw%’ || description like ‘%$kw%’ || salary like ‘%$kw%’)”;
}

With:

if (!empty($kw))
{
$pos = strpos($kw, ‘,’);
if ($pos === false)
{
$sch[] = “(jobref like ‘%$kw%’ || country like ‘%$kw%’ || subcounty like ‘%$kw%’ || subcity like ‘%$kw%’ || contract like ‘%$kw%’ || hour like ‘%$kw%’ || position like ‘%$kw%’ || category like ‘%$kw%’ || subcategory like ‘%$kw%’ || description like ‘%$kw%’ || salary like ‘%$kw%’)”;

}
else
{
$kwArr = explode(“,”,$kw);
for($k=0;$k<=sizeof($kwArr);$k++)
{
$sch[] = “(jobref like ‘%$kwArr[$k]%’ || country like ‘%$kwArr[$k]%’ || subcounty like ‘%$kwArr[$k]%’ || subcity like ‘%$kwArr[$k]%’ || contract like ‘%$kwArr[$k]%’ || hour like ‘%$kwArr[$k]%’ || position like ‘%$kwArr[$k]%’ || category like ‘%$kwArr[$k]%’ || subcategory like ‘%$kwArr[$k]%’ || description like ‘%$kwArr[$k]%’ || salary like ‘%$kwArr[$k]%’)”;

}
}

}

If you have any problems with this, please email us at info@joblite.co.uk

If you wish to display a jobs counter by each category and location on your homepage, then this upgrade is for you.
To view a example of the counter, please see below:

To upgrade, simply modify the pages as below:

tab2/category.html

Change:

<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/category/<?=$string?>.html”><?=$aqm['category']?></a>

to

<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/category/<?=$string?>.html”><?=$aqm['category']?></a> (<?    $f = “SELECT jobid, COUNT(*) FROM jobs WHERE category like ‘%$aqm[category]%’ and status = ’0′ GROUP BY jobid”;$g = mysql_query($f) or die(mysql_error());$h = mysql_num_rows($g); $row2 = mysql_fetch_row($g); echo “$h”; ?>)

tab2/location.html

Change:

<td height=”5″ width=”30%” valign=”middle”><?
$string = “$aqm[country]“;
$string = str_replace (” “, “_”, $string);

$string = strtolower($string);
?>
<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/location/<?=$string?>.html”><b><?=$aqm['country']?></b></a><br><table cellpadding=”1″ cellspacing=”1″ width=”100%”><?$i2 = -1;$qm2 = “select * from subcounties where toplevelcountry = ‘$aqm[country]‘ order by subcounty”;$rqm2 = mysql_query($qm2) or die(mysql_error());while($aqm2=mysql_fetch_array($rqm2)){$i2++;if($i2/3 == intval($i2/3)){?><tr><?}?><td height=”5″ width=”30%” valign=”middle” onMouseOver=this.style.backgroundColor=’#DDDDDD’ onMouseOut=this.style.backgroundColor=’#FFFFFF’><?
$string2 = “$aqm2[subcounty]“;
$string2 = str_replace (” “, “_”, $string2);

$string2 = strtolower($string2);
?>
<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/2_all/<?=$string?>/<?=$string2?>.html”><?=$aqm2['subcounty']?></a><br></td><?if(($i2+1)/3 == intval(($i2+1)/3)){?></tr><?}}?></table><br></td>

to

<td height=”5″ width=”30%” valign=”middle”><?
$string = “$aqm[country]“;
$string = str_replace (” “, “_”, $string);

$string = strtolower($string);
?>
<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/location/<?=$string?>.html”><b><?=$aqm['country']?></b></a> (<?    $f = “SELECT jobid, COUNT(*) FROM jobs WHERE country like ‘%$aqm[country]%’ and status = ’0′ GROUP BY jobid”;$g = mysql_query($f) or die(mysql_error());$h = mysql_num_rows($g); $row2 = mysql_fetch_row($g); echo “$h”; ?>)<br><table cellpadding=”1″ cellspacing=”1″ width=”100%”><?$i2 = -1;$qm2 = “select * from subcounties where toplevelcountry = ‘$aqm[country]‘ order by subcounty”;$rqm2 = mysql_query($qm2) or die(mysql_error());while($aqm2=mysql_fetch_array($rqm2)){$i2++;if($i2/3 == intval($i2/3)){?><tr><?}?><td height=”5″ width=”30%” valign=”middle” onMouseOver=this.style.backgroundColor=’#DDDDDD’ onMouseOut=this.style.backgroundColor=’#FFFFFF’><?
$string2 = “$aqm2[subcounty]“;
$string2 = str_replace (” “, “_”, $string2);

$string2 = strtolower($string2);
?>
<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/2_all/<?=$string?>/<?=$string2?>.html”><?=$aqm2['subcounty']?></a> (<?    $f = “SELECT jobid, COUNT(*) FROM jobs WHERE subcounty like ‘%$aqm2[subcounty]%’ and status = ’0′ GROUP BY jobid”;$g = mysql_query($f) or die(mysql_error());$h = mysql_num_rows($g); $row2 = mysql_fetch_row($g); echo “$h”; ?>)<br></td><?if(($i2+1)/3 == intval(($i2+1)/3)){?></tr><?}}?></table><br></td>

tab2/tab.php

Change:

<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/category/<?=$string?>.html”><?=$aqm['category']?></a>

to

<img src=’images/l1.png’ border=’0′ /> <a href=”<?=$fullurl?>/category/<?=$string?>.html”><?=$aqm['category']?></a> (<?    $f = “SELECT jobid, COUNT(*) FROM jobs WHERE category like ‘%$aqm[category]%’ and status = ’0′ GROUP BY jobid”;$g = mysql_query($f) or die(mysql_error());$h = mysql_num_rows($g); $row2 = mysql_fetch_row($g); echo “$h”; ?>)

If you have further queries regarding this issue, please email us at info@joblite.co.uk

Joblite is now compatible with most third party multi job posting services: The new multi post plugin will enable your job board to be compatible with the following multi job posting services and applicant tracking services:

Multi Post Plugin
Purchase Price: £125

To purchase, please contact us via the Joblite Contact Form