Mysidia Adoptables Support Forum - Mys 1.3.4 Alchemy Mod

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Mys v1.3.x Mods (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=42)

- - Mys v1.3.4 Alchemy Mod (http://www.mysidiaadoptables.com/forum/showthread.php?t=4368)

Well I've had the idea of working on an alchemy system since the initial Mys v1.3.0 release, but did not carry out for numerous reasons. Now I finally decided to give it a try and it took me only about 4-5 hours.

The idea of Alchemy is to mix two old items(called ingredients) to create a new item, which is normally rarer and more valuable(otherwise it does not justify the economics lol). The Alchemy Mod allows you to achieve just that, you can create some items that are rare or even impossible to obtain without performing alchemy. This will make your site considerably more interesting to a good number of your users, it also offers incentives for the act of item collection.

Below is a screenshot of the basic alchemy page, which allows you to choose two items to produce a new one. Note at this time being only two items can be used to produce a new item, there is no way to mix more than two:
http://oi57.tinypic.com/2lxckkg.jpg

This mod also comes with ACP integration, in which the admins can create alchemy practices that allow users to create new items from the old ones. Admins can also manipulate the settings for Alchemy System on their sites. The entire system can be turned on/off at will, while admins can specify whether alchemy success chance is 100% always or less. Other settings such as cost of action, recipe/license requirement for performing alchemy are also configurable.

To install the mod, simply run the installer script located at yoursite.com/install/alchemy.php. If your site is in a subdirectory, just change the example url accordingly. I assume you all know what I mean by this so I wont explain further.

If you have a brand new site or have never ever modified any part of the script, you may simply download the .rar file I provided and uploading them to your server through ftp. If the only changes you made are the mods I've offered lately(gender ratio and item drop), you may give a try just uploading the files as well as good chance my mods are compatible with each other.

However, for advanced users who have heavily modified sites, you will need to make some changes manually. I will post a brief description on how to do that in the next post.

At last, I hope you enjoy the new mod I've made for Mys v1.3.4, unlike the old ones like gender ratio which were simply revised to be compatible with the new version. You can edit the alchemy system to as you wish, maybe altering its user interface or adding more functionality(such as multiple item mix rather than just two), its all up to you.

Hall of Famer

For advanced users who have heavily modified sites, you may follow the procedure below to install this mod on your site. Ignore this post if your site works fine with simply uploading/overwriting files.

First of all, upload and run the installer script at yoursite.com/install/alchemy.php. This step is identical for all users, unless you wish to create tables/insert rows into database manually, but will be a pain with this mod.

Second, upload the following new files to your server. Most of these files do not exist in the base script so you wont run into file overwriting problems. The new files are:
/admincp/alchemy.php
/admincp/view/alchemyview.php
/classes/class_alchemy.php
/classes/class_alchemysetting.php
/classes/class_alchemyvalidator.php
/lang/admincp/lang_alchemy.php

You may do the same for the lang file: lang_inventory.php since I assume nobody has ever modified it. If the answer is opposite however, you may wish to search through the differences of the two lang files to see how to append new lang vars to your site. It shouldnt be difficult.

Alright then, in the next step you will need to modify some old script files. I hope you are ready. Now go to file /classes/class_adminsidebar.php and find these line:

PHP Code:


		
			
        $components->add(new Division(new Comment("Inventory", FALSE)));
        $inventory = new Division;
        $inventory->add(new Link("admincp/inventory/add", "Give Item to User"));
        $inventory->add(new Link("admincp/inventory/edit", "Edit User Inventory"));
        $inventory->add(new Link("admincp/inventory/delete", "Delete Users items"));
        $components->add($inventory);

Add below:

PHP Code:


		
			
        $components->add(new Division(new Comment("Alchemy", FALSE)));
        $alchemy = new Division;
        $alchemy->add(new Link("admincp/alchemy/add", "Create new Alchemy Practice"));
        $alchemy->add(new Link("admincp/alchemy/edit", "Edit Alchemy Practices"));
        $alchemy->add(new Link("admincp/alchemy/delete", "Remove Alchemy Practices"));
        $alchemy->add(new Link("admincp/alchemy/settings", "Change Alchemy Settings"));        
        $components->add($alchemy);

Next, go to file /classes/class_itemtablehelper.php and find the constructor:

PHP Code:


		
			
    public function __construct(){
        parent::__construct();      
    }

insert these two methods right below the constructor definition:

PHP Code:


		
			
    /**
     * The getItem method, fetches the item type.
     * @param int  $item
     * @access public
     * @return String
     */    
    public function getItem($item){
        if(empty($item)) return "N/A";
        else return $item;        
    }
    
    /**
     * The getItemImage method, fetches the item image.
     * @param id  $item
     * @access public
     * @return Image
     */
    public function getItemImage($item){    
        $item = new Item($item);
        $image = new Image($item->imageurl, $item->itemname);
        return $image;            
    }

Then go to script file /inventory.php and find the method toss() at:

PHP Code:


		
			
    public function toss(){
        $mysidia = Registry::get("mysidia");
        $item = new PrivateItem($mysidia->input->post("itemname"), $mysidia->user->username);  
        if($item->iid == 0) throw new ItemException("toss_none");
        
        if($mysidia->input->get("confirm")){
            $item->toss();
            return;
        }        
    }

Add a new method alchemy() right below it:

PHP Code:


		
			
    
    public function alchemy(){
        $mysidia = Registry::get("mysidia");
        $settings = new AlchemySetting($mysidia->db);
        if($settings->system == "disabled") throw new ItemException("alchemy_disabled");
        
        if($mysidia->input->post("iid") and $mysidia->input->post("iid2")){
            $alchemy = new Alchemy($mysidia->input->post("iid"), $mysidia->input->post("iid2"), $settings);
            $alchemy->mix();
            $this->setField("alchemy", $alchemy);
            return;
        }
        
        $stmt = $mysidia->db->select("inventory", array("iid", "itemname"), "owner = '{$mysidia->user->username}'");
        $map = $mysidia->db->fetchMap($stmt);
        $this->setField("itemMap", $map);
        $this->setField("settings", $settings);
    }

Now open the file /view/inventoryview.php and find these lines:

PHP Code:


		
			
        $mysidia = Registry::get("mysidia");
        $document = $this->document;
        $document->setTitle($mysidia->lang->inventory);

Add the three new lines below:

PHP Code:


		
			
        $document->addLangvar("You may manage these items as you like, or go to the alchemy page to make your own items: <br>");    
        $document->add(new Link("inventory/alchemy", "Use the Alchemy Service Now!"));    
        $document->add(new Comment("<br><br>"));

Next, find the toss() method at:

PHP Code:


		
			
    
    public function toss(){
        $mysidia = Registry::get("mysidia");
        $document = $this->document;
        if($mysidia->input->get("confirm")){
            $document->setTitle($this->lang->global_action_complete);
            $document->addLangvar("{$this->lang->toss}{$mysidia->input->post("itemname")}{$this->lang->toss2}");
            return;
        }
    
        $document->setTitle($this->lang->toss_confirm);
        $document->addLangvar($this->lang->toss_warning);    

        $confirmForm = new FormBuilder("confirmform", "toss/confirm", "post");
        $confirmForm->buildPasswordField("hidden", "action", "toss")
                    ->buildPasswordField("hidden", "itemname", $mysidia->input->post("itemname"))
                    ->buildButton("Please Toss", "confirm", "confirm");
        $document->add($confirmForm);            
    }

Append the alchemy() method right below it:

PHP Code:


		
			
    public function alchemy(){
        $mysidia = Registry::get("mysidia");
        $document = $this->document;
        
        if($mysidia->input->post("iid") and $mysidia->input->post("iid2")){
            $alchemy = $this->getField("alchemy");
            $newitem = $alchemy->getNewItem()->itemname;
            $document->setTitle($this->lang->alchemy_success);
            $document->addLangvar($this->lang->alchemy_newitem.$newitem.$this->lang->alchemy_newitem2);    
            return;        
        }

        $document->setTitle($this->lang->alchemy_title);
        $document->addLangvar($this->lang->alchemy);
        $itemMap = $this->getField("itemMap");
        $settings = $this->getField("settings");
        $alchemyFrom = new Form("alchemyform", "alchemy", "post");
        $alchemyFrom->add(new Comment("<b>Cost of performing Alchemy: {$settings->cost} {$mysidia->settings->cost}</b><br>"));
        
        $alchemyFrom->add(new Comment($mysidia->lang->alchemy_choose));        
        $items = new DropdownList("iid");
        $items->add(new Option("None Selected", "none"));
        if($itemMap->size() > 0){
            $iterator = $itemMap->iterator();
            while($iterator->hasNext()){
                $item = $iterator->nextEntry();
                $items->add(new Option($item->getValue(), $item->getKey()));
            }
        }        
        $alchemyFrom->add($items);

        $alchemyFrom->add(new Comment($mysidia->lang->alchemy_choose2));        
        $items2 = new DropdownList("iid2");
        $items2->add(new Option("None Selected", "none"));
        if($itemMap->size() > 0){
            $iterator = $itemMap->iterator();
            while($iterator->hasNext()){
                $item2 = $iterator->nextEntry();
                $items2->add(new Option($item2->getValue(), $item2->getKey()));
            }
        }        
        $alchemyFrom->add($items2);        
        $alchemyFrom->add(new Button("Let's mix the items now!", "submit", "submit"));
        $document->add($alchemyFrom);        
    }

At last, open the file /functions/functions_items.php and add a new function to the bottom of the script(right above the php closing tag). It does not really do anything other than preventing some kind of bugs/error messages from possibly emerging:

PHP Code:


		
			
function items_recipe($item, $adopt){
  $note = "The item {$item->itemname} is a recipe item, which cannot be used on any adoptable and can only be useful if you are performing alchemy.";
  return $note;
}

You are done with the modifications now, it was easier than you thought right? Anyway you may run into some problems, and in this case please post in this thread to let me know. I will find out where the errors are and fix them for you as soon as I get a chance.

Simply amazing HOF =)
Thanks, might do something like this for evolution stones or something

