Loading vehicles from MySQL - 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 vehicles from MySQL (/showthread.php?tid=282087)
+- 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 vehicles from MySQL (/showthread.php?tid=282087)
Loading vehicles from MySQL - CraftMan - 09.09.2011
In general, I'm using ****** translator, since I was a Russian on our Russian forum I did not give an exact answer is boot the machine code (using MySQL) it loads, then there is a record in a variable it is important CMySQLHandler:: FetchField ("id") - 1 writing and must be further CMySQLHandler:: FetchField ("model") - 562 but this does not happen ... Download the code
----
PHP код:
stock LoadVehicles(idx)
{
new result[512], field[32], id,var[512];
mysql_query("SELECT * FROM cars");
mysql_store_result();
while(mysql_fetch_row_format(result, "|"))
{
mysql_get_field("id", var); CarInfo[idx][cId] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("model", var); CarInfo[idx][cModel] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("x", var); CarInfo[idx][cLocationx] = floatstr(var); // ДЛЯ ВЕЩЕСТВЕННОГО ЧИСЛА
mysql_get_field("y", var); CarInfo[idx][cLocationy] = floatstr(var); // ДЛЯ ВЕЩЕСТВЕННОГО ЧИСЛА
mysql_get_field("z", var); CarInfo[idx][cLocationz] = floatstr(var); // ДЛЯ ВЕЩЕСТВЕННОГО ЧИСЛА
mysql_get_field("angle", var); CarInfo[idx][cAngle] = floatstr(var); // ДЛЯ ВЕЩЕСТВЕННОГО ЧИСЛА
mysql_get_field("color1", var); CarInfo[idx][cColorOne] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("color2", var); CarInfo[idx][cColorTwo] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("owner", CarInfo[idx][cOwned]); // ДЛЯ ТЕКСТА
mysql_get_field("owned", var); CarInfo[idx][cOwned] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("description", CarInfo[idx][cDescription]); // ДЛЯ ТЕКСТА
mysql_get_field("price", var); CarInfo[idx][cValue] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("family", var); CarInfo[idx][cFamily] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("faction", var); CarInfo[idx][cFaction] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("type", var); CarInfo[idx][cType] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("respawnable", var); CarInfo[idx][cRespawnable] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА CarInfo[idx][cRespawnTime] = 0;
mysql_get_field("locked", var); CarInfo[idx][cLock] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
mysql_get_field("house", var); CarInfo[idx][cHouse] = strval(var); // ДЛЯ ЦЕЛОГО ЧИСЛА
}
mysql_free_result();
return 1;
}
Quote:
|
[04:47:16] >> mysql_query( Connection handle: 1 ) [04:47:16] CMySQLHandler::Query(SELECT * FROM cars) - Successfully executed. [04:47:16] >> mysql_store_result( Connection handle: 1 ) [04:47:16] CMySQLHandler::StoreResult() - Result was stored. [04:47:16] >> mysql_fetch_row_format( Connection handle: 1 ) [04:47:16] CMySQLHandler::FetchRow() - Return: 1|562|143.42143|-68.73001|1.42969|0.99995|0.00000|0.00000|0.00000|0 .00000|-1|-1|1|Tester|255|255|0||35000|1|0|0|255 [04:47:16] >> mysql_fetch_field_row( Connection handle: 1 ) [04:47:16] CMySQLHandler::FetchField("id") - 1 [04:54:21] >> mysql_query( Connection handle: 1 ) |
Re: Loading vehicles from MySQL - MadeMan - 09.09.2011
Change
pawn Код:
while(mysql_fetch_row_format(result, "|"))
pawn Код:
while(mysql_next_row())
Re: Loading vehicles from MySQL - CraftMan - 09.09.2011
It did not help
Re: Loading vehicles from MySQL - DRIFT_HUNTER - 09.09.2011
Use mysql_fetch_field_row(Variable,"Mysql variable name");
Re: Loading vehicles from MySQL - CraftMan - 09.09.2011
Quote:
|
Originally Posted by DRIFT_HUNTER
 Use mysql_fetch_field_row(Variable,"Mysql variable name");
|
Re: Loading vehicles from MySQL - CraftMan - 09.09.2011
It did not help \ = log so it can be something wrong
Quote:
|
[00:54:42] --------------------------- [00:54:42] MySQL Debugging activated (09/10/11) [00:54:42] --------------------------- [00:54:42] [00:54:42] >> mysql_connect( ) [00:54:42] CMySQLHandler::CMySQLHandler() - constructor called. [00:54:42] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "newproject" | Username: "root" ... [00:54:42] CMySQLHandler::Connect() - Connection was successful. [00:54:42] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [00:54:42] >> mysql_query( Connection handle: 1 ) [00:54:42] CMySQLHandler::Query(SELECT * FROM `players` WHERE Name = 'name') - Successfully executed. [00:54:42] >> mysql_store_result( Connection handle: 1 ) [00:54:42] CMySQLHandler::StoreResult() - Result was stored. [00:54:42] >> mysql_fetch_row_format( Connection handle: 1 ) [00:54:42] CMySQLHandler::FetchRow() - Return: 2|name|123|4458436|0|0|7|1|140.44948|-93.80830|1.57812|2|1 [00:54:42] >> mysql_free_result( Connection handle: 1 ) [00:54:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [00:54:45] >> mysql_query( Connection handle: 1 ) [00:54:45] CMySQLHandler::Query(SELECT * FROM `players` WHERE Name = 'name' AND Password = '123') - Successfully executed. [00:54:45] >> mysql_store_result( Connection handle: 1 ) [00:54:45] CMySQLHandler::StoreResult() - Result was stored. [00:54:45] >> mysql_fetch_row_format( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchRow() - Return: 2|name|123|4458436|0|0|7|1|140.44948|-93.80830|1.57812|2|1 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("id") - 2 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("Money") - 4458436 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("Kills") - 0 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("Deaths") - 0 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("Glklan") - 1 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("warn") - 2 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("carkey") - 1 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("x") - 140.44948 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("y") - -93.80830 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("z") - 1.57812 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("Admin") - 7 [00:54:45] >> mysql_query( Connection handle: 1 ) [00:54:45] CMySQLHandler::Query(SELECT * FROM cars WHERE id = '1') - Successfully executed. [00:54:45] >> mysql_store_result( Connection handle: 1 ) [00:54:45] CMySQLHandler::StoreResult() - Result was stored. [00:54:45] >> mysql_fetch_row_format( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchRow() - Return: 1|562|143.42143|-68.73001|1.42969|0.99995|0.00000|0.00000|0.00000|0 .00000|-1|-1|1|name|255|255|0||35000|1|0|0|255 [00:54:45] >> mysql_fetch_field_row( Connection handle: 1 ) [00:54:45] CMySQLHandler::FetchField("id") - 1 |