jobs is not crediting my users

boots · January 17, 2012

My job is not crediting my users,please help

1 hour cron

if(date('G')==17)
{
$db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY, u.exp=u.exp+(jr.jrPAY/20) 
WHERE u.job > 0 AND u.jobrank > 0");
$db->query("UPDATE userstats us LEFT JOIN users u ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET us.strength=(us.strength+1)+jr.jrSTRG-1,us.labour=(us.labour+1)+jr.jrLABOURG-1,us.IQ=(us.IQ+1)+jr.jrIQG-1 WHERE u.job > 0 AND u.jobrank > 0");
}
if($set['validate_period'] == 60 && $set['validate_on'])
{
$db->query("UPDATE users SET verified=0");
}
?>

i have ran manual cron no errors

job.php

<?php

$jobquery=1;
include "globals.php";
$_GET['interview'] = 
isset($_GET['interview']) && 
is_string($_GET['interview']) && 
preg_match("`^\d+$`ims", $_GET['interview']) ? 
@intval($_GET['interview']) : 0;

if(!$ir['job'])
{
if(!$_GET['interview'])
{
print "


<div class='generalinfo_txt'>
<div><img src='images/info_left.jpg' alt='' /></div>
<div class='info_mid'><h2 style='padding-top:10px;'> Job Central </h2></div>
<div><img src='images/info_right.jpg' alt='' /></div> </div>
<div class='generalinfo_simple'><br> <br><br>


<font size='2'>NOTE:If any of the 'Req' fields are <font color=green>Green</font> it means that you have reached the required stat you need.<br/>
However if any of the 'Req' fields are <font color=red>Red</font> it means that you need to more training on that particular stat.</font>
<br/><Br/>
Hi, looks like you don't have a job yet, here are the jobs you can get.<br /><br/>
<table width='100%' class='table' border='1'>
<Tr background='theader.gif'>
<th background='theader.gif'>Job Name</th>
<th background='theader.gif'>Job Desc</th>
<th background='theader.gif'>Req Strength</th>
<th background='theader.gif'>Req Labour</th>
<th background='theader.gif'>Req IQ</th>
<th background='theader.gif'>Get</th>
</tr>";
$q=$db->query("SELECT j.*,jr.* FROM jobs j LEFT JOIN jobranks jr ON j.jFIRST = jr.jrID");
while($r=$db->fetch_row($q))
{
print "<tr bgcolor='black'>
<td>{$r['jNAME']}</td>
<td>{$r['jDESC']}</td><td>";
if($ir['strength'] < $r['jrSTRN'])
{
print "<font color=red>{$r['jrSTRN']}</font>";
}
else 
{
print "<font color=green>{$r['jrSTRN']}</font>";
}
echo "</td><td>";
if($ir['labour'] < $r['jrLABOURN'])
{
print "<font color=red>{$r['jrLABOURN']}</font>";
}
else 
{
print "<font color=green>{$r['jrLABOURN']}</font>";
}
echo "</td><td>";
if($ir['IQ'] < $r['jrIQN'])
{
print "<font color=red>{$r['jrIQN']}</font>";
}
else 
{
print "<font color=green>{$r['jrIQN']}</font>";
}
echo "</td>
<td><a href='job.php?interview={$r['jID']}'>Get Job</a></td>
</tr>
";
}
print " </table></div><div><img src='images/generalinfo_btm.jpg' alt='' /></div><br></div></div></div></div></div> ";
}
else
{
$q=$db->query("SELECT j.*,jr.* FROM jobs j LEFT JOIN jobranks jr ON j.jFIRST = jr.jrID WHERE j.jID={$_GET['interview']}");
$r=$db->fetch_row($q);
if($ir['strength'] >= $r['jrSTRN'] && $ir['labour'] >= $r['jrLABOURN'] && $ir['IQ'] >= $r['jrIQN'])
{
$db->query("UPDATE users SET job={$_GET['interview']},jobrank={$r['jrID']} WHERE userid=$userid;");
print "<font color=green><b>

<div id='mainOutput' style='text-align: center; color: green;  width: 600px; border: 1px solid #222222; height: 70px;
                       margin: 0 auto 10px; clear: both; position: relative; left: -20px; padding: 8px'>

Congratulations you got the job!</div></div><br/>
<a href='job.php'><u>Go To Your Job</u></a>";
}
else
{
print "
          <div id='mainOutput' style='text-align: center; color: green;  width: 600px; border: 1px solid #222222; height: 70px;
                       margin: 0 auto 10px; clear: both; position: relative; left: -20px; padding: 8px'>

                       <font color=red> Sorry but you are not good enough to get this job, you need:




";
if($ir['strength'] < $r['jrSTRN'])
{
$s=$r['jrSTRN']-$ir['strength'];
print " $s more Strength,";
}
if($ir['labour'] < $r['jrLABOURN'])
{
$s=$r['jrLABOURN']-$ir['labour'];
print " $s more Labour,";
}
if($ir['IQ'] < $r['jrIQN'])
{
$s=$r['jrIQN']-$ir['IQ'];
print " $s more IQ, ";
}
print "to get the job.</div></div> 
<a href='job.php'><u>Back</u></a>  ";
}
}
}
else
{
switch($_GET['action'])
{
case 'quit':
quit_job();
break;

case 'promote':
job_promote();
break;

default:
job_index();
break;
}
}
function job_index()
{
global $db, $ir,$c,$userid,$h;
print "

<div class='generalinfo_txt'>
<div><img src='images/info_left.jpg' alt='' /></div>
<div class='info_mid'><h2 style='padding-top:10px;'> Job Central </h2></div>
<div><img src='images/info_right.jpg' alt='' /></div> </div>
<div class='generalinfo_simple'><br> <br><br>


You currently work in the {$ir['jNAME']}! You receive \${$ir['jrPAY']} each day at 5pm!<br />
You also receive {$ir['jrIQG']} IQ, {$ir['jrSTRG']} strength, and {$ir['jrLABOURG']} labour!<br /><br>
<table width=50% cellspacing=1 class='table'><tr><td>Strength: {$ir['strength']}</td><td>IQ: {$ir['IQ']}</td></tr><tr><td>Labour: {$ir['labour']}</td><td>Job Rank: {$ir['jrNAME']}</td></tr></table>
<br><b>Job Ranks</b><br />
<table width=75% cellspacing=1 class='table'><tr style='background:gray'><th>Title</th><th>Pay</th><th>Strength Reqd</th><th>IQ Reqd</th><th>Labour Reqd</th></tr>";
$q=$db->query("SELECT * FROM jobranks WHERE jrJOB={$ir['job']} ORDER BY jrPAY ASC;");
while($r=$db->fetch_row($q))
{
print "<tr><td>{$r['jrNAME']}</td><td>\${$r['jrPAY']}</td><td>{$r['jrSTRN']}</td><td>{$r['jrIQN']}</td><td>{$r['jrLABOURN']}</td></tr>";
}
print "</table><br/><b><a href='job.php?action=promote'>Try To Get Promoted</a></b> |
<b><a href='job.php?action=quit'>Quit Job</a></b></div><div><img src='images/generalinfo_btm.jpg' alt='' /></div><br></div></div></div></div></div><br />
";
}

