Popular Cities

[jonh1052]

Hi

I am wanting to add on the right side of my site Popular Cities (top 10). Would anyone know how to do?

My site: www.kdanuncios.com.br


Tanks

[jonh1052]

Can you help me?

[mrnestyy]

hi guys,
I am new to osclass and in am looking for tips on adding city or region to my sidebar.Nothing seems to show after i have uploaded and installed OSClass.

[jonh1052]

help me please!

[fre2mansur]

Still no solution??

[teseo]

***CORRECTED***

Hi,

Code: [Select]

    <?php $conn = getConnection();
    $popular_cities = $conn->osc_dbFetchResults("SELECT c.s_name as city_name, cs.i_num_items as items
     FROM %st_city_stats cs
     INNER JOIN %st_city c ON c.pk_i_id = cs.fk_i_city_id
     WHERE cs.i_num_items > 0
     ORDER BY cs.i_num_items DESC
     LIMIT 10", DB_TABLE_PREFIX, DB_TABLE_PREFIX);

    View::newInstance()->_exportVariableToView('cities', $popular_cities);

    while(osc_has_cities()) {
        echo osc_city_name() . ' (' . osc_city_items() . ')<br />';
    } ?>

Regards

[fre2mansur]

hmm something wrong with this code page does not load at all.

[teseo]

No, the code is right. You must have inserted in the wrong place, eliminate php start <?php and end ?> tags if you are inserting it inside another block of PHP code.

Regards

[fre2mansur]

Yes i'm placed in wrong place but now I'm corrected. but the code does not showing any cities.

[teseo]

There was a little mistake, it wouldn't work if your tables have other prefix than standard "oc_", try now with my corrected code above.

If still failing, paste here your footer.php

[fre2mansur]

no. its working well. I cant make this topic as solved. anyway thank you teseo.

This code how I before use the popular cities with using  jquery. but teseo mthode is better.

Code: [Select]

<?php if(osc_count_list_cities() > 0) { ?>
                <h4><?php _e('Popular Cities', 'bender'); ?></h4>
               <div class="popcity">
                    <ul class="popcity">
                             <?php while(osc_has_list_cities() ) { ?>
                                <li><a href="<?php echo osc_list_city_url(); ?>"> <i class="hidden"><?php echo osc_list_city_items() ; ?></i> <?php echo osc_list_city_name() ; ?></a></li>
                             <?php } ?>
                            </ul>
                        <?php } ?>
                        <script>
                            $(function(){
                                var elems = $('ul.popcity').children('li').remove();
                                elems.sort(function(b,a){
                                    return parseInt($(a).text()) > parseInt($(b).text());
                                });
                                $('ul.popcity').append(elems);
                                $('ul.popcity li:eq(4)').nextAll().remove();
                            });
                        </script>


[MkRahamath]

How to make below code for countires and Possible make this as New DAO method?

***CORRECTED***

Hi,

Code: [Select]

    <?php $conn = getConnection();
    $popular_cities = $conn->osc_dbFetchResults("SELECT c.s_name as city_name, cs.i_num_items as items
     FROM %st_city_stats cs
     INNER JOIN %st_city c ON c.pk_i_id = cs.fk_i_city_id
     WHERE cs.i_num_items > 0
     ORDER BY cs.i_num_items DESC
     LIMIT 10", DB_TABLE_PREFIX, DB_TABLE_PREFIX);

    View::newInstance()->_exportVariableToView('cities', $popular_cities);

    while(osc_has_cities()) {
        echo osc_city_name() . ' (' . osc_city_items() . ')<br />';
    } ?>

Regards

[teseo]

***CORRECTED***

Hi,

Using DAO method:

Code: [Select]

$popularCities = new DAO();

$popularCities->dao->select('c.s_name as city_name, cs.i_num_items as items');
$popularCities->dao->from(DB_TABLE_PREFIX.'t_city_stats cs');
$popularCities->dao->join(DB_TABLE_PREFIX.'t_city c', 'c.pk_i_id = cs.fk_i_city_id', "INNER");
$popularCities->dao->where('cs.i_num_items > 0');
$popularCities->dao->orderBy('cs.i_num_items', 'DESC');
$popularCities->dao->limit(0, 10);

$result = $popularCities->dao->get();
$popular_cities = $result->result();

    View::newInstance()->_exportVariableToView('cities', $popular_cities);

    while(osc_has_cities()) {
        echo osc_city_name() . ' (' . osc_city_items() . ')<br />';
    }
 

For countries I've answered in this other thread of yours:

http://forums.osclass.org/general-help/popular-countries

Regards

[MkRahamath]

This is not working and nothing display.

[teseo]

Yes, there was a bug, try now my corrected code.