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[ _&ۤIݮ! E$壶 Sa;vw66 0@o|3i{%&<2%2ƿ3Yhj!Lծ{֌N~"ܩcGSf'ΈHDr>KsMyce4 ؔQ4d6h~0 ENGބskĤǮlAh)A H9+aoxGmn(MZ;TgfM:ZJ "E.on6,6ˬj#V()[nϊi3"jA\BRMi'~[9cvw!(V]TMCxfpKJF|3I^llo~)=!O*8|M5z:XIži 2QE䫡; U<㩎g( {w!-9G i(p~^$վ} "޽2!Bva/6?0< UMsolAAǪ`Ea_7 FC ˉTV`2v"@7+T$@4ms˞As#?WwFCkE6FSѻUP|f]{hZkC Png#`9C?t:Go03%U$`.PZaϝEsWѵ Ұ\RK..F 6},"d6:a0\g2I`g:袘[€ACQKnU_s`[[H`v[ 8Ŭ @lH&mQ:_sM`Nod͎R媚Z#;N3Uؖ]gp10}91bݱ=ߊQٍvgao4V/N-ƴ7^xGhC>sl/7=(+`41G XUEzܾޞ VMo4!6Y B\$O}806Z1'.Q r$HQ`P-0J4SVle}hގԉ]wfbX^t̃8[CB3lv¹kC1]iThlJP#gTsU0hY,"[]ZfYt v\.J G$a 5"|p ׯF3WV4탑Ţ `ʐҾaC*>Ʈڟ:ͼܲmǛ:R!iW6 I!y2oK48)سl6q4Ÿ9hd܉NW%ff ild#Nhx; `2쬯B[Xܠodi+qH2PoMyMR>AVVVM*Ŵ-+ɱLniz% @e ]JB A$oIϕ$d)qi,KU U%y+YkUUgr b7d(fdEn0Vfd2GrhP4+1&F͕(8v&U/ Ku -\upFϫYG.PK4]j-rڔ\QIg( !{Fwo.lFaXUr 5! SMa>QaFa%K >f#b- Pp[8%N4F4k<`^fWe6#UvfҞxU$]k4IZVk:7ewφPR 9-NaiddC tFbs0qU"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狫 &* „{QTNSBtUfYX& }^.$iKg!!*K&J5Fǁl s8VNFh õ|Z=B\H'lfbcXƑws5*^SGJE|[Z3ZFF3m+i xTKqzvJI9@RS$B6Ъ|ŋv_Z*Lsʷd;'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>7o6l-nSfqɒp} sn%w`[K[yuм<}Ӷrj셹Ⱦ|w˺ B떲o nPd+^ݤȮwյdMڵdՍq+eӆMKzsqXly+`jAv^eUvKWlm^8یL-ފR@qV.[YgQebZ%iVդhJȯXު^5zmcEa&3zj]67P{(nöw;KZG^؍<қy`ҩM_JYdH' =Ib!>0wÊa.aQ#ɶ" 5Q=՘2$&K0'Zc"\ws_Wd-;΁WB,N,P93Z8D˼e2Txq'>ƟWJj_DN׋|3 Yf@e諫J⪪ 9!+~Vh=vU.L)) !йM/|5"9m'/L]V3$ h3,V ֪ߔFWj~Iz |كO@ܵF JCr;vrJ9_A*8oۏ;}Ĕ-~v5ru 8Š1ePw){=bPmG++? ̳z#F)ޟAkĞ-+ik3ͩn΂)zHsdwS>>v}b ]OSMO0zӑ)cSh ;TV&T7@)T%R#-~ &.y.?MH~6 ϞꙇGWx $,"SB(36vvq"yxLSX<1M38JQe؈N@ӏؗg W2mj0Pn>#{%q@_SIr̸$I[ < K4Nx:I6@RYVI])$12Cx VR/} q]j̀4xJR9pD2;嬧D8s q`WW4H0s_l,Mr"Hԝ#kMt $ b=P$SA-^~ T^33_jE !򲪰rK]C4;gE)6*y(Gb4-* 1HxYވ?s8&GJ^ ? Qi5eWxcy}ZJP[sd%L#IzPfrA 1 (FfCS$u u4l4x1]9L1W&bH*02C}}!0CO .JC*HW2}.I}Ac&9W19`CɎQP ~bZyU9kxp)[ s|-ٯ̚XR8 ՟.mWR=ħrDfC(`"T;/ vh?=z0gW):*dXTa4,0eւ+>>TfSg Tɪq̸aaӲXO OՃJf.؇9* @(:``N9#r )!|艱ՆFaz ׍31! 4Ê0"K3i qҬd UbMxJBVC+ eQ\WK}q̷Y CρC|MHcraf*09H{=z}k UMq_kEq@}p# )Q2tFUep+G3CJd)88g(w]^-$Tј #4[.GGA`kc`Q~ ~p't@D1c<?؛M@THt[=]ׇ&{7e [%_^:RR]Y(HXQ<&tU?:^<3AY᳣q MAGs^}~=Y2[c0EY@1%8@U„o"sցT:x8ǎ̵6QEmJ(iM+!fT.0uFD'%*AS X 3vt#gbx}EibZP)3έ%y-T~w4V20CA Z\fHCkUĔoFf:p``5GL}قT ] Gƞnf*@BPR4 ^;u.a6 +F$g3̓$wvּ$u¸q[|^e9Gw>E<0zh+24 Cp=˷ded+R[f8,Tޚ'q~ag̬cm%s%n;~~ Zo9q-mQ,(yf]r]\nBEhsϚ9#Yyab21f4"2l#p0DC&G1'x%iT(qUHyT+a8,9S)1Nr;z>N͋+9̺ {8c~GG}Gt_ arZ0$oS3@0Br?ߕO'PH%H!QYN#I( ; :eȔ_d m]/%@:;F|D6 \`;a &'T 9%娺oA4"Zr$,cV:zM;-grqfgB+Std&Oh+ɛ0C1>3H/PDXAs;;!F{8OA)߃;@L2EH/|3%C,}Rr7Qh0`<9sYB3!GOA%ĤD:YM2>aq%F He1VpBx`|P YˇߟφK*kfΏ`*b).3f<6*/#Q}dU}oESG+63K,PS|w"!_Ma]me] y ,640&Ō_azzA숀1Tx,Hapk$thMKSk>0(K15CQ1̎ aI-3\@ mƭfg&a245f-ͷ?Z#-|Ӄ:S0 84RA:OafJ߁_ue 0nYfYUX`sE id|ՠGG`n(rZ(5*qE1xNKMˍǗUgʩ2TOOi#eO"3JB!+/POt7`R2Txqb/XwpCU2Hb_D('DطqDHr;7+.?h#xi8&RJ=p{М%vkl wO[ @F%<>f)^=K8MsTÈ!OQy%qZ4쑍T}8<Mv;:@Q> c+x5 N`a-!STD@΄ (0`nʸr7Jԭi)%`bDTV"Ѫ>ߒa^}qqnW{[װKZ /^i E^nC?>^Th8$R0;VI1>M#$x&pͿ0%Ӭxa-L&烪B҃PUaxDEX|M+L \hM)GC uwj2xW0>-8&0 MEF%TZѧe4@ [٦ڤ{L@Z a!a쇠Pi)4q:¥dcsbM%,fN$bc?2MD#2At`6:ߵOK=ɁJ0bG9by $gȞ00GDdD#=+q̷Qz8Fpel{=&bJdB~uEJy;TWT|BY;Ԉ yf3` 6=E+I7$a+I@8OxXl 0M%|P~r@ZdX\)Quj~e8cxe0 ~a@5&\)<E@H]\%~X b{au 7Rԙ—[%1N],B)7 qJS,p[w*h6h8L[ϹCCr2n79鮨dcr0j[U!"*|-: j&:,q_@p@Th_%~B*p8H'1TG['1ѸSC88g8a jW#~O B`ǓɀZB:O_xٔ[$}MTǮy_ܷy)'UV}*г5.OwveDWqg`Vۗ/ź^'{!j:BŸs(|ӸqDH }͡]z佥.+|@Sln q l00;0{5l0;a؀#RW͇8qڍLbu?9*X[!3C^~zOoy?fT r}-4`fsR؄mesSz`_%At5(d)ō"셴D}q\ Aj>sE * YA{Zd;w#CUOYG@3>maq^X`Cl|U,%CY]v6QiJ&|w dE q,8%[\ǵEW/^B 13`By7SʗXˮ#+b6 Β楝PRī"MxQz0|15y]E wga@>yФ eD JJ&ė}nR1aMnq6.9.`tPg:_%[Q3 fa /*Q?ʕ;= MK4OF ؉}i ?~yKw;ͬЧqB^<3%AiHx0cP 4UŜSp8jX/!37'1E }sNDO*yDY(zSM}1 7Co=H튚Ag|(< pIɧ$t]%tikJ+]bD,/nĻ;/)b̝ R=P7 | 9~ZQ{!`0p'8Ɋy< Hh^7-^+DG-ݫ:UQAnL"qщ |nH`º B {Ehcu#3@ng#4xW-UBp@2qMrEKx$ ?TLd@PO d1BFVg[xAb}BnNn܀'x'C<]V<ęX*nӺjl<pz-x֥T_(9gq|%vWb`ݯ8 wߴ'vCHLaBB}kV?Q@PFUg~a lvka0Ͳ%B׆?/ +} Q3#Z a|HTB0\h`x c0O' h1kB+ܞWi&$#??3" "kgևܞ_>AVXFO5@=9g4ۍQ; *SR,:`ܬ}hR|mvM~K>j7GVYIN`,2<ΠgPYpO9 d6޾yĨ&ѰvgeY=Ah܄wn η(/IcqC~oE/~`œ-k 9<`Mq1]F8T€A\<,dx'M? rՋ{_vUO`'5Q 5c|%r@}`aQ-gDΉ$սU%4r)Q@$_ |#f"-٠qJ;EMa*5ͪޮ'$N|kuJ.RQr+ymy!k}l$C>J//Hz~M$> ǿt >,}MkoWnW|+V?yY^otJÃr#2B!1i s!.DWK0OwS/g᩠ &0tN`b7tTE%E=[r$zY2ǗT <6/9@V}ҐJޞ#9kNq[x{jջ (joqYH);= ~4.cB*1o_q= V H1`ٳĒ˳Cj՜ru4%K)ʹ40ݤw]9☦(|E9}m~6㏸?^qn⭷e5݈|PJz[HyؚrdzK/gۋ9šQ7`o@DG?'TL)E֩3UE3]ꗥ[?A< 3&qKnAE@|DLYy7x 0f HLЉ f[E8N_,^32<6ig`#D2ԄYhJ.~(!sBB{Y#O0JR>;s:TpgPܛ˰{"?ÚE3:!コ 0xfɏ[wRY3*TӖYJQY.;%(_gnR%QYeĮ:6 [Ս"4XqtP\-P $Q9+y$ex WhIeMQȫYקMxZliݠqf\S,Zc_%::xۙxqC-L zn%#! `Lp@7NjCVepޮ5Y,dڃT&_1l͘llX)յ?v |1O/3efK q"q !ieܷr#8:Ce𼤍   M'r hdp9/,+œWhwwA {I_QCZ!78;3 %ǖB8,3'J(Aѹ'C̢ύYҽjd'h¥F u,5!W:=O2ViXZǚ!8JuGcֵq&|8 HH2n>B'ȷM6) #C\gCR` -LIPQ0ۺ2Y[-h+{ڈ%4;W u:~=״uɝ"S$쯫HReA!)[؉lV9վ1, @z7szvoeYB=mb#R?)%Y:Iq+hr!F90=IźJ[V. Ρ̅q1x-Po%:F{s:,{T߬=qVXQavCeW #C`y޹\3vBGc)ۘ!XfaBR"tjԫ&qqDN!%W" &xeш 1p"r$7QVpިa5&9Ԗp̓H84iw%p bV\߶EGm/ 4\x F?ƼYӕVK4`&-si &.-|v'sE;uBm"M ) Op dIV$(7Ǡ; 51[s'9`XP&-JrbH:"qFҐ2;u8%p"~p=h -vY$xJ< 9>\(da[tx4}[«+%K ()Vs/\[:PA^ŋ8p>[e׋ͳiy!gc `'Nm/S'ux#hQgP!kW/<208}FhF:s=r2Wn}jas4ipIǟ~{paAZ)Q9y_ivn׺ކ2=Mx+m ӨNB3@iN F }SyB1u120]'&\/LvڠOz^7 j>LYmKjKjc|8?rBy(oހNZvl4*kQt[z%=I/ֺnk::4Y4Zvnz.96A4HzOr%UZ ia !]Oץ·%M $x1(f\ԁvT(ӆ`6yde%8J,[`JwڭD0Xf`&m{TWZ-iߔz3at`kdue^9Q;Z;U i_ M?QAvSCkfju !:mC[Юw5=ih 5R5P:tZlF?w @)h dzjmhIC݆,z_ŠtLI hGӇj $ F]'ci $̬"Sx{M퉟 i.&at~oHAhXVfT[0zwj?OmmVz[k5Pƒ5֌ڻ=I %%i Bn -Ͷ֨2ZZD 9lGձ uPT.Bs 5DNia7"Bl#ӞN@C UgДMR-gZ| 递hԻ].AvSoh7o+6;MTԠA)u#nBP^stAd[π -`p#@Ŋ{=J-ph H^s%D$eH6@Pjб@TFfthJ nܝ͓Is>iO'jTm ] H!߶3VT\]rX(Vܐ'XFup˹kLp~ӇoiǏ,WX)Mq2撅x8.]Nq,aOהa6c, \sxqS6쐨ȉLݚ_g$>C2EEEEٟ'V=V=V=V=V=_J/-k-k,km+x37ިDEpl'Zw{{ۅݿ"9_#>GL F\|*#[F$dPl)yW_=Ɂa#`(⇵Aw3Љ_LFIP83Q1t"*b$ؙHTz+N:1gщh#Dt5 )[4f: 25GV~L H7<GU|H}%N0eny|mE? #p48s6Ĭxo 4NĮ\o/VG %ݺA+73ظ|;`>.JʏzGYc_gx fS!xWu/K<9?:~f7b#rPZzkZpҵ(4#~.X[˜-l1t`_|8_1u6q:+_9,m:2[^( D XLPY(,~?q  0@p# %|rR>m!Je~%.S4xX 5iƼbę=f5: Iv έ ;';6{DQFn_DD))+5vkr&\Ō[,QN|ZV):!C@شc |4}|\Ȟ!P>Px `gVc]Lo./(ۏ*^U>ʐ2Cn19|$o(y3Noe4 < di&C=1x@ ZD4!UL8>!Sg.\9(II<׫d{(J