dashed-slug.net › Forums › Airdrop extension support › date and time of transactions
- This topic has 15 replies, 2 voices, and was last updated 5 years, 8 months ago by
alexg.
-
AuthorPosts
-
January 2, 2019 at 10:58 pm #5447
Anonymous
InactiveFirst of all congratulate him on this extension.
I would like to know if there is any possibility that I put the date and time when an airdrop is done.
Thank you very much, best regards and happy 2019
January 3, 2019 at 9:04 am #5459alexg
KeymasterHello,
Thank you and happy new year to you too.
Unfortunately this is not possible at the moment.
If you are interested in making the airdrop appear as if it occurred at some point in time, you can update the
created_time
andupdated_time
columns in the DB manually. For example, imagine you just performed an airdrop with a tag ofad-5be9b4ca31a06
and you would like it to appear as if it happened on the change of the new year. You would do the following:1. Back up your database.
2. In your MySQL console, do this:
UPDATE wp_wallets_txs SET created_time='2018-01-01 00:00:00', updated_time='2018-01-01 00:00:00' WHERE tags LIKE '%ad-5be9b4ca31a06%'. (Replace
wp_` with your actual table prefix if needed).Were you interested in actually performing the airdrop on a schedule? This is not currently possible.
with regards
January 3, 2019 at 9:33 am #5461Anonymous
InactiveExcuse me, I do not know if you explain me well. I use a translator.
When doing an airdrop the date and time puts it incorrect.
I attached some captures.
Attachments:
You must be logged in to view attached files.January 3, 2019 at 9:41 am #5464alexg
KeymasterOK I understand now.
The plugin inserts the current date as it is set on your server.
It uses the MySQL function
<a href="https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_current-time">current_time()</a>
.If you adjust the clock on your server, your new airdrops will be assigned the correct time.
To update the airdrop that you created already, use the code I posted above.
with regards
January 3, 2019 at 9:48 am #5465Anonymous
Inactiveumm … The clock of my server is correct other transactions appear correct, only happens with airdrop
January 3, 2019 at 10:02 am #5466alexg
KeymasterIs it possible that your database runs on another server than your PHP/web server?
Other transactions use the PHP time as reported by WordPress, but this extension uses the MySQL time because it is implemented as a pure SQL solution. I could change this but it is faster if you make sure the DB server has the correct time.
with regards
January 3, 2019 at 10:28 am #5467Anonymous
Inactivehello again, I’m looking at phpmyadmin but I can not find how to see the time of the server.
Excuse my lack of knowledge.
January 3, 2019 at 10:49 am #5468Anonymous
InactiveI have managed to check the time in myphpadmin and it is correct.
Attachments:
You must be logged in to view attached files.January 3, 2019 at 12:21 pm #5470Anonymous
InactiveI’m trying to download the extension again but it tells me that I do not have access to the downloads
January 3, 2019 at 12:37 pm #5471alexg
KeymasterYou have no access to the premium downloads because you are on a tax exempt membership plan and your VAT number does not check out on VIES. Could you please check the VATIN you entered in your profile? You can access your profile at https://www.dashed-slug.net/membership-login/membership-profile/
Let me know if you think this is in error.
with regards
January 3, 2019 at 1:10 pm #5479Anonymous
InactiveYes, I updated it and I still can not download.
January 3, 2019 at 1:14 pm #5481alexg
KeymasterThe VATIN in your profile is exactly the same as it was before.
If you cannot change it via your profile screen for some reason, then email me the number and I will enter it myself to your account.
with regards
January 3, 2019 at 1:53 pm #5482Anonymous
InactiveI sent an email thanks.
I will try to install the extension again to see if the problem of the date and time is corrected.
I wait for your answer to be able to download.
Thank you.
January 3, 2019 at 3:07 pm #5483Anonymous
Inactivecheck the date of the database as I sent you in the previous capture, I have reinstalled the extension and continues to errone the date.
January 3, 2019 at 3:31 pm #5484Anonymous
Inactiveproblem solved.
I leave here as solvent the problem.
In the file tools.php
on line 79 and 80
I changed “current_time” to “now”
Thank you very much for your support.
A greeting. -
AuthorPosts
- You must be logged in to reply to this topic.