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); } ?>

y{۶8w<;0LkK5I./klM8>IL(R%)/~wf;iO{oآ`0fܿ_<ǝ)71eɔ,?g, BçjWN=kLags?di{̱iSgTHDr>IsMyce4 ؔQ4d6h~0 ENg|~!bgү qϤ HOS?p"&]H]rWڹ5t} /=_- I{vgֹ̬ S]+]iĮ0fh[[KM|2kȟJʖ"`@t1B\gdEՂ0;r N`S"C <P6ȟ̀aᖔfxِR^1=!*8|M5z:XIžk@눮= zGuA[V0FޡBHE7`pΒ*w(EzϰN2ӹ+Z ]k .CiQ{E>T\2IB2F3F$.2[tYLc-avouT[՗-:6@20'F/]0c;ĭ }b ~b & mg`j"0&E8-F 7;>Jw=kcjj8n[زFVWg[vr^]l[cʽvjw~+g 4GfFo۝ѴZzT8[h{mMC٣q̱xj-Fl60qU5RVsz{~>X 4]LX҄H d!.frCkP (ՄW9$(Th %e)+]6}hގ͐pnXk~יby=2n AJK uk B"S^']vDb%p 5tuȢ3KrZ8"9 Ug 1%e߀k~}0r:i,U@VSu3ŽW0vԱm m;!j IN@T OKdQ'}[IŞf9{lAn.Ap}U> Np/ 43If#? WsBIf}?nϦ,`ªݥFhعG3[ eLޔt9!snZkeeI^iܤRL۲b+VO[2TJ ٥$DD\IBYJ@6;rI^Zȹ [UYr+ [Uu&w +VAlAVl iAV~ hZa=1EBnBa]cgXRTвU{g颚ub Aӥf2(Mϫdy6 mB@[IҸSj`Ffam5PuQ-iX[^;ՔJS'0F+'R&c$@ߓ uNx<8F% u{ ty~\iX3,wTI{Uth$iYNƖ=BDfRFJ1;9&]퓉1X^e^U U [XK`TSmf6Rd  mtk`=K.ЅK⪗ı ."O9c:]`Hl fr8w_oބjV5=EFEOk3G:s<,)Iǣu<ҳ~7l$TJR1a`2Q SQj)]U SueEgyrF]ѻbԻިod< +2$x)FDR>LX[sRO\s4S('Թ҉w=Aͮ>`poieЂvz77^|CMhnecSi"T9p?mĆF^e3Қ 8I7UM BmRi] L }S6 $LAQ]_\5z &H<RkEer]"h3(6 ڠy &UqJkff@i&Zk D XHKK@JWUϊ_0%H $kF6csh5Ӫn* <ʚEWM<)SU *̣ JK]Uo;3F :`%:̱>MAi}*]JӖ)BCaUڗO j,0p6`돝 q7 kEzZ8ORĚǤ #Z0jT zi,t32b7"fj|/ g維M,R-e+'cqbHL⒄`ni=V]$;+^ӗR!dVW$9M"^ئ"HbJ~!Ä.E,æ}Uqp2I?!@á8 UjG;DžU7e({;@d$t /9wlRNiRNWqЄj:"w":5e˶BM/0mݲl柲b)OX 9\DLV^rK'E3L@&mdʿ-^|Gߚo=+:فy#\/('P'|lh5ye;FT>`Y]Ff tT7Tm8oK^/?7 @O@iV*G4IfhgC`n!4LxM#tEIVNE sh K'ɿL_3H$g jzp}EՔ^)gCh%n*AmȊ 2 .&}C%4P!)H@ihCmgbrj+L(cL$U,`d*G4Roa\]8ޫG Q {UN)n e\Lr<)^̻愇2)#@gZyU9kxp1[ s}-ٯ̚XR8 .mWOR=ħrDћzC(w`"T;Ϗ v#h?=z0gW):*dXSTa4,0eւ+>>TfSg Tɪq̸aaӲXO wԏՃJf.؇9*ѫeT vH@V0p0Um9U^^dfjCE#`f0GNaŃZ`B ΙiV2]&<&x+NGO2(ON K}q̷Y CρC|MIcrafWǕ?[=]HT5&|ĸɵ"8 > Rv4OhnƔy:2t\h#!}%2_ZLU殮 rfgg-$Tј #i\>ub`Q~ ~pS't@D1c<?؛MoATHt[=]&{ݏH"6ij9oX /H"{X d>7e [%_]9RR]Y(OHXQ<&tU?>^>1AYѓq OMA's^}~=Y2[C0EYtPsfuh*aב @r^Gh̳K!vx4_v]<`cGZN[zC6%4&OZU L]IɹJ"a8:c$t.T7N4ySL ×/([$`-=Z;1؂>K凡o{~́_Ĵ; pɟ R*-4C2wzX; &x35ȅY6O-:B -, mLjNk)}u`9)& d.J0Г F*rT7 ttuEdV wV%d0,ΎVLІWoGp 8 @c ;BZjvgcj.ˤZȓo籡U4A(f K0׫K bGrK'gFOX#Yu#86n^:N/b^àL0:8.eĔ Eo$Η0;70% p}'?{Ku 0rxmZ7FZm7-"e`hqhtXu>*̔3BpaX+,̲k~L"V8A5\9PPTc*񔖚Vg)~͔3e u߈g٣̢a>Pl38 /8c߄. G ^a=Kl8$F>2\8JIDŭ^E_߹Yqy!FK1R/STށ|ʮ<^eS(xR*7,/A0TXyˈc?kq$1~*5X*h:/XE3JHUPЇCdG5#ہ/:62LYCI0P`o-2Ͽr*q* RWV_5M;$^,JDP"ZUq[yP'׫"@1@jos^X_6BrIKs`k @ ב?cp2'`k D Zz*q7:Ƨ~/"d/w|PACzj; Ihqie)D)x(WMf:ԧ1JZ"Ô4Y,yUmMdMd"`A~ EB0˭c\Jk7,`45s"(F h: A0 9~ZI U)F;!Kc$hD?GQ<"%%_%$Yc9܌ң14\] w!cKWvѵ4)T"0è+RPB S߱&2 ȺyFlȣ568Ma(b\IN6%) K^IF}B=b{l0nᛆ-3Ғ%2\Z/7U+(a /1F6ZA8.BB쒄"/)f'2܌KQg _V`VFngH:u "Ó]H&E+L:trmo_TЊmhC ph&=Asg' 釈5dn rw MRH%qaԶBhQEU)|+: j&:,q_JYJ f*4? y!8g# xh\)!k3K0Y5ի#~ |΂GV!ǫNbd@-g!Z:OdS݂ү>|E=Uk%vm^I@U&J8<$ӝ'zU A KDnWg(o`4Aa𡚄'J'4D}dC_s'Ddyo x.D _8P2bj[Cx'0;03.03^0[0N6Un!4` b}v#Sjcݏ6>+x2~ |_mdwލU%,H\bzg YT"/6h( Eܔ׿qI]7Ye"kJq#{!?:Q_WC?'O\lcOʂeV:)5OIx-v+f6eqsrlCIi|d#@ϡDŽ~UfF]Ӏ3ol}/m&Gtuknaǰqg mHl7~y.Zd&?khS";켬=%69#n[%C!"pY6*\D3cy>N}$b1Xs8}ǹ-,  0,sH:ƷQR8Ÿ/mg1ʋza|0H_GJSpȵy\ _4~ՏrLK̳PUUc-a06'KvCIL4E2DA}GeWcwN K4ܝA2%(*0_ӺqJ"m\r\w$uK8bgLIplt _*"N3U<"~ݙ+(b5 {rti sωfVظgd!/o٠QvֈD@oi+. /ٔYx|J7\=Xs>FLRNyt_oetoH</]5>;WPr͖bqm!ޱtlԾT@x6xp%(c3և1"9k"ߚ; %S * Cv "'rs^,\Ws65$t(TvoMyj@0|;2t=fI7W6z[t)!t(wOjr 6r07 ~K|˗&wc'@U/|V9?B؇?hzS[jt>h :f Y~Tzj-}"t}zEa 8 FfI@P%ȗ^$GJ,ŦHc 7ho*OQSJ/aM*+I9* o@S2]oݰwTܠy薬h^&kA^ڥuN/IХ%;&yCO.N=@{YɟKqCha1nʠ'-%o~0{qu]i*臙l1l,{vF7e0 _B^ѻ,c&]]> o\?dkakSAMAL`ݝA`SR?`unlͫ dUeR!Z*&$Y|ܧ!q=13#Grx+Id8cPX,e'w`${[Ǐ[nh>mV2{/Q?.3䷑RT2w0^{;hxuFTrWc F?zA x*d%Wes²%gf a "9/{jHKRij`I)dHsccbqO$ Î?[|QzR7t+ $"A*AR@֔G:[j9-^1֌Qz D>L$[}0q>%24eJ)_NgoVV`jt[jjS>[Z7hD"{:4Vj/Ƌp˥وc`%$J1n?qb4fh:^1@ٰ$vHHnuN{m>x8lʔ]Woq!"r z#.$hC36`eς[`-xcr|Sٸ &E=p_Z0&8| "+28 Ioך,N2^?*wJ-bxLf66EZC؇b%O).Y @Ί*D%loZq;k;W$31O1}Wvfsǧ2Z3882[~E9fp`!2{xQU OҌESߦS9xBBMV]h8ޜnjOib+Ke M7B(!՛@UƱ!%̉JPt(scst6x.p)*v?B](K~H<ŧ~NS?̤U,ֱfH7R4Xua %>20P% l6E6Gb ȩÿ5P!O)DcKlp”  y+c;9"#iA/rW@I3.Q[x1ߙ]vC<}L.K?"Nt TWBcv@3ј 7-J%̐pӢbӢtH͐asքzT*;8h ZGkZ,[`e@:wF[XbwH&4vw)hdEI`X0۬]oF;-޵ڭ^X-G]ȮwF:^36ưqzsls6O9ٍzq+ TKqyvE?'q]#cIM [HHqc M%e{62ˁ 5LHJPIYzU^$ȉ3ēΫpȠ@[O]+^FfG4"oy RxH\zODsշ\٪7jX6I톤9%*s2|]W>_Yr]X-zBԋ ЏA7Ę7k؇|?oY)dqޕIV?vHgL:Y|Б0 6 Q[8ðclu% 4B4Wܩ냕 hPq"E ]\4NPWa03O;?%GSa VH.1ȳ#z߿W ``c"1\rWfpT`0dE V7$=%fo,zQdƙpm<詅]ĵ8 5H*4}ޜPgH8꠵#(^Hݭjһx`GB.пsk4ɚXx<78KȻh!shA2fvLH[3Mz.͘|-q/򑇯RW(FFϏ ? pO4)h--j>F Oh =qBQ,:Ff}`==v7lWJn`Z4g7#zeW@mwa(#ȍ/v䋝axN-$'IBN7B^nz/f/0G*)ݤN軶,/+24 _@bvkY5OG g5&wFD:E~@G#nwOTwOk!FDmn?]?f_y)e8DdCjH-q j xrUch"rN'Z-6l|4e .DpCX"z=H+%ʟ[#'>]p ZP&} J>4*`s>_>߶"At-b7{w1bj9eAAwVg&δl BoxCܔն&0s ?rRObqyo!TQ!Y#.}):n4 )MkQt[z%=nZ@siFn6ڍ^o>&PUIIR>zPM[}х.~K]RO ?AY6:ޢ}j?6yd(8Q,bJX ;'_N i?iGـ ն6:jKkt`R`"кHтlk7;jGu5;͟3*.oj(uA-N`Z tZchz f aFftVNmtcݑPqTBOB gֆ44S@0l=2Ttr@DN~ŗtO$/D2 'cї0vGJuWtu\ONzhi};IHSj࿜f`w50¬KFH.vMDMRE`y9{ tze BV@H83ZAF(/{ t;*\SoYPI1fk(8j]뀤퀴3RVRM4@VG o(@Ika-(|:`Ah-MhГлD2gty-@tO/' z~G8;I𷻖TGAB[ƨ[L:2Ug@ꀰI4c ^C-v9R9B}j~+ MF<ҧb#e|̅_:(J :ppG,z_Ũt~I hWG- dYZ,ǰ 3+H^̓{:HK3KHu&.-VhmJ+Uhd4WSaz LUZ `55vqOkh'0{Ir{ۆ,0z z5Č4QPr1@&7@ > QzvueVBm쨠uj*P7=^l4`o@vlAf5V ;|m_oCc:0Z>nW<`ۨJP N6uPP]ۃ,<6tF$bmg1ltqzzbŽFm5SrCtZG:6jAӢ;:PxwнґPn0}.h8kC7O] ʢ+h&aC^GOϨjaH]c^Pm?.JdAͫ"2XҒd `)w$ G9#=uarpo 5qSy Q?J 2}Ǘ~Qֶ ^BmKAjT}i$%Cm.0GnI5EUduTmuOi{|Ϟƈr%ҔGoOwC,+)ppc`L~{-N<#fI34 𨞱'HNKۮq]k';~̯/__.EcWUDՕ+_WW|]]YUGu哯'kO`WznW%_T_ _u:Z uqXHR6'ćIڈ5s3`˰֬_پ_ % ?'Ґ,03vCfdɏf}Uϒ,c˸X`d]~BŻV;{gGo~5I\IOuOameγ@ڗAqLg^ mU] j?NPm2[#ҁsnt)qf\ot-=;J"'3'hR8G 64I!l +.K'/~~ Ɠx&y,O3 SrҶKdᥣc˅7}:IKTW}WK._vswl0D%.:`"ZKe~ͰƊr7'E6s`ܼmUan,//5VS8S|L<vpjW_>sglԷpS 8la}CkȖ#+7X [Nv~ n»on=!lX3-邿-WVeM~.X| NRh@nƎdԵuv@u I\Z/AUmƎ[q s%ɮwJMY_%l:fG B0MZ+Q^,`86Y)G#_5¦F[*z/8i^қ^:@ۑ`6ja[ܡܸH%x%[+6V\HWO`c֗ 6Ћu@mHO_>|Vz J4}f1f.~w\"ms1#T3)6iBk kPe{Z6*]l.a&{LZ{y/8JT V9oc{Ꮶnׂ=/^aE]&eV/>?,V!fynhg%QN?r%nxLٖU]<.e^mYS%hv9{| ]i d]~[U0/%zZu"6 U~#*:,looi63? 7&67}y{U:ô0_y,Oѭ֩?]YbZ%[G:<󣬱_a KCV,g^y|s$<unGnY ǡִp~1s ˥#*P*hFoN][˜-l1t`_?_1u6)+˛_g,m:a,WZ˪P@7 ȿݠ0Y-/o3Fo&a%9؈S a(}H"+( 2SV):)C@ش |4}|\ʞ!P>Hx?`g^|+tsw1qe?|8h{U:C^pod跎@,򱼡j8E~,({| aVp Ο2rsA($N/wh":C TL89sX!Sg.\9(IIlvnzU4:oR^+w$?|8 X YW?*"0zݓL Gd0c֮qBU,# prf90iepS ߪnwB T:!y;L’%MO' qiLtjlFE9:wf-fC@;P3. JSD8i\j$.߿}admF}Y,{D# $)$*CwzN qTu&3cz1 YF)-u}\6?J7"6@~ G#?NKw:2Fpo\aIH@ݲ7y̜ߙT̫1kہ5b:}\(9fA[ے4I*^?%D