21.08.2011, 18:21
Sorry for dubbel,dubbel post, but i now whats wrong, but how can i fix it?
Query:
(%s = the name of the player.)
Error:
Database:
Query:
Quote:
SELECT skin, Adminlevel, money, bank, level, exp, xpos, ypos, zpos, apos, tut FROM users WHERE name = '%s' LIMIT 1 |
Error:
Quote:
[20:17:48] CMySQLHandler::Query(SELECT skin, adminlevel, money, bank, level, exp, xpos, ypos, zpos) - An error has occured. (Error ID: 1054, Unknown column 'skin' in 'field list') |
Quote:
CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(225) NOT NULL, `password` text NOT NULL, `skin` int(5) NOT NULL DEFAULT '101', `adminlevel` enum('0','1','2','3','4','5','6','7','1337','1338' ) NOT NULL DEFAULT '0', `ip` varchar(20) NOT NULL, `money` int(225) NOT NULL DEFAULT '5000', `bank` int(225) NOT NULL DEFAULT '2500', `level` int(10) NOT NULL DEFAULT '1', `exp` int(10) NOT NULL DEFAULT '0', `xpos` float NOT NULL DEFAULT '1685.84', `ypos` float NOT NULL DEFAULT '-2333.34', `zpos` float NOT NULL DEFAULT '-2.6797', `apos` float NOT NULL DEFAULT '1.4551', `tut` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; |