Zaključano

[Pomoc]MYSQL prebacivanje u YSI TD

Započeo Sarkenzo
pre 8 godina
2,103
pregleda
6
postova
Ova tema je zaključana. Samo moderatori i administratori mogu odgovarati.
Sarkenzo
Shot Caller
pre 8 godina
Skripta koju koristim:
Detaljan opis:Kako prebaciti register and login system iz MYSQL u YSI
Dio skripte:

#include //SA-MP Team

#include //BlueG                                                      Version R41: https://github.com/pBlueG/SA-MP-MySQL/releases/tag/R41

#include //Y_Less                                                    Version 2.8.2: https://github.com/maddinat0r/sscanf/releases/tag/v2.8.2

#include //ZeeX                                                          Version 0.3.1 https://github.com/YashasSamaga/I-ZCMD - (Note: Rename izcmd to zcmd and done).

/*==============================================================================
Global Settings
==============================================================================*/

#if !defined MAX_LOGGIN_ATTEMPTS
#define MAX_LOGGIN_ATTEMPTS            (5)
#endif

#if !defined MIN_LENGTH_PASSWORD
#define MIN_LENGTH_PASSWORD            5
#endif

#if !defined MAX_LENGTH_PASSWORD
#define MAX_LENGTH_PASSWORD            20
#endif

#if !defined MIN_DATE_YEAR
#define MIN_DATE_YEAR                  (1850)
#endif

#if !defined MAX_DATE_YEAR
#define MAX_DATE_YEAR                  (2017)
#endif

#if !defined MAX_REGISTER_TEXTDRAWS
#define MAX_REGISTER_TEXTDRAWS          (22)
#endif

#if !defined MAX_LOGGIN_TEXTDRAWS
#define MAX_LOGGIN_TEXTDRAWS (4)
#endif

#if !defined COLOR_LOGGIN_TD_HOVERING
#define COLOR_LOGGIN_TD_HOVERING (0x00C100FF)
#endif

#if !defined COLOR_REGISTER_TD_HOVERING
#define COLOR_REGISTER_TD_HOVERING      (0xFF000085)
#endif

new MySQL:handle;

enum //dialog enum
{
DIALOG_INFO,
DIALOG_REGISTER,
DIALOG_LOGIN,
DIALOG_SELECT_GENDER,
DIALOG_SELECT_DATE_YEAR,
DIALOG_SELECT_DATE_MONTH,
DIALOG_SELECT_DATE_DAY
};

new
PlayerText:LogginTextDraw,
PlayerText:RegisterTextDraw;

/*==============================================================================
Internal functions
==============================================================================*/

static ReturnPlayerName(playerid)
{
new string;
GetPlayerName(playerid, string, MAX_PLAYER_NAME);
return string;
}

/*==============================================================================
Public functions
==============================================================================*/

public OnFilterScriptInit()
{
handle = mysql_connect("host", "user", "password", "database");

if (mysql_errno(handle))
{
    print(": Failed to connect mysql database.");
}
else
{
    mysql_query(handle, "CREATE TABLE IF NOT EXISTS `users` (`id` int(11) NOT NULL AUTO_INCREMENT, `username` text NOT NULL, `password` text NOT NULL, `gender` int(1) NOT NULL DEFAULT '1', `birthdate` text NOT NULL, `skin` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;", false);

    print(": Success connect to mysql database.");
}
return 1;
}

public OnFilterScriptExit()
{
if (mysql_errno(handle) == 0) mysql_close(handle);

for (new i, len = GetPlayerPoolSize(); i <= len; i++)
{
    if (!IsPlayerConnected(i)) continue;
   
    OnPlayerDisconnect(i, 1);
}
return 1;
}

