[MOD] Votes saved in DB

[Stoleti]

Go to your DB (4images_XX) , there 4images_voted , and after choose "browse" , there you have a list of votes

I've put as prefix 4images, maybe you've another one...but i hope you've understand (sorry for my english)

[V@no]

MySQL query:[qcode]DELETE FROM 4images_voted WHERE user_id = XXX[/qcode]where XXX is user id.

And yes, the code above will restrict voting for the same image from same IP, it will not work for guests though.

[TIMT]

cheribibi, V@no... thanks!! 

One more questions.
Is it correct, that the dropdownlist is not activ because of the DB entry, but the voting (e.g. 5) is shown becaus of a cookie?.
When I delete the cookies, the dropdown is not activ (perfect), but the voting isn't shown anymore.

Is it possible to show the voting stored in the DB?

Thanks!!

[V@no]

I just updated cheribibi's post (hope they dont mind )
replace

Code: [Select]

  $image_rated = (isset($row['vote']))? $row['vote'] : 0 ;with:

Code: [Select]

  $rating = (isset($row['vote']))? $row['vote'] : 0 ;

[TIMT]

Hi V@no,

now the MOD is perfect for me!

Again, thanks to you an cheribibi!   

[Stoleti]

I'm using the Version A , and i would like know how make only possible see "who Voted" for Admin's ? For Another Users make show "You've No Permission" 


 

Anyone can answer me ? 

[V@no]

http://www.4homepages.de/forum/index.php?topic=6123.45

[Stoleti]

http://www.4homepages.de/forum/index.php?topic=6123.45

But how make appear a message for non-admin's " You've no permission ... "  

[Daniel]

for Admin use:

$vote = ($user_info['user_level'] == ADMIN) ? " (".$row['vote'].")" : "";

for User use:

$vote = ($user_info['user_level'] == USER) ? " (".$row['vote'].")" : "";

and for Admin and User:

???

Sorry i dont no 

[ch€ri{Bi}²]

http://www.4homepages.de/forum/index.php?topic=6123.45

But how make appear a message for non-admin's " You've no permission ... "  

try to replace this code :

Code: [Select]

while ($row = $site_db->fetch_array($result))
{
  $vote = ($user_info['user_level'] == ADMIN) ? " (".$row['vote'].")" : "";
  $voted_list .= "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;user_id=".$row['user_id'])."\">".$row['user_name']."</a>".$vote."<br />"; //member name WITH a link to their profile page
//  $voted_list .= $row['user_name'].$vote."<br />"; //member name WITHOUT a link to their profile page
}
by this one :

Code: [Select]

if ($user_info['user_level'] == ADMIN) {
  while ($row = $site_db->fetch_array($result))
  {
    $vote = $row['vote'];
    $voted_list .= "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;user_id=".$row['user_id'])."\">".$row['user_name']."</a>".$vote."<br />"; //member name WITH a link to their profile page
  //  $voted_list .= $row['user_name'].$vote."<br />"; //member name WITHOUT a link to their profile page
  }
} else {
  $voted_list .= "You have no permission!" // or anything you want
}


[TheOracle]

@cheribibi:

