[HELP]Damages Issue - Printable Version

[HELP]Damages Issue - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [HELP]Damages Issue (/showthread.php?tid=582962)

[HELP]Damages Issue - XVlaDX - 24.07.2015

Код:

new fetch[256];
format(query, sizeof(query), "SELECT * FROM `damages` WHERE `pid` = '%s'", playerid);
cache_get_field_content(0, "area", fetch);
format(area, 79, "%s", fetch);
cache_get_field_content(0, "damage", fetch);
format(damage, 79, "%f", fetch);
cache_get_field_content(0, "weapon", fetch);
format(weapon, 79, "%s", fetch);
cache_get_field_content(0, "shooter", fetch);
format(shooter, 79, "%s", fetch);
mysql_function_query(dbHandle, query, false, "", "");
new gText[1000], fstr[45];
format(fstr, sizeof(fstr), "%d damage from %s to the %s\n", damage, weapon, area);

Код:

format(query, sizeof(query), "INSERT INTO `damages` (pid, area, damage, weapon, shooter) VALUES ('%d', '%s', '%f', '%s', '%s')",Target,GetBodyPartName(Target + 3),HealthLost,GetPlayerWeapon(Shooter),GetName(Shooter));
mysql_function_query(dbHandle, query, false, "", "");

Essentially what I aimed to do was to insert damages whenever the player lost health. Although that all works well, when selecting from the damages in order to display them, the display doesn't work.

Re: [HELP]Damages Issue - xVIP3Rx - 24.07.2015

Quote:

Originally Posted by XVlaDX

pawn Код:

format(query, sizeof(query), "SELECT * FROM `damages` WHERE `pid` = '%s'", playerid);

"`pid` = '%s'", playerid);"

playerid is a string ?, okay..

use "%d" for integers like playerid.

Re: [HELP]Damages Issue - Denying - 24.07.2015

You're formatting the query but you aren't executing it, should you use mysql_tquery(mysql, query, "some public", "i", playerid);

And then do all the fetching inside the public?

Re: [HELP]Damages Issue - XVlaDX - 24.07.2015

Quote:

Originally Posted by xVIP3Rx

"`pid` = '%s'", playerid);"

playerid is a string ?, okay..

use "%d" for integers like playerid.

Well spoted mate. However, I'm still having an issue with the display

Quote:

Originally Posted by Denying

You're formatting the query but you aren't executing it, should you use mysql_tquery(mysql, query, "some public", "i", playerid);

And then do all the fetching inside the public?

I will give that a try mate.

Re: [HELP]Damages Issue - xVIP3Rx - 24.07.2015

On the dialog, use GetPlayerName, and use "%s" for it in the format.

Re: [HELP]Damages Issue - XVlaDX - 24.07.2015

Код:

 
new area[120], damage[12], weaponz[25], shooter[MAX_PLAYER_NAME];
public DamagesQ()
{
		new fetch[256];
		cache_get_field_content(0, "area", fetch);
   		format(area, 79, "%s", fetch);
		cache_get_field_content(0, "damage", fetch);
   		format(damage, 79, "%f", fetch);
		cache_get_field_content(0, "weapon", fetch);
   		format(weaponz, 79, "%s", fetch);
		cache_get_field_content(0, "shooter", fetch);
   		format(shooter, 79, "%s", fetch);
}
stock DisplayDamages(toplayer, playerid)
{
        new playername[MAX_PLAYER_NAME], title[45];
        GetPlayerName(playerid, playername, sizeof(playername));
        format(title, sizeof(title), "%s", playername);
		format(query, sizeof(query), "SELECT * FROM `damages` WHERE `pid` = '%d'", playerid);
		mysql_function_query(dbHandle, query, true, "DamagesQ", "i", playerid);
        new dmgtxt[1000], fstr[45];
        format(fstr, sizeof(fstr), "%f damage from %s to the %s\n", damage, weaponz, area);
        strcat(dmgtxt, fstr);
		ShowPlayerDialog(toplayer, damages, DIALOG_STYLE_LIST, title, dmgtxt, "Close", "");
        return 1;
}

It only displays one damage as oppose to numerous. Any idea why?

Re: [HELP]Damages Issue - xVIP3Rx - 24.07.2015

pawn Код:

new area[120], damage[12], weaponz[25], shooter[MAX_PLAYER_NAME];
forward DamagesQ(toplayer, playerid);
public DamagesQ(toplayer, playerid)
{
        new fetch[256];
        cache_get_field_content(0, "area", fetch);
        format(area, 79, "%s", fetch);
        
        cache_get_field_content(0, "damage", fetch);
        format(damage, 79, "%f", fetch);
        
        cache_get_field_content(0, "weapon", fetch);
        format(weaponz, 79, "%s", fetch);
        
        cache_get_field_content(0, "shooter", fetch);
        format(shooter, 79, "%s", fetch);
        
        new playername[MAX_PLAYER_NAME], dmgtxt[128];
        GetPlayerName(playerid, playername, sizeof(playername));
        format(dmgtxt, sizeof(dmgtxt), "%f damage from %s to the %s\n", damage, weaponz, area);
        ShowPlayerDialog(toplayer, damages, DIALOG_STYLE_LIST, playername, dmgtxt, "Close", "");
}

stock DisplayDamages(toplayer, playerid)
{

        format(query, sizeof(query), "SELECT * FROM `damages` WHERE `pid` = '%d'", playerid);
        mysql_function_query(dbHandle, query, true, "DamagesQ", "ii", toplayer, playerid);
        return 1;
}

You could use

pawn Код:

format(query, sizeof(query), "SELECT * FROM `damages` WHERE `pid` = '%d'", playerid);
        mysql_function_query(dbHandle, query, true, "DamagesQ", "ii", toplayer, playerid);

instead of the stock itself.

Re: [HELP]Damages Issue - XVlaDX - 24.07.2015

That works too, however it only displays one entry, that being the first entry that has the Id == playerid, none other.

Re: [HELP]Damages Issue - xVIP3Rx - 24.07.2015

I don't understand, it shows only one line in the dialog ? maybe because there's only one in there already ?

Re: [HELP]Damages Issue - XVlaDX - 24.07.2015

Sorry for not being all to clear. Allow me to clarify.
There are two entries in the database relating to the players ID -

However, this is what's displayed IG.

Only one line as oppose to the two that are in the database.