public OnPlayerConnect(playerid)
{
new
    Cache:cache, rows, query[81 +MAX_PLAYER_NAME];

format(query, sizeof(query), "SELECT * FROM `users` WHERE `username` COLLATE latin1_general_cs = '%q' LIMIT 1", ReturnPlayerName(playerid));
cache = mysql_query(handle, query, true);

cache_get_row_count(rows);

if (! rows)
{
    if (SetPVarInt(playerid, "RegisterTextDraws", 1))
    {
RegisterTextDraw = CreatePlayerTextDraw(playerid, 277.400085, 101.399917, "box");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 25.012474);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 512.106445, 0.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 133);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 144.900054, 98.800018, "");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 0.000000);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 124.000000, 207.772872);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 153);
PlayerTextDrawFont(playerid, RegisterTextDraw, 5);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetPreviewModel(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetPreviewRot(playerid, RegisterTextDraw, 0.000000, 0.000000, 0.000000, 1.000000);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 207.199340, 313.302551, "PlayerName");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.298000, 1.483332);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, -0.649999, 120.680145);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 2);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 133);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 366.000000, 116.000000, "box");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 2.149996);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 504.000000, 20.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 252645375);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 320.000000, 118.000000, "Password:");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 2);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 320.500000, 157.301635, "Gender:");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 2);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 366.000000, 154.000305, "box");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 2.149996);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 504.000000, 20.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 252645375);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 320.000000, 194.503906, "Birth Date:");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 2);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 366.000000, 192.902679, "box");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 2.149996);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 504.000000, 20.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 252645375);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 374.499420, 156.800048, "N/A");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 374.000000, 196.283126, "Year");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 366.000000, 224.004577, "box");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 2.149996);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 504.000000, 20.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 252645375);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 373.799957, 226.783096, "Month");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 366.000000, 254.506439, "box");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 2.149996);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 504.000000, 20.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 252645375);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 374.200012, 257.683105, "Day");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 481.000000, 311.743896, "Sign Up");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.229497, 1.214998);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 12.000000, 46.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 2);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawUseBox(playerid, RegisterTextDraw, 1);
PlayerTextDrawBoxColor(playerid, RegisterTextDraw, 6815816);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 336.797363, 286.388488, "SKIN:");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.279000, 1.401664);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 2);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 378.400756, 286.685028, "ld_beat:left");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 0.000000);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 12.000000, 16.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 4);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 473.406555, 286.685028, "ld_beat:right");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.000000, 0.000000);
PlayerTextDrawTextSize(playerid, RegisterTextDraw, 12.000000, 16.000000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 4);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, RegisterTextDraw, true);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 431.900238, 287.416778, "0");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.400000, 1.600000);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 2);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);

RegisterTextDraw = CreatePlayerTextDraw(playerid, 368.800292, 122.633346, "[]");
PlayerTextDrawLetterSize(playerid, RegisterTextDraw, 0.191495, 1.057499);
PlayerTextDrawAlignment(playerid, RegisterTextDraw, 1);
PlayerTextDrawColor(playerid, RegisterTextDraw, -1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
PlayerTextDrawSetOutline(playerid, RegisterTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, RegisterTextDraw, 255);
PlayerTextDrawFont(playerid, RegisterTextDraw, 2);
PlayerTextDrawSetProportional(playerid, RegisterTextDraw, 1);
PlayerTextDrawSetShadow(playerid, RegisterTextDraw, 0);
    }
if (SetPVarInt(playerid, "CurrentPreviewModel", 0))
{
    SetPVarInt(playerid, "Gender", -1);
   
    SetPVarInt(playerid, "BirthDateDay", -1);
    SetPVarInt(playerid, "BirthDateYear", -1);
    SetPVarInt(playerid, "BirthDateMonth", -1);
}

