Sziasztok, edilteni kezdtem a MalibuRPG-t, nagyon szerethető mód, de elakadtam és segítséget szeretnék kérni :)
Nem tudom mit ronthattam el. A szerveren lehet a boltokhoz adni tárgyakat, pl Kenyér stbb. Vegyük példának a Kenyeret. A Kenyeret hozzárendelem az egyik bolthoz, megjelenik az árulistában de mikor rákattintok akkor csak ennyit reagál: Vettél egy -t.
Valamiért nem tudja lekérni az adatot a MySQL, megpróbáltam az eredeti móddal és jól működött. Úgyanígy nem működik a bútorbolt sem. Nem tudom mi történhetett, egy két helyen foglalkoztam MySQL-al,megpróbáltam kiszedni, úgyanúgy fentállt a hiba, nem tudom, hogy még van-e MySQL hiba, ezért valaki aki jobban ért hozzá legyenszives mondja el, miért nem tudja lekérni azt adatot. Ez egy régebbi MySQL, R6-os.
if(dialogid == butorbolt)
{
if(!response) return 0;
new dollar, nevecskeje[64];
sscanf(formattedinputtext, \"is[64]\", dollar, nevecskeje);
strdel(nevecskeje, 0, 4);
if(pInfo[playerid][penz] < dollar) return Malibu(playerid, \"Nincs elég pénzed!\");
if(GetKereskedelemItem(12) < 300) return Malibu(playerid, \"Nincs elég bútor (fa) a raktárban.\");
format(query, sizeof(query), \"SELECT `itemid` FROM `invname` WHERE `name`=\'%s\'\", nevecskeje);
mysql_query(query);
mysql_store_result();
new iid;
iid = mysql_fetch_int();
mysql_free_result();
format(stri, 256, \"Vettél egy %s-t!\", nevecskeje);
Malibu_Green(playerid, stri);
AddItem(playerid, iid, 1);
Kifizet(playerid, -dollar);
SetKereskedelemItem(12, GetKereskedelemItem(12)-randomex(300,500));
}
if(dialogid == bolt)
{
if(!response) return 0;
new dollar, nevecskeje[64];
sscanf(formattedinputtext, \"is[64]\", dollar, nevecskeje);
strdel(nevecskeje, 0, 4);
if(pInfo[playerid][penz] < dollar) return Malibu(playerid, \"Nincs elég pénzed!\");
if(listitem == 0)
{
if(eInfo[pInfo[playerid][mentben]][style] == 16)
{
if(GetPlayerTszam(playerid) > 0) return Malibu(playerid, \"Már van telefonszámod!\");
AddPlayerTszam(playerid);
format(stra, 256, \"Vettél egy telefont. Számod: %d\", GetPlayerTszam(playerid));
Malibu_Green(playerid, stra);
Kifizet(playerid, -dollar);
}
else if(eInfo[pInfo[playerid][mentben]][style] == 1)
{
Malibu_Green(playerid, \"Vettél egy doboz cigit.\");
AddItem(playerid, 9, 18);
Kifizet(playerid, -dollar);
}
}
else
{
format(query, sizeof(query), \"SELECT `itemid` FROM `invname` WHERE `name`=\'%s\'\", nevecskeje);
mysql_query(query);
mysql_store_result();
new iid;
iid = mysql_fetch_int();
mysql_free_result();
if(iid == 2503)
{
if(GetKereskedelemItem(4) == 0) return Malibu(playerid, \"Elfogyott a kenyér a megye élelmiszerraktárából!\");
SetKereskedelemItem(4, GetKereskedelemItem(4)-1);
}
if(iid == 2504)
{
if(GetKereskedelemItem(7) == 0) return Malibu(playerid, \"Elfogytak a tejtermékek a megye élelmiszerraktárából!\");
SetKereskedelemItem(7, GetKereskedelemItem(7)-1);
}
if(iid == 2505)
{
if(GetKereskedelemItem(9) == 0) return Malibu(playerid, \"Elfogytak a hentesáruk a megye élelmiszerraktárából!\");
SetKereskedelemItem(9, GetKereskedelemItem(9)-1);
}
format(stri, 256, \"Vettél egy %s-t!\", nevecskeje);
Malibu_Green(playerid, stri);
AddItem(playerid, iid, 1);
Kifizet(playerid, -dollar);
}
}
Köszönöm szépen előre is :)
Megnézem a debugot hátha találok valami érdekest
Dupla hozzászólás automatikusan összefûzve. ( [time]2016. augusztus 12. 08:59:55[/time] )
A bútorboltba beraktam egy Bólyát úgyanúgy ez a reakciója: Vettél egy -t, nem von le pénzt, és nem adja meg a tárgyat
CMySQLHandler::Query(UPDATE `inventory` SET `amount`=\'23\' WHERE `pname`=\'Rico_Bernasconi\' AND `itemid`=\'-1\')
Tehát azért Vettél egy -t, mert
itemid`=\'-1\'
-1 az item idje, miért lehet ez?
CMySQLHandler::Query(SELECT `invname`.`name`, `butoritems`.`ar` FROM `invname`, `butoritems` WHERE `butoritems`.`itemid` = `invname`.`itemid` AND `entid`=\'11\' GROUP BY `butoritems`.`itemid`) - Successfully executed.
[08:41:18] >> mysql_store_result( Connection handle: 1 )
[08:41:18] CMySQLHandler::StoreResult() - Result was stored.
[08:41:18] >> mysql_fetch_row_format( Connection handle: 1 )
[08:41:18] CMySQLHandler::FetchRow() - Return: Bója|1
[08:41:18] >> mysql_fetch_row_format( Connection handle: 1 )
[08:41:19] >> mysql_real_escape_string( Connection handle: 1 )
[08:41:19] CMySQLHandler::EscapeString(1$ | Bója); - Escaped 9 characters to 1$ | Bója.
[08:41:19] >> mysql_query( Connection handle: 1 )
[08:41:19] CMySQLHandler::Query(SELECT `amount` FROM `kereskedelem` WHERE `itemid`=12) - Successfully executed.
[08:41:19] >> mysql_store_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::StoreResult() - Result was stored.
[08:41:19] >> mysql_num_rows( Connection handle: 1 )
[08:41:19] CMySQLHandler::NumRows() - Returned 1 row(s)
[08:41:19] >> mysql_fetch_int( Connection handle: 1 )
[08:41:19] CMySQLHandler::FetchRow() - Return: 38426
[08:41:19] >> mysql_free_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[08:41:19] >> mysql_query( Connection handle: 1 )
[08:41:19] CMySQLHandler::Query(SELECT `itemid` FROM `invname` WHERE `name`=\'\') - Successfully executed.
[08:41:19] >> mysql_store_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::StoreResult() - Result was stored.
[08:41:19] >> mysql_fetch_int( Connection handle: 1 )
[08:41:19] >> mysql_free_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[08:41:19] >> mysql_query( Connection handle: 1 )
[08:41:19] CMySQLHandler::Query(SELECT `amount` FROM `inventory` WHERE `pname`=\'Rico_Bernasconi\' AND `itemid`=\'-1\') - Successfully executed.
[08:41:19] >> mysql_store_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::StoreResult() - Result was stored.
[08:41:19] >> mysql_num_rows( Connection handle: 1 )
[08:41:19] CMySQLHandler::NumRows() - Returned 1 row(s)
[08:41:19] >> mysql_free_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[08:41:19] >> mysql_query( Connection handle: 1 )
[08:41:19] CMySQLHandler::Query(SELECT `amount` FROM `inventory` WHERE `pname`=\'Rico_Bernasconi\' AND `itemid`=\'-1\') - Successfully executed.
[08:41:19] >> mysql_store_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::StoreResult() - Result was stored.
[08:41:19] >> mysql_num_rows( Connection handle: 1 )
[08:41:19] CMySQLHandler::NumRows() - Returned 1 row(s)
[08:41:19] >> mysql_fetch_int( Connection handle: 1 )
[08:41:19] CMySQLHandler::FetchRow() - Return: 22
[08:41:19] >> mysql_free_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[08:41:19] >> mysql_query( Connection handle: 1 )
[08:41:19] CMySQLHandler::Query(UPDATE `inventory` SET `amount`=\'23\' WHERE `pname`=\'Rico_Bernasconi\' AND `itemid`=\'-1\') - Successfully executed.
[08:41:19] >> mysql_query( Connection handle: 1 )
[08:41:19] CMySQLHandler::Query(SELECT SUM( `invname`.`weight` * `inventory`.`amount` ) FROM `invname` , `inventory` WHERE `inventory`.`itemid` = `invname`.`itemid` AND `pname` = \'Rico_Bernasconi\') - Successfully executed.
[08:41:19] >> mysql_store_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::StoreResult() - Result was stored.
[08:41:19] >> mysql_fetch_float( Connection handle: 1 )
[08:41:19] CMySQLHandler::FetchRow() - Return: 0.03600000170990825
[08:41:19] >> mysql_free_result( Connection handle: 1 )
[08:41:19] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[08:41:19] >> mysql_query( Connection handle: 1 )
[08:41:19] CMySQLHandler::Query(UPDATE `players` SET `money`=\'1686\' WHERE `name`=\'Rico_Bernasconi\') - Successfully executed.
--------------------------------------------------------Az eredeti mód Debugja -----------------------------------------------
CMySQLHandler::Query(SELECT `invname`.`name`, `butoritems`.`ar` FROM `invname`, `butoritems` WHERE `butoritems`.`itemid` = `invname`.`itemid` AND `entid`=\'11\' GROUP BY `butoritems`.`itemid`) - Successfully executed.
[09:15:07] >> mysql_store_result( Connection handle: 1 )
[09:15:07] CMySQLHandler::StoreResult() - Result was stored.
[09:15:07] >> mysql_fetch_row_format( Connection handle: 1 )
[09:15:07] CMySQLHandler::FetchRow() - Return: Bója|1
[09:15:07] >> mysql_fetch_row_format( Connection handle: 1 )
[09:15:08] >> mysql_real_escape_string( Connection handle: 1 )
[09:15:08] CMySQLHandler::EscapeString(1 $ | Bója); - Escaped 10 characters to 1 $ | Bója.
[09:15:08] >> mysql_query( Connection handle: 1 )
[09:15:09] CMySQLHandler::Query(SELECT `amount` FROM `kereskedelem` WHERE `itemid`=12) - Successfully executed.
[09:15:09] >> mysql_store_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::StoreResult() - Result was stored.
[09:15:09] >> mysql_num_rows( Connection handle: 1 )
[09:15:09] CMySQLHandler::NumRows() - Returned 1 row(s)
[09:15:09] >> mysql_fetch_int( Connection handle: 1 )
[09:15:09] CMySQLHandler::FetchRow() - Return: 37158
[09:15:09] >> mysql_free_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[09:15:09] >> mysql_query( Connection handle: 1 )
[09:15:09] CMySQLHandler::Query(SELECT `itemid` FROM `invname` WHERE `name`=\'Bója\') - Successfully executed.
[09:15:09] >> mysql_store_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::StoreResult() - Result was stored.
[09:15:09] >> mysql_fetch_int( Connection handle: 1 )
[09:15:09] CMySQLHandler::FetchRow() - Return: 80
[09:15:09] >> mysql_free_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[09:15:09] >> mysql_query( Connection handle: 1 )
[09:15:09] CMySQLHandler::Query(SELECT `amount` FROM `inventory` WHERE `pname`=\'Rico_Bernasconi\' AND `itemid`=\'80\') - Successfully executed.
[09:15:09] >> mysql_store_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::StoreResult() - Result was stored.
[09:15:09] >> mysql_num_rows( Connection handle: 1 )
[09:15:09] CMySQLHandler::NumRows() - Returned 1 row(s)
[09:15:09] >> mysql_free_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[09:15:09] >> mysql_query( Connection handle: 1 )
[09:15:09] CMySQLHandler::Query(SELECT `amount` FROM `inventory` WHERE `pname`=\'Rico_Bernasconi\' AND `itemid`=\'80\') - Successfully executed.
[09:15:09] >> mysql_store_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::StoreResult() - Result was stored.
[09:15:09] >> mysql_num_rows( Connection handle: 1 )
[09:15:09] CMySQLHandler::NumRows() - Returned 1 row(s)
[09:15:09] >> mysql_fetch_int( Connection handle: 1 )
[09:15:09] CMySQLHandler::FetchRow() - Return: 1
[09:15:09] >> mysql_free_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[09:15:09] >> mysql_query( Connection handle: 1 )
[09:15:09] CMySQLHandler::Query(UPDATE `inventory` SET `amount`=\'2\' WHERE `pname`=\'Rico_Bernasconi\' AND `itemid`=\'80\') - Successfully executed.
[09:15:09] >> mysql_query( Connection handle: 1 )
[09:15:09] CMySQLHandler::Query(SELECT SUM( `invname`.`weight` * `inventory`.`amount` ) FROM `invname` , `inventory` WHERE `inventory`.`itemid` = `invname`.`itemid` AND `pname` = \'Rico_Bernasconi\') - Successfully executed.
[09:15:09] >> mysql_store_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::StoreResult() - Result was stored.
[09:15:09] >> mysql_fetch_float( Connection handle: 1 )
[09:15:09] CMySQLHandler::FetchRow() - Return: 1.8359999540261924
[09:15:09] >> mysql_free_result( Connection handle: 1 )
[09:15:09] CMySQLHandler::FreeResult() - Result was successfully free\'d.
[09:15:09] >> mysql_query( Connection handle: 1 )
[09:15:09] CMySQLHandler::Query(UPDATE `players` SET `money`=\'1684\' WHERE `name`=\'Rico_Bernasconi\') - Successfully executed.
Itt nagyon jól működik