Ajutor MySQL Save player

AsSsASIN · February 16, 2011

Am o mica problema la MySQL save player, imi puteti da un ex de saveplayerdata si database cu totul din PlayerInfo si altele? va rog mult... nu mi se salveaza datele..

AsSsASIN · February 21, 2011

la fel, deci, nu stiu ce sa fac :| laz, pentru salvarea datelor, zi-mi ce trebuia sa fac de la inceput de la sfarsit, poate am omis ceva..

February 22, 2011

pune la OnGameModeInit mysql_debug(1); ,deschide sv,intra,iesi si uitate in mysql_log si vezi care e eroarea!

AsSsASIN · February 22, 2011

[19:16:27] MySQL Debugging activated (02/21/11)

[19:16:27] ---------------------------

[19:16:27]

[19:47:32] >> mysql_real_escape_string( Connection handle: 1 )

[19:47:32] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[19:47:32] >> mysql_query( Connection handle: 1 )

[19:47:32] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(username) = LOWER('exDDD') LIMIT 1) - Successfully executed.

[19:47:32] >> mysql_store_result( Connection handle: 1 )

[19:47:32] CMySQLHandler::StoreResult() - Result was stored.

[19:47:32] >> mysql_num_rows( Connection handle: 1 )

[19:47:32] CMySQLHandler::NumRows() - Returned 0 row(s)

[19:47:37] >> mysql_real_escape_string( Connection handle: 1 )

[19:47:37] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[19:47:37] >> mysql_real_escape_string( Connection handle: 1 )

[19:47:37] CMySQLHandler::EscapeString(******); - Escaped 6 characters to ******.

[19:47:37] >> mysql_query( Connection handle: 1 )

[19:47:37] CMySQLHandler::Query(INSERT INTO players (username, password) VALUES ('exDDD', '******')) - Successfully executed.

[19:47:38] >> mysql_query( Connection handle: 1 )

[19:47:38] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed.

[19:47:38] >> mysql_store_result( Connection handle: 1 )

[19:47:38] CMySQLHandler::StoreResult() - Result was stored.

[19:47:38] >> mysql_fetch_row_format( Connection handle: 1 )

[19:47:39] >> mysql_query( Connection handle: 1 )

[19:47:39] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed.

[19:47:39] >> mysql_store_result( Connection handle: 1 )

[19:47:39] CMySQLHandler::StoreResult() - Result was stored.

[19:47:39] >> mysql_fetch_row_format( Connection handle: 1 )

[19:47:39] >> mysql_query( Connection handle: 1 )

[19:47:39] CMySQLHandler::Query(SELECT * FROM players WHERE id = 0 LIMIT 1) - Successfully executed.

[19:47:39] >> mysql_store_result( Connection handle: 1 )

[19:47:39] CMySQLHandler::StoreResult() - Result was stored.

[19:47:39] >> mysql_fetch_row_format( Connection handle: 1 )

[19:47:39] >> mysql_free_result( Connection handle: 1 )

[19:47:39] CMySQLHandler::FreeResult() - Result was successfully free'd.

[19:49:28] >> mysql_query( Connection handle: 1 )

[19:49:28] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.

[19:50:07] >> mysql_query( Connection handle: 1 )

[19:50:07] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.

[19:55:20] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[19:55:20] CMySQLHandler::FreeResult() - The result is already empty.

[19:55:20] CMySQLHandler::Disconnect() - Connection was closed.

AsSsASIN · February 23, 2011

^^^^^^^^^^^^^^^^

look!

LaZ · February 23, 2011

[19:49:28] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.

La `username` ar trebui sa fie nickul tau.

AsSsASIN · February 23, 2011

in fine, am facut eu ceva si am reusit, dar nu se salveaza corect, se salveaza cifre aiurea :|

[DBG]EduCaTu. · February 23, 2011

in fine, am facut eu ceva si am reusit, dar nu se salveaza corect, se salveaza cifre aiurea :|

deci nu ai reusit ! incearca cum a zis laz

AsSsASIN · February 23, 2011

Noua syntaxa

public SavePlayerData(playerid)
{
	new query[700];
	format(query, 700, "UPDATE players SET password=%s, Admin=%d WHERE username=%s", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid));
    mysql_query(query);
	return 1;
}

.. si zice eroare din mysql ca syntaxa e gresita, problema?

February 24, 2011

Esti stresant.

valorile se pun sub ' ' iar alea dinantea' lui egal(am uitat cum se numesc,raceala) cu ` ` .Deci prin urmare

format(query, 700, "UPDATE players SET `password`='%s', `Admin`='%d' WHERE `username`='%s'", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid));

pPassword trebuie sa fie string( pPassword[30])

pAdmin trebuie sa fie integer( pAdmin)

Astea in gm.

AsSsASIN · February 24, 2011

Tot incerc, si iar incerc, defapt am rezolvat cu salvarea, dar parola nu se salveaza cum trebuie ...


