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); } ?>

{{F8w<1I|B8e'iu^JIL(R%)_b/^EJsnc3  >z~(yJ Myڧ#e1,?E-'5f|Dywȴٹg9cZط\fuR\Sq,60QMN>O nBl=HF)4t4bc@/WN=s,GcRs֐ias: c0`Q^Pe ?.-7bgEоj<&[{ /.d!\lXO1Ƞ.!10,\ϒFWٱAF&fM#_ o,԰?,gZ? ݇q -9*'Tx8^ mh4&fO~B٧oU>\Us^`Wy;Gך@W^ـ[Va {Tj`Գ0rn /l't};BgDmbchnb~Ϫ5TV*( @3ngKč-lKJ4 0F[9=?t6Ӱ1c%$`Nqt=qLV1 @4ӱ\AM 6O|T G6 L]:?00`WF2ET+՗-;6@2hW/NVBj1+HjП6 vc 7wZdkL 2L]ѷڬ}{i zFVϰ,WZֶm ={ w;i` ,f?lnY[FcPY; {mm{(PȲL{޴䐏ۋNl- f;8i8$i\16'Jt:m&DbS0+Rc1"o67b8N@)\2)Tp$HQ`#vi  5u).DY`| w1p"9‰gϿ#gE`poallB 63@}{Kj&@͍8P*.5jOï+4F3mcּ a鲪I?}D Pm;w%#S1f↘hczx4y ƿ ö cǘoY[G&D͖.h$A:d!nHgWPLC:>qCÊa,aiO~L"ɶ" hjL$&K Y `^C@-w0SA֕i2+%E1-yIv.wd2*bat6 \H\<_B\gZM1wc4:BPL=:uUSg 섬ZءWh)RxJF?6gx4d1,O(jX~vZ(XWnnj)Cq=Y1M$ |YO@ĵ UJ]GNUrkq9~Wf(4~wԔCTq$o>DtnʖmCMo0mݲl쟳b)Y,ٳ7500HfM&LȔxDs4?F3וwt{}\/տ(ԁX#ve[VAӬ;k ȏQ z8c+"YfggN^ٙqQj/se#RL#Sh!;BVTEȀT_1o|hⒷ20Pߙä|I|lPyr:;8 e@Alm-( f2:`4$4`+'秵j#: WV/?c_Y7LZ; ThIS%h@jInDHd\d9yMv bt:%&ɿTpGϳ8 x}ad(* D%ʴ+jQQ ~bf?#oy}Oʮj|+Q{1 " }"p"^P-<t:fgB!h}%!VTOHx-Ʒ0CfÉ ~9<P邒|s'aT)Z5/X[{$Ǔw3S%;FAeRFq(hN:P}E 윙?y3&5"YCC*G^m|E|)@|*G|Nk9 [(isvZއ6c#W??jLa( 2@٪^O;NFbYȃS](Qf#g*d8fܰsrŰia,'、Gqe asny!p(E'9S a_X_SeN E{FOU.l #f ӛnq% <donp̤%oH)tro"܏LӋ8V eQt[xsP>l,ĥ¬M/I\qɻ־?ӅDUX \Vt&}]UpH$$ y:#Es:]4jqd_C+sY{t _qMCuA++~M2I$Ľ -r%}>> J&Gh;*XX & 99oO$YFA?xﺿ=5̵t3$iDZ9ߎ޿'x]-y&YaR`a 977>P)+~3o'r}`:5.]1)뗦֠9u/>?ye,j-S9,:v8sFu^ ?$j}dBC:$yvf:+!N T82趕 D) G6<=h:Q.0uNJUP1+vic61hghHuDG9τ5?E"0 o,֒ԉAX ExۻOCL4V20CA Z|J ͐ ,,AkĔoFf0?&xܢ+͎6!+Rb9 Y5!=d,3mvQZ͊")Wq@ ]p}9yv pM``5AL}ق(ꁣ cO7#L 5 kZyj.:S`0 hdp&dsX[;9L:;¸#UtWYʣMݻT/% ^ʟLy\$nu|XVszlZ꯬4aX df'u7X\Oo`j XwԳ[ѳXQ (t6zclr]\nBP;Eh+;}Y}mb21ftt]td0KyE;p&:7hi)L@Q3Ȱ9N%;Lc2~?J%KR͋HʨqaUHyTy0{ÙS-L0 m o=GL}IPd uubO{YtqOvL-}r&c&E}73N/9=+.PqH4CسH.0$;Pl0HkS) cu1_O+l@0*v $'T 9&H5sCVU) Na/ ?fY[Hj&~P &" ojȫf':y6[fPד#qvi"T&&FQӽ L N35}Y ,?Lʓ3%4rt ԲHLJYG03KYBVPRPk!S FǥzPN*r.z cqCh`X@ 7pB,sz[$\8Ll6`Pozv"ru@@C js< 3am 0nYfY z/霿|QBj0)7kK\E%(1/i [N}~s{d^=u~>-R8#3JBq~q+cVH]8~GQz{qIH> u\54Fuzk}$q+w(7+=h#|N-Z 8kfΗ;G,|Zb|KL0%<>ff^=k8GMc旨BLj!/_lT^G^s; äL`#2_98@UL~ y]` jqcn]/,$%J@8Uߓa8`8cUD-zk}5lny䒖ԋ @ہ&C׾?`p2'@HD!8>ZMi!Ȯ0k)n ka❅0ir>hF7x')M/:_hT0EHrUz58"` :AF6ӂcĎ\d]bHL+>-k0 -G<_*6E&c2: K  Ob?"OsS).%k,`45s*(F h:A1!9~I U)F;!TKcH"@_"{¨Q rKzVjdS]H[ `Jdb"L05<wlIN .v^)h5a@6"Ƶd줛I`S҄aɫI at' %ƻo @hKeo,mL7UÛ(+گ1F6aT!!vIBse` /ោ2܌KQg _@bk}Jb39u"A. n$R"ݕ#:9YjЧokh6h8L[\[B!b!f92n7=CH5qa6E%8EU(:2TM's]냎n*J0 TpbO;&8cqX D888AΫJC8qi2aAxӵpU-N^A7%璘>Nk%oۼSHA>MJgHux ӵ>P X#pܾ|(0U&(?\' >(I ? P:q 4$∐%}͡fD0=\K\^5pbev6~K8zOava6g]`g]0[0Ng**}t0RRJLӲ-^2ki>Mv磘Q -aAz;<[̀ϡ쉼؄mesSz`_5A4oDFkBZA(W=$ᰯ\mH[AɂeV:5OI83²O9rlCI|t#@ϡcB*E##N%41Zfwnn~-V* T )cMO>}E +vMmd⵵Úƃ^mхӇى<`(=tbWep}/=O;pf#@Pq͍c[X{kna.Xt̝fq6;>8MTyZVԷI„.\a! ha7 >d%q-|w?1V3(4g~ _NV?]GVi/ m %s;ѡWE&"@|jlx|$`tQAY(O4)CQ #e BƏn/.2`Ky/`1%e5 e5~8/Wbu {rti ~ywC;ͬЧqB<35AHxTxtā 9(V{LN1'J!Q >I<_|,`w3 p 08ݫybMUȓ%6& B1Г՟*nb|(}H!!+j 5k(bc%%^8[_pjU,Gs+]#Zq>&N[Ŀ^w??"УH{=t;x \9>U^nY8\Ҁ,敞i҄0$.,8JDo^t}USEq)Ric{ǛhE u<X*$ˋ^Ӎi bϬ%Fh6O))]~f(8ɦ \%<҄52٠hq$F %,&Q]=s=^P2X߼Cc47܂'xx<Z*&ܦus=St69§Sթe 5uOt%:' k>ɩ@}Tio_|dJ77S 08YPC_bӑֿȄddv%x`#y$ ' iϬi=yrAt/0;`0?3dvn\O 06 v!V5Cw]y$nO䀚b!ʺS,3Ll?aoulR?l$+E7HJwCn 7v䌯wɦ+I|pPw,1q/OaɔeTՙź8Ouy+,OF< "||Ύnlﴙѓg7+LfK8jval-jZ*4_+S)cgk}+cDrDR5q au ۉ>}|# f5׃^D.}-0,})u2N)mϠI蠆8?% GF=y@P%3s9„Yl4`vLUTzkU{{u)G%!|*sx冕D.RQr]ѼL*̓dHvϥגXC<[@猞(2=N x'8|N$:L#Rr?t~Z⧾þNJc\\ x%UNr6<򃼢&9|Mdka>N!(4mN}`RR+1j XR77K !HE\Q#Z*%ڦY.yJ"u!FIOS5鞬ح3Vfz\.b]vLcmSFYbk`sE˗6{ɔ$%cF6)斻?a HT%H_ˬzvA!#cG|߂5+6w61jz$AD5')+,47JZiX`I)d@2M_]bqO枱e7Î?ˮx fZVӝ+ȻERjL9I%Rˁ)e%-6+zl *={Lk5/[Md(KHehʔ"*u;KUEGaq 8 sflZqy7/s j-⸬GZ0'Jqݥ&L%7<}4`JIkA@1͚F#:xN:l턷JsOk%)_F}!@;Z,yRlzZHx:RSCw`⹠xtfɏtG,SDJvR&'uãЙOiKFYyĮ6MPf4Tbogo~֧n:P=V~߱\ȣHw/?arDϘPR^M@I@AQ66g.\QYFh$8x^04BѢs`Y ˒ \3Rw A*ֺؗf~THڒNdf/+WY,bd *%Jϼ*Lt+KLeXKg\YDq%9 *dQ[5m.()ڏkW$*ܓ~Og}?PT"? ]ϫI\#.CPG ^N+8 bt Bo{ |g6?ˈ]Qլየ|s-HhP"ߔw h-!/Glp]k؎]7VKO29}ǯ)6IGq]!Y M U"m~ooksr{Ed}4F Cti'Whc, =>U4t1Gqy|"`[ 4rJaRo  *SvO#yPLD8e8.!}KئcK0@(~tu+9LnI?¼Q" O; %zc~pa2!ZB@ #ݤS`fc]JC,B*e%˻ȩ@tYBOʻsE2Rz mzC }y_J@+wb1/-]!?w3>u\[<8; 'd:.2Z37z88&2[~E9[p`Ruݻ*ict<Jc|  52B[w.x?MTSJ<8T^Y-#hG*QQ!NoqV3k%/]"ԑd;QB =Ybe|nlܻ }"E.%U6R ui3@ures?Y4C?7IUY!(ZsࣱNKb %>R P% l6EQodӺ,Cg@LL9rSciCO8laJ Jln^dkl?>>qV_ِ&>89uHHH8DQd wHNfSЮ^yǗ\L=$E eZXDw[-fѤEp\QMxEȈ!P:5f3 GFNN'I/f唓Zh5-vʙ.Dxܛ]SSiF^K!CUk|<:<"bԿX FW "/Bm{!8 rd@ZYiM= G*E+&H l$EHG0?41ӄ% 1poɈJ-8QǶ\”Y[eŠ m3cmgg +ݥq "ݹy!n\:=q4P5d.>+I/+:]łiֈſk,gG\" "pq%.ΣDd$?1P#oy1jͥ$i`U5I$='F7DkaQzVn[d\nL%pWH~X4, :ow qKٸL' &b/eE$H%dYY.DAsmZ 8EcWk< PJ"5Sa~H5{:LЉ@{%}dXlУq* +D`;-a=g~U:f}ao ;l-KۺLn4.?NkV cYZSγ( -yP4ǁ ˳}?el"8~]ã% >o͍-} pM-F\ ;[-IZ'N_F׮ #Vd뜸"BqMsHȩnrkf}w5i܆N\6·j6ۗFk.ķtv;ht<emVl0 CS~@=4^Ɓ2,@}Mέqe_Sqʕ܃t&.Zc~H=O1{$P.-d'슥Ջ̎WJ,Rj|ZRk`Z+$[a*V1Xjhpbp:oaOXES|"K!qnSL}[vhAۼQ&ң[Y vڭFpA 0pB j1U}bQH/+'4F!*~7M}`dNt"=R*Wi ŢO^lыw-57)rQ;(nwi5{ tAo5j}iǕtm[W֟}Y֟V6{lV{GZxO ]/X)e]?geY;766[36w67Vc E;*~ǧU"C%Wo)Rh]I?=YCpno(=Nハҳϖ]&9?J/poꗳ$* ;pAf9E]KfB --^lTQ5ke(royV{.lhX"ˮLvYc?p{2~ty/V!fԥ{T`ENmr '}ǞowNUYQkxPsQ.UKTbVň%p4H<{5u ]WaJ#^2_|S]^W/WҮn\l\ݷMްҾ Df+^GƤz&͛+o1rVeG6I˅G2J(]߳W6fڵ+*Ҝ[{Y/JQRE'WKox]]`S-YqJrA]wSK}^|M{WRZB9,d &vJ =y~ t `yvb5!PY,)]8GzyK\>U!*\˖sKó@޷RӪlp%^i2nHo(8uq}yMpdTc*%-mM' Ba>d«s[/'R=G4?%DeS.! k]B*wNe1#=UbN\`6>(:rޫ|:ː2Pn@N|*/){3NoeOg` dW(r3k{4Ã:Kub]kÿPs̥tŏ4ji| :ylFQ;ah3Ob-aJF>ݲI䌝oL 9EҒcOӉX(u{c!|d!MR~ o