public plugin_cfg() {
new Query[5012], Len;
g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3])

Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `tabla_neve` ")

Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ")
Len += formatex(Query[Len], charsmax(Query)-Len, "`pont` int(11) NOT NULL, ")
Len += formatex(Query[Len], charsmax(Query)-Len, "`kulcs` int(11) NOT NULL, ")
Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollar` int(11) NOT NULL, ")

for(new i;i < sizeof(LADANEVEK); i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "`Lada%d` int(11) NOT NULL, ", i)

for(new i;i < sizeof(SkinNevek); i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "`Fegyver%d` int(11) NOT NULL, ", i)

for(new i;i < sizeof(OsszesFegyver); i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "`OFegyver%d` int(11) NOT NULL, `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)",i)

SQL_ThreadQuery(g_SqlTuple,"createTableThread", Query)
}
public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED)
set_fail_state("Nem tudtam csatlakozni az adatbazishoz.");
else if(FailState == TQUERY_QUERY_FAILED)
set_fail_state("Query Error");
if(Errcode)
log_amx("Hibat dobtam: %s",Error);

}
public load(id) {
new Query[2048], Data[1], Name[32];
get_user_name(id, Name, 31);
Data[0] = id;

formatex(Query, charsmax(Query), "SELECT * FROM `tabla_neve` WHERE Nev = ^"%s^";", name[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
return PLUGIN_HANDLED;
}
public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
log_amx("%s", Error)
return
}
else {
new id = Data[0];

if(SQL_NumRows(Query) > 0) {
Pont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "pont"))
Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kulcs"))
Dollar[id] = float(SQL_ReadResult(Query, 3))/100
Szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "szint"))

for(new i;i < sizeof(LADANEVEK); i++) {
Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Lada%d"),i)
}
for(new i;i < sizeof(SkinNevek); i++) {
Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Fegyver%d"),i)
}
for(new i;i < sizeof(OsszesFegyver); i++) {
OsszesFegyver[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "OFegyver%d"),i)
}
}
else {
save(id)
}
}
}
public save(id) {
new Query[2048], Name[32];
get_user_name(id, Name, 31);
new Len;

Len += format(Query[Len], 2048, "INSERT INTO tabla_neve ")
Len += format(Query[Len], 2048-Len,"(Nev) VALUES('%s')", name[id])

SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
log_amx("%s", Error)
return
}
}
public update(id) {
new Query[2048], Len

Len += formatex(Query[Len], charsmax(Query), "UPDATE `tabla_neve` ");

Len += formatex(Query[Len], charsmax(Query)-Len, "SET pont = ^"%i^",", Pont[id])
Len += formatex(Query[Len], charsmax(Query)-Len, "kulcs = ^"%i^",", Kulcs[id])
Len += formatex(Query[Len], charsmax(Query)-Len, "Dollar = ^"%i^",", floatround(Dollar[id]*100));
Len += formatex(Query[Len], charsmax(Query)-Len, "szint = ^"%i^",");
for(new i;i < sizeof(LADANEVEK); i++) {
Len += formatex(Query[Len], charsmax(Query)-Len, "Lada%d = ^"%i^"", i, Lada[i][id])
}
for(new i;i < sizeof(SkinNevek); i++) {
Len += formatex(Query[Len], charsmax(Query)-Len, "Fegyver%d = ^"%i^"", i, Skin[i][id])
}
for(new i;i < sizeof(OsszesFegyver); i++) {
Len += formatex(Query[Len], charsmax(Query)-Len, "OFegyver%d = ^"%i^"", i, OsszesFegyver[i][id])
}
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE Nev = ^"%s^";", name[id])

SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public plugin_end() {
SQL_FreeHandle(g_SqlTuple)
}
public client_putinserver(id) {
if(!is_user_bot(id)) {
load(id)
}
Skins[id] = true
}
public client_disconnect(id) {
if(!is_user_bot(id)) {
update(id)
}
}