Jump to content
  • 0

pomoc [Help] MySQL nevytváří tabulky

Michael

Dotaz vytvořil uživatel Michael,

 Share

Dotaz

Michael

Michael 4

Odesláno:
Odesláno:

Čaute, mám MySQL plugin, ale nevytváří mi v DB tabulku

 

 

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

V OnGameModeInit

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);

 

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;
}

Link to comment
Share on other sites

14 odpovědí na tuto otázku

Recommended Posts

  • 0
Michael

Michael 4

Odesláno:
  • Author
Odesláno:

Zde dokládám LOG

[*]    


[*]    
[size=1]----------[/size]    

[*]    
[size=1]Loaded log file: "server_log.txt".[/size]    

[*]    
[size=1]----------[/size]    

[*]    


[*]    
[size=1]SA-MP Dedicated Server[/size]    

[*]    
[size=1]----------------------[/size]    

[*]    
[size=1]v0.3e, ©2005-2012 SA-MP Team[/size]    

[*]    


[*]    
[size=1][20:14:55][/size]    

[*]    
[size=1][20:14:55] Server Plugins[/size]    

[*]    
[size=1][20:14:55] --------------[/size]    

[*]    
[size=1][20:14:55] Loading plugin: mysql.so[/size]    

[*]    
[size=1][20:14:55][/size]    

[*]    


[*]    
[size=1]> MySQL plugin R5 successfully loaded.[/size]    

[*]    


[*]    
[size=1][20:14:55] Loaded.[/size]    

[*]    
[size=1][20:14:55] Loaded 1 plugins.[/size]    

[*]    


[*]    
[size=1][20:14:55][/size]    

[*]    
[size=1][20:14:55] Filterscripts[/size]    

[*]    
[size=1][20:14:55] ---------------[/size]    

[*]    
[size=1][20:14:55] Loading filterscript 'flymode.amx'...[/size]    

[*]    
[size=1][20:14:55] Loaded 1 filterscripts.[/size]    

[*]    


[*]    
[size=1][20:14:55] mysql_ Ping: 0[/size]    

[*]    
[size=1][20:14:55] mysql_ Connect to the server.[/size]    

[*]    
[size=1][20:14:55] mysql_ Connection error, retrying...[/size]    

[*]    
[size=1][20:14:55] --------------------------------------[/size]    

[*]    
[size=1][20:14:55] Number of vehicle models: 3[/size]
[/list]

Link to comment
Share on other sites
  • 0
EEEE

EEEE 8

Odesláno:
Odesláno:

Načo na to public ?

 

Do OnGameModeInit si daj

 

DBStart();

 

hocikde do módu:

 

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;
}

Link to comment
Share on other sites
  • 0
Tosi

Tosi 26

Odesláno:
Odesláno: 

mysql_ [color=#660066]Connection[/color] error[color=#666600],[/color] retrying[color=#666600]...[/color]

 

Podľa tohoto sa nemôže pripojiť k serveru.

Link to comment
Share on other sites
  • 0
Michael

Michael 4

Odesláno:
  • Author
Odesláno: 

mysql_ [color=#660066]Connection[/color] error[color=#666600],[/color] retrying[color=#666600]...[/color]

 

Podľa tohoto sa nemôže pripojiť k serveru.

Nepovídej :d
Link to comment
Share on other sites
  • 0
Tosi

Tosi 26

Odesláno:
Odesláno:

Skús si vytvoriť jednoduchý script na výpis z jednej tabulky. Hľadaj chybu vylučovacou metódou. Pawn neovládam takže ti inak nepomôžem.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Přejít na seznam dotazů
×
×
  • Create New...