Call to vote for your favorite tricks
Re: Call to vote for your favorite tricks
Perhaps there's a way for Falcury to get a list of all email addresses of people who visited the Princed forum in 2020 and/or have posted 50 or more times in total? I could then manually email those people via BCC from the PoPOT email address per 30 addresses or so. (I could first merge the list with a similar email addresses list of PoPOT users.) And then with a message that explains the submissions are welcome until the end of October. Falcury, what do you think?
- atrueprincefanfrom18
- Site Shah
- Posts: 1786
- Joined: January 21st, 2020, 2:53 pm
- Contact:
Re: Call to vote for your favorite tricks
Yes, that would be nice of you if you decide to send an email to them. But make sure it's not marked as spam. Test on other email id of yours. Is the message is same it might be considered spam. Maybe you need to add a name for each email.
And yes, I think any admin that has access to the user list can get it. Or it's just a simple query away:
You need to change that according to the columns, otherwise poirot would have to fire the query manually.
And yes, I think any admin that has access to the user list can get it. Or it's just a simple query away:
Code: Select all
SELECT name, email FROM users WHERE user_last_seen LIKE '%2020%' AND user_post_count >= 50;
Re: Call to vote for your favorite tricks
Maybe use OR instead of AND.atrueprincefanfrom18 wrote: ↑September 30th, 2020, 5:23 am Yes, that would be nice of you if you decide to send an email to them. But make sure it's not marked as spam. Test on other email id of yours. Is the message is same it might be considered spam. Maybe you need to add a name for each email.
And yes, I think any admin that has access to the user list can get it. Or it's just a simple query away:
You need to change that according to the columns, otherwise poirot would have to fire the query manually.Code: Select all
SELECT name, email FROM users WHERE user_last_seen LIKE '%2020%' AND user_post_count >= 50;
- atrueprincefanfrom18
- Site Shah
- Posts: 1786
- Joined: January 21st, 2020, 2:53 pm
- Contact:
Re: Call to vote for your favorite tricks
Yeah, you are right, OR would get more users.Norbert wrote: ↑September 30th, 2020, 10:17 amMaybe use OR instead of AND.atrueprincefanfrom18 wrote: ↑September 30th, 2020, 5:23 am Yes, that would be nice of you if you decide to send an email to them. But make sure it's not marked as spam. Test on other email id of yours. Is the message is same it might be considered spam. Maybe you need to add a name for each email.
And yes, I think any admin that has access to the user list can get it. Or it's just a simple query away:
You need to change that according to the columns, otherwise poirot would have to fire the query manually.Code: Select all
SELECT name, email FROM users WHERE user_last_seen LIKE '%2020%' AND user_post_count >= 50;
Code: Select all
SELECT name, email FROM users WHERE user_last_seen LIKE '%2020%' OR user_post_count >= 50;
Re: Call to vote for your favorite tricks
Were you able to contact him?
- atrueprincefanfrom18
- Site Shah
- Posts: 1786
- Joined: January 21st, 2020, 2:53 pm
- Contact:
Re: Call to vote for your favorite tricks
I did contact him, but he's too busy I guess. He told me that he would have to run the command directly, I sent him the command and all, but after that I never actually heard from him. Maybe he decided to do the task and then reply and then forgot about the task itself, or something similar, I don't really know. Maybe it's just best that you can end the vote thing at the end of the year, as not many people have voted...