Mysql

[ToE]

Taigi nesenai susikuriau mysql reg/prisijungima ir pasirodo jog viskas bugginasi, pirmas žaidėjas prisiregistruoja jį įrašo į duom. baze, o kai antras prisiregistruoja jo nebe rašo į duom baze, ta prasme jaigu duom. bazėje jau yra įrašytas vienas žaidėjas antro nebeįrašo.

 

Reg/Prisijung

 

if(dialogid == 2)
{
if( response )
{
if( !strlen( inputtext ) )
return SendClientMessage( playerid,-1,"Laukelis Negali būti tuščias." );
if( strlen( inputtext ) > 40 )
return SendClientMessage( playerid,-1,"Slaptažodis negali būti ilgesnis nei 40simbolių." );


new
Query[ 150 ]
;
format( Query,sizeof( Query ),"SELECT * FROM `players` WHERE `Vardas` = '%s' AND `Slaptazodis` = '%s'",GetPlayerNameEx( playerid ),inputtext );
mysql_query( Query );
mysql_store_result( );
pData[playerid][Logged] = true;


if(! mysql_num_rows( ) )
{
Kick( playerid );
}
else
{
SendClientMessage( playerid,-1,"Prisijungėte sekmingai!" );
}
if( !response )
{
Kick( playerid );
}
mysql_free_result( );
return true;
}
}


if(dialogid == 1)
{
if( response )
{
if( !strlen( inputtext ) )
return SendClientMessage( playerid,-1,"Laukelis Negali būti tuščias." );
if( strlen( inputtext ) > 40 )
return SendClientMessage( playerid,-1,"Slaptažodis negali buūti ilgesnis nei 40simbolių." );


new
Query[ 150 ]
;
format( Query,sizeof( Query ),"INSERT INTO `players` (Vardas,Slaptazodis) VALUES ('%s','%s')",GetPlayerNameEx( playerid ),inputtext );
mysql_query( Query );
pData[playerid][nonreg] = 1;
}
else
{
Kick( playerid );
}
return true;
}

 

[Scottas]

Tikrinai server loga? Sena plugino versija, ar turi OnMysqlError? Pasidebugint galėtum

[ToE]

Mysql logo tikrinau tai ten kai pirma accounta kuriu viskas gerai buna o kai antra kuriu errora meta

[22:07:54] >> mysql_free_result( Connection handle: 1 )

[22:07:54] CMySQLHandler::FreeResult() - Result was successfully free'd.

[22:07:57] >> mysql_query( Connection handle: 1 )

[22:07:57] CMySQLHandler::Query(INSERT INTO `players` (Vardas,Slaptazodis) VALUES ('Edva_Testt','edva')) - An error has occured. (Error ID: 1062, Duplicate entry '0' for key 'PRIMARY')

[22:07:59] >> mysql_query( Connection handle: 1 )

[22:07:59] CMySQLHandler::Query(SELECT * FROM players WHERE Vardas = 'Edva_Testt') - Successfully executed.

[22:07:59] >> mysql_store_result( Connection handle: 1 )

[22:07:59] CMySQLHandler::StoreResult() - Result was stored.

[22:07:59] >> mysql_retrieve_row( Connection handle: 1 )

[22:07:59] >> mysql_free_result( Connection handle: 1 )

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

[ProGreen]

 

 

[22:07:57] CMySQLHandler::Query(INSERT INTO `players` (Vardas,Slaptazodis) VALUES ('Edva_Testt','edva')) - An error has occured. (Error ID: 1062, Duplicate entry '0' for key 'PRIMARY')

Padaryk jog primary column'as turėtų "AUTO_INCREMENT" funkciją.

[ToE]

Query error:

#1063 - Incorrect column specifier for column 'Vardas

Čia kai dedu auto_increment meta sita

[Scottas]

Sukurk laukeli 'id' ir nustatyk jam primary ir autoincrement