Replace Country name by Country Code

[hel68c +]

Do you know how to replace the Country name by the Country code in the showlisting template?

[hel68c +]

Like this:

Photos | ------ Title ----- | Price | - Expiration -| Country
?????? | ????????????????? | 9.00$ | 2008-12-15 | US

[Eric Barnes]

I think the only way possible would be to edit the registration form and use the code instead of the country name. Of course this would affect new customers.

[hel68c +]

If we join the table countries with this queries (listings.php line 209). Do you think it's possible?

$sSQL = "SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.username, u.state, u.city, u.country ". $select ." FROM ".PREFIX."listings AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id" . $joins;

[Eric Barnes]

Yes that might work however that query is very complex. I think it already has about three joins on it.

A better option maybe to create a Smarty plugin or use Smarty's str_replace. Of course you may not want to go that route if you have users from lots and lots of countries.

[hel68c +]

Hmm... a bit to far for me.

Thanks anyway!

[Maffo +]

Try this, havent tested this so it may not work.

Find this code at around line 377 on Listings.php

PHP Code:

while ($row=$result->fetch()) 
            {
                $row['id']=$row['id']; 


Now just before the $row['id'] line paste this

PHP Code:

if($row['country']){
                        $maf_sSQL="SELECT countryCode FROM ".PREFIX."countries WHERE countryName='".$row['country']."'";
                        $maf_result=$db->query($maf_sSQL);
                        $maf_rs=$maf_result->fetch();
                        $row['countryCode']=$maf_rs['countryCode'];
                } 


You should then be able to use 'countryCode' from within your template.

Let me know if it doesnt work

[hel68c +]

Hey Maffo! you are very fast and effective.

It work fine.
Thank you!