January 2, 2019 at 10:58 pm #5447
First 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 2019January 3, 2019 at 9:04 am #5459
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
updated_timecolumns in the DB manually. For example, imagine you just performed an airdrop with a tag of
ad-5be9b4ca31a06and 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%'. (Replacewp_` with your actual table prefix if needed).
Were you interested in actually performing the airdrop on a schedule? This is not currently possible.
with regardsJanuary 3, 2019 at 9:33 am #5461
Excuse 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 #5464
OK I understand now.
The plugin inserts the current date as it is set on your server.
It uses the MySQL function
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 regardsJanuary 3, 2019 at 9:48 am #5465
umm … The clock of my server is correct other transactions appear correct, only happens with airdropJanuary 3, 2019 at 10:02 am #5466
Is 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 regardsJanuary 3, 2019 at 10:28 am #5467
hello 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 #5468
I 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 #5470
I’m trying to download the extension again but it tells me that I do not have access to the downloadsJanuary 3, 2019 at 12:37 pm #5471
You 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 regardsJanuary 3, 2019 at 1:10 pm #5479
Yes, I updated it and I still can not download.January 3, 2019 at 1:14 pm #5481
The 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 regardsJanuary 3, 2019 at 1:53 pm #5482
I 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 #5483
check 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 #5484
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.
- You must be logged in to reply to this topic.