#include    <a_samp>
#include    <a_mysql>
#include    <sscanf2>

#define     DB_HOST         "LocalHost"
#define     DB_USER         "root"
#define     DB_BASE         "test"
#define     DB_PASSWORD     ""

#define     D_REGISTER      1
#define     D_LOGIN         2

#define     CWHITE         "{FFFFFF}"
#define     CRED           "{ARWRWR}"
#define     C_SERVER        0xFFF255AA

#define     PASSWORD        DIALOG_STYLE_PASSWORD
#define     INPUT           DIALOG_STYLE_INPUT

enum pFile
{
    pUserName[34],
    pPassWord[34],
    pScore,
    pMoney,
    pAdmin
}
new pI[MAX_PLAYERS][pFile];

main()
{
    print("\n----------------------------------");
    print(" RicaNiel Property ");
    print("----------------------------------\n");
}

stock playername(playerid)
{
    new pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid,pName,sizeof(pName));
    return pName;
}

public OnGameModeInit()
{
    SetGameModeText("Blank Script");
    AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
    mysql_debug(1);
    mysql_connect(DB_HOST,DB_USER,DB_BASE,DB_PASSWORD);

    return 1;
}

public OnGameModeExit()
{
    mysql_debug(0);
    mysql_close();
    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 data[100],string[500];
    format(data,sizeof(data),"SELECT `test` FROM `User` WHERE `Username`='%s'",playername(playerid));
    mysql_query(data);
    if(mysql_num_rows()>0)
    {
        format(string,sizeof(string),""CWHITE"This account is already Registred\n\nUser:"CRED"%s"CWHITE"\n\nPlese Enter Your Password Bellow To Login",playername(playerid));
        ShowPlayerDialog(playerid,D_LOGIN,PASSWORD,""CWHITE"RicaNiel - Login System",string,"Login","Cancel");
    }
    else
    {
        ShowPlayerDialog(playerid,D_REGISTER,INPUT,""CWHITE"RicaNiel - Register System","That account is not registred\n\nPlease Type a password to register an account","Login","Cancel");
    }
    mysql_free_result();
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    switch(dialogid)
    {
        case D_REGISTER:
        {
            if(!response) return Kick(playerid);
            if(response)
            {
                if(strlen(inputtext) == 0)  return ShowPlayerDialog(playerid,D_REGISTER,INPUT,""CWHITE"RicaNiel - Register System","That account is not registred\n\nPlease Type a password to register an account","Login","Cancel");
                new passwordtext[60];
                new data[100];
                mysql_real_escape_string(inputtext, passwordtext);
                format(data,sizeof(data),"INSERT INTO `Users` (Username,Password,Score,Money,Admin) VALUE ('$s','%s','0','0','0')",playername(playerid),passwordtext);
                mysql_query(data);
                SendClientMessage(playerid,C_SERVER,"SERVER:"CWHITE" You have succesfully registred a new account");
            }
        }
        
        case D_LOGIN:
        {
            if(!response) return Kick(playerid);
            if(response)
            {
                if(strlen(inputtext) == 0) return ShowPlayerDialog(playerid,D_LOGIN,PASSWORD,""CWHITE"RicaNiel - Login System","Please Enter The Account Password","Login","Cancel");
                new passwordtext[60];
                new data[100];
                mysql_real_escape_string(inputtext,passwordtext);
                format(data,sizeof(data),"SELECT * FROM `Users` WHERE `Username` = '%s' AND `Password` = '%s'",playername(playerid),passwordtext);
                mysql_query(data);
                mysql_free_result();
                if(mysql_num_rows() <0)
                {
                    new ldata[100];
                    format(ldata,sizeof(ldata),"SELECT * FROM `Users` WHERE `Username` = '%s' ",playername(playerid));
                    mysql_query(ldata);
                    mysql_store_result();
                    mysql_fetch_row_format(ldata,"|");
                    sscanf(ldata,"e<p<|>s[24]s[23]i>",pI[playerid]);
                    mysql_free_result();
                    GivePlayerMoney(playerid,pI[playerid][pMoney]);
                }
                else
                {
                    ShowPlayerDialog(playerid,D_LOGIN,PASSWORD,""CWHITE"RicaNiel - Login System","Please Enter The "CRED"CORREECT"CWHITE" Account Password","Login","Cancel");
                }
                mysql_free_result();
            }
        }
    }
    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}

SA-MP Dedicated Server
----------------------
v0.3d-R2, ©2005-2011 SA-MP Team

[22:20:16] filterscripts = ""  (string)
[22:20:16] 
[22:20:16] Server Plugins
[22:20:16] --------------
[22:20:16]  Loaded 0 plugins.

[22:20:16] 
[22:20:16] Filterscripts
[22:20:16] ---------------
[22:20:16]   Loaded 0 filterscripts.

[22:20:16] Script[gamemodes/dan.amx]: Run time error 19: "File or function is not found"
[22:20:16] Number of vehicle models: 0

plugins mysql

plugins mysql.so

public OnPlayerConnect(playerid)
{
    new data[100],string[500];
    format(data,sizeof(data),"SELECT * FROM `User` WHERE `Username` = '%s' LIMIT 1", playername(playerid));
    mysql_query(data);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(rows == 1){
        format(string,sizeof(string),""CWHITE"This account is already Registred\n\nUser:"CRED"%s"CWHITE"\n\nPlese Enter Your Password Bellow To Login",playername(playerid));
        ShowPlayerDialog(playerid,D_LOGIN,PASSWORD,""CWHITE"RicaNiel - Login System",string,"Login","Cancel");
    }else{
        ShowPlayerDialog(playerid,D_REGISTER,INPUT,""CWHITE"RicaNiel - Register System","That account is not registred\n\nPlease Type a password to register an account","Login","Cancel");
    }
    mysql_free_result();
    return 1;
}