[help] Registracijoje - tinka bet kas, logine - netikrina slaptazodzio.

[KKarolis]

Dialog:Register(playerid, response, listitem, inputtext[]){
	if(response){
		new password[40], query[200];
		mysql_real_escape_string(inputtext, password);

		if(!strlen(password)){
			SendClientMessage(playerid, -1, "Sis laukelis negali buti tuscias!");
			Dialog_Show(playerid, Register, DIALOG_STYLE_PASSWORD, "Register", "Irasykite norima slaptazodi:", "Registruotis", "Atsaukti");
			return 1;
		}
		if(strlen(password) > 40){
			SendClientMessage(playerid, -1, "Slaptazodis turi buti sudarytas is maziau nei 40 simboliu!");
			Dialog_Show(playerid, Register, DIALOG_STYLE_PASSWORD, "Register", "Irasykite norima slaptazodi:", "Registruotis", "Atsaukti");
			return 1;
		}

		format(query, sizeof(query), "INSERT INTO `players` (vardas, slaptazodis) VALUES ('%s', '%s')", PlayerName(playerid), MD5_Hash(password));
		mysql_query(query);
		Online[playerid] = true;
		afterRegister[playerid] = true;
		SendClientMessage(playerid, -1, "Sekmingai uzsiregistravai!");
	} else { Kick(playerid); }
	return 1;
}

Dialog:Login(playerid, response, listitem, inputtext[]){
	if(response){
		new password[40], query[200];
		mysql_real_escape_string(inputtext, password);

		if(strlen(MD5_Hash(password)) > 40){
			SendClientMessage(playerid, -1, "Slaptazodis turi buti sudarytas is maziau nei 40 simboliu!");
			Dialog_Show(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", "Irasykite slaptazodi:", "Prisijungti", "Atsaukti");
			return 1;
		}

		format(query, sizeof(query), "SELECT * FROM `players` WHERE vardas = '%s'", PlayerName(playerid));
		mysql_query(query);
		mysql_store_result();

		if(!mysql_num_rows()){
			if(countLogs[playerid] > 2){ Kick(playerid); }
			countLogs[playerid] ++;
			SendClientMessage(playerid, -1, "Slaptazodis neteisingas!");
			Dialog_Show(playerid, Login, DIALOG_STYLE_PASSWORD, "Login", "Irasykite slaptazodi:", "Prisijungti", "Atsaukti");
		} else {
			SendClientMessage(playerid, -1, "Prisijungei sekmingai!");
			Online[playerid] = true;
			afterLogin[playerid] = true;
			return 1;
		}
		mysql_free_result();
		return 1;
	} else Kick(playerid);
	return 1;
}

sedziu pakraupes

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

[13:11:14] CMySQLHandler::Query(SELECT * FROM `players` WHERE vardas = 'Trevor_Philips') - Successfully executed.

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

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

[13:11:14] >> mysql_num_rows( Connection handle: 1 )

[13:11:14] CMySQLHandler::NumRows() - Returned 0 row(s)

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

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

[13:11:15] >> mysql_real_escape_string( Connection handle: 1 )

[13:11:15] CMySQLHandler::EscapeString(123); - Escaped 3 characters to 123.

[13:11:15] >> mysql_query( Connection handle: 1 )

[13:11:15] CMySQLHandler::Query(INSERT INTO `players` (vardas, slaptazodis) VALUES ('Trevor_Philips', '202CB962AC59075B964B07152D234B70')) - Successfully executed.

[13:11:30] >> mysql_query( Connection handle: 1 )

[13:11:30] CMySQLHandler::Query(UPDATE `players` SET pos_x = '2193.067382', pos_y = '44.106826', pos_z = '26.335937' WHERE vardas = 'Trevor_Philips') - Successfully executed.

[13:11:30] >> mysql_query( Connection handle: 1 )

[13:11:30] CMySQLHandler::Query(UPDATE `players` SET skin = '0', money = '0', xp = '0' WHERE vardas = 'Trevor_Philips') - Successfully executed.

[13:11:30] >> mysql_query( Connection handle: 1 )

[13:11:30] CMySQLHandler::Query(UPDATE `players` SET hp = '100.000000', armour = '0.000000' WHERE vardas = 'Trevor_Philips') - Successfully executed.

[13:11:59] >> mysql_query( Connection handle: 1 )

[13:11:59] CMySQLHandler::Query(SELECT * FROM `players` WHERE vardas = 'Trevor_Philips') - Successfully executed.

[13:11:59] >> mysql_store_result( Connection handle: 1 )

[13:11:59] CMySQLHandler::StoreResult() - Result was stored.

[13:11:59] >> mysql_num_rows( Connection handle: 1 )

[13:11:59] CMySQLHandler::NumRows() - Returned 1 row(s)

[13:11:59] >> mysql_free_result( Connection handle: 1 )

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

[13:12:00] >> mysql_real_escape_string( Connection handle: 1 )

[13:12:00] CMySQLHandler::EscapeString(1); - Escaped 1 characters to 1.

[13:12:00] >> mysql_query( Connection handle: 1 )

[13:12:00] CMySQLHandler::Query(SELECT * FROM `players` WHERE vardas = 'Trevor_Philips') - Successfully executed.

[13:12:00] >> mysql_store_result( Connection handle: 1 )

[13:12:00] CMySQLHandler::StoreResult() - Result was stored.

[13:12:00] >> mysql_num_rows( Connection handle: 1 )

[13:12:00] CMySQLHandler::NumRows() - Returned 1 row(s)

[13:12:01] >> mysql_query( Connection handle: 1 )

[13:12:01] CMySQLHandler::Query(SELECT * FROM `players` WHERE vardas = 'Trevor_Philips') - Successfully executed.

[13:12:01] >> mysql_store_result( Connection handle: 1 )

[13:12:01] CMySQLHandler::StoreResult() - Result was stored.

[13:12:01] >> mysql_retrieve_row( Connection handle: 1 )

[13:12:01] >> mysql_fetch_field_row( Connection handle: 1 )

Viską įrašo, bet registruojantis nieko neįrašius - "Sveikiname prisiregistravus", logine įrašius neteisingą slaptažodį - "Sveiki prisijungę"

[Zero Two]

bandžiau taisyt klaidas, bet užkniso

problemos:

!strlen(password), tokio dalyko nėra naudok strlen(password) <= 0

betkada prisijungs prie serverio todėl, kad tu tikrini ar toks žaidėjas egzistuoja, o ne slaptažodį

taipat logikos problema, kad kai tu užkoduoji slaptažodi, ir jei jo užkodavimas ilgesnis nei 40 raidžių tu meti, kad slaptažodis per ilgas, kai čia kodavimas per ilgas.

 

manau pats pasitaisysi

[KKarolis]

bandžiau taisyt klaidas, bet užkniso

problemos:

!strlen(password), tokio dalyko nėra naudok strlen(password) <= 0

betkada prisijungs prie serverio todėl, kad tu tikrini ar toks žaidėjas egzistuoja, o ne slaptažodį

taipat logikos problema, kad kai tu užkoduoji slaptažodi, ir jei jo užkodavimas ilgesnis nei 40 raidžių tu meti, kad slaptažodis per ilgas, kai čia kodavimas per ilgas.

 

manau pats pasitaisysi

dabar netaisysiu, grįšiu namo pažiūrėsiu, dėkoju.

[Agnius]

SELECT `password` FROM `players` WHERE name='%s' AND password='%s'

Mazdaug taip turetu atrodyti sql uzklausa. Del !strlen auksciau komentaves narys tave suklaidino, gali naudoti !strlen kas bus == 0