you forgot to change the pill names when you copy and pasted in the sql file

ALTER TABLE accounts ADD bluepill int(11) unsigned not null default '0';
ALTER TABLE accounts ADD redpill int(11) unsigned not null default '0';
ALTER TABLE accounts ADD blackpill int(11) unsigned not null default '0';
ALTER TABLE accounts ADD charmstore tinyint(11) unsigned not null default '0';


you had blue pill 3 times

few other things...
in redsale, blacksale, and blue sale you have if pills>10, which means that they have to have 11 pills to sell.  so change that to 9, and then it wont give them the error "you only have 10 pills you do not have enough"  

and in pillcheck and pill_sell you have the navigation to knock them back to the village, they should just return to the love shop.

One thing I noticed which is even though you run out of turns you can still create pills. Needs to check turns as well as check charm.

Adding a turn checker doesn't really change much. As you can tell, it takes your turns per pill anyway.