Changeset 666

Show
Ignore:
Timestamp:
10/23/06 15:40:46 (2 years ago)
Author:
sven
Message:

mod/browser: silence some notices and clean some sql

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • devel/mod/browser/index.php

    r659 r666  
    8686        $filter_text = __gettext("Filter"); 
    8787         
    88         $body .= <<< END 
     88        $body = <<< END 
    8989         
    9090            <p><b>$browse ::</b>  
    …… 
    107107                    if (empty($filter)) { 
    108108                        $search_sql = "SELECT u.*, COUNT(DISTINCT m.ident) AS members FROM `".$CFG->prefix."users` u JOIN ".$CFG->prefix."friends m ON m.friend = u.ident WHERE u.user_type = \"community\" GROUP BY u.ident ORDER BY members DESC, name DESC"; 
    109                         $count_sql = "SELECT COUNT(DISTINCT u.ident) AS numberofusers, COUNT(DISTINCT m.ident) AS members FROM `".$CFG->prefix."users` u JOIN ".$CFG->prefix."friends m ON m.friend = u.ident WHERE u.user_type = \"community\" GROUP BY u.ident"; 
     109                        $count_sql = "SELECT COUNT(DISTINCT u.ident) AS numberofusers, COUNT(DISTINCT m.ident) AS members FROM `".$CFG->prefix."users` u JOIN ".$CFG->prefix."friends m ON m.friend = u.ident WHERE u.user_type = \"community\""; 
    110110                    } else { 
    111111                        if (empty($searchtype)) { 
    …… 
    142142        } 
    143143         
    144         $search_sql .= " limit $offset, " . $CFG->search_results;      
     144        $search_sql .= sql_paging_limit($offset, $CFG->search_results); 
    145145         
    146146        if ($results = get_records_sql($search_sql)) { 
    …… 
    175175                 
    176176                $blogposts = get_record_sql("SELECT COUNT(".$CFG->prefix."weblog_posts.ident) AS weblogposts FROM ".$CFG->prefix."weblog_posts WHERE weblog = {$result->ident}"); 
    177                 $description = get_record_sql("SELECT ".$CFG->prefix."profile_data.value FROM ".$CFG->prefix."profile_data WHERE owner = {$result->ident} AND name = 'briefdesc'"); 
     177                $description = get_record_sql("SELECT ".$CFG->prefix."profile_data.value FROM ".$CFG->prefix."profile_data WHERE owner = {$result->ident} AND name = 'minibio'"); 
    178178                 
    179179                $icon = "{$CFG->wwwroot}{$result->username}/icons/{$result->icon}/h/67/"; 
    180180                 
    181                 $description = stripslashes($description->value); 
     181                $description = @stripslashes($description->value); 
    182182                $name = stripslashes($result->name); 
    183183