Show
Ignore:
Timestamp:
02/21/07 15:12:16 (2 years ago)
Author:
jm3
Message:

cleanup

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • feedmelinks/bin/heuristics.sh

    r1325 r1339  
    5656        scope=10 
    5757 
    58    double_hyphenated_links=`mysql -u $u -p$p $u -B -e "select count( url ) as 'double_hyphenated_links' from links where submitter = '$USER' and url REGEXP '.+-.+-.+\\.com';" | tail -n1` 
    59 known_spammer_domain_links=`mysql -u $u -p$p $u -B -e "select count( url ) as 'known_spammer_domain_links' from links where submitter = '$USER' and url REGEXP '(ourbigtop|blogspot)\.com';" | tail -n1` 
    60                 dot_info_domains=`mysql -u $u -p$p $u -B -e "select count( url ) as 'dot_info_domains' from links where submitter = '$USER' and url REGEXP '\\.info(%2F|$)';" | tail -n1` 
    61                    tags_w_commas=`mysql -u $u -p$p $u -B -e "select count( name ) as 'tags_w_commas' from linksGroups where userid = '$USER' and name REGEXP ',';" | tail -n1` 
    62     tags_w_multiple_spaces=`mysql -u $u -p$p $u -B -e "select count( name ) as 'tags_w_multiple_spaces' from linksGroups where userid = '$USER' and name REGEXP '. . ';" | tail -n1` 
    63                      links=`mysql -u $u -p$p $u -B -e "select count( url ) as 'links' from links where submitter = '$USER';" | tail -n1` 
    64                             tags=`mysql -u $u -p$p $u -B -e "select count( id ) as 'tags' from linksGroups where userid = '$USER';" | tail -n1` 
    65    last_ten_domains_linked=`mysql -u $u -p$p $u -B -e "select lower(substring_index(url, '.', 2)) from links where submitter = '$USER' order by id desc limit ${scope};" | tail -n${scope}` 
    66           has_been_snuffed=`mysql -u $u -p$p $u -B -e "select snuffed from linksUsers where userid = '$USER';" | tail -n1` 
     58   double_hyphenated_links=`mysql -u $u -p$p $u -B -e "select count( url ) as 'double_hyphenated_links' from links where userid = '$USER' and url REGEXP '.+-.+-.+\\.com';" | tail -n1` 
     59known_spammer_domain_links=`mysql -u $u -p$p $u -B -e "select count( url ) as 'known_spammer_domain_links' from links where userid = '$USER' and url REGEXP '(ourbigtop|blogspot)\.com';" | tail -n1` 
     60                dot_info_domains=`mysql -u $u -p$p $u -B -e "select count( url ) as 'dot_info_domains' from links where userid = '$USER' and url REGEXP '\\.info(%2F|$)';" | tail -n1` 
     61                   tags_w_commas=`mysql -u $u -p$p $u -B -e "select count( name ) as 'tags_w_commas' from tags where userid = '$USER' and name REGEXP ',';" | tail -n1` 
     62    tags_w_multiple_spaces=`mysql -u $u -p$p $u -B -e "select count( name ) as 'tags_w_multiple_spaces' from tags where userid = '$USER' and name REGEXP '. . ';" | tail -n1` 
     63                     links=`mysql -u $u -p$p $u -B -e "select count( url ) as 'links' from links where userid = '$USER';" | tail -n1` 
     64                            tags=`mysql -u $u -p$p $u -B -e "select count( id ) as 'tags' from tags where userid = '$USER';" | tail -n1` 
     65   last_ten_domains_linked=`mysql -u $u -p$p $u -B -e "select lower(substring_index(url, '.', 2)) from links where userid = '$USER' order by id desc limit ${scope};" | tail -n${scope}` 
     66          has_been_snuffed=`mysql -u $u -p$p $u -B -e "select snuffed from users where userid = '$USER';" | tail -n1` 
    6767      # for freshness idx: 
    68                 first_link=`mysql -u $u -p$p $u -B -e "select to_days( createDate ) from links where submitter = '$USER' ORDER BY id ASC LIMIT 1;" | tail -n1` 
    69                        last_link=`mysql -u $u -p$p $u -B -e "select to_days( createDate ) from links where submitter = '$USER' ORDER BY id DESC LIMIT 1;" | tail -n1` 
     68                first_link=`mysql -u $u -p$p $u -B -e "select to_days( createDate ) from links where userid = '$USER' ORDER BY id ASC LIMIT 1;" | tail -n1` 
     69                       last_link=`mysql -u $u -p$p $u -B -e "select to_days( createDate ) from links where userid = '$USER' ORDER BY id DESC LIMIT 1;" | tail -n1` 
    7070 
    7171        if [ $links -ne 0 ]