Reputation: 8 Worker
- Active Members
- Active Posts:
- 98 (0.19 per day)
- 12-October 12
- Profile Views:
- Last Active:
- Jul 04 2013 12:04 AM
- Dream Kudos:
Posts I've Made
Posted 4 Jul 2013thought #1, backup your data before you try anything
thought #2, why is ExpirationTime not a DATE/DATETIME field? (otherwise you could use DATE_ADD(), cf. date/time functions in SQL)
thought #3, the current date is available via NOW()/CURRENT_DATE/etc. (see link above)
thought #4, you can run this purely in SQL
It was all previously saved using unix timestamps written by php, and, due to my laziness, i haven't converted it over.
Posted 18 Apr 2013Pretty sure you can't use that type of increment syntax with UPDATEs, but the rest of the query is fine:
$sql = "UPDATE `DatabaseName`.`TableName` SET `ValueIwantToIncrease` = `ValueIwantToIncrease` + 1 WHERE `TableName`.`id` = 1 LIMIT 1"
I'll test that out tomorrow, thanks. And i have been doing it by getting the "ValueIwantToIncrease" in one query and then saying "$setToVal = $resultOfQuery + 1" and then assigning "ValueIwantToIncrease = $setToVal" (+ syntax of course when i actually do it in the code), but i have a feeling this will be a lot simpler; thanks.
Posted 7 Apr 2013Your brain and your fingers are really the best website builder. All website builder codes came from somewhere and are limited to the knowledge of their developer. If you code your own website from scratch, the potential is limitless.
Posted 29 Mar 2013Sorry for the late reply. Was in the shower, where all good thinking happens of course, and i thought of a way to recreate the function and after about 10 minutes of working on it I was able to rebuild an equivalent version that produces the same output. Thanks for your help.
Posted 28 Mar 2013There's no built in function c (that I'm aware of). It may be included from another file. Looks like they're obfuscating the code so that you can't just just cut and paste their solution.
Thanks for the quick reply, is it possible to see where it calls from? I ask because I'm working on a similar site and they seem to have their security done pretty well.
- Member Title:
- D.I.C Head
- Age Unknown
- Birthday Unknown
LilGhost hasn't added any friends yet.