[Plugin: NextGEN Gallery Voting] Script returns 3 same pictures
-
Hi there!
I’m using function wrote by shauno (showing images ordered by vote) and this function is there:
function shaunos_awsome_top_images_i_should_really_consider_donating($limit=10) { global $wpdb, $nggdb; $qry = 'SELECT pid, SUM(vote) AS total, AVG(vote) AS avg, MIN(vote) AS min, MAX(vote) AS max, COUNT(vote) AS num'; //yes, no joins for now. performance isnt an issue (i hope...) $qry .= ' FROM '.$wpdb->prefix.'nggv_votes'; $qry .= ' WHERE'; $qry .= ' pid > 0'; $qry .= ' GROUP BY pid'; $qry .= ' ORDER BY avg DESC'; $qry .= ' LIMIT 0, '.$limit; $list = $wpdb->get_results($qry); foreach ($list as $key=>$val) { $val->image = nggdb::find_image($val->pid); /* //Uncomment this amazing piece of code to see all the magical attributes provided, free of charge, by NextGEN. Radical bro. print("<pre style='font-family:verdana;font-size:13;color:#000;z-index:99999;background:#ccc;'>"); print_r($val); print("</pre>"); */ echo "<a href='"; echo $val->image->imageURL; echo "' title='"; echo $val->image->description; echo "'"; echo $val->image->thumbcode; echo "'><img title='"; echo $val->image->alttext; echo "' alt='"; echo $val->image->alttext; echo "' src='"; echo $val->image->thumbURL; echo "'"; echo $val->image->size; echo " /></a>"; } }If if call function like this
<?php shaunos_awsome_top_images_i_should_really_consider_donating ?>in the view/singlepic.php then it returns me the same pictures for three times (if i added 3 pictures earlier, for example if I add four pictures – then script will return four times same pictures). Script doesn’t return on my post single pictures. It returns me three times same pictures i the same sequence (order by avg). I want that it will return me single images, not duplicated. What’s problem with this script? I don’t use gallery. I wrote post tags responsible for show single images in my post and i want show images in normal post, not in file responsible for template.I’m also tried to copy code from function nggv_admin_top_rated_images in ngg-voting.php but it’s the same problem. In admin panel images are single, but on my post images are duplicated. I don’t understand it.
Sorry for my bad english, but i hope that is undestandable for you.
I will be grateful for your help 🙂
Best regards,
crazytapczan[ Please do not bump, it’s not permitted here. ]
The topic ‘[Plugin: NextGEN Gallery Voting] Script returns 3 same pictures’ is closed to new replies.