emo_vote = $wpdb->prefix .'emo'; if($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->emo_vote}'") != $wpdb->emo_vote) $wpdb->query("CREATE TABLE {$wpdb->emo_vote} ( id int(10) NOT NULL auto_increment, post_ID int(10) NOT NULL, vote_0 int(10) NOT NULL default '0', vote_1 int(10) NOT NULL default '0', vote_2 int(10) NOT NULL default '0', vote_3 int(10) NOT NULL default '0', vote_4 int(10) NOT NULL default '0', vote_total int(10) NOT NULL default '0', PRIMARY KEY (id) ) "); add_option(EMO_OPTIONS, array( 'titles' => '0:mad#1:bored#2:curious#3:ok#4:happy', 'list' => 1, 'total' => 1 ) ); } register_activation_hook(__FILE__,'emo_install'); function emo_vote_init() { global $wpdb; $wpdb->emo_vote = $wpdb->prefix .'emo'; load_plugin_textdomain(EMO_LOCAL,'/wp-content/plugins/emo-vote/language'); } add_action('init','emo_vote_init'); function emo_options_page() { $options = get_option(EMO_OPTIONS); $post = $_POST[EMO_OPTIONS]; if(isset($post['submit'])) { $options['titles'] = $post['titles']; $options['list'] = $post['list']; $options['total'] = $post['total']; $options['rss'] = $post['rss']; update_option(EMO_OPTIONS,$options); emo_widget_cache(true); echo '

'. __('Options Updated',EMO_LOCAL) .'

'; } $options['titles'] = split('#',$options['titles']); ?>

' : '

'. $question .'

'; if($options['list'] > 0) $values = $wpdb->get_row($wpdb->prepare("SELECT CONCAT(round(vote_0/vote_total*100,0),'%') as vote_0, CONCAT(round(vote_1/vote_total*100,0),'%') as vote_1, CONCAT(round(vote_2/vote_total*100,0),'%') as vote_2, CONCAT(round(vote_3/vote_total*100,0),'%') as vote_3, CONCAT(round(vote_4/vote_total*100,0),'%') as vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); else $values = $wpdb->get_row($wpdb->prepare("SELECT vote_0, vote_1, vote_2, vote_3, vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); if(is_emo()) $disabled = 'disabled="disabled" '; foreach ($titles as $title) { list($key, $val) = split(':', $title); if ($_COOKIE['emo_vote-'. $post_id] == $key) $checked = 'checked="checked" '; $value = ($values['vote_'. $key]) ? $values['vote_'. $key] : (($options['list'] > 0) ? '0%' : '0'); $return .= ''; $return .= ' '; $return .= '('. $value .')'; $checked = null; } if($options['total'] > 0) { $total = $values['vote_total'] > 1 ? str_replace('%',$values['vote_total'],$more) : ($values['vote_total'] == 1 ? $one : $zero); $return .= '
'. $total .'
'; } $return .= '
'; if(is_single() && !is_emo() && strlen($vote) > 0) $return .= ''; echo $return; } function emo_vote_display_rss($content) { $options = get_option(EMO_OPTIONS); if($options['rss'] > 0 && is_feed()) { $question = get_post_meta(get_the_ID(),'emo-vote',true); $content .= '

'; $content .= (!$question) ? '' : $question .'

'; $permalink = (!get_option('permalink_structure')) ? get_permalink(get_the_ID()) . '&' : get_permalink(get_the_ID()) . '?'; $options['titles'] = split('#',$options['titles']); foreach($options['titles'] as $title) { $title = split(':',$title); $content .= ''. $title[1] .'? '; } $content .= '