if (GetPVarInt(playerid, "RegisterTextDraws"))
{
    PlayerTextDrawSetString(playerid, RegisterTextDraw, ReturnPlayerName(playerid));
   
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
    PlayerTextDrawShow(playerid, RegisterTextDraw);
   
    SelectTextDraw(playerid, COLOR_REGISTER_TD_HOVERING);
}
}
else
{
    if (SetPVarInt(playerid, "LogginTextDraws", 1))
    {
LogginTextDraw = CreatePlayerTextDraw(playerid, 254.499908, 103.666770, "");
PlayerTextDrawLetterSize(playerid, LogginTextDraw, 0.000000, 0.000000);
PlayerTextDrawTextSize(playerid, LogginTextDraw, 131.000000, 190.000000);
PlayerTextDrawAlignment(playerid, LogginTextDraw, 1);
PlayerTextDrawColor(playerid, LogginTextDraw, -1);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);
PlayerTextDrawSetOutline(playerid, LogginTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, LogginTextDraw, 153);
PlayerTextDrawFont(playerid, LogginTextDraw, 5);
PlayerTextDrawSetProportional(playerid, LogginTextDraw, 0);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);
PlayerTextDrawSetPreviewModel(playerid, LogginTextDraw, 1);
PlayerTextDrawSetPreviewRot(playerid, LogginTextDraw, 0.000000, 0.000000, 0.000000, 1.000000);

LogginTextDraw = CreatePlayerTextDraw(playerid, 320.300109, 303.167022, "PlayerName");
PlayerTextDrawLetterSize(playerid, LogginTextDraw, 0.400000, 1.600000);
PlayerTextDrawTextSize(playerid, LogginTextDraw, 0.000000, 127.419876);
PlayerTextDrawAlignment(playerid, LogginTextDraw, 2);
PlayerTextDrawColor(playerid, LogginTextDraw, -1);
PlayerTextDrawUseBox(playerid, LogginTextDraw, 1);
PlayerTextDrawBoxColor(playerid, LogginTextDraw, 153);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);
PlayerTextDrawSetOutline(playerid, LogginTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, LogginTextDraw, 255);
PlayerTextDrawFont(playerid, LogginTextDraw, 2);
PlayerTextDrawSetProportional(playerid, LogginTextDraw, 1);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);

LogginTextDraw = CreatePlayerTextDraw(playerid, 256.899993, 322.599914, "box");
PlayerTextDrawLetterSize(playerid, LogginTextDraw, 0.000000, 2.222089);
PlayerTextDrawTextSize(playerid, LogginTextDraw, 383.920013, 0.000000);
PlayerTextDrawAlignment(playerid, LogginTextDraw, 1);
PlayerTextDrawColor(playerid, LogginTextDraw, -1);
PlayerTextDrawUseBox(playerid, LogginTextDraw, 1);
PlayerTextDrawBoxColor(playerid, LogginTextDraw, 133);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);
PlayerTextDrawSetOutline(playerid, LogginTextDraw, 0);
PlayerTextDrawBackgroundColor(playerid, LogginTextDraw, 255);
PlayerTextDrawFont(playerid, LogginTextDraw, 1);
PlayerTextDrawSetProportional(playerid, LogginTextDraw, 1);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);

LogginTextDraw = CreatePlayerTextDraw(playerid, 320.799957, 324.949707, "SIGN IN");
PlayerTextDrawLetterSize(playerid, LogginTextDraw, 0.305999, 1.290832);
PlayerTextDrawTextSize(playerid, LogginTextDraw, 10.000000, 113.000000);
PlayerTextDrawAlignment(playerid, LogginTextDraw, 2);
PlayerTextDrawColor(playerid, LogginTextDraw, -1);
PlayerTextDrawUseBox(playerid, LogginTextDraw, 1);
PlayerTextDrawBoxColor(playerid, LogginTextDraw, -2139062017);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);
PlayerTextDrawSetOutline(playerid, LogginTextDraw, 1);
PlayerTextDrawBackgroundColor(playerid, LogginTextDraw, 255);
PlayerTextDrawFont(playerid, LogginTextDraw, 2);
PlayerTextDrawSetProportional(playerid, LogginTextDraw, 1);
PlayerTextDrawSetShadow(playerid, LogginTextDraw, 0);
PlayerTextDrawSetSelectable(playerid, LogginTextDraw, true);
    }
   
    new password[MAX_LENGTH_PASSWORD +1], birthdate[11 +1], gender, previewmodel;
   
    cache_get_value_name(0, "password", password);
    cache_get_value_name(0, "birthdate", birthdate);

    cache_get_value_name_int(0, "gender", gender);
    cache_get_value_name_int(0, "skin", previewmodel);
   
    new day, month, year;
    sscanf(birthdate, "piii", day, month, year);
   
    SetPVarInt(playerid, "Gender", gender);
   
    SetPVarInt(playerid, "BirthDateDay", day);
    SetPVarInt(playerid, "BirthDateMonth", month);
    SetPVarInt(playerid, "BirthDateYear", year);

    SetPVarString(playerid, "Password", password);
   
    SetPVarInt(playerid, "LoggedInPlayer", -1);
    SetPVarInt(playerid, "LogginAttempts", 0);

    PlayerTextDrawSetPreviewModel(playerid, LogginTextDraw, previewmodel);
    PlayerTextDrawSetString(playerid, LogginTextDraw, ReturnPlayerName(playerid));
   
