Spiders - Filtering from Who's Online?

[djdavedawson]

Here is what I changed in who's online to accomplish filtering out the spiders around line 197 zen 1.3.8:


changed this:

$whos_online = $db->Execute("select customer_id, full_name, ip_address, time_entry, time_last_click,
                                      last_page_url, session_id, host_address, user_agent
                               from " . TABLE_WHOS_ONLINE . "
                               order by $order"); 

to this:

$whos_online = $db->Execute("select customer_id, full_name, ip_address, time_entry, time_last_click,
                                      last_page_url, session_id, host_address, user_agent
                               from " . TABLE_WHOS_ONLINE . "
                               where full_name <> '&yen;Spider'
                               order by $order"); 

~DD

[djdavedawson]

I also added this around line 334 to show what product they were looking at :

I changed this:

} else {
                      echo "<a href='" . $whos_online->fields['last_page_url'] . "' target=new>" . '<u>' . $whos_online->fields['last_page_url'] . '</u>' . "</a>";
 } 

to this :

 } else {
                                        
                        $result = preg_match("/products_id=([0-9999]*)/", $whos_online->fields['last_page_url'], $matches);
                        
                        if ($result) {
                        
                        $model_var = $matches[1];
                        
                        $model_qry = $db->Execute("select products_id, products_name
                               from " . TABLE_PRODUCTS_DESCRIPTION . "
                               where " . $model_var . "= products_id
                               ");
                        
                        $model_num =  $model_qry->fields['products_name'];
                        
                        
                        } else {
                        
                        $model_num = $whos_online->fields['last_page_url'];
                        
                        }
                            
                      echo "<a href='" . $whos_online->fields['last_page_url'] . "' target=new>" . '<u>' . $model_num  . '</u>' . "</a>";
 } 

Thought I would share this too.

~DD

[orchidlake]

love it! thanks so much for the code - especially the product text code.

[djdavedawson]

Thanks, I'm glad this helps. I have since updated the products code...

                    } else {
                                    
                        if (preg_match("/products_id=([0-9999]*)/", $whos_online->fields['last_page_url'], $matches)) {
                        
                        $model_var = $matches[1];
                        
                        $model_qry = $db->Execute("select products_id, products_name
                               from " . TABLE_PRODUCTS_DESCRIPTION . "
                               where " . $model_var . "= products_id
                               ");
                        
                        $model_num =  $model_qry->fields['products_name'];
                        
                        
                        } else {
                        
                        if (preg_match("/cPath=([0-9999_]*)/", $whos_online->fields['last_page_url'], $matches)) {
                        
                        if (strrchr($matches[1],'_') == true) { 
                        
                        $model_var = substr(strrchr($matches[1],'_'),+1) ;
                        
                        } else { 
                        
                        $model_var = $matches[1];
                        
                        }
                        
                                                            
                        $model_qry = $db->Execute("select categories_id, categories_name
                               from " . TABLE_CATEGORIES_DESCRIPTION . "
                                where " . $model_var . "= categories_id
                               ");
                        
                        $model_num =  'CAT - ' . $model_qry->fields['categories_name'];
                        
                        
                        } else {
                        
                        if (preg_match("/main_page=([A-Za-z0-9999_]*)/", $whos_online->fields['last_page_url'], $matches)) {
                        
                        $model_num = strtoupper ($matches[1]);
                        
                        } else {
                        
                        
                        if (preg_match("$/$", $whos_online->fields['last_page_url'])){
                        
                                    
                        $model_num = 'HOME'; 
                        
                        } else {
                        
                        $model_num = $whos_online->fields['last_page_url'];
                        
                        }
                        
                        }
                        
                        } 
                        
                        }
                            
                      echo "<a href='" . $whos_online->fields['last_page_url'] . "' target=new>" . '<u>' . $model_num  . '</u>' . "</a>";
                    } 

[bonnit]

FANTASTIC ADDITION!

this combined with the enhanced whos online makes life so much sweeter, i think you should certainly add this as to the zen addon directory!

thanks!!