15.12.2010, 18:00
Trying to add dynamic interiors with MySQL, this very code actually worked before, but now it's not. Can't see what the problem is aslong as it used to work, anyways my code:
What happends: If I look in the console it displays the name of the interior [iDesc], but all the floats is 0.
Mysql:
Would appreciate all answers!
pawn Код:
enum Interiors
{
iID,
iInt,
iDesc,
iVirtual,
iPickup,
Float:iX,
Float:iY,
Float:iZ,
Float:iEx,
Float:iEy,
Float:iEz
};
new InteriorInfo[Interiors];
pawn Код:
public LoadInts()
{
new intdata[255], string[255];
format(query, sizeof(query), "SELECT * FROM `interiors` ORDER BY `id`;");
mysql_query(query);mysql_store_result();
printf("\nSQL Table loads (NOT PLAYERS)");
print("------------------------------------");
while(mysql_fetch_row(intdata,"|"))
{
mysql_fetch_field("id", intdata); InteriorInfo[iID] = strval(intdata);
mysql_fetch_field("int", intdata); InteriorInfo[iInt] = strval(intdata);
mysql_fetch_field("virtual", intdata); InteriorInfo[iVirtual] = strval(intdata);
mysql_fetch_field("pickup", intdata); InteriorInfo[iPickup] = strval(intdata);
mysql_fetch_field("x", intdata); InteriorInfo[iX] = floatstr(intdata);
mysql_fetch_field("y", intdata); InteriorInfo[iY] = floatstr(intdata);
mysql_fetch_field("z", intdata); InteriorInfo[iZ] = floatstr(intdata);
mysql_fetch_field("ex", intdata); InteriorInfo[iEx] = floatstr(intdata);
mysql_fetch_field("ey", intdata); InteriorInfo[iEy] = floatstr(intdata);
mysql_fetch_field("ez", intdata); InteriorInfo[iEz] = floatstr(intdata);
mysql_fetch_field("desc", InteriorInfo[iDesc]);
CreatePickup(InteriorInfo[iPickup], 1, InteriorInfo[iX], InteriorInfo[iY], InteriorInfo[iZ], 0);
Create3DTextLabel(InteriorInfo[iDesc], COLOR_BRIGHTRED, InteriorInfo[iX], InteriorInfo[iY], InteriorInfo[iZ], 20.0, 0);
format(string, sizeof(string), "%s %f %f %f", InteriorInfo[iDesc], InteriorInfo[iX], InteriorInfo[iY], InteriorInfo[iZ]);
print(string);
}
format(string, sizeof(string), "[MySQL] Loaded interiors from database, a total of: %d", mysql_num_rows());
printf(string);
return 1;
}
Mysql:
Код:
id desc int virtual pickup x y z ex ey ez 1 Controlroom 0 0 1559 1557.2798 -1614.2976 13.3828 1555.6104 -1614.3075 13.3828 2 Los Santos Police Department 6 0 1559 1554.0829 -1675.5900 16.1953 246.783996 63.900199 1003.640625 3 Ganton Gym 5 0 1559 2229.6560 -1721.5797 13.5643 772.111999 -3.898649 1000.728820 4 Jefferson Motel 15 0 1559 2232.2334 -1159.7573 25.8906 2215.454833 -1147.475585 1025.796875 5 Burger Shot 10 0 1559 1199.4281 -918.6729 43.1181 375.962463 -65.816848 1001.507812 8 Burger Shot 10 0 1559 811.1805 -1616.3197 13.5469 375.962463 -65.816848 1001.507812 6 Burger Shot 10 0 1559 2398.4216 -1898.3119 13.5469 375.962463 -65.816848 1001.507812 7 Burger Shot 10 0 1559 2420.4954 -1508.8000 24.0000 375.962463 -65.816848 1001.507812 9 Well stacked pizza 5 0 1559 2104.8223 -1806.5011 13.5547 373.825653 -117.270904 1001.499511 10 Rusty browns donuts 17 0 1559 1038.0732 -1340.078 13.7371 381.169189 -188.803024 1000.632812 11 Well stacked pizza 3 0 1559 1480.9524 -1770.2269 18.7958 384.808624 173.804992 1008.382812 12 ZIP Clothing 18 0 1559 -1138.1721 23.9871 45.3713 161.391006 -93.159156 1001.804687 13 Binco Clothing 15 0 1559 -1664.8224 15.4766 169.6903 207.737991 -109.019996 1005.132812 14 Victim Clothing 11 0 1559 -1501.1610 31.0568 292.3217 226.293991 -7.431529 1002.210937 15 Ten Green Bottles 11 0 1559 -1643.7958 14.8270 317.4572 501.980987 -69.150199 998.757812