Loading reports from database - Printable Version

Loading reports from database - 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: Loading reports from database (/showthread.php?tid=633766)

Loading reports from database - LazzyBoy - 06.05.2017

hey there i saved every report on database MySql but when i load it it seems like wont work and it shows only 1 line not all

heres code where i load em

Код:

function:ReportList(playerid)
{
	new rows, fields;
	cache_get_data(rows, fields, MySQLPipeline);
	if(rows)
	{
		for(new row = 0; row < rows; row++)
		{
			new iMessage[128],Repotredby[128],ReporedTime[128],Reason[128], pName[MAX_PLAYER_NAME];
			cache_get_field_content(row, "ReportedBy", pName, MySQLPipeline);
			cache_get_field_content(row, "Reported", Repotredby, MySQLPipeline);
			cache_get_field_content(row, "TimeDate", ReporedTime, MySQLPipeline);
			cache_get_field_content(row, "Reason", Reason, MySQLPipeline);
			format(iMessage,sizeof(iMessage),"%s - %s - %s -%s",pName,Repotredby,ReporedTime,Reason);
			SendClientMessage(playerid, COLOR_GREY, iMessage);
	    return 1;
		}
	}
	return 1;
}

Command

Код:

COMMAND:reports(playerid, params[])
{
 
	new iQuery[300];
	mysql_format(MySQLPipeline, iQuery, sizeof(iQuery), "SELECT `Reported`, `ReportedBy`, `TimeDate`, `Reason` FROM `Reports`");
	mysql_tquery(MySQLPipeline, iQuery, "ReportList", "d", playerid);
	return 1;
}

Re: Loading reports from database - ShihabSoft - 07.05.2017

Quote:

format(iMessage,sizeof(iMessage),"%s - %s - %s -%s",pName,Repotredby,ReporedTime,Reason);
SendClientMessage(playerid, COLOR_GREY, iMessage);

Well the above code outputs a one liner. What do you expect then?

Re: Loading reports from database - Logic_ - 07.05.2017

Because you're using return 1; under the loop and you're resetting the row count to 0! I also changed the function to show a dialog instead of sending messages in the chat.

Correct code:

PHP код:



function:ReportList(playerid)

{

    new rows, fields;

    cache_get_data(rows, fields, MySQLPipeline);

    if(rows)

    {

        new str[128 * rows], iMessage[128], Repotredby[128], ReporedTime[128], Reason[128], pName[MAX_PLAYER_NAME];

        for(new i; i < rows; i++)

        {

            cache_get_field_content(row, "ReportedBy", pName, MySQLPipeline);

            cache_get_field_content(row, "Reported", Repotredby, MySQLPipeline);

            cache_get_field_content(row, "TimeDate", ReporedTime, MySQLPipeline);

            cache_get_field_content(row, "Reason", Reason, MySQLPipeline);

            format(iMessage, sizeof iMessage,"%d) %s - %s - %s - %s",i + 1, pName, Repotredby, ReporedTime, Reason);

            strcat(str, iMessage);

        }

        ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "Reports list", str, "Okay", "");

    }

    return 1;

}

Re: Loading reports from database - LazzyBoy - 07.05.2017

It doesnt really work , it shows only 1 line and all shows only "Null"