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.J^Ni9feʒGG&y uZ>t1i"  LGCnBli^:a> RbMs͙X#MV0bnG"E#Nz}XB}#YS'TR܈A뢋)p̚N]g`EՃ0\?r Z`]cv=!(V]T]C'`X"%').cL#͊#_ o,԰?,g qZ@Lc IeV< /tj4s?Js"ODx}|\XENѥP7`6wpj4awN~h6Նl{XN60ۉNP[tڶA,{͍XB\5[s9m hUc{sm_Y Dٷ)Ɩjl6%%zZ ޾BJ84AL8gI5 X1Ӵrܹh }] .Á(AʂkB&cSb:q"aEC lZ ^r SH‚Eݘ!!ni `7wsZJiL] ǷEj&1KaY qݶe mm 6(]lZC-ks("Js0krkcaoz*[io;1c{Jz6&l|0}4 'z$4:;hXڄH ("L:p ;afs#T¥| 9 ,U}#}cFR:C*ܴ"hҼ sib48V˭VSW$tLs)gWPHi+9,|vZ=%X9rE^Yȹͫ,͛+dJo,d.ry Y[<BV~GV>9fh^)cFL_E3\)!5$ z@=@3zğC-C2hӦ6J;J<ȔMB@[IҸ_ jԑkmaX.b= B pbt4vB cwPʈy >f#b= PpR8Ni uw&о`VjMfjHDIjҴNƖ=BDREJ94;&]1ZU^NՈ M u$:RZUo/j"Ps!Pk.vBH;uc&bW}:#=$Q ".p u̐~aS{ڶj8 pa5Y5qQyF͝y*&}Ƞ?x oAcpY46E<ҳ~tarPL*J% Q-R_)P Hj+Nz*pA!n6HoƶjKk`l- 6Ԍ&hPʍe|洞Ɩބ\rBQխmU˺~sVe|:Ϭ0TaAHBP\3_] VH2+I+pꊸR \>jx+.;VPnTl.o\lDdqEZh.7E[*5oHy |/44]*YY?ܥZ.W%w.I|NJWFw:]yugѼ>{Vrwj텹̿|w [ _A늺onQt+\]ݦ[wՍtmEFMY]Gݺi]V,[މU*Xu<[м7ie]_UwЪe;Q(/pީYtsL9C} E2 G<=Ow&CSQGqNQUԵa$H*Ӛe *ziyy*5[ ro giݼs-vA_9f,z[M܂9X89<n53H=gxQ7v[͝fdEa.3fJv>hcz|4y ƿ ö cǘ7x`Y[&F͖Μh,Az" C:mmؑ4)!Ϯtf}#Êa,aiOAL#ɶ" hjL$&K I`^#@-w0SAօi2+%E -yiv*wd2*bat.F~/}ZM1w/cg8:CP)׊ ℬZؑWV11RxB+X`|9m@ iȪcX\QTG`Zv\*XWj)Cq=Y1M%=ICz؁'sZ*#`g^rkI9~WQhBQRSQő.wѩ)[}p 5qu*IyxLǗ\,OrL Nm;=MTP* ?*+0ZfS0Uk@źH;VrtmfIIēxx-Z\wy+Cl6#"@RYLU<( |8)*tZA%P=Jױ7hpf#a8&qSE \(5 ~8Ŧ"iSE)4 \`%&//P&SaZ<Y{, Ef?De5=9fĔ<#q`yO.j|+Q&{1Hfr RA >vy8/f `:DsgB!h} $!VT{$?[!é z=T$_@$+R"\U&kkϘxR`_w£ QT&cOLO!:W支 Elh.(a\z_#b59r\QWhħrDyCt\{! `0BN;{q {Ox^F誝2[Q`fz9Ec:UtCf!xNwD뛁!0UIúNaXPL/^A#wUny)p(E'9S a_X_SU%N E{FO7$\4"Fnыǔ kbErWW8f7Y+۬&<'x+N` :ʓ 뽁7U_ &2j~L\:{.ڄH(˵s7N@}.$rᲢ 55r} 'EzӔ,t;6F ut9G3C}52ZKT殮 zFg^Y+O%A5%Hho5˖K/qiX41X?@3 PT1X0΁0x}"#"5Rݖq $| f㞹4'iY;|NwA#bgVGI}4Ǜ [%_]9LRCRVf?g(wu+=X<0AMwpܥk2!?}T2cP2^t^ْeё3{0L&?+_'AUÔ#sցGhx٥;Cm /;VuSy|VVhUԦ2|Z?5G!3":)W @4ƬH5M: '1&É#s c ?z|uD,YP3έ%y -4~wvui dga 2!XX;<v1)ތprzavMEW!͏6!+R9 y5$!}d,3m~QZ͊kESЯ|%{zpM``5E\}ق(%ꁣ O7#L 5 kZyj&9S`0(N38tIf~xN& d~_w$*k0^y{ $c\վ)OXĭ?hƾWJ[Uf8,T?q~a̬sn +L1uG=,&E@7Yker rڐ)Bc_x+C1-r#Y΢,ށ.0ѹ@K{OeGDM;C;d0<wKQWgҕQJS4ѫ93Z 7b>$Norg;z9>k̆ &\ݣH%&+1hGg!8\`H& v(؄a$@ѩ}&S h#b|z1&w l@0*v Г F*r P:?d*Xq S]g%\Bx&a<=D6@f6 A3T3J(ć%<[Y/Z1φx j;ov)Bebbe Q>˿A@HY~o(aÀGiyrBNZI0fI49T 8bq-$Z 䃆Et3`W"?}7WMI.\UF);V]fxqkhj3e%FrBɓ7P"9WR8;zdZŠ-",bkObrC*j,`?i(ʥCCĊ#PKgd=dFI=81n^:,r2)ĸL0:8.uԷ Ug0:70 pq'?GIZͽ%;L…dh9j<6-[pOozm7-"mbhqH2A:{PqpF;{[UpAM",KA^_ f:/_FGyp ْ"g"/oP+J Zj_n/>֛gj_OḲa>P+qܧs7`ℕRaT^A^s@kG5W"ya߾8w{]E9J͊0@?TK~NR;N߀y1˧pg{x:RS*8gx9YGFlW%i&wtX9=1bsgE8*"<;oXE3@hl$}st4Ywv& +TKN`a #}Dv+X[C Q,a,iFԭ`bDTU"Ѽ>󂡮OYk(ϣ2@ @sX.p [^!9z{h;d :'S [|8R0GVKI30>M#$x&p0%ӭda-L&M PS,>ʼnƵS!4W'ZSJ(̠#djs>-8&0 M(DF%TԺ賲fSKjD`lSDm=& +c| !f| M(q)Z`d}`KYP %OlEF1N@9)ٸ.v-LOr`L4QZ| D F5&—|lXH\W!Ni>BƖ'B]S"aQWd0cK LJuW/TuJAĐGkl)p>1c'LR&U K^MH >!V)Xlu0M%|P~r@[T,eYkl㨺B5ZL0r0)SkUtJ2 $$.IHq.v5:Bq)LHlmVI4.@|8Ex΍`Bf\dTx`@'K-M †6TqkkkyH?D=$,A'p }a(|8.ڦ"Ȳʼ <D'{ܗ3Cd :y}ؑ_5-\%#WI N2A Ց~'qL4.딁̲' Sy^1b0?M,طB0?^]=x v4΢|i+݂ՇW4ѳ-5}rRP5곤,pVT ׸>][;ȩeϫ95 @+^5~iubo@C">X|&YG^ii ϥ] *v\nwjSLlkffs%Ef )úᵊ*l>}T.eSm{jcrWn*#(G=^~M9N'ܵ|0J%,H]bzg09R=p@ۢln^߹&՛r5R֟?탪/Ui8+W[,RgVp`4NEjnASq^݊MAiYGܜ{ sPn}e:_݈; h@vЯJp(Sx$ 8AxEDWWFy +@ }܆ 'up'>87r8bwŮM@&p@t `mvj '%C!"XpY6*\EKyE>N}$b9Ys8T>suz%[K9$qg㇨fy*Ÿ/mU3MZ0 WEH$/ZM"%`)Y 8yR _4~ݏrB!̀ MYd—O`ב0Gaݿtyf':D^$c@!]s][\M obLU-*; Ƀ&(#JPra$uuUтm\r\N`Wa:_%[Q3 fa /5jP?ܕ%XvBa➆&ݙ}l)ľ4_ZDHNq3+ib3g7Lm` u;kD*U1qBz^ &SΉ059RW `ѿ4/ r0ω< o)%7NjXSU)d;BT 7b@n_uH(슚@'|ʨ<+pIɧ$▼WtZK%JטVDκnĻV;ևȝO)Ҟ(gΫ[F^ՁaOsj/ *`pZ \/O,Ui񲄵0$.,$JDo^t}Y;SEI)Ric{ǻ6:,E'7  x< )UJ̖QH AŞYK80m/~`+&-[ ${ R{뵽fD7>Fۀߛ-Z+$v`0z{Hqfu=F`K"4&]߿G5AP/Y4R%0l*I9p&HcS{%1Qe)AgfYGHZ T@yQrWnXI2 7hsZyB̞ӱtZkDg(|7EکOTǟ/]TʔAO)9,SN%~8Hz]*X^oflF}+ { B2̩=⃐hG [KQA\=<0n{}t/ÖtTZP>RZ>A*zBU,6jtd䬯 I4Jrsմ{b:DT㻾գ*UwwlkcZ/^<{lbNE-c{/$q̩[r#& 7Gr_? 1)*KzUR.(~~HA[f'_R_TU7$}FR+3mq 72WhsqQ @L2N36= G|Vt+J$"n*A])omm+S2Ir`JYxKx^sXo6aA@jyd MRUe߷Ncy rh\ⵝ`}_P8'aΦՎ?\}sq8"] Z`5s_]N}o24]bpCCtt Ӭ8eœwa;oU.{\+ML5 q?JEk!KI"JWPO{߁vwә?ҳLMhUh<*#yFQ\?ԍ;#Gs2г]mbknhD&ogo~cL@(D+CXDQ$;җO0qh蜣ga9R^M@I@AQ66夕.\QYFh8x^049BѢ `y ˒ \1Rw A*׺W<1G"jKO;A8P_g拑)6W?h2YFÓi,Y0sZ:"ObC^PzH/^5*O^5y¯(%&|E=7t6A5 e%Rޅ̔;B0=u4v]W({u/طHTL~ۛ/?/o8e8.!}KئcK0@(~tu 9JnI?Q! O;K9zc~pa2!ZӐ%B=_nZa<&;lRkq>xJp9s:Gg9O ErRz mzC }yK@vr /-M\!?ws>uR-7x&(^Ivr Ni76gf]uM> aS)YYG:,g_̤yY!(ZsࣱNKҳb %>NR 9P% |6EQWod蓺,C'@LLrSc8'0#CEbr7dG5ZVZ+Bk/lHSQ[l:N$N$N$w"Yi w dlj'YО / '}$EJeVXDfѷ[-a-Ibb>sBOF/ OQFRal(H9}Qw%n_5%N^`scTtٶ;QJ*{M& .dF_*r# "/BmhF|<=Nx"iwp,J" ;X4L{F  iSBLoYJOL_Ttɼ# 8ڡaub Pվl zc~D/#4nAԼ;3O `rܹKg{?)'`t$Pubn }X[dDry^ }7GZ"IC&$JX΍DEgZKc!ī9+_f~%e VbNKCJl `tHFz0kF7EKcq{ e. C")D"Q=Y3|^$jX9Ri^-Q^+"vPⶖ2f6hĘaŠEbC4+d *"0!.] to.]n=4^ q]XTg軯v0\N:ÌSe0("=Lep=R ='2'2qI"(Z v!dB2Vsɏ6Hb>43pw8dh5e#"c@qSx0H f/m8zP;@ͺѬC';V#H 8F.VwEU"j4`-Yt"=R @jJ<~M͍zc2cRs͍rwF12i] kC?Hm5/?Z_qzp[W<>f_f lAG1)0|Wϧ5?-(U^)3ˬߙ˲nb7v߾߉U9unl3\S sg[Ωܡ*8j :hn4jJ̫d]πWפgnu:n^Ix{В7ue幽j9,y]ՅZ+͹ۅVX+Tu ­A廁Șί/wˏ5g}fY̻{QM_a5j+{jӦ\|6˹ҍT4zu 6ҘE&$;0oWuy|ὼt!4ڽԇm|3lڿԫj (f!WTYZvfɦ#Za?v5!nPYCB @a.Gt# |_qR>U!*VsI? XsW۹RӪjp%^i(`9W$uKNq]ܰZuY kt߻tJ;EI<ŋ)y<ͅWgԁ bOO~^C~C9A9 Kݓ&wz2ܑeU>;2X1M;\,_GT},>Ȓ}x+to({5}]s A~d>2k T)&YPZ YL$]d!Cn2$7T߻C88/NNNO&3g.[q%NK)b6Y0sǛI.}޽,ߑdƉq]Y#7EY./S/U|mk{mm?fevD*3/BPjΉv }32٘_Gmc]qa&}WDzĿ\]K5~X Eŏ;_O?xpq?GB~ \hxOwprf90hepS 4j1nwB tz4 wQY!dIgc_)xd6xBВ(Z<k0-1șGZ$H^<Xށq!LH,P /9Y$ a\4*[;lh{TJa oa.AU_ψͭ ]ň:7D0L(Z[A{?I7gHZz)b$ځ5:}\79& a˗6%i$k">w ^