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

}k{8y?lj5l9ͮӦeiΦ٬lѶZYK~Zg}'3i$A';þ4&_?ky#Sf@Dfw"K d):|migM):l, |/b9v46mv F/xNX,aq0ה?t\&K MyEӰl&ӑkPD.y矲IRH+چѓl 'M'Q(|hbk1m0lN׵{$5wr4>,qB5C#̚:>'F,]Lgt:+r|ą,$ՔmVI/ 90@B?%)}|c.CyI/7o+( |?Դ*tnZ=kZ0wv[mc˩4j0(  , 56 MmIJ'z%ĵZUikF[uP|cfF2[hukks!`zQa b&9Kj HBߍqt=u\֢1u@tc/ ֏.q>H* NƑ6 \]c3K#X3yTKW:6@2h/ q+%5GuP OTՁklM: 2:}gm zCoCVjl}GvyghYkK}h[v øo0}95bpc4 ȟ̚mon[k}C ǖ}kZ5c`[k[fgp4i4`^-8n Q fEq>u 6@dwTôz K'z 9 ,U}#}cFR<e(5nx;NDgc'bZ8g5}L4!q[}bf 5S׺b֩ јuA,'5#gP Mݡε0hY."4[]YfYtv\!ZaӘ|rA3\TZѸ F ޘ!]D> ];vlyeێ7,S?thJ4͝]fȨKm̆&NF-lOt:^d; c1i=.L=2D+mR{ @ld`#Jhx; w0mv5ZsMXl V7.]`cJQ?|!41)r>C*ܴ"hWmei^eܴRL[bUr++/% Sf-J) "yI"P~èQXL\Ҵ XW2z:ZW4i,j#P{.Pk/ж\mJMc&bW}:+=$U ".p u̐~aS{ܲj8 paY5qQyFfX="~}S'ۃ< <,3)im pyg4v`6TJԄ QMT_)X_W H(NJmefy8r-jշvkK5Z kF^o jFDx`(FD2>H[sZORskSlj.G9ف?-Uf] bgVf ̭puusfF{|[y` :IpH m[iTR7\[b`G[Ђ@:PY(&62|AMhǎYR^Z@8DThgMF]`l7@=l ]T5G(Cugnbd*0\GI ) j00֨B1JP4^{he8\솵yZ4q[(6 ܠy&pJjN&u k9 Ɯu@lD[o5}mk뭍 5ͳ8u fid%v6cShIkzt4 YUekk.8xR򏢦@|&uR.;M%v& Љ  0@%v߷/RIIRbiGzB&+1XZaX-:Ai5 |V=B\J'lifdMXΑw  eZ/)]##؅WL-Q`ሸkʨnR\aQ.]ā!0K.ezHoxNWKC3iNxJsFMe Č|+ Ä.E,æ]TUIp2IskCibouj"Qe>V| K9.%e3=^8IF7_UHIaC4.(Rn(;TK+̗zCG8Ҡ̒xR \$WOʲU5Kb/1IDXj)RZ E*01xwdipJk`_Nܥkv'+^Zݩ[註wM4םE&M[ZݽE/2Ct-/n| w K[`NE-wewpyvnnU7Yyu*juӂE+]zs9XITx[м7ii]_UwЪe;Q(/pީYtu&˜?<ą#nN:杪TQ\S=ETu-{dn- fYy0cy^Z޼B^Jvp\[c׷$^'($E,@%Lh ͛NS+P 8p!7KlO|6~ }KS5s;̀0UCVT'd ǎ嵊?bǃ@z4f^isN'LCV3:5G+ǥM2aCޕԌ\C*䯆]x:5`R*vʭT[IʩrBһ*my݇NMٲSF[VMSV0F0{S ôh.qϔa%|L}@1Z gz=A)<}.۲fY@~gݔs\U$wS>9q}[<}I+''w^$Y)?v+7024e'@k@g:,5@3uJ=y &.y. Z?LH~ɗcd h7?̣k]IꩡT 6VV_z++$cN|F -dP~=VETޔg3h%n*ْ#Ad2 R.&2_KWG}DSr]= " },p"^PO-<t:Z}τB HB؛Roa\K.їJ6CJ~cS[Bj>פceOJ|Nx Jvd!DJQМu8 E k_#zBkD,F7Tt݀k jԃST(?7ޯrA  Pg츁ݽm'@#vt5Nʭ(U@0eUKwJ*:B!3U^{P@SȪq̤a=aXPLԯnA#wU,R*;P$N d+s(@¾,Kً7$\4"Fnq)6<䠯pd%o%H+ttCo"LK8V eQNxsPe>l,ĥ¬MI80qѻ ֞?ӅDUZC \Vt᳦}SnTpH4$ y9:#Ep:.]4jqd_̷V40qUKuAL+~Eri$Խ -fr%{>= B&'h:*XX & 9oG$YAA?xﺿ=1̵t3&IDZ9޿ӧx]#y&YaR`c 9WW>RcuuO@7=uU#X7AMhGd\C~5bƠe'X%^-%y5V)ʢCg=`T/L~W0KI)G49zyNYdJ j3T[=AN#Yn[IzMTQRpdiC҇֬Sψ\%He "a86a#$v@ 'He!mB V$rjJIB(_XRgH!u飴X׊0<_-t=J1S5bMe&arMf ڣ0*L<w0-4j硪h:vL]l,vk8L=>&/Zs;4uwqGr>9Gw`KZl0ƕ?Y!Hzáf{ЬϬ2aZ ;gf_ǍuWX`Aj:I-=fa4Q/ ݼɲ^.۳\[@%ԆN³&@V_Lo]]Y0RuetwMZ{-=PԌ>"2lcp0DCF#pLޏ.Rs s&g&E};ל_1r{(|W>\H%&+1hGg!8\`H& v(؆H mSL L0/FRcL}; @2/c@ pd0R1x#eljD![Ur,cV:zM^=+grafeCctlOhë雰0C5>3h/B|@ZBs++!E8oA-ߎ`;$]PEHw/|35P!R_(4c0`QZ-B8"3JB>p~q+~ +.W@ܽZMm$$$ :E*B=a߾8wG]E9J͊0@?TK?>7`|w`q)+η 7Y"^`iƱc?z`I$1~u\U3i P(6Z%Iu}8Mv;;EU~AՉ镋o|dKN`a #}Dv+XYA Q,a,iFԭ`bDTU"Q] hNJ{XyPק1Q xpvEo-\=d h2Tyq)-C>YTIR)hS#k$ݤ& ?cVY&fB^iwS,>D)D)%DP{gOMf2z9&v"#SDdjSAYY) Хho5"Ve)69}ܓ1֝CXfy!f| M(q)Z`d}`KYP %OlEF1N@9)lٸ.v-LOr`L4QZ| D F &—|lXH\۸GCpu}.܅-\]S"aQWd0cK-LJuW/TuJAĐGkl)p>1nc'L&_U K^MH >!V)Xl0MGpK1 䀶dX&˲\Quj~c8`x0>3-SkUtJ2 $$.IHq.v5:Bq)LHlcVI4A|؏Ex΍`Bf\dTx`@'K-M†6Tqk>++yH?D=$,A'p }c(|8.ڦ"Ȳʼ զo'Y)01 K f )zᵊ*l>}T.dSm{jcrWn*#(GG0rOc aBKX޸.3`ns("/1h( Eܔ׿sM]7Y"kjy#{!U_>h_p7X?άdr+h|OXC܂ $sҲϸ9)rbCI|t#@/)bB*E#N%41Zߋ}]]VX1U/rR&,;č| q&67ۆڃ^mљ3٩<`(=tbWepsM]O;pa#@PqՕc[Xܻ聗na.Ytȝq6?>8OTyZV7i„.\a!ha7 >d)I-|w? VR3(4g~ _NV?_GVø6晝PRī"MxQz taoN^nq51i<_},`8y RJn6#ŀ>$ JgP5O5Qq1yLWO/IZ-yXy 8s*|K㙕1t 8u{_ډwS'ޭv_3%; S=P.W . jj/ *`pZ .ʀYEZE*ϴxYo?f%dw l$]hEv u<X*%fˋ^$Ӎi bϬ%Fh6O))=~a(8 \%<҄ r٠hq"F3%ř.&Q]}s=^P2ɶX߼;#k[OOmt}Sgdګ8p嵢_O>ƝN.[0M/Kx4_(9gq}%_vB4چcz; `&b0?!d|k6 W4 (#AJʳ0rZ FIlkgDaC~'/hMN{SB0u0}|- 57^=D.}da!m{ M DhLj^iJ`4.ޓDU8#=sK/L9ǦJC f'Э]KbPSJ`Ͳ|*$VN/ݰe**@n<4kZyB̞ӱtZkD0#P(n)'VTYNܱia 0^ϷmmƳscVNI_8-~kbnn/_J_B`%*g~??}$Y -X[os/JAªDTsBsdtAOY9{8( Xi'#ǀk>*mtU5݊WJzW6@KS2Ir`JYxKx^slڭa4A@jku:%24eJW:9jizѸk;X4lP8'aΦ?\}{uYM[Pk.e`0v9Q/L . 7`.1!L!UJ:_ iV; 밝SҷS*qx=a|s8p?鈇XOiRuK'ܽI NF@sA;Ɉ̊ӏRUes*4xe<(MO.ƎTãйOiKFyYĮ6 PfT"v77UpU?O[& H?p,W"(˿'Er4t30 TWqA,yPPTG9i hT6nZFx :A=bqPXB$g&Z[lۆJ k]R rN n>lH$Y]Ndn/*W/bd /+*Ϭ*LdZ(KLmX g\YDI-9Vt^[7m.(ʏRkW$*ܕ~Og?TPV"?sIL-CPGs^NcJ<' ]@^o8D(滽7_9o>u\:j'} 91#y~q׀AKO20J*kdb*JKyF>,{.LzΙM7!da0Μ TnQJB )h5% g:CkD"<*P(f&-.~a$ul ON>+5F"^OxMH[t#g4 ?'[NOO'|'P,V3]c#OϸDsӶYm(Y m6x(uj=x*eM Rc9\}|/e4ܖ  TaH)z"aqjӸ:XBiEnh[-l4h 0\6d} u]$.Z-SYݴDĖ+VMr=}ylETd cZ{Cm}x#0AĽ33 `Mʹg?)欆ck:vS\qsZR<#{"߭dDr:ְk:]%U0iBIfr?Lk,JRHjS~ud4&BxE*sҟz(w,ռwV MJ9X aKS=ԏ~Ľ , n(F _g%xS(aͳmro@E/OܾI<1fZ{ \qa`yޅ `d]W֐9kw;L:%Kȶ.hf C: X0.$U/׏q1!a0l|fy„XwF᫧~^L{W-eċ<[L[Hl$q%&j*]pSYkv]Da2waZ ё0cH }KT"..Rc&A8R>\C@hʽLjK gt1uJUVA(_%+C8l$17Rt"6An$uV,*dUA%K P w< gswm}[C Vxx6;9-;k2vl8Z,13vCfexw̤;bų=?gl"ܳ~]ۃ9%߂Obq_4:wYnk4q r.noIka_{ԮQlK$q:SĶv%͑SgtKD[ kk ohsc|"x="97Z-Bonu΍Ms mQja3r79CBNxeJmъ3PH[s` o7Хdco$La _18J^!t]M#H3O510 Cf' hT5Y`Z $[Q*-),vE=480gޟY`)XEM%;Vܐ1sK>~u" k6oirg]b$nB'۝56s 0pCoYj#Z,DzQ?<(8D&\"c`X8ۋ-Yt"=RíZIQioqb^D.֛bI Zf"yt;xDC͋O_v\^ŤC(&bsk4f_f"}GcPS`x_\ӂoR7jk=ñȺM=3BaQ֟3Mlvۗ'Mg}{Gu#_3-,w5*ɍgTr^giYR.¬K8*7]T{~G4p߿ewDmVP"kBnX0U 4z.Eʅʅt ؊0_{3 F{l) vvwc<63eMϲxXS:P9%9)P0{[)˲bzZ(ļ  h~ {vM {rZ[J#)_++OU]MsUD-i4Yzcnn[N8[3g wo#cZ__QkzR^R3wU9K2ߡJ[$#^T_a`K{Ж\洰|6˹ҍT4zju6ˆE&$GS]_x,]s/,.!c۽0/zZ,dS *q* q,t B+ 0 G3`@&ݍ* ~Oh"( 娜|DW7K?*sxZV-l.d /"9:wuKVU'YI D9"%9[rЪKn^[̥CV*ĖN)^?N!(0i.:sl]{rzFK D bJ1_e,ѥ̿!wqYƠ V aN-+73d>ɾ@X#ԍG7 Ww˗݆9B;| Gu_dϾ2k T)&YPZ YL|"]s!Cn;)$.߻C0@*'н n5g\KwHvJ%) SĖmCwa 7\޽{Y@+9Ȍ04F/ef# ]^t5 4\Tܡ⵽RڌюW堏LFf 6v+qA[N)@G_LPT/@.G|G -n_1BN,{P)`; =ԺeV$,G S`Al0}\(Z<k0-1șGZ$H^L4!wf\F kkNiR4Rj?4?#L ]UmSEK_YU-c!T\o67*F4qg%aJFݲiLLj;SECO&a &A1mgMX*ֆdt7Dj|:¿M