I don't suppose it'd be possible to also share a .zip file? I can't work with .rar files :(

Sure I can, although an .rar file is not that hard to work with if you download winrar.

Oh thanks. ^^ I hope this will be a valuable tiny little addition to your site.

Yeh that is an awesome idea, I wanted something like that on mine ages ago, but I think my coders on hiatus and my photoshops been refusing to work, and I've been busy so I havent had much time for it. ^_^' I know I was playing with the idea of using a system like this to create potions, or make jewellery and trinkets, ect. Is there any chance of this being compatible with older versions of Mysidia? >.>'

What version of Mysidia Adoptables are you using? It shouldnt be difficult to get it to work with Mys v1.3.3, but not sure for even older versions.

Lol I'm sticking with 1.3.2... unless I go insane and try to upgrade. XD I was alright until I lost contact with my coder... I'm just praying nothing breaks now. >.>' And its okay if its too hard or difficult, I'll just have to either figure out something else, or just not do it. ^_^'

EDIT: My coders still around! :D She's just busy working on her own site, she said she'll take a quick look at this sometime. ^_^

Okay, uploaded everything and tried to run the installer, but ran into this;

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/ferrepet/public_html/classes/class_initializer.php on line 97

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/ferrepet/public_html/classes/class_initializer.php on line 97

