Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 201
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 193
Total: 193

Author Topic: Remove votes on images  (Read 11460 times)

0 Members and 1 Guest are viewing this topic.

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Remove votes on images
« on: April 06, 2008, 04:08:59 pm »
Hello,

Is it possible to remove all the votes on the images in the gallery in a simple way. Not every vote one by one but all at once. == Clear all votes

thanks in advange,

Vincent Volmer



Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Remove votes on images
« Reply #1 on: April 06, 2008, 04:16:17 pm »
You could do a couple database queries to do so if you want to remove all votes/vote history. If you need that I can give you some sql queries that will do this.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #2 on: April 07, 2008, 03:16:42 am »
You could do a couple database queries to do so if you want to remove all votes/vote history. If you need that I can give you some sql queries that will do this.

Okey, thank you. I'll come back to you if I need it.

Vincent

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #3 on: April 10, 2008, 09:31:54 am »
You could do a couple database queries to do so if you want to remove all votes/vote history. If you need that I can give you some sql queries that will do this.

Okey,

Is it possible to display the 'most rated pictures' of the last month (a specific period of time?). This will keep the voting’s but we can have our monthly challenge.

Regards,
Vincent

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Remove votes on images
« Reply #4 on: April 10, 2008, 07:14:14 pm »
Is this for an ssi function? Or on the stats page or some place else?

Basically you could do like a date between statement which would get the pictures between a start date and end date.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #5 on: April 10, 2008, 11:33:54 pm »
Is this for an ssi function? Or on the stats page or some place else?

Basically you could do like a date between statement which would get the pictures between a start date and end date.
The 'date between' statement is what I mean  :D

It would be very nice if this could be implemented for the ssi function.
If this is not possible, the stats page is a good place.


Vincent

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #6 on: April 28, 2008, 02:58:09 pm »
Is this for an ssi function? Or on the stats page or some place else?

Basically you could do like a date between statement which would get the pictures between a start date and end date.
The 'date between' statement is what I mean  :D

It would be very nice if this could be implemented for the ssi function.
If this is not possible, the stats page is a good place.


Vincent

Is it possible to get the ssi function in a couple of day's? We're starting the contest on the 1st of May. So if we could have this ssi function somewhere in the beginning of May?

Thanks in advange,
Vincent Volmer

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Remove votes on images
« Reply #7 on: April 28, 2008, 07:03:09 pm »
You need a function to related the top rated pictures for a time period?
If so what kind of format do you want the data in?
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #8 on: April 29, 2008, 12:59:36 am »
You need a function to related the top rated pictures for a time period?
If so what kind of format do you want the data in?

Yes, top rated for a time period: "top rated of May" and/or if possible: "display only top 10 of May"

There are 3 possibilities to display I guess.
I prefer to have a center block like a thumbnailpages in the gallery (see option 3 below). If that isn't possible I prefer a horizontal block like option 2.

(option 1) Displayed in a vertical sideblock
[]
[]
[]
[]
[]


(option 2) horizontal block
[][][][][]


(option 3) in a center block like the thumbnailpages in the gallery
[] [] [] []
[] [] [] []
[] [] [] []
[] [] [] []


Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #9 on: May 05, 2008, 12:55:06 am »
Do you have enough information from me to prepare this future?

Regards,
Vincent

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #10 on: June 12, 2008, 11:54:04 pm »
You need a function to related the top rated pictures for a time period?
If so what kind of format do you want the data in?

Yes, top rated for a time period: "top rated of May" and/or if possible: "display only top 10 of May"

There are 3 possibilities to display I guess.
I prefer to have a center block like a thumbnailpages in the gallery (see option 3 below). If that isn't possible I prefer a horizontal block like option 2.

(option 1) Displayed in a vertical sideblock
[]
[]
[]
[]
[]


(option 2) horizontal block
[][][][][]


(option 3) in a center block like the thumbnailpages in the gallery
[] [] [] []
[] [] [] []
[] [] [] []
[] [] [] []



Can you include it in the search function of the gallery, maybe that makes it a bit easier?

or... could you (or someone else) please give me the database query so I'm going to try it myself. I really need this 'report'. => select the (last 'xx' (say 10..)) most rated pictures from the month (Jan, Febr, March, April, May etc.....).

thanks in advange,
Vincent

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Remove votes on images
« Reply #11 on: July 25, 2008, 07:14:40 pm »
This would be custom feature to be developed and would like a good 5 or 6 hours to make.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #12 on: August 02, 2008, 02:27:06 pm »
This would be custom feature to be developed and would like a good 5 or 6 hours to make.

Okey, thank you for your answer. I'll think it over....

Regards,
Vincent

Offline Vincent Volmer

  • Hero Member
  • *****
  • Posts: 519
  • SMF 2.0.17
    • View Profile
    • Digiscrap.nl
Re: Remove votes on images
« Reply #13 on: August 03, 2008, 03:04:38 am »
I'm trying to fix it by myself but I get a SQL warning:
Quote from: sql
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result

Could someone help me with ths query?

Code: [Select]
$query = "SELECT *, FROM_UNIXTIME(date, '%Y-$m-$d') FROM smf_gallery_pic
          WHERE date_str = '2008-08-__'
          ORDER BY rating DESC
          LIMIT 10";

$resultaat = mysql_query ($query);
while ($record = mysql_fetch_object($resultaat)){

echo "$record->ID_MEMBER";
etc.....

}

I'm trying to get: All images from a 'specific month', sorted by rating.

Thanks,
Vincent
« Last Edit: August 03, 2008, 03:23:04 am by Vincent Volmer »

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
4350 Views
Last post August 31, 2007, 11:48:33 am
by texterted
0 Replies
4567 Views
Last post July 25, 2008, 03:00:36 pm
by nicco
1 Replies
4660 Views
Last post February 26, 2014, 12:22:57 pm
by Jonas1975
1 Replies
1146 Views
Last post March 10, 2022, 12:59:22 pm
by SMFHacks
2 Replies
1776 Views
Last post July 12, 2022, 09:23:24 am
by mickjav

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal