A question - 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: A question (
/showthread.php?tid=583407)
A question -
Sjn - 28.07.2015
Hello,
I am currently using MySQL R38 and i am doing this to load my house data
Код:
LoadHouses()
{
new query[36], Cache:result, id;
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `houses`");
result = mysql_query(mysql, query);
if (cache_get_row_count() >= 1)
{
for (new i; i < cache_get_row_count(); ++i)
{
id = cache_get_field_content_int(i, "id");
cache_get_field_content(i, "name", hInfo[id][h_Name], mysql, 100);
cache_get_field_content(i, "owner", hInfo[id][h_Owner], mysql, 24);
hInfo[id][h_X] = cache_get_field_content_float(i, "x");
hInfo[id][h_Y] = cache_get_field_content_float(i, "y");
hInfo[id][h_Z] = cache_get_field_content_float(i, "z");
hInfo[id][h_Level] = cache_get_field_content_int(i, "level");
hInfo[id][h_MaxLevel] = cache_get_field_content_int(i, "maxlevel");
hInfo[id][h_Price] = cache_get_field_content_int(i, "price");
hInfo[id][h_Owned] = cache_get_field_content_int(i, "owned");
hInfo[id][h_Insur] = cache_get_field_content_int(i, "ins");
hInfo[id][h_Locked] = 1;
CreateHouseEntrance(id);
g_ServerData[TotalHouses]++;
}
cache_delete(result, mysql);
}
else return 0;
return 1;
}
Is this the correct way to do so? I don't really know stuffs about cache so i would like to know.
Also,
I am sending queries like mysql_tquery(conn, query, "", ""); to update something in the databas. Which one would be better to use? This one or mysql_query(conn, query, false); ?
I am kinda confused with these 2 stuffs for a long time and i couldn't really find any good explanation for them.
Re: A question -
Sjn - 29.07.2015
/Bump, anyone can help please?