Mnożenie się nicków w SQL
-
-
Jaszczurek
24.04.2016
Witam. Coś jest nie tak z zapisem w pluginie, zamiast zapisywać jednego nicku w tabeli, to zapisuje ich kilka (po zmianie mapy lub restarcie serwera). Jak takie coś naprawić? Chciałbym żeby dla każdego zapisywał się jeden nick, bo po zmianie mapy wszystko się resetuje.
-
-
Linux'
24.04.2016
Przy nadpisywaniu danych, zamiast aktualizowac je do bazy tworzony jest pewnie nowy wpis. Co to za plugin, podaj wiecej szczegolow i najlepiej sma.
-
-
Jaszczurek
24.04.2016
Jest to ten plugin:
Spoiler
/* Plugin generated by AMXX-Studio */
#include <amxmodx>
#include <amxmisc>
#include <cstrike>
#include <engine>
#include <hamsandwich>
#include <colorchat>
#include <sqlx>
#include <csx>
#define PLUGIN "CS:GO Mod"
#define VERSION "1.0"
#define AUTHOR " "
#define LOG_FILE_AK47 "addons/amxmodx/logs/csgomod/csgo_ak47.txt"
#define LOG_FILE_M4A1 "addons/amxmodx/logs/csgomod/csgo_m4a1.txt"
#define LOG_FILE_AWP "addons/amxmodx/logs/csgomod/csgo_awp.txt"
#define LOG_FILE_DGL "addons/amxmodx/logs/csgomod/csgo_deagle.txt"
#define LOG_FILE_FAMAS "addons/amxmodx/logs/csgomod/csgo_famas.txt"
#define LOG_FILE_KNIFE "addons/amxmodx/logs/csgomod/csgo_knife.txt"
#define TASK_SAVEME 768
#define SPRAWDZ 3431
new weapon, year, month, day, hour, minute, second;
new g_hudmsg, runda;
new bool:Loaded[33];
//new nazwa_gracza[33][32];
//new vaultAK47, vaultM4A1, vaultAWP, vaultDGL, vaultFamas, vaultKnife, vaultCase;
#include "csgo/knives.inl"
#include "csgo/awp.inl"
#include "csgo/ak47.inl"
#include "csgo/m4a1.inl"
#include "csgo/deagle.inl"
#include "csgo/famas.inl"
#include "csgo/cases.inl"
#include "csgo/menu.inl"
#include "csgo/reward.inl"
#include "csgo/admin.inl"
#include "csgo/sql.inl"
public plugin_init() {
register_plugin(PLUGIN, VERSION, AUTHOR)
new classname[32]
for(new i=1;i<31;++i)
if(i!=2) {
get_weaponname(i,classname,31)
RegisterHam(Ham_Item_Deploy, classname, "fwItemDeploy",1);
}
register_event("30","Message_Intermission","a");
register_event("DeathMsg", "DeathMsg", "a")
register_event("HLTV", "NowaRunda", "a", "1=0", "2=0");
register_clcmd("say /menu", "Menu");
register_clcmd("say_team /menu", "Menu");
register_clcmd("say /skin", "SelectSkin");
register_clcmd("say_team /skin", "SelectSkin");
register_clcmd("say /skiny", "SkinInfo");
register_clcmd("say_team /skiny", "SkinInfo");
register_clcmd("say /pomoc", "SkinInfo");
register_clcmd("say_team /pomoc", "SkinInfo");
register_clcmd("say /case", "CaseMenu");
register_clcmd("say_team /case", "CaseMenu");
register_clcmd("say /debug", "DebugMode", ADMIN_IMMUNITY);
g_hudmsg = CreateHudSyncObj()
/*vaultAK47=nvault_open("AK47")
vaultM4A1=nvault_open("M4A1")
vaultAWP=nvault_open("AWP")
vaultDGL=nvault_open("Deagle")
vaultFamas=nvault_open("Famas")
vaultKnife=nvault_open("Knife")
vaultCase=nvault_open("Case")*/
}
public plugin_natives() {
register_native("set_player_case_ak47", "SetCaseAK47", 1);
register_native("get_player_case_ak47", "GetCaseAK47", 1);
register_native("set_player_case_m4a1", "SetCaseM4A1", 1);
register_native("get_player_case_m4a1", "GetCaseM4A1", 1);
register_native("set_player_case_awp", "SetCaseAWP", 1);
register_native("get_player_case_awp", "GetCaseAWP", 1);
register_native("set_player_case_dgl", "SetCaseDGL", 1);
register_native("get_player_case_dgl", "GetCaseDGL", 1);
register_native("set_player_case_famas", "SetCaseFamas", 1);
register_native("get_player_case_famas", "GetCaseFamas", 1);
register_native("set_player_key", "SetKey", 1);
register_native("get_player_key", "GetKey", 1);
}
public plugin_precache() {
PrecacheKnives();
PrecacheM4A1();
PrecacheAWP();
PrecacheAK47();
PrecacheDGL();
PrecacheFamas();
precache_sound("csgo/yay.mp3");
precache_sound("csgo/gotkey2.mp3");
}
public client_connect(id) {
TakeAK47(id);
TakeAWP(id);
TakeDGL(id);
TakeFamas(id);
TakeKnives(id);
TakeM4A1(id);
pKey[id] = 0
pCaseAK47[id] = 0
pCaseM4A1[id] = 0
pCaseAWP[id] = 0
pCaseDGL[id] = 0
pCaseFamas[id] = 0
Loaded[id] = false;
/*get_user_name(id, nazwa_gracza[id], 31);
LoadDataAK47(id)
LoadDataM4A1(id)
LoadDataAWP(id)
LoadDataDGL(id)
LoadDataFamas(id)
LoadDataKnife(id)
LoadDataCase(id)*/
LoadData(id);
set_task(25.0, "CheckData", id);
}
public client_disconnect(id) {
/*SaveDataAK47(id);
SaveDataM4A1(id);
SaveDataAWP(id);
SaveDataDGL(id);
SaveDataFamas(id);
SaveDataKnife(id);
SaveDataCase(id);*/
if(Loaded[id]) SaveData(id);
/*TakeAK47(id);
TakeAWP(id);
TakeDGL(id);
TakeFamas(id);
TakeKnives(id);
TakeM4A1(id);
pKey[id] = 0
pCaseAK47[id] = 0
pCaseM4A1[id] = 0
pCaseAWP[id] = 0
pCaseDGL[id] = 0
pCaseFamas[id] = 0*/
}
public SkinInfo(id)
show_motd(id, "skiny.txt", "Info Skiny");
public fwItemDeploy(wpn){
static id;
id = entity_get_edict(wpn, EV_ENT_owner)
weapon = cs_get_weapon_id(wpn)
if (id > 32 || id < 1)
return HAM_IGNORED;
SetKnifeSkin(id);
SetM4A1Skin(id);
SetAK47Skin(id);
SetAWPSkin(id);
SetDGLSkin(id);
SetFamasSkin(id);
return HAM_HANDLED;
}
public DeathMsg()
{
new kid = read_data(1);
new vid = read_data(2);
if(!is_user_alive(kid) || !is_user_connected(vid) || !is_user_connected(kid))
return PLUGIN_HANDLED;
if(random(100) < 3) {
pKey[kid]++;
set_hudmessage(0, 255, 0, 0.45, 0.50, 2, 0.1, 4.0, 0.1, 0.1, -1)
ShowSyncHudMsg(kid, g_hudmsg, "KLUCZ!")
client_cmd(kid, "mp3 play sound/csgo/gotkey2.mp3");
}
return PLUGIN_CONTINUE;
}
public bomb_planted(planter)
{
if(random(100) < 20) {
pKey[planter]++;
set_hudmessage(0, 255, 0, 0.45, 0.50, 2, 0.1, 4.0, 0.1, 0.1, -1)
ShowSyncHudMsg(planter, g_hudmsg, "KLUCZ!")
client_cmd(planter, "mp3 play sound/csgo/gotkey2.mp3");
}
}
public bomb_defused(defuser)
{
if(random(100) < 20) {
pKey[defuser]++;
set_hudmessage(0, 255, 0, 0.45, 0.50, 2, 0.1, 4.0, 0.1, 0.1, -1)
ShowSyncHudMsg(defuser, g_hudmsg, "KLUCZ!")
client_cmd(defuser, "mp3 play sound/csgo/gotkey2.mp3");
}
}
public NowaRunda()
{
runda++;
if(runda % 2){
for(new id=1;id<=g_MaxPlayers;id++) {
if(!is_user_connected(id)) continue;
SaveData(id);
}
}
}
public SetCaseAK47(id, amount){
pCaseAK47[id] = amount;
}
public GetCaseAK47(id)
return pCaseAK47[id];
public SetCaseM4A1(id, amount){
pCaseM4A1[id] = amount;
}
public GetCaseM4A1(id)
return pCaseM4A1[id];
public SetCaseAWP(id, amount){
pCaseAWP[id] = amount;
}
public GetCaseAWP(id)
return pCaseAWP[id];
public SetCaseDGL(id, amount){
pCaseDGL[id] = amount;
}
public GetCaseDGL(id)
return pCaseDGL[id];
public SetCaseFamas(id, amount){
pCaseFamas[id] = amount;
}
public GetCaseFamas(id)
return pCaseFamas[id];
public SetKey(id, amount){
pKey[id] = amount;
}
public GetKey(id)
return pKey[id];
stock RandomPlayer(){
new g_PlayersIndex[33], g_Value;
for(new i = 1; i <= g_MaxPlayers; i++){
if(!is_user_connected(i)) continue;
if(cs_get_user_team(i) == CS_TEAM_SPECTATOR) continue;
if(Choosen[i]) continue;
g_PlayersIndex[g_Value] = i;
g_Value++;
}
return g_PlayersIndex[random(g_Value)];
}
/* AMXX-Studio Notes - DO NOT MODIFY BELOW HERE
*{\\ rtf1\\ ansi\\ deff0{\\ fonttbl{\\ f0\\ fnil Tahoma;}}\n\\ viewkind4\\ uc1\\ pard\\ lang1033\\ f0\\ fs16 \n\\ par }
*/
Przez to duplikowanie się, po zmianie mapy nikt nie ma skinów, skrzynek, kluczy.
+ dorzucam jeszcze plik sql.inl który pewnie będzie potrzebny:
Spoiler
new g_MaxPlayers;
new Handle:gTuple, bool:gConnected;
public plugin_cfg() {
gTuple = SQL_MakeDbTuple("DaneDoBazy", "DaneDoBazy" , "DaneDoBazy", "DaneDoBazy")
new error, szError[128];
new Handle:qConn = SQL_Connect(gTuple, error, szError, 127);
if(error){
log_amx("Error: %s", szError);
return;
}
else gConnected = true;
SQL_FreeHandle(qConn);
g_MaxPlayers = get_maxplayers();
}
/*public SaveData(id) {
if(!gConnected || !Loaded[id]) return
new Data[1]
Data[0] = id
new qCommand[768], szName[64]
get_user_name(id, szName, charsmax(szName))
format(qCommand, charsmax(qCommand), "UPDATE Noze SET Bayonet='%d', Butterfly='%d', Flip='%d', Gut='%d', Huntsman='%d', Karambit='%d', M9='%d' WHERE nick='%s'", pKnife[id][1], pKnife[id][2], pKnife[id][3], pKnife[id][4], pKnife[id][5], pKnife[id][6], pKnife[id][7], szName);
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "UPDATE AK47 SET Vulcan='%d', Redline='%d', Assimov='%d', FireSerpent='%d' WHERE nick='%s'", pAK47[id][1], pAK47[id][2], pAK47[id][3], pAK47[id][4], szName);
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "UPDATE M4A1 SET Cyrex='%d', DragonKing='%d', Assimov='%d', Nuclear='%d' WHERE nick='%s'", pM4A1[id][1], pM4A1[id][2], pM4A1[id][3], pM4A1[id][4], szName);
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "UPDATE AWP SET Hawking='%d', Redline='%d', Assimov='%d', DragonLore='%d' WHERE nick='%s'", pAWP[id][1], pAWP[id][2], pAWP[id][3], pAWP[id][4], szName);
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "UPDATE DGL SET Asking='%d', Engraved='%d', Conspiracy='%d', Skrillex='%d' WHERE nick='%s'", pDGL[id][1], pDGL[id][2], pDGL[id][3], pDGL[id][4], szName);
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "UPDATE Skrzynie SET Klucz='%d', CaseAK47='%d', CaseM4A1='%d', CaseAWP='%d', CaseDGL='%d' WHERE nick='%s'", pKey[id], pCaseAK47[id], pCaseM4A1[id], pCaseAWP[id], pCaseDGL[id], szName);
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)
}*/
public SaveData(id) {
if(!gConnected || !Loaded[id]) return
new Data[1]
Data[0] = id
new qCommand[3192], iLen, szName[64]
get_user_name(id, szName, charsmax(szName))
/*iLen = formatex(qCommand, sizeof qCommand -1, "UPDATE CSGOMOD SET VulcanAK47='%d', RedlineAK47='%d', AssimovAK47='%d', FSAK47='%d',", pAK47[id][1], pAK47[id][2], pAK47[id][3], pAK47[id][4], szName);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "CyrexM4A1='%d', DKM4A1='%d', AssimovM4A1='%d', NuclearM4A1='%d',", pM4A1[id][1], pM4A1[id][2], pM4A1[id][3], pM4A1[id][4], szName);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "HawkingAWP='%d', RedlineAWP='%d', AssimovAWP='%d', DLAWP='%d',", pAWP[id][1], pAWP[id][2], pAWP[id][3], pAWP[id][4], szName);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "AskingDGL='%d', EngravedDGL='%d', ConspiracyDGL='%d', SkrillexDGL='%d',", pDGL[id][1], pDGL[id][2], pDGL[id][3], pDGL[id][4], szName);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "Bayonet='%d', Butterfly='%d', Flip='%d', Gut='%d', Huntsman='%d', Karambit='%d', M9='%d',", pKnife[id][1], pKnife[id][2], pKnife[id][3], pKnife[id][4], pKnife[id][5], pKnife[id][6], pKnife[id][7], szName);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "Klucz='%d', CaseAK47='%d', CaseM4A1='%d', CaseAWP='%d', CaseDGL='%d' WHERE nick='%s'", pKey[id], pCaseAK47[id], pCaseM4A1[id], pCaseAWP[id], pCaseDGL[id], szName);
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)*/
iLen = formatex(qCommand, sizeof qCommand -1, "INSERT INTO CSGOMOD (`nick`, `VulcanAK47`, `RedlineAK47`, `AssimovAK47`, `FSAK47`,`CyrexM4A1`, `DKM4A1`, `AssimovM4A1`, `NuclearM4A1`, `HawkingAWP`, `RedlineAWP`, `AssimovAWP`, `DLAWP`,");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`AskingDGL`, `EngravedDGL`, `ConspiracyDGL`, `SkrillexDGL`, `Bayonet`, `Butterfly`, `Flip`, `Gut`, `Huntsman`, `Karambit`, `M9`,");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`Klucz`, `CaseAK47`, `CaseM4A1`, `CaseAWP`, `CaseDGL`, `CaseFamas`, `PulseFamas`, `DKFamas`, `PixelFamas`, `SkullFamas`) ");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "VALUES ('%s', %d, %d, %d, %d,%d, %d, %d, %d,", szName, pAK47[id][1], pAK47[id][2], pAK47[id][3], pAK47[id][4], pM4A1[id][1], pM4A1[id][2], pM4A1[id][3], pM4A1[id][4]);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "%d, %d, %d, %d,%d, %d, %d, %d,", pAWP[id][1], pAWP[id][2], pAWP[id][3], pAWP[id][4], pDGL[id][1], pDGL[id][2], pDGL[id][3], pDGL[id][4]);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "%d, %d, %d, %d, %d, %d, %d,", pKnife[id][1], pKnife[id][2], pKnife[id][3], pKnife[id][4], pKnife[id][5], pKnife[id][6], pKnife[id][7]);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "%d, %d, %d, %d, %d, %d,%d, %d, %d, %d)", pKey[id], pCaseAK47[id], pCaseM4A1[id], pCaseAWP[id], pCaseDGL[id], pCaseFamas[id], pFamas[id][1], pFamas[id][2], pFamas[id][3], pFamas[id][4]);
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "ON DUPLICATE KEY UPDATE `nick`=VALUES(`nick`),`VulcanAK47`=VALUES(`VulcanAK47`), `RedlineAK47`=VALUES(`RedlineAK47`), `AssimovAK47`=VALUES(`AssimovAK47`), `FSAK47`=VALUES(`FSAK47`),");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`CyrexM4A1`=VALUES(`CyrexM4A1`), `DKM4A1`=VALUES(`DKM4A1`), `AssimovM4A1`=VALUES(`AssimovM4A1`), `NuclearM4A1`=VALUES(`NuclearM4A1`),");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`HawkingAWP`=VALUES(`HawkingAWP`), `RedlineAWP`=VALUES(`RedlineAWP`), `AssimovAWP`=VALUES(`AssimovAWP`), `DLAWP`=VALUES(`DLAWP`),");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`AskingDGL`=VALUES(`AskingDGL`), `EngravedDGL`=VALUES(`EngravedDGL`), `ConspiracyDGL`=VALUES(`ConspiracyDGL`), `SkrillexDGL`=VALUES(`SkrillexDGL`),");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`Bayonet`=VALUES(`Bayonet`), `Butterfly`=VALUES(`Butterfly`), `Flip`=VALUES(`Flip`), `Gut`=VALUES(`Gut`), `Huntsman`=VALUES(`Huntsman`),`Karambit`=VALUES(`Karambit`), `M9`=VALUES(`M9`),");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`Klucz`=VALUES(`Klucz`), `CaseAK47`=VALUES(`CaseAK47`), `CaseM4A1`=VALUES(`CaseM4A1`), `CaseAWP`=VALUES(`CaseAWP`), `CaseDGL`=VALUES(`CaseDGL`), `CaseFamas`=VALUES(`CaseFamas`),");
iLen += formatex(qCommand[iLen], (sizeof qCommand - 1) - iLen, "`PulseFamas`=VALUES(`PulseFamas`), `DKFamas`=VALUES(`DKFamas`), `PixelFamas`=VALUES(`PixelFamas`), `SkullFamas`=VALUES(`SkullFamas`);");
/*
iLen = formatex(qCommand, sizeof(qCommand), "INSERT INTO CSGOMOD (`nick`, `VulcanAK47`, `RedlineAK47`, `AssimovAK47`, `FSAK47`,`CyrexM4A1`, `DKM4A1`, `AssimovM4A1`, `NuclearM4A1`, `HawkingAWP`, `RedlineAWP`, `AssimovAWP`, `DLAWP`,");
iLen += formatex(qCommand[iLen], sizeof(qCommand) - iLen, "`AskingDGL`, `EngravedDGL`, `ConspiracyDGL`, `SkrillexDGL`, `Bayonet`, `Butterfly`, `Flip`, `Gut`, `Huntsman`, `Karambit`, `M9`,");
iLen += formatex(qCommand[iLen], sizeof(qCommand) - iLen, "`Klucz`, `CaseAK47`, `CaseM4A1`, `CaseAWP`, `CaseDGL`, `CaseFamas`, `PulseFamas`, `DKFamas`, `PixelFamas`, `SkullFamas`) ");
iLen += formatex(qCommand[iLen], sizeof(qCommand) - iLen, "VALUES ('%s', %d, %d, %d, %d,%d, %d, %d, %d,", szName, pAK47[id][1], pAK47[id][2], pAK47[id][3], pAK47[id][4], pM4A1[id][1], pM4A1[id][2], pM4A1[id][3], pM4A1[id][4]);
iLen += formatex(qCommand[iLen], sizeof(qCommand) - iLen, "%d, %d, %d, %d,%d, %d, %d, %d,", pAWP[id][1], pAWP[id][2], pAWP[id][3], pAWP[id][4], pDGL[id][1], pDGL[id][2], pDGL[id][3], pDGL[id][4]);
iLen += formatex(qCommand[iLen], sizeof(qCommand) - iLen, "%d, %d, %d, %d, %d, %d, %d,", pKnife[id][1], pKnife[id][2], pKnife[id][3], pKnife[id][4], pKnife[id][5], pKnife[id][6], pKnife[id][7]);
iLen += formatex(qCommand[iLen], sizeof(qCommand) - iLen, "%d, %d, %d, %d, %d, %d,%d, %d, %d, %d)", pKey[id], pCaseAK47[id], pCaseM4A1[id], pCaseAWP[id], pCaseDGL[id], pCaseFamas[id], pFamas[id][1], pFamas[id][2], pFamas[id][3], pFamas[id][4]);
iLen2 = formatex(Two, sizeof(Two), "ON DUPLICATE KEY UPDATE `nick`=VALUES(`nick`),`VulcanAK47`=VALUES(`VulcanAK47`), `RedlineAK47`=VALUES(`RedlineAK47`), `AssimovAK47`=VALUES(`AssimovAK47`), `FSAK47`=VALUES(`FSAK47`),");
iLen2 += formatex(Two[iLen2], sizeof(Two) - iLen2, "`CyrexM4A1`=VALUES(`CyrexM4A1`),`DKM4A1`=VALUES(`DKM4A1`),`AssimovM4A1`=VALUES(`AssimovM4A1`),`NuclearM4A1`=VALUES(`NuclearM4A1`),`HawkingAWP`=VALUES(`HawkingAWP`),`RedlineAWP`=VALUES(`RedlineAWP`),");
iLen2 += formatex(Two[iLen2], sizeof(Two) - iLen2, "`AssimovAWP`=VALUES(`AssimovAWP`),`DLAWP`=VALUES(`DLAWP`),`AskingDGL`=VALUES(`AskingDGL`), `EngravedDGL`=VALUES(`EngravedDGL`),`ConspiracyDGL`=VALUES(`ConspiracyDGL`), `SkrillexDGL`=VALUES(`SkrillexDGL`),");
iLen2 += formatex(Two[iLen2], sizeof(Two) - iLen2, "`Bayonet`=VALUES(`Bayonet`),`Butterfly`=VALUES(`Butterfly`),`Flip`=VALUES(`Flip`),`Gut`=VALUES(`Gut`),`Huntsman`=VALUES(`Huntsman`),`Karambit`=VALUES(`Karambit`),`M9`=VALUES(`M9`),");
iLen2 += formatex(Two[iLen2], sizeof(Two) - iLen2, "`Klucz`=VALUES(`Klucz`),`CaseAK47`=VALUES(`CaseAK47`),`CaseM4A1`=VALUES(`CaseM4A1`),`CaseAWP`=VALUES(`CaseAWP`),`CaseDGL`=VALUES(`CaseDGL`),`CaseFamas`=VALUES(`CaseFamas`),");
iLen2 += formatex(Two[iLen2], sizeof(Two) - iLen2, "`PulseFamas`=VALUES(`PulseFamas`), `DKFamas`=VALUES(`DKFamas`), `PixelFamas`=VALUES(`PixelFamas`), `SkullFamas`=VALUES(`SkullFamas`);");
*/
//add(qCommand, sizeof(qCommand), Two, sizeof(Two));
SQL_ThreadQuery(gTuple, "SaveHandler", qCommand, Data, 1)
//iLen = 0;
//iLen2 = 0;
}
public SaveHandler(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
//new id = Data[0] //Not using
if(Errorcode)
log_amx("Blad w zapytaniu: %s [SaveData]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [SaveData]")
return PLUGIN_CONTINUE
}
return PLUGIN_CONTINUE
}
/*public LoadData(id) {
if(!gConnected) return
new Data[1]
Data[0] = id;
new qCommand[512], szName[64]
get_user_name(id, szName, charsmax(szName))
format(qCommand, charsmax(qCommand), "INSERT INTO Noze (`nick`) VALUES ('%s') ON DUPLICATE KEY UPDATE `nick`='%s';", szName, szName)
SQL_ThreadQuery(gTuple, "LoadHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "INSERT INTO AK47 (`nick`) VALUES ('%s') ON DUPLICATE KEY UPDATE `nick`='%s';", szName, szName)
SQL_ThreadQuery(gTuple, "LoadHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "INSERT INTO M4A1 (`nick`) VALUES ('%s') ON DUPLICATE KEY UPDATE `nick`='%s';", szName, szName)
SQL_ThreadQuery(gTuple, "LoadHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "INSERT INTO AWP (`nick`) VALUES ('%s') ON DUPLICATE KEY UPDATE `nick`='%s';", szName, szName)
SQL_ThreadQuery(gTuple, "LoadHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "INSERT INTO DGL (`nick`) VALUES ('%s') ON DUPLICATE KEY UPDATE `nick`='%s';", szName, szName)
SQL_ThreadQuery(gTuple, "LoadHandler", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "INSERT INTO Skrzynie (`nick`) VALUES ('%s') ON DUPLICATE KEY UPDATE `nick`='%s';", szName, szName)
SQL_ThreadQuery(gTuple, "LoadHandler", qCommand, Data, 1)
}*/
public LoadData(id) {
if(!gConnected) return
new Data[1]
Data[0] = id;
new qCommand[512], szName[64]
get_user_name(id, szName, charsmax(szName))
format(qCommand, charsmax(qCommand), "INSERT INTO CSGOMOD (`nick`) VALUES ('%s') ON DUPLICATE KEY UPDATE `nick`='%s';", szName, szName)
SQL_ThreadQuery(gTuple, "LoadHandler", qCommand, Data, 1)
}
public LoadHandler(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
//new id = Data[0] //Not using
if(Errorcode)
log_amx("Blad w zapytaniu: %s [LoadData]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [LoadData]")
return PLUGIN_CONTINUE
}
return PLUGIN_CONTINUE
}
/*public CheckData(id) {
if(!gConnected) return
new Data[1]
Data[0] = id
new qCommand[512], szName[64]
get_user_name(id, szName, charsmax(szName))
format(qCommand, charsmax(qCommand), "SELECT * FROM `Noze` WHERE `nick` = '%s'", szName)
SQL_ThreadQuery(gTuple, "CheckHandlerKnives", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "SELECT * FROM `AK47` WHERE `nick` = '%s'", szName)
SQL_ThreadQuery(gTuple, "CheckHandlerAK47", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "SELECT * FROM `M4A1` WHERE `nick` = '%s'", szName)
SQL_ThreadQuery(gTuple, "CheckHandlerM4A1", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "SELECT * FROM `AWP` WHERE `nick` = '%s'", szName)
SQL_ThreadQuery(gTuple, "CheckHandlerAWP", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "SELECT * FROM `DGL` WHERE `nick` = '%s'", szName)
SQL_ThreadQuery(gTuple, "CheckHandlerDGL", qCommand, Data, 1)
format(qCommand, charsmax(qCommand), "SELECT * FROM `Skrzynie` WHERE `nick` = '%s'", szName)
SQL_ThreadQuery(gTuple, "CheckHandlerCases", qCommand, Data, 1)
}*/
public CheckData(id) {
if(!gConnected) return
new Data[1]
Data[0] = id
new qCommand[512], szName[64]
get_user_name(id, szName, charsmax(szName))
format(qCommand, charsmax(qCommand), "SELECT * FROM `CSGOMOD` WHERE `nick` = '%s'", szName)
SQL_ThreadQuery(gTuple, "CheckHandler", qCommand, Data, 1)
}
public CheckHandler(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
new id = Data[0]
if(Errorcode)
log_amx("Blad w zapytaniu: %s [CheckData]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [CheckData]")
return PLUGIN_CONTINUE
}
client_print(id, print_center, "Skiny Zaladowane!");
if(SQL_MoreResults(Query)){
pAK47[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VulcanAK47"))
pAK47[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "RedlineAK47"))
pAK47[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AssimovAK47"))
pAK47[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FSAK47"))
pM4A1[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CyrexM4A1"))
pM4A1[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DKM4A1"))
pM4A1[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AssimovM4A1"))
pM4A1[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "NuclearM4A1"))
pAWP[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "HawkingAWP"))
pAWP[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "RedlineAWP"))
pAWP[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AssimovAWP"))
pAWP[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DLAWP"))
pDGL[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AskingDGL"))
pDGL[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "EngravedDGL"))
pDGL[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ConspiracyDGL"))
pDGL[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SkrillexDGL"))
pKnife[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Bayonet"))
pKnife[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Butterfly"))
pKnife[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Flip"))
pKnife[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Gut"))
pKnife[id][5] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Huntsman"))
pKnife[id][6] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Karambit"))
pKnife[id][7] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "M9"))
pKey[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Klucz"))
pCaseAK47[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseAK47"))
pCaseM4A1[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseM4A1"))
pCaseAWP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseAWP"))
pCaseDGL[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseDGL"))
pCaseFamas[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseFamas"))
pFamas[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "PulseFamas"))
pFamas[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DKFamas"))
pFamas[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "PixelFamas"))
pFamas[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SkullFamas"))
Loaded[id] = true;
}
return PLUGIN_CONTINUE;
}
/*public CheckHandlerKnives(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
new id = Data[0]
if(Errorcode)
log_amx("Blad w zapytaniu: %s [CheckDataKnives]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [CheckDataKnives]")
return PLUGIN_CONTINUE
}
if(SQL_MoreResults(Query)){
pKnife[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Bayonet"))
pKnife[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Butterfly"))
pKnife[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Flip"))
pKnife[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Gut"))
pKnife[id][5] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Huntsman"))
pKnife[id][6] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Karambit"))
pKnife[id][7] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "M9"))
}
return PLUGIN_CONTINUE;
}
public CheckHandlerAK47(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
new id = Data[0]
if(Errorcode)
log_amx("Blad w zapytaniu: %s [CheckDataAK47]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [CheckDataAK47]")
return PLUGIN_CONTINUE
}
if(SQL_MoreResults(Query)){
pAK47[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Vulcan"))
pAK47[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Redline"))
pAK47[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Assimov"))
pAK47[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FireSerpent"))
}
return PLUGIN_CONTINUE;
}
public CheckHandlerM4A1(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
new id = Data[0]
if(Errorcode)
log_amx("Blad w zapytaniu: %s [CheckDataM4A1]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [CheckDataM4A1]")
return PLUGIN_CONTINUE
}
if(SQL_MoreResults(Query)){
pM4A1[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Cyrex"))
pM4A1[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DragonKing"))
pM4A1[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Assimov"))
pM4A1[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Nuclear"))
}
return PLUGIN_CONTINUE;
}
public CheckHandlerAWP(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
new id = Data[0]
if(Errorcode)
log_amx("Blad w zapytaniu: %s [CheckDataAWP]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [CheckDataAWP]")
return PLUGIN_CONTINUE
}
if(SQL_MoreResults(Query)){
pAWP[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Hawking"))
pAWP[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Redline"))
pAWP[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Assimov"))
pAWP[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DragonLore"))
}
return PLUGIN_CONTINUE;
}
public CheckHandlerDGL(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
new id = Data[0]
if(Errorcode)
log_amx("Blad w zapytaniu: %s [CheckDataAWP]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [CheckDataAWP]")
return PLUGIN_CONTINUE
}
if(SQL_MoreResults(Query)){
pDGL[id][1] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Asking"))
pDGL[id][2] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Engraved"))
pDGL[id][3] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Conspiracy"))
pDGL[id][4] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skrillex"))
}
return PLUGIN_CONTINUE;
}
public CheckHandlerCases(FailState, Handle:Query, Error[], Errorcode, Data[], DataSize)
{
new id = Data[0]
if(Errorcode)
log_amx("Blad w zapytaniu: %s [CheckDataCases]", Error)
if(FailState == TQUERY_CONNECT_FAILED) {
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED) {
log_amx("Zapytanie anulowane [CheckDataCases]")
return PLUGIN_CONTINUE
}
if(SQL_MoreResults(Query)){
pKey[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Klucz"))
pCaseAK47[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseAK47"))
pCaseM4A1[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseM4A1"))
pCaseAWP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseAWP"))
pCaseDGL[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CaseDGL"))
Loaded[id] = true;
}
return PLUGIN_CONTINUE;
}*/
/* AMXX-Studio Notes - DO NOT MODIFY BELOW HERE
*{\\ rtf1\\ ansi\\ deff0{\\ fonttbl{\\ f0\\ fnil Tahoma;}}\n\\ viewkind4\\ uc1\\ pard\\ lang1033\\ f0\\ fs16 \n\\ par }
*/
Użytkownik Jaszczurek edytował ten post 24.04.2016 19:05
-
-
Linux'
25.04.2016
Jest dokładnie tak jak to opisałem. Trzeba by to przerobić poza tym kod to kompletna klapa, widzę całą mase rzeczy którą bym poporawiał. Niestety za dużo roboty jak dla mnie, by udzielić darmowej pomocy.
-
-
Jaszczurek
25.04.2016
Jest dokładnie tak jak to opisałem. Trzeba by to przerobić poza tym kod to kompletna klapa, widzę całą mase rzeczy którą bym poporawiał. Niestety za dużo roboty jak dla mnie, by udzielić darmowej pomocy.
Jeśli masz chęci żeby to naprawić, żeby działało jak trzeba, to mogę również zapłacić.
Poszło pw.
-
-
GwynBleidD
29.04.2016
Podaj strukturę bazy. Widzę przeczytałeś mój poradnik o tym, jak zoptymalizować zapytania INSERT / UPDATE, jednak nie do końca - nie dodałeś odpowiednich kluczy w bazie przez co każdy rekord jest dodawany jako nowy, zamiast nadpisywać istniejący.
