Event ADD

[AlabamaHit]

Anyone know how to make it where the people in a gang gets an event when the gang does an organised crime...either sucess or failed? many many thanks in advance..........oh yeah......its on v2

[dementor]

Re: Event ADD

something something event add blah blah blah

check attackmug.php for a clue

:-D

[parelem]

Re: Event ADD

it's coded into the cron, but it doesn't seem to work.

[dementor]

Re: Event ADD

aint it in yourgang.php

?

[AlabamaHit]

Re: Event ADD

lol, no

[dementor]

Re: Event ADD

v 2 different then boi

cause is my yourgang.php

[AlabamaHit]

Re: Event ADD

anyway you can tell me how they have it worded?

[Wookard]

Re: Event ADD

Is there a trick to getting the OC Cron itself to work? This is what happens when a OC finishes..

oclog.php

incorrect usage of file

[parelem]

Re: Event ADD

bump

[Isomerizer]

Re: Event ADD

I'm using v1... These seem to work for me under success part of the oc cron..

 

$i=mysql_insert_id($c);
$qm=mysql_query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);
while($rm=mysql_fetch_array($qm))
{
event_add($rm['userid'],"Your Tribes's Organised Crime Succeeded. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}

 

Fail part:

 

$i=mysql_insert_id($c);
$qm=mysql_query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);
while($rm=mysql_fetch_array($qm))
{
event_add($rm['userid'],"Your Tribes's Organised Crime Failed. Go [url='oclog.php?ID=$i']here[/url] to view the details.",$c);
}

 

Don't know if it'll work for v2 though...

I think thats what you wanted? ^^

[parelem]

Re: Event ADD

i don't think the v2 OC cron works at all, but i'm not sure what's wrong with it

 

while($r=$db->fetch_row($settq))
{
$set[$r['conf_name']]=$r['conf_value'];
}
$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);
}
}
}

 

$i=mysql_insert_id($c);
$qm=mysql_query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);

 

was missing the $c, i'll add it and test.

[gurpreet]

Re: Event ADD

 

i don't think the v2 OC cron works at all, but i'm not sure what's wrong with it

 

while($r=$db->fetch_row($settq))
{
$set[$r['conf_name']]=$r['conf_value'];
}
$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);
}
}
}

 

$i=mysql_insert_id($c);
$qm=mysql_query("SELECT * FROM users WHERE gang={$r['gangID']}",$c);

 

was missing the $c, i'll add it and test.

Sorry to be a bit noobish but what file is this under?

[Isomerizer]

Re: Event ADD

It will be under your OC cron...

orgcrime.php ?

[gurpreet]

Re: Event ADD

I have no orgcrime.php. The only file starting with "o" I have got is oclog.php

[parelem]

Re: Event ADD

it goes in cron_hour.php

[gurpreet]

Re: Event ADD

Oh ok thanks a lot :)

[parelem]

Re: Event ADD

hmm...can't get it to work. any ideas, anyone?

[parelem]

Re: Event ADD

bump

[Isomerizer]

Re: Event ADD

In your cron file... Make sure your including the file with event_add() function in...

require "../../../../global_func.php";

Something like that ^?

[AlabamaHit]

Re: Event ADD

Not sure what you mean, lol..But I'm trying a bunch of stuff.

[redhead]

Re: Event ADD

Did anyone ever figure out what was happening with this?

[Ghetto]

Re: Event ADD

This should work:

 

$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))
{
$db->query("INSERT INTO events VALUES ('',{$rm['userid']},unix_timestamp(),'0',\"Your gang's Organised Crime Succeeded. Go [url='oclog.php?ID=$i']here[/url] to view the details.\")");
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$rm['userid']}");
}
}
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))
{
$db->query("INSERT INTO events VALUES ('',{$rm['userid']},unix_timestamp(),'0',\"Your gang's Organised Crime Failed. Go [url='oclog.php?ID=$i']here[/url] to view the details.\")");
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$rm['userid']}");
}
}
}

[toufail]

Re: Event ADD

 

$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))
{
$db->query("INSERT INTO events VALUES ('',{$rm['userid']},unix_timestamp(),'0',\"Your gang's Organised Crime Succeeded. Go [url='oclog.php?ID=$i']here[/url] to view the details.\")");
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$rm['userid']}");
}
}
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))
{
$db->query("INSERT INTO events VALUES ('',{$rm['userid']},unix_timestamp(),'0',\"Your gang's Organised Crime Failed. Go [url='oclog.php?ID=$i']here[/url] to view the details.\")");
$db->query("UPDATE users SET new_events=new_events+1 WHERE userid={$rm['userid']}");
}
}
}

 

any clue where thi sshould be