Very Quick Project - I have Wordpress with SupportCandy ticket system plugin.
Guests open tickets and users reply to the tickets.
What is needed:
Wordpress plugin that will send +1 to a remote MySQL database every time "Reply" button is clicked on SupportCandy by a registered user (not by guest).
Registered user clicks "Reply" ---> Send +1 and username to remote MySQL
In a new MySQL database:
For each day, every time a registered user (Not Guest) click "Reply" (or "Send message") using SupportCandy increase this user's reply count by 1 and store in MySQL with the username.
User1 - 20 Clicks
Admin - 25 Clicks
User55 - 40 Clicks
User1 - 15 Clicks
Admin - 2 Clicks
User55 - 6 Clicks
Display these results in a separate MySQL page from new date to old.
Delete dates older than 90 days.
Any reply without "I have fully read and understood what needs to be done" will be ignored.