City Names

[The Ace]

I am trying to get the name of the city the user is in to display at the top of the explore page, where it says: You begin exploring....

I have tried having:

You begin exploring {$r['cityname']}

 

but that didn't work. Do I need to have something at the top, like in viewuser.php, such as:

$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']}");

 

but only have:

$q=$db->query("SELECT c.* FROM users u LEFT JOIN cities c ON u.location=c.cityid WHERE u.userid={$_GET['u']}");

or something like that?

Cheers.

[Guest Anonymous]

Re: City Names

$db->query("SELECT c.* FROM users u LEFT JOIN cities c ON u.location=c.cityid WHERE u.userid={$ir['userid']}");

that may work.

[fbiss]

Re: City Names

Instead of adding a query, first try to change that line to:

 

You begin exploring {$ir['cityname']}

[The Ace]

Re: City Names

No, that didn't work either...it just displayed: You begin exploring and see a bit that interests you.

But thanks for trying! :)

[Joel]

Re: City Names

Look on the Submitted mods, I posted a Explore page thats shows the city name near the top, Take that bit out and put it in your explore page :/

[The Ace]

Re: City Names

Thanks a lot Extermination! :o)