troOn_vegan

Here’s my code working for me, feel free to use it or upgrade it :

global $wpdb;

$sql = "SELECT *
	FROM {$wpdb->prefix}comments c
	JOIN {$wpdb->prefix}commentmeta m 
	  ON c.comment_ID = m.comment_id
	WHERE
	  c.comment_post_ID = {$post->ID}
	  AND m.meta_key = 'wpdiscuz_votes'
	GROUP BY m.meta_key
	ORDER BY m.meta_value DESC
	LIMIT 1";

$rows = $wpdb->get_results( $sql );

if( !empty($rows)):
	foreach($rows as $row):
		$comment = get_comment($row->comment_ID);?>
	
		<div class="comment">
			<div class="comment_meta">
				<span class="author"><?php echo $comment->comment_author;?> - </span>
				<span class="date"><?php echo get_comment_date( 'd M Y - G:i', $comment->comment_ID);?></span>
			</div>
			<div class="content"><?php echo $comment->comment_content;?></div>
		</div>
	<?php endforeach;
endif;?>

• This reply was modified 6 years ago by troOn_vegan.

ok thanks, I go to do it by myself and I’ll share it here.

ok when I’ve finished with the translation I contact you, see you ??

Hello,

I’m fixing the french language right now, tell me how to send it to you please, I’m not familiar with these forums too ??

Another thing I’ve forgotten yesterday which would be very useful : set more than one signatures goal, as Avaaz do for example.

Checking IP addresses would prevent fraud, from users using a lot of email addresses on the very same computer, but of course it would be a problem if several people at the same place with the same IP want to sign the same petition.

Best regards

Hi, I’m just testing your plugin, it is great, simple & efficient at the same time.

As I see you’re working on it, just a simple list of problems, corrections and suggestions, in no special order :

– in the database, there’s a “custom message” field, but it seems We can’t find it nowhere in the backoffice, it would be useful.
– you could propose a verification by IP or Email address (as it is now)
– great to chose the message for petition shared on twitter, same thing for Facebook would be nice.
– Could be very useful We can import signatures from any csv file (I’m doing it through the db, it’s easy, but surely not so easy for everybody). For my example, I start this petition on another plugin, but this one showed itself too limited, that’s why I go to yours, but meanwhile lot of people have signed the first one ??
– More than just one custom field would be very appreciated, with possibility to chose between text or textarea inputs (and why not radio, checkboxes).
– The “Petition message” field should be optionnal. Because the form could be integrated in a post where this text is already written.
– The french translation for the prepopulated fields is sometimes funny ?? Especially for the email message, if you want help on this I’ll do.

I stop for now, I hope it would be useful to you and thanks again for your great plugin !

Hi, I just checked this new version. It’s really great, simpler and no bug found for now.

I used to use the wp_socializer function. It doesn’t exist anymore, but I need less than before, because your plugin allows more things than before. But this function is really usefull when We need to place buttons exactly where We need or for a template which doesn’t call for the_content() (it could happen when a website uses lot of custom fields).

Second thing I regret is that it seems not possible anymore to chose language on the facebook button, so I got my buttons in English on a website which is not. It was an useful setting on previous versions.

By the way, for what I’ve tested today, this 3.0 version sounds very great, good job and thank you ??