Nebūna registracijos.

[Darko_Pawno]

Sveiki kūriau prisijungimą/registraciją su mysql ir neduoda registracijos tik Login.

eilutės.

OnPlayerConnect callbackas.

//REGISTRACIJA/PRISIJUNGIMAS
new
Query[ 200 ]
;
format( Query,sizeof( Query ),"SELECT * FROM `players` WHERE `Vardas` = '%s'",GetPlayerNameEx( playerid ) );
mysql_query( Query );
mysql_store_result( );

if( mysql_num_rows( ) )
{
ShowPlayerDialog( playerid,1,DIALOG_STYLE_INPUT,"Login","Praðome prisijungti","Jungtis","Atðaukti" );
}
else
{
ShowPlayerDialog( playerid,0,DIALOG_STYLE_INPUT,"Register","Praðome uþsiregistruoti","Register","Atðaukti" );
}
mysql_free_result( );
return 0;
}

OnDialogResponse callbackas

{
if( dialogid == 0 ) //Registracija
{
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 ),"INSERT INTO `players` (Vardas,Slaptazodis) VALUES ('%s','%s')",GetPlayerNameEx( playerid ),inputtext );
mysql_query( Query );
}
else
{
Kick( playerid );
}
return true;
}
if( dialogid == 1 ) //Prisijungimas
{
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( );

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

mysql.log

[17:19:43] ---------------------------

[17:19:43] MySQL Debugging activated (09/01/13)

[17:19:43] ---------------------------

[17:19:43]  

[17:19:43] >> mysql_connect( )

[17:19:43] CMySQLHandler::CMySQLHandler() - constructor called.

[17:19:43] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "serveris" | Username: "root" ...

[17:19:43] CMySQLHandler::Connect() - Connection was successful.

[17:19:43] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:19:43] >> mysql_ping( Connection handle: 1 )

[17:19:43] CMySQLHandler::Ping() - Connection is still alive.

[17:19:43] >> mysql_query( Connection handle: 1 )

[17:19:43] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Vardas` = 'Strongas') - An error has occured. (Error ID: 1146, Table 'serveris.players' doesn't exist)

[17:19:43] >> mysql_store_result( Connection handle: 1 )

[17:19:43] CMySQLHandler::StoreResult() - No data to store.

[17:19:43] >> mysql_num_rows( Connection handle: 1 )

[17:19:43] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[17:19:43] >> mysql_free_result( Connection handle: 1 )

[17:19:43] CMySQLHandler::FreeResult() - The result is already empty.

[17:19:45] >> mysql_query( Connection handle: 1 )

[17:19:45] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Vardas` = 'Strongas' AND `Slaptazodis` = 'dariukas') - An error has occured. (Error ID: 1146, Table 'serveris.players' doesn't exist)

[17:19:45] >> mysql_store_result( Connection handle: 1 )

[17:19:45] CMySQLHandler::StoreResult() - No data to store.

[17:19:45] >> mysql_num_rows( Connection handle: 1 )

[17:19:45] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[17:19:45] >> mysql_free_result( Connection handle: 1 )

[17:19:45] CMySQLHandler::FreeResult() - The result is already empty.

[bebras]

[17:19:43] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Vardas` = 'Strongas') - An error has occured. (Error ID: 1146, Table 'serveris.players' doesn't exist)

Lentelės "players" nėra.

[Darko_Pawno]

Ką tai turėtų reikšti?

[bebras]

Ką tai turėtų reikšti?

Tai ką ir reiškia.... Tavo duomenų bazėje NĖRA lentelės su pavadinimu "players"...

[Darko_Pawno]

Gal galėtum duoti info kaip ją sukurti?

[Darko_Pawno]

Padėkit kas labai reikia ble..

[nesigilink]

Eik į savo duomenų bazė (prisijiunk, jeigu nemoki nekurk gal..) Tada ten paspausk ant savo duomenų bazės pavadinimo (serveris) atrodo pavadinta, tada ten trputį dešnejė pusėje viršuj bus uostelė su pasirinkimais, spausk Table, ir ten išmesk create new table kažkas tokio, pavadinimą padaryk players, nu ir ten įrašyk login, pass nu ir kažką..

[Darko_Pawno]

Eik į savo duomenų bazė (prisijiunk, jeigu nemoki nekurk gal..) Tada ten paspausk ant savo duomenų bazės pavadinimo (serveris) atrodo pavadinta, tada ten trputį dešnejė pusėje viršuj bus uostelė su pasirinkimais, spausk Table, ir ten išmesk create new table kažkas tokio, pavadinimą padaryk players, nu ir ten įrašyk login, pass nu ir kažką..

AČiū žiauriai einu pabandyti