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{@خ#Ť$J%/q&\vu^J$&~^33OQGq[0 ׃_±;/sLwh(*M yhۣ'ڶʙ'*!wܶ‘a352۵Cto: cCvF>( 'A^'ÚB:|ᔭ}.;1e|;{*K=yap/!ؼ9،cC~w3ݳ< Ԇ7t9ZJ*r5ChW8@_cܺcTC)eO8`Ū+_}o< V/$Ib4NeDWm[`fFGh$j sA@ f*Z I˴xn` mh4&L?wg}sc"u"؀?hM{^xi T0uw2 kНiћM6- E%3ӯPeeogfh:[%@Lk axL\sm UoU}{se D3 Ɩo6jKJ4 0F[9=Ϸ6Qi1*s"+}iMefpk躆pZ/ CϽG~TvnxuxMѷڼ}{zlO{[jd~8woZ4eZ 40&7-= 1;[֎67vr]d`dZ7jlBߴ䐏mˍFl[[AbAJB\e7'ݹ@h;m&Dχ:)e"cYlnpRD)'* K>f9Q])20 8YXJ!^k=F;t9آЛNBLF_t\W9qWU! K tmJSl!41tJ6s>"hʒ 3Ib49V-/E"; ۘ fBPIT*F0'l{MUooV5I)ƆCRP;U[޴l.#fCշI VVci%d47@†ф>ID~椞Ɩބ\rBQխmUK~s:;˪{u>a(h­6ΰM*kf{dt;I n^4j66 MDmdŒ ,}s#ÎmW)rKC/5 jERu6qgeLk񰍓tY$>_"6՝ֻ䒞{s C_V3w& X\{I73@o`ͥlnסB6wmx:ƜD+8`7Ej`l,,X3 1~ `TÕ+֨>i6 70b "-iZ @d,!+]\3|` MPVL_kG1.mq>416%J_\Vvn^"WZZKࠉ_U5Zp`ui*X=n܀Agw.[akchyִ.Y,<8<T.@+1XX-~jXs/Aלi qDI9I`G15^SGJeK/ZI3m+i x>WKqz\o[9@)Y\b v!shՅX񢵝KC3r_e}DME ĔC ]X M;(dD\1F+(RǙ*+UgWwX!F$k@s8)9hBv(O;1$aQk2陵$1ouj"Q~, LueXq)`)bU"% lv]8UrQtVDW,VY,`Kp$A$%wuE\ | rx5e!UAEj(7V^(6?s]ܦ[ɝXVu@F~(?Erݚ5?Eݾi+KWLe\f|w˺ _A늲o nPd+\]ݤȮ'ɬ'ɪ7euu*ʦ% v=Ի*|Xly+V`8oAv~JM+˪$}-_-_C˖IoEG)R{yjgͭ3^ Ũ .l~vCLNq H:h`T縻N^f!awo4;:Lf\`hcqFx^z CnYPHq󏡸o_w5bv8bf/xdV]wb i@G'N4]3M}}{2 Mk'1PI\a40.!V:* st9i9!Et1-yIvt2*AxFw羫+Jj^ERz "N]UUA^x!U=cnZDGHqMp|Gh2tEs5d5ծX~vR(X^]U7 0Hf @&Mh(G`/.ƛp]y8/வŊ~u!֐Vԇ4sCNT:w&gJbޓ GZ;=UT#N=LS B=ȁTZs;W! ux;W W?r_f =wR,Gm0‘>޹k\ 𐅪FWMk{P7_[][N# xF2wmt*㳓X]W}R?X*L`^wSj0U+Ǿu ->"{dLU,3cb{?\-͐ւ~.8'!D?*a*(-!᪚'$'X[{ę{3z5;8#`%+FAeҎ3BUWkG9 sՂЛ<RCSC@/Vj!UxT(?~T^ n:lγGýmbG@of쪜qUXa"@e TSwF*آ Sf!x#NuD~-nۈֵ&d0x7N}_ݫ!h}]>~9Jr9d洧jOzJg74^q|CA#af0qdm-AŅZ H LZiT2OYMxLBVB+ QRFї<򾴱gxZ_ Byrӡ_r/O*0~[x:DOUcpZ>kbוPUGOZڸV1/CgXUKMqpp#WCk _qUCu@쌿WV6e*ؒ d$5V _'݇oNk`Qͬ`gv`Jx̗JDŽyco;'߀6k @s`53$AHRƿ_MOcAzy,j@xSV+Xe+6P# z; G]o}Ijd']&#1O Ag#q>?eIɺDbz>SG`V)Ot^U }*D3]*ugW |Sjq T؊ tJL#`mڔP \L*ʻfT.0uFD'%*ASJv136Rx:rIJ`sG/la4 ‹z =ZRv11mSHo{A݆i^W& J&&b IA+C’!tm*UPRH,#fgϛt, mL0j"!+q];p׀ "DUPrYq] 88r!x9&2cs0&zT 0:&*=̜*@VDPL4 ^+u. :5QdN<}$L2}m@× I ߤqG|[y s+6pR>G<0zy+31pԵ#EQj} kCyo""@7 W2N^z 7n!XP>)t50D35t]t0Kyy;PI R} ,!]\>B2lp0dCAS#pOs  9} c&A}3ׂ_0rz!{$}W1];ݣK:(+9HCس=\`H& v,؄A(V@Щ=&Sh#r~>z9t?Sl@0(v#''T 9$尺k4@4"hZr$,0>uq ~^%e0,ښ[ $Љ|B^MIAs3E 2!I ~+PC^5?q2R<0>=N2eHTN_$_HYZEda0e ̈́ *Y$%֑%]dk) % Nq1Vf|P C-"?{@CA.LO`b℟7~"֯Ba|1ra~ 28r-W-nbPğR|# W8+z`%#WW8HT#tqij)ϧ%^Ml) u u~屄?kq$9~ +k1KU:*"<:yE3J:HUP%h`_vT^꼥^ ;ä9(7;# *q=5 RTV˺k9%`bDXV"1Nߓy'e}zqX(!?8Pt;7蹅͏S\W@.iiN͏x H2y9v{ -C>^Tl)hS ä& ?axa-HM@ӪqpBFW;UL! \>њRY uwj2Wi1irG@.2.1ELXi֫>-k0 -GX*6d&c` : K  c?쀟fB'0\J?~NI0^Ă%ȉnlǶ"]V&hTt^if$0T xY(P,ad"~.—blHӳxW4Jpu}.T/BߊC*KEa4k<̳-PT'bBY;Ԉ yBaЁl!E+I7$iɫI1#at'*j6&_wI4n)U)B@u_3q@ThX%^B*pNbwL/e|N9pq/< pjW+9F\Ʉf!tOWWwœɀZTBu~+Ȧ ӯ|E=Uk&e[U&J"tۿ&AFdT܊ X!T8n_D zUD  I ?ΡtMhJ!9KZ@\zF*b@ŁS-n \YDYf0KvtXW Vrاq@{ K;ZS-{lcrSTn* +G0J$v,c"nQUZ‚%wDԀa'br[%LYcu|U&7^ʰ =E% }b됇Ǚ4T<&5P,4Nk[1 /,SPb M&VA6<&b\43誢D=ZΖfyDWWFE GIy܂1&up㧘(3ɣrw安M@ ǵ=Oz_8tǼb#.QqՕs[Z{+&na.Xt$Šfq6qX&"-c`WI҄.\a!Ln)A| NJq-b?)1f3&(4Yd|S8b9Y} ZvY ^sOgvCI 4e2DA5y(IpTB wga@>Ф eD JJ&$}gnRJ?Z[ܻ @@wJ:<] d1*wƔ,ȖAǥ"t0]./;2wElͲi➆&ݙ}g|)4_LPNq3+ilsg7x\l~v֐DԔ+yfM\{i]]^Wk|0gd NU{.[0M/KM5O(sSqe]Kƺ[ia|@ ` F',ԷFpc:U_^eqi`/Lf',Q.umhz$NV}@}t$g/~Te:ĪO`[``[&δĊm{$Qjwa ^k͒3MWLp]}o*wPKL}pQRNE][ad4)s(NT7Pʝ/-8ދ~!ڍe} TBix6xSCߌuwk}+䮉~sbb *Cv. c:sxA\ҫWs>59 f߾yVVXc'!uBɶd4ëxC-P~|5^kjz%ʈST>I/rRze?-՛jw5;4ooZ; 8xG^X0ujD*>`3cw!"4Lq 5(s3w% 3 T60A#6͒S Ng8ivO0U%7|M7;63q>x.5X9 1#+:2!-\rOLB;%g 0O#RACL`{kG' }>0JBGe}*XoWWK "j-s9Hh>g5]X&5uɁFN5,ۭ3=wLTDzネG6w=[[[GO6ÍÃ^?#3_{R/w.>$; ~j9GrV\.|1bfy+{SWx61y5{W\ V ZP? zt#3LK^Ӎ]}I"́6_4+-ğfn>?kxxΓloʖt# $"n*Im)omm|A[͕)?)'ӷ+Zr)MSFQ:|HCռh5k'C!P֩4/_VVK*4ꏴKv  8شڑp3筫on5._Z}u J-G6r8O&j=0MhqlժQ8Ԛig$'1\3I`O4y/ |/[%^m&13U'QJ \xH>L\< (aG^G߰LMKghUh"1i"(Mgv"J ʃqsJxM) =ƖfJDN\v=SW9E@$ 20"s&G=^ L 5 Ki&<1(.ƽ ҥO42+7DB<|/6tM2ڽWB+s`Y +LQa]7 AmHb(ˊҽ>Y6[LU]$E2Lreɢ;,R (7EAg?Bѽ>0˸>Y4zd jK HJ ?„ +>.oV) e~׈\C99 -b{@ΠBu ϑ&%NY^|s<4;xe?gqyl"`-oРI5/&74g'O晲 U?AG9 j$.$hIC `e/J`:S%oBo8Q īcBl|ޘ/X,!`Hz;$qiߧ#.q='0`[p-lX)1{D;^R6]}׋9U#O,4'A] BpחwH1vOyq7ѷzZdKEi6v$H /0q 㹠<{U`f0&$zgh*Dzߜ+{L%I&eY[iI0#I pYtE0P-{,ug";g((M⸿x*<JH:.FN$,g*@ 2/]˚"ő$0E,92>76gFaOh¥j8F x,moC(ҮLEz69eiXZǚ!Z:uX%Y6DT?}L )TF6}|3MѼAdA)9u;AݱT!S@LLrSc(' %CE%l0dG!ZVOKd6jM 6H2&n^D["H)U$+)2 AXi[؉l篂BxKq&uCdhVKGeXKo"D0.YO烑K#scpV{9czZCݽfrIQwd3NS2TF( m6,( |5,c%0$b5F@%~*Q,A@H X<$9v0b( P[(-ӷbepKџ>&5L ֍=<&%F(\|*?RAPY9q=pLI<\ǖR YI[L 1D@}j{@FzwFqA[سlA VKشs O| ԕ#<xt67 8g[$xR0q pxZX_cd8+˰/6u@fKWRfK@;A}[v\tr +,}'Qv"?﷛F7vEi iɨ41+lhM}\5[L`ϐE.h:cqhe|!Y*Cy %*TS(02-ԣ]iLrn9Wha4 j7խTNԯL3x3`D|hlo+ P#Zy6͝`* cbEzoU{cǗ^٘3 "5v,<"lM4ЋyҿU6pj?Ucn. 퇞gaM0AN[k^Q2IЯZ J Kj|Ëڛlz/w% fPp)4' Hd.qhMfyC07/ ( s9ECOUɛ۩Wu"[WC`/ɠ><1kO$jZ8^E +>iW_t cvзKlVS-V~iR& ys6t:$ԐXPi!@F\03R2S:Br ɍ/ue;6|>-oOkզ ǥNm}өtn&*xJF-Sfjs 9xQlaG{/q6ĒAOU-/ժU}ب`^(ￇS\N V.7+ [ͳ&|l>0@^X ;x 1tdΥYf.eB{2l9N!rrO0 rޡW0qK?~!c[a wݶxHI,'Rt*BߴMu.öBs qKsZS Bq?!ieVx;VzUY-XⓃ rbe|O|5>JL-JKB?t;Uo{+/Kۍ_\8ҥ X6$g`|J*7e* jfE㻙_Xh<{X"a#ƂHkܻ(fA8×-AJ}/D_Y¨~ӟ_zK(Q7ڮ2eʜSnm\֐6] >cct7zW|D_aDv,d~>G|uW 76CERO0x纠[/f~ >֍U@;S8Bh]r6a).@Cӥ{X#tkWXLm, &S>-փ/f%{%~1:Nky<+2i?U;忰[j6ڢy[ᾮ2!L"htk7cM# fѳÙˋD.k,7łH\GnI3KB}mw_4^<-y x]ZoD F5iTeZ;mQ5|e:3s!@:!nز x,3u8l_dOfcZ`+1 RwZ-YZ~F]Ijeݒ |$9=uG8Fk#7U <|cD:s7tUo7l/֖xM5@,h3df#2Ɲ!=}TW-gxA@}H>y,#Gx@ җHqRDu;q.G2ճJeGjlJ,RjH|M\-fJ ՜A#7RU ,|hpg~Spw8&V5.qE6$r܏: ī(Vv)ЂLGk*դףvڭ(okŪuQK/+wFLq{ٸŏFmuPEQ `5@ztybEKxjnxJ>&HR%{  \zƍXK\?b♟Xl`_o#E|d_M,oZ7Q_Ebܿs@M_q{hs)7lNًO76[7w67VcKut@ϟV9*kYi~f}_QA$(aO^::x9xrEFb| X\~͇Ӓ@e6U,f,֠JjFKK^a:>s{s> 7| ?f7|b\vmwdEe=vۋ[ubƞ7pSў‹xз-ziPYjmwl4ʹjH̊d]"̀fW׸k&>A֕˸Z+ m0"5|S]^Vݟ'>S=Oѕoh6@¢)M@9\OY$G Zo cr'`6te\fUJ'n?8Lo~7Et}ğGYQNj`GNv#׷y;gf 6m*ʹkA #糙{Y.}<MbG)˜l11.;0oWuq~I:S>]^^d9SqjYʽr |O *-pwf1t'09LC; D5QX?pJ 0@p:JE%\cV( ;d}3P)IH<#܍ħ\,)qMOIo!{IsO{ =JLYF n4]OJ2W}uLVe;+J~n]H+SdS\?$c1Kk}Z;I- $^9P.$>Rg~Vf5?<G~䘨vw.xW:#ܴҹT! l)R\g XOS Q;[ps2yo^F3fJ![2R V7g>}#wք6؉9xogX|djx  yxBdN-A5GNhO/ { P3. J#TgBz4HSwo<7vmF|,_