NuamNume

acm imi zice de lastlogin... am inteles

Gata.

[15:10:31 05/19/20] [ERROR] CMySQLQuery::Execute[FJ37DH3JG_MYSQL_INTERNAL] - (error #1054) Unknown column 'RegisterDate' in 'field list' (Query: "INSERT INTO `users` (Name, Password, RegisterDate, LastLogin) VALUES ('R4uL', 'sadsadasda', '15:10:31 - 19/05/2020', '15:10:31 - 19/05/2020')")

mysql_log(LOG_ERROR | LOG_WARNING, LOG_TYPE_TEXT); la asta te referi? sunt prost nu ma pricep... scriptez de 1 sapt

Nu..

Nu merge. Oricum, multumesc.

Bro tot nu merge

Multumesc mult, o sa incerc

Dialog:DIALOG_REGISTER(playerid, response, listitem, inputtext[])
{
    if(!response)
        return Kick(playerid);
        
    if(strlen(inputtext) < 8 || strlen(inputtext) > 64)
        return Dialog_Show(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Register", "Type your desired password below:\n{AFAFAF}Numarul de caractere trebuie sa fie format din 8 - 64.", "Register", "Cancel");

    format(PlayerInfo[playerid][pName], 24, GetPlayerNameEx(playerid));
    format(PlayerInfo[playerid][pPassword], 128, inputtext);

    gQuery[0] = (EOS);
    mysql_format(SQL, gQuery, sizeof gQuery, "INSERT INTO `users` (Name, Password, RegisterDate, LastLogin) VALUES ('%e', '%e', '%e', '%e')", GetPlayerNameEx(playerid), inputtext, GetDateTime(), GetDateTime());
    
    inline CheckSQLID()
    {
        PlayerInfo[playerid][pSQLID] = cache_insert_id();
        printf("New account: %s (%d).", GetPlayerNameEx(playerid), playerid);
        return true;
    }
    
    mysql_pquery_inline(SQL, gQuery, using inline CheckSQLID, "");
    Dialog_Show(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "E-mail", "Scrie mai jos adresa ta de e-mail:", "Select", "Cancel");
    return true;
}

Nu am erori, dar dupe ce ma inregistrez si ma duc in baza de date nu se salveaza nimic...

habar nu am de ce

Daca ma poate ajuta cineva intr-o ora de preferat as fii recunoscator..

Edit: am pus in alta baza gen acolo la mysql_connect si dupa a mers.. nush ce are

Am rezolvat si asta... topic aiurea cer t/c

Am rezolvat, era din cauza easyDialog acum l-am schimbat si merge.

dar mai am o rugaminte daca ma puteti ajuta cu asta: 

C:\Users\Raul\Desktop\Shine RPG Gamemode\gamemodes\Shine.pwn(128) : warning 202: number of arguments does not match definition
C:\Users\Raul\Desktop\Shine RPG Gamemode\gamemodes\Shine.pwn(128) : warning 202: number of arguments does not match definition

COD:     if(strlen(inputtext) < 8 || strlen(inputtext) > 128 || !IsValidEmailAddress(inputtext))
        return Dialog_Show(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "E-Mail", "Scrie mai jos adresa ta de e-mail:\n{AFAFAF}Adresa de e-mail nu este valida."); // asta este linia

 warning 202: number of arguments does not match definition (de 2 ori la aceasi linie)

COD:  if(strlen(inputtext) < 8 || strlen(inputtext) > 128 || !IsValidEmailAddress(inputtext))
        return Dialog_Show(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "E-Mail", "Scrie mai jos adresa ta de e-mail:\n{AFAFAF}Adresa de e-mail nu este valida."); // linia cu return dialog_show

si inca ceva C:\Users\Raul\Desktop\Shine RPG Gamemode\pawno\include\easyDialog.inc(95) : error 035: argument type mismatch (argument 4)
C:\Users\Raul\Desktop\Shine RPG Gamemode\pawno\include\easyDialog.inc(99) : error 035: argument type mismatch (argument 4)

nu stiu de ce dar acolo la linia 95 este gol.. pur si simplu spatiu liber

COD linia 99:     if(!response)
        return Kick(playerid); // linia cu problema este aceasta cu return kick

As fii recunoscator daca m-ar ajuta cineva

Am rezolvat.

Nu e neaparat o eroare dar mereu cand compilez primesc crash la pawno library... help

Vreau sa mentionez ca am totul definit, dar mna...

COD: 

switch(dialogid) {
    case DIALOG_SETPIN: {
        if(!response) return 1;
        if(!IsNumeric(inputtext)) return SCM(playerid, COLOR_GREY, "Pin-ul trebuie sa contina doar numere!");
        if(strlen(inputtext) > 4) return SCM(playerid, COLOR_GREY, "Pin-ul trebuie sa contina 4 numere!"
        new pin = strval(inputtext);
        PlayerInfo[playerid][pPin] = pin;
        PlayerInfo[playerid][pPinLogged] = 1;
        format(string, sizeof(string), "Your pin is %d.", pin);
        SCM(playerid, COLOR_YELLOW, string);
        SCM(playerid, COLOR_GREEN, "Nu uita sa faci poza (F8) pentru a nu uita pin-ul!");
        new query[180];
        format(query, sizeof(query), "UPDATE `users` SET `Pin`='%d' WHERE `ID`='%d'", pin, PlayerInfo[playerid][pSQLID]);
        mysql_query(SQL, query);
    }
    case DIALOG_LOGINPIN: {
        if(!response) return 1;
        new pin = strval(inputtext);
        if(PlayerInfo[playerid][pPin] != pin) return SCM(playerid, COLOR_RED, "Invalid pin, try again!");
        PlayerInfo[playerid][pPinLogged] = 1;
        SCM(playerid, COLOR_WHITE, "{f244a}<< {FFFFFF}Correct pin! Enjoy the game. {f2444a}>>");
    }
    case DIALOG_CHANGEPIN: {
        if(!response) return 1;
        new pin = strval(inputtext);
        if(PlayerInfo[playerid][pPin] != pin) return SCM(playerid, COLOR_RED, "Invalid pin, try again!");
        ShowPlayerDialog(playerid, DIALOG_CHANGEPIN+1, DIALOG_STYLE_INPUT, "Change pin", "Scrie mai jos noul pin care doresti sa-l ai!", "Select", "Cancel");
    }
    case DIALOG_CHANGEPIN+1: {
        if(!response) return 1;
           new pin = strval(inputtext);
        PlayerInfo[playerid][pPin] = pin;
        format(string, sizeof(string), "Your pin is now %d.", pin);
        SCM(playerid, COLOR_YELLOW, string);
        SCM(playerid, COLOR_GREEN, "Nu uita sa faci poza (F8) pentru a nu uita noul pin!");
        new query[180];
        format(query, sizeof(query), "UPDATE `users` SET `Pin`='%d' WHERE `ID`='%d'", pin, PlayerInfo[playerid][pSQLID]);
        mysql_query(SQL, query);
        
    }
}

si inca un cod:

CMD:loginpin(playerid, params[]) {
    if(PlayerInfo[playeri][pPinLogged] == 1) return SCM(playerid, COLOR_GREY, "Ai introdus deja pin-ul!");
    if(PlayerInfo[playeri][pPin] == 0) return SCM(playerid, COLOR_GREY, "Nu ai un pin setat! Foloseste '/setpin' pentru a seta unul.");
    ShowPlayerDialog(playerid, DIALOG_LOGINPIN, DIALOG_STYLE_INPUT, "Login pin", "Scrie pin-ul pe care l-ai setat:", "Select", "Cancel");
    return 1;
}

CMD:changepin(playerid, params[]) {
    if(PlayerInfo[playeri][pPin] == 0) return SCM(playerid, COLOR_GREY, "Nu ai un pin setat! Foloseste '/setpin' pentru a seta unul.");
    if(PlayerInfo[playeri][pPinLogged] == 1) return SCM(playerid, COLOR_GREY, "Pentru a schimba pin-ul trebuie sa fii logat cu el!");
    ShowPlayerDialog(playerid, DIALOG_CHANGEPIN, DIALOG_STYLE_INPUT, "Change pin", "Scrie pin-ul pe care l-ai setat:", "Select", "Cancel");
    return 1;
}

CMD:setpin(playerid, params[]) {
    if(PlayerInfo[playerid][pPin] != 0) return SCM(playerid, COLOR_GREY, "Ai deja un pin setat! Foloseste comanda '/loginpin' pentru a te loga cu el.");
    ShowPlayerDialog(playerid, DIALOG_SETPIN, DIALOG_STYLE_INPUT, "Set pin", "Scrie mai jos pin-ul care doresti sa-l ai!\nAcesta trebuie sa fie format 4 numere!", "Select", "Cancel");
    return 1;
}

C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(3641) : error 029: invalid expression, assumed zero

case pRollPointsx:

C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18946) : error 029: invalid expression, assumed zero
C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18946) : error 035: argument type mismatch (argument 2)

if(PlayerInfo[pRollPoints] < 100) PlayerInfo[pRollPoints] += 20, Update(i, pRollPointsx);

C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18967) : error 029: invalid expression, assumed zero
C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18967) : error 035: argument type mismatch (argument 2)

