Kleines Problem

[DT]Nightstr3am · 27. Mai 2013

Tag Community,

Ich habe gerade ein kleines Problem beim Laden bzw. beim einschreiben in eine Tabelle.

Problem 1: danke Beavis

Und dann schreibt er mit den Spieler nicht einmal in die Tabelle :

new str2[150];
format(str,sizeof(str),"INSERT INTO `dt_myplayer` (`pname`,`rent`) VALUES ('%s','%d')",SpielerName(playerid),PlayerH[playerid][rent]);
mysql_query(str2);

Beavis · 27. Mai 2013

der query ist zu klein 50 reicht nicht aus

[DT]Nightstr3am · 27. Mai 2013

Dankeschön und beim 2ten ?

Beavis · 27. Mai 2013

was sagt der Debug?

[DT]Nightstr3am · 27. Mai 2013

Zitat von Beavis

was sagt der Debug?

//edit
Doch nicht, er schreibt mir die Sachen immer noch nicht in die Tabelle :

case D_HM2:
{
if(response)
{
new str[150],str2[150];
new sto; sto += 1;
format(str,sizeof(str),"UPDATE `dt_myhotel` SET `stocke` = '%d' WHERE `vwelt` = '%d'",sto,GetPlayerVirtualWorld(playerid));
mysql_query(str);
PlayerH[playerid][rent] = 1;
format(str,sizeof(str),"INSERT INTO `dt_myplayer` (`pname`,`rent`) VALUES ('%s','%d')",SpielerName(playerid),PlayerH[playerid][rent]);
mysql_query(str2);
SendClientMessage(playerid,C_GRAU,"Du hast nun ein Hotel Zimmer gemietet");
}
}

Debug :

Spoiler anzeigen

Code

