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

}y6߁a(ɗojz)PGlHI}w[$0 ?;þ4_?ƿkycSf@Dfw"KN d):|migM):l, }/b9v41mv F/xNX-aq0הg?r\&KLyElkPD.}kÉnmK6@z&S0~>Li}85gj6 Z=9^# '9` ]f͜PRIr#xV.f0k6s9 p|Bj6Hk{eXusPM!?) }|cByq/7`ï +( |?Դ*~زZ-{ԯ״`<Rc˩4j0(  - 5:M۶9eOKk&RvW57l+h!́e,LTco,)&R`RPa b9Kj HBߍq􌝶=s\֢1 @tc/ 6.qg>H* ON'6\]z?00`WF1ET+W:6@2e/m q+%5GuP OU݅;Q`Lq8-Nn@hUXߐgmYV-ņa{iՑe YBе10EJ#6bhz- q0RLA-%eUЫb %%j?LE65;WߑOTFnbHRP\nl9 &LuQ،X_^;ՔGÉJ/Rc01i''JhԯpJ۝0f`G?0|0OUm23-w77TZW$J2NfvJ5D 2א*R!)09|]1ԊΨZp&FiZ{l'EP]ӓBIfw P X]{IuƦto6w`Oi%0Ё=Z0I, a@N^ff1Gmڪ7YUù1'7oiܩkV5=E"§N55EyXfSo3 CH"hНmLCs!4* AcS5[jHRnU$z*pA!n[JoֶjtZKkFh jFDx`(FD2>HXXsZORskKnj.G9ζ*~FtUcgcYCw3+3 UXOVՅ9Q3T=H<C$ vTl}dv4 *n[Kl.q0LڭMhfzr.^V|&h4ȉcWn EnrRKl,v~]0YwvP;MP8HUM%JRYۨ@/7@0e53lH ŵ$1F;7 u^*FIvq*p3@6jz/ YE_b`, '`-a lR WlZ!ͭ ]1o`b z{tm[ dkgEq`A7x :҂Jr/&mfВ6FVEn]i̲J],u8xR򏢦@|&uS.;M%v Љ  [0@'/RKIRbiWzB&+1XZaX-9AiÉ5 |V=B\J'liflXΑw  eZ/)]##إUL-Q`ሸkʨnR\aQ.]ā!0K.ezHoxNOKCsiNxJsFMe Č|+ Ä.E,æ=TUIp2IskCibouj"Qe>V|] K9.%e3=^8iF7_UHIaC4.(Rn(;T++̗zWCG8Ҡ̊xR \"WOʲU5+b/1IDXj)RZ E*01|wwdepJk`_Mܥkv'+^Yݩ[註wM4םE&M[Yݽe/2]t-n|w +[`NE-wewpuvnnU7Yuu*juӒe+]ys9XITx[м7ie]_UwЪe;Q(/pީytu&˜ߡ"ą#nN:杪TQ\S=ETuzda- fYy0cy^Z޼B^Jvp\[c3$ۊ,ky/1e,K' y)LUZrP[vX"YsfIکܓydIy'>c)_ ܽKIo|?Yf@c{tꪡ\^+*|Rhc^ZDHA =0XzhEe9m'ē_!bq}~ ^GQS}ͣRruMtn!Ɋij^.:䯇=x:g5dR:ʭU[KʩrBҿ*mu݇NMٲSF[VMSV01D0{S h.)$K1؋4Gc.?q]Y}G0~Ųx߇:klh5~gM#*ߟy t3Dg sAPD>ޒ L%*^xdg\Ȁ)T?Zk ?1 `AǮy2T*՗ɛh5qwN(|RǤ|Ij򗟱/ï~F>SqX7yJ5,3)xVE>~u%^LTF`D$(Z* `Iѵ%0Z΢C+_z@˸qX:@ al4HIgghgC`nT{Ӹ&!Џf4B7X$Mz*H]< P|I b=tJ(L0-^ gq@ɈzYlVTAnKUi Vւ#9ᄶfĔ<#qhyCO.j|+Q{1a:Q$3T9\WFsj< 3S 0gV3C>DdG$?[!Ù y9<P郒|}'aX)Z5/X[{$Ǔw312#@~bzrFR4|o(>g#+vA;ȟˬ!]e/6Fs@ >#ʏ>DǍB}-);n`w?6SW??La* 2@٪^;NFbY*S}(fg+d8fҰstia,(&、IeQ asny)p(E'9S a_X_SU%N E{FO.l #f Ӌ]78ǔ bErWW8f7G::VY%MxNJV@+2(OV' 92GO6mP `sa&@DYnpYqd?ӅDUY# \Vt᳦}SnUpH,$ y9:#Er:.]4Fjqd_̷V40⮹љWV6lIP{ :[zͲK|օ>M L=;uBT$*@L:s`S9fnK3q\iY;xNwA#bgVGI}<Ǜ [%_]9\RK}RVf?g8u+: cr56>]q 1֠qb]x̖X} ()N߃Q?g2yPσ& $}9g]*3ī|Sm\9Ggm%!)6QEmJ)ag Z L]>#Rp )Gc̊]xڔp Zn2h=b;0÷ȯQH4 ‹=Zw; Ȃ>K㗡o{qӁ_ĴMPh%? 1 p)(LM)fk lO-B n~ܶ q$X9Oȫ)% | c H ̟!UhԥbEhV\+œ~+'(O̟6 Z35ѧ-hRZ8 0t#Px0ruYڙ3u h؋Q4s3q_ dھh'd@iɭLWm*e}. x`hWdu`S"q'euL }r&g&E};ל_0r{(|W>\A-sKLVb 1Bp#L:@Q @ELa0D_ோ]ǘzd^dU ( =`b8 ,GʮՈë+CHY0>u~V%t0<ښ6&LІW7a#8(`j}f^0# ~+QC^5;q̳2Z<4čHL2112(_ fjB,{V 7Qh0a<9syBs!GOA#ĤDu3$e*K ZY J j-dHI ACR^ \L+&SЏ$.aOr.3d<6Tב$J^YdY228B_2?97P"9WR8;zdZŠ-",bkObrC*,`?n)ʥCCĊ#PKgd=Ɍdqĸ xp=x2;!S2T忓;XV42 Kx%i50;0 a4۴8n?i ?Yݴܷa !9\BFJρ3F 0nYfY _094`>J5Lcn07Ζ9+yyJ\QbD%^RS}QT=SH$0}ZR8p=<V3* }:w+&NY)wD +ݫvNOBp9\1z"_#ۗ'Q[|QqS62O1RꯍS6`|7`q)~VLK sCTFQgfыEQUJDu% |+cC]~PGe01Á?]6BrI+s 5vPuOg d-R%pHNatf`|GH"+LaJ[Zzg!LA)QxLӋNW'4 L \hM)G$H:;{|j2xѫx4#A"&R%S ʚLY.E%*M,㾌2C,ȣA7;\hFuKԚ#K-X2M͂J@-%~b+2u!FPLaclukzC` ǎzՒi&PȞ0j0GDdF⒞8懽(=ᔆcp.dlim?GҤV3?"s %<[j`R3zKW j$ZE8*BB⒄"/)a_P? #dl6:ngHsD]H&dE+LtrmO4Њ+lhCph&ϹCCrdn zw ҍjˁ¨mJhq*ۋ, RQt}9>3 hOG=UU1R!|da$#Pyl߄7`2B_XdJ6+9F \ٌϬ B`OWW&̀(ju )}Y+TQ:ގK9)C ZYR8kDC@k\T5uL KD܀AP?4A:aAICGH>17Mj!DD_/kM>H,#ϵ4Rn;.O)[5I{ s 9"zقavʰ>Gx" ygq@{!!KjT~v\\+pCN#^~C9N'ܵ|0J%,Ho\bzg09V=p@ۢln^߹&՛r5R_?//i8+W[,RVp`4NEjnASq^݊MAiY'ܜz 9p$X[tb wЀ1_࢑QDIp-׉~+,V* T )SOO>}Eqnqĸ]e+xmmC~A/ᶁX p @OKB:D|+l~U9N}HPsְp }DZ-,=K 0,sH:ƏQR8Tq_'<-g`+꛴za|0H_DJSpghX+C̳P }/'X˯#a<FcrNt()U&Hƀ(h=氿 /: .,[Tqw6 MQF&kH|~M۸ 4p"DzuK8bgLEp|t _"N 5> ~ݙڕ%XvBa➆&ݹ}l)ľ4_ZFXNq3+ib37Lm`0u;kD*U1qBz5^ &WΉ059RW `ѿ4/ r0ω< o)%7NXSU)d;BT 71b@n_uH(슚B|ʨ<+pIɧ$▼WtZK%JׄVDλnĻV;GĝO (Ҟ(gޫ[F^ՁQO5倁[08-Nke,`3"ygZ,am7 3[W]u_6$]hE u<X*%fˋ^$Ӎi bϬ%Fh6O))}~f(8 \%<҄ r٠hq"F3%ř.&Q]s=^P2ɶX߼cg7Z܁'xx>jx֩3pULMZhd NU~-xץfjvO_˂} ϧ.d9 y/ !  `%a҇|`)bB [LL.U\޿z=>7ۛgfG:FV|nnt> 1ć,S?R*~8`JޫlxyE'5FP?L.s $,968}AP$5WO% i0&v *)VCԸ@CAPU`+KMZ}D&)9Bs9j=y[g]a;Ktى;1 LO>y;O;Ot;Ϸ76w tJ|1nˍ[s+pu} ~t0 Rc /eVI=O#J?oߚ~;~I5VR V S?%K̴E,0ܤ _ur 1@.1J8'w_/`eW<\yWiwVHD2UԻR)WdLo񖘕 n[MhʇdkO=:N[2R2ūʾoN~ rh\ⵝp}_[i(Y0gjٟw:߬&-HV08h (bw3Û 0&Ɉ*%]4+&tzYs䝄u)o80JS:3BǁҟtXOiRu+ܽI N@sAɈ̊铏RUes*4xe<(MO.ƎTãйOiKFyyĮ6MPfT"v77UpU?[& |O?t,W"(˿'Er4r30 TWqA,yPPT͇9i zhT6nZFx6 :A?bqPXB$&`vCzʵ(Y'76u$v$/ˊy|l`CJyA83-e4<ʒS-W&ZxA} {<9[{ h[?*  |4HzjR0Wj~Ȼ DтuIn=p[$QYۛ/?o͗7_ou\:j' 91#y~q׀"pcLzSifZ#_Vǖ5:7H7>AKO20J*kdb*JKyF>,{.LzΙO]4!da0Μ TnQJB h5' g:CkD"<*P(f&-S.Aa$ul &ON=v!'7T P0)cjO4q@'a}+tkB$C?zwJN-0fR]kC rj:]gM \߅"9)H2.^ mu6ϥYUVtR񔗖ݜ Ǘ} j )W\e;gɥ̕2SEk3U}ku&.m^񋣂G@iYT0PZbs~ǔ&FyRq/(D& є$mYJB*@ J ]ؙ"ԑ$L(U,1r!6gn]uM>խ 5eѰY\VeE3p ӜT7%z<32BW9 42i)u^sDi@JBqA9CSD=AϦ(_:K*P =(zlX?`P G#HG+3 }MGg.BWK @fK@a o7bbb8ҔRd wŞR Q x= H kpU.z}|Vj6iEX㉑ @G[R햱: w紻1vqF-8xژ/xs~myw^C!UBM>J=ZdFTXFW "BmՑ  TaHIyz eAqkjx:DB]iE^lh[-чh4h [&&u$W-NYݴDðԖ+Lr+=}+ V9QÇJiȢxwnrŒ{s7&lRT -T`Ƈ+ O4劙B:mw )61SsZ"$aa&>Ӳ %)8 ע\ d{OZivM)0UT2ϛ?fgGnI8qu;`-YRG(l' IxVeu&\g)X?@3|{3pnIG4,YJDI4^ I[k8/軯͹EKu=Z|hhC:uoWJ#3O5 5S' ,UXE Ү8ULGzkT'hz/fud~5ec٦4wiwm$nswLM݄ NvVp0pB $ "䰪cC,eeF&$ߒ]MX*{8HOڨ=P QYX&FY[1Fo;wP4.U5{ t'ij?F/j I|(!hvcO;,O~#E6{GPS`x/6iibk=ñ̺M=3BaY֟3MlNۗ'-;FwcgGu#3-w5*ɍTrQge.ſQ)Bj ,zrHqE婞|. OQv3xKTQ뒲 ]%sYe@sgb_4\ܨ\Lw?ްQN7X֋s]inn,wgֿ'yVo|:3r*cg"M9fcqS?eUVq^hUKW1bB;ޟͯa/ҮI}^My@U8͑븺wW&7,RWԕg֫gt릹KW4s7­ky77, 7ѭ1/w35m`[̻{P-|Ċ/Wե-v-ha,wK7GTR ҋCW9+TK#`\wnOuy|]t?Guxg,tp!e.PB6'!^&Л'. H'ha0 Qfb ?O'`NrTNi>Ы^9<Q^^z\2ԅ:wuKVU'YI p szEJrE%n[p#{сg#Y I<ÏkP x u[l%!dNK K⾕.%~;mĢD] VrON>!ܻ! l } P#Z=?Bb摌qG#ZrD^~r}:G^p跎@_3gX^RF|-a*$ _2ax0+8Kd}":" ''tP7B͙3 <Ҥ]gI%HeP',G“$p޽,ߓdƉqG]Y#wY./SNW*⵽Vڌ5B67YW\讥+~m9DŽ/(WW2xC45CQ7Z}$g鄺Z >$r`h,cLx1Y֥.B&aIɒ& S`Al8}\(Z<k0-1șGZ4J^<GXށqLH,P /e;Y˂I(KkO *W}YOTa`EKU-ct) zFlnmZ[[V#aM0%ݲYLoLj93ECOQ &A1mg}&&bmJFocSMƧgBD