Fatal error: require(): Failed opening required '../inc/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/ferrepet/public_html/classes/class_initializer.php on line 97

This is strange, the url rewrite must be malfunctioning on your site. Do you have a .htaccess file in your install folder? If not, create an empty .htaccess file and upload it.

No, I'll go ahead and try it.

Oh btw, the htaccess.txt file in MyBB forum can also be used here. Just rename it as .htaccess and upload it to the install folder if you dont have one in the install directory. The mysidia root directory uses url rewrite, but the install and forum directories do not.

Uploaded an empty .htaccess file but I am still getting this error;

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/ferrepet/public_html/classes/class_initializer.php on line 97

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/ferrepet/public_html/classes/class_initializer.php on line 97

Fatal error: require(): Failed opening required '../inc/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/ferrepet/public_html/classes/class_initializer.php on line 97

I made sure that the file was a .htaccess and not a .txt or anything like that (notepad sometimes messes with that).

umm this... I remember you had a similar problem when you were installing the script, I forgot how it was resolved. Do you still remember that? And if you dont mind, send me a PM about your site ftp info and Id like to take a look on why your server is malfunctioning on .htaccess.

(late reply)
No, don't remember it, unfortunately. I'm having some problems connecting remotely to my site's FTP (something's wrong with the host), so I'll be changing hosts eventually (when I find an affordable one) and then will see about getting this to work again.

I see, thats unfortunate. Is there a way you get the FTP to work? Lemme know if I can do anything to help you.

(Hopefully my questions make sense. I'm still a bit of a noob when it comes to coding and I'm having issues wording things correctly today)