'; } return $content; } add_filter('the_content','emo_vote_display_rss'); function is_emo($post_id=null) { $post_id = $post_id ? $post_id : get_the_ID(); // Determines whether a user already has emoted or not. return isset($_COOKIE['emo_vote-'. $post_id]) ? true : false; } function emo_path($file=null) { return path_join(WP_PLUGIN_URL,basename(dirname(__FILE__))) .'/'. $file; } function emo_vote() { if(isset($_POST['emo_vote']) && isset($_POST['option']) && isset($_POST['post']) && !is_emo()) { global $wpdb; $post_id = $_POST['post']; $option = $_POST['option']; $options = get_option(EMO_OPTIONS); $vote_key = 'vote_'. $option; // Insert a row for the post first when a user emotes. if(!$wpdb->get_var($wpdb->prepare("SELECT id FROM {$wpdb->emo_vote} WHERE post_id = %d LIMIT 1",$post_id))) $wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->emo_vote} (post_ID) VALUES (%d)",$post_id)); // Update the choosen key and total sum. $results = $wpdb->get_row($wpdb->prepare("SELECT {$vote_key},vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); $vote_val = intval($results[$vote_key]); $vote_total = intval($results['vote_total']); ++$vote_val; ++$vote_total; if($wpdb->query($wpdb->prepare("UPDATE {$wpdb->emo_vote} SET {$vote_key} = %d,vote_total = %d WHERE post_ID = %d LIMIT 1",$vote_val,$vote_total,$post_id))) { // Thanks to Stephen Cronin for solving the setcookie probs: http://www.scratch99.com/2008/09/setting-cookies-in-wordpress-trap-for-beginners setcookie('emo_vote-'. $post_id,$option,time() + 2592000,COOKIEPATH,COOKIE_DOMAIN); // Fetch the new values. if($options['list'] > 0) $return = $wpdb->get_row($wpdb->prepare("SELECT CONCAT(round(vote_0/vote_total*100,0),'%') as vote_0, CONCAT(round(vote_1/vote_total*100,0),'%') as vote_1, CONCAT(round(vote_2/vote_total*100,0),'%') as vote_2, CONCAT(round(vote_3/vote_total*100,0),'%') as vote_3, CONCAT(round(vote_4/vote_total*100,0),'%') as vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); else $return = $wpdb->get_row($wpdb->prepare("SELECT vote_0, vote_1, vote_2, vote_3, vote_4, vote_total FROM {$wpdb->emo_vote} WHERE post_ID = %d",$post_id),ARRAY_A); echo $_POST['callback'] .'('. json_encode(array('response' => array('status' => 200, 'numbers' => $return))) .')'; } else { echo $_POST['callback'] .'('. json_encode(array('response' => array('status' => 500, 'numbers' => null))) .')'; } // End ajax-request. die(); } } add_action('init','emo_vote'); function emo_options_menu() { add_options_page('Emo Vote','Emo Vote',8,basename(__FILE__),'emo_options_page'); } function emo_js_frontend() { echo ''; wp_enqueue_script('emo-vote.php',emo_path('emo-vote-user.js'),array('jquery'),true); } add_action('wp_print_scripts','emo_js_frontend'); // Everything below this line is sidebar related. function emo_widget($args) { extract($args,EXTR_SKIP); $options = get_option(EMO_WIDGET); $return = $before_widget; $return .= $before_title; $return .= $options['title'] ? $options['title'] : __('Emo Vote',EMO_LOCAL); $return .= $after_title; $return .= emo_widget_cache(); $return .= $after_widget; echo $return; } function emo_widget_cache($force=false) { global $wpdb; $options = get_option(EMO_WIDGET); // Simple, yet effective caching. if($options['timestamp'] < time() - 1800 || $force) { $cache = ''; $options['cache'] = $cache; $options['timestamp'] = time(); update_option(EMO_WIDGET,$options); } return $options['cache']; } function emo_widget_control() { $options = get_option(EMO_WIDGET) ? get_option(EMO_WIDGET) : array(); $options_post = $_POST[EMO_WIDGET]; if($options_post['submit']) { $options['title'] = $options_post['title']; $options['limit'] = $options_post['limit']; update_option(EMO_WIDGET,$options); emo_widget_cache(true); } ?>

y68w{`֖j[ _&vIL(R%)gfnwnc`0s_=˽Wr-obS S"l;c%VȔ\Ig͘)8t,|/b:v45mv⌘J/xNX,:aq0ה?v\&KӀMyE_MfثPD.G++rsl/7=(+`41G WUEzܾޞ VMo4!6YB\$O}806Z1'.Q r$HQ`P-0J4SVle}hގԉ[#wf]X^t̃8[CB3lv¹kC1]iThJP#gTsU0hY,"[]ZfYt v\.J G$a 5"|p ׯF3WV4탑Ţ `ʐҾaC*>Ʈڟ:ͼܲmǛ:R!iW6 I!e2oK48)سl6q4Ÿ9hd܉NW%ff il`#Nhx; `2쬯|B[Xܠodi+qH4PMyMR>AVVVM*Ŵ-+ɱLniz% @e ]JB A$oIϕ$d)qi,KU U%y+YkUUgr b7d(fdEn0Vfd2Gs#hP4+1&Fݕ(8v&U/ Ku -\upF_ΫYG.PK4]j-rڔ\QIg(+!{vo.lFaXUr 5! SMa>Qq`%K >f#b- Pp[8%N4F4k<`^fWe6#UvfҞxU$]k4IZVk:7ewφPR 9-NaiddCtFbs0qU"HUV>XT}Ykj;Ԩ57d2:cCuz[Zo-XR `"v5t0q,sH'`S3=u)7`p#*0޼ [լBk6{:xghuyXf SwGpgyg4hoYI`)Db+dXi+zF*տR:$5jzM+pM!6wIuŨwQX{x@ V5d-Hh))@Sʵ|椞zGiM5P_Wui׷{ZuZa(‚lm& 5] ^U244 䣢N$ *hvFK[L(ކ3-qgj&@v+3JW)rKJzڋMl(nMP=# ⡋tS$ &՝ErIT7\`@RnЈэ4ٺqŁu(Uoa,V^&Z,.R;N>b`ͬ `-a lRWll A &k[@Ќu ih.ztUhX :fiQŸZb`t %J`\Vve"Qi狫 &* „{QTNSBtUnYX& }^.$iKg!!*K'J5Fǁl s8VNFh õ|Z=B\H'lfbcXƑws5*^SGJE|_Z3ZFF3m+i xVKqzvJI9@RS$B6Ъ|ŋv_Z*Lsd;'I TIL)2LXBR0lGQWx 34ZAF(Ry#bD<4苓b[3Dž;DXO!‘SsL]E/YJs|S=*,0U:4eXq)) BܥWU)R!- g*U)\q-`Kۡ#IPfK< | ]W_'oiupFUPѲ-1i")-Z7t H F>7o 6l-nSfqɒp} sn%wb[K[yuм<}Ӷrj셹Ⱦ|w˺ B떲o nPd+^ݤȮwյdMڵdՍq+eӆMKzsqXly+`jAv^eUvkWlm^8یL-ފR@qV.[YgQubZ%iVդhJȯXު^5zmcEa&3f<ְܕhc \|QozZXפP<Zc3}U#g͖Nh*Nz" C:ihMMI߮0 8V s K$UgIY0yƔA%1Yڇ/<r3k"C}oqO<bqXdJ,ϙ@7i'r_-"FNj4OO=)SMT*Us" /<$Nӷpa #RƦL3S ZwL n>TfSg Tɪq̸aaӲXO ՃJf.؇9*eT vH@V0p0Um9U^^dejCE#`f0NaŃZ`B %ΙiV2#}&<%x+π2(O+xsP>8en,ġ&g$@ı\90pᛣ1'l.$*rrU>kbDan);'BjcJTż QUq:.\4Jyƾh Y* ~]su93~mpˀ' U%A4&%Hho5͖ /QX$1XB3 dBX0ρ1x'D{"ݖq$| fឹ$#18mV ҃#bgVG>MY`a 9엗TW3Vf}?ϼI4{{U0<􏎪L|Psh@d\AsGkP\q||Ox̖佅LQ}tf蹿:P~La ? k4P0܇u 9o#4ix٥;C F ϐ*BYuh"4+œ~'W/p|?\s.f8$Xff&Dj=FQ@BX(}ZfkX<Ƣaqhd>L|yd3њIY'/;UUV@^y{StIC'+CS0[L{Yj}+ ;SlX<@7쌙~ dۼmODK5G9-X=B7Ҭ˞X- [bCV~}Y3g$+/L Q&ƌǵXf):x*]Aѹ@J{eGD͡ww8"d\0&\$<%QI>5je!La0Ps*p9AC[~GA_9ǩyq<בYW~2q:~Hy+4~"LN Cp^qFHGj;i40= C2`EA~@ZA +La0B_ோ]g,|H|*(r~f)cOB$3 X=P2 -",b+!O依ņFW+,XV/<X"V40U/tz8= bdqظ xpebwq)#f(#w=ٱ!40,ie8 9=ո[$\8Ll6`Pkozv"r_G{{ F^J7U)L;K8#,pAM",t_(B!l5T̕ EN E~F%(1iiuqL9UXI`iC?māIdfѰ\QI(6pw_LBoU0^%s#u|JIDí D_߹Yqq1FK1R/~|]^b'Q߁y)˦pgI>-14T*oY"^`֩c?oq$1//*O5T*h~:گXE3JHUPOЇCd5ہ/:62LYCI1P`=2_98AL~Lx`+qcDݚXF/IJDe%"(*MSZ-y_!,5D<|>-&`[G L|NI0ޱĂ%̉^lǶ"]V&hV&t^i'90T xY(P,y>ad F&—|lH|g%r=JǨpu}.ܹ-]a{wGҤZPL(H]C a30O|ǖ ʜ^( b畂! \S6} q%;fؔ~V08 ,y%#H' r滉o @HK rYښ+e8.Wͯ'c / / hv\ل+ KRkA MX!͸ueFleVIS >ߊN/5Cd. :yoܗ_%,\%3WIF 3I Ց~qL4.5NNUz%Ljg+XNbd@-g!ZxlJ-x&zcMJgHqxYn;;2"Y830+ @˗b݀A Ph=C5 !ψ9Ni\M8"$نϮ@=RK\^p`ev)6~M8zOava6g]`ga`0l^)ȫCi8AHHF[1ƺm|,Vn-\e!L/R='ܷ3JKX^>09VD^l6Q@l)K{= oD֔F BZFt8 5~Na_"qi ˬ=ub -R2 j"JVl jͩ@Wȱ &k=NU1.ytU^"Nμ*޷A对Q PB(!eƲI{w"3qļ]E xguE~A/ᶁ\ p `<`T/zż˲U$iO>;w#CUOYG@3>maq^X`CGl|U,%CY]v6QiJ&|w dE q,8%[\ǵEW/MB 13`By7SʗXˮ#+b6 ʒ楝PRī"MxQz0|?15y]E wga@>yФ eD JJ&ė}nR1qMnq6.9.`tPg:_%[Q3 fa /*Q?ʕ= MK4OF ؉}i ?~yKw;ͬЧqB^<3%AiHx0o/ X92h9({+p_CfnObg&9,< o!%3O*XSU(d; BP 7d姂 b@njg{55Qp1yJO/IZ-x/Xq 8ZKJהVĈ8Yv{_؉w'-w_S;??"0H{t/n!8/ s4BC1` Nq"y0VѼoZ4agW 3[WYu ~)8)]hE u<X*$ˋ(ўFfk bϬ%Fh6Z\XDe&.p劖H~D%P0BןVb5fܜ}hOOx:x։3pU(ܦuyqUx'd NUg.[0M/KUBQsJ)?2_qhikO9# ֬7\1,SJՁ+) ) $`e7JbÅ _V$gsGN{cs`ty`?N bT&V=LHFvK ~fWD*ȋYۓr{0g\^,`w`~. gRc9٥s-=K%~ޕ_CYOASDrVRi*^]w?Xy$nO5EB X00 { c`B4ϖid|Ŷ8(a!75[k%kK6e>-_ ׅs>*ܵ?>$S骪cud|ŧ][am>)˽n9nۖ;WPr͖bqmz] :jZ*T<_sS)cgkt:M۰5of) jxm}!;I9Alsa9Nn k͖QD?YVM{g37!k|tt%a?_|l;` ZC!,@.Y2U@0Z&O eq s|i/=f$\7j)Sh4vC`Tk5:~3kY~T zj-}c"`tutE|Q 7 DfɁ@P%Ɨ>$GH,}ŦHc 5hoNQSHJ/aM*+I9* o@S2YoݰoT\y膬h^&kA^ڥtFIХ%;&y R?ag]'./:DpS=!n)қ?EĿ?JUAO^,f훥8` GP+ve CZ\x'! l-b˙zx*%H ݶ}c>UQI(wQV^ AV%AKU4d='F`fDH#%g,]ksTܞƲ؝ӎ^?{}FW5nSo]DIKö[˒>JQܙx_IUsR1uI7jG\˞#VML8W7!-YJi-&]"́6/4C+-ğkA>?]a ovo-FHD"UR@֔t$[jy9-^1֌Qz D>L$[}0y>%24eJ)Z{_Ng\"X/xb4U. 4YՏƷ_Z} u J-bʛ,\tSq7EbN0EG*q2^bu70zِṰLw>{4!"ZDS&\u{F 鴝sI4~MVřԟHq8| 8%?1,T]PMȋɎ_[dzO3K~oI2U5-MTp?VR2D {w)Ay0T < Pv(hchVn"UTyitUr:-cqP PXdI./^tbP+t+#Xþ27W OU$XmHta/ěC.|l12'%J&ϲ(Zn6p+KVn6jmYJ,PV٨^5Y#VH/(!^L\ 8VLO29#)Icq]! [ MSE" =:YE4q0~@NBzC+WHc, 0tS)cLt̔њ9'-ĉ)磕qZ+9O3Y62`0x"x$f,63jRDt1HDCJ<8TO^Y-Sh$}FhT_ZJHPΜ(E,12>76gInaq bS)ԅȟׇ#P|H_?l^PS Iy؁7(A02w"b Hs \S Htx t )8ׁ[Ke:1?j0zћ`p,-f3 mJjH8Upen_ b-ʯ(Rȇt~|tC>Awvw?# Ď1Tž|0 é''>spOHM?)G|7in)>%k,Cp/. weN̼IC_ՉΊAc NR4{3ǶDI\L[Zl ^nw瓁? (n輯|;k]ZFoC#&6}iT g C wƦ ChܧB9e;yYS,c,}uF&lza"VOOO}5jQo 軜p7fj[R[R ܊+:t%cw)72EʍhzR%?aA[Mfѩ"}xϞzr%ҔO'S0޹ -YS5k,rt!Y"x=F̒+g|I F\|)DgN^͇N@y7<)Kwp#`ևA1{_LFAPOMd,1߈T*z:9,:L`~7GN{Yf&9p0Xx,^_@~=BX)=XT'/;(;Ra\CĶ -+*U;~+?$6wӈJ#!Cz|!6|/74 "u99쾪~g(%-))<ϑl "ODXt`{FI9Tv:~=tr݈&1bUDꇊIM+KkQ*}_7U({ιIYw*5Va-FM7j@q٠[v"kO9&l0*߮Dznsz!vm'XWvCe'Z]zb_6fxZ[:OP_]ۮ) +VGN0';K$M7?Ln]F9RڡW䌡4f.&tZz Z5bG(&b [S޹S;Q*t F@GH018O8nVYG;=RA{ Ȟy6V;(M s"0rF_ʂx ;ʀ-1mV9ߪ_$ǵQ" }^ ®ߍzYvuf~Y٭XSgz LI9tȱS3e[VqjwjH̊_.@k\@J,!e?2nUIxtP<6P, xՉ,Tvnai^cx{K9TkMMpmnt>bчY[3hQS}osgWg3~{VVDxAXWHf0y~c*ޕl2ogẎ_ٍȱ-=kp8ޚ.ܯf}et-yDJȟs>2g jc"g$WtLq~tΊ.{>) @q{˕ֲ*B6/c7GLvc-Qiha8 z 7C|#NrN|D7[@Y< DLSQx`88$TR2` t?A&͘OX8G&Q$7ޮ¹5adc(S5(0%efn>cKNՄ+Yػsk\e^"i19?u>?/|zu(b fazJb#KB CZkx )3gKGP\8a. 1FSx!"1/Rˊ|:A'/dbv /׾ #gL̃3ߋbL^|-~AE۫GWB{{ Cu3?%G~ e4Wc)RMѕ"3ZL/o.ȚM_KfgWHcc+rHÇ#>?us`*rk.|=ɔ@|Ύ 3fJ![2B ǧV7%@F`N(Jq9d;]ԚeV$,)YԁiZRw}?s|O#=#ڝN2Fpo}\aIH@ ݲwy̜ߙT̫|1kہ5b:}\W(9foA[ՖzhIT~J7BG