Mark F

Re: Gallery System Great Mod!

Re: Honor Awards - V2 - Modified by HarryB Files are not in folders.

Re: Honor Awards - V2 - Modified by HarryB NEEDS TO BE CHANGED Open: donator30.php Find: mysql_query("INSERT INTO honorawards values ($userid,'donatordays15')",$c); Replace With: mysql_query("INSERT INTO honorawards values ($userid,'donatordays30')",$c);

Re: Honor Awards - V2 - Modified by HarryB Are you sure that 'list' is meant to be an int(11) ? It has been displaying as 0, and you can keep getting awards. I have tried changing the type to varchar, though it only half works. E.G. For donatordays30, when it is set as varchar, it will only add the donatordays part without the 30 to the list. Help would be highly appreciated!

Re: Honor Awards - V2 - Modified by HarryB a) Did you even get this version from here, because it looks different? b) Which version of MCcodes are you using, 1.0, 1.1 or 2.0? c) Have you made any modifications to the script? d) It is hard to look at the code spread across two posts like that. Use the when posting code. [ code ] [/ code ] Remove gaps above and post your code between.

Re: Honor Awards - V2 - Modified by HarryB Put up your code so we can take a look then.

Re: Honor Awards - V2 - Modified by HarryB I am able to receive the same award multiple times. Are you sure that you included all of the sql's?   } $q=mysql_query("SELECT * FROM honorawards WHERE userid=$userid AND list='donatordays15'",$c); if(mysql_num_rows($q)) { print "You have already recieved that award you can only recieve each award one time! "; print "[url='honorawards.php']Back to Honor Awards[/url] "; $h->endpage();   Is there meant to be an honourawards table? If so can I please have the SQL?

Does anyone know why the attack page is only displaying as white?

Re: Free 2 - Icons Fixed after a little effort, lol.

Re: Free 2 - Icons :cry: I could have guessed your answer! I have tried: <left> and echo '<div align="left">'; then I came here to annoy you, lol.

Re: Free 2 - Icons I know this is a n00b question, though how do you align them to the left? :-o I know that you can see this post, reply! Please? I don't like you anymore! :cry: What the heck is going on? :?

Re: [V2] Credit Card Mod [V2]   Thanks for that addon, saved me doing it myself! :-D

Re: [V2] Credit Card Mod [V2]   You took the words right out of my mouth before I could say them, lol.

Re: Help with silly problem, displaying gangs name. or it might just be easier for me to ask How do I display peoples gang names on the index page, lol.

Hello Everyone, I wish to display the name of my gang on my index page. I know that I have to add the following: if($r['gang']) { print "[url='gangs.php?action=view&ID={$r[']{$r['gangNAME']}[/url]"; } else { print "N/A"; } Though how do I change the following code so I only have what I need?: include "globals.php"; $_GET['u'] = abs((int) $_GET['u']); if(!$_GET['u']) { print "Invalid use of file"; } else { $q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}");

Re: Major Problems - Please Help! Thank you for your help, though I had already checked that out. I think that the problem must be on my hosters end, because when I run the file manually it seems to work.

Re: Major Problems - Please Help! Thanks for that, I will try it out!

Hello Everyone, I recently moved my game across servers, though I have been having problems, most likely with my crons. Features like Energy, Brave and Will etc have all stopped working. I have entered my crons into Cpanel, and checked that the code matches that in config.php I would appreciate it if I could have some help! Does anyone know a simple cron test that I could run?

Hello everyone, I have recently moved my game to a new server, though apparently I need to change my file permissions. Does anyone know the default file permissions required for MC Codes v2? I was thinking 755?

Re: Help with Syntax Error Sorry that I am new to this, though what do you mean exactly?

Re: Help with Syntax Error Thanks for your help, though it now says the following: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/marfur93/public_html/index3.php on line 10 Here is the code with line numbers:   09 $mq=mysql_query("SELECT * FROM `marriages` WHERE (`marriage_to` = '{$userid}') OR (`marriage_from` = '{$userid}')",$c); 10 if(mysql_num_rows($mq)) 11 { 12 $mr=mysql_fetch_array($mq); 13 if($mr['marriage_from'] == $userid) { $user=$mr['marriage_to']; } else { $user=$mr['marriage_from']; } 14 $get_U=mysql_query("SELECT * FROM users WHERE userid=$user",$c); 15 $gr=mysql_fetch_array($get_U);

Re: Help with Syntax Error P.S. I get the error message when I add the following sode to my index.php   $mq=mysql_query("SELECT * FROM `marriages` WHERE (`marriage_to` = '{$userid}') OR (`marriage_from` = '{$userid}')",$c); if(mysql_num_rows($mq)) { $mr=mysql_fetch_array($mq); if($mr['marriage_from'] == $userid) { $user=$mr['marriage_to']; } else { $user=$mr['marriage_from']; } $get_U=mysql_query("SELECT * FROM users WHERE userid=$user",$c); $gr=mysql_fetch_array($get_U);

I am trying to install 'Marriage Pro', though I keep getting this error after I insert the code into index.php Parse error: syntax error, unexpected $end in /home/marfur93/public_html/index3.php on line 74 Does anyone know why this is? On line 74 in index.php it just says ?>

Re: Query Help It doesn't work without it though, or at least not for me.

Hello Everyone The problem I am having is that I wish to display both my users house and job on index.php Though when I put the users job query on the page, the users house stops showing. I have a feeling that is has something to do with the following, though I am unsure.   <?php $housequery=1; $jobquery=1; include "globals.php"; $exp=(int)($ir['exp']/$ir['exp_needed']*100);   I would highly appreciate it if somebody could help me with this!