Loading mysql table into samp array - 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 mysql table into samp array (/showthread.php?tid=547978)
+- 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 mysql table into samp array (/showthread.php?tid=547978)
Loading mysql table into samp array - thimo - 26.11.2014
Hello, i have a question about how i can load from mysql table to samp array.
I want to load the mysql stuff like this:
Код:
new ALoads[][TLoad] =
{
{"Gravel", false, 1.00, PCV_TruckerOreTrailer, {11}, {1, 2, 3}}, // LoadID 1
{"Sand", false, 1.00, PCV_TruckerOreTrailer, {12}, {1, 2, 3, 4, 5}}, // LoadID 2
};
[img src="http://i.gyazo.com/8a818a61236d2a215fab6f0a34dfe296.png"][/img]
Does anyone know how to load that mysql table into an array in pawno?
Thank you in advance.
Re: Loading mysql array into samp array - dusk - 26.11.2014
MySQL array? Never heard of it.
What MySQL plugin of which version are you using? Syntax differs from version to version.
Re: Loading mysql array into samp array - thimo - 26.11.2014
Sorry for my fault in my post. I edited the post and im using Mysql R37
Re: Loading mysql table into samp array - dusk - 26.11.2014
Well this is one way:
pawn Код:
new Stuff[max][TLoad]; // Sorry for the non-mnemonic variable name but i have no idea what this code is for. Also change the "max" to an appropriate number.
public OnGameModeInit()
{
mysql_pquery(connection_handler, "SELECT * FROM table_name","OnSomethingLoad","");
}
forward OnSomethingLoad();
public OnSomethingLoad()
{
for(new i = 0; i < cache_get_row_count(); i++)
{
// Although the second dimension is an enum, i will be using indexes as you didn't give me that enum.
cache_get_field_content(i, "Load",Stuff[i][0],connection_handler, size); // size must be changed to the variables size
// I'm assuming that "Mafiaload" is a "String" type column
cache_get_field_content(i, "Mafiaload", Stuff[i][1],
connection_handler,size);
Stuff[i][2] = cache_get_field_content_float(i, "Payperunit");
// For loading "vehicleneeded" column, look below.
Stuff[i][3] = cache_get_field_content_int(i, "JobBlocs1");
// For loading "Joblocs2" you should probably load it into a temporary string, then split it with sscanf and put it into your own array
}
}