Author: dongy
Date: 2006-04-13 20:19:00 +0000 (Thu, 13 Apr 2006)
New Revision: 8545
Modified:
trunk/apps/DarknetSpiderBot/DarknetSpiderBot.php
trunk/apps/DarknetSpiderBot/class/bot.class.php
trunk/apps/DarknetSpiderBot/setup/darknetspiderbot.sql
Log:
DarknetSpiderBot:
#site_name & edition added into freesites_keys table
#function dbAddFreesite added
Modified: trunk/apps/DarknetSpiderBot/DarknetSpiderBot.php
===================================================================
--- trunk/apps/DarknetSpiderBot/DarknetSpiderBot.php 2006-04-13 19:52:43 UTC
(rev 8544)
+++ trunk/apps/DarknetSpiderBot/DarknetSpiderBot.php 2006-04-13 20:19:00 UTC
(rev 8545)
@@ -20,7 +20,7 @@
echo $bot->extractTitle();
+$bot->dbAddFreesite($splitedURL);
-
echo "\r\nDarknetSpiderBot is closing...\r\n";
?>
\ No newline at end of file
Modified: trunk/apps/DarknetSpiderBot/class/bot.class.php
===================================================================
--- trunk/apps/DarknetSpiderBot/class/bot.class.php 2006-04-13 19:52:43 UTC
(rev 8544)
+++ trunk/apps/DarknetSpiderBot/class/bot.class.php 2006-04-13 20:19:00 UTC
(rev 8545)
@@ -200,6 +200,15 @@
}
+
+ // Database processing
+ function dbAddFreesite ($splitedURL)
+ {
+ if ( $splitedURL['key_type'] != 'CHK' )
+ $splitedURL['key_type'] = 'SSK';
+
+ mysql_query("INSERT INTO freesites_keys ( key_type, key_value,
site_name, edition, created, last_update ) VALUES ('$splitedURL[key_type]',
'$splitedURL[key_value]', '$splitedURL[site_name]', '$splitedURL[edition]',
NOW(), NOW() ) ");
+ }
}
Modified: trunk/apps/DarknetSpiderBot/setup/darknetspiderbot.sql
===================================================================
--- trunk/apps/DarknetSpiderBot/setup/darknetspiderbot.sql 2006-04-13
19:52:43 UTC (rev 8544)
+++ trunk/apps/DarknetSpiderBot/setup/darknetspiderbot.sql 2006-04-13
20:19:00 UTC (rev 8545)
@@ -3,7 +3,7 @@
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
--- G?n?r? le : Jeudi 13 Avril 2006 ? 21:48
+-- G?n?r? le : Jeudi 13 Avril 2006 ? 22:15
-- Version du serveur: 4.0.20
-- Version de PHP: 4.3.4
--
@@ -39,6 +39,8 @@
`id` smallint(5) unsigned NOT NULL auto_increment,
`key_type` enum('CHK','SSK') NOT NULL default 'CHK',
`key_value` varchar(255) NOT NULL default '',
+ `site_name` varchar(255) NOT NULL default '',
+ `edition` smallint(5) unsigned NOT NULL default '0',
`created` timestamp(14) NOT NULL,
`last_update` timestamp(14) NOT NULL default '00000000000000',
PRIMARY KEY (`id`),
