Help with database / web page!!

[derkonsito]

Hi im making the web page for my ot server but im having this problem:

My server stores everything in the S3DB file like shown in the picture attached and it dosent updates nothing in the sql!! So i made my web page, i create chars in the page but they all go to sql file and server just like dosent even uses it !! Help please!!

 

[Limos]

Follow this tutorial.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

 

[DevvMio]

Have you put sqlType to mysql in the config.lua?
sqlType = "mysql"

 

[derkonsito]

Follow this tutorial.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

bro im getting a error with that video tutorial in the part of the database :/ it says

" Failed to connect to databas. Mysql error: Cant connect to mysql server on "local host" _10061_

 

[DevvMio]

Have you started apache and MySQL? If you have, then have you made sure your config.lua is set up correctly?

 

[derkonsito]

Ok i made everything now my only problem is that i hate that map !! I have a map i love is it possible to add it? i added it but it says there is a problem with the realglobal-house and the realglobal-spawn !!

 

[DevvMio]

Check the config for the website. It might be needed to change map directory. So it can find the new map and its house info. I don't know about the spawn problem though. Or it could be that you have forgotten to add the spawn and house files with the map.

 

[Limos]

You can just replace the map in data/world. Then open config.lua and chang the mapname to the name of the map you added. Make sure you also add the spawn and house file of the map you added.
If you have errors, post the exact error.

 

[derkonsito]

Help please!!!!!
I got this map from other server i runned so it works!! the problem is that the forgotten server dosent runs it
@Limos

 

[Limos]

Already tried to use the same items.otb as in that server (if it's the same client version)?
If it's not the same client version, set the map in Remere to the client version your server uses (Map, Properties).

 

[derkonsito]

Already tried to use the same items.otb as in that server (if it's the same client version)?
If it's not the same client version, set the map in Remere to the client version your server uses (Map, Properties).

Yes its the same !! I changed the otbs and it says that it cannot load the otb

 

[Limos]

Try to use the item.otb of your server in Remere, then save that map with that items.otb.

 

[derkonsito]

It says that a newer version of otb is required but both ots are 9.81 :O ?
@Limos

 

[Limos]

You can just ignore that message, it can say that if the map is saved with a different items.otb.

 

[Root Groves]

Hello people! I'm in trouble big time and wondering if any of you would be willing to help me out!

I get this error when trying to set admin account to database. "Fatal error: Call to a member function fetch() on a non-object in /home/otsmanager/www/public_html/classes/account.php on line 33"

Illl copy down the piece of code if you are interested in helping! WOULD BE APPRECIATED

 

[Limos]

Go to index.php, set DEBUG_DATABASE false to true to see the error.

define('DEBUG_DATABASE', true);

Next time, create a new thread if you don't have the same problem as the creator of the thread.

 

[Root Groves]

Ok I'll do that

Nothing happened when I entered that one. Sorry

 

[Limos]

You can to find that with ctrl f and than change false to true.
But you can also post the line (line 33) of the script.

 

[Root Groves]

public function load($search_text, $search_by = self::LOADTYPE_ID)
    {
        if(in_array($search_by, self::$fields))
            $search_string = $this->getDatabaseHandler()->fieldName($search_by) . ' = ' . $this->getDatabaseHandler()->quote($search_text);
        else
            new Error_Critic('', 'Wrong Account search_by type.');
        $fieldsArray = array();
        foreach(self::$fields as $fieldName)
            $fieldsArray[$fieldName] = $this->getDatabaseHandler()->fieldName($fieldName);
        $this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();
    }

this is the code on that line where the bug must be.

 

[derkonsito]

@Limos

Same error i entered remeres saved the thing and didnt worked :/ !!