[MOD] Votes saved in DB

[luktur]

This mod is fantastic Thx for it.

It's working very good.

It's posiible to have data and hour of voting on photo?

http://ogk.cal.pl/details.php?image_id=684

After my nick.

[mstgokcen]

is it possible to delete my vote and re-vote? Or change the vote? But aain everyone must give vote for once not more then once

[luktur]

Hello.

How can I prevent from users that are voting from own photo?

[luener]

Thx for this Mod,
it works great on my Site.

Ralf

[alekseyn1]

guys, anyone knows how to join this MOD and this MOD http://www.4homepages.de/forum/index.php?topic=4023.0?

I run a website where people comment, but are not  very keen in setting a rating....

so I would really appreciate any help in joining of this MOD with this MOD http://www.4homepages.de/forum/index.php?topic=4023.0

but i need that MOD to let visitors post comment ONLY with voting and vote without comment


EDIT
Nevermind...

[alekseyn1]

OK guys... I solved it...

Here is what you do if you want to have a comment ONLY if your user rated an image... and the user can VOTE with no comments for the image...

1. Install this MOD 

2. in comments_form.html

add in the place where you would like this form to appear...

Code: [Select]

  <!--new rate system -->
{if rate_form}
<tr>
<td>
{rate}
</td>

<td valign="bottom">
<select name="rating" class="select" {rate_button}>
{rate_options}
</select>
<input type="hidden" name="action" value="rateimage" />
<input type="hidden" name="id" value="{image_id}" />
</td>
</tr>
   {endif rate_form}
  <!-- end of new rate system -->


3. in details.php

find:

Code: [Select]

