You must first be a
registered member to view any code.
This is a little script im working on for my lockdown. the only problem is that it doesnt work. somehow it gives a strange error (im using vb3.0.4)
table:
CREATE TABLE `lockdown_settings` (
`option` varchar(40) NOT NULL default '',
`value` int(10) NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO `lockdown_settings` VALUES ('lockdown_enabled', 0);
INSERT INTO `lockdown_settings` VALUES ('lockdown_counters', 0);
the value should be changed from 0 to 1
the error:
Invalid SQL: SELECT * FROM lockdown_settings WHERE option=lockdown_enabled
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'option=lockdown_enabled' at line 1
i hope someone can help me out here