View Single Post
  #3  
Old 11-13-2015, 07:55 AM
Nieth's Avatar
Nieth Nieth is offline
Aspiring
 
Join Date: Dec 2012
Location: North Carolina
Posts: 154
Gender: Male
Credits: 14,106
Nieth is on a distinguished road
Send a message via MSN to Nieth
Default

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.
Reply With Quote