Re: [Help] MySQL Error

[Michael]

Čaute, skouším gamemode, ale používám MySQL plugin (http://forum.sa-mp.com/showthread.php?t ... G-sTyLeZzZ), ale když nahodím server píše Unknown a v logu stojí

Kód: Vybrať všetko

[19:33:49] Server Plugins
[19:33:49] --------------
[19:33:49]  Loading plugin: mysql.so
[19:33:49]   Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
[19:33:49]  Loaded 0 plugins.


Každá rada pomůže

[Riso135]

čítaj skype

[tinostar91]

Predpokladám že máš Win a nie Linux takže skôr použi mysql.dll(windows library) a nie mysql.so(čiže linux library).

[Riso135]

nie má linux server, a ja som mu s tým pomohol a vyriešil to čiže - /LOCK

[Michael]

Není , ese 1 problémeček, nevytváří tabulku v DB

[EEEE]

Ukáž riadky pripojenia k DB a vytváranie tabuliek

[Michael]

Kód: Vybrať všetko

#define SQL_HOST "db.crew-servers.com"
#define SQL_USER "51461_sampreg"
#define SQL_PASS "**********"
#define SQL_DB     "Truck"


Kód: Vybrať všetko

MySQLConnect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
mysql_query("CREATE TABLE IF NOT EXISTS slot1(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot2(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot3(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot4(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot5(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot6(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot7(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot8(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot9(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot10(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(24), IP VARCHAR(15), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city VARCHAR(24), truckselect VARCHAR(24), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20), Slot1Saved INT(20), Slot2Saved INT(20), Slot3Saved INT(20), Slot4Saved INT(20), Slot5Saved INT(20), Slot6Saved INT(20), Slot7Saved INT(20), Slot8Saved INT(20), Slot9Saved INT(20), Slot10Saved INT(20))");
mysql_debug(1);


Kód: Vybrať všetko

forward MySQLConnect(sqlhost[], sqluser[], sqldb[], sqlpass[]);
public MySQLConnect(sqlhost[], sqluser[], sqldb[], sqlpass[])
{
    print("mysql_ Probiha propojeni k DB Serveru.");
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    if(mysql_ping()==1)
    {
        print("mysql_ Spojeni navazano.");
        return 1;
    }
    else
    {
        print("mysql_ Chyba pri pripojeni, opakuji akci...");
        mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
        if(mysql_ping()==1)
        {
            print("mysql_ Uspesne pripojeno, muzeme pokracovat.");
            return 1;
        }
    }
    return 1;
}


[EEEE]

A máš to v OnGameModeInit ?

[Michael]

Ano mám

[KarTooN]

Já bych to udělal takto

Kód: Vybrať všetko

mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
mysql_query("CREATE TABLE IF NOT EXISTS slot1(user VARCHAR(24), boss INT NOT NULL, level INT NOT NULL upgrade INT NOT NULL, language INT NOT NULL, city INT NOT NULL, truckselect INT NOT NULL, km INT NOT NULL, PosX FLOAT NOT NULL, PosY FLOAT NOT NULL, PosZ FLOAT NOT NULL)");


to ostatní podle předchozího a bez mysql_debug

[EEEE]

Načo na to public ?

Do OnGameModeInit si daj

Kód: Vybrať všetko

DBStart();


hocikde do módu:

Kód: Vybrať všetko

stock DBStart()
{
#define SQL_HOST "db.crew-servers.com"
#define SQL_USER "51461_sampreg"
#define SQL_PASS "*************************"
#define SQL_DB "Truck"

connection = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
if (!connection)
{
     printf("[ Error ] Nepodarilo sa nadviazať spojenie s databázou !");
     return SendRconCommand("exit");
}

mysql_query("CREATE TABLE IF NOT EXISTS slot1(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot2(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot3(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot4(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot5(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot6(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot7(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot8(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot9(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS slot10(user VARCHAR(24), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city INT(20), truckselect INT(20), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20))");
mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(24), IP VARCHAR(15), boss INT(20), level INT(20), upgrade INT(20), language INT(20), city VARCHAR(24), truckselect VARCHAR(24), km INT(20), PosX INT(20), PosY INT(20), PosZ INT(20), Slot1Saved INT(20), Slot2Saved INT(20), Slot3Saved INT(20), Slot4Saved INT(20), Slot5Saved INT(20), Slot6Saved INT(20), Slot7Saved INT(20), Slot8Saved INT(20), Slot9Saved INT(20), Slot10Saved INT(20))");



return 1;
}