TipZ Posted September 12, 2008 Share Posted September 12, 2008 hi. i maked a rank script but now i just need it to run hmm every one can help me ???? as it is now you have to go to the page where i placed the rank script <?php include "globals.php"; 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"); } ?> any one know how i get it to run automatic ?? Quote Link to comment Share on other sites More sharing options...
Tonka Posted September 12, 2008 Share Posted September 12, 2008 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(); ?> Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted September 12, 2008 Share Posted September 12, 2008 Re: hey use a cron, here you go, set it to run whenever you want, hourly or daily, Hmm, cron could work..not the best of ideas. But the cron you provided will not, $userid & $ir are not defined. Try.. <?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 users SET rank = 'starter' WHERE `rankxp` > 1"); $db->query("UPDATE users SET rank='Pickpocket' WHERE `rankxp` > 150"); $db->query("UPDATE users SET rank='Criminal' WHERE `rankxp` > 400"); $db->query("UPDATE users SET rank='Dealer' WHERE `rankxp` > 550"); $db->query("UPDATE users SET rank='Thug' WHERE `rankxp` > 700"); $db->query("UPDATE users SET rank='Leader' WHERE `rankxp` > 1000"); $db->query("UPDATE users SET rank='Con Artist' WHERE `rankxp` > 2500"); $db->query("UPDATE users SET rank='Caporegime' WHERE `rankxp` > 5000"); $db->query("UPDATE users SET rank='Hitman' WHERE `rankxp` > 10000"); $db->query("UPDATE users SET rank='Crimelord' WHERE `rankxp` > 15000"); $db->query("UPDATE users SET rank='Piciotto' WHERE `rankxp` > 32000"); $db->query("UPDATE users SET rank='Contabile' WHERE `rankxp` > 40000"); $db->query("UPDATE users SET rank='Boss' WHERE `rankxp` > 57000"); $db->query("UPDATE users SET rank='Kingpin' WHERE `rankxp` > 65000"); $db->query("UPDATE users SET rank='Consiglieri' WHERE `rankxp` > 80000"); $db->query("UPDATE users SET rank='Godfather' WHERE `rankxp` > 110000"); $db->query("UPDATE users SET rank='Don' WHERE `rankxp` > 210000"); $db->query("UPDATE users SET rank='Legendary Godfather' WHERE `rankxp` > 310000"); $db->query("UPDATE users SET rank='Legendary Don' WHERE `rankxp` > 410000"); $db->query("UPDATE users SET rank='Untouchable Don' WHERE `rankxp` > 490000"); ?> Quote Link to comment Share on other sites More sharing options...
POG1 Posted September 12, 2008 Share Posted September 12, 2008 Re: hey if ($ir['rankxp'] > 1) { $rank = "Rank1"; ) if ($ir['rankxp'] > 150) { $rank = "Rank2"; } if ($ir['rankxp'] > 400) { $rank = "Rank3"; ) $result = mysql_query("UPDATE `users` SET `rank` = '".$rank."' WHERE `userid` = '".$userid."'"); if (!$result) { echo 'Invalid query: ' . mysql_error(); $h->endpage(); // not sure if that is rite as i don't use mccodes. die(); } Quote Link to comment Share on other sites More sharing options...
TipZ Posted September 12, 2008 Author Share Posted September 12, 2008 Re: hey use a cron, here you go, set it to run whenever you want, hourly or daily, Hmm, cron could work..not the best of ideas. But the cron you provided will not, $userid & $ir are not defined. Try.. <?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 users SET rank = 'starter' WHERE `rankxp` > 1"); $db->query("UPDATE users SET rank='Pickpocket' WHERE `rankxp` > 150"); $db->query("UPDATE users SET rank='Criminal' WHERE `rankxp` > 400"); $db->query("UPDATE users SET rank='Dealer' WHERE `rankxp` > 550"); $db->query("UPDATE users SET rank='Thug' WHERE `rankxp` > 700"); $db->query("UPDATE users SET rank='Leader' WHERE `rankxp` > 1000"); $db->query("UPDATE users SET rank='Con Artist' WHERE `rankxp` > 2500"); $db->query("UPDATE users SET rank='Caporegime' WHERE `rankxp` > 5000"); $db->query("UPDATE users SET rank='Hitman' WHERE `rankxp` > 10000"); $db->query("UPDATE users SET rank='Crimelord' WHERE `rankxp` > 15000"); $db->query("UPDATE users SET rank='Piciotto' WHERE `rankxp` > 32000"); $db->query("UPDATE users SET rank='Contabile' WHERE `rankxp` > 40000"); $db->query("UPDATE users SET rank='Boss' WHERE `rankxp` > 57000"); $db->query("UPDATE users SET rank='Kingpin' WHERE `rankxp` > 65000"); $db->query("UPDATE users SET rank='Consiglieri' WHERE `rankxp` > 80000"); $db->query("UPDATE users SET rank='Godfather' WHERE `rankxp` > 110000"); $db->query("UPDATE users SET rank='Don' WHERE `rankxp` > 210000"); $db->query("UPDATE users SET rank='Legendary Godfather' WHERE `rankxp` > 310000"); $db->query("UPDATE users SET rank='Legendary Don' WHERE `rankxp` > 410000"); $db->query("UPDATE users SET rank='Untouchable Don' WHERE `rankxp` > 490000"); ?> thanks man its working now :) Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted September 13, 2008 Share Posted September 13, 2008 Re: hey Couldn't it just be placed in the header.php? Quote Link to comment Share on other sites More sharing options...
Isomerizer Posted September 13, 2008 Share Posted September 13, 2008 Re: hey Couldn't it just be placed in the header.php? What would be run every time someone clicks over daily... Bad idea... Gonna run alot of unnecessary queries. Quote Link to comment Share on other sites More sharing options...
Haunted Dawg Posted September 13, 2008 Share Posted September 13, 2008 Re: hey Iso, you could use as pog-one said... if($ir['rankxp'] > 1) { $rank = "Newbie"; } else if($ir['rankxp'] > 150) { $rank = "Pick Pocket"; } else if($ir['rankxp'] > 400) { $rank = "Criminal"; } else if($ir['rankxp'] > 550) { $rank = "Dealer"; } else if($ir['rankxp'] > 700) { $rank = "Thug"; } else if($ir['rankxp'] > 1000) { $rank = "Criminal"; } mysql_query("UPDATE users SET rank='".$rank."' WHERE userid=".$ir['userid']) or die(mysql_error()); Quote Link to comment Share on other sites More sharing options...
AlabamaHit Posted September 14, 2008 Share Posted September 14, 2008 Re: hey so would placing it in the hour cron... Quote Link to comment Share on other sites More sharing options...
Haunted Dawg Posted September 14, 2008 Share Posted September 14, 2008 Re: hey header.php Quote Link to comment Share on other sites More sharing options...
Dave Posted September 14, 2008 Share Posted September 14, 2008 Re: hey header.php Personally i would go for a cron, Considering i've striped my header down to only what it needs to run (For speed) Quote Link to comment Share on other sites More sharing options...
Haunted Dawg Posted September 15, 2008 Share Posted September 15, 2008 Re: hey Well david, you have seen my header.php thats all i need to run in header.php the rest i run either on other scripts. But as you see, my game still loads fast with the images. Because the header has an efficient coding. Quote Link to comment Share on other sites More sharing options...
Dave Posted September 15, 2008 Share Posted September 15, 2008 Re: hey Well david, you have seen my header.php thats all i need to run in header.php the rest i run either on other scripts. But as you see, my game still loads fast with the images. Because the header has an efficient coding. Same with FW because there are quite a few uncompressed PNG's on the header. Quote Link to comment Share on other sites More sharing options...
Haunted Dawg Posted September 15, 2008 Share Posted September 15, 2008 Re: hey Well i hope RR's images are compressed. :lol: Quote Link to comment Share on other sites More sharing options...
POG1 Posted September 15, 2008 Share Posted September 15, 2008 Re: hey if your worried about loading times don't have any images :P Quote Link to comment Share on other sites More sharing options...
Dave Posted September 16, 2008 Share Posted September 16, 2008 Re: hey if your worried about loading times don't have any images :P Then it looks rubbish xD Quote Link to comment Share on other sites More sharing options...
Tezza` Posted September 16, 2008 Share Posted September 16, 2008 Re: hey if your worried about loading times don't have any images :P Then it looks rubbish xD not exactly, thats where CSS comes in... you'd be suprised how much you can do with that! (: Quote Link to comment Share on other sites More sharing options...
Dave Posted September 16, 2008 Share Posted September 16, 2008 Re: hey Yerp i know but images are generally easier to get nicer effects Quote Link to comment Share on other sites More sharing options...
Tezza` Posted September 16, 2008 Share Posted September 16, 2008 Re: hey True, but in some sence CSS can do some nice things :P Quote Link to comment Share on other sites More sharing options...
POG1 Posted September 16, 2008 Share Posted September 16, 2008 Re: hey True, but in some sence CSS can do some nice things :P yeah, i have seen sites with 1 big BG image as the whole website layout it took about 5 mins to load fully Quote Link to comment Share on other sites More sharing options...
Tezza` Posted September 17, 2008 Share Posted September 17, 2008 Re: hey True, but in some sence CSS can do some nice things :P yeah, i have seen sites with 1 big BG image as the whole website layout it took about 5 mins to load fully yea thats the problem, if you dont cut and slice properly and just put a hige image... it kinda sucks. Quote Link to comment Share on other sites More sharing options...
POG1 Posted September 17, 2008 Share Posted September 17, 2008 Re: hey Adobe Imageready is good for slicing images. Having images tiled also helps to slim down loading times. Quote Link to comment Share on other sites More sharing options...
Dave Posted September 17, 2008 Share Posted September 17, 2008 Re: hey Adobe Imageready is good for slicing images. Having images tiled also helps to slim down loading times. I never cut my graphics up xD Quote Link to comment Share on other sites More sharing options...
Tezza` Posted September 17, 2008 Share Posted September 17, 2008 Re: hey Adobe Imageready is good for slicing images. Having images tiled also helps to slim down loading times. I never cut my graphics up xD = slow loading times :P tsk tsk.. Quote Link to comment Share on other sites More sharing options...
Dave Posted September 17, 2008 Share Posted September 17, 2008 Re: hey Not really for me, I hate images which load one by one (When there sliced) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.