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{`֖b[ _n&N]/%BTIGl?Dcw66 0>Ӄ_Kh#+72e?Ȕ,NXdI,2ն{քN~"ܩcGcf'΀HDrHsMyCe4ДQ4 h2i~0 EN&,(3Ez6j՞a&PҏNIi[e}? mO3ՙX#N V0bRe7ӊm `Ȣx7eRPe ?+)[nϊjM3"*AM\BRMy V`6{syXuePw!? )$zIR޾)9!O*W8|EתzڛI~=x/Q<U.TbVr];*^{TkȤq s  eZWC+ UH㩎\` {u!-9G 7p i(pnZN$U>B MV= : twߏ.T5 Ͻ-Z%]0b5<[s,'VPZ0ۉN,-ke ۶9eOV[$VUt2( @իٷ jKћUAV0F޾BGY5` pΒJwg(9zǰN"ӹKZ]i .C gQ{Y>T\2IC0F3G(3[t1}[AMVQKnT_s[[H;cv[ 8Ŭ *AlH:mvjV:SM`oVgR[_MZj+lˮAw83߾ܘMCkh1]ylY͖oE `mձ7VC ǖ}ckj {0!8hØ|vFJBUQZnWoNzKƳQL!.& bCkP(儗9$(Th %E)K]64RoЉt)25L밼qZ}B3lv©kC1]iTh JP< #gTsUݡ0h9_Dpih"<5]$B\HtGjLEu@I[ \gNh#E%ޘ!]uU|A= ];vlyeێ7,S?tHZ}ҮG0}ETwIh64qRjg{"^'۩qs,awAȸ9=:KF :@0UGv`2쬫W|D[Xܠodvi+qH6Pԇ˦ )s݊]K+K +&bچXZu&\~R=Oݐ 2R.$! 7$RBIa4 *EMٲʒlkeUgrW o2ȖQ^5i [FB|WrG~8p0|sAѬPPPWV**U%rr@ |9/g؟C-CtYiSӳr;rE%Y ndBnЖoD450xwf2 UPP4@qP/OjJa % JB)#1}FZ1b'q8 R֪ i:x? Xm;(ifM DIVՒtnf'Tcˎ "3 )"e>;9&]퓑1B^E^NU U YJzoT]uzֻRR_d 5Mt7+`Jޜ ؕU-c p:fH?0SNa#\m[b8 p V ``8 βf͕&}Ƞx XE}eV0% pp wGzVAv ͷ1 ,T`I KMEh7J[zYBT^Z<{ӊ<\Q9F jR}U1mEU^0%ckFJJ<Ыr-"xe)h&9'RM]QNsq⯪VĿ`D];u|:O0alVcgx,Y` qZQLH'uvJk-M%ο vQmB P__;LxmdX55AYzuހʁKUil<@Ye&]7&v:( IjToNm`g*n``jf.GI ) W^5hFf5lX;:IA0Kz/ 'P[E'Q]EYfV}b0 ΁a lRWVl F :+5V@4ЌU -i 64jtUhX :fi1ߋqi)jT Jח4ҚYWkM<)UV 2̃ JK];MsVL# 8@,h* 0Ǻ4zt! O[8 )1OeiWz@+1XaX:AKAגi q!q 5I`G޵aԨ8Rr/]aaԂk^Έ۶mM8[WXiG/ĉ!aJ$|=M9"_񢵝ė !ӜPl$xa)@S - V# vQT'b>VP(e [#8XT^\ݑbD<4苓bZDž;DX\#i<$)u_&=6$FQj.5Ǣ<_W|.2/]Z)|U"% p6R2˅ǼC!bRfGO_+qW7ĕ*7[Xv}QTƆ-1[6"85ERh)E;Wj)xw5"_iHT|M%mo&KnS%mjo,nU d:C:MXݾu/"Md o.n|wʶ`LA-epsvn"nUגY7jגU7n2U,Mk(z.wMaHڤMx6UUoI^1~=vl="ZLz+: 1 v:eoP_jąo329O똷&ESPG~VQԵaH ӚekE Ec8o;1Ƴ"s;혛bcƢmr}:q :bʓEe` |vWVjQ1Ƣ0W3l3h7m,5ϔXc(n@;uzM?e7/}UN#g͖Nh,Nz" C:iuMHgWpt!ԝ+%*> 3$ۊ,׷8^'8E,@%Lh \̛N+P YBoʧŞ,TzRܽ Jg̀pѩR⪬ Ȼ8!y p{+]\)hR й/|5"sڜ/SL>@á8*{[Gs+˒oP\s;o%yO.e$tv '9ulRwVaRL闯pЄrܻ"w":1e˶OWNnY{6O|)X8ٟELV^rK&E3OM@&}dʿ^@ߛ́yS\/(>ԁX#Ƕ>v}l# ^g~HSMO0zӑ)CS|*+#@!]ƀ Q́fk}iU_&m$K3dLh?ã+^]I)Y  ɶ_z[[8VԖY ""bG' $ޏS?Jy`渫8oϥnEB99Ϭoʩ"9N E[FO-7$\4"fh ӛnqmm% <!@_^IK< RQY:x5o^܄g$to1pX(r7E_&Rj~L\:{.hmF$L˥3 79*CzO B"w!.5&}EIiB ,t;6DeEld! a+ڊ~dB5wyYU\0;w _ xP[Dc^νK|{ֹ6I L-;qBD$*cP:s`9)HD|q u}dkig.I磈,bsL?N⥆ (Y@FxSV+eXB奣-$UOŠ߬G07=gQbef:G=& g>ZO Ľ;īe$̔'`@)ԯ@U„o#sցE<0z`+7 Cpde`+f 3*Lub8 jݰ3fV)|X\yێ˟*)%G9X=B7Ҭ˞Z- [bCV~}Yg +/L Q&ƌ׷ݮXf):x*]Aѹ@J{eGD͡ww8"d\0&\ <=%SQI>5ji!La0Ps*p)AC[~GA_9DZyq<בYU~2q:~Hy+4~"LN Cp^qGH]ty xD.頬D" яbBp=L2@QЀa$@)} &S h#b~)z9&02#@ 0 =`b( ,G] Al2#aAð_#l.!y&fa<-D4@Gf6 A33E%HJ=5Uh<-3(CP8y{Ĵ *QDh/'1Sr7D+%}FY ,?Jʓ3%4r4 HLJ#%,SX@ +1R@*#2xDTN䃄AU /Z>D|8^X6fWA3\;8?<Hq=AYy$-+,x128ʵ\_ce"LJ_Ad|9#J2Pr3#tEDeRLv%Ɍܷ 3~{SCĊz#Pᥓ@#YƇQ,:`ҡu7/?Nb^àL0:8.e Eo$0;V70 pu'?{Ku 0rxmZ7 j MnZDhgG0K9| Lq-eO#3JB>+/POt7`ͥ&Q< Nb;'1ZAU2Hbt_D('Dط?rDne&%f'md , DJ)4svyDſxcM|Zbi|KTߨDS#=#ëb t4;Ib.^^i1sY8*O"u_$Nf@"`ʠ^cG{(j§|_Pulzer 2 c{d`r*q*-z RNƖ_5M;$^,JDP"ZVQ[yP'Ϣy0b1Łޣ6BrI s`k @ ׁ?bp2'`k D ZzJq7:Ƨ~/"?0L4+^X ,t/Tղwz(DS!$W'ZSP$C=̠+R&v"#SD*djӲfSKbD`lSDm=&+'c| 0CP(8YnR219&z LS3'PJxۊbtYsSX!:0yZ觅P%idB}TԮeSmQ-^2C9>:Gd6ٝcFi KBfV?GȋM8F mQ67eio\DWMVȚ2B֟?탨W}?'/\l}`wʂeV:)5OIx%v+f6sjͩAWȱ &k=NU1.yte^"Nμ*޷^对Q PB(!e²Iϻhqļ]6҃^mѩ3٩x>)_8!y_ e•Q4>p?}wG-8g./}C|d9}T,fu1KDe *^߅+"$-Ƒlrm_|9& Abf&,or~/'+Xˮ#+6Β慝PRī"MxQz0|?5y*IpTa颂Q XKZ7N)P?X;wxqSC0+Ht/-ƨSP\0[]엒t(Oȁqwfiʇ#XvBa➆&݅}'l-ľ4_RDHNq3+il37Ll` q;kD"E1c%@+=G&M|N9 eq yMIL;`$wYAKӽ'TZ/\bynd&N+{f-0BxUrOHT&nWh $AIȄL6$Z\.*L>dd\n.p6L-7/HF5xx2aɳNkBq6ˋƆC|=![w:wقizw]C ]G <+اhǿ~ɡm|?A ` F@[gbXFW@1QT R,I4nĆ ]>9?' K>ə_yLi/_(y~l ./gc:`p d-nA_ibӑ?̈́ddz._^z`#y\NA?` ϲ~f}(oOΊ8 rxQ93?Ka.ldk] /xW~ e‡J%^SDrVR+^^w[y$nOp`!zS,\\e 1vI!e6_Iݐho?߭Ս32^I s|U ,yjk} #Ht!ӧY]៷2t<)zjkԘ|{ )Wl/^-_-P*ޯ )o1Bav}01"k"ߚ:)] %VSTT<&EN\,\қWs:$Vڍ\}| w&nB  0K°!_Ϸ٢wL?RKӵCX0U&w}#ɡfW a+!c?1|Y-& <.=/jzKIWhJit T1'MY>XC+p>U'_"C  ׾ďLO8;"pP$4}GGXJi0$R$0'mo*I_8KX8ŦHC 6hﾻ OQShJ/`MJ۾-H9* @S27nXy* @̦ zBHn)9͟bp:Y.p]lbyپY+/ʍ`B^!i sa6DwK.unncSA=AL`stTE)F]]r $zY2W 609@VѐJΎ#9L$[}Z3jy:%24eJiz8ZE|hㅦX4g0gOŒݭ8.#?c#ߺzU=i-(HE+o4sD Dl~~4:"@V,/~F~ggx?l8=-=vekfјΆ.kN9!=GTZIgR ;RǬ~ThPu1W@e*TW2s ߒ(`e˕<Cs&G= 3;pj(NM`aΌVΪi&RHg~jCWu.Wʽ"gE/́ehAE_XJttAua_\`ˆ2i$p/}.|Vl12'7 &Ϣ(Znh+KVnjmYR,ҏPtVѨLW^5Y#Vj/(!t W^}~<{̦|w-Xx)$0T[5"H";*L`yq tE`}C$ JF,rX/PEixAhg7Ϥig+YL]s^`(3'l RMuGqtR1@DB8'J(Aѹ'燘E{7հɸOIB4(e}s,/+ *  X:#8 ”@#cx&|8 HHH2.g`HJd[lB & /GYS!Ž)Dc 䬧&p4” q y#cIyR\TD1(-746+FPo$:%sړ,{ʦ^%⬰"B-?; .x^z"CzH`g rϱ~>SSvo k7 G z~ @5u-c+ !Q9%|GhqCZoyw ~ INP;vK}WJ,1%.5x`/]턴Im7Y.?;;EJXoj|+NBߠO ȗB$aςim@#xC>xnFfMTChb[!Ŏ0<^pl.Wqcm.6 @cS-h[HIp)uJﻶ,."43/0q#\T4̛etOQKC{L*z'i5M7jቐP{o i 6O S)-<帡=(hv;OwofKM([a{FlpfҟrN|otqSNb3bw1bj9EAJme}DJ:^SF]jZRVm[7&̔զ6:0̋GS 4gqa9C&i51P5]S*kPoZ?v-  @)h5 d\:jMhIM9v pv'uցeu^o@pQ|kU@&4$XPjmIWwX࿨ d5:5ӨXq7u@c}51*V°WSʷ팁?*a0ܨ)7¥I䇁({rnu Ft={AX #˕:.CJS>Id=,\/5s+פ<eӅiq߉)1K q : "N7ZV6'.q\:O}#YCE񲯥% >1e oLhTQ@*w[-ܙ% o;ɀNF^ۦ]R5~߽2LŖfܮ&C2SFLOJ-w=w_Rm^w$I5X{_:OP_]ۮC6b:p?9-X@ngt ߪrf'C Bi(͐z^̵jH7XVaC\war[waN9u]Z}:g)AG1R,%@gNHkR?kR0FKQTO(G@cHSnv" _K~<&..:WR#ӳ2v _+s/+ؚ`;ٟu!})0]W|hxa<3o˚Ǣ>@}IZ3#Gx)rߥA#ŵKArﲏ_({T 0D%.:`½RҲq9KlET7R`Rdbl_r}zfZGMQVS8QtL<`mƩn<~TR :_o[t*^_Ţu߿j ׻|rw%)4 |qڎdԕUdBM;^{:xcQ.I~UH܉Ÿ?]ykv7^kIʝFmjǍF2iziU;WP:Suja[ܡ]Q(_[q r~òTbP?oK?DCǯoBv p:/0YJNZ 4UttjEFflE/g D^c&[.<`/n|vZvcTiTȲd5*gbbFN ܙ2rrN^֯7NᾔMYQӨ51+b*|@:[.fq'm𺆬+q˸e%3 X{m|Y`D׃N&?L|J{ś!_sgjk}77P}:ݺ9+.8ش|`>1Jo(zGYS_g'fSm!xWq/K<5?:~far7Py+Z8sҵ(4z.nX˜ lt`[|4]1l&{v w?sOYڴwXeg);A`>"[^(. D XLPY(,Py8 Q8$B+nx7+iSy@R@wqqlId &^$^YzM0oƟrqmMb/Ho.]gMSkĎ %QjgQ%Q(aJR!w;]JhOrnb˭p qzE(2WN9aa+PAbGl Vi& MD)K,~%HiQ#%̔ f.]9qᄹk,`_W-+ܽ! l1>\y(_)G<1n?If|ԝo./(O{%m,]e  !\mI>ה<_H7ɂGW`h25 !ytCMjȬp'Mcn Aͩ3bX}*8C/AR'-݆:9<7\i. Ǹ`8Q3K%md<$ŘLh0'NFhps"Ea劣E,Jf5?0x孭v _#ux 85˶BWNŖK3J ǃ1YOWG 344Y?N’^U}XZU;N/J@ʿK{]KǛ΢K~{%m1"-Fo@ӗ//ҳٙe%R|xߨ(`q:a&dUܚ„ _UO2%0YŒYeV/HM $X.psJA\Np&s2 KJt:v`kc<,cDž1ҩ C9Sk̙&7aC,@͸&$L(cq q0MݫTH\@|\ڌpr槈HRHU@ VEouic ̸Z5@d3T[jWa_ϖ (Elt?E0xF4[jղQtÒFSeԷș8_T}ueIM;E̦̚v` N_WJo;C01ih)ݪ!M'RnL[q I