for (new i; i < MAX_LOGGIN_TEXTDRAWS; i++)
{
    PlayerTextDrawShow(playerid, LogginTextDraw);
}

SelectTextDraw(playerid, COLOR_LOGGIN_TD_HOVERING);
}

cache_delete(cache);

return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
if (GetPVarInt(playerid, "RegisterTextDraws"))
{
    for(new i; i < MAX_REGISTER_TEXTDRAWS; i++)
    {
        PlayerTextDrawHide(playerid, RegisterTextDraw);
        PlayerTextDrawDestroy(playerid, RegisterTextDraw);
    }
}
if (GetPVarInt(playerid, "LogginTextDraws"))
{
    for(new i; i < MAX_LOGGIN_TEXTDRAWS; i++)
    {
        PlayerTextDrawHide(playerid, LogginTextDraw);
        PlayerTextDrawDestroy(playerid, LogginTextDraw);
    }
}
SetPVarInt(playerid, "Password", EOS);

SetPVarInt(playerid, "Gender", -1);

SetPVarInt(playerid, "BirthDateDay", -1);
SetPVarInt(playerid, "BirthDateMonth", -1);
SetPVarInt(playerid, "BirthDateYear", -1);

SetPVarInt(playerid, "LogginAttempts", -1);
SetPVarInt(playerid, "CurrentPreviewModel", -1);

SetPVarInt(playerid, "RegisterTextDraws", -1);
SetPVarInt(playerid, "LogginTextDraws", -1);

SetPVarInt(playerid, "LoggedInPlayer", -1);
SetPVarInt(playerid, "LogginAttempts", 0);

