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{@خ#Ťn_Rh9;xI)RaYgf6$0 \8ӷG;``d#l w %rĿ#74<虶1rn\'M,3&?z\YX=zؖs`tU$x!PeK1[!Y4k=WvLK#4NT/h$ $/g9#fV_W}#_V=tmwV3iPqۮq˨~gNynh5hJ07tL ,^i(M+t=97|kih147qVkzַ7Aw=^Ct]0F\R뛵ƒ Balo-PfoL!^&o=gxwN0V25s+躂`sZ7 ׹셞Pv n4yuzcx M7[}kQwFFnycܴamG0k]3o ^W26F@h@d4*NP+$Q`L" 09J$-Rۼ}юdh\Fw-i  9g @jFP_?)su^W>~`-:դB f H"fE +Sӵ.& ager+~0LwT]Aiom(Iuk:=kc#A Da3Hia,l9m ]P}۝ir36LreTKڕwHw t͐QDumfC'G#sZV'q:5qTy;#S|hHbS\LnQu h' &/\؞ KҪݥ|# fǔ/=] eL}+t`ٜ/58Tn\)X1MUr +Ջ *s.B1 2yE"=璐dΎ+'^. 97ayys,_3ټS ,_MlELL6$s>_dl GP4-1$FkYo B/ C*#W-ٴv" A%f,M/ʑ(3ȘMB@[IҸ jTלܯ| .fb@r ,q(O jJahh R(e({zIji:x; y~BiH3 Wlnn[g`%+f3NKJ]1زS黧C(TCHɇfF'~ᐤd`] Fbc0q5"H?BmV,ji6kU Z͚55ƒнYYmSodkُdqՊaX%S7^@ N^fl1Gm*7x!F7g hܙ׬\c{H:Vu7Qa~x~o4,nyq`&G"sޠ[T-*)n!UfswoRqTFַkq5QV )[ hl4 5!}PQ!*Kfšzk[jk_Vs> uNEU7U/舖ZXV}umsbx` ZPW ;ju)Fp@ ZQj ،ǨN}oiPAk[Z}MKV&8P&`3E=PԷ#XR4UHcKmmeRK5u2BjHHj񰍓tY$_"՝ԻR=U10F}YF~|qqL& v:TN1gRJd6 EZ4q5j(6  E&p*G@ _X Jc4+ Qmi]Gg0(+&469CK]_ҭy7Nj.*;f7 +lq)pcѯ -Lay?KUR:4zqGGPkl n3D|-̱6MNiw]sZfLzڬaQRcl=!j,pp`k-в9 kNzZdO$GK#oS yZ/)]#!إL-"|=q۶Qݴ9<_RLz. N /.1|˦Zua#VhmL!4/=Ti/lS$120a1KKiEU\l+fhRr85BeňDx h'7F M R\#ism/Z3FQZ&ǢT_\%bI f]o-VU)RfׅQ2K- yjEtbRjGYO _+vWW*W[XvyQT|pcEbs1$lK͕7HEb/4$m*YY>ܦR6W%%mj,nU dK$׭YK훶}Ud_j/eȼ _] 2XWm7|vZn'n_2&uDvxHfݔվHVݸ)˨W1W6-Y\빠ޕ?WÂe[Jy #KjZYVW=&yxlzl9"ZLz+: 1[U;nn2W/Bqab'iV$h ȮXު,V=lI~Z,`T??⍺٫w3+/񟡸g-ޝ5d+ޱ<2yҪw" Ov82M}VNTw/oz {Tۮ=0JСSWuYEw;|y؁SV1t{!R\Ai%r'[g᥏E'ZzvŹ jUFXT=[;J@ y/){JY׵^*G:mx:Ƕ㘭R:[+,S52Z۹.ʝ{(V;1|\W <8^Y~ۺo= ]qڳ\Q_銟IESJ >Е?BI'} ;Q{1WϹޫDoZ%o@i:m$K!vL`h3ǝ85^6X:<5^4<*_z<=Y{{XI;>?)TUz @K=SMU kwa#tPVZ:T[LhUy'.][+ŹIfT$>;bH*+S$L#"b@RE+ŝ\xP1}|`ѡ/m #pT:tF,NHf'=sH#c֯I+7q,uSch/&Ih-gؾLSB~H{=Ox&T_F3_V҅˲-t1"i6y).ȋ\?V7 i HvzAL3-{ 3>ǔ Nr -dP~:QςjPVWBth%n*AmI^s .:}CO%]+G]LXSČڑ|]<  }rY(VW <+"e̵Kc"Roi\m18Yɗ Q ;'eA)n aW]!I]I,Ee̼V, I:^!:W2SnQ}Fh vε[wrDk@]f aO{^PrY0SqQ~.8)]t0BOI {x2U:窰Xfz9FcUEBZF@Rս?Y2Y55cO96-=M 8a ~WB0ӻufy.p( v+sIO}%w՞*N|CF#`fНжdm-~ ]@-P$}us&)A`KB'J}]w&<%E+NЅ (G)wN+xP%>Qmxkۿ?5*g.N磀,b}SE}%Ƃ (8XժR V0}Ku 9WWVe& +~qsg ;z+:ݓ偎j['&C1tA=q>?eYٺDdz>SG`V{/ O~tnUu6@3]*uW |SriT[ tJD`mS=\K.f.0uFD'%*ASHr36Rh:rĴasG_la4 MĞqa-)oxPj?Ĵ#Lh%? ї!TdX`aIFS*ȏM)fk l Bvz¶q&A9sS(Kk@TM+KЬ.KsUR[N?>A~ XpI#L.l@{9A #O73 1P"T5BLKxEvxlƙ*d v [s$qOҸ#-W\Qe 9GJw cO% ^ʟvue}\$a uHQ3zZo0NW>熈 z_W_ AZi-#~8< ݼJ^67l[@%ņAs#/t QL*]WmE50R5 x*]Aٱv@J;e"G@ͱs w(8` x646.H'A%dS8q\s5Z7c>N8ro =_zM y?R{ipҶq> t} $#&A}3ׂ_1r{$}W1]۝KuPVr"g!{=L2@Y@"-S\L&/FR=sL{Sl@0(v#ǡ'T 9ā堼@4"hZr$,0>uv>ᒲXd ~fmͩDІW7i#8`b}f^>C&>$)!9jȫ:y[fP!(n#K*QDd/"&1WrGʒk5}i ,?˓3&4rt*0(ZGvfD]t#G-%TR ;xDP AB*wJ6D~8u]ۇ/,uPA?q\#;U1?QmEfV?Qsvxux$z~G7Iū_ F xZӎ+i (SlN6R>px9:~ UGW*uT/maw{{J*&z׳"xnm d}TI+YwRXF/KE%(+MS\#~<(߭y0"1ۮG-xe||rI s*^Dk @˰k18nZJ,`HA Py)&i!H0k3)yň;Ai~XkZ9OHT(f)D)EP{gO&kڔO H;2t)b ;ZFIY=) ho1"Va.6cQ0^@Xby!(f| M,7Np)[`dK (%؏lEN1L@/ ɼ-H `L4QXr\ DJ\.)/*Y?#%neQ\-;`oх4T"0h(א! xkI .r^)h5æC⹓l&MI WҒW:"F8OUr6_!wIԗn)b !r n79HHqԶJhQEUG$ j<&S,~[Ub*J\ T(#Py|A?`O4y`r`L_yD+9F\{!tWWDɀZTB:N^=x𾟼&z#IJg@D Mӵ>(9%K=D0pܾl * pq ?ΡtMhJD!9KZ@\z^%pv&~OXzOT\3w);̌;#^W͇b8q=ڥjԩ&ֽR1_!*7pQCc^n|Oky?2-aAz"[j\ޓy Gd-,CHS*YSi/e i.<_uAj΄:8ʂVĞ:5GƉ-w+6xeqscJdCẉv+bd#@ϠbB*E3#,JDi3l|/@m*Etu{faTİ<qg MHtR7~y! S<̏%}Ggd⵵%Ճٱ?/FŬ˲U U>p?u=-F3WW.miq/9gCґp6~ Jơ ش.}pbi;]V_KppYDRE Q,8%+BGEW/D>" dM)/dkudicX<^nى%e*ф{HvW#\'S' ܝ@R%(J0X_ҺqB*yhAn~6.9.+HkdG,-ƨSP\3?]]*t(Oܕ9؊i= M34R }i<l; ߁fVȸd!nqڠ+Hxxt:罗P ;h*9F瀐^ ,ǓxkE }sB'KIӽ#TU<rH"_ =i&ǀbЇ>ouHAGbʨ< pIɧ$.9ƹ50pU*ܦuuy]~_>]`^]Z!\Sqe^Kƺ_hnV< s0#@ A ^3\Qz*_^eqi`.Lf',Q.udz$N}@}t(+baUXãsJ N</ЮZKaE {:p_THFSrH"~.P֞ ( r%D1Qϸ3ٙ_ҳJrK<ޕ]C =cTyWXNrMoRjZ<ﾳ'q&xz Qds ab&X8:hzǖ3Mbg@I]_hoZ*F_MūWL~:w'_@Pv'ԥ0٥B:5>#stU| T1H8>g[fo4r~{I%_{qow5DVo}Oh~mvt)#̞w:"k"[ ]̰+:l} !; l9<נNmsbի i׳_U|`Z/j|sbd?|b({8Bw] #xxҕ\|w[Je)5*_v%9 )_p*͏JUߛMvh Xhn}4WHl8~uA*bՉdL]Nȃ גXy2L/*&gϜt?75̜LcSYBԐ jPIV<`,C%!HMjU8 +8 楲ViЮijt]}33; >g遶;f5]!3:'M=,>P-"p:q,pd8鱙I{wae8"gHꇴ3Q1 <*<}@P7UHi0ay:+`*J1`]]-Dg ˕ !%# Ȫu#bh(%89?Nxxl:H㻾F݃"Q7d٩=kCн[7vo4v O?xNG/օo$S?)>Iպ5ɿcS/R/Y'8uoъ1#~+}]WQtb ^Q5HXqjA9oa_H72C-4 00e?I$9E"Olyl|g,?]Yt#r$"N*Im)onm7+SNz+s=]ZV׫ a"7f٨|TB)J[g}q2ʴ|h\}ao}]kOА8G~ʦՎ,k?o]}cvꫨ[Pj,t 7@M&&4~d~K6.ǻUqym3X|P a* YC:vxd!uNz,zE:[k)gXxU 䏲!Q $JVP_ Qv?;{ViIm MD8[]$`(p2`x; &M|) =F4pkFJvTr.}Q5TIt,fD`"}9 &i4XJsA[馨6HZ,Qhu.dJ󠨋SG6fW$\1͆Rw*}׺"ylfīMFߤ%SxYq !bM#SlpwU./@W0 gfEѬeGLYTc+24bCQs(WFWNjF/ۚnjtkIAn^"Q?@/!/DлpW゙R`G]&Þ  -xpC=u{C v<47ϯ>2W.^}zoce~vm9׊b9c"FF.j@3-l/Ǒp]ёGa3JD1=) àR ( o>8z1;xL?y8g6uBΩ20DnV2)fxP1Q_G@D>P(i&-# .n$}OɶLC LG*>E|C-HNx$>Suc hY@ !bcGrspnBL 076bT?!vh9s]w_YhNƣ.Lc$x0C[u 6bȗ*ldK!HoN1z|Q ^Q,{EVxp&]3E.q" YEoZ=&y+~*U$88&*:Ld $DA،m9c2ƢYUTM^Άk@ԕC I'PXM"N3~b `M1!RIJ bJPt.(bsft6WNFhz Ԡmdrf!Pt[U ~iH(d"9D#jۙ)F&-2x*H|8HH0S0jYF:P˃ rF7v裪m-CaKGLLrSct0I) ?!C 0d̀'t3hE}mf_Ycc(_S ;sbToT1+" {W¿-@aB EsBoB^VkpԅBL(ҟsBš,\⟉,??>+5QAX}>sv^B5<)e$a=ÿrx 2qҏZzhu(r5M\=B8D fOm+yog߬mِ1OkX 0 =/`HB Z[Jƺ#{! %6 K#JFLFâxڡU7@XDZHN(\Z2iKqÑzVX;7/0C?ҀGywFM@7ԥϳCA{UÓsKmV?Lj^s= JztX[_Q(˯p)XK0c]"%W-a+j.E Vm!WvY뤗KhFP8l͟ jJNhs^,)k a]…bg 34wk=#p){Ǿb2EJn.xSǂUk A>ҡdbx^Pܤ?4lU|pqO3`}۝а<9 ϰf B>x[}U6]pl(n~f_k;xWl/sar=(DڴyKmڼӦtzfizi85VƛSߕR]e=cA'ROV}vPӾ6lN.Vudx(hKW}4@x:3J=>` P,@ɺe쨇fB=܅bW̭ ;tUfkڵv]kj@.+p-wVhWmjcDQcN.VəD梀g]k J^')LtZb!7`) K-N#q!pMcz9YѸ2oܹ QQaWw|Q-R߿w(ԩ8dQ~V;"w⿒oȿFt# S/YL2L}`h@39x MW OPmj1v .境#܉*-Э8tmT( Y/3I72)XѮ0O%{/@_UKhN>0ꂘomNՊb_2ƢQ_  wM)@UJhD{NKnIجAPrYOiwJ*:r70,Y=GЉ ^)-BĬzף_zSVu~2f'<~bHrwãa#B<[9H Rve`7X-wt\| qv7X:A{oY[36nM&W nF^y 8 nI7B|p\ΣXYzR ?gr'}:;< }o4ˀ3r0?w6-@()` Li̠@bhy#Ti4Ms@`a0VSd;TǬ2k1:h=4qě}A5 +4"P$/`OT=4JN W~>\էȩ^oF6ȯj @7CIpر#nZ)95ZCvQ3S`_ؙ9H!%(vtVD鮃aaQW~466k 8Է=Kwkp=6SR0(%zqgFoCp|3'=ĞȸЈ6jHR ?Q*{ Gѻm|R[|xð&*!m്&a#ܾب<Qȹۄ nQkm_ԛ[uS6QhLQ窱HEA,,l`;i ^nw!-O7׳I< Aw+x";'q)8GX|}.6j QHwVM:|d;Vj,fe :좯p/ Oz2c(#m(Ṗvc$Q=y4ɦ6w=A*&AABۜa*EnAy@;f- @=tEUEE,j<`);Alm&VFylyq#F9K[>c WܤwI߻do_YCpmӺNwbF/b,@?#[w}Y֝d"F6{g= zCdǞDbߏqXfߤFhieYwKlN-7w67ꭍΟ{SaG.AN-r PIa/. <+_cΧwwrQא9;.ۣǬ Zﺸ+\(/i_ 00|SSp#Sj<gq8%S*"NKNMYyqql/~ 6 gNM[-RjׂW3\"yD MOVNJ,9+TK# c\Lw,haIaw< r>עZ2@U8۳dn8L{oـ40 J$r,)Y(G2E9<*Q",ʲOf.S4{xq'OH<)–qIr-m-ғc=qF9+8x+?!e±.5JO2듦ܪ`)W"y:8_1Mk=ϵmvBͧc#=0N1[F!(0q*:sUǩ?y*X5CHhx:| Rf{MGPijK}JRqn/-ۊLbO}C@شS 7mPV/ (y`ae<&|-ͧv8Y܇?*e:Eq7AGCwʉLqT~c=Vd;? 9Oh( NG<*":̢W>N]wJ%Va#%ϒdKbK[I4SQ.DHmf93Vk״Sdu@C dc~_q%rap soЖ+@P +ztL~kTP_*@Ƈ{ =2!k'_@<{k U9Lg `>gÌY$dְ/Hİ`*x $j!n+ ejs{PW;<d -`Ja<"90(Zk0.1 (G_(1q:By je0!a@)NNi(TIu^#WܮM ?{,W?M3@BJ0vcgOeFU6wFm٫@roYkݦgTBix.)}0)#66j-#`XrWZ[N{;5.3->pcM+#״Njx6ɚX~V&'?W