lucky3809

I agree 100% lol I looked at it and was like wth :-)

Replace query with:

$q =$db->query("SELECT u.*,us.strength,us.agility,us.guard,us.labour,us.IQ,c.cityname,h.hNAME,g.gangNAME,
f.fed_days,f.fed_reason 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']."");

You do not need to select every single thing in the user table like you were if your going to select all use u.*....

I also found below the query you are missing a few IF statement endings...

not exactly i have got it working with his extra stuff... You are right about the vars after i uploaded the script to my server. but his bccode stuff is fine... its his query that is causing the problem...

Take a look....

echo "

<h3><font color=orange>Profile for {$r['username']}</font></h3>

<table width=100% cellspacing=1 class='' border='1'><tr style='background:darkred'><th>General Info</th><th>Financial Info</th> <th>Display Pic</th></tr>

<tr>

<td>

Name: $user_name<br />

User Level: $userl<br />

<font color=yellow>$u_duties</font>

<font color=#00FF00>Status Message: {$r['sm']}</font><br />

Gender: {$r['gender']}<br />

Married: $partner<br />

Signed Up: $sup<br />

Last Active: $lon<br />

Last Action: $ula<br />

Last Login: $ull<br />

Do you see anything wrong?

your $vars is not going to show the way you have them it should be

Name: '.$user_name.'<br />

also your query is screwed up...

give me a few and i will fix it for you.

if($ir['student']== 3)

{

echo 'You already have 3 students!';

$h->endpage();

exit;

}

You do know that you can have more then 3 students?

it's basically saying if the value is 3 in your table it will print that statement but if the value is 1,2,4,5,6 and so forth it wont print that...

== means that it has to be the value of 3 I think you were aiming for the greater than sign > ....

if($ir['student']> 3)

{

echo 'You already have 3 students!';

$h->endpage();

exit;

}

yep lol. I had to redo the crime page, I didnt want to give crystals either!

There is actually one like criminals-nightmare on here search for attack

thanks for the input...$var+=0 I didnt know about that, will look it up and practice using that. I haven't covered all the basics, iam no expert lol. I just know somethings that do work for me.

I use abs(intval for many reason one in which Joshua said and another when someone enters for instant http://www.game.com/steal.php?ID='1' in the url, I dont want it to show a query error like it would show if I had not used it in the link directing from the users profile. I dont want users to enter in an invalid statement..

I know I could prevent the error message from showing by adding @$db->query...

This is the style that goes up above the page...

<style type="text/css">

.steals_msg {

color: #009900;

margin: 0;

padding: 2px 0px 2px 12px;

}

.steals {

border: 1px #009900 solid;

background-color: #eee;

width: 55%;

margin: 0 auto;

padding: 8px 15px 3px 15px;

}

.steal_msg {

color: #000;

margin: 0;

padding: 2px 0px 2px 12px;

}

.steal {

border: 1px #000 solid;

background-color: #eee;

width: 55%;

margin: 0 auto;

padding: 8px 15px 3px 15px;

}

.stealhj {

border: 1px maroon solid;

background-color: #eee;

width: 55%;

margin: 0 auto;

padding: 8px 15px 3px 15px;

}

.stealhj_msg {

color: maroon;

margin: 0;

padding: 2px 0px 2px 12px;

}

</style>

Forgot lol....

For those that dont know how to create the link to the steal page you place this on the viewuser.php

<a href="steal.php?ID='.$r['userid'].'">Steal</a>

This mod was requested by $Chinion$...

What this does is allow you to steal money and crystals from other players, it takes 10 energy to perform one steal...

This can be modify to steal from banks just change the money part to bankmoney... right now I have it taking from money out of the bank...Create a new file call it steal.php

Screenshots...

NOTE: If the code did not show up correctly let me know and i will take off the bbcode tags.. im using firefox and see br tags everywhere o.O

you need to fill in all parts, cant leave one field with 0 or nothing in it. Your default formula is not the problem

All it takes is the query to be changed on the free cash one... but even then there is a easier solution...

I can make it for you for free if you want just give me a few.

Will post mine under free mod

I wouldn't want as many as you can equip, some players take advantage of that idea... should keep it at 6 or less.

I use headgear,primary,secondary,chest plate,feet, and special set-up, and have slots for each one.

to be brutality honest his game is not up and running yet, he is using an illegal mccode script in which he has no knowledge of php or mysql, or even have a plan or theme but that he calls his game crimemasters and using a free host, he wants someone to create him a game for FREE in 1 hour!!

I know this info because I tried to help him, he gave me his access to his file manger, and while I wasn't fast enough to code the whole damn game in under an hour he freaked on me lol. Anyways good luck to who wants to help him for free... Oh yeah if your wondering why I deleted my mods on your game, it's because I think you should learn to php and mysql before even coding also I feel my hard work you don't deserve or help at this time.

@ fuzz Some of the issues are that on some of these mods they aren't showing certain characters such as '. .' but you should be smart to know the problem by looking the scripts over and replacing the errors... noticed same thing on the dump mod that i helped someone add to their server. Always look over the script just don't copy and paste.

I came to a conclusion that all these problems new people are having with their installation of mccodes are using illegal copy of them...

So i dont bother helping anymore. Either buy the legal copy and update it to 2.0.3 or just stop coding all together, and learn php, and mysql,html...

Just saying... Found two people today on here that i had helped personally with illegal copies but i wont mention names, but seriously coding a game takes knowledge of how the codes work do your research first... Dont expect someone to do all the work for you, that's just silly lol...

One thing to remember Calum...

patience is a virtue, when you have someone help you, it takes time, for them to fix things, that are in a mess and not coded properly.

Another thing is you have got to have a plan, to what you want your game to look like the look of a game is what brings players to play your game, you need to be well planned, and have a list in your mind to what you want the developer to do, you just don't say you dont care, or that you guess. You have to know what you want to get what you want, or else you may not get what your looking for or what you want.

When you have that list in mind pm me, but until then I have stopped helping you.

Coding a game takes time and effort and creativity if you have neither then you just as well quit and move on to something else.

I tried to help him... he didnt upload the sqls to his database, thats why it wasnt showing. plus the script had many errors in it.

are you creating a file for the php code?

Does your mysql show the tables you added for those mods?

What is it your trying to add?

You dont just add it to mysql , you have to put the php code in a file.

use this for your 1 minute crons...

http://makewebgames.io/showthread.php/32642-any-version-Removal-of-1-minute-crons

How i do those tricky time things is add a table call it TIME add ID,cTIME...

Then when the person executes a crime have a query INSERT the userid and time into that table...

Then use an if statement like ...

if ($r['cTIME'] ==0){

//crime stuff

}else {

echo ' Sorry time is not up yet.';

}

I then add the query to update that time in the 1 minute cron...

Not bad I like the colors you used.

there is a slight error, when i clicked rob it said i didn't have enough energy the energy was at 100 when I clicked it.

also dont know if you know when you fail a shoplift you go to jail, but your not really in there lol, if you try again and get a fail attempt it adds you again to the list.

I also was ignorant and thought the very same, that if someone cant install then they shouldnt buy the engine, however, there are many self taught individuals out there, that uses tuts to learn from, they dont go to school for php. Myself I know how to install mccodes, but that is because I have learned from tuts I had to google, when I had first started messing with the engine i didnt know the errors that it gave, but i gradually learn what they were, from those tuts I found not on this forum but google search... I had no idea this forum exist until a year later lol...

Anyways it does not hurt to add a tut on how to install the engine, the customer pays for the engine, it should be available rather your an expert developer or not one... You buy software from the store and they come with a Manuel... Just saying... mccodes is software and should come with FULL instructions...

second one is a lot better... you should put dj mixers in the background,and music notes.

A new admin panel would be nice, one where you just type in what your looking to do and it pops up...like jquery type...also some css design wont hurt...and above all security and a good tut on how to install... many people have came to me asking how you install mccodes... it should be a necessity for the people buying the engine, its one of the main and key factors, rather your an expert or not it should be there and included!