return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
    case DIALOG_REGISTER:
    {
        if (response == 1)
        {
            if (!(MIN_LENGTH_PASSWORD <= strlen(inputtext) <= MAX_LENGTH_PASSWORD))
            {
                new string;

                format(string, sizeof(string), "{FFFFFF}Enter your password then hit \"Submit\".\n\n \
                                                {DC143C}ERROR: Invalid password length, must be (b/w: %d/%d)", MIN_LENGTH_PASSWORD, MAX_LENGTH_PASSWORD);

ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "{FFFF66}Register: {FFFFFF}Password", string, "Submit", "Close");
            }
            else
            {
                new string[20 +1];
                for (new i, len = strlen(inputtext); i < len; i++)
                {
                    if (i < 10) strcat(string, "[]");
                }

                if (SetPVarString(playerid, "Password", inputtext))
                {
                PlayerTextDrawSetString(playerid, RegisterTextDraw, string);
                PlayerTextDrawShow(playerid, RegisterTextDraw);
                }
            }
        }
    }
    case DIALOG_LOGIN:
    {
        if (response == 1)
        {
            SetPVarInt(playerid, "LogginAttempts", (GetPVarInt(playerid, "LogginAttempts") +1));
           
            if (!(MIN_LENGTH_PASSWORD <= strlen(inputtext) <= MAX_LENGTH_PASSWORD))
            {
                if (GetPVarInt(playerid, "LogginAttempts") == MAX_LOGGIN_ATTEMPTS) return Kick(playerid);
               
                new string;

                format(string, sizeof(string), "ERROR: Invalid password length, must be (correct length: %d/%d)", MIN_LENGTH_PASSWORD, MAX_LENGTH_PASSWORD);
                SendClientMessage(playerid, 0xDC143CFF, string);
               
                format(string, sizeof(string), "{FFFFFF}Enter your password then hit \"Submit\"\n\n \
                                                Error: Insert your correct password{DC143C}(attempts: %d/%d)", GetPVarInt(playerid, "LogginAttempts"), MAX_LOGGIN_ATTEMPTS);

ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "{FFFF66}Login In: {FFFFFF}Insert your password", string, "Submit", "Close");

PlayerPlaySound(playerid, 1085, 0.00, 0.00, 0.00);
            }
            else
            {
                new password[MAX_LENGTH_PASSWORD +1];
                GetPVarString(playerid, "Password", password, MAX_LENGTH_PASSWORD);

                if (!strcmp(inputtext, password, false))
                {
                    if (GetPVarInt(playerid, "LogginTextDraws"))
                    {
                        CancelSelectTextDraw(playerid);
                   
                        for (new i; i < MAX_LOGGIN_TEXTDRAWS; i++)
                        {
                            PlayerTextDrawHide(playerid, LogginTextDraw);
                            PlayerTextDrawDestroy(playerid, LogginTextDraw);
                        }
                        SetPVarInt(playerid, "LogginTextDraws", -1);
                       
                        if (SetPVarInt(playerid, "LoggedInPlayer", 1))
                        {
                        SendClientMessage(playerid, 0x00FF00FF, "Welcome Back!");
                        }
                    }
                }
                else
                {
                    if (GetPVarInt(playerid, "LogginAttempts") == MAX_LOGGIN_ATTEMPTS) return Kick(playerid);
                   
                    new string;

                    format(string, sizeof(string), "{FFFFFF}Enter your password then hit \"Submit\"\n\n \
Error: Insert your correct password{DC143C}(attempts: %d/%d)", GetPVarInt(playerid, "LogginAttempts"), MAX_LOGGIN_ATTEMPTS);

ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "{FFFF66}Login In: {FFFFFF}Insert your password", string, "Submit", "Close");

PlayerPlaySound(playerid, 1085, 0.00, 0.00, 0.00);
                }
            }
        }
    }
    case DIALOG_SELECT_GENDER:
    {
        if (response == 1)
        {
            if (SetPVarInt(playerid, "Gender", (listitem +1)))
            {
            PlayerTextDrawSetString(playerid, RegisterTextDraw, (listitem > 0) ? ("Female"):("Male"));
            }
        }
    }
    case DIALOG_SELECT_DATE_DAY:
    {
        if (response == 1)
        {
            if (GetPVarInt(playerid, "BirthDateMonth") == -1)
            {
                ShowPlayerDialog(playerid, DIALOG_INFO, DIALOG_STYLE_MSGBOX, "{FFFF66}Register: {DC143C}Error:", "{FFFFFF}- Please; first select a month for your birth date", "Close", "");
               
                PlayerPlaySound(playerid, 1085, 0.00, 0.00, 0.00);
            }
            else
            {
                if (SetPVarInt(playerid, "BirthDateDay", (listitem +1)))
                {
                    new string[2 +1];

                    format(string, sizeof(string), "%i", (listitem +1));
                    PlayerTextDrawSetString(playerid, RegisterTextDraw, string);
                }
            }
        }
    }
    case DIALOG_SELECT_DATE_MONTH:
    {
        if (response == 1)
        {
            new month;
       
            switch (listitem)
            {
                case 0: month = "January";
                case 1: month = "February";
                case 2: month = "March";
                case 3: month = "April";
                case 4: month = "May";
                case 5: month = "June";
                case 6: month = "July";
                case 7: month = "August";
                case 8: month = "September";
                case 9: month = "October";
                case 10: month = "November";
                case 11: month = "December";
               
                default: month = "Unknown: ERROR";
            }
           
            PlayerTextDrawSetString(playerid, RegisterTextDraw, month);
           
            SetPVarInt(playerid, "BirthDateMonth", (listitem +1));
        }
    }
    case DIALOG_SELECT_DATE_YEAR:
    {
        if (response == 1)
        {
            PlayerTextDrawSetString(playerid, RegisterTextDraw, "Day");
            PlayerTextDrawSetString(playerid, RegisterTextDraw, "Month");
           
            SetPVarInt(playerid, "BirthDateDay", -1);
            SetPVarInt(playerid, "BirthDateMonth", -1);
           
            new string;

            format(string, sizeof(string), "%i", (MAX_DATE_YEAR -listitem));
            PlayerTextDrawSetString(playerid, RegisterTextDraw, string);
           
            SetPVarInt(playerid, "BirthDateYear", (MAX_DATE_YEAR -listitem));
        }
    }
}
return 1;
}

