[Miguelch1312]

Hi eveyone,
Im here to know if someone could tell me the equals for "db_next_row" in the pBlueG MySQL version R39-5 or the way to do something like that.

Thanks and greetings.

[div]

what exactly do you want?
like fetch a data from a field data or something?

[Miguelch1312]

Fetch the row info, And use strcat to add it to a "format", next get the other row info and use strcat to add, this with all rows

To make something like
Row 1 NAME: Pepe | Lastname: White
Row 2 NAME: Pipe | Lastname: Andres

And wanna to show that on a dialog like

_______________________
|++Name++|++Lastname++|
|_________ |____________ |
|+Pepe++++|+White+++++|
|+Pipe++++|+Andres+++++|
|_________ |_____________|

[div]

i can give u an idea.. dont want to write code for now ;3


When he connects, showplayerdialog(2 dialogs TYPE_MSGBOX)


OnPlayerDialogResponse


then

INSERT * INTO `playerdata` WHERE `firstname` = '%s', inputtext)


same we doing with lastname



then the command u want to make this dialogbox for
new fName[24], lName[24];
cache_get_field_content(connectionhandle, "firstname", fName);

same with second name..


then
new string[128];
format(string, sizeof(string), "Name\tLastname\n%s\t%s, fName, lName);
ShowPlayerDialogBox


or if ur making a /credits dialogbox of smth


simply ShowPlayerDialog.. easy.

[Miguelch1312]

No i mean getting the diferrent rows from the MySQL Table and showing it, look, like

--SELECT `NAME`,`LASTNAME`,`ID`, `VIP` FROM `PLAYERS`WHERE `VIP` >= 1 ORDER BY `ID`--

This will do a MySQL query with all the rows with the players that have his vip level more than 1, so then i make a loop to reach all the rows.

Код:

new dialog[128 * 15];
format(dialog, sizeof dialog, "Name\tLastname\tID\tVIP\t");

for(new i; i < cache_get_row_count(Result); i++ )
{
	new name[24], lastname[24], ID, VIP;

	cache_get_field_content(Result, "NAME", name, 24);
	cache_get_field_content(Result, "LASTNAME", lastname, 24);
	connected = cache_get_row_int(Result, "ID");
	rank = cache_get_row_int(Result, "VIP");

	new dline[128];
	format(dline, sizeof dline, "%s\t%s\t%d\t%d", name, lastname, ID, VIP);

	strcat(dialog, dline);
	listitem ++;

	db_next_row(Result);// THIS IS FROM SQLite I NEED THIS IN MYSQL R39-5
}
cache_delete(Result);
ShowPlayerDialog(playerid, VIP_LIST, DIALOG_STYLE_TABLIST_HEADERS, dialog, "OK", "");

db_next_row(Result);This line is from SQLite, i need to update it to MySQL and i dont know what's the statement or the way, its to catch the information from the next row

[div]

u mean u wanna check if row exists or not??

Код:

        new rows = 0;
	rows = cache_get_row_count();

	if(!rows)

        {
          CODE HERE
          }

[Calisthenics]

There is not equivalent.

SQLite stores only on row and can move to the next but not to previous.
MySQL on the other hand can access any row anytime.

You shouldn't create variables inside loops, move them outside and you call cache_get_row_count multiple times. The optional parameter is also connection handle not the cache id as well as retrieving data require a row id, not the cache id.

pawn Код:

new dialog[128 * 15], name[24], lastname[24], ID, VIP;
dialog = "Name\tLastname\tID\tVIP\t";

for(new i, j = cache_get_row_count(); i < j; i++ )
{
    cache_get_field_content(i, "NAME", name, 24);
    cache_get_field_content(i, "LASTNAME", lastname, 24);
    connected = cache_get_row_int(i, "ID");
    rank = cache_get_row_int(i, "VIP");

    format(dialog, sizeof dialog, "%s%s\t%s\t%d\t%d", dialog, name, lastname, ID, VIP);
}

cache_delete(Result);
ShowPlayerDialog(playerid, VIP_LIST, DIALOG_STYLE_TABLIST_HEADERS, dialog, "OK", "");

It is also always suggested to use threaded queries.