freedumbo

oh..you’re right.
i delete cacahe.. haha thank you..
for ($x = 0; $x <= 100000; $x++) {
$wpdb->delete( ‘wp_options’, array( ‘option_name’ => ‘_transient_yasr_visitor_votes_$x’ ) );
}

sometimes..i find screen display “security check” in my web..and find this source in your file.
if ( ! wp_verify_nonce( $nonce_visitor, ‘yasr_nonce_insert_visitor_rating’ ) ) {
die( ‘Security check’ );
}

what does this work?? may i delete this??

i understand first question…wp_log_votes..
why you combine it??
I want to know..and i’ll update it..

second question…
I can’t solve it..

***i want to delete table totally..**
although i delete you table, votes_number and rating is remain.. -_-

for me..if i can change two part, it’s good. but i can’t controll it. so i’ll delete table totally and rebuild your tables….
1. review_type varchar(10) -> varchar(30)
2. update review type anywhere…

i’m not handy with programming..haha
1. at first i want to change your review_type varchar(10) -> varchar(30)
im using bitnami..and i can’t access phpmyadmin..sorry…so can’t change it.

2. i have a idea using your review_type to others.
when new votes occur, It work well..

$new_row_result=$wpdb->replace (
YASR_VOTES_TABLE,
array (
‘post_id’ => $post_id,
‘number_of_votes’ => $number_of_votes,
‘sum_votes’ => $rating,
‘review_type’ => $tag or etc..
),
array (‘%d’, “%d” ,”%s”, “%s”)
);
good.

but, below is wrong.
$row_exists_result=$wpdb->update(
YASR_VOTES_TABLE,
array (
‘number_of_votes’ => $number_of_votes,
‘sum_votes’ => $user_votes_sum
),
array (
‘post_id’ => $post_id,
‘review_type’ => $tags
),
array(‘%d’, ‘%s’ ),
array( ‘%d’,’%s’)
);

so, i want to delete your plugin and data totally.
or change your two part

Hello, What function make this prevent??
if you tell me, i’ll fix it by myself.

I’ve done it…thank you..^^

Oh..i understand..
If you don’t mind, can you tell me the fuction to delete post-vote db??
by using user id and post id

like this..
function delete_vote_user(){
}

Please..
if so, i’ll customizing it.

Oh, sorry
I mean i want to give a fuction that logged user can cancel their rating by rating “0”.
As i know, the rating’a range is 1,2,3,4,5,6,7,8,9,10 or /2, not “0”
Do you think is that function will be possible??
If so, I’ll make it by myself.

Hello
I fix it some days ago..
I have one question more..
is it possible user delete rating what they rate??
give 0 directly or delete button for some post

I’ve done..Thank you ^^

I’ve done..Thank you

Hi
I review your yasr-shortcode-function.php
I think your source have all db table I want.
In fact, I can’t use workbench, so can’t approach more.
Anyway I want to get rating by user id individually
I hope you write some wpdb code if you have time. T.T

EX)
————————————————————————————
$query_result_most_rated = $wpdb->get_results(“SELECT””);
by post id, by user id, -> get rating score.
————————————————————————————
If you give me source code like above, I’ll write query source by myself. T.T

not upper setence ….in “a” tag!!!!

Or would you tell me how to add class in <a>user-class"></a> tag??

[Moderator Note: Please post code & markup between backticks or use the code button. Your posted code may now have been damaged by the forum’s parser.]

Oh. thanks…
I have a question more..
Is it possible thumbnail do not show until my scroll as other lazyload for image??

Sorry, It work for user id who like a post.
I mean post id….In page which psot get favorited..