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{`֖bu4juR"$1H|ڟx:&`00=>5Fd6[m= )͡[Vkbo4f7LLִn xSׇpA>-7=5PVZEl/0EUm.RVszzkv_ 4Y҄Hx^q?t6@dԴVq b2Gm ysDLRz*q'r8]q{tȗju43IbC'Wz3BIh^şkr{g laUpRVeHBCSr?.3lM+v-,+0WiVLciթ3qկd 3rcdP4-1x&Fõ(8s/ JU -\/iG.PK4]b-rڔ\QIk(!{slw-TAPUV2 y! SMA6Qyx_:؁T R(e\YX=9hV$F~SZxu~@<0+"mi KZfSiGc,Q8-51زủC(TCHɇz'䠰K}2v :k1*sg=I﯂jԨWFOWkjT[ Tjk[jnU+ؓؓU-b6\9ty8y3b . =µ;.Y7X9s&摞U<ASg6ơT, A荶RRJћMCR,v*/7ޤ4WTZj\}UU;^`< K 2jT"jJ)7"Wfʚzmт՜rBU"%]#m~yyf`ӕPW;5tEawR-`A#JB >*ZqĻ.߉ӠFGie 4U[ЂVz 7^|MMhjcCi42EnrRUi6ok*X>|M%`L|M 70_SWɝoX꼅yyMX}}Ud_j/eȼ[ \2X7m| vZN}}˰uu뮺̺PuS6QblZ@nsA/~n2 -M*t>.[:oRƲ*-+@_4֯~8[H-~ WUni27/Bj niu̯&ASPGvɢ*kӏMV!)Okf`̯uK˛@ \B*Wϋpv-1b|s!'۸nl 蠊oW~R+ AڣV۝ZUcaʌz9hE;%XjlC/_CYuk.PkR\P<Z{]*%D@tZޕT)"]a3g>]H(,,34a\ܑ;k=bYGRCkؖ4sƜFT=sa͘^g?ɉ $QAj޾~ʅ+ H2L5 3YP]yg03eJGf M4_9L# fܯ*4h#%_#`";>ޙk_(P W ںk'<#_vgw%0 +镆Gǥb!:m4T|RO?c_2L`._ʴ#_H;. oV)M2'i%Zʿ.8WWH$YlFD4JEKeX)fRxXZ΢VP vc.}!;gPftDdvYW Wq6K`OԯiN`Џf4B'4dTdP .0CIOp {*+ NZ'ņAf'fN@feYa!M4`y).̋8Co>􂘢g$[<Mw@ɟP prc% |/BO簰"Kq5䬾|M%-9D x(I#|#3p x@6PoIx&ʘk-1@c(a? {[!3Decp%w*AB~TqS[B$bck lW˘yПP"T&aLBt0e4< >c#s vε7{9%5$cC GӞϥr9\UxT(?zp~ Pjv\~ m򦼿'@of*2[a,@e SwJ*:EJjzӇJ}`bY2Y55o]0lZz 8a ~WB0]>z)s [nH8hD) ;w((<ڊcc7(P C(9 8 RqYxonԄg$to hX(rr7E_㦞j~L:hmN$ ˥sC 79.@zMg t!Q{˚Yc"WƊ p{$H,FPS2 ʐq 6RRf0xmppK?2 T!P+*;xe/h[ ._ hOd\CsCkP٘q|Gx̒䝹LQST߃Y+?'c㠀JmhBC:죷!4gB!7}њw$̣۲*KigA8} ݼJ^Z{j:.l!K Y"4օkN00D3Ⱥ#zbb8,LtwER)> .j!6G18"!#pޏ.bs KI ZDDq8ˏ̥ M]4AfI48!8ZbHALq1 @P  \L F*{fc0ua>qƎ3O8~rdۏLQeŌ,s''<99B$51X=P2 ٠%",bk!O依GFWK,T-/].X"Vԏ0U/w |49#drȸy1qelwq)Cf('w=ٱ40(hi8 9=[$\8L,`Pk%ov$r_;; F^B7U{)(LK8#.pAM",t_(B!t5T̥5ErE~A%(1iiyQT9SH 0}XS8p= 43* @>+SK]8~ai< Nl;G'1ZaQRHb^('zط?rDne&%f'md , XJ)~NZ:]]a'Q/<^ㄥS4xR*7,/A0TXyψH7(nWWgF xRҎ+i (SlC6RSst4xEMv` LT|=StVW.9=aw {{ WN%NPc<@@9X*Y+QiggыEaQJJ@8.0zY(!(=zn+as+ 0Gn$pz-C|INauc|GH"+LaJZ{g(MU0ݣԋFW;0B AĹ =њR"`qd=o\H|ZpL`>@KL2OLI.F% I㾌 C,ȣA7;BhfyKؚ#-X2MH@)F~d+2ѥeFLAilNukzC` ƎrŒI& ϑ=AXbbH )|WFGzZJ7h* W]ҥzt%Mo.Ȅ"L05<Գ-I.r^)hM5aӧ@lEKI6T$a+q@8Oghؘl'0 %|@~r@ZxXFÒ\+Quj~c8ax0e@%5fH'\+<Gy@H\\%E~c b'au 7Rԙ—%[%1N] ĸHv%p_NZ-Zq m(C6-֤}9Ґ^XCzXA 'p oT_Fm++U^dY%^rH]q͐Ƨj=NdW5W LUo dCu}|>o:e03S~aI +'z^1b(0?fj`$t,HԢ|Y+Ȧ݄ɫh'Ţo;Z0J1 r 3 b9ky|> X]Tk#ZX㢍M^RC9>:Ǒdٝ#Fi KBV?ȋL8F mQ7ei\MVȚH{)^H/@/q83[,TVPY S'B%*8 n&?nN=z Bl(\7>3Xl40vЯpȢ+Qp杘-בM~," D)SNO>=E$/vMmd⭭% 3{sm3Ӈ}Rp!C.˦W+p} >~z?ܩ[ U=c%q\]y8ŽxdeI>,JaӺtRvYyW/LxfIvH XpJ66jƯ^I5 63`By7S̗`ב`>}FgrNt()U&Hƀ(H=taE^jq52{F) LnG` Iģ(O7?D(0bd焘}5Q>qp&i7%`+jE,' +]Z#t}qk'މx؉3JP6/9#D(`@8@9{^22c:0pQeh\ 0p8钀E" ̒Hh^7-nDE-ݫ:?QAn s BvЉ {|noº. {Eh#u#3@ng#4h[ίҕBp@2qMrEKx$ KB&A rA(TggDu #2{p- dmq)7rO5\'xx>*=6qU(ܦuuy]hd NU{.[0M/KUTO(9gq|%vxb`/ٴ wװ4'#HLaBB}k?Q@5PFvvUgva)Kmvka0%BO.%az\Կ'Q?p(ƃϸs 9?ZrK+2Ïp LrM?c+p})5U// DMNCEr@ g \r3#LcS w]KBW')C&Ymݖv w U7nXy* @n<;4/I /vm:/$kc\KBO2z¯67NL/)R͟"p\m/SMB^ x*Wf~W'}2!-fr&U擐h`ɷCvAT=<n >ч۞(tۨt`L^]D ZꬒBU N%Ȫ#2&V#05q$GwOzm3y](n"YvL }kV@I^wz{n?}^5j'ϱb,-2%nJ~(3⽖'wc`_JA0`->+g^bIf|?,}pX|=y:1L6}XT V S?Vd*8t@Ob$ڜpt4RG vKnZ ⶨ[#T RzR^mL9IF2%=а, hW֪]ȇdwpE@p KzULT]6PmɎWF3 ~÷'KEO&PyZ_z E)Xl"\3,~QJB;R[1nU塩܉ ȣۃ~UN P-V6ȣ7/=ga2>T>T< Pv(эhszhn#UTy6a6uUr.bqP  XVdI./^tb4JWWFR }qEn.76HZ,^25j\bdNm: LşEQhݬ,SbڲyӥXҏPtfѨV^5i#R /0&Lf6A؇b!O).i @Β*Dl3 -xTPݕ)類>-7.8fZ>QS^Z:b /I $A O+ʎN337Ϣ LHB~ ZEc2N80ɐu5(h2'G@i‰g)a<!&Z*Yi.D4lwF71{Xt>41ˣ#~AE%2| 4 xD+@&~bĠRLG`j1%(:wWd~~Y9 wS xN}; R0P% t6Eb /ȩG^S!O)Dc l`Cza R0TT06L(?GV J#,M/*qm>[l:wN)U$)" {W@.v5%mh~D@ K;FqN--SGSpMbq7Z⧢փ8K1n&n%\ňׇ12+XG]*vʃ<902D|TwjzEFG҂^e3`gT" *"0Ъc F V. ?P\1ѣy>P!PZ/ד6D逶!bvMى~,J(mV~/+LQ fj3{D|v$tL#`{"M6L)zJYUbj5h۝phՎjv{]]ojְPgVGZ}P YzPw1'oGAjR|[pw%?*P-&^mG!mHco)x]ٕV%7l V"48QHQt<:"~_ɍCt ~ >iH.d"cD !}C>m BQjRL>w.$]&6cTMRp5_Vl+<2#^AMt5ڱwBz#%7ss?3ղAo)c!XMXaB\"dCiO*U&q߃@N!Şn!m=!^D=G,"/]mH5l<յnҷ\+X6u}ܚʂ9m1:>U;: ?itvb6G26Dԏs7ד=7ƈ5+z;:1CxfуZ*Ij3pm=|7z=pf\HNJgY.˻cv}b]PN/$Sx쾄CBjn˛ҩx<f)PgItم4c~<k0!G,7BIȀz65(rU@V,,t7ſB.hICJ<,'N@ڔg@-nzڭd[A 4$B%QX_oױP!o\L8GHxYnG c`!A;mW6Fr=|JLO%$g8Ō8'&?/)FwS\l ž-vI01񤈓إҹ`0_0lj@@*>[l{jhlm-g4{˧(SrgqfE5) ?Ԫ /Tj@Z'OD1pFxgR4XOwxj@poU?ArxtTRmYh)fTSɧcy6&4}> &ygf.!ܬuIeOV~Q>1F8m @g])`^dS<.b]D-'14ফ3;2ZIS buvv[0-!A <oxKܐՖ60G3trq矀}fyz'#wHmeȋsSCȮ#OAe)1܏+c.RF+ 3ѧJZj8k;-j‚7zKkQ=jmXZASz`.PmՁS CǴ٠G:ՄwBwPo4\o#S6֝4^^`5;j]h^ )y@]P,P jm lFuP) nu̫!ZQ;Z/rPyM)B(eĂ`$3N`HT'I,ofaj67U 9Q*d_5y[ҍVu| Tb@Hw V'bqGf^z0XEeJ hDm^tNik8U[6&jK۪?GpZx2DžZ eFt3ѐ0@zWάF`S萔K4^h:VǂtHI'6b'[] 8r #L&?;Ygb$nxTM?#|mwEٻU?mU":lGB2ZwϓPw w w w w wjTCw w 5 wjd(7[K.rww/yM6b_ArgFG?ѧ驃XA ?h!d/F!A96:c?`WʀPƛ2; DĀLgT `CEm+A-֍h"Vy$~(괴Dy/ϜexPEh3ZaR PumJmƇg#NowɃ1d"4047+ BTOHRio,snv(ٿpfZrˤZNwkf9td]Co1'mHQJhwF s oܪrv'CAi(0ݹl^@1b_6u+}rPwᯣju7:w^8R^yGi׻A|GVڝAzDz/}$WT 4wE=!a.sQo`'R 6˜JY\I?;F̩QøO&UL'ƄLᯒHMɮp(lhҊщ@s!gx 4Ë@< VnbQ2/~x9;|4[Ktzknѭ%ĕn.I/&W^\ R{ރ/7Z)q+oM7GBNݸ۬]]F9z!Tv{\jsb|K`ƎRAI5993҂G CO\. LDw.͊Ww I<\\f's|†˔e}X}\WEkXue֋rwٵOI]R*x%K Tܻ hKx?ik)!-G~lfXOڒr7X ]_@M.7їnv>jjЌZ[MTmI  یS+xQ :_o[t*^_Ţu߿j o-MK.zq 5q^ JRo7YT_`t' tGdBw,)wϷov~՞;Q_?o+rby-N_V^٬UNSo4j Ë_ݩŸ?]-lwK;Tr/01o Tf} K*۷KEUնs[$A@S?v̋L~ZLNZ[*xje%ffE/gޙX`6.\8p-n Պ8paW?j?5;.j5eN=,JW 1#&Mۣ 9r 'm-ppgʦ.iVG1z] -Wרؕ^x@8~@˸e%C X{hB,0X>T;d@巠/Ҹnֆfs$`x7ܛZ TO_?!g8A.p{ֲ,6"7!G[$;t ı#(40 JT]!sp@d9 8Qh /;2E9& $[N[uHry*lw6WGM_Kb熪P^KrHÇ#>;US*rk.xW]ɐ@|2O3fJ![2B 'g V7ŗ@`>v Jq9`;!]Ԛaf$,)ĆiZ