Tonka

Re: [mccode v2] Ignore User Mail   i have fixed this problem, and updated the first post aswell $select = sprintf(("SELECT `blocked` FROM `ignore` WHERE userid = %u AND blocked = %u"), $userid, $_GET['ID']); $q = $db->query($select); $r=$db->fetch_row($q); if($r['blocked']) { echo "This person has choosen to ignore mails from you. [url='mailbox.php']> Back[/url]"; $h->endpage(); exit; }

Re: Race. Help! [*code]Your_Code_Here[*/code] without the *

Re: [review]www.lost-warzone.net   that's actually quite funny, there is also an error on the login page

Re: [showcase] CriminalImpulse.com Released! looks good

Re: [v2]Casino[v2] once you fix it up and recode a few things it works and looks nice

Re: Another New Mailbox well the real owner had lots of errors and i made it so that it wont get hacked if you made it so it won't get hacked where are all the secured queries? ialso have he original mailbox from the creator and the only errors were some spelling mistakes

Re: Help Needed (Crons) for my server i use * * * * * php -q (location_of_cron)

Re: [FREE][V2] Club Mod (my version) replace line 173 with this $_POST['ppointscrys'] = abs((int) $_POST['ppointscrys']); war hero missed a )

Re: GoldMember/In deperate need of a coder welcome to CE, i added you as well

Re: Cron Hour Gang Crimes i know that, i removed them before posting

Re: Cron Hour Gang Crimes   <?php include "removed"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } define("MONO_ON", 1); require "removed"; $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 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($set['validate_period'] == 60 && $set['validate_on']) { $db->query("UPDATE users SET verified=0"); } $db->disconnect(); ?>

Re: hey use a cron, here you go, set it to run whenever you want, hourly or daily,   <?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; if ($ir['rankxp'] > 1) { $db->query("UPDATE users SET rank='starter' WHERE userid=$userid"); } if ($ir['rankxp'] > 150) { $db->query("UPDATE users SET rank='Pickpocket' WHERE userid=$userid"); } if ($ir['rankxp'] > 400) { $db->query("UPDATE users SET rank='Criminal' WHERE userid=$userid"); } if ($ir['rankxp'] > 550) { $db->query("UPDATE users SET rank='Dealer' WHERE userid=$userid"); } if ($ir['rankxp'] > 700) { $db->query("UPDATE users SET rank='Thug' WHERE userid=$userid"); } if ($ir['rankxp'] > 1000) { $db->query("UPDATE users SET rank='Leader' WHERE userid=$userid"); } if ($ir['rankxp'] > 2500) { $db->query("UPDATE users SET rank='Con Artist' WHERE userid=$userid"); } if ($ir['rankxp'] > 5000) { $db->query("UPDATE users SET rank='Caporegime' WHERE userid=$userid"); } if ($ir['rankxp'] > 10000) { $db->query("UPDATE users SET rank='Hitman' WHERE userid=$userid"); } if ($ir['rankxp'] > 15000) { $db->query("UPDATE users SET rank='Crimelord' WHERE userid=$userid"); } if ($ir['rankxp'] > 32000) { $db->query("UPDATE users SET rank='Piciotto' WHERE userid=$userid"); } if ($ir['rankxp'] > 40000) { $db->query("UPDATE users SET rank='Contabile' WHERE userid=$userid"); } if ($ir['rankxp'] > 57000) { $db->query("UPDATE users SET rank='Boss' WHERE userid=$userid"); } if ($ir['rankxp'] > 65000) { $db->query("UPDATE users SET rank='Kingpin' WHERE userid=$userid"); } if ($ir['rankxp'] > 80000) { $db->query("UPDATE users SET rank='Consiglieri' WHERE userid=$userid"); } if ($ir['rankxp'] > 110000) { $db->query("UPDATE users SET rank='Godfather' WHERE userid=$userid"); } if ($ir['rankxp'] > 210000) { $db->query("UPDATE users SET rank='Don' WHERE userid=$userid"); } if ($ir['rankxp'] > 310000) { $db->query("UPDATE users SET rank='Legendary Godfather' WHERE userid=$userid"); } if ($ir['rankxp'] > 410000) { $db->query("UPDATE users SET rank='Legendary Don' WHERE userid=$userid"); } if ($ir['rankxp'] > 490000) { $db->query("UPDATE users SET rank='Untouchable Don' WHERE userid=$userid"); } $db->disconnect(); ?>

Re: Cron Hour Gang Crimes it was working for a bit, but it's stoped for some reason

my users are not getting event's that their gang crimes have failed or succeeded, here is the code from my cron hour   $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); } } }

Re: [V2] Ignore User Mail [V2] first post has been updated with the fix from iso's post

Re: [V2] Ignore User Mail [V2] thanks for that iso

Re: [V2] Ignore User Mail [V2]   thanks illusions for pointing that out, the edits are fine, it's becuase & #039 ; is replcaed by ' automatically by html as it's acsii code, i will post updated instructions on the first post

Re: Basic Stock Market [V2] find $q=$db->query("SELECT * FROM stock ORDER BY stID DESC",$c);   replace with $q=$db->query("SELECT * FROM stock ORDER BY stNAME ASC",$c);   EDIT: put DESC instead of ASC

Re: Counting (nr game) 1984

Re: Count Backwards :D 4885

Re: [V2] Ignore User Mail [V2] Updates - Username will now go to viewuser.php - Non-existent users can't be ignored - Users can't ignore staff - All print statements changed to echo first post has been edited

Re: {MOD} Upload Item Pics Via admin panel + Create Description.. here's the correct function /*Update DB*/ mysql_query( sprintf(("UPDATE `items` SET `itmpicname` = '%s' WHERE `itmpic` = u"), mysql_real_escape_string($picture), mysql_real_escape_string($_POST['itmid'])); }   when i was helping illusions, i missed a few beackets

Re: Cron Jobs i would also suggest http://www.webbasedcron.com/ i used before i got the crontab on my own server to work

Re: Sick & Tired i think that a contest would be a good idea aswell and would be really fun

Re: [V2] Ignore User Mail [V2] it's working fine, a possible answer to your problem, is that you tried to change the queries, while modifying it to go with your game, if you did i would suggest that you remove everything that you changed and just use what i have posted as it works 100% fine, and if you do need to change the code, do not mess around with the queries unless you know what your doing. As all the queries have been secured.