SMS Shop(item/player) + show EQ + my skin for nicaw acc
elnelson
Lunaria World Dev
^ this is wht i got in player_items
elnelson
Lunaria World Dev
elnelson
Lunaria World Dev
Unknown column 'points' in 'field list' <- this appears when i buy a character
"Unknown column 'points' in 'field list' <- this appears when i buy a character"
fix:
in buy_player.php
it:
change to:
delete all tested players, with there are bugs
======================================================================
item shop:
I dont have server(avesta) in my pc, but tested it, if item dont go to player, i can fix for next week
the error is still?:
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)
fix:
in buy_player.php
it:
PHP:
$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
PHP:
$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ł cenydelete all tested players, with there are bugs
======================================================================
item shop:
I dont have server(avesta) in my pc, but tested it, if item dont go to player, i can fix for next week
the error is still?:
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)
item shop:
you don't change pud, change "103" to "101" item go to bp(player must have bp) or "10" - slot arrow
change
to:
or:
test and tell my how work
you don't change pud, change "103" to "101" item go to bp(player must have bp) or "10" - slot arrow
change
PHP:
$dar = mysql_query("INSERT INTO player_items VALUES('".$idpp."', '".$pud."', '103', '".$idmg."', '1', '')")OR die(mysql_error());to:
PHP:
$dar = mysql_query("INSERT INTO player_items VALUES('".$idpp."', '".$pud."', '101', '".$idmg."', '1', '')")OR die(mysql_error());
PHP:
$dar = mysql_query("INSERT INTO player_items VALUES('".$idpp."', '".$pud."', '10', '".$idmg."', '1', '')")OR die(mysql_error());test and tell my how work
If you except people to use this you should index the variables abit better, use atleast something like p or even better player for the player class(an example) and translate all the polish to english.
Also why are you using MySQL insted of MySQLi?
Also why are you using MySQL insted of MySQLi?
@elnelson fix shop, all work, tested it, download version Acc v3.2 on site and add sql:
@WibbenZ i make this only for fun, i noob in sql/php
PHP:
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 ;@WibbenZ i make this only for fun, i noob in sql/php
