Zero-Affect

weird this reminds me of immortal thug he can't do left join so good either but.. $bombexists = "SELECT in.`inv_itemid`, `inv_userid`, i.`itmid`, `itmname`, u.`userid` FROM `inventory` in LEFT JOIN `items` i ON in.`inv_itemid` = i.`itmid` LEFT JOIN `users` u ON in.`inv_userid` = u.`userid` WHERE in.`inv_itemid` = 3"; $bombboom = $db->query( $bombexists ); should work

That's due to the harry potter convention you just came from Sim

That is very unusual, Maybe just run back over the code, when i get something wrong or a error i normally run over my code or recode specific parts to be sure they are correct.

Weird it looks fine to me, you just get a timed out error?

I'm planning on putting about 500 into advertising within the first month of my game opening i wouldn't want someone's game on my game that only spent 10 bucks on advertising. Doesn't seem fair to me.

paste your code ill see if i can help

ah then a while function maybe in order?

depending on what exactly your asking for there are ways to simply update them like the following [mysql] UPDATE `users` SET `cash` = `cash` + 100 WHERE `donatordays` >= 5 [/mysql] basically it adds 100 cash to anyone who's got 5 or more donatordays

I use Notepad++ when i need to edit multiple files, rarely but still use zend studio when im bored and mostly still in normal old notepad. Generic notepad FTW!

Firstly i'd like to thank Zeddicus of mcaddons for his post on his website about this also thanks to phpsec for information on this. In header.php find (this is normally located in the userdata section): $IP = $_SERVER['REMOTE_ADDR']; or if it looks like this replace with above: $IP = ($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR']; then add below: if ( isset($_SESSION['HTTP_USER_AGENT']) ) { if ( $_SESSION['HTTP_USER_AGENT'] != sha1( $_SERVER['HTTP_USER_AGENT'] )) { session_unset(); session_destroy(); header("Location: login.php"); } } else { $_SESSION['HTTP_USER_AGENT'] = sha1( $_SERVER['HTTP_USER_AGENT'] ); }   In authenticate.php find: $_SESSION['userid']=$mem['userid']; Add below: $_SESSION['HTTP_USER_AGENT'] = sha1( $_SERVER['HTTP_USER_AGENT'] ); Tested and works perfectly (thanks BogFx for the help testing). I am not sure on what encryption is possible but im assuming any is allowed. see hash() for further information on hashes. Any issues don't hesitate to contact me via PM or post here.

nyna owns nyna.co.uk and when you whois that domain the Registrant: Nyna Zpsneynar Nothing weird there... Lets play with some basic encryptions rot13: Nyna Zpsneynar => Alan Mcfarlane I seem to have forgot the website which is his website. Nyna/Alan was a very good programmer and did make some interesting work, Advanced beyond most on MWG/CE.

jokes then a question mark... im so scared :P   It's called coding your own work into a project... You don't need class when you can simply code up a better one within minutes. God i mean we all know the Generic MC one isn't even theirs so... It is better to use class IMO maybe just advance v2's into the 21st century.