function job_promote()
{
global $db,$ir,$c,$userid,$h;
$q=$db->query("SELECT * FROM jobranks WHERE jrPAY > {$ir['jrPAY']} AND jrSTRN <= {$ir['strength']} AND jrLABOURN <= {$ir['labour']} AND jrIQN <= {$ir['IQ']} AND jrJOB = {$ir['job']} ORDER BY jrPAY DESC LIMIT 1");
if($db->num_rows($q) == 0)
{
print "

<div id='mainOutput' style='text-align: center; color: green;  width: 600px; border: 1px solid #222222; height: 70px;
margin: 0 auto 10px; clear: both; position: relative; left: -20px; padding: 8px'>

<font color=red>Sorry, you cannot be promoted at this time.</font> </div></div> <br />
<a href='job.php'><u>Back</a></a>";
}
else
{
$r=$db->fetch_row($q);
$db->query("UPDATE users SET jobrank={$r['jrID']} WHERE userid=$userid");
print "

<div id='mainOutput' style='text-align: center; color: green;  width: 600px; border: 1px solid #222222; height: 70px;
margin: 0 auto 10px; clear: both; position: relative; left: -20px; padding: 8px'>

Congrats, you have been promoted to {$r['jrNAME']}. </div></div> <br />
<a href='job.php'>Back</a>";
}
}
function quit_job()
{
global $db,$ir,$c,$userid,$h;
$db->query("UPDATE users SET job=0,jobrank=0 WHERE userid=$userid");
print "

<div id='mainOutput' style='text-align: center; color: green;  width: 600px; border: 1px solid #222222; height: 70px;
margin: 0 auto 10px; clear: both; position: relative; left: -20px; padding: 8px'>

You have quit your job!</div></div><br />
<a href='job.php'>Back</a>";
}
$h->endpage();
?>

read most of the posts on this forum but still cant fix

Edited January 17, 2012 by Dominion
added code tags

boots · January 19, 2012

I have tried many things to try and fix this but still no joy, so i have now made it work in the day cron without the, if(date('G')==17) still dont understand why it dont work in the hour cron ,my sever time is correct

Edited January 19, 2012 by boots

Sign In

jobs is not crediting my users

Recommended Posts

boots

Link to comment

Share on other sites

boots

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Hosting