Update(playerid, pRollPointsx);

Nu inteleg ce are.. va rog sa ma ajutati

Am rezolvat. Cer t/c

Am rezolvat. Cer t/c.

format(string3, sizeof(string3), "PAYDAY~n~Played time: +%0.2f~n~Paycheck: $%s~n~Bank: $%s~n~Tax: $%s~n~Rent: $%s~n~Total money: $%d", PlayerInfo[pPayDay]/3600, FormatNumber(checks), FormatNumber(PlayerInfo[pAccount]),
FormatNumber(TaxValue), FormatNumber(rent), checks-TaxValue);
PlayerTextDrawSetString(i, PaydayTD, string3);
PlayerTextDrawShow(i, PaydayTD);

erori: error 035: argument type mismatch (argument 1)

1 hour ago, Gigel said:

"~" nu are ce sa caute acolo.. 

incearca asa:

 

format(string3, sizeof(string3), "PAYDAY~n~Played time: +%0.2f~n~Paycheck: $%s~n~Bank: $%s~n~Tax: $%s~n~Rent: $%s~n~Total money: $%d", PlayerInfo[pPayDay]/3600, FormatNumber(checks), FormatNumber(PlayerInfo[pAccount]), FormatNumber(TaxValue), FormatNumber(rent), checks-TaxValue);

 

 

 

