View Single Post
Old 07-23-2005, 04:34 PM   #4
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Something got out of sync. Maybe info was deleted from the database directly instead of from the admin panel?

Try the following. First create the following table in the same database as the PhpDig tables:
Code:
CREATE TABLE blanks (
	blank TEXT DEFAULT '' NOT NULL
);
Then in search_function.php find:
Code:
             $query = "SELECT sites.site_url, sites.port, spider.path,spider.file,spider.first_words,sites.site_id,spider.spider_id,spider.last_modified,spider.md5 "
                      ."FROM ".PHPDIG_DB_PREFIX."spider AS spider, ".PHPDIG_DB_PREFIX."sites AS sites "
                      ."WHERE spider.spider_id=$spider_id AND sites.site_id = spider.site_id";
             $result = mysql_query($query,$id_connect);
             $content = mysql_fetch_array($result,MYSQL_ASSOC);
And afterwards add the following:
Code:
             if (empty($content['site_url'])) {
                      $blank = addslashes(serialize($content));
                      mysql_query("INSERT INTO blanks (blank) VALUES ('$blank')",$id_connect);
             }
Now do some searches, and then attach to this thread about ten rows from the blanks table so I can have a look-see.
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote