- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Name: RageLT
Subject: Re: Tag & ServerWeight

./indexer -S

          Database statistics

Status    Expired      Total
   -----------------------------
     0          0         92 Not indexed yet
   200          0         10 OK
   302          0          1 Moved Temporarily
   -----------------------------
 Total          0        103

mysql> SELECT u.url, u.status, s.tag, s.url FROM url u, server s WHERE 
u.status>0 AND s.rec_id=u.server_id LIMIT 20;
+----------------------------------------------+--------+-----+-----------------------+
| url                                          | status | tag | url             
      |
+----------------------------------------------+--------+-----+-----------------------+
| http://www.yahoo.com/                        |    200 | A   | 
http://www.yahoo.com/ |
| http://www.msn.com/                          |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/rss/games.aspx            |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/rss/msnentertainment.aspx |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/rss/msnmoney.aspx         |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/rss/news.aspx             |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/rss/sports.aspx           |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/tour.aspx                 |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/worldwide.aspx            |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/defaultb.aspx             |    200 | B   | 
http://www.msn.com/   |
| http://www.msn.com/default.aspx              |    302 | B   | 
http://www.msn.com/   |
+----------------------------------------------+--------+-----+-----------------------+
11 rows in set (0.00 sec)


- - - - - - - - - - - - - - - - - - - - - - - - - - - -

Read the full topic here:
http://www.dataparksearch.org/cgi-bin/simpleforum.cgi?fid=05;topic_id=1193303172

Ответить