Jump to content
MakeWebGames

Jobs Not Working

LegendFTW

By LegendFTW
in Modification Support

 Share

Recommended Posts

LegendFTW Newbie

LegendFTW

Posted
Posted

sorry about this but its a vital part of a game to have jobs working so it is important i get this working. It doesnt give the stats and cash to people every day.

Cron Hour

<?php
include "config.php";
global $_CONFIG;
if($_GET['code'] != $_CONFIG['code']) { die(""); }
define("MONO_ON", 1);
require "class/class_db_{$_CONFIG['driver']}.php";
$db=new database;
$db->configure($_CONFIG['hostname'],
$_CONFIG['username'],
$_CONFIG['password'],
$_CONFIG['database'],
$_CONFIG['persistent']);
$db->connect();
$c=$db->connection_id;
$set=array();
$settq=$db->query("SELECT * FROM settings");
while($r=$db->fetch_row($settq))
{
$set[$r['conf_name']]=$r['conf_value'];
}
$db->query("UPDATE users SET smoking=smoking-2 WHERE smoking > 0");
$db->query("UPDATE gangs SET gangCHOURS=gangCHOURS-1 WHERE gangCRIME>0");
$q=$db->query("SELECT g.*,oc.* FROM gangs g LEFT JOIN orgcrimes oc ON g.gangCRIME=oc.ocID WHERE g.gangCRIME > 0 AND g.gangCHOURS = 0");
while($r=$db->fetch_row($q))
{
$suc=rand(0,1);
if($suc) {
$log=$r['ocSTARTTEXT'].$r['ocSUCCTEXT'];
$muny=(int) (rand($r['ocMINMONEY'],$r['ocMAXMONEY']));
$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
$db->query("UPDATE gangs SET gangMONEY=gangMONEY+$muny,gangCRIME=0 WHERE gangID={$r['gangID']}");
$db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'success', $muny, '{$r['ocNAME']}', unix_timestamp())");
$i=$db->insert_id();
$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}");
while($rm=$db->fetch_row($qm))
{
event_add($rm['userid'],"Your Gang's Organised Crime Succeeded. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}
}
else
{
$log=$r['ocSTARTTEXT'].$r['ocFAILTEXT'];
$muny=0;
$log=str_replace(array("{muny}","'"),array($muny,"''"),$log);
$db->query("UPDATE gangs SET gangCRIME=0 WHERE gangID={$r['gangID']}");
$db->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'failure', $muny, '{$r['ocNAME']}', unix_timestamp())");
$i=$db->insert_id();
$qm=$db->query("SELECT * FROM users WHERE gang={$r['gangID']}");
while($rm=$db->fetch_row($qm))
{
event_add($rm['userid'],"Your Gang's Organised Crime Failed. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}
}
}
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.jobpoints=u.jobpoints+jr.jrPOINTS, 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");
}

$stock=$db->query("SELECT * FROM stock",$c);
while($st=$db->fetch_row($stock))
{
$rand1=(int) rand(1,2);
$rand2=(int) rand(1,25);
if($rand1 == 1)
{
$db->query("UPDATE stock SET stCOST=stCOST+$rand2,stPERC='$rand2' WHERE stID={$st['stID']}",$c);
} 
else
{
$db->query("UPDATE stock SET stCOST=stCOST-$rand2,stPERC='-$rand2' WHERE stID={$st['stID']}",$c);
}
}
$db->query("UPDATE stock SET stCOST=0 WHERE stCOST<0",$c);
$db->query("DELETE FROM stock WHERE stCOST=0",$c); 
?>

 

Jobs

<?php
$jobquery=1;
include "globals.php";
$_GET['interview'] = abs((int) $_GET['interview']);
if(!$ir['job'])
{
if(!$_GET['interview'])
{
print "
You do not yet have a job. A list of jobs is available below.

";
$q=$db->query("SELECT * FROM jobs");
while($r=$db->fetch_row($q))
{
		print "> <font color=blue>{$r['jNAME']}</font> - <font color=green>{$r['jDESC']}</font> - [url='job.php?interview={$r[']<font color=red>Go to interview</font>[/url]
";
}
}
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);
print "{$r['jOWNER']}: So {$ir['username']}, you were looking for a job with us?

{$ir['username']}: Yes please!
";
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 "{$r['jOWNER']}: Okay {$ir['username']}, we're good to go, see you tomorrow.

{$ir['username']}: Thanks!

[url='job.php']:)[/url]";
}
else
{
print "{$r['jOWNER']}: Sorry {$ir['username']}, you're not far enough in the game to work in this job. You'll 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 "before you'll be able to work here!

[url='index.php']:'([/url]";
}
}
}
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 "<h3>Your Job</h3>
You currently work in the {$ir['jNAME']}! You receive \${$ir['jrPAY']} and {$ir['jrPOINTS']} Job Points each day at 5pm!

You also receive {$ir['jrIQG']} IQ, {$ir['jrSTRG']} strength, and {$ir['jrLABOURG']} labour!

<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><td>Job Points:{$ir['jrPOINTS']}</tr></table>
[b]Job Ranks[/b]

