[adithegman]

Errors!! Please help me, I copied everything from the tutorial...

Code:

C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(67) : error 017: undefined symbol "mysql"
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(67) : error 017: undefined symbol "host"
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(68) : error 017: undefined symbol "mysql"
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : error 001: expected token: ";", but found "-identifier-"
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : error 017: undefined symbol "Name"
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : warning 215: expression has no effect
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : error 001: expected token: ";", but found "]"
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


7 Errors.

Lines With the errors:

Code:

public OnGameModeInit()
{
	mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG); 
    mysql = mysql_connect(host, user, db, pass);  // Line 67
    if(mysql_errno(mysql) != 0) print("Could not connect to database!"); // Line 68
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	return 1;
}

public OnPlayerConnect(playerid)
{
    new query[128]
    GetPlayerName(playerid, Name[playerid], 24); // Line 89
    GetPlayerIp(playerid, IP[playerid], 16);
    mysql_format(mysql, query, sizeof(query),"SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1", Name[playerid]);
    mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);
	return 1;
}

I already have these defined:

Code:

#define host    "localhost" 
#define user    "root" 
#define db      "server" 
#define pass    "" 

//dialogs
#define dregister    6287 //dialog register id
#define dlogin        6288 // ^

static
    mysql, //This variable will be used to manage our database
    Name[MAX_PLAYERS][24], //We will use this variable to store player's name.
    IP[MAX_PLAYERS][16] //We will use this variable to store player's ip.
    ;
    
native WP_Hash(buffer[], len, const str[]); 


enum PDATA
{
    ID, 
    Password[129], 
    Admin, 
    VIP,
    Money, 
    Float:posX, 
    Float:posY, 
    Float:posZ

}
new pInfo[MAX_PLAYERS][PDATA]; //Variable that stores enumerator above