kaine-

Can anyone convert any of these files can anyone convert any of these files into McCode v2 please if so can someone do it and inbox me the link thanks,

Yes i did i made citymafia.info but its run out and i nt changed it so i bought extreme-gangsters.co.uk and i not changed it over propa so try /register2.php then it shud work :)

ohhhh i didnt change the name over try http://www.extreme-gangsters.co.uk/register2.php that will work :)

WHat do you mean also the game only works with mozilla firefox.

Making a custom made website, need coders and designers, the website is up it is http://www.extreme-gangsters.co.uk everything on there is custom made by myself i need someone who can code custom pages and someone who is good at designing and they will need to inbox me there pay with how much they charge if your interested please write on here also check the website and tell me what you think thank you :)

anyone got one then?

the domain is mafiagamescript.net its all on there i will buying licenses and so on.

Someone said i should buy a script called mafia game script v2.... should i do this?

Please message me for more info, the game will be MCC based, i have already purchased a script but just needs someone to help me make it better?

Oh i have changed my website kind now i am using MCC just need the MCC version of the betting system if anyone has one please send it thanks.

This is what it looks like on a game i play, if anyone has one with the DB's not using MCC please email it to me, also looking to make a game with someone.

Yes it is like a football system just like the one on torn but not using mccode.

Yeah but it cannot be for mccode.

Looking for a football betting system, if anyone has any please inbox me.

Jaaaaaaaaaaaaaaaack oh really tbh they was very basic and i have had a new layout made and a graveyard added so.... its only a game what i was users to join whats the big deal?

Hey all i have created a new website, www.citymafia.info i am looking for picture makers and people who can code mafia games also please join and give your feedback about what you like/diss like. There is also a twitter and facebook feed. The aim of the website is to rank to the top rank and be the best, richest, most powerful and have the biggest baddest mafia family. here are a few print screen's of the website.

anyone know how to sort this Fatal error: Call to a member function assign_by_ref() on a non-object in /home/kainesne/public_html/include/class_language.php on line 153

ive changed it and it says the same thing :/

QUERY ERROR: Unknown column 'h.hChi' in 'on clause' Query was SELECT u.*,us.*,h.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN houses h ON h.hChi=u.maxChi WHERE u.userid=30 anyone know how to sort it?

wt u mean is it set?