I'm also having the same issue as Abronsyth with installing this mod. I had similar issues with uploading and installing the gender ratio and item drop mods, but when I manually installed those, it worked fine. Is there a way to fix the issue that's been coming up with this mod that's been discovered (and if so, I'd love to know what so I can add this mod as well!)? If not, what are the tables I need to create so I can manually install this one?

for those who can't create the database here is the manual install/creation or whatever you want to call it:
just use the "SQL" and copy/paste/change the following codes (remember to change `your_database` for your database name, and if you changed the adopts prefix, remember to change it too to the one you are using):

Code:

INSERT INTO `Your_database`.`adopts_acp_hooks` (`id`, `linktext`, `linkurl`, `pluginname`, `pluginstatus`) VALUES ('null', 'Alchemy Plugin v1.3.4 by Hall of Famer', 'http://www.mysidiaadoptables.com/forum/showthread.php?t=4368','alchemy', 'null')

Code:

INSERT INTO `Your_database`.`adopts_items_functions` (`ifid`, `function`, `intent`, `description`) VALUES ('null', 'recipe', 'no','This item function defines items that acts as recipe for alchemy practices.')

Code:

CREATE TABLE `adopts_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)

Code:

CREATE TABLE `adopts_alchemy_settings` (asid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(20), value varchar(40))

Code:

INSERT INTO `Your_database`.`adopts_alchemy_settings` (`asid`, `name`, `value`) VALUES ('1', 'system', 'enabled'), ('2', 'chance', 'enabled'), ('3', 'recipe', 'enabled'), ('4', 'cost', '500'), ('5', 'license', ''), ('6', 'usergroup', 'all')

Please take in mind that this is how it worked for me, im using x10hosting and probably you will have to change/edit something, to make it work.
EDIT:
If you have no idea where to add the codes... I made a failed attempt of tutorial, but it will give you the idea of what to do and where to add the codes:
http://i581.photobucket.com/albums/s...orialthing.png for me is in spanish, but most of the phpadmins are kind of similar

another thing i noticed, while looking at the intall is that the "INT" in most or all of the codes are not in Caps "int" probably this is one of the reasons the install is not working.

hope this help for those who want to install the mod.

by the way: IT WORKS!! THANKS HOF!!!!

I am glad the mod is working for everyone, minus the headache of installation. I did beta-test the mod extensively before releasing it, so guess it helps somehow. I aint quite sure why auto-installer aint working for some of you, I will see if theres anything I can do.

dont worry HOF, for me it was good that the installer dint work ^^ now i know how to insert and create tables XD. and like you said in your first post ._O it was a pain to add them, specially for someone like me that knows too little about coding and creating/inserting/adding tables to a database >_> But for the same reason i decided to add the codes that worked for me to install manually the tables to the database, maybe it will help those who are like me =)

By the way for me the installer only showed a blank page and nothing else... maybe because i used the solution to remove the warnings that appeared in the admin cp...

I am also having trouble installing this mod ^_^''

This is the warning:

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/ycadopts/public_html/classes/class_initializer.php on line 97

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/ycadopts/public_html/classes/class_initializer.php on line 97

Fatal error: require(): Failed opening required '../inc/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/ycadopts/public_html/classes/class_initializer.php on line 97

I tried the installation thing with the tables that kristhasirah said but it didn't work.. not sure what to do XD Help? ^_^

Are you using Mys v1.3.4? If so, take a screenshot of the folder structure as it appears on your FTP client and I will see what the error may be.

Yes I do use the latest version, but what do you mean by 'folder structure'? Do you mean just snapshot an image of the folders? Because I can do that but I'm confused by what you mean XD

i tested the codes again and they are working, i even created a new database just for that, but if you still have troubles using the codes i posted for installing the tables manually, try installing them 1 by 1 , because if you try to install them all at the same time you must add a: ; at the end of each code
example: CREATE TABLE `adopts_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);
also remember to change the "your_database" with the name of your database
and if your tables have a different "prefix" and not "adopts_" you must change that too

Oh, OK. I shall try that then! (I did them all at the same time ^_^'') I have just made a copy of my site for testing so now I won't ruin the actual one. So let's see if this works.. XD

EDIT: No... it still won't work.. I keep getting this:

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/calamit2/public_html/classes/class_initializer.php on line 97

Warning: require(../inc/config.php): failed to open stream: No such file or directory in /home/calamit2/public_html/classes/class_initializer.php on line 97

Fatal error: require(): Failed opening required '../inc/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/calamit2/public_html/classes/class_initializer.php on line 97