if ($user_info['user_level'] == ADMIN) {
  while ($row = $site_db->fetch_array($result))
  {
    $vote = $row['vote'];
    $voted_list .= "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$row[$user_table_fields['user_id']])."\">".$row[$user_table_fields['user_name']]."</a>".$vote."<br />"; //member name WITH a link to their profile page
  //  $voted_list .= $row[$user_table_fields['user_name']]. $vote."<br />"; //member name WITHOUT a link to their profile page
  }

And :

$voted_list .= "You have no permission!" // or anything you want

to :

$voted_list .= $lang['no_permission']; // or anything you want

This text has already been added as part of the core in 4images's lang/english/main.php definition file.

[ch€ri{Bi}²]

@cheribibi:

if ($user_info['user_level'] == ADMIN) {
  while ($row = $site_db->fetch_array($result))
  {
    $vote = $row['vote'];
    $voted_list .= "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;URL_USER_ID."=".$row[$user_table_fields['user_id']])."\">".$row[$user_table_fields['user_name']]."</a>".$vote."<br />"; //member name WITH a link to their profile page
  //  $voted_list .= $row[$user_table_fields['user_name']]. $vote."<br />"; //member name WITHOUT a link to their profile page
  }

@TheOracle
well, the code I post was a copy/paste of another code this the topic. please can you also correct all the other codes in this thread ? thanks !

[TheOracle]

@Daniel:

Perhaps you're looking for this :

Code: [Select]


for User use:

$vote = ($user_info['user_level'] >= USER) ? " (".$row['vote'].")" : "";



[glitzer]

 :Dworks perfect thank you very much!

[wallpapers]

I have made a plugin so you can view whitch member had voted in witch file.
My programming and my englisch are not good i know.

You can change a lot on this file. (it's a start for me  )

This is the code

Code: [Select]

<?php // PLUGIN_TITLE: voted

$nozip = 1; 
define('IN_CP', 1); 

$root_path = "./../../"; 
define('ROOT_PATH', $root_path); 
require(ROOT_PATH.'admin/admin_global.php'); 
show_admin_header(); 

function display_results() { 
  global $site_db; 
  
$sql = 'SELECT * FROM `4images_voted` LIMIT 0, 30 ';
  $result = $site_db->query($sql); 
  while($row = $site_db->fetch_array($result)){ 
    $user_id = $row["user_id"]; 
    $postcard_date = date("D d M, Y g:i a", $row["postcard_date"]); 
    $image_id = $row["image_id"];
    $image_name = $row["image_name"]; 
    $image_thumb_file = $row["image_thumb_file"]; 
    $cat_id = $row["cat_id"]; 
    $postcard_headline = $row["postcard_headline"]; 
    $postcard_message = $row["postcard_message"]; 
 
    
    $postcard_sender_name = $row["postcard_sender_name"]; 
    $postcard_sender_email = $row["postcard_sender_email"]; 
    $postcard_recipient_name = $row["vote"]; 
    $postcard_recipient_email = $row["postcard_recipient_email"]; 
    
    $cat_id = $row['cat_id'];
    $pict_id = get_media_code($row['image_media_file'], $image_id, $cat_id, $row['image_name']);
    $image_media_file = get_media_code($row['image_media_file'], $image_id, $cat_id, $row['image_name']); 
    $template = TEMPLATE_PATH; 
    
    echo " 
          
<font color=\"#000000\" size=\"1\"></td>
   </tr>
</tbody>
</table></td>
   </tr>
</tbody>
</table>
        <table border=\"1\">
                <tr>
                        <td height=\"15\" width=\"119\" align=\"center\" bgcolor=\"#E5E5E5\">
                        <p align=\"center\"><b>Gebruiker</b></td>
                        <td height=\"15\" width=\"148\" align=\"center\" bgcolor=\"#E5E5E5\"><b>
                        Cijfer</b></td>
                        <td height=\"15\" width=\"286\" align=\"center\" bgcolor=\"#E5E5E5\"><b>
                        Wallpaper</b></td>
                </tr>
                <tr>
                        <td height=\"21\" width=\"119\" align=\"center\" bgcolor=\"#F5F5F5\">
                        <font color=\"#000000\" size=\"2\" face=\"Tahoma\" >$user_id</td>
                        <td height=\"21\" width=\"148\" align=\"center\" bgcolor=\"#F5F5F5\">
                        <font face=\"Tahoma\">  <font color=\"#000000\" size=\"2\" >
                        $postcard_recipient_name</font><font size=\"2\">  </font>  <font color=\"#000000\" size=\"1\" >
                <a href=\"mailto:$postcard_recipient_email\">
                        <font color=\"#000000\" size=\"2\">$postcard_recipient_email</a></font></td>
                        <td height=\"21\" width=\"286\" align=\"center\" bgcolor=\"#F5F5F5\">
                        <font color=\"#555555\" size=\"2\" face=\"Tahoma\" >
&nbsp;(<a href=\"../../details.php?image_id=$image_id\" target=\"_blank\">ID: $image_id</a>)
&nbsp;</font></td>
                </tr>
        </table>\n";
END;  } 
} 

display_results(); 
show_admin_footer(); 
?>

Yes i change a other plugin to get this.
I enybody has a better code