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%/qm&N]DHbL*ۊ?3uNf6 `0w?S6 <Ŀ1ݡpWADnZwCGP><Ӷ$5PNm~6Pa} pg }ٮڦ}NX=a>w e{ |`(0z}8 k?ܺ. vt){ tsnz3zÈ:gm{X {=/ '=TؼcC~w34߷< Ԇ7t9ZJ*r5Cho8@cܺcTC)e8`2Ū+x HI_$7eyX@3 G_7f )e[`_x!Ә.4k PvL*b 4T2HPH^CvOh;F19gSp^U`w։bz?4OwB`2 kНiћM6- E%SӯPeeofG4{e "-1qVg5TVyPp_ngKč-Ul6h s{k)`zrx{o Vm6c9UD8w:NӚՋE6U G8[^{яyr9pjCߜfL袘й9^AKQ!JT_}j[A;&'[ω8lꭄ b@U`<->Tvnxuxuѷڼ}{zlwӭU52`w׭g`}s[gVsgE0=>v7 ́u方796z1q4N LڴZM蛖޷m1^{6tKs{=]LpKb4FHIh:;h y҄H0'H>ut>@d4k͍NP (W$Q`\߇Qpaȑ_ Aq ג1R;[6[[~2Zz~@<0B(2mk+->f *$jNƖK=BDfRFJ143:NJ$;&Cad0ʼ3A>0:]o-jikK\K7{l;lodv=0q,)vH'`S31#ֶenÉ`-ċ ;4lkV9=EEOk|g{ρ̂NI?-}_; -"=E@wz:/1 ̄T`N*Rͭ*kR u[vvέؽi>\P9F͆o7jK)[ hn4 5% }7(嫈@3aaI=q͍- /:g'[۪tD[w6U<<3}0Pxa[ma5]՛8;UtA;NBmw;@vխ$oillB 63@}{)0%5AYFj{R*^j͕ԊRu6qgeLk񰍓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܀A{w.[akchyִ.Y,<8<T.{@+1XX-~jXs/Aלi qDI9I`G15^SGJEK<(ZU3m+n xUKqz\o[9@)Y\b v!shՅX񢵝KC3@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!kUAEj(7V^(6sn6q H:h`#gN^f!awo4;:Lf\`hcqFx~z  ݲt}GX5i[|A4vc`7!N[vMaIij+Ȧ8vbKX4maI,34EzP@%qPZ`\w̩i xWX"YӵǴM&qکQDq;&iv$>a?\u+{ QHu32\:uU^\UUy{c;Њn+-!5q;wf]xN[tex6,'אT6bQ`zyY AES{{23u_: 8fcJؙWnZ\N-W4j^Zv#~[!SC1-)B֭x)/fʐBО(P\ )I7Pt4އ#Q7tw}\/V(Pb Sۊfߘc@o\` .:&(C9>v<$#eaVҩO*cBt>J_UKU>c(U]ꦔ&`V}Z|Drjx쉼jU43.xVB^VW]1$5Ac,,>#"f@RE$^xP14z`ѡ/ +pX*r9?Y3N{UE=@s;7FԯIG'7&q,uShK &ɿ$L_3l_) IEZgVԖ9"bG' $ލS?W*y`zW"/nens9)ϼSe >q>ߐpЈc1 7r80&nPq`C(9~sp0(@Lãjm`VaqЊçЅ (Wv+fK}yسx CρK<MI\9Яf7Gc?}o<io}@OUcpZ>kbוPUGNZڸV1/CgXU Mqpp#WC9<5P@k: `v++~A2IBlI{ 2[f+/#7Hb(fqS;ADBW%=5W~fxh ?{){:&S#1<<Ǩ腿WNyS?Ĩj؅u÷!ĞR;mhCjUOjVVVbkUԦ2|AkOSWhDtRr$0hklWyA:Ck# ՉM)G,>q!F,Pљ3.%e L65qwmvwidga"2J ,,~сV S e,yS~`em fX\$dT5|a.ПUh Cn1C4+Ҝr~'U_!?\o"g8$XflN&Dj6=F P@B(=fkX<¢A'B6̧\>&TûGo@?IKZDPWm*ޥ}. x`hWg(c" 'kw:V6w<5EE\5n97Da:yN=^Z6~"v0=> ~:xZ GayTi|{OdpZ.گZxbPS|  W8+z`%#.R8C#ƌJB/POt7bR߇SA߽XOl8$9:*E"D95ı}.po&(0+.>h#x)Z zМ%'jlpiW[ @F%">f9u;|uy,F~G7I_ʓF xRc?dW<ӢPpl*}st4hEM/v;p ML|=WuR/aw{{_8AULoE]` *gqcdݵZ 0zHR",+Bp^ hG<3>]$, S({W)a + 4Gn$C? E6) WatO ^Dv \0Lkf$YJSw`niU08"RX|*C`CIJhM)GĬH:;{B5~G~PЫ|4# A"&SUD5r]#K^,lf2j1Y0]kXBQlvO3#.%?'$YxbijDJ 76c[S.+t@4` *CDfs:C 43S<,vC(\O0H2G? xDJHKJ6I$Yc۫|Ti>n`KFt!Mo!ȥ"L05dqk`RzW jĆ~1h:¹Ʃ4 <ȫ^qp#'?]^}Ov$jQ1 QIՇ &|OzMTǮyۖoRvFV}*j5!O֞fD[է`Vۗ/ƺ^nuj:BŸRP:q 4%∐KZ@?"$% (3-s!zeUݧZS-b=2f f;̚a0+鰮@xb_6O6*AjvRZXQb妨UF1V·azyQ>YƮEvݸ Ll3juO&m#(Kw! «n&LdM-na/O{ |K;b3+h,xfM쩓khYPsUiWrbf_XV 7>]6kk'&VA6<&b\43誢D=NΖfyDFE GIy܂1&up㧘(3ɣrw安M}Bv ^[{]Q^0Jm <0W}6;1}!2pY6*\N/PP^1p}ù--= 0,sH:ƏaT8TŸN,mgU1ꫤzib0ːHha7 >d%@hh囟X3C,P)UU~c-Q/9m '3;ѡW2 }?5y"IpTB wga@>Ф eD JJ&$}nRJ?X[ܻ @@ux#|cT))Y-KE~a]=_pwfeʇElͲi➆&ݙ}|)4_RPNq3+ilsg7x\l~v֐D5姫ÊkC^mZW )GS՞L RpS:Jgy}%T\v{WVlچkX5_'Ň9@  A Q3\qFW@uj$< SSFk:v1Ϗ(Q ~2=`=N bmT&W=zLHFq/SDT9=ۓq8+J7b>ǽ3*Ig3?g.x+ΧJ` Drdw!V5:ﾻ'q&xzO /  >e:ĪO`[``[&δĊm{$Qjwa ^k͒3MWLp]so*wPKLspQByupMF< "q=|Ύ2hmnF_vCe+wn)^] n4-E@@K%k;5OYGz^{e5oN]̰{y=[Aeb=a,Cz5(3ۜXzj&f=%:Zv˲JZ?; 1?[g9* @`R2'WnX"% _<44/J /v'=<9tY9_ܵ_ \SN3}!ɛ0yҵ.!0:"M {ǦYrZ|6'/fff<${+ǹ?60c qV=lbzkJ$AD3 FfH!'DmN=izWZĉ?&|~;d'efߔ-ZHD"UԛR)o5WLRhŦl4AO=7F] a"Yڣ7Vլ} TB)Jzo[<ZeZ^4.Ш?Ҿ- ۍs'h(X cjɫ؟78iu-(H#٠& 2]3qM5xnt=JxBgU: "4&7!AY) yhaPS 'M<~d'aB/݇ux(_AK<X\p<$ 7aڍ'^gGYY3*4#f4vR&P2;mv%MY6[,0U]$E2Nre;,RE`7>ϞCѽ>0˸>Y4zdnK{JJ „ P on9 E!Rޅ̔;B0q`%$r)BZ`PsL3BDL~˫?O_}~oGV. e~׈^C99 -b{ |,)@kNBw ϑ&%NY|s4{ E&Oʫ[O JAjO@oh0N83e~8QrJU]I/ .$ާ406ulO}ر˧J|]RP e'pzE Ƅ1/^orBvId)#z='C4, &[lRcPcvȵ ld9sGtYhNú/\ cx13Coc@ylkY,W<ؑ#]o0<'HSe_xLJg7ěDR)5sXIP(.+}s֯(1qE@'en%mg󳲏$lÑgMDBBM:֝h^;Dt>49ɫ0-2ABҩ 4 D+@&g?Sb?0~ք)$%Qol %(:wdq~Y93wU }E.%U6R ei3 @we_,ҳ)36O: F*թ3:dϲq&H|q(` g`H2l-&/ȩء뎽B )ӧDbe҈͐E!L=))**ay%<ʓjA[I>qV,x5d6G+m[ErHn*G {W¿I@-Bk6sWAވe!ѸXsѺHL kpقL4z%27i",B'|NH%#Z- {;eq8#=Ǩ7ݓɐ/g+(rZ:%KoQVvg6? ^` k_h )&DaT'lYDg+(CІ!+PF7JΌ# ?$V(ۈm;1f᭕[^=ĢڥeJ@OYzTp^9IS J`ސYk~K&YJ m0:EjjqB]7Z߮5jwi#;qyˠYå@; C[yc6uו"<ٱx<색64 8gZ49CHe e-ʰ[=2qϡ-$RfK@ecZO-LUZC"-;j% !7I=²WqkfH`@nr5Iqܾ dpg}'JeB5yY8j]L"NP3dܞm'r6N9" T-hn;X >9s׳?EK3} v[qOsez o>)E~2e$ݭ f8(A?ag#PVlME9Hh0Sum~l֏nt߇iֱf0r8zZ8] Hs@;RM]zGT^*Hu@I趠Pέ ^C8hDop B֏\iMh>f/\l;E 5^AZ\*Y<Rw6nQw6ncڔnU>i00V~ 7`Aڒd<|=XK6t-Enm!nif*m>nd["{jq g+[3D>H`,xeO XrZDᶩPۛ7Rۛ>hl{VnV&ij{=WG{Vg&iߍY6?Is>n说G(8],tX6ƁdZOabRhC؃ȡ=o9-kRr9jtq\pt)^ff^f,՗`%Zx@|!AU4\:s/[(f  C~*`jP;Jݵ7[իϏ흿n͋Uel}۵ouwStQaG]ٷVy6WR&Bi2{ [&R+tɣ pۓ4+QҥOT낞-q؂0|7=ބ4\&i9 H<@yYI˸`wW~Px1~cB[m }H0erwQ3FQ.n &˴%~{)ډOcMn W=܋3xodޙAʮ.tmZ2 oSy`B>R&A-B,| fb%{b^}#yxѻd*S,bO6D| KdZ"QR Li҃ٗL0. qu]<&.*"S>bo|< ǎ.Ty {G|e25Sx;/$~yh3A'^MΔ&x[0S7^2bYM#ER@UC!* μ6ʯKO#/yg"vqnjdZ;mѭ5|e:3sሉ+{^ 3[[!xT/giCOQ~OH776oHo<D}roHS0(%zqgwy?Yo4ޕv>-y~ ezÇaS}(INo6ot^SF9zMq5s%^o8P*>=y [|'2Lmт ,lv8xLDǑ/f9~|[H ģ^a~ NgމD#8B6R\LwckFzužXt V[EWK`C saK=RznC` ,|hp"K݋y4ɦʨ)v3q|nM"'@BʱNw2=Xo k6z[8@uv)2B5Ue2^V5dE0iJNUB6-~x&VzT'1+-3^F/jnװD.gMzQ3}Mzw.+K?H"pmhq؍VK\bb [ W֭d_u+ٿfojoQ6{zR[ Q, Sˬ[,V#|ءmN-~gc{Cool5vC@U ş?]-2vs;✠)xVƜwRy ,rt;Q~ۅQÞ}{={#V[-z8|rǙz73됏炰k;??%;/ݵ.sNoW?ߨ3Թ{T`Şx/otʪ]%_<rZ""F.Y;3UE5.ԵV^_!e\ qdn,敄6J` \./+KnҞJV7W4 A[aѿnoJ{`WN%5'98<尮f*-#oMos&`6>9Z /c0SSVe6I DNv#׷yAMzJk fTZ#̒bO2as%vb1A>쾡?pJ 0@p:HE%\cV( ;dS3P)IHҾ4chǺuИC dc~ߕy)v'Qxًs/oЖ@X K{ZPQPVԻ@,&1؄lh $ Lp@|6Ϗ#߁p%Ha)^3ӆIrD r/p<8i\u߿2vmFcY,y < PU׷v[͝f Lf\eko46Z$>JK~K>hZR hg#[[eQǽtÒx>"ܲwIh/U_Iiɱhb $p^{=q/`Vs>t;l2fF8