I don't know if it'll help or not, but here is the class_initializer file:

PHP Code:


		
			
<?php



use \Resource\Native\Object;

use \Resource\Native\String;



/**

 * The Initializer Class, it is responsible for the basic bootstraping of the system.

 * It handles basic Loader, Registry, System Object creation, further operations are delegated to Mysidia System Class.

 * This is a final class, cannot be extended by any child classes.

 * @category Resource

 * @package Utility

 * @author Hall of Famer 

 * @copyright Mysidia Adoptables Script

 * @link http://www.mysidiaadoptables.com

 * @since 1.3.3

 * @todo Not much at this point.

 * @final

 *

 */



final class Initializer extends Object{



    /**

     * The dir property, defines relative directory for Bootstraping process.

     * @access private

     * @var String

    */

    private $dir; 



    /**

     * The uri property, stores a reference of the URI from server variables.

     * @access private

     * @var String

    */

    private $uri;   



    /**

     * Constructor of Initializer Class, it delegates to the method initialize() to complete the request.

     * @access public

     * @return Void

     */

    public function __construct(){

        $this->setURI();

        $this->setDir();

        $this->initialize();

    }



    /**

     * The getUri method, getter method for property $uri

     * @access public

     * @return Void

     */

    public function getUri(){

        return $this->uri;

    } 



    /**

     * The setUri method, setter method for property $uri

     * The property is set upon Initializer object instantiation, cannot be called from external class.

     * @access private

     * @return Void

     */

    private function setUri(){

        $this->uri = $_SERVER['REQUEST_URI'];

    }   



    /**

     * The getDir method, getter method for property $dir

     * @access public

     * @return Void

     */

    public function getDir(){

        return $this->dir;

    } 



    /**

     * The setDir method, setter method for property $dir

     * The property is set upon Initializer object instantiation, cannot be called from external class.

     * @access private

     * @return Void

     */

    private function setDir(){

        if(strpos($this->uri, "admincp") !== FALSE or strpos($this->uri, "install") !== FALSE){

            $this->dir = "../";

        }

        else $this->dir = "";

    }   



    /**

     * The initialize method, carries out the basic bootstraping steps.

     * It opens config file first, then include basic files and instantiate important objects.

     * @access private

     * @return Void

     */

    private function initialize(){

        $config = "{$this->dir}inc/config.php";

        require $config;



        include("{$this->dir}functions/functions.php");

        include("{$this->dir}functions/functions_users.php");



        $loader = "{$this->dir}classes/class_loader.php";

        require $loader;

        $loader = new Loader($this->dir);



        $registry = Registry::getInstance();

        Registry::set(new String("loader"), $loader, TRUE, TRUE);

        

        $mysidia = new Mysidia;        

        $router = new Router($this->uri);

        $router->route();

        $dispatcher = new Dispatcher($router);

        $dispatcher->dispatch();



        $wol = new Online;

        $wol->update();

        Registry::set(new String("wol"), $wol);

    }

}

?>

Is there maybe something wrong with it? (That's what the warning seems to say... but I dunno XD)

I know I keep asking for help, but this is the only way I'll learn how to solve issues if I run into them in the future XD (Plus it's a great way of learning basic coding skills hehehe)

Are you trying to install the mod by using the installer? because your problem is like the one Abronsyth had/has when tried to run the installer.php :http://www.mysidiaadoptables.com/for...9&postcount=11
The codes i posted are the ones that the installer is supposed to install, so you dont need to run the installer script, just make the edits and upload the required files to make the mod work.

edit:
I did a completely manual Install, because when i tried to run the installer i got a blank page and right now is working without problems or errors.

Oooh! So i just ignore the install folder and manually install everything else? I can try that! Thanks!

Yes, if you used the codes i posted then you already have installed the tables you need for the mod and now just need to edit the pages and add the files, and the mod will be working without problems =)

Nope, it still won't work... where do you insert the table codes? Because I have tried all the files and the only one that I can find is the alchemy.php file in the install folder. But it has the install thing in it and won't work if I just put it into the public html folder...

