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%qc7Wc~! E ,|cBkcM:V!0a@^6͉޸S1B˜Lo X; I5bؚoy]s6P,>Uch`EJkp>`ztU$x)GdN,c 53 =-灆LcڮfP@yt`:vP9&}C AU zf} >^YE~Xc:^@4?=/Դ*}n~;o5iћM6- E%3ӯPyeogfh:[%@Lk xL\s> l<(?q_ngKč-Ul6h s{k)`zrx{oPm6ch9UD8v:NӚLE6u {8Z^{ُyr:9pjCߜf:L貘s>2-B\h f̶"OM-O[ω8lj b@U?->Tvnx-uxMѷڼ}{zlw{[+jdq޴im{˴D=+9ٍi`Lon[zzc}{mnлPȴnL{لi}?!ۖ3썸hmC4ڃG3MCkoN.sFѐw(MD#}R䩣"YlnpRD)'* s>f1Q])20 s@},,%z @/Gvȵ`by}srldT41}엖Ls \~]"de`{0kG5@?Q"U@N5ivЂ g1lpQ6Tus3r_kA0 wT]Ain(iu4}Ǟh3uaDa;HiG0ݎwFeq;1-ve6TGڕwIwt}!͆&NJ-lW~iݸvb\4 P]2AWRf 6@ZdrCoBhD= `2Z7B- a]72@;hqLmd3?J7d?-5[iIb48ZZx{RH] 2R\JB A&H\ҏd?'S⊅/KE/7ay%2YfyEg.`b7ayd?/b" 7`y$3YLq1Gcf2h4~-3aTA `hY =@4f؟C-tY4 *hSj; EL72!wP/D4ul5D X<k B ҃|}v4E)2.-D\K==HU$nSlm0k<? X˴mӯ6730ƫZJҲ꿦 3;kvz*}lEH)ŐL9(l aޒ(Z`&FiZ[d"v;Uo/j"Ps!Pk.)NvB찝Yaߓ(cLE%8y3r .ᶶ-sNC|n\M^D&^GTܡasg^ yqy"}8^[=XD}\e4Jmn"YhY-?yI`&DbsWTlnUYol:$ SunM ζ1Bl6T}PmUo5^HZ@Fs $l)MhA)E(,m KNʉKnlMY('9;V忴7w!ڪ9X"̏ jCYm ߩfC qn LH4(n-m>h&h%~+ fcjKDF],) 772V"T8RCl̠V|Z-UכiwvP;ʹM8HM%BmSi(@.陂71e%slH ť71z33 u\Fqvq*js'/mL2vCkQ v|"(͂50{a7I5bZ<ln-i~m,fd @Zm٨56K@J4 #߄n`3Hך^s[O&MᯍFIן%[ȕV>8hWUM&0};*u]t Ve#577ޝ |"`>`ZXZ7{5K&=mR`1g1:dc4c[g`AGcA8\s,%mBΖ&a$&]eyǜh.zYNr)e.EciT M[MXj3,˴}`L7ۅ4C. wŌtɄfUfgI TIL)2LXRR0lAQWD 3$4AB;,PYy:; 1"^苓bcہ.jXO!‘ssL/JsFQF.UlDzT]\bi F <-fU)R[f煳Q*L EjEtl%TjGYO_+qWWĕ*W[wyQbpcEls14ldK-䚋7^HEb/_4$m YY>ܦR6W%)%mJ,nU ds$׭Ys}Qd_f-eȼ _] 2XWm7|vRn'n_2&eDvݸ>Kfݔ>KVݸ*˨1W6-\깤ܕ'?WÒi[Jy#sJZYVeg=$y%xl|l92Z6Mz+:J1 [;nn4(/Fqb˰b'iVŤhJXު [[Pw(-KwZ3)nw(根}Mco&=vع/o+UkDܻlЮ m 9L= = e&'1PI\ai `\*C@t𣪀\w̩i xWhX"'Yӵ4~L3)Pw MTClO|:~ Dtf(eAI/ e݊' |Cp/ًB/ %% }C%Ixo؋=@.\WGQ_yܵqXQPnb mE݃r͹ L7~8}E`9S:*#EPNOM驢qaj(O޼% G FКCw޹}(m޹OR}ƍ~-~ WNy{J773h!` #;}rs8>3B ! UW /v߯&Gdd|K20  Tg'j!Zh*¾|?)U]&`V}Z<"?vŷjU8'Ik mx-k_wEWWX$Y|FD@فz VI)Vq$ch1XZ΢M+(_:@@uI?q nWu䎡s ?Y3N[UE-@s7FԯIG'&qO$ꦠ'P5p9J@ 0zG}N$g jzq? LGGn\+/*kK^I)/JaQ ƱzQDKT@ bl7>|SZL9QN0Dc8n9OOai1exc(y}!1QT?48p >⡏%kGE=XS$ڕ|]> B }(ܷCMWLk#ʘk 1@$[8S=&7å O-8 *cq^]/AvOR\|ixBzǜ.߫W#?Vb'my-#`\UhNy5 Y1UC(zذ g@!ڬ[͊4\_-e=y x9& O:?N'D!”4c$oZP3^IU }(N(J$0,dK#I(36wJtj}1_uv)O>pT9! d!JII#C'I`9>2 uEVb>bV:븄MY?/X|0,ښ[ $Љ< &oGp8 @yL|HRB깵_ ԐW͏u|̠OLJqv.eL*F\)K߯\Mff1 300O\LѭQEbP"h٘Y d*IRY r J-la5a& U@CqshҼqs7? ]u/,&Np.i"4Yɩ'x{OdpZ.گZxbPğR|w"&pV(b`C).}572AWKFty&RD]ĆFWU+'F2IIl"w 8Sq L`t\j8H]Dat,` J*h N)AO5sa.&CQia ܲVvB }Zl⼔n-)HK:#D* &д򓉟*5X`"ߑA5O\9_弐g񔦚d󩏯~s%e_G~hd\QNp9w_LBo; +=u+vOgq\$1:C_Bg'QZX}Ĥ%.̊1A?aDJT -K4S~uD%x6E8%RAΒrNOw^]K8McC10?W-ì'qZ4T>r&?좨 jnA{Aѱ镉o[ 1L{p;UPTD@P߮!NʠrWR],F/fIre9BUCZ-y<(듦WE0b1Ł۩C-|i>9lay䒖~AI"/Ǯ}o<eOs*M"-p C㕸4D?Ba53X ,)Aӻt7д{zQ,>G!0S!JO4#bV$C] #j3>-8&0 MEF% +mzѧy4@[ Iט,㮂RC,A(;LhFySĚ#-O,X2MH@)~l+reeFLAelNukfzRC` ŎrŒI&51me'j)hէIi֯ yv]b`Vۗƺ^A} LJj:Bq(|ӸqDH䃄de}<WVELq}E1_ӥ!v<ߓk0+`h0`V f *Un4hcp7lviZ+5e-|,nMea|We<7T rYjZݕb rY%LYZ}u|U&^ʰ3=E9 }b됇? * AkZf&\U'\YS@W( &'^3 qz NU1.ytU#Ny+Gu{o3߻yDWW&FE GIy܂1&up(3ȣbrw媉M@pp@xnalvb'KB:d|1+lvV> ǵ]\Oz_8t'b#.QqՕc[Zܻ+&.a.Xt$Šfq6q&"-c`W՗I҄*a!L{n)A| NJq)bTbb7$f PMЯd=kyd5ziaXI<>z6X$0?'q 08ݭrNUȓ)$ B6\Г*.bCŀ>$}CBnU*<s֐GƞKJ>t&i%>ũ+h ժ-ffF4%9l}~c'Ix܉>HQV;d(G$@_v]Z7W!1^D4V7 p5t`xjqڕb' I]M$gGin7ww\)XsL[nbvuFC߲Ztl+TBix6xSCߌ5oWYIĮ oеT&\\B;tp_"[;̹W/|R?kB@K{̓F߿{QVXc'C :d9t-;P~|-mjz%ScT=zy;ng77?jz[ߛ-vhLPhm}+$vAz |幏Z܉_܃`3c"r"ȵ4Vq 5(3;wI 3;!T60A-Pk&5d"'{ksu&*y劕l.RQCkN2V| ^g/h?zfow-3=} @-'okKgC4aO>NdCxi6]؃ϣff?/%;< +ǹߕ6kmE[DP>%"UAH4}GQaBrD*HH `7h[5QI(5Pj $:[YeN-T@V KG.90}&ݓeq=0X:#C_=|{zXy|k>=~xBɌ+#%IH1.d%W0p΁^\b13B=+<\=+. +Q-(q]BjGKÍ]N"uN_4] -ğgn{;+eq{ef/-+FHD"UR+SRN+s=M]FQ:|HzOk5/ZPaHe`(He; +UE #Ұݸ926vd;\y[ _G݂Rdܧk \Ai;l=30Mܘ4hqv̚#W9'!}Fy"-,j&)F%%/#es`CgúIMIRȯ +8'#w,=g7ow죦3"4fbvR*eP!;mpv%MܱEhcKDuekzM9"'`.)+yX"uKMx}tG1/H_=~9}>pm`4'IxV: Vg&"'چBhTʚ8C(x0c, @AzI•n'l5t!V,uE/0ۚ<W[.93xYv!bf#[loU./AW2gfEѬ鲌\^2qvT%+2bC3Ⱥ[f'z/_mit,II^n"Q.GA/(DлW゙\`GyL5A-z ;G q:0\8S?LbSǟ_ǃWmx˰MQ(FLi1]l!#Pv Mn/ǒp]OHУ'8$sP(_C.QcGp]}Z ۹nHۆ;oKܾ |xxY'щ gP ]sIS2*]^?aqQ\e6uS0#RhPjyƤ3'Lم DTlR~~hy4zൡ}F' LMb0H)^;vTOG*lAopCqh>_73+VSގ9 x,ei;|I 9&r%Ds VJuj#Q9K l" gNGȓf#3.:K;%̧x=k=M|}2"7; d }8+/qPaf0&$>gh͜5@3Zߜ+[L&I&eY[iI0x۬l#I pYtph0!$YhD4lwB{Q":Rqq{AAU-yDC9 PIYd_:5!D#IIaB G{8>(XݻM> aS)?G2/~xbikTz#kGcg8QAJ$>|$ 3Rlzf3EGYolЇu^R O)DfYNt؂ ݼjA[I\>qV,x5|l(-6qIg:wN)U$+)2 # : i hϟy-^G bE"2ͬe"3͖̏f˰ޤI`\2 19!·#=r#HFHpV{N>NQvͥn_y39רX^hfa)mѬFއ>*{kb4t>x“E on~,m1m yM%gđYCO%ʟ%艤]QMc#B 5<2}7W4K KgCF=DϿ ZSs8dȥ" cK)̝vZ&jج:>ihA4tAv~4qyYͪ6åv+xz`t]y uDH>O|,+2`M7M`BꢸtQP'%KSn ˛" 2qϡࡡU,z pmbԎKJZaI}VI1A=p9\2r#!΁C |Y|VQolF?"7Y/ԥ̈YViы1CLqqַ#O?MםBGC֥d`]ORsLo'q3Ui59GlB`sk> Yp8A8Lv>^cozt?.\ŵ^n%_XM'dMF@=h9Q#͙)4Ts[5l 0 u 0h7^ws`GhFշbo C~1eQs}BԤyȨDZ8,xx͡Ex;RC=~?}Aמ{c)joǪ-ick{edP\7'0qr/k&jas[?6vo^-f' g_#֛w {G`k/!Qj Qb:MR#PapX(T`}>8?PaT'eP5p$=HwبHP!L"`g}[g},:ˍWN76[7w67VcO{P4;%pe]R?& G?&oZ/oW5%jyԇ`*9|8KRԎY|Q!kj 8  w_ E v>z(>"S?T;Sk;IG|WFU ٮl;-Mk\(W|յzN.ֵmwzQh"hsamQ[Z6 1Ђp.& -gSJaYs{@*e9@ Ԯjܚm_1J?W/(<79F j7[zgcJ ?\C'-:@,@cEJXSK-]Dl2Eb{c1C1B& sSXy7}sEH{B^d;Vئ+"ixJu[vk:x0~Vn`nnq.w[VioAz<;D:]oe)'-~D==vzh5G-wkVM8*sIᖒ Z@6鶖-"*ҝ&-/muF 1g>d4A8w6A6BZ -*x ^F>%ZZxO.d>(#ч6[MuhIɶ?bGnVN~u`l_JeV+,Ӱs2l_DUCR]Z7{c8fF&!Sbw)!ϪHN98sԲRS//.Պ|L׸()q e/XJ4n97!^˻ω9]zTk(oIXe>wGEa)TCG<0-Se~bRnd9Âpv#KeDy!s/%YHj_&rnay!W!Ce;fY izz佱 ~tl}Uɕ%p+?+:Wu93-^Omx9ܟ% (9U0& zn[Cj&2khU.,5.Ms֤:ƧphB8u+,Џyi G :h`nƗf0aPQFlѳx/Uss>_~ mxpƫ'F/?!{Ldn4.J3s6OHךJ2|Ź8vb)`mZ^6lYkXd :^/65l'*Jsc#,i¹HDƢVaKX8fr&V8ۿszvp) H0{Wax;|Wa0! O0u C1R]eaR`w 6F0x9 1x9"ȹmBo7l/֖.Z Saz*d:[rrQ=2+emk #7apMy!M/| ăxX\E2g_"ohr!]z;).}.6{\`f;`g*9'J75%Aބ-5% >7xC/uK- 6בW')%}=y4ɪʨ)63-kl9w t@ȭPusGPZуo\׺r{UF&nɁJgY8܇,:l;/fˣ`z nһ$uYo]\jW=߉.֗v\\_.g3n}KH)Нdj6_X;Q_Ebܿ@Mkh)НFZntPg՛jBW ݜWbvE/(]a_vaoc{X@npQܸ- ~W/ygwi{·Ӕ@eU,fLJjFSSZa8pxK>7Y|rǙz7s{7[sAصf_F_s69|7Tˏ/nT[B5*C{bKmI[ 'mʹ֯ktʪM%Pk;gQUKDbV)xo4;H\k5\{2n^NxPSEuyYYcLycظ|[F?_Էp Y*4~~Yc_gK'dY7"_Ythʽ,9"Ixp?Odbxx>׊5ڴ4S5/f}aY2 7-_,sV,RƸ2o˼eumޫaY|s[ zS\&f| |O *pwfspO2as%vb1AnP/B @`,Gt|G򊗴+rY9<*Q*lwɼ%f,C4is7OX;I9Ir-c/)ғ{ =f9+Ѹ)( %e̾.5VJW2fܺ`W,E~Ifb>^ZtR#=4O [q=$^ٟ)^DtŌglVCi;-H Gm#!R7at/>W:#\ҹT! )RQV/ (X폵hYg~oŘn1>q}ÇJm\g 8 1 (K\ONe7fBޓkU0 }Ϡϸ_4M5mgN s(9uRX OبI9H䱥 QG43GWv;vg찋qK=d̒'?gH0ev>Ē&PS`}W> Ɓͫu ȍl_kk1K׀􅵶vn 8keAK;edQEpU^A*74jW ^dÊ^}vN^UBc]WlwW|? mq M_ Wհ6JzDv/?8x0c} 4ĝ&0zeѼ8|F™ !C跆yxAN&9+ 5 q>v{}: : 8ALIVH0<S @` &9Ƒ+Gc&q]\;?Y ' Ҕz{&w/M._/WOǃ!o4;:Aqhk\{E+55kY_Jx!NѾqOYC4 7k;hS %Xpjo&=2ݞTl{ 9&o˜NO%JgP8|RM7: 6NJzY