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?lj5lͮӦeiҙ٬lѶZYHr7%I:{vw2F"AA/zQ4vwr \2O2%2ƿcYRd!L m[N=kLa?d{ܱi34zQ%s"ro4xߤ< 2Yl`ʣ(z}8 u?/^"'rٮ-%-=nFW:1`K'p9pGQBu9ckȴI5 T͐B?z|TK}2kzJʖ"h^4ˬuV^= YH) S+`.'!Ūx W/HrRpd W$-uc[͒F3ɱA' C͚F:YX94i0wL kb"䜨.HPeHR.Qx'Vј\H_P ig>1W!Bz\Ns7uztwߏ.5- g^ـ-Ѱ݊|M l l 0c9ZaYֳ߆H*  G6 Yx. 9  oJ@K0;g ̂E)Cvl/[IO4ڃ|U晦-By~s^؜\t+F!QNI!.Lr܈8pɤPM‘ 7GrEY/`L3hiJTle4Ro|DL 'Vu<<&1ϖ]?d9w@̌!fpZ3(kt]~j_a :ӄB #+ "Ksե@kZEarOz;N]0iȷ}]>uݾL:`dPR1`T%Np/5[hff}? WBIhkr;# *Aw);W2if MMR>A*+KJ+&bڊਬ:[Zy.?H2+)fHh+YIBYJ@6;Wd^J/RFȪ*K*X鍅L!+V! HȊ4BȪHH3XB!Za;YA%1a4p0RLA !eӫbub  `K͢yPNژ\('*lp#r71 mA$aH~!QGy}wj:LuQ=X_^;ՔJ_/Rc01I`-qJV?f`G?0|0Oem<3-_77XZW$J2VefvB5T 2Ӑ2R!19,l ]ޒ(Zp&FiZ XG2Z#뭅@-ݑZ&55Mmެ,S76 `"vs;C0q,[vH'`S3嘀#ֶmm`Hl)?#* oސӰSլBk{{EOk|g{ρ$f1/摞E<; ۘ BPIT*FP6ڦjfsKccC6 H8;)ٛV1Bl6TcTPmh5^"HAl- 6Ԕ&hPʍ|椞Ɩބ\rBQխmU]hƲbVf`:^XVjcgDP&"54 RA4n-e 0j66 TLxmdXӋ%5AYFFj{W(rKfseR 6qguLktYդ>[6՝ֻ{s XV3sQ&0\\{Ic43hQgͥbnסW; 6h<di2pl. EZ4q5(6  E &pJjvU -ZcA 67lHKom/ YBVyV4 ,`/AGZ0YIYŸZ()ݮ* IZsYʚiRik-  w~TNS1Btt_(" 0:4к"]JӖ])BC"Jx@6K9 %:'#?r\pUOUK-M IL850]8Rr/ˈ]qiԂ^M,Q-2Ja9@RS$B6Ъvt$44W愵Ǫd;gI TIL)2LXRR0lAUWx 34ZAFRyH_ݑ 1"^libXcDž;DXO!‘ssL]Es_&=6$FQF.UcY`Eh8˰RR8?tUU6tH٨"e 9C"b|w5t[# ʬ'/+JKpī--ߪ *ZVC1"BJ^sXDqERޛ-nR^#7MpJVwdָ t]jKmw;?╵ѝ꼅{WDsY4o޴ݫZ2{a./?DWqn[[r7]v Wa6]u#u[QuSVQR7-Y\빤ޕ?WÒe;JǪͻxVUUI^ 2[z79[l-[&K睪GWYgQ-A\1↘3V0!F0{7IL)$ISi.Oh]~꺲n3`Ųx?:klSh5|g!#*ߟ{ tD3e&wS>=u}tVNOeoSTS~>WFo`82 e`42OeuX@u]k j?J%3z&AoM\]J;34/Om0<3OHtY$Ef-P-kgP;[[ }୭=D/G X4 <1M3J:ImڈN@U/ؗo7Yu7LZ;ThI%h@jInDV-9D& "bҼx(U޴hDPBˇAd]NċꙅG3Q\P!Z}IU@2c{_?]-̐UY?CztAI>ՏwpJqKrU-t=cI񻂙| )2)#@~bz|FR4|/Q>gk"vε?y=&5"YCC*G^m|E|)@|*GNj9 [(i3vRއ6c#W??jgLa( 2@٪^N;NFbYȃS](Qf#g*d8fܰs2w!`Hs#s )Gc̊]xژ p Z;Rx8zv`3!Goߘnh7iTtskI} p,_"'u~.7M@L, PVB3$C Kx;ڮ"01YF/̏ 7? 94u,M#XyBVM)qKK@j` "D.}+BZ88_ɾ?=A~ &DpIؚ L>lA{FQ@ƒյP$-!湵jȫf:y6[fPCqvi"T&&FQ哽 L Nj.&  X~'g.Kh&0e`fDLe1#!BR@+ YAIAL0)0A>h(PTJ7!ٸ!pl>Lrx`vCW}'Du񴾢̧Q2r0͂\Q̗))SO%y%#Jq髹"2)&dJElh`tU #A̽' E`z`yXQ7vD*y,'$,:`ұu7/?ob\P&vg[wRqscBÒZf` ӣĭfg&a245f-ͷ?Z}=|Ӄ6Z_W1 8$y)ݠV=SH8pF;{[.kEYt_(B!l5R Ss̵%E E^ޠWPT]n->v-1tTqrN3Nԏ5ӌ&xukT{cĐꯊpTExu߰$NfB:H L%hpv`6 ML|#S R/9a &ᯜJ*&z?p?N/gL5U\@u#j[J F*4? y!8g#-1ѸS"k+K LIUz%Ljk84` V|uY: X]T{%XIbUFQ·ax5$vls&A( v-fPQD^l6Q@l)K{= oDFKBZE(W=&o\mH[AɂeV:5OIx-v+f6eqsS+؆u`m5F܁CDŽ~UFFKib\Ǿ?6#[1U/rR,=|A>-#}W(kkokkz DNjf'V}\8!y_ ea4ֿ_p?}wG-8A3WW>maq^Y`Cw6~jšr\v6Qi[Q$ >ppYD28RC>ǵE7,Z!"H dMVp+|9YZvY (`17,7D"^h‹d =k 2]Ewga@?yФ eD jZ&ė}״nR ?Z[ܻ @@J:,] d1*vƔ,̖A&t0]rWܝY\0_m'f.imҝۧyƖ`NKcx)`qE7B=# y~ # FQ `{*g X2hR:ŜSs@(eoq+yMIL;` iA-d^k*E,y4QhᆞTqS@1D_ C͐t| ]QchYCG{.)™U܂0Wbɷ>[Jyխx7qr' E=X\Eړx졻yul``VhTQ{!`pX eb"`0+Ҁ/,敞i҄?f%xw 辬8]hE u<X*$ˋ^Ӎi bϬ%Fh6O))]~a(8ɦ \%<҄G52٠hq$Fs%,&Q]=s=^P2X߼Cc47܂'xx>y֙3pULMZ`gd NUz-xץf{¤ȉ\k3ۜXzj'f=a)y`;ѧ* B{b&|<|N(L8L\@wY *}͇}cʿtCo2%xӋ@(:#ٗzsmlI /e\!㈅[{GJSKg Shj$q{t8DY)"UCvn> ĹC^rI!,6UX0#>wZc&TzkU{{u)G%!&*sy冕~.RQr桡_ѼL*̓dHvϥ#ߒXCy 㘞>cǟv?đkK׺t"iʠ')3?iH0~$=R?|5[^o|F}kr{ 1#@09@=⃐hGL![ Q AL=<?n{}t0c%tZ֏P?RzZ~A*zrBU}. jtxר䬯 H4Jrx율Idnu(w}Gez>oԕ|<|5{W\ V S?3%K-ʹ/0ܤ_Hs C/=1J8's䢛a5Y*cqP4&X$l)aCOz(Y%76U$$/ˊ{|lY`ZJy A83 e4<ʒaS-҉X.\yA} {<ʤ>Y{dj[{HJ p >rJg y5)+5?v݅`" hA u gA pς1םo D7_9曯o>oӌ(\kʧ=@aK%rLyрfj&zׅ\LazAA8~M'M? ii6/7<'>CuhtݠTHohXvr6)1v检^DKKz̧.2y P~#&&i]L`ap>2eNī8QG9 z]IN/Z)ݗ/i`m:#_uHerC-LIx?Z0&8| /+V'8 ioך,N:a?.'wJY1[`v+Vg#6 ,zS Jyd [xRP+r S/^bk=BZdKyii 7^$oA AypOR)5sXS/+5Ws_ &YٽYI  PhtS.g@HV?ںs Ǜ׌i:Pq1x.(DS>tj qzX5(/t;kBPGioD %:wdq|Q9ss3l"<MT H/ԥ%wH<7ەg<d&UfgT{hΩs:Tϋq&|8HH2g`hB'ȷ[[M_S"C]gIR&| 9%(p.qذq=]ԧ?bYY4Y_"3rf%⬰.b: ]-!^#r)8C/>v\tb;6VX%[a {Gpjt UrigUޗJC\D@C;V g٘ca~'j.o7vnٞ{,9wZ|)_X%kkWڑ0-Ylyڻg#!n6ߤ5]a[#2 &Tv{\F{hmM:RsƑͥLmъ3THۚa Op?B -Ǣ>%[xBs8fr%w/ Ea2u/ƀ |L d' LEe!YE@JC/,ߙRf0,|o[XҬn0V -wȽb 2nJ)avO" -h7ʄ:zFT+fn4PNՈc"^^VDzYIb o/x #Ӊ KscU`5@Z[X!FYcRs͍bό[@?@qӼHS[h >@y SרW_A1Iž"nlٗeod7fo(Qj ?Tz\'8ZOq,oSόsFXp[SFcKcjQA ?v$4سkU"C%qJ. ?Ko*Lj ,ztH~E.|~ QzxU=T^9vHWrEf,^z٨t)st)3k" s{Q2`6/n|\vm{dE][~YeNBȩ c (O=ǭwNUYQkxAsQ.UKTbVň%x4H<{5u]WwqU%Fϋ/Tוgg갴&KV4371ky7,k^!ѭ1/s5h~Y̻{QMj=kpiSi] ZXg̦޹^VKU( 盅l_nPi#<~ٙ'eZ^hc&aՄBe: -XS Q(}H"}OBT-> u^@޷RӪlp%^i(`Wx Nq]ܺZv kt5tR9YtwS $^;B.x=>S=zi~Kq}SNS ݿirRk;r|#PtrR+i@ёkR2FnŤy,ފ1bz}N7w˗'B{| Cu _dϿ'2k1T)&YPZ Y r r3$=ZDY]R1nctzD9uRX@5sP4IiݲI䌝L ;EҒcOӉX(u{c!:cAX4X}:42ς?T