Multumesc din tot sufletul, mai am doar o eroare.

error 035: argument type mismatch (argument 1)

Ma poti ajuta? Stiu ca cer mult dar mna...

Salut, vreau sa va rog daca ma puteti ajuta cu aceste erori. M-am chinuit 3 ore non-stop sau mai mult sa le rezolv, degeaba. Multumesc tuturor.

Erori: C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18869 -- 18870) : error 001: expected token: ",", but found "~"
C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18870) : warning 215: expression has no effect
C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18870) : error 001: expected token: ";", but found ")"
C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18870) : error 029: invalid expression, assumed zero
C:\Users\Raul\Downloads\Gamemode (1)\Gamemode\Gamemode\gamemodes\BigZoneGM.pwn(18870) : fatal error 107: too many error messages on one line

cod:                 format(string3, sizeof(string3), "PAYDAY~n~Played time: +%0.2f~n~Paycheck: $%s~n~Bank: $%s~n~Tax: $%s~n~Rent: $%s~n~Total money: $%d", PlayerInfo[pPayDay]/3600, FormatNumber(checks), FormatNumber(PlayerInfo[pAccount]),
                FormatNumber(TaxValue), FormatNumber(rent), checks~TaxValue);
                PlayerTextDrawSetString(i, PaydayTD, string3);
                PlayerTextDrawShow(i, PaydayTD);

Va rog mult sa ma ajutati, multumesc all