Loading vehicles from MySQL
#1

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;

MySQL Debug (log)
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 )

I hope to answer =)
Reply
#2

Change

pawn Код:
while(mysql_fetch_row_format(result, "|"))
to

pawn Код:
while(mysql_next_row())
Reply
#3

It did not help
Reply
#4

Use mysql_fetch_field_row(Variable,"Mysql variable name");
Reply
#5

Quote:
Originally Posted by DRIFT_HUNTER
Посмотреть сообщение
Use mysql_fetch_field_row(Variable,"Mysql variable name");
please give an example
Reply
#6

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

Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)