Offline |
|
Csatlakozott: 2015.12.14. 18:19 Hozzászólások: 216
Megköszönt másnak: 15 alkalommal Megköszönték neki: 5 alkalommal
|
Hi Valamiert nem mukodik a Regisztrációt lementi a tobbit nem Valaki segitene koszonom. [jonaks.amxx] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"�' at line 1 public plugin_cfg() { g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]); static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `premium_06`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollar` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Lada` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`EventLada` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`VipKupon` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`XP` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`viporok` int(11) NOT NULL,"); for(new i;i < 15; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`F_%d` int(11) NOT NULL,", i); for(new i;i < 1; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "`Skin_%d` int(11) NOT NULL,", i); Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public Load(id) { static Query[10048]; new Data[1], Name[32]; get_user_name(id, Name, 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `premium_06` WHERE Nev = ^"%s^";", Name); SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1); } 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) { SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Felhasznalonev"), regFh[id], charsmax(regFh[])); SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), regJelszo[id], charsmax(regJelszo[])); Regisztralt[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralt")); Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollar")); Lada[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Lada")); Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs")); EventLada[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "EventLada")); VipKupon[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipKupon")); Szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint")); xp[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "XP")); viporok[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "viporok")); for(new i=0;i < 15; i++) { new String[64]; formatex(String, charsmax(String), "F_%d", i); OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } for(new i;i < 1; i++) { new String[64]; formatex(String, charsmax(String), "Skin_%d", i); Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String)); } } else { Save(id); } } } public Save(id) { static Query[256]; new Name[32]; get_user_name(id, Name, 31); formatex(Query, charsmax(Query), "INSERT INTO `premium_06` (`Nev`) VALUES (^"%s^");", Name); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public SQL_Update_Reg(id) { static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `premium_06` SET Felhasznalonev = ^"%s^", ", regFh[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Jelszo = ^"%s^", ", regJelszo[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Dollar = ^"%i^", ", Dollar[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Lada = ^"%i^", ", Lada[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^", ", Kulcs[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "EventLada = ^"%i^", ", EventLada[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "VipKupon = ^"%i^", ", VipKupon[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Szint[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "XP = ^"%i^", ", xp[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "viporok = ^"%i^", ", viporok[id]); for(new i=0;i < 15; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "F_%d = ^"%i^", ", i, OsszesSkin[i][id]); for(new i;i < 1; i++) Len += formatex(Query[Len], charsmax(Query)-Len, "Skin_%d = ^"%i^", ", i, Skin[i][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Regisztralt = ^"%i^" WHERE Nev = ^"%s^";", Regisztralt[id], name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!"); else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error"); if(Errcode) log_amx("[HIBA*] HIBAT DOBTAM: %s",Error); } 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 client_putinserver(id) { if(!is_user_bot(id)) { get_user_name(id, name[id], charsmax(name)); Load(id); } set_task(1.0, "vip_betolt", id) Felhasznalonev[id] = ""; Jelszo[id] = ""; } public client_disconnect(id) { if(!is_user_bot(id)) { SQL_Update_Reg(id); } Dollar[id] = 0; Lada[id]=0; Kulcs[id] = 0; EventLada[id] = 0; VipKupon[id] = 0; Szint[id] = 0; Fegyo[id] = 1; xp[id] = 0; viporok[id] = 0; Belepve[id] = false; Beirtjelszot[id] = false; Beirtjelszot1[id] = false; Beirtfelhasznalot[id] = false; Beirtfelhasznalot1[id] = false; regFh[id][0] = EOS; regJelszo[id][0] = EOS; Felhasznalonev[id][0] = EOS; Jelszo[id][0] = EOS; for(new i;i < 1; i++) Skin[i][id] = EOS; for(new i;i < 15; i++) OsszesSkin[i][id] = EOS; copy(name[id], charsmax(name[]), ""); }
_________________ .::#0n3.Sh00T[Clan] Only AWP#Update[DEAGELE PÁRBAJ & RTD & Statrak*Go,Go,Go Nagyon jó szerver :D
|
|