public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    new tmppass[64],loginstring[256],loginname[64],regstring[256];
    GetPlayerName(playerid,loginname,sizeof(loginname));
	if(response) {
        if(dialogid == 1) {
            if(strlen(inputtext)) {
                //Encrypt(tmppass);
				strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
                OnPlayerLogin(playerid,tmppass);
            } else {
                format(loginstring,sizeof(loginstring),"{FF0000}WRONG PASSWORD!! {FFFFFF}please write the correct password.",loginname);
                ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",loginstring,"Login", "");
            }
        }
        if(dialogid == 2) {
            if(strlen(inputtext)) {
                //Encrypt(tmppass);
				strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
				OnPlayerRegister(playerid,tmppass);
            } else {
                format(regstring,sizeof(regstring),"{FFFFFF}Welcome on {0000FF}eXtrike Federation{FFFFFF}.\n{FFFFFF}What's up {0000FF}%s{FFFFFF}? Please enter your password.",loginname);
                ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",regstring,"Register", "");
            }
        }
	    return 1;
    }
    return 1;
}

public SavePlayerData(playerid)
{
	new query[700];
	format(query, 700, "UPDATE `players` SET `password` ='%s', `Admin` ='%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid));
    mysql_query(query);
	return 1;
}


[14:12:09] MySQL Debugging activated (02/24/11)

[14:12:09] ---------------------------

[14:12:09]  

[14:12:44] >> mysql_real_escape_string( Connection handle: 1 )

[14:12:44] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[14:12:44] >> mysql_query( Connection handle: 1 )

[14:12:44] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(username) = LOWER('exDDD') LIMIT 1) - Successfully executed.

[14:12:44] >> mysql_store_result( Connection handle: 1 )

[14:12:44] CMySQLHandler::StoreResult() - Result was stored.

[14:12:44] >> mysql_num_rows( Connection handle: 1 )

[14:12:44] CMySQLHandler::NumRows() - Returned 0 row(s)

[14:12:50] >> mysql_real_escape_string( Connection handle: 1 )

[14:12:50] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[14:12:50] >> mysql_real_escape_string( Connection handle: 1 )

[14:12:50] CMySQLHandler::EscapeString(******); - Escaped 6 characters to ******.

[14:12:50] >> mysql_query( Connection handle: 1 )

[14:12:50] CMySQLHandler::Query(INSERT INTO players (username, password) VALUES ('exDDD', '******')) - Successfully executed.

[14:12:54] >> mysql_query( Connection handle: 1 )

[14:12:54] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:12:54] >> mysql_store_result( Connection handle: 1 )

[14:12:54] CMySQLHandler::StoreResult() - Result was stored.

[14:12:54] >> mysql_fetch_row_format( Connection handle: 1 )

[14:12:55] >> mysql_query( Connection handle: 1 )

[14:12:55] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:12:55] >> mysql_store_result( Connection handle: 1 )

[14:12:55] CMySQLHandler::StoreResult() - Result was stored.

[14:12:55] >> mysql_fetch_row_format( Connection handle: 1 )

[14:13:04] >> mysql_query( Connection handle: 1 )

[14:13:04] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:13:04] >> mysql_store_result( Connection handle: 1 )

[14:13:04] CMySQLHandler::StoreResult() - Result was stored.

[14:13:04] >> mysql_fetch_row_format( Connection handle: 1 )

[14:13:04] >> mysql_query( Connection handle: 1 )

[14:13:04] CMySQLHandler::Query(SELECT * FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:13:04] >> mysql_store_result( Connection handle: 1 )

[14:13:04] CMySQLHandler::StoreResult() - Result was stored.

[14:13:04] >> mysql_fetch_row_format( Connection handle: 1 )

[14:13:04] >> mysql_free_result( Connection handle: 1 )

[14:13:04] CMySQLHandler::FreeResult() - Result was successfully free'd.

[14:13:34] >> mysql_query( Connection handle: 1 )

[14:13:34] CMySQLHandler::Query(UPDATE `players` SET `password` ='**:***', `Admin` ='1338' WHERE `username` ='exDDD' ) - Successfully executed.

[14:14:13] >> mysql_close( Connection handle: 1 )

[14:14:13] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[14:14:13] CMySQLHandler::FreeResult() - The result is already empty.

[14:14:13] CMySQLHandler::Disconnect() - Connection was closed.

AsSsASIN · February 24, 2011

up pt primul post.

AsSsASIN · February 27, 2011

Rezolvat, locked!

Sign In

Ajutor MySQL Save player

Question

AsSsASIN

37 answers to this question

Recommended Posts

AsSsASIN

Guest farse

AsSsASIN

AsSsASIN

LaZ

AsSsASIN

[DBG]EduCaTu.

AsSsASIN

Guest farse

AsSsASIN

AsSsASIN

AsSsASIN

Similar Content

Ajutor, cum gasesc o comanda ascunsa ?!?!

Gamemode Hardgaming Versiunea a 4-a (no-mysql) 1 2

Ajutor comanda /members - Nu im afiseaza dialog-ul

ajutor conectare data de baze in gamemode ca nustiu care pun ca le pun pe amandoua si numi merge va las jos sa imi spuneti care ip trebuie

ajutor my sql ( NO DATA BASE CONECT)

Recently Browsing 0 members

Browse

Activity

Important Information