Unknown column 'points' in 'field list' <- this appears when i buy a character@specx error adding player to store
Cannot add or update a child row: a foreign key constraint fails (`veridicot`.`bans`, CONSTRAINT `bans_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `players` (`id`) ON DELETE SET NULL)
$buy2 = mysql_query("UPDATE players SET points = 0 WHERE id = '$id' AND name = '$name'")OR die(mysql_error()); //zmienia points, gracz nie będzie miał ceny
$buy2 = mysql_query("UPDATE players SET price = 0 WHERE id = '$id' AND name = '$name'")OR die(mysql_error()); //zmienia points, gracz nie będzie miał ceny
$dar = mysql_query("INSERT INTO player_items VALUES('".$idpp."', '".$pud."', '103', '".$idmg."', '1', '')")OR die(mysql_error());
$dar = mysql_query("INSERT INTO player_items VALUES('".$idpp."', '".$pud."', '101', '".$idmg."', '1', '')")OR die(mysql_error());
$dar = mysql_query("INSERT INTO player_items VALUES('".$idpp."', '".$pud."', '10', '".$idmg."', '1', '')")OR die(mysql_error());
ALTER TABLE `accounts` ADD `points` int(11) NOT NULL;
ALTER TABLE `accounts` ADD `points_history` int(11) NOT NULL;
ALTER TABLE `players` ADD `shop` int(11) NOT NULL;
ALTER TABLE `players` ADD `price` int(11) NOT NULL;
CREATE TABLE IF NOT EXISTS `shop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`info` text NOT NULL,
`price` int(11) NOT NULL,
`image` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
CREATE TABLE IF NOT EXISTS `quest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`storage` int(11) NOT NULL,
`questname` varchar(20) NOT NULL,
`lvl` int(11) NOT NULL,
`desc` text NOT NULL,
`rew` text NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;