[Santi.]

Hi, my doubt is how can I get the return value of a MySQL function and if it's possible.

Thanks!

[sdz]

look into this https://sm.alliedmods.net/new-api/dbi/DBResultSet
and this https://wiki.alliedmods.net/SQL_(SourceMod_Scripting)

[Santi.]

Originally Posted by sidezz look into this https://sm.alliedmods.net/new-api/dbi/DBResultSet and this https://wiki.alliedmods.net/SQL_(SourceMod_Scripting)

Thanks, but I'm having problems to get the result of a MySQL Stored Procedure specifically.

[Santi.]

My SP:

`sp_load_characters`(steam_id INT)
BEGIN
	SELECT c.id, c.name, c.level, c.reset 
    FROM Players p RIGHT JOIN Characters c ON (p.id = c.idPlayer) 
    WHERE p.steamid = steam_id;
END

Code:

int steamid = GetSteamAccountID(client);
	
	char error[255];
	Database db = SQL_DefConnect(error, sizeof(error));
	DBStatement hUserStmt = null;
	if (db == null){
		PrintToServer("Could not connect: %s", error);
	}
	
	
	/* Check if we haven't already created the statement */
	if (hUserStmt == null){
		char error2[255];
		hUserStmt = SQL_PrepareQuery(db, "CALL sp_load_characters(?)", error2, sizeof(error2));
		if (hUserStmt == null){
			PrintToServer(error2);
			
			delete hUserStmt;
			delete db;
			
			return Plugin_Handled;
		}
	}
	SQL_BindParamInt(hUserStmt, 0, steamid, false);
	if (!SQL_Execute(hUserStmt)){
		char errorr[255];
		SQL_GetError(hUserStmt, errorr, sizeof(errorr));
		PrintToServer(errorr);
		delete hUserStmt;
		delete db;
		
		return Plugin_Handled;
	}
	
	
	
	int rows = SQL_GetRowCount(query); 
	PrintToServer("%d", rows); //returns 0
	
	delete hUserStmt;
	delete db;
	return Plugin_Handled;

If I run the query on MySQL Workbench it returns the select result. But when I call it from the plugin it returns nothing

[asherkin]

SourceMod's MySQL extension only supports a single result set per query - CALL always returns multiple so does not work.

[Santi.]

Originally Posted by asherkin SourceMod's MySQL extension only supports a single result set per query - CALL always returns multiple so does not work.

Thanks you asherkin.

Will it support multiple resultsets in the future?

[Fyren]

If someone wanted to coordinate with one of the devs and submit a PR to implement it, it could happen. Otherwise probably not.

[Santi.]

Originally Posted by Fyren If someone wanted to coordinate with one of the devs and submit a PR to implement it, it could happen. Otherwise probably not.

I would like to help. But Idk who to talk with

[Fyren]

Doing the actual implementation would be writing code in C++. I have no idea if that's within your ability. (It wouldn't be for most SM users; anyone could learn but this wouldn't be a good first project.) If it is, then either find any of the devs on IRC or make an issue on Github.

[Santi.]

Originally Posted by Fyren Doing the actual implementation would be writing code in C++. I have no idea if that's within your ability. (It wouldn't be for most SM users; anyone could learn but this wouldn't be a good first project.) If it is, then either find any of the devs on IRC or make an issue on Github.

Thanks Fyren, I'll try to resolve this.