I am getting a problem in inserting a query in database. The character of my query is exceeding 1024 characters. Please tell me any option to run the query in warmod plugin.
char insertquery[1024];
char query[1024];
Format(insertquery, sizeof(insertquery), "INSERT INTO `%s` (`key_id`, `match_id`, `rounds_played`, `player_name`, `steam_id_64`, `team`, `kills`, `deaths`, `assists`, `head_shots`, `team_kills`, `assists_team_attack`, `damage`, `hits`, `shots`, `last_alive`, `clutch_won`, `1k`, `2k`, `3k`, `4k`, `5k`, `mvp`, `ak47`, `m4a1_silencer`, `m4a1_silencer_off`, `m4a1`, `galilar`, `famas`, `awp`, `p250`, `cz75a`, `glock`, `hkp2000`, `usp_silencer`, `usp_silencer_off`, `ump45`, `p90`, `bizon`, `mp7`, `nova`, `knife`, `elite`, `fiveseven`, `deagle`, `revolver`, `tec9`, `ssg08`, `scar20`, `aug`, `inferno`, `g3sg1`, `mac10`, `mp9`, `mag7`, `negev`, `m249`, `sawedoff`, `incgrenade`, `flashbang`, `smokegrenade`, `hegrenade`, `molotov`, `decoy`, `taser`, `xm1014`,`head`, `chest`, `stomach`, `left_arm`, `right_arm`, `left_leg`, `right_leg`) VALUES (NULL, %i, 2, '%s', '%s', %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i,%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i,%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i);", table_name, match_id, player_name, authid, team, round_stats[LOG_HIT_KILLS],round_stats[LOG_HIT_DEATHS], assist_stats[client][ASSIST_COUNT], round_stats[LOG_HIT_HEADSHOTS], round_stats[LOG_HIT_TEAMKILLS], assist_stats[client][ASSIST_COUNT_TK], round_stats[LOG_HIT_DAMAGE], round_stats[LOG_HIT_HITS], round_stats[LOG_HIT_SHOTS], clutch_stats[client][CLUTCH_LAST], clutch_won, k1, k2, k3, k4, k5, k1, weapon_value[0],weapon_value[1],weapon_value[2],weapon_value[3],weapon_value[4],weapon_value[5],weapon_value[6],weapon_value[7],weapon_value[8],weapon_value[9],weapon_value[10],weapon_value[11],weapon_value[12],weapon_value[13],weapon_value[14],weapon_value[15],weapon_value[16],weapon_value[17],weapon_value[18],weapon_value[19], weapon_value[20],weapon_value[21],weapon_value[22],weapon_value[23],weapon_value[24],weapon_value[25],weapon_value[26],weapon_value[27],weapon_value[28],weapon_value[29],weapon_value[30],weapon_value[31],weapon_value[32],weapon_value[33],weapon_value[34],weapon_value[35],weapon_value[36],weapon_value[37],weapon_value[38],weapon_value[39],weapon_value[40],weapon_value[41],weapon_value[42],round_stats[LOG_HIT_HEAD],round_stats[LOG_HIT_CHEST],round_stats[LOG_HIT_STOMACH], round_stats[LOG_HIT_LEFTARM],round_stats[LOG_HIT_RIGHTARM],round_stats[LOG_HIT_LEFTLEG],round_stats[LOG_HIT_RIGHTLEG]);
PrintToServer(insertquery);
Handle hPack = CreateDataPack();
WritePackString(hPack, insertquery);
if (SQL_DEBUG) {
LogError(query);
}
SQL_TQuery(hDatabase, MySQL_UploadRoundStatsReturn, query, hPack);
This is link
https://github.com/TGMaster/Sourcepa...ster/warmod.sp
Please let me know how to execute insert query with more than 1024 characters
Linear Mode
