-
Posts
374 -
Joined
-
Last visited
-
Days Won
3
Content Type
Profiles
Forums
News
Documentation
Everything posted by Jimmi
-
Hmm am cumparat sbiz 2 si are id 102 http://imgur.com/v9dcGmI cea ce inseamna ca id-urile se suprapun sau ceva de genul?
-
La stats am biz 106.imgur.com/oQDH8ub mysq_log ramane la fel.Pretul zice ca a fost schimbat dar ramane la fel. Poftim o poza din baza de date poate te ajuta cu ceva.http://imgur.com/VNyrou2,SMHeA1o
-
Am pus chestia aia crezand ca de aceea nu se modifica pretul de intrare.Totusi la fel nu se schimba. mysql_log [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed. [14:59:12] >> mysql_store_result( Connection handle: 1 ) [14:59:12] CMySQLHandler::StoreResult() - Result was stored. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 2000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25554, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2839920, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 1, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 110, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed. [14:59:12] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:12] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_free_result( Connection handle: 1 ) [14:59:13] CMySQLHandler::FreeResult() - Result was successfully free'd. [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(SELECT * FROM `bizz` ORDER BY `ID`) - Successfully executed. [14:59:13] >> mysql_store_result( Connection handle: 1 ) [14:59:13] CMySQLHandler::StoreResult() - Result was stored. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000,ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gun Shop Los Santos', `Extortion` = 'No-one', EntX = 1791.689941, EntY = -1164.030029, EntZ = 23.828100,ExitX = 315.769989, ExitY = -143.354003, ExitZ = 999.601989, Level = 15, Price = 23000000, EPrice = 2000, Till = 2296568, Locked = 0, Interior = 7, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gun Shop Las Venturas', `Extortion` = 'No-one', EntX = 2187.060058, EntY = 1113.650024, EntZ = 12.653800,ExitX = 285.815002, ExitY = -86.461402, ExitZ = 1001.520019, Level = 10, Price = 15000000, EPrice = 2000, Till = 2296568, Locked = 1, Interior = 4, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Restaurant Los Santos', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000,ExitX = -794.939025, ExitY = 489.848999, ExitZ = 1376.199951, Level = 5, Price = 5000000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 1, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 Benzinarie LS', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 1, `Owner` = 'AndyTLV', `Message` = '24/7 Fish LS', `Extortion` = 'No-one', EntX = 388.040008, EntY = -1897.229980, EntZ = 7.835939,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 0, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = '24/7 Mall', `Extortion` = 'No-one', EntX = 1154.400024, EntY = -1440.229980, EntZ = 15.801600,ExitX = 1156.750000, ExitY = -1440.270019, ExitZ = 15.798100, Level = 5, Price = 2500000, EPrice = 5, Till = 2296593, Locked = 0, Interior = 0, Products = 95, MaxProducts = 500, ProductPrice = 100 WHERE ID = 6) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 1315.430053, EntY = -898.622985, EntZ = 39.578098,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 ', `Extortion` = 'No-one', EntX = 841.130981, EntY = -1596.540039, EntZ = 13.546899,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Sex Shop', `Extortion` = 'No-one', EntX = 1087.680053, EntY = -922.481018, EntZ = 43.390598,ExitX = -100.555999, ExitY = -24.326700, ExitZ = 1000.719970, Level = 5, Price = 500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 3, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 1, `Owner` = 'The_Edic', `Message` = 'Sex Shop 24/7', `Extortion` = 'No-one', EntX = 1833.099975, EntY = -1842.510009, EntZ = 13.578100,ExitX = -100.555999, ExitY = -24.326700, ExitZ = 1000.719970, Level = 5, Price = 500000, EPrice = 5, Till = 2296568, Locked = 0, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Cluckin Bell Grove Stree', `Extortion` = 'No-one', EntX = 2420.370117, EntY = -1508.959960, EntZ = 24.000000,ExitX = 364.950988, ExitY = -11.041299, ExitZ = 1001.849975, Level = 5, Price = 500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 11) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Cluckin Bell T.C.C', `Extortion` = 'No-one', EntX = 927.765991, EntY = -1352.810058, EntZ = 13.343799,ExitX = 364.950988, ExitY = -11.041299, ExitZ = 1001.849975, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 12) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Burger Shot Plaja LS', `Extortion` = 'No-one', EntX = 810.973999, EntY = -1616.229980, EntZ = 13.546899,ExitX = 363.265991, ExitY = -74.840202, ExitZ = 1001.510009, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 13) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Well Stacked Pizza', `Extortion` = 'No-one', EntX = 2104.699951, EntY = -1807.130004, EntZ = 13.575900,ExitX = 372.351013, ExitY = -132.964004, ExitZ = 1001.489990, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 14) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 ', `Extortion` = 'No-one', EntX = 2884.860107, EntY = 2453.639892, EntZ = 11.069000,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 15) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 ', `Extortion` = 'No-one', EntX = 2546.520019, EntY = 1972.010009, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 16) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 Burger Shot LV', `Extortion` = 'No-one', EntX = 2452.429931, EntY = 2064.399902, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 17) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 2247.739990, EntY = 2397.070068, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 18) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 2097.620117, EntY = 2224.310058, EntZ = 11.023400,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 19) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 1937.150024, EntY = 2307.149902, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 20) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Pay N Spray', `Extortion` = 'No-one', EntX = 1034.750000, EntY = -1028.189941, EntZ = 32.101600,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 7500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 21) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gungame Arena', `Extortion` = 'No-one', EntX = 1965.800048, EntY = 1623.219970, EntZ = 12.862099,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 5000000, EPrice = 15, Till = 2296568, Locked = 0, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 22) - Successfully executed. [14:59:13] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:13] >> mysql_query( Connection handle: 1 ) [14:59:14] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Casino Las Venturas', `Extortion` = 'No-one', EntX = 2020.160034, EntY = 1007.739990, EntZ = 10.820300,ExitX = 2018.579956, ExitY = 1017.750000, ExitZ = 996.875000, Level = 5, Price = 5000000, EPrice = 15, Till = 2296568, Locked = 0, Interior = 10, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 23) - Successfully executed. [14:59:14] >> mysql_retrieve_row( Connection handle: 1 ) [14:59:14] >> mysql_free_result( Connection handle: 1 ) [14:59:14] CMySQLHandler::FreeResult() - Result was successfully free'd.
-
Mersi ca mi-ai explicat.Acuma cand dau /bizfee se reincarca si biz-urile dar pretul ramane aceleasi.Poate fi de la comanda /bizfee? if(strcmp(cmd, "/bizfee", true) == 0) { if(IsPlayerConnected(playerid)) { new bouse = PlayerInfo[playerid][pPbiskey]; new query[256]; if (bouse == 255) return SendClientMessage(playerid, COLOR_GRAD2, " Nu detii o afacere !"); tmp = strtok(cmdtext, idx); if(!strlen(tmp)) return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /bizfee [EntranceFee]"); if(strval(tmp) < 0 || strval(tmp) > 2000) return SendClientMessage(playerid, COLOR_WHITE, "Suma minima este de $0, suma maxima este de $2000."); if (bouse >= 100) { if(bouse == 102) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Phone Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } if(bouse == 103) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Gas Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } if(bouse == 104) { if(strval(tmp) > 0 && strval(tmp) < 101) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Electricity Company: {FFFFFF} /bizfee poate fi maxim 100!"); return 1; } } if(bouse == 106 || bouse == 107) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}CNN: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } SBizzInfo[bouse-100][sbEntranceCost] = strval(tmp); format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", SBizzInfo[bouse-100][sbEntranceCost]); OnPropUpdate(); SendClientMessage(playerid, COLOR_WHITE, string); } else { if(bouse >= 5 && bouse <= 11 || bouse >= 19 && bouse <= 25) { if(strval(tmp) > 0 && strval(tmp) < 501) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}24/7: {FFFFFF} /bizfee poate fi maxim 500!"); return 1; } } BizzInfo[bouse][bEntranceCost] = strval(tmp); format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", BizzInfo[bouse][bEntranceCost]); OnPropUpdate(); SendClientMessage(playerid, COLOR_WHITE, string); } format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s' WHERE `ID` = '%i'",BizzInfo[bouse][bEntranceCost], bouse); mysql_query(query); } return 1; }
-
public OnPropUpdate() { new File: file2; new string[ 256 * 10 ]; new idx; new index = 0; new query[256]; format(query, sizeof(query), "SELECT * FROM `sbizz` ORDER BY `ID`"); mysql_query(query); mysql_store_result(); idx = 0; while(mysql_retrieve_row()) { index++; idx = index - 1; format( string, sizeof(string), "UPDATE `sbizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f, ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d", SBizzInfo[idx][sbOwned], SBizzInfo[idx][sbOwner], SBizzInfo[idx][sbMessage], SBizzInfo[idx][sbExtortion], SBizzInfo[idx][sbEntranceX], SBizzInfo[idx][sbEntranceY], SBizzInfo[idx][sbEntranceZ], SBizzInfo[idx][sbExitX], SBizzInfo[idx][sbExitY], SBizzInfo[idx][sbExitZ], SBizzInfo[idx][sbLevelNeeded], SBizzInfo[idx][sbBuyPrice], SBizzInfo[idx][sbEntranceCost], SBizzInfo[idx][sbTill], SBizzInfo[idx][sbLocked], SBizzInfo[idx][sbInterior], SBizzInfo[idx][sbProducts], SBizzInfo[idx][sbMaxProducts], SBizzInfo[idx][sbPriceProd], idx); mysql_query(string); } while(mysql_retrieve_row()) { index++; idx = index - 1; format( string, sizeof(string), "UPDATE `bizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f,ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d", BizzInfo[idx][bOwned], BizzInfo[idx][bOwner], BizzInfo[idx][bMessage], BizzInfo[idx][bExtortion], BizzInfo[idx][bEntranceX], BizzInfo[idx][bEntranceY], BizzInfo[idx][bEntranceZ], BizzInfo[idx][bExitX], BizzInfo[idx][bExitY], BizzInfo[idx][bExitZ], BizzInfo[idx][bLevelNeeded], BizzInfo[idx][bBuyPrice], BizzInfo[idx][bEntranceCost], BizzInfo[idx][bTill], BizzInfo[idx][bLocked], BizzInfo[idx][bInterior], BizzInfo[idx][bProducts], BizzInfo[idx][bMaxProducts], BizzInfo[idx][bPriceProd], idx); mysql_query(string); } idx = 1; while (idx < sizeof(GangInfo)) { new coordsstring[256]; format(coordsstring, sizeof(coordsstring), "%d,%d,%d\n", GangInfo[idx][gID],// GangInfo[idx][gFaction], GangInfo[idx][gHours]);// if(idx == 1) { file2 = fopen("Configs/gangzones.cfg", io_write); } else { file2 = fopen("Configs/gangzones.cfg", io_append); } fwrite(file2, coordsstring); idx++; fclose(file2); } idx = 2; while (idx < sizeof(Bank)) { new coordsstring[256]; format(coordsstring, sizeof(coordsstring), "%d,%d\n", Bank[idx][bankID],// Bank[idx][bankHours]);// if(idx == 1) { file2 = fopen("Configs/bank.cfg", io_write); } else { file2 = fopen("Configs/bank.cfg", io_append); } fwrite(file2, coordsstring); idx++; fclose(file2); } return 1; }
-
Pentru amandoua.Eu dau /bizfee la un biz nu stiu de ce reincarca sbiz
-
Ma duc in game dau bizfee la un biz si in mysql log apare [12:44:58] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed. [12:44:58] >> mysql_store_result( Connection handle: 1 ) [12:44:58] CMySQLHandler::StoreResult() - Result was stored. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 2000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25554, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2839920, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 2, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 110, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_query( Connection handle: 1 ) [12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed. [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:58] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `players` SET `Money`='9010044' WHERE `username`='Jimmi') - Successfully executed. [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed. [12:44:59] >> mysql_store_result( Connection handle: 1 ) [12:44:59] CMySQLHandler::StoreResult() - Result was stored. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 2000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25554, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2839920, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 2, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 110, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed. [12:44:59] >> mysql_retrieve_row( Connection handle: 1 ) [12:44:59] >> mysql_query( Connection handle: 1 ) [12:45:00] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed. [12:45:00] >> mysql_retrieve_row( Connection handle: 1 ) [12:45:00] >> mysql_retrieve_row( Connection handle: 1 )
-
up
-
Ceva de genul. enum bInfo { bOwned, bOwner[64], bMessage[128], bExtortion[MAX_PLAYER_NAME], Float:bEntranceX, Float:bEntranceY, Float:bEntranceZ, Float:bExitX, Float:bExitY, Float:bExitZ, bLevelNeeded, bBuyPrice, bEntranceCost, bTill, bLocked, bInterior, bProducts, bMaxProducts, bPriceProd, }; new BizzInfo[100][bInfo];
-
s-bizz sau biz ? EDIT:24 este ultimul 1 este primul
-
Aici ? public LoadBizz() { new biss; new result[100],index = 0; new query[256]; format(query, sizeof(query), "SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC"); mysql_query(query); mysql_store_result(); while(mysql_retrieve_row()) { biss++; index++; new i = index; mysql_get_field("Owned", result); BizzInfo[i][bOwned] = strval(result); mysql_get_field("Owner", result); strmid(BizzInfo[i][bOwner], result, 0, 32, 32); mysql_get_field("Message", result); strmid(BizzInfo[i][bMessage], result, 0, 60, 60); mysql_get_field("Extortion", result); strmid(BizzInfo[i][bExtortion], result, 0, 32, 32); mysql_get_field("EntX", result); BizzInfo[i][bEntranceX] = floatstr(result); mysql_get_field("EntY", result); BizzInfo[i][bEntranceY] = floatstr(result); mysql_get_field("EntZ", result); BizzInfo[i][bEntranceZ] = floatstr(result); mysql_get_field("ExitX", result); BizzInfo[i][bExitX] = floatstr(result); mysql_get_field("ExitY", result); BizzInfo[i][bExitY] = floatstr(result); mysql_get_field("ExitZ", result); BizzInfo[i][bExitZ] = floatstr(result); mysql_get_field("Level", result); BizzInfo[i][bLevelNeeded] = strval(result); mysql_get_field("Price", result); BizzInfo[i][bBuyPrice] = strval(result); mysql_get_field("EPrice", result); BizzInfo[i][bEntranceCost] = strval(result); mysql_get_field("Till", result); BizzInfo[i][bTill] = strval(result); mysql_get_field("Locked", result); BizzInfo[i][bLocked] = strval(result); mysql_get_field("Interior", result); BizzInfo[i][bInterior] = strval(result); mysql_get_field("Products", result); BizzInfo[i][bProducts] = strval(result); mysql_get_field("MaxProducts", result); BizzInfo[i][bMaxProducts] = strval(result); mysql_get_field("ProductPrice", result); BizzInfo[i][bPriceProd] = strval(result); } mysql_free_result(); printf("%d bizz-uri create. (Daca apare 0 = Nu are conectiunea la baza de date)", index); return 1; } public LoadSBizz() { new sbiss; new result[100],index = 0; new query[256]; format(query, sizeof(query), "SELECT * FROM `sbizz`"); mysql_query(query); mysql_store_result(); while(mysql_retrieve_row()) { sbiss++; index++; new i = index; mysql_get_field("Owned", result); SBizzInfo[i][sbOwned] = strval(result); mysql_get_field("Owner", result); strmid(SBizzInfo[i][sbOwner], result, 0, 32, 32); mysql_get_field("Message", result); strmid(SBizzInfo[i][sbMessage], result, 0, 60, 60); mysql_get_field("Extortion", result); strmid(SBizzInfo[i][sbExtortion], result, 0, 32, 32); mysql_get_field("EntX", result); SBizzInfo[i][sbEntranceX] = floatstr(result); mysql_get_field("EntY", result); SBizzInfo[i][sbEntranceY] = floatstr(result); mysql_get_field("EntZ", result); SBizzInfo[i][sbEntranceZ] = floatstr(result); mysql_get_field("ExitX", result); SBizzInfo[i][sbExitX] = floatstr(result); mysql_get_field("ExitY", result); SBizzInfo[i][sbExitY] = floatstr(result); mysql_get_field("ExitZ", result); SBizzInfo[i][sbExitZ] = floatstr(result); mysql_get_field("Level", result); SBizzInfo[i][sbLevelNeeded] = strval(result); mysql_get_field("Price", result); SBizzInfo[i][sbBuyPrice] = strval(result); mysql_get_field("EPrice", result); SBizzInfo[i][sbEntranceCost] = strval(result); mysql_get_field("Till", result); SBizzInfo[i][sbTill] = strval(result); mysql_get_field("Locked", result); SBizzInfo[i][sbLocked] = strval(result); mysql_get_field("Interior", result); SBizzInfo[i][sbInterior] = strval(result); mysql_get_field("Products", result); SBizzInfo[i][sbProducts] = strval(result); mysql_get_field("MaxProducts", result); SBizzInfo[i][sbMaxProducts] = strval(result); mysql_get_field("ProductPrice", result); SBizzInfo[i][sbPriceProd] = strval(result); } mysql_free_result(); printf("%d sbizz-uri create. (Daca apare 0 = Nu are conectiunea la baza de date", index); return 1; }sau te referi la onpropupdate?
-
Tot nu se schimba pretul si in server_log [16:53:13] [debug] Run time error 4: "Array index out of bounds" [16:53:13] [debug] Accessing element at index 106 past array upper bound 99 [16:53:13] [debug] AMX backtrace: [16:53:13] [debug] #0 002c1130 in public OnPlayerCommandPerformed (playerid=0, cmdtext[]=@0732a578 "/bizfee 3", success=0) at C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn:41673 [16:53:13] [debug] #1 native CallLocalFunction () from samp-server.exe [16:53:13] [debug] #2 00028344 in public OnPlayerCommandText (playerid=0, cmdtext[]=@0732a54c "/bizfee 3") at C:\Users\Jimmi\Desktop\93.119.25.182-7777\pawno\include\zcmd.inc:108 mysql_log[16:53:13] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed. [16:53:13] >> mysql_store_result( Connection handle: 1 ) [16:53:13] CMySQLHandler::StoreResult() - Result was stored. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25525, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2083155, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 3, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_query( Connection handle: 1 ) [16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed. [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) [16:53:13] >> mysql_retrieve_row( Connection handle: 1 ) Eu dau sa schimb pretul de intrare al unui bizz nu stiu de ce apare in mysql_log sbiz. Comanda /bizfee if(strcmp(cmd, "/bizfee", true) == 0) { if(IsPlayerConnected(playerid)) { new bouse = PlayerInfo[playerid][pPbiskey]; new query[256]; if (bouse == 255) return SendClientMessage(playerid, COLOR_GRAD2, " Nu detii o afacere !"); tmp = strtok(cmdtext, idx); if(!strlen(tmp)) return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /bizfee [EntranceFee]"); if(strval(tmp) < 0 || strval(tmp) > 2000) return SendClientMessage(playerid, COLOR_WHITE, "Suma minima este de $0, suma maxima este de $2000."); if (bouse >= 100) { if(bouse == 102) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Phone Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } if(bouse == 103) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Gas Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } if(bouse == 104) { if(strval(tmp) > 0 && strval(tmp) < 101) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Electricity Company: {FFFFFF} /bizfee poate fi maxim 100!"); return 1; } } if(bouse == 106 || bouse == 107) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}CNN: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } SBizzInfo[bouse-100][sbEntranceCost] = strval(tmp); format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", SBizzInfo[bouse-100][sbEntranceCost]); OnPropUpdate(); SendClientMessage(playerid, COLOR_WHITE, string); } else { if(bouse >= 5 && bouse <= 11 || bouse >= 19 && bouse <= 25) { if(strval(tmp) > 0 && strval(tmp) < 501) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}24/7: {FFFFFF} /bizfee poate fi maxim 500!"); return 1; } } BizzInfo[bouse][bEntranceCost] = strval(tmp); format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", BizzInfo[bouse][bEntranceCost]); OnPropUpdate(); SendClientMessage(playerid, COLOR_WHITE, string); } format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s' WHERE `ID` = '%i'",BizzInfo[bouse][bEntranceCost], bouse); mysql_query(query); } return 1; }
-
Problema intalnita (descriere):ă:Am trecut biz-urile si sbiz-urile pe mysql.Acum cand folosesc /bizfee nu se mai actualizeaza pretul de intrare in biz/sbiz. Ero(area / rile) / warning-(ul / urile): Imagini / Video (optional):- Ati incercat sa rezolvati singur?:Da [15:26:45] >> mysql_query( Connection handle: 1 ) [15:26:45] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed. [15:26:45] >> mysql_store_result( Connection handle: 1 ) [15:26:45] CMySQLHandler::StoreResult() - Result was stored. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25525, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 1897065, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 2, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_query( Connection handle: 1 ) [15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed. [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) [15:26:46] >> mysql_retrieve_row( Connection handle: 1 ) Liniile de cod / sursa / script-ul(obligatoriu): if(strcmp(cmd, "/bizfee", true) == 0) { if(IsPlayerConnected(playerid)) { new bouse = PlayerInfo[playerid][pPbiskey]; new query[256]; if (bouse == 255) return SendClientMessage(playerid, COLOR_GRAD2, " Nu detii o afacere !"); tmp = strtok(cmdtext, idx); if(!strlen(tmp)) return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /bizfee [EntranceFee]"); if(strval(tmp) < 0 || strval(tmp) > 2000) return SendClientMessage(playerid, COLOR_WHITE, "Suma minima este de $0, suma maxima este de $2000."); if (bouse >= 100) { if(bouse == 102) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Phone Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } if(bouse == 103) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Gas Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } if(bouse == 104) { if(strval(tmp) > 0 && strval(tmp) < 101) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Electricity Company: {FFFFFF} /bizfee poate fi maxim 100!"); return 1; } } if(bouse == 106 || bouse == 107) { if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}CNN: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; } } SBizzInfo[bouse-100][sbEntranceCost] = strval(tmp); format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", SBizzInfo[bouse-100][sbEntranceCost]); OnPropUpdate(); SendClientMessage(playerid, COLOR_WHITE, string); } else { if(bouse >= 5 && bouse <= 11 || bouse >= 19 && bouse <= 25) { if(strval(tmp) > 0 && strval(tmp) < 501) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}24/7: {FFFFFF} /bizfee poate fi maxim 500!"); return 1; } } BizzInfo[bouse][bEntranceCost] = strval(tmp); format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", BizzInfo[bouse][bEntranceCost]); OnPropUpdate(); SendClientMessage(playerid, COLOR_WHITE, string); format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s'",BizzInfo[bouse][bEntranceCost]); mysql_query(query); } } return 1; }
-
Pai man asa am facuto si eu doar ca nu punea puncte.Asa ce am facut nu e nimica.Nu apare niciun dialog.In baza de date tot la fel e ca inainte.Dau /showstaffactivity ID si nimica.Nu apare nimica. EDIT:Lasa o sa vad eu ce fac cu ea.
-
Pai da ba dar nu stiu cum sa o fac sa citeasca doar comanda x la id y aia am zis si eu mai sus.Aaa da si nu pare dialogul
-
Pai da man dar eu vreau doar unele comenzi sa la afiseze la /showstaffactivity
-
Nu ca nu am stiut cum sa fac in comanda Stiu ca trebuie sa fac ceva de genul mysql_fetch_field_row(dataextrasa, "Command"); care sa extraga dar mai departe nu
-
CMD:showstaffactivity(playerid, params[]) { if(IsPlayerConnected(playerid)) { new jucator; new Query[96]; if(sscanf(params, "u", jucator)) return SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /showstaffactivity [PlayerID/PartOfName]"); format(Query, sizeof(Query), "SELECT * FROM `logExecCmds` WHERE `Player` = '%i' LIMIT 10", PlayerInfo[jucator][pSQLID]); mysql_query(Query); new str[255+1], players[MAX_PLAYER_NAME]; GetPlayerName(jucator, players, sizeof(players)); format(str, sizeof(str), "{FFFFFF}Activitatea lui %s", players); ShowPlayerDialog(playerid, 9, DIALOG_STYLE_MSGBOX, str, "/opr\t0 ori\n/cpr\t0 ori\n /unfreeze\t0 ori\n/setint\t0 ori\n/setvw\t0 ori\n/mute\t0 ori\n/mutereport\t0 ori\n/cc\t0 ori\n/respawn\t0 ori\n/slap\t0 ori\n/spec\t0 ori\n/setjob\t0 ori\n/kick\t0 ori\n/ban\t0 ori\n/goto\t0 ori\n/jail\t0 ori","Close",""); } return 1; }
-
Ma miram de ce a cazut sv: 14:50:49] >> mysql_query( Connection handle: 1 ) [14:50:49] CMySQLHandler::Query(SELECT * FROM `logExecCmds` WHERE `Player` = '0' LIMIT 10) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:50:49] OnQueryError() - Called. [14:50:50] >> mysql_query( Connection handle: 1 ) [14:50:50] CMySQLHandler::Query(INSERT INTO `logExecCmds`(`Player`, `Command`, `DateTime`, `ECount`) VALUES ('starz','/goto','16/06/2015 - 14:50:50','1')) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:50:50] OnQueryError() - Called. [14:50:53] >> mysql_query( Connection handle: 1 ) [14:50:53] CMySQLHandler::Query(SELECT * FROM `logExecCmds` WHERE `Player` = '0' LIMIT 10) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:50:53] OnQueryError() - Called. [14:51:07] >> mysql_query( Connection handle: 1 ) [14:51:07] CMySQLHandler::Query(INSERT INTO `logExecCmds`(`Player`, `Command`, `DateTime`, `ECount`) VALUES ('Jimmi','/goto','16/06/2015 - 14:51:07','1')) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:07] OnQueryError() - Called. [14:51:14] >> mysql_query( Connection handle: 1 ) [14:51:14] CMySQLHandler::Query(SELECT * FROM `logExecCmds` WHERE `Player` = '0' LIMIT 10) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:14] OnQueryError() - Called. [14:51:45] >> mysql_query( Connection handle: 1 ) [14:51:45] CMySQLHandler::Query(UPDATE `players` SET `Money`='22906207' WHERE `username`='Jimmi') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:45] >> mysql_query( Connection handle: 1 ) [14:51:45] CMySQLHandler::Query(UPDATE `players` SET `Money`='24449623' WHERE `username`='starz') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:45] OnQueryError() - Called. [14:51:45] OnQueryError() - Called. [14:51:49] >> mysql_query( Connection handle: 1 ) [14:51:49] CMySQLHandler::Query(UPDATE `players` SET `Deaths`='361' WHERE `username`='Jimmi') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:49] OnQueryError() - Called. [14:51:50] >> mysql_query( Connection handle: 1 ) [14:51:50] CMySQLHandler::Query(INSERT INTO `logExecCmds`(`Player`, `Command`, `DateTime`, `ECount`) VALUES ('Jimmi','/goto','16/06/2015 - 14:51:50','2')) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:50] OnQueryError() - Called. [14:51:52] >> mysql_query( Connection handle: 1 ) [14:51:52] CMySQLHandler::Query(UPDATE `players` SET `Paycheck`='52570',`JailTime`='0',`iInt`='0',`iLocal`='255',`Team`='11',`Muted`='0', `CarTime`='0', `Level`='10', `Respect`='34' WHERE `username`='Jimmi') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:52] >> mysql_query( Connection handle: 1 ) [14:51:52] CMySQLHandler::Query(UPDATE `players` SET `Respect`='34' WHERE `username`='Jimmi') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:52] >> mysql_query( Connection handle: 1 ) [14:51:52] CMySQLHandler::Query(UPDATE `players` SET `ConnectedTime`='77' WHERE `username`='Jimmi') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:52] >> mysql_query( Connection handle: 1 ) [14:51:52] CMySQLHandler::Query(UPDATE `players` SET `Points`='42' WHERE `username`='Jimmi') - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:51:52] OnQueryError() - Called. [14:51:52] OnQueryError() - Called. [14:51:52] OnQueryError() - Called. [14:51:52] OnQueryError() - Called. [14:52:22] >> mysql_query( Connection handle: 1 ) [14:52:22] CMySQLHandler::Query(INSERT INTO `logExecCmds`(`Player`, `Command`, `DateTime`, `ECount`) VALUES ('Jimmi','/opr','16/06/2015 - 14:52:22','3')) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:52:22] OnQueryError() - Called. [14:52:30] >> mysql_query( Connection handle: 1 ) [14:52:30] CMySQLHandler::Query(SELECT * FROM `logExecCmds` WHERE `Player` = '0' LIMIT 10) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:52:30] OnQueryError() - Called. [14:52:32] >> mysql_query( Connection handle: 1 ) [14:52:32] CMySQLHandler::Query(SELECT * FROM `logExecCmds` WHERE `Player` = '0' LIMIT 10) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:52:32] OnQueryError() - Called. [14:53:23] >> mysql_query( Connection handle: 1 ) [14:53:23] CMySQLHandler::Query(INSERT INTO `logExecCmds`(`Player`, `Command`, `DateTime`, `ECount`) VALUES ('Jimmi','/goto','16/06/2015 - 14:53:23','4')) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:53:23] OnQueryError() - Called. [14:53:47] >> mysql_query( Connection handle: 1 ) [14:53:47] CMySQLHandler::Query(INSERT INTO `logExecCmds`(`Player`, `Command`, `DateTime`, `ECount`) VALUES ('Jimmi','/goto','16/06/2015 - 14:53:47','5')) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now) [14:53:47] OnQueryError() - Called. [14:55:07] >> mysql_ping( Connection handle: 1 ) [14:55:20] [14:55:20] --------------------------- [14:55:20] MySQL Debugging activated (06/16/15) [14:55:20] --------------------------- [14:55:20]
-
Problema e ca acuma nu mai arata comenzile in baza de date dau /setint si nu mai apar in baza de date: if(strcmp(cmd, "/setint", true) == 0) { if(IsPlayerConnected(playerid)) { tmp = strtok(cmdtext, idx); if(!strlen(tmp)) { SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /setint [playerid/numejucator] [interiorid]"); return 1; } new playa; playa = ReturnUser(tmp); new intid; tmp = strtok(cmdtext, idx); intid = strvalEx(tmp); if (PlayerInfo[playerid][pAdmin] >= 1|| PlayerInfo[playerid][pTrial] >= 1) { if(IsPlayerConnected(playa)) { if(playa != INVALID_PLAYER_ID) { GetPlayerName(playa, giveplayer, sizeof(giveplayer)); GetPlayerName(playerid, sendername, sizeof(sendername)); SetPlayerInterior(playa, intid); PlayerInfo[playa][pInt] = intid; format(string, sizeof(string), " I-ai setat interiorul lui %s pe %d.", giveplayer, intid); SendClientMessage(playerid, COLOR_GRAD1, string); format(string, sizeof(string), " %s ti-a setat interiorul pe %d.", sendername, intid); SendClientMessage(playa, COLOR_GRAD1, string); ExecCMD[playerid]++; } } } else { SendClientMessage(playerid, COLOR_GRAD1, "** Nu ai rangul administrativ necesar!"); } } SaveExecCMDS(playerid, "/setint", ExecCMD[playerid]); return 1; }SaveExecCMDS(playerid, "/setint", ExecCMD[playerid]); si ExecCMD[playerid]++; le-am adaugat sa sa salvee in save de date si nu inteleg de ce nu mai merge acuma.... stock RegEx() { new fx[24],a,b,c,d,e,f; gettime(a,b,c); getdate(d,e,f); format(fx, sizeof(fx), "%02d/%02d/%02d - %02d:%02d:%02d", f,e,d,a,b,c); return fx; } stock SaveExecCMDS(playerid, const string[], &str) { new xquery[255], uns[MAX_PLAYER_NAME]; GetPlayerName(playerid, uns, sizeof(uns)); format(xquery, sizeof(xquery), "INSERT INTO `logExecCmds`(`Player`, `Command`, `DateTime`, `ECount`) VALUES ('%s','%s','%s','%d')", uns, string, RegEx(), str); mysql_query(xquery); return 1; }
-
Exact aceasi eroare: C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(27899) : error 076: syntax error in the expression, or invalid function call Linia 27899 format(Query, sizeof(Query), "SELECT * FROM `logExecCmds` WHERE `Player` = '%i' LIMIT 10", PlayerInfo[jucator][pName]);Comanda aranjata cred //========================================[CMD /SHOWSTAFFACTIVITY]============================================// CMD:showstaffactivity(playerid, params[]) { if(IsPlayerConnected(playerid)) { new jucator; new Query[96]; if(sscanf(params, "u", jucator)) return SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /showstaffactivity [PlayerID/PartOfName]"); format(Query, sizeof(Query), "SELECT * FROM `logExecCmds` WHERE `Player` = '%i' LIMIT 10", PlayerInfo[jucator][pName]); mysql_query(Query); new str[255+1], players[MAX_PLAYER_NAME]; GetPlayerName(jucator, players, sizeof(players)); format(str, sizeof(str), "{FFFFFF}Activitatea lui %s", players); ShowPlayerDialog(playerid, 9, DIALOG_STYLE_MSGBOX, str, "/opr\t0 ori\n/cpr\t0 ori\n /unfreeze\t0 ori\n/setint\t0 ori\n/setvw\t0 ori\n/mute\t0 ori\n/mutereport\t0 ori\n/cc\t0 ori\n/respawn\t0 ori\n/slap\t0 ori\n/spec\t0 ori\n/setjob\t0 ori\n/kick\t0 ori\n/ban\t0 ori\n/goto\t0 ori\n/jail\t0 ori","Close",""); } return 1; }
-
Imi da o eroare: C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(27897) : error 076: syntax error in the expression, or invalid function call Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase 1 Error. Folosesc mysql r6. Asa am facut comanda //========================================[CMD /SHOWSTAFFACTIVITY]============================================// CMD:showstaffactivity(playerid, params[]) { if(IsPlayerConnected(playerid)) { new jucator, Query[96]; format(Query, sizeof(Query), "SELECT * FROM `logExecCmds` WHERE `Player` = '%i' LIMIT 10", PlayerInfo[playerid][pName]); mysql_query(Query); if(sscanf(params, "u", jucator)) return SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /showstaffactivity [PlayerID/PartOfName]"); new str[255+1], players[MAX_PLAYER_NAME]; GetPlayerName(jucator, players, sizeof(players)); format(str, sizeof(str), "{FFFFFF}Activitatea lui %s", players); ShowPlayerDialog(playerid, 9, DIALOG_STYLE_MSGBOX, str, "/opr\t0 ori\n/cpr\t0 ori\n /unfreeze\t0 ori\n/setint\t0 ori\n/setvw\t0 ori\n/mute\t0 ori\n/mutereport\t0 ori\n/cc\t0 ori\n/respawn\t0 ori\n/slap\t0 ori\n/spec\t0 ori\n/setjob\t0 ori\n/kick\t0 ori\n/ban\t0 ori\n/goto\t0 ori\n/jail\t0 ori","Close",""); } return 1; }
-
enum pInfo { pRoadblock,pRadar,pTiredFromGym,pPunish,pTiredFromGrabkick,pTiredFromKarate,pKey[128],pLevel,pAdmin,pDonateRank, gPupgrade,pConnectTime,pReg,pSex,pAge,pOrigin[30],pGymEquiped,pKarateEquiped,pBoxFightStyle,pCK,pMuted,pExp,pCash, pAccount,pCrimes,pKills,pDeaths,pArrested,pWantedDeaths,pPhoneBook,pLottoNr,pFishes,pBiggestFish,pJob,pPayCheck, pHeadValue,pJailed,pJailTime,pMats,pDrugs,pTow,pLeader,pMember,pFMember,pRank,pChar,pContractTime,pDetSkill,pSexSkill, pBoxSkill,pLawSkill,pBoxingSkill,pGrabkickSkill,pKarateSkill,pMechSkill,pJackSkill,pCarSkill, pNewsSkill,pDrugsSkill,pCookSkill,pFishSkill,pDMVCar,Float:pHealth,Float:pSHealth,pInt,pLocal,pTeam,pModel,pPnumber, pPhousekey,pPbiskey,Float:pPos_x,Float:pPos_y,Float:pPos_z,pCarLic,pFlyLic,pBoatLic,pFishLic,pGunLic,pGun1,pGun2,pGun3, pGun4,pAmmo1,pAmmo2,pAmmo3,pAmmo4,pCarTime,pPayDay,pPayDayHad,pCDPlayer,pWins,pLoses,pAlcoholPerk,pDrugPerk,pMiserPerk, pPainPerk,pTraderPerk,pTut,pMissionNr,pWarns,pAdjustable,pFuel,pMarried,pMarriedTo[128],LastLogin[128],pRobbingBank, pJob1,pAchievement1,pAchievement2,pAchievement3,pAchievement4,pAchievement5,pAchievement6,pAchievement7,pAchievement8, pAchievement9,pTrial,pNewbTimer,pGPPoints,pRPBoost,pIP[256],pCar1,pCar2,pCar3,pAchievement10,pAchievement11,pAchievement12, pAchievement13,pAchievement14,pAchievement15,pAchievement16,pAchievement17,pAchievement18,pAchievement19,pAchievement20, pAchievement21,pAchievement22,pAchievement23,pAchievement24,pAchievement25,pAchievement26,pAchievement27,pAchievement28, pAchievement29,pAchievement30,pAchievement31,pAchievement32,pAchievement33,pAchievement34,pAchievement35,pAchievement36, pAchievement37,pFwarn,pAchievement38,pAchievement39,pAchievement40,pStyle,pSQLID,pCombina,pSText[100],pGPS,pEmail[50],pCadou,pLiderW,pRMuted };
-
Presupunand ca din tabelul players:http://imgur.com/NqzDErc Nu?
-
Stiu si eu asta.Asta e problema nu stiu cum sa fac ca sa preia comanda de la cine sa /showstaffactivity.Adica daca dau /showstaffactivity 1 sa imi arate activitatea lui id 1 nu si alte comenzi folosite de alti membri