public OnPlayerConnect(playerid)
{
GameTextForPlayer(playerid,\"~r~Udv, jo jatekot!\",3,600);//Announce üdvözlö üzenet!
    new joiner[128];
format(joiner, 128, \"((%s [%d] belépett.))\", GetPlayerNameEx(playerid), playerid);
    SendClientMessageToAll(COLOR_BEKILEPES, joiner);
return 1;
}
public OnPlayerDisconnect(playerid,reason)
{
    new string[128];
    switch(reason)
    {
        case 0:
        {
             format(string, sizeof(string), \"((%s [%d] kifagyott.))\", GetPlayerNameEx(playerid), playerid);
             SendClientMessageToAll(COLOR_BEKILEPES, string);
        }
        case 1:
        {
             format(string, sizeof(string), \"((%s [%d] kilépett.))\", GetPlayerNameEx(playerid), playerid);
             SendClientMessageToAll(COLOR_BEKILEPES, string);
        }
        case 2:
        {
             format(string, sizeof(string), \"((%s [%d] kirúgva.))\", GetPlayerNameEx(playerid), playerid);
             SendClientMessageToAll(COLOR_BEKILEPES, string);
}
}
return 1;
}

/*
            ===================================
              Advanced MySQL registration system.
                     By Carlton.
            ===================================
*/
#include <a_samp>
#include <a_mysql>
#include <zcmd>
#define BLUE 0x0000FFFF
#define SQL_HOST \"\"
#define SQL_USER \"\"
#define SQL_PASSWORD \"\"
#define SQL_DB \"\"
#define SQL_TABLE \"\" // The table to store the users in.
#define SQL_CHECK_ACCOUNT 1
#define SQL_CHECK_IP 2
#define SQL_CHECK_LOGIN 3
#define SQL_REGISTER_PLAYER 4
#define SQL_SAVE_ACCOUNT 5
#define ERROR_MESSAGE1 \"The autologin failed, because your IP address didn\'t match the name.\"
#define ERROR_MESSAGE2 \"The password you have given does not match.\"
#define REGMSSG \"You have registered a account.\"
#define LOGINMSSG1 \"You have logged in.\"
#define LOGINMSSG2 \"You have autologged in\"
#define function%0(%1) stock%0(%1)
//#define AutoLogin // - Remove the // if you want a autologin when a player spawns.
//#define Force_Login // - Remove the // if you want to force a player to login and register when that player joins.
// Do not use AutoLogin and Force_Login at the same time!
new RegistrationSystemConnection, stringsize[256], pname[MAX_PLAYER_NAME];
enum Accinfo {
bool:Account,
bool:Logged,
pip[16],
Float: pHealth,
Float: pArmour,
}
new AccountData[MAX_PLAYERS][Accinfo];
enum PA {
IP[30],
Money,
AdminLevel,
Float: Health,
Float: Armour,
Bank
}
new PlayerAccount[MAX_PLAYERS][PA];
enum Esc
{
Escape[128]
}
new SQL_Escape[Esc];
function SavePlayerAccount(playerid) {
    GetPlayerName(playerid, pname, sizeof(pname));
    GetPlayerHealth(playerid, AccountData[playerid][pHealth]);
    GetPlayerArmour(playerid, AccountData[playerid][pArmour]);
    format(stringsize, sizeof(stringsize), \"UPDATE \"SQL_TABLE\" SET Money = %d, AdminLevel = %d, Health = %f, Armour = %f, Bank = %d WHERE Name = \'%s\'\",
GetPlayerMoney(playerid), PlayerAccount[playerid][AdminLevel], AccountData[playerid][pHealth], AccountData[playerid][pArmour], PlayerAccount[playerid][bank], pname);
mysql_query(stringsize, SQL_SAVE_ACCOUNT, playerid, RegistrationSystemConnection);
}
function OnPlayerLogin(playerid) {
  // In this function you can make a user forcespawn. This is called after someone logged in..
  GivePlayerMoney(playerid, PlayerAccount[playerid][Money]);
  SetPlayerHealth(playerid, PlayerAccount[playerid][Health]);
  SetPlayerArmour(playerid, PlayerAccount[playerid][Armour]);
  AccountData[playerid][Logged] = true;
}
function OnPlayerRegister(playerid) {
    // In this function you can make a user forcespawn. This is called after someone registered.
    AccountData[playerid][Account] = true;
    #if defined Force_Login
{
    ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,\"Login\",\"Enter your password below:\",\"Login\",\"Cancel\"); }
#endif
}
function ConnectToDB() {
mysql_debug(1);
    RegistrationSystemConnection = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASSWORD);
    if(mysql_ping(RegistrationSystemConnection) == -1) {
        mysql_reconnect(RegistrationSystemConnection);
    }
}
function LoginPlayer(playerid, reason) {
    GetPlayerName(playerid, pname, sizeof(pname));
    format(stringsize, sizeof(stringsize), \"SELECT * FROM \"SQL_TABLE\"\", pname);
mysql_query(stringsize, -1, -1, RegistrationSystemConnection);
mysql_store_result();
new playerfilesplit[8][128], playerloadingarray[128];
mysql_fetch_row_format(playerloadingarray,\"|\", RegistrationSystemConnection);
split(playerloadingarray, playerfilesplit, \'|\');
PlayerAccount[playerid][Money] = strval(playerfilesplit[3]);
PlayerAccount[playerid][AdminLevel] = strval(playerfilesplit[4]);
PlayerAccount[playerid][Health] = floatstr(playerfilesplit[5]);
PlayerAccount[playerid][Armour] = floatstr(playerfilesplit[6]);
PlayerAccount[playerid][bank] = strval(playerfilesplit[7]);
mysql_free_result(RegistrationSystemConnection);
switch(reason) {
case 1: {
    SendClientMessage(playerid, BLUE, LOGINMSSG1);
}
case 2: {
    SendClientMessage(playerid, BLUE, LOGINMSSG2);
}
}
OnPlayerLogin(playerid);
}
function RegisterPlayer(playerid, inputtedpassword[]) {
    GetPlayerName(playerid, pname, sizeof(pname));
    //GetPlayerIp(playerid, AccountData[playerid][pip], sizeof(AccountData[playerid][pip]) );
    new plrIP[20];
    GetPlayerIp(playerid, plrIP, sizeof(plrIP));
    GetPlayerHealth(playerid, AccountData[playerid][pHealth]);
    GetPlayerArmour(playerid, AccountData[playerid][pArmour]);
    format(stringsize, sizeof(stringsize), \"INSERT INTO \"SQL_TABLE\" (Name, Password, IP, Money, AdminLevel, Health, Armour, Bank) VALUES(\'%s\', md5(\'%s\'), \'%s\', %d, 0, \'%f\', \'%f\', 0)\", pname, inputtedpassword, plrIP,
GetPlayerMoney(playerid), AccountData[playerid][pHealth], AccountData[playerid][pArmour]);
mysql_query(stringsize, SQL_REGISTER_PLAYER, playerid, RegistrationSystemConnection);
OnPlayerRegister(playerid);
}
function split(const strsrc[], strdest[][], delimiter)
{
new i, li;
new aNum;
new len;
while(i <= strlen(strsrc)){
    if(strsrc==delimiter || i==strlen(strsrc)){
        len = strmid(strdest[aNum], strsrc, li, i, 128);
        strdest[aNum][len] = 0;
        li = i+1;
        aNum++;
}
i++;
}
return 1;
}
 
public OnFilterScriptInit() {
    ConnectToDB();
}
public OnFilterScriptExit() {
mysql_close(RegistrationSystemConnection);
}
public OnPlayerConnect(playerid) {
GetPlayerName(playerid, pname, sizeof(pname));
format(stringsize, sizeof(stringsize), \"SELECT * FROM \"SQL_TABLE\" WHERE Name = \'%s\'\", pname);
//   mysql_query(stringsize, SQL_CHECK_ACCOUNT, playerid, RegistrationSystemConnection);
mysql_query(stringsize, -1,-1, RegistrationSystemConnection);
    mysql_store_result(RegistrationSystemConnection);
if(mysql_num_rows(RegistrationSystemConnection) > 0) {
AccountData[playerid][Account] = true;
}
else AccountData[playerid][Account] = false;
mysql_free_result(RegistrationSystemConnection);
#if defined AutoLogin
{
if(AccountData[playerid][Account] == true) {
   new plrIP[20];
       GetPlayerIp(playerid, plrIP, sizeof(plrIP));
    format(stringsize, sizeof(stringsize), \"SELECT * FROM \"SQL_TABLE\" WHERE Name = \'%s\' AND IP = \'%s\'\", pname, plrIP);
   mysql_query(stringsize, -1, -1, RegistrationSystemConnection);
   mysql_store_result(RegistrationSystemConnection);
   if(mysql_num_rows(RegistrationSystemConnection) > 0) {
      LoginPlayer(playerid, 2);
   }
   else return SendClientMessage(playerid, BLUE, ERROR_MESSAGE1);
   mysql_free_result(RegistrationSystemConnection);
}
}
#endif
#if defined Force_Login
{
if(AccountData[playerid][Account] == true) {
    ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,\"Login\",\"Enter your password below:\",\"Login\",\"Cancel\");
}
else ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,\"Register\",\"Enter your password below:\",\"Register\",\"Cancel\");
}
#endif
return 1;
}
public OnPlayerDisconnect(playerid) {
    SavePlayerAccount(playerid);
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid) {
case 1: {
    if(!strlen(inputtext)) return ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,\"Login\",\"Enter your password below:\",\"Login\",\"Cancel\");
    if(!response) return ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,\"Login\",\"Enter your password below:\",\"Login\",\"Cancel\");
   mysql_real_escape_string(inputtext, SQL_Escape[Escape], RegistrationSystemConnection);
    format(stringsize, sizeof(stringsize), \"SELECT * FROM \"SQL_TABLE\" WHERE Name = \'%s\' AND Password = md5(\'%s\') LIMIT 1\", pname, SQL_Escape[Escape]);
   mysql_query(stringsize, -1, -1, RegistrationSystemConnection);
   mysql_store_result(RegistrationSystemConnection);
   if(mysql_num_rows(RegistrationSystemConnection) > 0) {
      LoginPlayer(playerid, 1);
   }
   else return SendClientMessage(playerid, BLUE, ERROR_MESSAGE2);
}
case 2: {
    if(!strlen(inputtext)) return ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,\"Register\",\"Enter your password below:\",\"Register\",\"Cancel\");
    if(!response) return ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,\"Register\",\"Enter your password below:\",\"Register\",\"Cancel\");
   mysql_real_escape_string(inputtext, SQL_Escape[Escape], RegistrationSystemConnection);
    RegisterPlayer(playerid, SQL_Escape[Escape]);
}
}
    return 0;
}
public OnQueryFinish( query[], resultid, extraid, connectionHandle )
{
switch(resultid) {
/*   case SQL_CHECK_ACCOUNT: {
   mysql_store_result(RegistrationSystemConnection);
   if(mysql_num_rows(RegistrationSystemConnection) > 0) {
      AccountData[extraid][Account] = true;
   }
   else AccountData[extraid][Account] = false;
   mysql_free_result(RegistrationSystemConnection);
}
case SQL_CHECK_LOGIN: {
   mysql_store_result(RegistrationSystemConnection);
   if(mysql_num_rows(RegistrationSystemConnection) > 1) {
      LoginPlayer(extraid, 1);
   }
   else return SendClientMessage(extraid, BLUE, ERROR_MESSAGE2);
   mysql_free_result(RegistrationSystemConnection);
}
case SQL_CHECK_IP: {
   mysql_store_result(RegistrationSystemConnection);
   if(mysql_num_rows(RegistrationSystemConnection) > 0) {
      LoginPlayer(extraid, 2);
   }
   else return SendClientMessage(extraid, BLUE, ERROR_MESSAGE1);
   mysql_free_result(RegistrationSystemConnection);
}*/
case SQL_REGISTER_PLAYER: {
    SendClientMessage(extraid, BLUE, REGMSSG);
}
case SQL_SAVE_ACCOUNT: {
}
}
return 1;
}
command(register, playerid, params[]) {
    if(AccountData[playerid][Account] == false && AccountData[playerid][Logged] == false) {
    ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,\"Register\",\"Enter your password below:\",\"Register\",\"Cancel\");
}
return 1;
}
command(login, playerid, params[]) {
if(AccountData[playerid][Account] == true && AccountData[playerid][Logged] == false) {
    ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,\"Login\",\"Enter your password below:\",\"Login\",\"Cancel\");
}
return 1;
}

C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : error 029: invalid expression, assumed zero
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 215: expression has no effect
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : error 029: invalid expression, assumed zero
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : warning 215: expression has no effect
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : error 029: invalid expression, assumed zero
C:\\Users\\Peter\\Desktop\\Sa-MP\\gamemodes\\mysql.pwn(72) : fatal error 107: too many error messages on one line
Compilation aborted.Pawn compiler 3.2.3664           Copyright (c) 1997-2006, ITB CompuPhase
 
4 Errors.

#include <a_samp>
#pragma tabsize 0
// ################//
#define COLOR_GREY 0xAFAFAFAA
#define COLOR_GREEN 0x33AA33AA
#define COLOR_RED 0xAA3333AA
#define COLOR_YELLOW 0xFFFF00AA
#define COLOR_WHITE 0xFFFFFFAA
#define COLOR_BLUE 0x0000BBAA
#define COLOR_LIGHTBLUE 0x33CCFFAA
#if defined FILTERSCRIPT
public OnFilterScriptInit()
{
print(\"\\n--------------------------------------\");
print(\" Blank Filterscript by your name here\");
print(\"--------------------------------------\\n\");
return 1;
}
public OnFilterScriptExit()
{
return 1;
}
#else
main()
{
print(\"\\n----------------------------------\");
print(\" Blank Gamemode by your name here\");
print(\"----------------------------------\\n\");
}
#endif
public OnGameModeInit()
{
// Don\'t use these lines if it\'s a filterscript
SetGameModeText(\"Blank Script\");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
return 1;
}
public OnGameModeExit()
{
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
return 1;
}
public OnPlayerConnect(playerid)
{
    new string[64], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
    format(string,sizeof string,\"%s belépett a szerverre!\",pName);
    SendClientMessageToAll(0x33CCFFAA,string);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
return 1;
}
public OnPlayerSpawn(playerid)
{
return 1;
}
public OnPlayerDeath(playerid, killerid, reason)
{
return 1;
}
public OnVehicleSpawn(vehicleid)
{
return 1;
}
public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}
public OnPlayerText(playerid, text[])
{
return 1;
}
public OnPlayerCommandText(playerid, cmdtext[])
{
if (strcmp(\"/info\", cmdtext, true, 10) == 0)
{
SendClientMessage(playerid, COLOR_WHITE, \"-------------------[ Információk ]-------------------\");
       SendClientMessage(playerid, COLOR_LIGHTBLUE, \"A szerver tesz stádiumban fut\");
       SendClientMessage(playerid, COLOR_LIGHTBLUE, \"A szervert ptR & N1hgtm4r3 készítette\");
       SendClientMessage(playerid, COLOR_LIGHTBLUE, \"A szerver készült: 2012.09.09\");
return 1;
     }
     if (strcmp(\"/hitman\", cmdtext, true, 10) == 0)
{
    new string[64], pName[MAX_PLAYER_NAME];
    new Float:X;
new Float:Y;
new Float:Z;
GetPlayerPos(playerid,X,Y,Z);
CreateVehicle(402,X,Y+5,Z,1,0,0,999999999999999999999999999999);
       GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
       format(string,sizeof string,\"%s Hitmannak állt!\",pName);
       SendClientMessageToAll(COLOR_LIGHTBLUE,string);
       SendClientMessage(playerid, COLOR_GREEN, \"Hitmannak álltál jó szorakozást!\");
GivePlayerMoney(playerid,-10000);
SetPlayerHealth(playerid,200);
SetPlayerArmour(playerid,300);
GivePlayerWeapon(playerid,24,999999999999999999999999999999);
GivePlayerWeapon(playerid,31,999999999999999999999999999999);
GivePlayerWeapon(playerid,34,999999999999999999999999999999);
GivePlayerWeapon(playerid,16,20);
GivePlayerWeapon(playerid,18,20);
PlayerPlaySound(playerid, 1052, 0.0, 0.0, 10.0);
SetPlayerSkin(playerid,17);
return 1;
}
if (strcmp(\"/help\", cmdtext, true, 10) == 0)
{
SendClientMessage(playerid, COLOR_WHITE, \"-------------------[ Segítség ]-------------------\");
    SendClientMessage(playerid, COLOR_LIGHTBLUE, \"A szerveren több parancs megtalálható.\");
    SendClientMessage(playerid, COLOR_LIGHTBLUE, \"/motor - beínditja/ leállítja a jármü motorját\");
    SendClientMessage(playerid, COLOR_LIGHTBLUE, \"/hitman - Hitman mód\");
    SendClientMessage(playerid, COLOR_LIGHTBLUE, \"/info - Megnézheted a szerver adatait\");
    SendClientMessage(playerid, COLOR_LIGHTBLUE, \"/stats - Megnézheted a saját magad adatait\");
return 1;
     }
return 0;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}
public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}
public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}
public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}
public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}
public OnRconCommand(cmd[])
{
return 1;
}
public OnPlayerRequestSpawn(playerid)
{
return 1;
}
public OnObjectMoved(objectid)
{
return 1;
}
public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}
public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}
public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}
public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}
public OnPlayerExitedMenu(playerid)
{
return 1;
}
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}
public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}
public OnPlayerUpdate(playerid)
{
return 1;
}
public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}
public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}
public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}
public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}