Ads Listed By State

[garysmith]

Question:

Is there a way to have a listing of the states and then show # of ads posted to that state? Maybe show this list on the side nav bar...?

Example:

Alabama (23)
Arkansas (12)
Mississippi(39)


And further if I clicked on the state it would take me to the ads posted in the respective state listed?

Is that "hard work" for a mod?

gsmith

[Eric Barnes]

I haven't fully tested this but I think it will work.

First create a new file named function.statesearch.php and include this:

PHP Code:

<?php
/**************************************************  *********************
| 68 Classifieds developed by 68 Designs, LLC.
|-----------------------------------------------------------------------
| All source code & content (c) Copyright 2005, 68 Designs LLC
|   unless specifically noted otherwise.
|
|The contents of this file are protect under law as the intellectual property
| of 68 Designs, LLC. Any use, reproduction, disclosure or copying
| of any kind without the express and written permission of 68 Designs, LLC is forbidden.
|
| Author $Author: Eric $ (68 Classifieds)
| Version $Revision: 1.1 $
| Updated: $Date: 2006/03/14 16:08:04 $
| __________________________________________________  ____________________
|    http://www.68classifieds.com      http://www.68designs.com/
**************************************************  *********************/
function smarty_function_statesearch($params, &$smarty)
{
    global $db;
     
    //first get the states
    $sSQL="SELECT DISTINCT `state` FROM ".PREFIX."users WHERE state <>''";
    $result=$db->query($sSQL);
    while($row=$result->fetch())
    {
        $total=0;
        $sSQL="SELECT id FROM users WHERE state='".$row['state']."'";
        $result=$db->query($sSQL);
        while($rs=$result->fetch())
        {
            $sSQL="SELECT COUNT(*) AS total FROM products WHERE owner=".$rs['id'];
            $result=$db->query($sSQL);
            $state=$result->fetch();
            $total+=$state;
        }
        $output.='<option value="'.$row['state'].'">'.$row['state'].' ('. $total .')</option>';
    }
    return $output;
}
?>

Next upload it to the includes/template/plugins directory.

Finally open your template file search.tpl.php and locate this:
{section name=i loop=$states}
<option value="{$states[i].state}">{$states[i].state}</option>
{/section}

Replace it with:
{stateseach}

[garysmith]

Finally open your template file search.tpl.php and locate this:
{section name=i loop=$states}
<option value="{$states[i].state}">{$states[i].state}</option>
{/section}

Replace it with:
{stateseach}

Eric...followed everything up to here...

do i replace all the red with the blue?

gsmith

[Eric Barnes]

Yes that is correct.

[garysmith]

I don't think it recognized the tag?

I clicked search and got this:

Fatal error: Smarty error: [in search.tpl.php line 91]: syntax error: unrecognized tag 'stateseach' (Smarty_Compiler.class.php, line 580) in /home/zfreeads/public_html/includes/template/Smarty.class.php on line 1095

[Eric Barnes]

Sorry I spelled it wrong.
It should be: {statesearch}

[garysmith]

almost there...

now the pull down in the state area comes up and only one state is there...and announces like this: Mississippi 0 . Go to www.zfreeads.com and do a "search ads" at the top nav bar...then click state.

I have about 8-10 states with data in the system.

Only one shows in the pull down menu at search.

gsmith

[Eric Barnes]

Will you change it back for now and I will do some testing and give you some new code to use. I think it has to do with the way I am looping through the results.

[garysmith]

Yes Sir!

Done.

gsmith

[Eric Barnes]

Ok Gary,

Try this.
Change all the code in that function.statesearch file with the following then upload and change the template back.

PHP Code:

<?php
/**************************************************  *********************
| 68 Classifieds developed by 68 Designs, LLC.
|-----------------------------------------------------------------------
| All source code & content (c) Copyright 2005, 68 Designs LLC
|   unless specifically noted otherwise.
|
|The contents of this file are protect under law as the intellectual property
| of 68 Designs, LLC. Any use, reproduction, disclosure or copying
| of any kind without the express and written permission of 68 Designs, LLC is forbidden.
|
| Author $Author: Eric $ (68 Classifieds)
| Version $Revision: 1.1 $
| Updated: $Date: 2006/03/14 16:08:04 $
| __________________________________________________  ____________________
|    http://www.68classifieds.com      http://www.68designs.com/
**************************************************  *********************/
function smarty_function_statesearch($params, &$smarty)
{
    global $db;
     
    //first get the states
    $sSQL="SELECT DISTINCT `state` FROM ".PREFIX."users WHERE state <>''";
    $result=$db->query($sSQL);
    while($row=$result->fetch())
    {
        $total=0;
        $sSQL="SELECT id FROM ".PREFIX."users WHERE state='".$row['state']."'";
        $result2=$db->query($sSQL);
        while($rs=$result2->fetch())
        {
            $sSQL="SELECT COUNT(*) AS total FROM ".PREFIX."products WHERE owner=".$rs['id'];
            $result3=$db->query($sSQL);
            $state=$result3->fetch();
            $total=$state['total']+$total;
        }
        $output.='<option value="'.$row['state'].'">'.$row['state'].' ('. $total .')</option>';
    }
    return $output;
}
?>