public Load_All(id)
{
static Query[10048];
new Data[1];
Data[0] = id;
for (new i=1; i < 9; i++)
{
switch(i)
{
case 1:
{
formatex(Query, charsmax(Query), "SELECT * FROM `Profiles` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectProfile", Query, Data, 1);
}
case 2:
{
formatex(Query, charsmax(Query), "SELECT * FROM `Weapon` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectWeapon", Query, Data, 1);
}
case 3:
{
formatex(Query, charsmax(Query), "SELECT * FROM `Nevcedula` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectNevcedula", Query, Data, 1);
}
case 4:
{
formatex(Query, charsmax(Query), "SELECT * FROM `Stattrak` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectStattrak", Query, Data, 1);
}
case 5:
{
formatex(Query, charsmax(Query), "SELECT * FROM `StattrakKills` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectStKills", Query, Data, 1);
}
case 6:
{
formatex(Query, charsmax(Query), "SELECT * FROM `Skins` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectSkin", Query, Data, 1);
}
case 7:
{
formatex(Query, charsmax(Query), "SELECT * FROM `shedi_testers` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectTester", Query, Data, 1);
}
case 8:
{
formatex(Query, charsmax(Query), "SELECT * FROM `MusicKits` WHERE User_Id = ^"%i^";", g_Id[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectMusic", Query, Data, 1);
}
}
}
}
public Load_User_Data(id)
{
static Query[20048];
new Data[1];
Data[0] = id;
formatex(Query, charsmax(Query), "SELECT * FROM `Players` WHERE steamid = ^"%s^";", Player[id][steamid])
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];
new wId;
if(SQL_NumRows(Query) > 0)
{
g_Id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
wId = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
if(g_Id[id] == 0)
{
new sTime[9], sDate[11], sDateAndTime[32];
get_time("%H:%M:%S", sTime, 8 );
get_time("%Y/%m/%d", sDate, 11);
formatex(sDateAndTime, 31, "%s %s", sDate, sTime);
console_print(0, "-----------------------------")
console_print(0, "BEFORE LOAD")
console_print(0, "Játékosok: %i", p_playernum)
console_print(0, "id: %i", id)
console_print(0, "hashid: %i", get_user_userid(id))
console_print(0, "Név: %s | SteamId: %s", Player[id][f_PlayerNames], Player[id][steamid])
console_print(0, "Betöltetlen Account Id: %i", wId)
console_print(0, "Pontos idő: %s", sDateAndTime)
console_print(0, "-----------------------------")
log_to_file("Acc0id.txt", "Jatekosok: %i, sqlid: %i, hashid: %i, Nev: %s S: %s, Hibas Acccount id: %i Pontos ido: %s", p_playernum, id, get_user_userid(id), Player[id][f_PlayerNames], Player[id][steamid], wId, sDateAndTime)
console_print(id, "-----------------------------")
console_print(id, "BEFORE LOAD")
console_print(id, " ");
console_print(id, "Hibajelentes a hibas account betoltesrol!")
console_print(id, "Jatekosok: %i", p_playernum)
console_print(id, "id: %i", id)
console_print(id, "hashid: %i", get_user_userid(id))
console_print(id, "Nev: %s | SteamId: %s", Player[id][f_PlayerNames], Player[id][steamid])
console_print(id, "Betoltetlen Account Id: %i", wId)
console_print(id, "Pontos ido: %s", sDateAndTime)
console_print(id, " ");
console_print(id, "Ha a hiba tovabbra is fent all, keress fel egy tulajdonost!")
console_print(id, "A hiba megoldasaig, a szerver kirug, hogy ne legyen adatvesztesed!")
console_print(id, "-----------------------------")
console_print(id, "-----------------------------")
server_cmd("kick #%d ^"Hibás fiókbetöltés! További információk a konzolban!^"", get_user_userid(id));
}
Load_All(id);
}
else
{
Save(id);
}
}
}
public Save(id){
static Query[10048];
new Data[1];
Data[0] = id;
formatex(Query, charsmax(Query), "INSERT INTO `Players` (`steamid`) VALUES (^"%s^");", Player[id][steamid]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetDataProfile", Query, Data, 1);
}
public QuerySetDataProfile(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];
load_accid(id);
}
}
public load_accid(id)
{
static Query[20048];
new Data[1];
Data[0] = id;
formatex(Query, charsmax(Query), "SELECT * FROM `Players` WHERE `steamid` = ^"%s^"", Player[id][steamid]);
SQL_ThreadQuery(g_SqlTuple, "QuerySelectData1", Query, Data, 1);
}
public QuerySelectData1(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];
new wId
if(SQL_NumRows(Query) > 0) {
g_Id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
wId = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
if(g_Id[id] == 0)
{
new sTime[9], sDate[11], sDateAndTime[32];
get_time("%H:%M:%S", sTime, 8 );
get_time("%Y/%m/%d", sDate, 11);
formatex(sDateAndTime, 31, "%s %s", sDate, sTime);
console_print(0, "-----------------------------")
console_print(0, "BEFORE LOAD, AFTER ACCOUNT CREATE")
console_print(0, "Játékosok: %i", p_playernum)
console_print(0, "id: %i", id)
console_print(0, "hashid: %i", get_user_userid(id))
console_print(0, "Név: %s | SteamId: %s", Player[id][f_PlayerNames], Player[id][steamid])
console_print(0, "Betöltetlen Account Id: %i", wId)
console_print(0, "Pontos idő: %s", sDateAndTime)
console_print(0, "-----------------------------")
log_to_file("Acc0id.txt", "Jatekosok: %i, sqlid: %i, hashid: %i, Nev: %s S: %s, Hibas Acccount id: %i Pontos ido: %s", p_playernum, id, get_user_userid(id), Player[id][f_PlayerNames], Player[id][steamid], wId, sDateAndTime)
console_print(id, "-----------------------------")
console_print(id, "BEFORE LOAD, AFTER ACCOUNT CREATE")
console_print(id, " ");
console_print(id, "Hibajelentes a hibas account betoltesrol!")
console_print(id, "Jatekosok: %i", p_playernum)
console_print(id, "id: %i", id)
console_print(id, "hashid: %i", get_user_userid(id))
console_print(id, "Nev: %s | SteamId: %s", Player[id][f_PlayerNames], Player[id][steamid])
console_print(id, "Betoltetlen Account Id: %i", wId)
console_print(id, "Pontos ido: %s", sDateAndTime)
console_print(id, " ");
console_print(id, "Ha a hiba tovabbra is fent all, keress fel egy tulajdonost!")
console_print(id, "A hiba megoldasaig, a szerver kirug, hogy ne legyen adatvesztesed!")
console_print(id, "-----------------------------")
server_cmd("kick #%d ^"Hibás fiókbetöltés! További információk a konzolban!^"", get_user_userid(id));
}
Load_All(id);
}
}
}
public QuerySelectProfile(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, "Dollars"), g_dollar[id]);
SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Exp"), EXPT[id]);
//Player[id][EXP] = float(SQL_ReadResult(Query, 8))/100
g_Tools[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "STTool"));
mvpr_have_selectedkit[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "selectedkit"));
masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "jatszottido"));
g_SkinBeKi[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SkinBeKi"));
Player[id][FragWins] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FragWins"));
HudOff[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "HudBeKi"));
g_Tools[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Nevcedula"));
premiumpont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "premiumpont"));
g_VipTime[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "viptime"));
Vip[id][PremiumTime] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "PremiumTime"));
g_Admin_Level[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Admin_Szint"));
Player[id][SSzint] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "KSzint"));
hs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "fejloves"));
oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles"));
for(new i;i < LADASZAM; i++)
{
new String[64];
formatex(String, charsmax(String), "Case%d", i);
Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
for(new i;i < LADASZAM; i++)
{
new String[64];
formatex(String, charsmax(String), "Keys%d", i);
LadaK[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
Set_Permissions(id)
}
else
{
sql_create_profiles_row(id);
}
}
}
public QuerySelectTester(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, "Name"), Player[id][f_PlayerNames], 32);
erdem[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "van"));
}
}
}
public QuerySelectWeapon(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) {
for(new i;i < FEGYO; i++)
{
new String[64];
formatex(String, charsmax(String), "F_%d", i);
g_Weapons[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
}
else
{
sql_create_weapon_row(id);
}
}
}
public QuerySelectNevcedula(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) {
for(new i;i < FEGYO; i++)
{
new String[64];
formatex(String, charsmax(String), "N_%d", i);
SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String), g_GunNames[i][id], charsmax(g_GunNames[]));
}
}
else
{
sql_create_nametag_row(id);
}
}
}
public QuerySelectStattrak(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) {
for(new i;i < FEGYO; i++)
{
new String[64];
formatex(String, charsmax(String), "st_%d", i);
g_StatTrak[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
}
else
{
sql_create_st_row(id)
}
}
}
public QuerySelectStKills(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) {
for(new i;i < FEGYO; i++)
{
new String[64];
formatex(String, charsmax(String), "stk_%d", i);
g_StatTrakKills[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
}
else
{
sql_create_stk_row(id);
}
}
}
public QuerySelectSkin(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) {
Selectedgun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin0"));
Selectedgun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin1"));
Selectedgun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin2"));
Selectedgun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin3"));
Selectedgun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skin4"));
}
else
{
sql_create_skin_row(id);
}
}
}
public QuerySelectMusic(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) {
for(new i;i < Music; i++)
{
new String[64];
formatex(String, charsmax(String), "Kit%d", i);
mvpr_kit[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
}
else
{
sql_create_music_row(id);
}
}
}
public client_disconnected(id)
{
for(new i; i < 9; i++)
{
switch(i)
{
case 0: Update_Regi(id);
case 1: Update(id);
case 2: Update_Fegyver(id);
case 3: Update_Stattrak(id);
case 4: Update_StattrakKills(id);
case 5: Update_Nametag(id);
case 6: Update_Skin(id);
case 7: Update_Testers(id);
case 8: Update_Music(id);
}
}
}
public Update_fragers(){
static Query[10048];
new Len;
new sDate[11];
get_time("%Y/%m/%d", sDate, 11);
Len += formatex(Query[Len], charsmax(Query), "UPDATE `frag_counters` SET ");
Len += formatex(Query[Len], charsmax(Query)-Len, "Frags = ^"%i^", ", Frags);
Len += formatex(Query[Len], charsmax(Query)-Len, "Frags = ^"%i^" WHERE `Date` = ^"%s^"", Frags, sDate);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_Regi(id){
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `Players` SET ");
Len += formatex(Query[Len], charsmax(Query)-Len, "gametime = ^"%i^", ", masodpercek[id]+get_user_time(id));
Len += formatex(Query[Len], charsmax(Query)-Len, "gametime = ^"%i^" WHERE `id` = %d;", masodpercek[id], g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update(id){
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `Profiles` SET ");
Len += formatex(Query[Len], charsmax(Query)-Len, "Dollars = ^"%.2f^", ", g_dollar[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "gamename = ^"%s^", ", Player[id][f_PlayerNames]);
Len += formatex(Query[Len], charsmax(Query)-Len, "halal = ^"%i^", ", hl[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "selectedkit = ^"%i^", ", mvpr_have_selectedkit[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "FragWins = ^"%i^", ", Player[id][FragWins]);
Len += formatex(Query[Len], charsmax(Query)-Len, "PremiumTime = ^"%i^", ", Vip[id][PremiumTime]);
Len += formatex(Query[Len], charsmax(Query)-Len, "oles = ^"%i^", ", oles[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "SkinBeKi = ^"%i^", ", g_SkinBeKi[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "HudBeKi = ^"%i^", ", HudOff[id]);
//Len += formatex(Query[Len], charsmax(Query)-Len, "ChatPrefix = ^"%s^", ", g_Chat_Prefix[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "vanprefix = ^"%i^", ", VanPrefix[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "jatszottido = ^"%i^", ", masodpercek[id]+get_user_time(id));
Len += formatex(Query[Len], charsmax(Query)-Len, "viptime = ^"%i^", ", g_VipTime[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "premiumpont = ^"%i^", ", premiumpont[id])
Len += formatex(Query[Len], charsmax(Query)-Len, "Nevcedula = ^"%i^", ", g_Tools[1][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "STTool = ^"%i^", ", g_Tools[0][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Admin_Szint = ^"%i^", ", g_Admin_Level[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "KSzint = '%i', ", Player[id][SSzint]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Exp = ^"%.2f^", ", EXPT[id]);
for(new i;i < LADASZAM; i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "Case%d = ^"%i^", ", i, Lada[i][id]);
for(new i;i < LADASZAM; i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "Keys%d = ^"%i^", ", i, LadaK[i][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "oles = ^"%i^" WHERE `User_Id` = %d;", oles[id], g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_Skin(id){
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `Skins` SET ");
Len += formatex(Query[Len], charsmax(Query)-Len, "Skin0 = ^"%i^", ", Selectedgun[AK47][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Skin1 = ^"%i^", ", Selectedgun[M4A1][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Skin2 = ^"%i^", ", Selectedgun[AWP][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Skin3 = ^"%i^", ", Selectedgun[DEAGLE][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Skin4 = ^"%i^" WHERE `User_Id` = %d;", Selectedgun[KNIFE][id], g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_Music(id){
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `MusicKits` SET ");
for(new i;i < Music; i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "Kit%d = ^"%i^", ", i, mvpr_kit[i][id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Parameter = '0' WHERE `User_Id` = %d;", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_Stattrak(id)
{
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `Stattrak` SET ");
for(new i;i < FEGYO; i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "st_%d = ^"%i^", ", i, g_StatTrak[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ")
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_StattrakKills(id)
{
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `StattrakKills` SET ");
for(new i;i < FEGYO; i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "stk_%d = ^"%i^", ", i, g_StatTrakKills[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ")
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_Fegyver(id)
{
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `Weapon` SET ");
for(new i;i < FEGYO; i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "F_%d = ^"%i^", ", i, g_Weapons[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ")
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_Nametag(id)
{
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `Nevcedula` SET ");
for(new i;i < FEGYO; i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "N_%d = ^"%s^", ", i, g_GunNames[i][id]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ")
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update_Testers(id)
{
static Query[10048];
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `shedi_testers` SET ");
Len += formatex(Query[Len], charsmax(Query)-Len, "Name = ^"%s^", ", Player[id][f_PlayerNames]);
Len += format(Query[Len], charsmax(Query)-Len,"Parameter = '0' ")
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE `User_Id` = %d;", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
//sql_update_account1(id);
}
public sql_create_Players_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `Players` (`steamid`) VALUES (^"%s^");", Player[id][steamid]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_profiles_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `Profiles` (`User_Id`) VALUES (%d);", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_skin_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `Skins` (`User_Id`) VALUES (%d);", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_nametag_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `Nevcedula` (`User_Id`) VALUES (%d);", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_weapon_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `Weapon` (`User_Id`) VALUES (%d);", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_testers_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `shedi_testers` (`User_Id`,`Name`) VALUES (%d, ^"%s^");", g_Id[id], Player[id][f_PlayerNames]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_st_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `Stattrak` (`User_Id`) VALUES (%d);", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_stk_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `StattrakKills` (`User_Id`) VALUES (%d);", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public sql_create_music_row(id){
static Query[10048];
formatex(Query, charsmax(Query), "INSERT INTO `MusicKits` (`User_Id`) VALUES (%d);", g_Id[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}