[17:23:59]  [17:23:59] ---------------------------[17:23:59] MySQL Debugging activated (05/27/13)[17:23:59] ---------------------------[17:23:59]  [17:23:59] >> mysql_connect( )[17:23:59] CMySQLHandler::CMySQLHandler() - constructor called.[17:23:59] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ...[17:23:59] CMySQLHandler::Connect() - Connection was successful.[17:23:59] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.[17:23:59] >> mysql_ping( Connection handle: 1 )[17:23:59] CMySQLHandler::Ping() - Connection is still alive.[17:23:59] >> mysql_query( Connection handle: 1 )[17:23:59] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `dt_myhotel` (`id` int(11) NOT NULL AUTO_INCREMENT, `pick` int(11), `ex` varchar(40),  `ey` varchar(40), `ez` varchar(40), `er` varchar(40), `vwelt` int(11), `stocke` int(11),PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;) - Successfully executed.[17:23:59] >> mysql_query( Connection handle: 1 )[17:23:59] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `dt_myplayer` (`id` int(11) NOT NULL AUTO_INCREMENT, `pname` varchar(24), `rent` int(11),PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;) - Successfully executed.[17:23:59] >> mysql_query( Connection handle: 1 )[17:23:59] CMySQLHandler::Query(SELECT * FROM `dt_myhotel`) - Successfully executed.[17:23:59] >> mysql_store_result( Connection handle: 1 )[17:23:59] CMySQLHandler::StoreResult() - Result was stored.[17:23:59] >> mysql_num_rows( Connection handle: 1 )[17:23:59] CMySQLHandler::NumRows() - Returned 1 row(s)[17:23:59] >> mysql_retrieve_row( Connection handle: 1 )[17:23:59] >> mysql_fetch_field_row( Connection handle: 1 )[17:23:59] CMySQLHandler::FetchField("pick") - 1237[17:23:59] >> mysql_fetch_field_row( Connection handle: 1 )[17:23:59] CMySQLHandler::FetchField("ex") - 1547.411010[17:23:59] >> mysql_fetch_field_row( Connection handle: 1 )[17:23:59] CMySQLHandler::FetchField("ey") - -1733.409790[17:23:59] >> mysql_fetch_field_row( Connection handle: 1 )[17:23:59] CMySQLHandler::FetchField("ez") - 13.382812[17:23:59] >> mysql_fetch_field_row( Connection handle: 1 )[17:23:59] CMySQLHandler::FetchField("vwelt") - 21[17:23:59] >> mysql_fetch_field_row( Connection handle: 1 )[17:23:59] CMySQLHandler::FetchField("stocke") - 1[17:23:59] >> mysql_fetch_field_row( Connection handle: 1 )[17:23:59] CMySQLHandler::FetchField("er") - 87.430793[17:23:59] >> mysql_num_rows( Connection handle: 1 )[17:23:59] CMySQLHandler::NumRows() - Returned 1 row(s)[17:23:59] >> mysql_free_result( Connection handle: 1 )[17:23:59] CMySQLHandler::FreeResult() - Result was successfully free'd.[17:24:26] >> mysql_query( Connection handle: 1 )[17:24:26] CMySQLHandler::Query(SELECT * FROM `dt_myplayer` WHERE `pname` = 'BubbleBoss') - Successfully executed.[17:24:26] >> mysql_store_result( Connection handle: 1 )[17:24:26] CMySQLHandler::StoreResult() - Result was stored.[17:24:26] >> mysql_num_rows( Connection handle: 1 )[17:24:26] CMySQLHandler::NumRows() - Returned 0 row(s)[17:24:26] >> mysql_free_result( Connection handle: 1 )[17:24:26] CMySQLHandler::FreeResult() - Result was successfully free'd.[17:24:47] >> mysql_query( Connection handle: 1 )[17:24:47] CMySQLHandler::Query(SELECT `stocke` FROM `dt_myhotel` WHERE `vwelt` = '21') - Successfully executed.[17:24:47] >> mysql_store_result( Connection handle: 1 )[17:24:47] CMySQLHandler::StoreResult() - Result was stored.[17:24:47] >> mysql_num_rows( Connection handle: 1 )[17:24:47] CMySQLHandler::NumRows() - Returned 1 row(s)[17:24:47] >> mysql_free_result( Connection handle: 1 )[17:24:47] CMySQLHandler::FreeResult() - Result was successfully free'd.[17:24:48] >> mysql_query( Connection handle: 1 )[17:24:48] CMySQLHandler::Query(UPDATE `dt_myhotel` SET `stocke` = '1' WHERE `vwelt` = '21') - Successfully executed.[17:24:48] >> mysql_query( Connection handle: 1 )[17:24:48] CMySQLHandler::Query() - An error has occured. (Error ID: 1065, Query was empty)[17:24:52] >> mysql_query( Connection handle: 1 )[17:24:52] CMySQLHandler::Query(UPDATE `dt_myplayer` SET `rent` = '1' WHERE `pname` = 'BubbleBoss') - Successfully executed.[17:25:13] >> mysql_query( Connection handle: 1 )[17:25:13] CMySQLHandler::Query(SELECT * FROM `dt_myplayer` WHERE `pname` = 'BubbleBoss') - Successfully executed.[17:25:13] >> mysql_store_result( Connection handle: 1 )[17:25:13] CMySQLHandler::StoreResult() - Result was stored.[17:25:13] >> mysql_num_rows( Connection handle: 1 )[17:25:13] CMySQLHandler::NumRows() - Returned 0 row(s)[17:25:13] >> mysql_free_result( Connection handle: 1 )[17:25:13] CMySQLHandler::FreeResult() - Result was successfully free'd.[17:25:56] >> mysql_query( Connection handle: 1 )[17:25:56] CMySQLHandler::Query(UPDATE `dt_myplayer` SET `rent` = '1' WHERE `pname` = 'BubbleBoss') - Successfully executed.[17:26:05] CMySQLHandler::~CMySQLHandler() - deconstructor called.[17:26:05] CMySQLHandler::FreeResult() - The result is already empty.[17:26:05] CMySQLHandler::Disconnect() - Connection was closed.[17:26:43]  [17:26:43] ---------------------------[17:26:43] MySQL Debugging activated (05/27/13)[17:26:43] ---------------------------[17:26:43]  [17:26:43] >> mysql_connect( )[17:26:43] CMySQLHandler::CMySQLHandler() - constructor called.[17:26:43] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ...[17:26:44] CMySQLHandler::Connect() - Connection was successful.[17:26:44] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.[17:26:44] >> mysql_ping( Connection handle: 1 )[17:26:44] CMySQLHandler::Ping() - Connection is still alive.[17:26:44] >> mysql_query( Connection handle: 1 )[17:26:44] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `dt_myhotel` (`id` int(11) NOT NULL AUTO_INCREMENT, `pick` int(11), `ex` varchar(40),  `ey` varchar(40), `ez` varchar(40), `er` varchar(40), `vwelt` int(11), `stocke` int(11),PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;) - Successfully executed.[17:26:44] >> mysql_query( Connection handle: 1 )[17:26:44] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `dt_myplayer` (`id` int(11) NOT NULL AUTO_INCREMENT, `pname` varchar(24), `rent` int(11),PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;) - Successfully executed.[17:26:44] >> mysql_query( Connection handle: 1 )[17:26:44] CMySQLHandler::Query(SELECT * FROM `dt_myhotel`) - Successfully executed.[17:26:44] >> mysql_store_result( Connection handle: 1 )[17:26:44] CMySQLHandler::StoreResult() - Result was stored.[17:26:44] >> mysql_num_rows( Connection handle: 1 )[17:26:44] CMySQLHandler::NumRows() - Returned 1 row(s)[17:26:44] >> mysql_retrieve_row( Connection handle: 1 )[17:26:44] >> mysql_fetch_field_row( Connection handle: 1 )[17:26:44] CMySQLHandler::FetchField("pick") - 1237[17:26:44] >> mysql_fetch_field_row( Connection handle: 1 )[17:26:44] CMySQLHandler::FetchField("ex") - 1547.411010[17:26:44] >> mysql_fetch_field_row( Connection handle: 1 )[17:26:44] CMySQLHandler::FetchField("ey") - -1733.409790[17:26:44] >> mysql_fetch_field_row( Connection handle: 1 )[17:26:44] CMySQLHandler::FetchField("ez") - 13.382812[17:26:44] >> mysql_fetch_field_row( Connection handle: 1 )[17:26:44] CMySQLHandler::FetchField("vwelt") - 21[17:26:44] >> mysql_fetch_field_row( Connection handle: 1 )[17:26:44] CMySQLHandler::FetchField("stocke") - 1[17:26:44] >> mysql_fetch_field_row( Connection handle: 1 )[17:26:44] CMySQLHandler::FetchField("er") - 87.430793[17:26:44] >> mysql_num_rows( Connection handle: 1 )[17:26:44] CMySQLHandler::NumRows() - Returned 1 row(s)[17:26:44] >> mysql_free_result( Connection handle: 1 )[17:26:44] CMySQLHandler::FreeResult() - Result was successfully free'd.[17:27:06] >> mysql_query( Connection handle: 1 )[17:27:06] CMySQLHandler::Query(SELECT * FROM `dt_myplayer` WHERE `pname` = 'BubbleBoss') - Successfully executed.[17:27:06] >> mysql_store_result( Connection handle: 1 )[17:27:06] CMySQLHandler::StoreResult() - Result was stored.[17:27:06] >> mysql_num_rows( Connection handle: 1 )[17:27:06] CMySQLHandler::NumRows() - Returned 0 row(s)[17:27:06] >> mysql_free_result( Connection handle: 1 )[17:27:06] CMySQLHandler::FreeResult() - Result was successfully free'd.[17:27:17] >> mysql_query( Connection handle: 1 )[17:27:17] CMySQLHandler::Query(UPDATE `dt_myplayer` SET `rent` = '0' WHERE `pname` = 'BubbleBoss') - Successfully executed.