public OnPlayerClickPlayerTextDraw(playerid, PlayerText:playertextid)
{
if (playertextid == RegisterTextDraw)
{
    ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FFFF66}Register: {FFFFFF}Password", "{FFFFFF}Enter your password then hit \"Submit\"", "Submit", "Close");
}

else if (playertextid == RegisterTextDraw)
{
    ShowPlayerDialog(playerid, DIALOG_SELECT_GENDER, DIALOG_STYLE_LIST, "{FFFF66}Register: {FFFFFF}Gender", "{FFFFFF}Male\nFemale\n", "Select", "Close");
}

else if (playertextid == RegisterTextDraw)
{
new string[7 *(MAX_DATE_YEAR -MIN_DATE_YEAR)], year;

for (new i = MAX_DATE_YEAR; i >= MIN_DATE_YEAR; i--)
{
    format(year, sizeof(year), "%i\n", i);
    strcat(string, year, sizeof(string));
}
ShowPlayerDialog(playerid, DIALOG_SELECT_DATE_YEAR, DIALOG_STYLE_LIST, "{FFFF66}Register: {FFFFFF}Birth Date: Year", string, "Select", "Close");
}

else if (playertextid == RegisterTextDraw)
{
    ShowPlayerDialog(playerid, DIALOG_SELECT_DATE_MONTH, DIALOG_STYLE_LIST, "{FFFF66}Register: {FFFFFF}Birth Date: Month", "{FFFFFF}January\nFebruary\nMarch\nApril\nMay\nJune\nJuly\nAugust\nSeptember\nOctober\nNovember\nDecember", "Select", "Close");
}

else if (playertextid == RegisterTextDraw)
{
    new max_days_for_month;
   
    switch (GetPVarInt(playerid, "BirthDateMonth"))
    {
        case 1: max_days_for_month = 31;
        case 3: max_days_for_month = 31;
        case 4: max_days_for_month = 30;
        case 5: max_days_for_month = 31;
        case 6: max_days_for_month = 30;
        case 7: max_days_for_month = 31;
        case 8: max_days_for_month = 31;
        case 9: max_days_for_month = 30;
        case 10: max_days_for_month = 31;
        case 11: max_days_for_month = 31;
        case 12: max_days_for_month = 31;
       
        case 2: //February
        {
            if ((GetPVarInt(playerid, "BirthDateYear") %4) == 0) max_days_for_month = 29;
            else                                                max_days_for_month = 28;
        }
       
        default: max_days_for_month = 30;
    }

new string[5 *31], days;

    for (new i = 1; i <= max_days_for_month; i++)
    {
        format(days, sizeof(days), "%i\n", i);
        strcat(string, days, sizeof(string));
    }
    ShowPlayerDialog(playerid, DIALOG_SELECT_DATE_DAY, DIALOG_STYLE_LIST, "{FFFF66}Register: {FFFFFF}Birth Date: Day", string, "Select", "Close");
}

