WordPress.org

Ready to get started?Download WordPress

Forums

NextGEN Gallery Voting
[resolved] Delete All Votes (15 posts)

  1. cjharrison
    Member
    Posted 2 years ago #

    Hi Shaun,

    I really need to find away of deleting all votes.

    I run a photographic site where users can vote on their own pictures every month, the winner taking a prize.

    I need to be able to reset the votes once a month, can this be done?

    Many thanks,

    Chris

    http://wordpress.org/extend/plugins/nextgen-gallery-voting/

  2. shauno
    Member
    Plugin Author

    Posted 2 years ago #

    Hi cjharrison

    You can delete all votes for each image by clicking the 'Clear Votes' link for each image. If you want to delete ALL votes from the system, there is no admin interface for that. But you can run the following query on your database:
    TRUNCATE wp_nggv_votes;

  3. cjharrison
    Member
    Posted 2 years ago #

    TRUNCATE wp_nggv_votes;

    Thats done the job lovely.

    Many thanks

    Chris

  4. escribidle
    Member
    Posted 1 year ago #

    hi guy, please help me out.

    Where do I set this code: "TRUNCATE wp_nggv_votes;"

    =), im a total noob.

    Thanks a lot

  5. cjharrison
    Member
    Posted 1 year ago #

    You need to run it as an SQL command.

    Log into MySQL from your hosting control panel.

    Click on the SQL tab at the top, and paste in the above command.

    Press Go or Run and votes should be removed.

    Chris

  6. escribidle
    Member
    Posted 1 year ago #

    First of, thanks a lot for this plugin. And an awesome response time.

    I got into mySQL but have like 6 databases named wp1, wp2, wp3 and so on.

    Have no idea where the db you mention may be. :S

    is there any way to do the same thing from within wordpress?

    Thnaks 2 times for your plugin, and a great day. Best of lucks.

    Paul.

  7. cjharrison
    Member
    Posted 1 year ago #

    Thanks, but not my plugin ;)

    To find out which database your WordPress installation is using simple open wp-config.php, found in the home folder on your FTP, and look for the database name.

    Once you have found the name, follow the above instructions.

    Chris

  8. escribidle
    Member
    Posted 1 year ago #

    Will investigate further.

    I got to the .php page, but got nothing from it. I could paste it here, unless would imply any risk. As i told you, im a total noob.

    Thanks to the one(s) who made it, for such great work, and thanks you for great assistance.

    =)

    have a good one!

  9. montesdesigns
    Member
    Posted 1 year ago #

    is there any way to add a option for this in the admin panel so we don't have to deal with the sql query

    thanks,

    (premium supporter)

  10. shauno
    Member
    Plugin Author

    Posted 1 year ago #

    Hi montesdesigns
    Firstly, thanks for the support :) I will definitely add this into premium.

  11. montesdesigns
    Member
    Posted 1 year ago #

    HI Shaun,

    no prob and i look forward to seeing it! also are you open to other additional features or ideas with this? please see http://www.randomfg.com to see where i am using it.

    thanks,

  12. shauno
    Member
    Plugin Author

    Posted 1 year ago #

    Nice site. I'm glad you can put the plugin to good use.
    I am working on the premium plugin now, looking at adding a cool new feature. It's a biggie though, so not sure when it will get released.
    I always like to hear new ideas for features. What's on your mind?

  13. montesdesigns
    Member
    Posted 1 year ago #

    Thanks Shaun,

    the sorting options don't seem to work for me but i was thinking more like maybe a bar graph for votes something more visual would be nice.. we plan on resetting our votes maybe ever 3 months or so but a option to export statics prior to clearing would be nice.

    thanks for your consideration.

  14. shauno
    Member
    Plugin Author

    Posted 1 year ago #

    Just to let you guys know that I have just released an update to NextGEN Gallery Voting Premium. In the update, there are now buttons to delete ALL gallery and image votes.
    There are a bunch new cool feature too, so check it out on CodeCanyon :)

  15. montesdesigns
    Member
    Posted 1 year ago #

    thanks!

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.