if ($user_name == "")  {
and ADD BEFORE

Code: [Select]

//no comment without rating

//user rated before?
$image_rated_by_user = "";
    $sql = "SELECT vote
            FROM ".VOTED_TABLE."
            WHERE image_id =".$id." AND user_id =".$user_info['user_id'];
   
$row = $site_db->query_firstrow($sql);
    $image_rated_by_user = (isset($row['vote']))? 1 : 0 ;

//user is the owner of image?

$is_image_owner2 = "";
$sql2 = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email")."
        FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
        WHERE i.image_id = ".$id." AND i.image_active = 1 AND c.cat_id = i.cat_id";
$image_row2 = $site_db->query_firstrow($sql2);
$is_image_owner2 = ($user_info['user_id'] == $image_row2['user_id']) ? 1 : 0;


    if (!$is_image_owner2 && $image_rated_by_user == 0 && $rating == "--")  {
  $msg .= (($msg != "") ? "<br />" : "").$lang['rating_required'];
  $error = 1;
}

//end no comment without rating
3.1

find

Code: [Select]

update_comment_count($id, $user_info['user_id']);
and ADD AFTER

Code: [Select]

//save rating from comment form
 
  if (!$is_image_owner2 && $image_rated_by_user == 0) {
  update_image_rating($id, $rating);
  }
  //end save rating from comment form

4. in your language main.php

find

Code: [Select]

//-----------------------------------------------------
//--- Image Details -----------------------------------
//-----------------------------------------------------

and add after

Code: [Select]

$lang['rating_required'] = "You did not include the rating for this image";
this should work for you...

I can not remove one bug....

I have not removed the original rate form from below the image, so that user can vote as before and that rate form works perfectly... and shows the rating you have gived to the image....

but if you add a rating from the comments form, it gets entered into the database and the comment appears.. but the rate form does not change... thus letting the user vote again from the separate rate form...

anyways any ideas please.. I ran out of steam today trying to resolve this one...

[V@no]

Not quiet sure what exactly is the problem...it's not clear...also your tutorial is a mix of several other mods you've installed and would not work for everyone else, unfortunately.

[alekseyn1]

well... trouble is, that when the comment is posted, the rating value is transfered with POST... database updates..

but the data for the rate form (not the one listed by me, but the one modded with the modification listed in this topic to show the user vote after he voted) does not get pulled from the database correctly...

EDIT

fixed by replacing in page_header.php

line

Code: [Select]

if ($action == "rateimage" && $id) {
with line

Code: [Select]

if ($action == "rateimage" && $id || $action == "postcomment" && $id) {

[Joss]

Hey guys

I already installed the [MOD] Votes saved in DB. I use Option A. I use a table called "voted" to store the image_id, the user_id, vote, and user_IP. The problem is when I delete an image or an entire category, it's ok. 4images delete the records in the images table, but doesn't delete the record in the voted table. How can we repair this?

I agree with it. For now I've deleted more than 25000 rows from 4images_voted table via phpMyAdmin:

Code: [Select]

DELETE
FROM `4images_voted`
WHERE NOT EXISTS
( SELECT *
FROM `4images_images`
WHERE 4images_images.image_id = 4images_voted.image_id
);

DELETE
FROM `4images_voted`
WHERE NOT EXISTS
( SELECT *
FROM `4images_users`
WHERE 4images_users.user_id = 4images_voted.user_id
);
But we need a correction on core delete (image/user) function.

[luktur]

This mod is super. But is it possible that users can't see who voted on photo? Now they can only see who voted but they can't see the point's.
I want that only admin know who voted on picture.

[Joss]

I want that only admin know who voted on picture.

Open details.php, find

Code: [Select]

//--- Voted stats -------------------------------------
and before

Code: [Select]

$site_template->register_vars(array(
insert something like (change YOURNAME to your login)

if ($user_info['user_name'] !="YOURNAME") {
    $voted_list = "Image was rated";
}

[V@no]

This mod is super. But is it possible that users can't see who voted on photo? Now they can only see who voted but they can't see the point's.
I want that only admin know who voted on picture.

What mod/code are you referring to?

@Joss:
better use if ($user_info['user_level'] == ADMIN)
{
  // your code here
}

[luktur]

@Joss:
better use if ($user_info['user_level'] == ADMIN)
{
  // your code here
}

[/quote]

When a putt Your code it's not working :/ I still see nick as quest or normal user.


if ($user_info['user_name'] !="YOURNAME") {
    $voted_list = "Image was rated";
}

Code above is working but how add more admins?

[luktur]

Is this possible?:

Create new category (photo of the month). I put for example 10 photos and user vote for it. But - on gallery a have voting scale 1-10.

Is this possible to do for this category:
- only one point - user can give only 1 (in other categories all the time 1-10)
- hide for user info about voting - only admins can see it. (now user can see in bellow thumbnail)

[Artemios]

Ich benutze [MOD] Votes saved in DB in der Version B.

Erstmal ein Dank an V@no. Es funktioniert ausgezeichnet. Es gibt keine Probleme.

Nun möchte ich verhindern, dass User ihre eigenen Bilder bewerten können.

Dafür habe ich ein Mod von 2006 gefunden, dass die functions.php ändert.

User darf sein eigenes Bild nicht bewerten:
http://www.4homepages.de/forum/index.php?topic=489.msg2197#msg2197

Ich weiß nun nicht, ob sich diese beiden Mods vertragen.
Oder gibt es eine andere Möglichkeit, das [MOD] Votes saved in DB Version B, so anzupassen, dass eigene Bilder nicht bewertet werden können?


Nachtrag: ich habe es einfach ausprobiert und es klappt dann nicht mehr. Zwar können die eigenen Bilder nicht mehr bewertet werden, aber die Datenbank funktioniert nicht mehr.
Mit dem Ergebnis, dass jetzt wieder mehrfache Bewertungen aller anderen Bilder möglich sind.

Daher noch einmal die Frage, ob es eine anderes Mod gibt, dass man einsetzen könnte und das sich mit "Votes saved in DB in der Version B" verträgt?

Wäre schön, wenn sich mal jemand äußern könnte.

Gruß
Artemios