else if (playertextid == RegisterTextDraw)
{
    new Gender          =      GetPVarInt(playerid, "Gender");
    new BirthDay        =      GetPVarInt(playerid, "BirthDateDay");
    new BirthMonth      =      GetPVarInt(playerid, "BirthDateMonth");
    new BirthYear      =      GetPVarInt(playerid, "BirthDateYear");
   
new password[MAX_LENGTH_PASSWORD +1];
GetPVarString(playerid, "Password", password, MAX_LENGTH_PASSWORD);

if (!(MIN_LENGTH_PASSWORD <= strlen(password) <= MAX_LENGTH_PASSWORD) || Gender < 0 || BirthDay < 0 || BirthMonth < 0 || BirthYear < 0)
{
    new string[234 +1];

    if (!(MIN_LENGTH_PASSWORD <= strlen(password) <= MAX_LENGTH_PASSWORD))
    {
        strcat(string, "{FFFFFF}- Please enter a password\n");
    }
    if (Gender < 0) strcat(string, "{FFFFFF}- Please select a gender\n");
    if (BirthYear      < 0)    strcat(string, "{FFFFFF}- Please select a year four your birth date\n");
    if (BirthMonth      < 0)    strcat(string, "{FFFFFF}- Please select a month four your birth date\n");
    if (BirthDay        < 0)    strcat(string, "{FFFFFF}- Please select a day four your birth date\n");
   
    ShowPlayerDialog(playerid, DIALOG_INFO, DIALOG_STYLE_MSGBOX, "{FFFF66}Register: {DC143C}Error:", string, "Close", "");
   
    PlayerPlaySound(playerid, 1085, 0.00, 0.00, 0.00);
}
else
{
    if (SetPVarInt(playerid, "RegisterTextDraws", -1))
    {
        CancelSelectTextDraw(playerid);
   
        for (new i; i < MAX_REGISTER_TEXTDRAWS; i++)
        {
            PlayerTextDrawHide(playerid, RegisterTextDraw);
            PlayerTextDrawDestroy(playerid, RegisterTextDraw);
        }
       
        new query[256 +1];
        format(query, sizeof(query), "INSERT INTO `users`(`username`, `password`, `gender`, `birthdate`, `skin`) VALUES ('%q', '%q', %i, '%i/%i/%i', %i)", ReturnPlayerName(playerid), password, Gender, BirthDay, BirthMonth, BirthYear, GetPVarInt(playerid, "CurrentPreviewModel"));
        mysql_query(handle, query, false);
    }
}
}

else if (playertextid == RegisterTextDraw)
{
    new
        current = GetPVarInt(playerid, "CurrentPreviewModel");

if (current <= 0)
{
    PlayerPlaySound(playerid, 1085, 0.00, 0.00, 0.00);
}
else
{
    SetPVarInt(playerid, "CurrentPreviewModel", (current -1));
   
    PlayerTextDrawHide(playerid, RegisterTextDraw);
    PlayerTextDrawSetPreviewModel(playerid, RegisterTextDraw, (current -1));
   
    PlayerTextDrawShow(playerid, RegisterTextDraw);
   
    new string[3 +1];
    format(string, sizeof(string), "%i", (current -1));
    PlayerTextDrawSetString(playerid, RegisterTextDraw, string);
}
}

else if (playertextid == RegisterTextDraw)
{
    new
        current = GetPVarInt(playerid, "CurrentPreviewModel");
       
if (current > 310)
{
    PlayerPlaySound(playerid, 1085, 0.00, 0.00, 0.00);
}
else
{
    SetPVarInt(playerid, "CurrentPreviewModel", (current +1));
   
    PlayerTextDrawHide(playerid, RegisterTextDraw);
    PlayerTextDrawSetPreviewModel(playerid, RegisterTextDraw, (current +1));
   
    PlayerTextDrawShow(playerid, RegisterTextDraw);
   
    new string[3 +1];
    format(string, sizeof(string), "%i", (current +1));
    PlayerTextDrawSetString(playerid, RegisterTextDraw, string);
}
}
else if (playertextid == LogginTextDraw)
{
    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FFFF66}Login In: {FFFFFF}Insert your password", "{FFFFFF}Enter your password then hit \"Submit\"", "Submit", "Close");
}
return 1;
}

/*==============================================================================
Util Commands:
==============================================================================*/

CMD:changepassword(playerid, params[])
{
if (GetPVarInt(playerid, "LoggedInPlayer") < 0) return SendClientMessage(playerid, 0xDC143CFF, "ERROR: You are not registered or logged in.");

new password[MAX_LENGTH_PASSWORD +1];

if (sscanf(params, "s["#MAX_LENGTH_PASSWORD"]", password)) return SendClientMessage(playerid, -1, "* USAGE: /changepassword ");

if (!(MIN_LENGTH_PASSWORD <= strlen(password) <= MAX_LENGTH_PASSWORD)) return SendClientMessage(playerid, 0xDC143CFF, "ERROR: Invalid password length, must be (correct length: "#MIN_LENGTH_PASSWORD"/"#MAX_LENGTH_PASSWORD")");

new current_password[MAX_LENGTH_PASSWORD +1];
GetPVarString(playerid, "Password", current_password, MAX_LENGTH_PASSWORD);

if (!strcmp(current_password, password)) return SendClientMessage(playerid, 0xDC143CFF, "ERROR: Your current password and the new password are the same.");

new query[109 +MAX_LENGTH_PASSWORD];

format(query, sizeof(query), "UPDATE `users` SET `password` = '%q' WHERE `username` COLLATE latin1_general_cs = '%q'", password, ReturnPlayerName(playerid));
mysql_query(handle, query, false);

new message[58 +MAX_LENGTH_PASSWORD];

format(message, sizeof(message), "ACCOUNT: You have changed your password to {FFFFFF}\"%s\"", password);
SendClientMessage(playerid, 0x00FF00FF, message);

SetPVarString(playerid, "Password", password);

return 1;
}

CMD:changegender(playerid, params[])
{
    if (GetPVarInt(playerid, "LoggedInPlayer") < 0) return SendClientMessage(playerid, 0xDC143CFF, "ERROR: You are not registered or logged in.");
   
new gender[6 +1];
if (sscanf(params, "s", gender)) return SendClientMessage(playerid, -1, "USAGE: /changegender ");

new genderid;

if (!strcmp(gender, "Male", true))      genderid = 1;
else if (!strcmp(gender, "Female", true))      genderid = 2;
else                                            genderid = -1;

if (genderid < 0) return SendClientMessage(playerid, 0xDC143CFF, "ERROR: Insert a correct gender (correct gender: Male/Female)");

if (GetPVarInt(playerid, "Gender") == genderid) return SendClientMessage(playerid, 0xDC143CFF, "ERROR: Current gender is already select gender.");

    new query[114 +MAX_PLAYER_NAME];
   
format(query, sizeof(query), "UPDATE `users` SET `gender` = %i WHERE `username` COLLATE latin1_general_cs = '%q'", genderid, ReturnPlayerName(playerid));
mysql_query(handle, query, false);

new message;

format(message, sizeof(query), "ACCOUNT: You have changed your gender to {FFFFFF}\"%s\"", (genderid > 1) ? ("Female"):("Male"));
SendClientMessage(playerid, 0x00FF00FF, message);

SetPVarInt(playerid, "Gender", genderid);

return 1;
}

Neke slike/video za lakse dobivanje pomoci(neobavezno)://
Herarhije
Godfather
pre 8 godina
Odes i nadjes Log i Reg u yini na netu
Muma Rascall
Forum Don
pre 8 godina
Ja ne kontam zašto bi neko iz boljeg prebacio u gore...
Bolex_
Made Man
pre 8 godina
Muma wrote on May 23, 2017, 1:16 pm:
Ja ne kontam zašto bi neko iz boljeg prebacio u gore...


Oni koji uništavaju SA-MP...
Sarkenzo
Shot Caller
pre 8 godina
Zato sto naprimer ne znam da radim sa MYSQL i sve mi je do sada pravljeno u YSI
NanySamper
Made Man
pre 8 godina
Malo trazi po netu Reg/log Y_ini

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava