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

}y8AUgSdv.J6M^Ӥslm%M~3>NfH$ '?Á4?kyCSfPDfw"Kꏬ d):zmig)9|,}/b;v42mvF/xNX-aq0ה'?p\&K LyESǓPD.9?atf} twIi}=? >[3L [q`Iyl/DGG.&Nql <+E`5Nߊ߫a~1v! I5r= 2oB P>pEJ$)#k"Y5ǢX0$w0Ԭ8B Er<L뇡{`:NX;&%D@*Cr >B26~C)>}|cB~I/7+, |?Ҵ*tnY=״`ͦP͖c˙`Pxf;[ޙj=u C۶9e Kk4=kN6Ͷjlo΃+ 46{0ER͆DPoX[K;U@Hsj&,  }71vQr;o2Z/"߻Al ,2IA1#"mX-*'t2f0`WF2ET+W96@2/ q+%5GuP5O U݆;-RN`Lq8-V5oo5AOh]}h { UoȎs ,ommn~wƷ:gfXPnnY[FcPY[ {mm{(PȲoM{޴KVl- a;hIih$iLk16'ݹ@x:m&Db1X<U1ؘIT 7 '.p$HQ`#vi  5U)s]6>4Ro|DL 'Vu<<&1̖M2ym fƐQ_N8qK(汩NU :`̎:ڗ8C_/5av. g 8oueКYxjc9hؙrܩIpǩ31 ႒gNw6Q,@*CJ;1u4|azyg6˶oX&~Дjhve]; QΐQEuۊ MZٮiݤvb4 ʻd܉NWf 6@ڬdh#Bhx; 70mv13%s>b` tW 0ͱ %)_fʘؔt9!snZknei^eܴRL[bsVV^O+:̹+I(4@KBYI@>;Wd^JRFUr7yUrY< ًL-l Y|!+WP#?V>9ƌh^)c0ILߧSԐZV?  T\ρtY4 iS %D%Y ndJ&F!-߉$ iLuwc~aX|Oܩ?~ P˜)2dوXO==T$nSlm0k< y~|bmoҺƸ"QZ4-?7SewχPTR9Naed= VtFb0q5"Hc+`.jkԮvGjK\K36{l;N,UυHjT$ .e8y3j.ᶶmkCf\dMV &~DT@޼!asg^Jeqy(/"|$^[=XD}e0% 6A<4,m4T0JR 9a`ثmF{Km6wJ166mڊ22{<\P9F͆jl7j+)#[ hn4 5# <0r#"xeh$,9'7e5P_Tuk[Yo#ڪX*, +jC]mQf!v\*6>2w;@vխ68V&Q&`3G=PԷ +XR4elnı7"T9pn6WP;Ėjͬ;; fV&m˪&%@mT \ߛ[ Ʋ6 $MF:h.$pIA Ksz/ ǖZE_b`, ^$`-a lR Wnl<E [ @b,|}c&@4"-i 76+@J4ϊn/t$כ^LJیM%M?yo0j*;f?P*bqq50ជ8,UYii*Y3f^܀N{w.[akch"]IӖ])BC"JSd@6K9 %:'#?r\{%S>V!$r43& ,Ȼ%HA2WՔ.Ǒ{UER+k_(pDܵmeTmb j)(WYG]ā!0K.ezHoxNGKC3iNX{JsFMe Č|+ ÄȮD,æTUIp2IskCibouj"Qe>V|] K9.%e3=^۴2*EJ :u|TEr˅G١Z]XfԻ:eVēWJq}V]^woUX{\^s<@7\zoTj.dw "_i;hT~K%˵]KR5]jT-tݻ&΢y}v^2ݗ s.:Wu@u-0Bݢ鲻WM]]ۊڍtխusuӒe+]ys9XITxy7oRʺ*=ɫ@_%cC&gW͡Uˤwc=P^S֙,s~Td6!yz1TM)k& kIT5ʃkU-Uk@H*]EҎy;J[3rX=:s4pr6ysN'/}?bC{nl4;:\fR`|$Rr? ö cǘ7PܷAs-MO"g fKN4~ e!nHgWPLC:K?qa0D]Ҵ'a?p&d[rs4E5 S]|40!;ʠ]R4Ts}NrxKR" TbyΘټ$I;;2o 0:x#??gl>iVSݫ(ع6`GjTQCr@+t;jWSm#:]шyӾGW! O~:fixEMu1ՏNJu7e(ӹ'+{"7u_;tN\0[u+VYn-)Vo&TNҽ*mu݇Lٲ3F[V3V0!F0{S h.qߔa%|LC}@1Z[ gzPbmY} M1 ?dDsn‚9z.邌d)5SYś8,Քϕ H2LsYP]y OR}̾f[}鄁~e惆O6_%!9=d7@")R=54kja_;گlm- OS f:*`Qxcftj㳓XZ뫁j򗟰/i7LZ;Thi%h@jinDHdLd9yMv I bt:%?TpGϳ8 d}akd^+* Bѥ華%+kQY ~bqD[T@ bJlط>'e@5pL>ɕO(Dc /'ר*sq7| ZJp$j $I>a:Q{q$3T9v\WFsj:33 0gP!Z}IU@2c{?\-̐p₪z=T$_I;Q8%D @sM :֞1]GA d'(LPBt0)_˓]PΙzc_#b59r\QWhħrD~C`"v^?c'5}h?=zvTnF)tZ3Ta$ "8߅oz8rBVc& :Ǘ &b2H|~QjE`:fR 7؁"Qt![Ca8U9U^P^dg|CE#adaz&Za̓Z@ HLV`P4kB'>pV+4 I0ފShPJ7U_ƾ2j~L\:{.ڄH(˵ }7;Bl h{=]HT5eE>kjPAOORZ@ژ)3R>El! A|kE#pp.j/S!P n.;xeЯh[?yEź,j- LQ9c蹿:Pds{uT5L>2w!`Hs"TbgW %`Jr* tJB3mڔR#\Ljf(D|FD'*A(SƘ 1Z36Rd8zv`3!Goߘnh4 *:{ƹ$>q}8/CiQ&J&b(HA+Oi!%C`mWSPR,fGϛYtA( mH"%sWSJBC.?C'+ŊЬ*œ~+'(Oğ6 [5ѧ-hRZ8 0t#Px0rPufYڙ3uh؉(Fqyx{}M2cm@w2i WqGr>9Gw`KZ?•?Y!HzÑg{Ȭ_XeB),GW v>kk'q۱_j Pw[{i(_ye]o..n!K Y"4g21D3:^P.w:ja:<8ji[&\Q{|Dd{'`p&G1_xyte80G$"y0{WÙSL07 ms7 |WS̆ & oGpP 8̠`" !i 1ϭVjvgexh~=>ov%Bebbe Q>˿A@HY>U 7Qh0aô<9syBs!GOA-ĤDu3$e*K I,d%2xD@Q) U//= ev)fc'0tէQ9qNT?0O+|o/,WQ,x{EpZ!گ|aQşR|(+)X=P2K_-b]K1T蓘ܷ 3A(F{Orn∀1T=EiY0#YOFI2#Yuc$1n^:,r2)ĸL0:8.Է U.f0:70 pq'?GIZͽ%;L…dh9j<6-[pOozm7-"mbhqH2A:{Pqጀw.kEY f:/_FG ""/oP+J Zj_n/>ve<8`%8cUD-zc}5lnyVA%k@+kO08n ZJ"JA PY-&4яEW5ÔL0B494HwCMSb/N4 A" A*=њRHD uwd Wi1ibG@!2.1ELJD5 ]V#K/lUf"j1Y]keXljJov rᏉϩ5 FZdZKVd4CPсٜbB?$*O#%1 L$/=aTcbH(|W%=q{Qz<) Wׇ]ҹ]H[ `Jdb"05<wlIN .q^)h5a@6"ƵtdI`S҄aɫi at's%ƻ4n)Ж,rY֚:mUW7V QC_A;:E_c"||TE8(BB⒄"/)a_P? #d:ngHsD]H&dE+LtrmOЊ+lhCph&ϹCCrdn zw җҍjˁ¨mJhq*ۋ, RAt}9>3 hOUU1R!|a$#Pyl߄7`2BԟYdJ6+9F \ɄV!ϒNbfYBT:^xݔ[𾟽&z6'y#oRN ƐV}jAaקkk9}y5G=F08}Q27`Ы3 MP~N|P~@̡tMhH$!KCL`z\^5pbv6~˶8zOava6g]b]d=a`2NUUa!,`p/bv)S하jc'U˕[r Wy?D>:ה}] Z‚wxsCEy GD-,khڭd却W"셴iT}Yz5~Na_:d8˭=ub -Rs j*p*v+6eqsS+Ću`m+5F܁^@SĄ~UFFK$ibLߋ}]_VX1U/rR,=| q&6Wۚڃ^mѹӇى<`(W=tbWep}/=O;pf#@Pqc[X{聗kna.Ytĝq6?>8OTyZV7i„.\a!ha7 >d%I-|w? VR3(4g~ _NV?_GVø6u晝PRī"MxQz tawA^nq51̗bu { tgi ~ykwC;ͬЧqB<35AxTxtkā (V{LN9'J[\6E |2sxӿX$0>?'p 08ݫybMUȓ%6& R1Гן*nb| (}H!+j 5k(bc%%^8[_pjU,G3+]#Zq6N[ĿZdKw??"УH{=t;nx \V>ͩ08, ܪY9p6'`pY?,*Wy~Ð1(%{UPGeL$HojuYN$oc @3nx`Rث-/F{L72p=p`'x>_^'&}l{P^k., xx>CW1_ZH[x~sJrEC@k{sYo|֍nCk`Fk2q=#ԙ/p43Ҳ0YJ`.DU8=sȑK/i9ǦJ fDM%19f)hBgfYGHZ T@aRr'WnX2 7hsZyB^Qt[kH0ag3=x'8rZ|' zBHɱi)=K͟p:-fG#EW}37#^U{U0 !tꇴɅRD=%g Z2᩠! 0tۣtTE-Ҳ~ZHRsԈ s9@V $F%g}]H`NQcDM'/vL@5}UD#X`ew8x~}|nuάFI4R%@04 9B[ `y˒ \SRw >cA*׺W<1G"jK/LA8Pg拑ufW?hXYFÓI,5sZ: "bC^PzH/^5*O^5y¯(%)|E=7\wևA5 e%Rޅ̔;B0u$v]Yܯ{u/ȷHTL~ۛ/?o͗7_o4'JE!g _5ӞkyEB㌇9h@h%LS|Y=p\_ӎetwXIf0=ɠRk}؏& XMǝ^@ PGtvi4 Unmw{m|[S!4mP *74+;y60v壀^/DKK9qQ\3)@c\2hԊ$9v1yCsId)p'^}<*P(M~4pzr/]I lSױ%xal:إ\T%7Baި'á%c1?YKbeÐvIȒdfq|70`|llX)յz8cvu ٥jy׋9U#KМ'u ]_߅"9)=Ee !/IUOVtR񘗖Ʈz9AB:)<T$; '$$oWLBHB~XYc/N80Ⱥ]Vq#A4fȷ\0P|,ug"7/q:PI d.(DS>tb qz󂟫X5(/t3kJPG7vT{<>(؜w6T&\FOmf;$[~hM~a2fNfL{hUΩ3:Rϊq.|8HH2`hB'ȷ[WM_S"C]gIR'dd$v$RpdN>{vXOhWmI,,jƕ<}x>,?-*k{2D^h[B7烧XFޗAȁ.+P$d`EP@O"'ROcġ6{$=+.J leeG 1C.51c+t@ב+b^ωAK~KXF0:5bjT˅ &|~4M >RKcDMǻ3sS&DIzۓ2hjxp5rŤ!4<尸O52zhNDJ 8I4I$+E<<ī?]2f~% VbNKEl~խO]`.]^{l5u$Z$ۼNm)sSn(w@Y#zxۨ7Z܇*!T]n~Dc&j}WkXw)=mA5<40tTenӐNqJ^-U4^J;I*A㎵pNC;0x0P/1N!|% @ q\VP>/F ~ĜS҇Y6cיtqZEsRJe1yފBb%1b`Ks*]FpC>vHm 8B7d´L6+-a"y{$w;E`"\I~pZ=Д{&ws3 :EcWkaA}jXeonlٷ]ٛZ`N\=;[-IZ.Lh+HH)VЋ͑S]KoҚFkMZ0j@΅hn*|=f}a&|v `G-fJܲQX6hv~)mH0H2|dboǢ>ﾦ[nfBi98{ 3Nh⢈0fVH1Q2ɜX Cf' hT5_YY`Z#|[ULRX8><]UԔY7AMi){c7)^Ђy\,Gk:hh֡ӝvD4E4 PY=4DD)Vu{EU"k`8-Yt"=RؼP -b,hfe418`F7ͻ4uU횽xH[C͋/?F/j IGPLz(!k4f_f*$e?@M}0>X_$U^)3ˬ˲nb7v߾JO?<]v{('F%_گ\uH ;k@f9} KfB fvG/>٨r)sr)3k" s{Q:`6/n|F{.ll4~5ȳk?],7_>]܉U9ual3XS s|߱g[Ωܡ*8j +hn4jJ̫d]πWפgnu :n^IxĻ̒7ueٻj9,y]եX+͹VX Tu ?}Ș̯/wS5gyfY̻{QMb၊VզMv-ha$lscs;#*PhrErl1L0.BIwaޮvg~K|u%,ٴw)eW2/PB67̒M(-/ 1~0 $jBTi,)](Gzu+B}OBT> u_sW۹RӪjp%^i'`9W$nKNq]ܒZu kttJ; i<)y<ɅWgȁ DO@~^C~D~Y +u&wda#'7˪|>E'wdbvJXWGT<1rX|%cV7:,\QQϟj"Ls A~5?ǣ?yIq,({2Ue0`Vp YIQȐ8ͽ'":"KS=g̙`&i,@$uزv#\fq߻w/ w$q.fLK=kwT עEaJݙ<|m܌LB_9B6UX\Έk~5m9凄#({25CQ$?\ZP1>$[ Zܔ@{P)`; >]ԺeV$,)Yu=x,(>YA\(Z<k0-1șGZ8K^<XqD:eJ2< 2A2W3|6嫊U co| >#66v#긷0%hkn$r7&Նߜ"i鱧Yxb Jpޠ3pp/ߪ)FeHTti(d{?6Q