[NC.svtrade]

Create Table

PHP Code:

Format(buffer, sizeof(buffer), "CREATE TABLE IF NOT EXISTS sql_matches (");
    Format(buffer, sizeof(buffer), "%s match_id bigint(20) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s name varchar(65) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s uid bigint(20) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s team int(11) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s kills int(11) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s assists int(11) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s deaths int(11) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s dmg int(11) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s adr float(8) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s rws float(8) NOT NULL,", buffer);
    Format(buffer, sizeof(buffer), "%s rating float(8) NOT NULL);", buffer); 


Query

PHP Code:

SQL_EscapeString(db, PlayerName[i], PlayerName[i], sizeof(PlayerName[]));

Format(buffer, sizeof(buffer), "INSERT INTO sql_matches");
Format(buffer, sizeof(buffer), "%s (match_id, uid, name, team, kills, assists, deaths, dmg, adr, rws, rating)", buffer);
Format(buffer, sizeof(buffer), "%s VALUES (LAST_INSERT_ID(), '%i', '%s', '%i', '%i', '%i', '%i', '%i', '%f', '%f', '%f');", buffer, PlayerUID[i], PlayerName[i], PlayerTeam[i], GetTotalSum(PlayerKills, i, Rounds),
GetTotalSum(PlayerAssists, i, Rounds), 
GetTotalSum(PlayerDeaths, i, Rounds), 
GetTotalSum(PlayerDamage, i, Rounds), PlayerADR[i], PlayerRWS[i], PlayerRating[i]);
SQL_AddQuery(txn, buffer); 


I tested with logs and I confirmed that plugin arrives on query section.

[Balimbanana]

Are you sure the buffer string is large enough for all those values?
You can also see if the database looks correct with SQLite tools: https://www.sqlite.org/2019/sqlite-t...86-3300100.zip
Then you use

.open "path/to/sourcemod-local.sq3"

and you can use SQL queries as normal and you can list the tables in the database with

.tables

and you can see what schema structure it has with

.schema tablename

So you can see if all the values are correctly there.

It might be a bit more messy, but you *can* create a table in SourceMod on one line with something like in this case:

SQL_FastQuery(Handle_Database,"CREATE TABLE IF NOT EXISTS sql_matches(match_id bigint(20) NOT NULL,name varchar(65) NOT NULL,uid bigint(20) NOT NULL,team int(11) NOT NULL,kills int(11) NOT NULL,assists int(11) NOT NULL,deaths int(11) NOT NULL,dmg int(11) NOT NULL,adr float(8) NOT NULL,rws float(8) NOT NULL,rating float(8) NOT NULL);");

It would ensure that no buffer clamp is happening.
Also, after all the SQL_AddQuery's is there an ending:

void SQL_ExecuteTransaction(Handle db, Transaction txn, SQLTxnSuccess onSuccess, SQLTxnFailure onError, any data, DBPriority priority)

Because the SQL_AddQuery will only keep adding to the transaction table but not send it.
If so, then does SQL_GetError return anything afterwards?

[headline]

Increase the size of buffer to something like 512

Also, you need to be escaping the player names or else people can write to your database