public client_putinserver(id)
{
gFolyamatban[id] = 0
gBejelentkezes[id] = false
copy(gJelszo[id], 31, "")
copy(gFelhasznalo[id], 31, "")
}
public client_disconnect(id)
{
gFolyamatban[id] = 0;
if(gBejelentkezes[id]) {
SqlAccFissites(id)
SqlAccFissites2(id)
SqlAccFissites3(id)
}
gBejelentkezes[id] = false;
}
public plugin_cfg() {
SqlTuple = SQL_MakeDbTuple(SqlN[0], SqlN[1], SqlN[2], SqlN[3]);
}
public SqlAccBetolt(id) {
new Query[2048], Len = 0;
new a[191];
format(a, 190, "%s", gFelhasznalo[id]);
replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")
Len += format(Query[Len], charsmax(Query), "SELECT * FROM badboynew ");
Len += format(Query[Len], charsmax(Query)-Len, "WHERE Felhasznalo = '%s'", a);
new Data[2]
Data[0] = id;
Data[1] = get_user_userid(id);
SQL_ThreadQuery(SqlTuple, "SqlAccBetoltQwe", Query, Data, 2);
}
public SqlAccBetoltQwe(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
if(FailState == TQUERY_CONNECT_FAILED)
{
set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
return
}
else if(FailState == TQUERY_QUERY_FAILED)
{
set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
return
}
if(Errcode)
{
log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return
}
new id = Data[0];
if(Data[1] != get_user_userid(id))
return;
new Found = SQL_NumRows(Query);
if(gMenu[id] == 0) {
if(Found > 0) {
ColorChat(id, NORMAL, "^4[%s] ^1Ez a felhasználónév már foglalt!", Prefix);
gFolyamatban[id] = 0;
RegFomenu(id);
}
else SqlAccKeszit(id);
}
else if(gMenu[id] == 1) {
if(Found == 0) {
ColorChat(id, NORMAL, "^4[%s] ^1Hibás jelszó vagy felhasználónév!", Prefix);
gFolyamatban[id] = 0;
RegFomenu(id);
}
else SqlAccLoad(id);
}
}
public SqlAccKeszit(id) {
new Query[2048], Len = 0;
new a[191], b[191], c[191];
format(a, 190, "%s", gFelhasznalo[id]);
format(b, 190, "%s", gJelszo[id]);
replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")
replace_all(b, 190, "\", "\\")
replace_all(b, 190, "'", "\'")
new Nev[32]; get_user_name(id, Nev, 31);
format(c, 190, "%s", Nev);
replace_all(c, 190, "\", "\\")
replace_all(c, 190, "'", "\'")
Len += format(Query[Len], charsmax(Query), "INSERT INTO badboynew ");
Len += format(Query[Len], charsmax(Query)-Len, "(Felhasznalo, Jelszo,Jatekosnev) VALUES ('%s', '%s', '%s')", a, b, c);
new Data[2]
Data[0] = id;
Data[1] = get_user_userid(id);
SQL_ThreadQuery(SqlTuple,"SqlAccKeszitQwe", Query, Data, 2)
}
public SqlAccKeszitQwe(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
if(FailState == TQUERY_CONNECT_FAILED)
{
set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
return
}
else if(FailState == TQUERY_QUERY_FAILED)
{
set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
return
}
if(Errcode)
{
log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return
}
new id = Data[0];
if(Data[1] != get_user_userid(id))
return;
ColorChat(id, NORMAL, "^4[%s] ^1Sikeresen Regisztráltál! Felhasználónév: ^4%s ^1| Jelszó: ^4%s", Prefix, gFelhasznalo[id], gJelszo[id]);
gFolyamatban[id] = 0;
gMenu[id] = 1;
RegFomenu(id);
return;
}
public SqlAccLoad(id) {
new Query[2048], Len = 0;
Len += format(Query[Len], charsmax(Query), "SELECT * FROM badboynew ");
Len += format(Query[Len], charsmax(Query)-Len, "WHERE Felhasznalo = '%s'", gFelhasznalo[id]);
new Data[2];
Data[0] = id;
Data[1] = get_user_userid(id);
SQL_ThreadQuery(SqlTuple,"SqlAccLoadQwe", Query, Data, 2);
}
public SqlAccLoadQwe(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
{
log_amx("%s", Error)
return
}
else
{
new id = Data[0];
if (Data[1] != get_user_userid(id))
return ;
new Password[100];
SQL_ReadResult(Query, 2, Password, 99);
if(equal(gJelszo[id], Password)) {
if ( is_online( id ) )
{
ColorChat(id, NORMAL, "^4[%s] ^3%s ^1már be van jelentkezve!", Prefix, gFelhasznalo[id]);
RegFomenu(id);
return;
}
gId[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Id"));
Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars"));
Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs"));
Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
new Text[32];
for ( new i; i < 284; i ++ )
{
format(Text, charsmax(Text), "F%i", i);
OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, Text));
}
for ( new i; i < LADA; i ++ )
{
format(Text, charsmax(Text), "L%i", i);
Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, Text));
}
client_printcolor(id, "!g[%s] !nSzia,!t %s!n (#!g%d!n) Sikeresen Bejelenetkeztél!", Prefix, gFelhasznalo[id], gId[id]);
gFolyamatban[id] = 0
gBejelentkezes[id] = true;
}
else {
ColorChat(id, NORMAL, "^4[%s] ^1Hibás jelszó vagy felhasználónév!", Prefix);
gFolyamatban[id] = 0;
RegFomenu(id);
}
}
}
public SqlAccFissites(id) {
static Query[4096], Len = 0;
new c[191];
new Nev[32]; get_user_name(id, Nev, 31);
format(c, 190, "%s", Nev);
replace_all(c, 190, "\", "\\")
replace_all(c, 190, "'", "\'")
Len += format(Query[Len], charsmax(Query), "UPDATE badboynew SET ");
Len += format(Query[Len], charsmax(Query)-Len, "Dollars = '%d', ", Dollar[id]);
Len += format(Query[Len], charsmax(Query)-Len, "Kulcs = '%d', ", Kulcs[id]);
Len += format(Query[Len], charsmax(Query)-Len, "Szint = '%d', ", Rang[id]);
Len += format(Query[Len], charsmax(Query)-Len, "Oles = '%d', ", Oles[id]);
Len += format(Query[Len], charsmax(Query)-Len, "Jatekosnev = '%s' ", c);
Len += format(Query[Len], charsmax(Query)-Len,"WHERE Id = '%d'", gId[id]);
SQL_ThreadQuery(SqlTuple,"SqlUpdateQwe", Query);
}
public SqlAccFissites2(id) {
static Query[4096], Len = 0;
new c[191];
new Nev[32]; get_user_name(id, Nev, 31);
format(c, 190, "%s", Nev);
replace_all(c, 190, "\", "\\")
replace_all(c, 190, "'", "\'")
Len += format(Query[Len], charsmax(Query), "UPDATE badboynew SET ");
for(new i;i < LADA; i++)
Len += format(Query[Len], charsmax(Query)-Len, "L%d = '%d', ", i, Lada[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"WHERE Id = '%d'", gId[id]);
SQL_ThreadQuery(SqlTuple,"SqlUpdateQwe2", Query);
}
public SqlAccFissites3(id) {
static Query[4096], Len = 0;
new c[191];
new Nev[32]; get_user_name(id, Nev, 31);
format(c, 190, "%s", Nev);
replace_all(c, 190, "\", "\\")
replace_all(c, 190, "'", "\'")
Len += format(Query[Len], charsmax(Query), "UPDATE badboynew SET ");
for(new i = 1; i <= 284; i++)
Len += format(Query[Len], charsmax(Query)-Len, "F%d = '%d', ", i, OsszesSkin[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"WHERE Id = '%d'", gId[id]);
SQL_ThreadQuery(SqlTuple,"SqlUpdateQwe3", Query);
}
public SqlUpdateQwe(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
if(FailState == TQUERY_CONNECT_FAILED)return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED) return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode) return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return PLUGIN_CONTINUE
}
public SqlUpdateQwe2(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
if(FailState == TQUERY_CONNECT_FAILED)return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED) return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode) return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return PLUGIN_CONTINUE
}
public SqlUpdateQwe3(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
if(FailState == TQUERY_CONNECT_FAILED)return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED) return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode) return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return PLUGIN_CONTINUE
}
stock is_online( iPlayerId )
{
for ( new i = 1; i < 33; ++i )
if ( gBejelentkezes[ i ] )
if ( equal( gFelhasznalo[ iPlayerId ], gFelhasznalo[ i ] ) )
return i;
return 0;
}