PhpDig.net - View Single Post

Charter · 08-03-2005, 06:33 PM

Hmm, try the following...

First create the following table in the same database as the PhpDig tables:

Code:

CREATE TABLE blanks3 (
	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:

             $blank = addslashes(serialize($content));
             mysql_query("INSERT INTO blanks3 (blank) VALUES ('$blank')",$id_connect);

Now do one search (using the and option) on "Zealand Sustainability Database" (without the quotes) and then attach to this thread the content from the blanks3 table.

08-03-2005, 06:33 PM	#8
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hmm, try the following... First create the following table in the same database as the PhpDig tables: Code: CREATE TABLE blanks3 ( 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: $blank = addslashes(serialize($content)); mysql_query("INSERT INTO blanks3 (blank) VALUES ('$blank')",$id_connect); Now do one search (using the and option) on "Zealand Sustainability Database" (without the quotes) and then attach to this thread the content from the blanks3 table. __________________ 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.