Alchemy Mod - HoF

[Nieth]

Yeah, I wanted to just add it with PHPMyAdmin but they won't let me have access to it on my host.

I edited:

PHP Code:

$adopts->query("CREATE TABLE ".constant("PREFIX")."alchemy (alid int NOT NULL AUTO_INCREMENT PRIMARY KEY, item int DEFAULT 0, item2 int DEFAULT 0, newitem int DEFAULT 0, chance int DEFAULT 0, recipe int DEFAULT 0)"); 


to

PHP Code:

$adopts->query("CREATE TABLE ".constant("PREFIX")."alchemy (alid int NOT NULL AUTO_INCREMENT PRIMARY KEY, item int DEFAULT 0, item2 int DEFAULT 0, item3 int DEFAULT 0, newitem int DEFAULT 0, chance int DEFAULT 0, recipe int DEFAULT 0)"); 


to add the column during install, shouldn't that have worked?

Also, my site now has three different 'Recipe' options when giving a type to an item. I would just clear out the alchemy table(s) on my database if they'd let me have access to it, but I'm at a loss as to what to do now.