<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>";
}
$js=$db->query("SELECT * FROM jobspecials WHERE jsJOB={$ir['job']} ORDER BY jsID ASC;",$c);
print "[b]Specials unlocked:[/b]
<form action='specials.php' method='post'>
<table width=80% cellspacing=1 class='table'> <tr> <th><font color=red>Reward</font></th> <th><font color=red>Cost</font></th> <th><font color=red>Take</font></th></tr>";
if($db->num_rows($js) == 0)
{
print "<tr class='row$current_row'><td colspan=3>This Job has no Speacials</td></tr>";
$current_row = 1 - $current_row;
}
while($sp=$db->fetch_row($js))
{
print "<tr class='row$current_row'><td><font color=black>{$sp['jsNAME']}</td><td><font color=#FF0000>-{$sp['jsCOST']} Job Points</font></td><td><center><input type='radio' name='ID' value='{$sp['jsID']}' /></td></tr>";
$current_row = 1 - $current_row;
}
print "<tr>
<td colspan=3><div align=center><input type='submit' value='Purchase'></div></td>
</tr></table>

[url='job.php?action=promote']> Try To Get Promoted[/url]

[url='job.php?action=quit']> Quit[/url] 
</form>";
} 

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 "Sorry, you cannot be promoted at this time.

[url='job.php']> Back[/url]";
}
else
{
$r=$db->fetch_row($q);
$db->query("UPDATE users SET jobrank={$r['jrID']} WHERE userid=$userid");
print "Congrats, you have been promoted to {$r['jrNAME']}

[url='job.php']> Back[/url]";
}
}
function quit_job()
{
global $db,$ir,$c,$userid,$h;
$db->query("UPDATE users SET job=0,jobrank=0 WHERE userid=$userid");
print "You have quit your job!

[url='job.php']> Back[/url]";
}
$h->endpage();
?>

 

Cron day

<?php
include "config.php";
global $_CONFIG;
if($_GET['code'] != $_CONFIG['code']) { die(""); }
define("MONO_ON", 1);
require "class/class_db_{$_CONFIG['driver']}.php";
$db=new database;
$db->configure($_CONFIG['hostname'],
$_CONFIG['username'],
$_CONFIG['password'],
$_CONFIG['database'],
$_CONFIG['persistent']);
$db->connect();
$c=$db->connection_id;
$db->query("UPDATE fedjail set fed_days=fed_days-1");
$q=$db->query("SELECT * FROM fedjail WHERE fed_days=0");
$ids=array();
while($r=$db->fetch_row($q))
{
$ids[]=$r['fed_userid'];
}
if(count($ids) > 0)
{
$db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")");
}
$db->query("DELETE FROM fedjail WHERE fed_days=0");
$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0");
$db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0");
$db->query("UPDATE users SET reward_done=0");
$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0");
$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0");
$q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0");
while($r=$db->fetch_row($q))
{
$cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}");
$coud=$db->fetch_row($cd);
$userid=$r['userid'];
$db->query("INSERT INTO coursesdone VALUES({$r['userid']},{$r['course']})");
$upd="";
$ev="";
if($coud['crSTR'] > 0)
{
$upd.=",us.strength=us.strength+{$coud['crSTR']}";
$ev.=", {$coud['crSTR']} strength";
}
if($coud['crGUARD'] > 0)
{
$upd.=",us.guard=us.guard+{$coud['crGUARD']}";
$ev.=", {$coud['crGUARD']} guard";
}
if($coud['crLABOUR'] > 0)
{
$upd.=",us.labour=us.labour+{$coud['crLABOUR']}";
$ev.=", {$coud['crLABOUR']} labour";
}
if($coud['crAGIL'] > 0)
{
$upd.=",us.agility=us.agility+{$coud['crAGIL']}";
$ev.=", {$coud['crAGIL']} agility";
}
if($coud['crIQ'] > 0)
{
$upd.=",us.IQ=us.IQ+{$coud['crIQ']}";
$ev.=", {$coud['crIQ']} IQ";
}
$ev=substr($ev,1);
if ($upd) {
$db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid SET us.userid=us.userid $upd WHERE u.userid=$userid");
}
$db->query("INSERT INTO events VALUES('',$userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')");
}
$db->query("UPDATE users SET course=0 WHERE cdays=0");
$db->query("TRUNCATE TABLE votes;");
$db->query("UPDATE users SET fishing_aloud=20"); 
$db->query("UPDATE users SET rates=1");

$db->query("UPDATE `users` SET `money` = `money` - 250 WHERE `loan` > 0", $c);
mysql_query("UPDATE `farmmarket` SET `fm_daysleft` = `fm_daysleft` - '1'",$c);
mysql_query("DELETE FROM `farmmarket` WHERE `fm_daysleft` = '0'",$c);
//Drug Farm itself
mysql_query("UPDATE `farm_collection` SET `fc_age` = `fc_age` + '1'",$c);
mysql_query("UPDATE `drug_farm` SET `df_daysleft` = `df_daysleft` - '1'",$c);
$f=mysql_query("SELECT * FROM `vege_farm` WHERE `f_daysleft` = '0'",$c);
while($r=mysql_fetch_array($f))
{
mysql_query("INSERT INTO `farm_collection` (`fc_id`, `fc_drug`, `fc_user`, `fc_holding`, `fc_age`) VALUES ('NULL', '$r[f_drug]', '$r[f_user]', '0', '0');",$c);
}
mysql_query("DELETE * FROM `vege_farm` WHERE `f_daysleft` = '0'",$c);
$fo=fopen("jailshouts.txt","w");
fclose($fo);
$fo=fopen("hospitalshouts.txt","w");
fclose($fo);
?>
Uridium Rising Star

Uridium

Posted
Posted

Legend try running the Hour cron Manaually to see what Errors it gives.. if its a Cron problem it will always show errors..

Also on the jobs i Noticed you have jobspecials and not jobs unless this is a different data section

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...