[CreativityLacker]

Quote:

Originally Posted by [HiC]TheKiller 1. Could you please post the printed values for the query variable for some of them. 2. May sound like a stupid question, but have you used db_open? 3. Is it actually reaching the queries? Use print around the queries and see if that area of code is being printed . 4. Try taking out the ' and ' around the numerical values. This may be causing issues if the fields are integers in the database.

Query's printed

Quote:

[16:05:05] UPDATE MINING SET ORE='0', COPPER='0', TIN='0', ORE_CONTAINER='0', COPPER_CONTAINER='0', TIN_CONTAINER='0', TOOL='0', MININGXP='0' WHERE `USERNAME` = '[COD5]Gangs' [16:05:05] UPDATE TIME_STATS SET TIMES_WEEDED='0',TIMES_MINED='0',TIMES_FISHED='0', TIMES_PUNISHED='0',HOURS_PLAYED='0',MINUTES_PLAYED ='0',SECONDS_PLAYED='0',TIMES_PLAYED='0' WHERE `USERNAME`='[COD5]Gangs' [16:05:05] UPDATE MAIN_PSTATS SET KILLS='0',DEATHS='0',XP='0',MONEY='55000',BALANCE= '0' WHERE `USERNAME`='[COD5]Gangs' [16:05:05] UPDATE SERVER_STATS SET PASSWORD='nAn',IP='nill',ADMINLEVEL='0',VIPLEVEL=' 0',DONATED='0.000000',REG_YEAR='2013',REG_MONTH='5 ',REG_DAY='12' WHERE `USERNAME`='[COD5]Gangs' [16:05:05] UPDATE OWNERSHIP_STATS SET CAR1='9999',CAR2='9999',HOUSE='9999' WHERE `USERNAME`='[COD5]Gangs' [16:05:05] UPDATE INVENTORY_STATS SET WEED='0',SEEDS='0',FISHBAIT='0',TUNA='0',SNAPPER=' 0',NEEDLEFISH='0',FERTILIZIERS='0' WHERE `USERNAME`='[COD5]Gangs' [16:05:06] UPDATE NOTIFY_STATS SET JOINLEAVE='1',SPREES='0',CAPTURES='0',ADMINS='0' WHERE `USERNAME`='[COD5]Gangs'

The MAIN_PSTATS one is still not saving.