Threaded Mode | Linear Mode

admin_teclis · 08-14-2012 01:09 AM

Hi everyone, I have a problem with connecting to Mysql...

I followed the example of a user I found with the search button.

Report the script:

PHP Code:

sub-zero Wrote:
Code:
---- sphere.ini ----
// MySql configuration.
MYSQL=1
MySqlHost=127.0.0.1
MySqlUser=root
MySqlPassword=
MySqlDatabase=sphere


Code:
---- sphere_serv_triggers.scp ----
// This function is called on server startup
[FUNCTION f_onserver_start]
f_sphere_MySQL_connect


Code:
---- sphere_MySQL.scp ----
[Function f_sphere_MySQL_connect]
DB.CONNECT
IF ( <DB.CONNECTED> )
    SERV.LOG "Connection with MySQL...        [ OK ]"
ELSE
    MySqlDatabase=mysql
    DB.CONNECT
    DB.EXECUTE "CREATE DATABASE IF NOT EXISTS `sphere`"
    DB.EXECUTE "USE `sphere`"
    MySqlDatabase=sphere
    serv.f_sphere_MySQL_connect
    //SERV.LOG "Connection with MySQL...        [ FAILED ]"
ENDIF 

But it did not appear in the log file it in the console status ok.
Obviously I did not even create the table ...
We carry the script made by me to create the table:

PHP Code:

DB.EXECUTE "create table demo ( 
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
account VARCHAR(50),
name VARCHAR(50),
guild TEXT,
kills INT,
fame INT,
karma INT
);" 

What's wrong?

Threaded Mode \| Linear Mode Mysql not connected
Author	Message