[PURG3D]

Quote:

Originally Posted by EiresJason Can you print the final formatted query please and let us know what the result is? pawn Код: stock g_mysql_SaveMOTD() {     new query[1024];     format(query, sizeof(query), "UPDATE `misc` SET ");     format(query, sizeof(query), "%s `gMOTD` = '%s',", query, g_mysql_ReturnEscaped(GlobalMOTD, MainPipeline));     format(query, sizeof(query), "%s `aMOTD` = '%s',", query, g_mysql_ReturnEscaped(AdminMOTD, MainPipeline));     format(query, sizeof(query), "%s `vMOTD` = '%s',", query, g_mysql_ReturnEscaped(VIPMOTD, MainPipeline));     format(query, sizeof(query), "%s `cMOTD` = '%s',", query, g_mysql_ReturnEscaped(CAMOTD, MainPipeline));     format(query, sizeof(query), "%s `pMOTD` = '%s',", query, g_mysql_ReturnEscaped(pMOTD, MainPipeline));     format(query, sizeof(query), "%s `ShopTechPay` = '%.2f',", query, ShopTechPay);     format(query, sizeof(query), "%s `GiftCode` = '%s',", query, g_mysql_ReturnEscaped(GiftCode, MainPipeline));     format(query, sizeof(query), "%s `GiftCodeBypass` = '%d',", query, GiftCodeBypass);     format(query, sizeof(query), "%s `TotalCitizens` = '%d',", query, TotalCitizens);     format(query, sizeof(query), "%s `TRCitizens` = '%d',", query, TRCitizens);     format(query, sizeof(query), "%s `ShopClosed` = '%d',", query, ShopClosed);     format(query, sizeof(query), "%s `RimMod` = '%d',", query, RimMod);     format(query, sizeof(query), "%s `CarVoucher` = '%d',", query, CarVoucher);     format(query, sizeof(query), "%s `PVIPVoucher` = '%d',", query, PVIPVoucher);     format(query, sizeof(query), "%s `GarageVW` = '%d',", query, GarageVW);     format(query, sizeof(query), "%s `PumpkinStock` = '%d',", query, PumpkinStock);     format(query, sizeof(query), "%s `HalloweenShop` = '%d'", query, HalloweenShop);               printf("Query: [%s]", query); //copy and paste the result inside the square brackets.     mysql_function_query(MainPipeline, query, false, "OnQueryFinish", "i", SENDDATA_THREAD); }

Here is it, As you can its updating but the misc table inside phmyadmin is still empty.

Код:

[10:09:24] [zcmd] [Ivann Setland]: /motd Test
[10:09:24] Query: [UPDATE `misc` SET  `gMOTD` = 'Test', `aMOTD` = '', `vMOTD` = '', `cMOTD` = '', `pMOTD` = '', `ShopTechPay` = '0.00', `GiftCode` = '', `GiftCodeBypass` = '0', `TotalCitizens` = '0', `TRCitizens` = '0', `ShopClosed` = '0', `RimMod` = '0', `CarVoucher` = '0', `PVIPVoucher` = '0', `GarageVW` = '0', `PumpkinStock` = '0', `HalloweenShop` = '0']
[10:09:27] [zcmd] [Ivann Setland]: /amotd test
[10:09:27] Query: [UPDATE `misc` SET  `gMOTD` = 'Test', `aMOTD` = 'test', `vMOTD` = '', `cMOTD` = '', `pMOTD` = '', `ShopTechPay` = '0.00', `GiftCode` = '', `GiftCodeBypass` = '0', `TotalCitizens` = '0', `TRCitizens` = '0', `ShopClosed` = '0', `RimMod` = '0', `CarVoucher` = '0', `PVIPVoucher` = '0', `GarageVW` = '0', `PumpkinStock` = '0', `HalloweenShop` = '0']
[10:09:31] [zcmd] [Ivann Setland]: /cmotd test
[10:09:31] Query: [UPDATE `misc` SET  `gMOTD` = 'Test', `aMOTD` = 'test', `vMOTD` = '', `cMOTD` = 'test', `pMOTD` = '', `ShopTechPay` = '0.00', `GiftCode` = '', `GiftCodeBypass` = '0', `TotalCitizens` = '0', `TRCitizens` = '0', `ShopClosed` = '0', `RimMod` = '0', `CarVoucher` = '0', `PVIPVoucher` = '0', `GarageVW` = '0', `PumpkinStock` = '0', `HalloweenShop` = '0']
[10:09:35] [zcmd] [Ivann Setland]: /vipmotd test
[10:09:35] Query: [UPDATE `misc` SET  `gMOTD` = 'Test', `aMOTD` = 'test', `vMOTD` = 'test', `cMOTD` = 'test', `pMOTD` = '', `ShopTechPay` = '0.00', `GiftCode` = '', `GiftCodeBypass` = '0', `TotalCitizens` = '0', `TRCitizens` = '0', `ShopClosed` = '0', `RimMod` = '0', `CarVoucher` = '0', `PVIPVoucher` = '0', `GarageVW` = '0', `PumpkinStock` = '0', `HalloweenShop` = '0']