Revision 596
Added by thorn almost 18 years ago
| upgrade-script.php | ||
|---|---|---|
| 61 | 61 |
*/ |
| 62 | 62 |
function db_add_search_key_value($key, $value) {
|
| 63 | 63 |
global $database; global $OK; global $FAIL; |
| 64 |
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = '$key' LIMIT 1");
|
|
| 64 |
$table = TABLE_PREFIX.'search'; |
|
| 65 |
$query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1");
|
|
| 65 | 66 |
if($query->numRows() > 0) {
|
| 66 | 67 |
echo "$key: allready there. $OK.<br />"; |
| 67 | 68 |
return true; |
| 68 | 69 |
} else {
|
| 69 |
$database->query("INSERT INTO ".TABLE_PREFIX."search (name,value,extra) VALUES ('$key', '$value', '')");
|
|
| 70 |
$database->query("INSERT INTO $table (name,value,extra) VALUES ('$key', '$value', '')");
|
|
| 70 | 71 |
echo mysql_error()?mysql_error().'<br />':''; |
| 71 |
$query = $database->query("SELECT value FROM ".TABLE_PREFIX."search WHERE name = '$key' LIMIT 1");
|
|
| 72 |
$query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1");
|
|
| 72 | 73 |
if($query->numRows() > 0) {
|
| 73 | 74 |
echo "$key: $OK.<br />"; |
| 74 | 75 |
return true; |
| ... | ... | |
| 349 | 350 |
|
| 350 | 351 |
} |
| 351 | 352 |
|
| 353 |
/********************************************************** |
|
| 354 |
* - asp - Advanced Spam Protection |
|
| 355 |
*/ |
|
| 356 |
echo "<br /><u>Adding table mod_captcha_control</u><br />"; |
|
| 357 |
$table = TABLE_PREFIX.'mod_captcha_control'; |
|
| 358 |
$database->query("DROP TABLE IF EXISTS `$table`");
|
|
| 359 |
$database->query("CREATE TABLE `$table` (
|
|
| 360 |
`enabled_captcha` VARCHAR(1) NOT NULL DEFAULT '1', |
|
| 361 |
`enabled_asp` VARCHAR(1) NOT NULL DEFAULT '1', |
|
| 362 |
`captcha_type` VARCHAR(255) NOT NULL DEFAULT 'calc_text', |
|
| 363 |
`asp_session_min_age` INT(11) NOT NULL DEFAULT '20', |
|
| 364 |
`asp_view_min_age` INT(11) NOT NULL DEFAULT '10', |
|
| 365 |
`asp_input_min_age` INT(11) NOT NULL DEFAULT '5' |
|
| 366 |
)" |
|
| 367 |
); |
|
| 368 |
$database->query("
|
|
| 369 |
INSERT INTO `$table` |
|
| 370 |
(`enabled_captcha`, `enabled_asp`, `captcha_type`) |
|
| 371 |
VALUES |
|
| 372 |
('1', '1', 'calc_text')
|
|
| 373 |
"); |
|
| 352 | 374 |
|
| 353 | 375 |
|
| 354 | 376 |
//****************************************************************************** |
Also available in: Unified diff
added new CAPTCHA and ASP (Advanced Spam Protection)