Jun 7, 2020 #1 ES3N1N Master Summoner Discord 500 Posts Joined Nov 27, 2018 Messages 544 Reaction score 204 Hello guys, maybe someone knows how to implement this. - random reward for entering the game every 24 hours 1. for all players 2. random item only for working with SQL
Hello guys, maybe someone knows how to implement this. - random reward for entering the game every 24 hours 1. for all players 2. random item only for working with SQL
Jun 8, 2020 #2 LukasCCB 01001100 01000011 01000011 01000010 Decennium Got A Reaction Highlighted Thread Notable Release Joined Apr 23, 2013 Messages 1,180 Reaction score 2,158 :$::$::$::$: PHP: UPDATE UsersData SET GamePoints = (GamePoints+1000) WHERE DATEDIFF(MINUTE, uc.LastUpdateDate, GETDATE()) <= 24 For give item, use EXEC FN_AddItemToUser Upvote 0
:$::$::$::$: PHP: UPDATE UsersData SET GamePoints = (GamePoints+1000) WHERE DATEDIFF(MINUTE, uc.LastUpdateDate, GETDATE()) <= 24 For give item, use EXEC FN_AddItemToUser
Jun 8, 2020 #3 ES3N1N Master Summoner Discord 500 Posts Joined Nov 27, 2018 Messages 544 Reaction score 204 very tnx Upvote 0