30.09.2015, 10:36
These tables listed below does not exist in the db. So its the function misc_load is not loading. I know its updating instead of creating /saving
So, How do i create these tables? Maybe SQL Query? How, Thanks!!!!!!!!
Код:
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); mysql_function_query(MainPipeline, query, false, "OnQueryFinish", "i", SENDDATA_THREAD); }