this is the script i am using:: <?php 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']}"); if($db->num_rows($q) == 0) { print "Sorry, we could not find a user with that ID, check your source."; } else { $r=$db->fetch_row($q); $m=$db->query("SELECT * FROM users WHERE userid={$r['married']}"); $par=$db->fetch_row($m); if($r['user_level'] == 1) { $userl="Member"; } else if($r['user_level'] == 2) { $userl="Admin"; } else if ($r['user_level'] == 3) { $userl="Secretary"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="Assistant"; } $lon=($r['laston'] > 0) ?date('F j, Y g:i:s a',$r['laston']) : "Never"; $sup=date('F j, Y g:i:s a',$r['signedup']); $ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ']; $d=""; if($r['laston'] > 0) { $la=time()-$r['laston']; $unit="seconds"; if($la >= 60) { $la=(int) ($la/60); $unit="minutes"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $str="$la $unit ago"; } else { $str="--"; } if($r['last_login'] > 0) { $ll=time()-$r['last_login']; $unit2="seconds"; if($ll >= 60) { $ll=(int) ($ll/60); $unit2="minutes"; } if($ll >= 60) { $ll=(int) ($ll/60); $unit2="hours"; if($ll >= 24) { $ll=(int) ($ll/24); $unit2="days"; } } $str2="$ll $unit2 ago"; } else { $str2="--"; } if($r['married'] != 0) { $partner= "<font color=green>{$par['username']}</font>"; } else { $partner= "<font color=red>N/A</font>"; } if($r['donatordays']) { $r['username'] = "<font color=red>{$r['username']}</font>";$d=""; } if($r['laston'] >= time()-15*60) { $on="<font color=green>Online</font>"; } else { $on="<font color=red>Offline</font>"; } print "<h3>Profile for {$r['username']}</h3> <table width=95% cellspacing=1 class='table'><tr> <th align='left'>User Infomation</th> <th width='25%'>Display Picture</th></tr> <tr><td> Name: {$r['username']} [{$r['userid']}] $d Online: $on User Level: $userl Duties: {$r['duties']} Gender: {$r['gender']} Days Old: {$r['daysold']} Level: {$r['level']} Gang: "; if($r['gang']) { print "{$r['gangNAME']}"; } else { print "N/A"; } print " Property: {$r['hNAME']} Health: {$r['hp']}/{$r['maxhp']} Married: $partner Friends: {$r['friend_count']} Enemies: {$r['enemy_count']} Signed Up: $sup Last Active: $lon Last Action: $str Last Login: $str2 Location: {$r['cityname']} Referals: "; $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print ""; if($r['fedjail']) { print " <font color=red>In federal jail for {$r['fed_days']} day(s). {$r['fed_reason']}</font>"; } if($r['hospital']) { print " <font color=red>In hospital for {$r['hospital']} minutes. {$r['hospreason']}</font>"; } if($r['jail']) { print " <font color=red>In jail for {$r['jail']} minutes. {$r['jail_reason']}</font>"; } print "</td> <td align='center'>"; if($r['display_pic']) { print ""; } else { print "This user has no display pic!"; } $sh=($ir['user_level'] >1) ? "Staff Info" : ""; print "</td></tr> <tr> <td width='25%' align='center'> </td> <td colspan='3' align='center'>User Interaction Links</td> </tr> <tr> <td width='25%' align='left' valign='top'>"; $pd=$db->query("SELECT * FROM pdetails WHERE userid={$r['userid']}"); $p=$db->fetch_row($pd); echo "<u>Personal Information:</u> "; if($p['personal']=='ON') { echo "First Name: {$p['first']} Last Name: {$p['last']} Age: {$p['age']} Aim Of The Game: {$p['aog']} Msn: {$p['msn']} Aim: {$p['aim']} Aol: {$p['aol']} Yahoo: {$p['yahoo']} "; } else { echo "This person dose not wont to share there personal details."; } print " </td> <td colspan='3' align='center'> [Send Mail] [Display Cabinet] [Send Cash] "; if($set['sendcrys_on']) { print "[Send Crystals] "; } if($set['sendbank_on']) { if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0) { print "[Bank Transfer] "; } } print " [Attack]"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { print " [Jail] [MailBan]"; } if($ir['donatordays'] > 0) { print " [Add Friends] [Add Enemies] "; } print "</td> </tr> <tr> <td colspan='4' align='center'>$sh</td> </tr> <tr> <td colspan='4' align='center'>"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { $r['lastiph']=@gethostbyaddr($r['lastip']); $r['lastiph']=checkblank($r['lastiph']); $r['lastip_loginh']=@gethostbyaddr($r['lastip_login']); $r['lastip_loginh']=checkblank($r['lastip_loginh']); $r['lastip_signuph']=@gethostbyaddr($r['lastip_signup']); $r['lastip_signuph']=checkblank($r['lastip_signuph']); print "<h3>Internet Info</h3><table width='100%' border='0' cellspacing='1' class='table'> <tr><td align='center'></td><td align='center' class='h'>IP</td><td align='center' class='h'>Hostname</td></tr> <tr><td align='center' class='h'>Last Hit</td><td align='center'>$r[lastip]</td><td align='center'>$r[lastiph]</td></tr> <tr><td align='center' class='h'>Last Login</td><td align='center'>$r[lastip_login]</td><td align='center'>$r[lastip_loginh]</td></tr> <tr><td align='center' class='h'>Signup</td><td align='center'>$r[lastip_signup]</td><td align='center'>$r[lastip_signuph]</td></tr></table>"; print "<form action='staffnotes.php' method='post'> Staff Notes: <textarea rows=7 cols=60 name='staffnotes'>{$r['staffnotes']}</textarea> <input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; } else { print ""; } print "</tr></table>"; } } function checkblank($in) { if(!$in) { return "N/A"; } return $in; } if($r['profileSIG'] == "") { print " <table cellspacing=1 class='table' width='95%'> <tr style='background:black'> <th><center>Profile Signature</center></th> </tr> <tr> <td><center>This user has not got a profile signature!</center></td> </tr> </table>"; } else { print " <table cellspacing=1 class='table' width='95%'> <tr style='background:black'> <th><center>Profile Signature</center></th> </tr> <tr> <td>{$r['profileSIG']}</td> </tr> </table>"; } $h->endpage(); ?> but when i put it on it says this: QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query was SELECT * FROM users WHERE userid= can someone help me?

on my viewuser it says on my view user it says QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query was SELECT * FROM users WHERE userid= anyone have any idea why?? this is the script: <?php 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']}"); if($db->num_rows($q) == 0) { print "Sorry, we could not find a user with that ID, check your source."; } else { $r=$db->fetch_row($q); $m=$db->query("SELECT * FROM users WHERE userid={$r['married']}"); $par=$db->fetch_row($m); if($r['user_level'] == 1) { $userl="Member"; } else if($r['user_level'] == 2) { $userl="Admin"; } else if ($r['user_level'] == 3) { $userl="Secretary"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="Assistant"; } $lon=($r['laston'] > 0) ?date('F j, Y g:i:s a',$r['laston']) : "Never"; $sup=date('F j, Y g:i:s a',$r['signedup']); $ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ']; $d=""; if($r['laston'] > 0) { $la=time()-$r['laston']; $unit="seconds"; if($la >= 60) { $la=(int) ($la/60); $unit="minutes"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $str="$la $unit ago"; } else { $str="--"; } if($r['last_login'] > 0) { $ll=time()-$r['last_login']; $unit2="seconds"; if($ll >= 60) { $ll=(int) ($ll/60); $unit2="minutes"; } if($ll >= 60) { $ll=(int) ($ll/60); $unit2="hours"; if($ll >= 24) { $ll=(int) ($ll/24); $unit2="days"; } } $str2="$ll $unit2 ago"; } else { $str2="--"; } if($r['married'] != 0) { $partner= "<font color=green>{$par['username']}</font>"; } else { $partner= "<font color=red>N/A</font>"; } if($r['donatordays']) { $r['username'] = "<font color=red>{$r['username']}</font>";$d=""; } if($r['laston'] >= time()-15*60) { $on="<font color=green>Online</font>"; } else { $on="<font color=red>Offline</font>"; } print "<h3>Profile for {$r['username']}</h3> <table width=95% cellspacing=1 class='table'><tr> <th align='left'>User Infomation</th> <th width='25%'>Display Picture</th></tr> <tr><td> Name: {$r['username']} [{$r['userid']}] $d Online: $on User Level: $userl Duties: {$r['duties']} Gender: {$r['gender']} Days Old: {$r['daysold']} Level: {$r['level']} Gang: "; if($r['gang']) { print "{$r['gangNAME']}"; } else { print "N/A"; } print " Property: {$r['hNAME']} Health: {$r['hp']}/{$r['maxhp']} Married: $partner Friends: {$r['friend_count']} Enemies: {$r['enemy_count']} Signed Up: $sup Last Active: $lon Last Action: $str Last Login: $str2 Location: {$r['cityname']} Referals: "; $rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}"); print $db->num_rows($rr); print ""; if($r['fedjail']) { print " <font color=red>In federal jail for {$r['fed_days']} day(s). {$r['fed_reason']}</font>"; } if($r['hospital']) { print " <font color=red>In hospital for {$r['hospital']} minutes. {$r['hospreason']}</font>"; } if($r['jail']) { print " <font color=red>In jail for {$r['jail']} minutes. {$r['jail_reason']}</font>"; } print "</td> <td align='center'>"; if($r['display_pic']) { print ""; } else { print "This user has no display pic!"; } $sh=($ir['user_level'] >1) ? "Staff Info" : ""; print "</td></tr> <tr> <td width='25%' align='center'> </td> <td colspan='3' align='center'>User Interaction Links</td> </tr> <tr> <td width='25%' align='left' valign='top'>"; $pd=$db->query("SELECT * FROM pdetails WHERE userid={$r['userid']}"); $p=$db->fetch_row($pd); echo "<u>Personal Information:</u> "; if($p['personal']=='ON') { echo "First Name: {$p['first']} Last Name: {$p['last']} Age: {$p['age']} Aim Of The Game: {$p['aog']} Msn: {$p['msn']} Aim: {$p['aim']} Aol: {$p['aol']} Yahoo: {$p['yahoo']} "; } else { echo "This person dose not wont to share there personal details."; } print " </td> <td colspan='3' align='center'> [Send Mail] [Display Cabinet] [Send Cash] "; if($set['sendcrys_on']) { print "[Send Crystals] "; } if($set['sendbank_on']) { if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0) { print "[Bank Transfer] "; } } print " [Attack]"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { print " [Jail] [MailBan]"; } if($ir['donatordays'] > 0) { print " [Add Friends] [Add Enemies] "; } print "</td> </tr> <tr> <td colspan='4' align='center'>$sh</td> </tr> <tr> <td colspan='4' align='center'>"; if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5) { $r['lastiph']=@gethostbyaddr($r['lastip']); $r['lastiph']=checkblank($r['lastiph']); $r['lastip_loginh']=@gethostbyaddr($r['lastip_login']); $r['lastip_loginh']=checkblank($r['lastip_loginh']); $r['lastip_signuph']=@gethostbyaddr($r['lastip_signup']); $r['lastip_signuph']=checkblank($r['lastip_signuph']); print "<h3>Internet Info</h3><table width='100%' border='0' cellspacing='1' class='table'> <tr><td align='center'></td><td align='center' class='h'>IP</td><td align='center' class='h'>Hostname</td></tr> <tr><td align='center' class='h'>Last Hit</td><td align='center'>$r[lastip]</td><td align='center'>$r[lastiph]</td></tr> <tr><td align='center' class='h'>Last Login</td><td align='center'>$r[lastip_login]</td><td align='center'>$r[lastip_loginh]</td></tr> <tr><td align='center' class='h'>Signup</td><td align='center'>$r[lastip_signup]</td><td align='center'>$r[lastip_signuph]</td></tr></table>"; print "<form action='staffnotes.php' method='post'> Staff Notes: <textarea rows=7 cols=60 name='staffnotes'>{$r['staffnotes']}</textarea> <input type='hidden' name='ID' value='{$_GET['u']}' /> <input type='submit' value='Change' /></form>"; } else { print ""; } print "</tr></table>"; } } function checkblank($in) { if(!$in) { return "N/A"; } return $in; } if($r['profileSIG'] == "") { print " <table cellspacing=1 class='table' width='95%'> <tr style='background:black'> <th><center>Profile Signature</center></th> </tr> <tr> <td><center>This user has not got a profile signature!</center></td> </tr> </table>"; } else { print " <table cellspacing=1 class='table' width='95%'> <tr style='background:black'> <th><center>Profile Signature</center></th> </tr> <tr> <td>{$r['profileSIG']}</td> </tr> </table>"; } $h->endpage(); ?>

same with me i just tried this but it doesnt work do the crons need to go in order like minute first 5min second and so on?

if($r['faction']) { echo '.'"]'.$r['factionNAME'].' '; } else { echo 'Not in a faction. '; } i just put this in what else do i need i copied this over the gang bit and it says this Notice: Undefined index: factions in /home/qulo8876/public_html/viewuser.php on line 159

because im using a free trail on a host and i need to change so my crons will work anyone know any?