i might just create the tables manually... do you know what I need to put in each box? (Like NULL etc.) I tried a moment ago but the silly thing kept popping up with an error (I don't know everything to put in the boxes.. what values etc.)

EDIT:

Well, i think I may be figuring it out. I am entering the table things into the manual creation thing in x10 hosting and now I am trying to get the lines to work and get the codes creating the table. But it keeps coming up with errors..

EDIT 2:

Yay! It worked! Thank you! I got it working ^_^

=D im glad that is working for you now!!!
sorry for my failed attempt of explaining how to add the codes in the database, English is not my native language, but i will add some pictures of where to add the codes in the database

OK XD It actually turned out it has created a blank database >.< But now that all the other boxes are gone and the only ones left are asid, name and value, I'm hoping it'll work! I am almost finished, so I'll edit this if it works or not... I'm hoping it will XD

EDIT:

Yep! It worked! :D Thanks! And you didn't do too badly with explaining, I just understand little to no coding at all XD So I am trying to learn, but I am only, like, a teenager so... XD I am attempting to pick bits up though so that I will be able to do things like this in future! (Without too much help :P)

well i made a failed attempt of tutorial for those that have no idea of how to add or create a table in the database... i was like that at first... and still have problems, so probably i will be coming back to see my failed attempt in a near future, as i usually forget how i added or edited something >_>"

http://i581.photobucket.com/albums/s...orialthing.png
this is how i add them to the database, if you are using x10hosting when you open phpmyadmin you must click the name of your database is the one down of information_schema, that way you are sure that you are adding creating and inserting the info in the correct database

the first 2 inserts are the ones i think they can give you problems, but is easy to add the values manually,
just click the the adopts_acp_hooks, wait for the table to load and click insert/insertar, it will open a new window and just add this:
first box leave it blank
2nd: Alchemy Plugin v1.3.4 by Hall of Famer
3rd: http://www.mysidiaadoptables.com/for...ead.php?t=4368
4th: alchemy
5th: null
For the second insert do the same: click adpts_items_functions, click insert/insertar, wait for the new window and add the following info
First box: leave it blank
2nd: recipe
3rd: no
4th: This item function defines items that acts as recipe for alchemy practices.

the other 3 are working, i tested them 3 times in a new database, but like i say make sure you have selected the database you are using for your site.

Edit:

Glad to know is now working for you ^_^ !!!

Yeah, I use x10 hosting. XD And it wouldn't insert the items into the settings database so I was lucky that it created a blank one (the adopts_alchemy_settings thing) as then it was easy to go through and add them myself by adding values XD And I'm sure the tutorial will help a few others who are stuck! :D

I'm having problems with the alchemy mod. I installed everything but when I try to create a new alchemy, it throws this at me after clicking submit: Database error 1146 - Table 'chibifur_chibifurs.adopts_alchemy' doesn't exist

I went through all the files and they are all configured properly.

Are you using adopts_ as your table prefix in your database?

And to make sure, did you create the tables first? This post a few pages back helps.

Yeah. adopts is the prefix. Thought it would be a bit confusing later if I had changed it so I left it as it was.

I just tried the codes and the last one failed.
It refuses to insert contents into the adopts_alchemy_settings table.

The adopts_alchemy table is created and has the contents.
The adopts_alchemy_settings is created and has no contents.

I use x10 hosting as well.

The code to insert contents into the adopts_alchemy_settings table says this error:
#1142 - INSERT command denied to user 'chibifur'@'localhost' for table 'adopts_alchemy_settings'

Sorry if it's not clear. I'm not very good with formatting things.

Well, hmmm. While Google implies this is normally a permissions issue, I also had trouble using the supplied SQL commands to insert data into the table on my own server (tested just now).

So I took a look at it. I visited the database and hit SQL to create the table first -

Code:

CREATE TABLE `adopts_alchemy_settings` (asid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(20), value varchar(40))

Then went into the table and hit SQL again to insert the data there -

Code:

INSERT INTO `adopts_alchemy_settings` (`asid`, `name`, `value`) VALUES (1, 'system', 'enabled'), (2, 'chance', 'enabled'), (3, 'recipe', 'enabled'), (4, 'cost', '500'), (5, 'license', ''), (6, 'usergroup', 'all')

http://fc08.deviantart.net/fs71/f/20...as-d892d6q.gif

I changed the formatting only slightly? And it seemed to help. But the order of operations I think is what really helped, rather than doing it all from the front of the database - to do it while already visiting the table. Try that with the others, too?

I've got it to finally do the job now. Oddly I didn't do anything different and it worked.
Alchemy is completely functional. Tested and verified.

Only a few more issues to work on like the failing gender ratio and figuring out to add an explore system with chances of getting items, pets and coins and then my site should be ready for visitors.

On a side note, How did you make that gif? It's really clever and useful o see what to do almost live.