I know this probably isn't the best place to post but MC V2 does have a item issue, i have known about it for quite awhile but considering most people wouldn't of even thought about it and most that know, know from me. itembuy.php you can buy items which are buyable but set at price 0, this obviously is very rare but happens alot in small games when people are creating mass items they sometimes forget to uncheck the item buyable check box. So guys remember to uncheck the box and maybe a little fix would work well.   <?php /*----------------------------------------------------- -- Item Buy -- Patched by Zero-Affect -- Released @ MakeWebGames.com for free -----------------------------------------------------*/ include_once (DIRNAME(__FILE__) . '/globals.php'); $_GET['ID'] = (ctype_digit($_GET['ID']) AND !empty($_GET['ID'])) ? $_GET['ID'] : '' ; $_GET['qty'] = (ctype_digit($_GET['qty']) AND !empty($_GET['qty'])) ? $_GET['qty'] : '' ; if($_GET['qty']) { $id = $db->query("SELECT `itmbuyprice`, `itmid`, `itmname` FROM `items` WHERE `itmid` = {$_GET['ID']}"); if($db->num_rows($id) == 0) { echo " This item does not exist. Click [url='index.php']here[/url] to go home. </p> "; } else { $r = $db->fetch_row($id); $price = abs(@intval($r['itmbuyprice'] * $_GET['qty'])); if( $price > $ir['money'] ) { echo " You can only buy what you can afford. Click [url='index.php']here[/url] to go home. </p> "; } else { item_add($userid, $r['itmid'], $_GET['qty']); $db->query("UPDATE `users` SET `money` = `money` - {$price} WHERE `userid` = $userid"); $priceh = money_formatter($price, '$'); $item_name = ( $_GET['qty'] == 1 ) ? ''.$r['itmname'].'' : ''.$r['itmname'].'s' ; echo " You bought {$_GET['qty']} {$item_name} for {$priceh}. Click [url='index.php']here[/url] to go home. </p> "; $db->query("INSERT INTO `itembuylogs` VALUES ('', $userid, {$r['itmid']}, $price, {$_GET['qty']}, unix_timestamp(), '{$ir['handle']} sold {$_GET['qty']} {$item_name} for {$priceh}')"); } } } else if($_GET['ID']) { $ckitm = $db->fetch_row($db->query("SELECT COUNT(`itmid`) AS `check_itm`, `itmname`, `itmbuyprice` FROM `items` WHERE `itmid` = {$_GET['ID']}")); if( !$ckitm['check_itm'] ) { echo " This item does not exist. Click [url='index.php']here[/url] to go back. </p> "; } else { echo " Please specify the amount of {$ckitm['itmname']}s you want to buy. Note: it costs ".money_formatter($ckitm['itmbuyprice'], '')." {$set['primary_currency']} per {$ckitm['itmname']}. </p> <form action='itembuy.php' method='get'> <input type='hidden' name='ID' value='{$_GET['ID']}' /> <table class='table' align='center' cellspacing='1' cellpadding='1' width='55%'> <tr> <th> Quantity: </th> <td> <input type='text' name='qty' value='' /> </td> </tr> <tr> <td colspan='2'> <input type='submit' value='' id='submit_box'> </td> </tr> </table> </form> "; } } else { echo " This item does not exist. Click [url='index.php']here[/url] to go back. </p> "; } $h->endpage(); ?>   Sadly i don't have the time to update it to recent standards but im sure there will be a error since i changed afew things in my items table and so on with KC, If any errors just post and ill try and help. The code itself could do with a update also if anyone's got time (this is very old code).

Sadly i use windows lol but a very edited version, Nice image though.

Yeah it does go Gold Silver Bronze... I better win spammer of the month or your car will disappear mdshare ;) i know afew people on MWG who would buy it.

lol @ me not even noticing that part 8o

Your welcome CableBox, anything else just ask (within reason). I am not lap dancing again...

There are alot of MySQL functions people don't use much on here, LEAST for example.

didn't Zaver do something like this?

That so reminds me of something Anthony Ownz used to do... it's spelt 'maybe' and 'proxy' by the way mate

I do believe that people sometimes mess up with grammar ( i am one of them ) Result of a bad education i guess but thank you TOLK did actually help.

I watched BSG series 1 lastnight (6 episodes and the mini series) and im hooked! I still like the originals though so FRACK you all!

I just had a quick look around and i do admire the work you put in on there, I commend you on that good job.

CronJobs   Are you a guru now? Money is Money Peasant... Let me give you a hand goto config.php and set/change 'code' => 'CODE HERE' i would suggest maybe md5 encrypted password, you can encrypt into md5 here You can use advanced unix cron jobs (personal preference) which then the codes are gotten from installer.php (if your using mc) they are as followed: /5 * * * * curl [url]http://www.website.com/cron_fivemins.php?code=code[/url] * * * * * curl [url]http://www.website.com/cron_minute.php?code=code[/url] 0 * * * * curl [url]http://www.website.com/cron_hour.php?code=code[/url] 0 0 * * * curl [url]http://www.website.com/cron_day.php?code=code[/url]   may also help (personally im sickened that only MTG offered to do it for free)

So you just giving me the spammer badge permanently or changing it to "spammer of the month (zero)"?