Spoiler anzeigen

Beavis · 27. Mai 2013

Zitat von [DT]Nightstr3am

mysql_query(str2);

mach mal die 2 da weg dann gehts auch

[DT]Nightstr3am · 27. Mai 2013

Zitat von Beavis

mach mal die 2 da weg dann gehts auch

Haha, danke xD, habe anscheinend die 2 beim format auch vergessen. Danke, soviel zur Hilfe von Denkfehlern bzw. Schlampigkeitsfehlern

Nächtes Problem,

Jetzt kommt beim Laden in der Debug :

SQL

CMySQLHandler::FetchField(pname) - You cannot call this function now. (Reason: Fields/Rows are empty.)

Und beim stock :

stock DT_PLOAD(playerid)
{
new query[150],val[128];
format(query,sizeof(query),"SELECT * FROM `dt_myplayer` WHERE `pname` = '%s'",SpielerName(playerid));
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
{
mysql_fetch_field_row(val,"pname"); PlayerH[playerid][pname] = strlen(val);
mysql_fetch_field_row(val,"rent"); PlayerH[playerid][rent] = strval(val);
}
mysql_free_result();
}

Beavis · 27. Mai 2013

erst fetch_row dann erst die Felder

[DT]Nightstr3am · 27. Mai 2013

Wie ? Es gehört ja so, bei anderen Sachen die ich Lade ist dieser Fehler nicht und ich lade genau gleich ?

Beavis · 27. Mai 2013

stock DT_PLOAD(playerid)
{
new query[150],val[128];
format(query,sizeof(query),"SELECT * FROM `dt_myplayer` WHERE `pname` = '%s'",SpielerName(playerid));
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
{
mysql_fetch_row_format(query);//das sollte man nutzen
mysql_fetch_field_row(val,"pname"); PlayerH[playerid][pname] = strlen(val);
mysql_fetch_field_row(val,"rent"); PlayerH[playerid][rent] = strval(val);
}
mysql_free_result();
}

breadfish.de 12. März 2022