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{`֖b[ _8M8vIL(R%)gf^uIw]M`xtHh#+72e˔,NXdI,2Զ{քΦ~"ܙcGcf΀HDr>KsMyCe4ДQ4 h2i~0 EN㍤C'JO>z6j՞~&PҏNIi‘e۳}? lOsՙX#NV0bRe7ӄm `ȢxcRPe ?+)[nϊXjM3"*AO\BRMy V`>{3y8XueP!`ߟLaᆔ zxlo^ގj}gS+k =פb?`< CŇaAǫI#"vUaTk&VdRcc:۱aVOaTkj|8E,SAʻ넥#1Zr/` $(2$/Qx3 ZZKz\߫<| ,^!={T!wgu\]j^xf~ZVj{KU5a(U0j̟yXNCaZ3ϣtضA,{͍cYL\%ٜuEo7AV^Et;LW[ެj5% Bݰڭ1`*®MsTB;C;=uʗ]FZ^p&?"߻̂KCjl}AvyghY<-9o`~szk6 tAe5[zY[Vި[N*[iժ&0|^<`o5z PVݪc V) UP]9=-F[GiB$l4K/L:p 2a i4b8N@!\^HR9ޣZ /`N3hiJ,w0{7 K C'"˳15Zw&LX^t̃8_>HC6@~i;Ե.Ǯ5B4fv#~|I~3t`*R*,ejYAX@/"[]XfYtv\.Z $a 5"ߺ|q ׭3UV4Ţro̐ҮaC*>;ͼԲm0RV+$ DE@F]ҷ MZٞȩ뽸vb4 {]P=2D+iQC34Lm6r%xՑ?%4 6;U&׹{6f+V7.]`cJQƿl!41)r6Cܴ"hʒ 3Ia49V-.%3=^R*EJr:ulT,e 9yjCt 0l$(!Wn+/Uo:*hQ [c/lDq RzovR E 09~7_Sk*Y/5fkjھJ|Ê7F_U-dwM$W͛ȳoRZ'2{a./D7ql[ȴ[u+\ݦȮ[wՍdmڍdխuKeӚu xsqXlU$mRqقx6UUoI^1~=zE:h(Xh/p~U/s~bT .l~ᆘyZjR4uW,<6de-1fYaF"ziyyk@H yιwvmKcƢmr}6Op tP7+?_^T` nEEouic, 3q563v#-Rszyk5=Nmb]ސbCFJo3fKgN4~}+b!ִw$UIoWptԝ+%*> 3$ۊ,׷8^'8E,@%Lh \̛NS+P YBoŞE"_J{;^"M?ḍJ벂 ol.MB#ty`fHB.h̼| Ɨ!~h;!~e k8G`Rhox`|uUMkΛaIޓ˦{"7 tN]k0[.+UXn+.ok4(~\*݇NMٲSF[V𐁀MS6a#=@{gIL)$L؋I{]#?v]YyM40bYGR@kؖ4kښ|s x8c :<$(Yb''MYSJi)?}j 024e@k@g2,5` g ʏhh2qwF(̼_UiFK$>CDN}3<:SS e)@alk+u?N f2eYIiV- NKFthiȟ~ƾ|>e]iS0UKGu =-=w\*ЭRf%OJhUp]qүHxD% R¤Z%cE|5|?Kp{hg @P c)g=%Z-en=SA:A?b|`hSEt.0CIOp P$SA-^~ T^33_hNCfEYau4`Rm4/?0H`L[T@ bl8'f@5pL>ɕ(D~j y(?+jP/Ɣ3 7$J F >'咎:bQ>)HjOihCmgbrj'L(c7L$U,`d*G4Roa\N]8ީG Q {eN)n e\'Lr<)~/c}_s`CɎQP ~?0-F*ќ5<4 8 @9׾Fń׈Xf,n)O{AThTS9mt\z!U`0BGOq {Ox2U:e Df+r9Ec:Ut 2L<8zhzej3nX9`ش4q@8Sy asz\*;P$N d+s8SNJ*^darCE#M`f0GVaɃZ`B Ιp,e `MxJBV@+2(O.NKxsP>8Tn,ġ&$@ı\:0p }2ioGOk p 51+re0OMZ`d1%*c^Ψ 8.`C%<`fc_WV4#@⮹WV6e2ؒ d$w5͖^ .!Hb(fji?8ީ: "U ұ`۟`FD;"%ݖq$| fឹ$"1d8mg ҃#bgVG>MY`a 9WWTUf +~g(2Vt蘌kȟ~fh *?32uْ3S)ʢCg{0tL~0cBU ]hXs&Bg] 3ģF|SrT:2 tJLD) ;6:8}h)]`rNJU1+v6N Hgh HuDG9?|~EiެZP3έ%y -T~wUv{4V20CA Z\fHCk{eĔoFf8˦EG!e!mB VT9OȊrBG.5?CfԥŊЬ. sB_ξ=>pM``5EL}ق0*=̜נJ@VBPB4 ^;u.a6 kF$3@ dցh_$۲*Ki(~^U$G4&q0s9B-wF#篜ؼVȬ*I8a]ac?V{Itu~us6K#aY-O -б< $oGp 8 @C {Bmm6G y(9φx J|7N!1Rʄbe Q>˾I̔ ZEDQ(ˏe ̈́=,AffI49#8ZbHAL0 @P{)}7U$.a*);V\f~x0(K0CQ;1̎ aA-3\@ m)ǭfg&a245f-ͷ?Z-|Ӄ*Q0 84RA:{OafJׁ_Ui 0nYfYe5X`sE id|ՠ`.)r6WTC*񌖚f)O~/M3 Ӈ5uXg~dfѰ\QI(p9w_WL߅>*}0$s#u\%$Fyrk}#IԿV?{#/QnV\F2pLk'ԯ9+$*kl wi-RArNՏw%}ӌ&xuKTzaĐO/e_ ,5D<|>-&a[Ǹ L|NI0޲Ă%̉^lǶ"]V&hFt^i'90T xY(P,y>adF%&—|lH|g%vt3Jpu}.܅-]a;wGWҤ6PF]€g`-U0))_P@+5bC 9lOR2w$)I`p@XJRG<0:NbY96a1w 4n),岴5pqT]X)N^D _~ }5 :Osy@H]\%~X# b'au 7Rԙ—%[%1N]p ԸHw%p_NNZ-Zq m(#-֤9~X#zYA 'p lTB_Fm++U^dY^rH=q͐&j=NveW 4 W LUA!o tCu}|1o :e0sS~ai +z^1b(0?L,طB0?]]Ov:$jQ> Q4} dSn~+*](%#oRN 4) "!5.O2"Lp%X7`Ы30h0PNBGH17k)GD_k}pM>HJwZ:]  v\fwbSLtkfgfss 3 8ky|>: X]T{#Xq-^2C9>:DZd6ٝcFi KBfV?GȋM8F mQ67ei\D׽MVȚ2R_?탨W}$\lgwʂeV:)5OIx-v+f6sj?ԣǠ+؆u`k35F܁Cc' ͌<2/gފr^|L~/(a(|!@ې2a٤!n]4L|8bĮy3xkUI~A/ᶁ\ p `<`/zż˲U(h{>;w#CUOYG@3WW>maq>^p eI>*YJal2vYyT/LfvH XpJ66k/_IB 13`By7S̗`eבp֏FzgrNt()U&Hƀ(H=ފjlx|$`tQAY(O4)CQ #e(bȝ߻ @@é>uY|cT)(Y-KI~a}}/;tEf;0sqOCn>Svb_Ï_BDHNq3+il37Ll` q;kD"E1~ i@+=C&M|Nw@8^ ,󐙛ēw"I~>9'";{%O*yD9W 7d姂b@nrg;5O5Qp1yLO/IZŝ+jE,΁Vƴ%FN8n|gn^.vP@"Iedl`800aIs(`p:8]0H?4*WM&lm!pa1cQ"zw* +ޏ2ET"6wkr\t"q[.pk^s"JgZ 3k f|+ϯҕ{Bp@2qMrEKx$ KB&dA rA(TggDu!#r{p- dmy)GrW7UE]F;XKm5m-R01pDPߚ%+e`T:|y EU %_gNb- Yv$6\!$?ghMτՏ2',Q j; N<,Э8K3Mq{:_gZ_.+ ~?0Oʉ" ,kgև؞r *J 6*2WWk #Ȳ9DPU2H[=LUrvv̌hs$ݓv@1{`bn۳XcS%ƾdמ6fYQ;hfouqX+G);= ~4c R*1oə^q=  H0a`Ò+ʳɅSj՜r7se4%K)̴y40ݤ[9&- +lj?֦|~; nk%J:^s[Tӭț#~-VflL9IG23иaŨՊW@Dǯ5fh#YB*CSy֩wsU׋.^:oKCz8 s&$2r3WWo/0]_f."1AGH Ï#tl8oxV`KxΤ0p{x4=vѧPf͢1}t))?!\+ILUOqB7Aqg>Ò^Տ*M. GS NF:dOvY?ᛷғ濫LUMghU<- ,6oޝ9vJP * KЋ]ubMPTbo BEpE?*3w P-V\ȣ7/?ar"9 T>T < Pv(hhn#UTyc6tUr.bqP $XVdI./^tbP-+t#i }qEn.76HZ,^23j\bdNo: LşEQhݬ4WbڲX=/( ^1Q_|kF9*QBx^D{o>l~1 Bg+yQPjqtݕ`" hE uό B^op4//?|_~z<{_%eS>黖Y ,<CAHd$[`ʝjhV0Te\:"Z0p!bzAAh#Rd4<0`4fS)c,Y>ƊsSW)9WJIA楯$0;TSQp6]fhTLīw8NCfdzSKw ѵa [dNRYV6PjsrF72QuTzJ#&Q&9,YR8aJ 8 ݼ1؞A+?>u7Z\*¸p ;sbT +TJo+_'{Z eH*Ē-TQ[В(|3oDأ |%"vKH->2+%4oWYNbE=T1Һ#0O[]*ʃ(=&0ֆcJ\EN{U0`Wjj\)aEY~qF]ZD !,nڮJ+G؍ǒ+HHl3vBR{oF)둔!XO&(cBR"tckO*U&q@N!% KfZly 2pG"r&T׮kYVj)HYn%,GV0hϠJ^Z#"|omЍhvmڇ˟g\Gܠc֬HݘE{-Y՛HB$D7YB&"ǒFoK/ >k؊P:_@e㦵plNӭ }Q郀P׽fz[ϖ5>6FCJ'gggZ/h߆B'i9~CghvjsJ`cٖdw OBx!ϐЋQAӥ3ڞ8 (̖p;gMtvB:ފ{~,J]qM<6K؊t$"301~T)0`nFpChXN0.)sOGu1"ȠsKrxI F_ *[Bd>MYmJjCc{4@ w sg,2tp3eL(~SE H\ 'Ju:F٪jz]2ZMj7:vCz,U~֮NҡZh5f |mlhUՒJ.5V/)Rqox3~G"KoU Kj szHbP" ;:jNH> 2TåRP:/\sgȆ,z^PpH`wyG. dWySZj +HNS% Npo$)s?ʌj00jFNS4/ZcI7F :XMhm LW fn7!i Z˺Zoj**5ZuC 5:HxmyXn#<7P)[*(n@v6jJ>Z?j546]3ZPXGԀضxjИhIhd&j:Mp):-lCUG P[o~6Aզ0`m;c E l<)7~"DʍefB$?aȉ[93]xϞsr%Ҕ'w 3xp*W|c`L~y,<#fIy3.@G?;$#rmY]tYn?[xU!wKwKwK%;9cwkwkwkwkwkw?%%k%Y*i_?niO4Rݭޭz=OzMN&}_9掬O;3#x*{䜱{Uv0sؠRK PޝOFPVXDž^xlQ9,:-g`Lė}>ݶjZ#xf<7 q XpH`]M.:ZGQy+V%)SFZQc`',ulx@0YZps/:Zd'{l2̗ó m5tޯkO ifG:Ѫwɺ?"Ik-s dS}OO:99=/cB5=:7G CO<& :5]o!xgH0<<'sr¦̌Kd}X}FkDu寘;ŋU\7ELCҲwRJZ9"hڂͰƒr7X&L]{AQ?\Zn/[K^}ZxG‰ڔ37dsl3NRp Tpҩ6S =:_oC}cb*#~,Ȗ;񥸛1.r g];F'Xj~6^cKB3Iz_Br<7v%E%{ !t$P`zxΝX:pJ !d&)w?oWf>h01ҮZp; $o֋r?zcub;46u*/^xhT[nFUdݭ:@ۑä;Q ݒ**1_!ϸf} ?aWVbP?ҳ7oI<DCkpcXg{!;| o׺(0o8:5b.+,bhn質 0 a2gK6{5l^}3gǷiAՎQQC_"ˮ֟]">3r\oΔ3ܐS?)@t8~v l*ZFxTYSkhv1{t =i d]G[V0𸎵%̗+Չ$T}go= *X? &7}qsUJ)"tDAFNspdwn̜G MlZɘxqlƏt|O**?neMU|M{n>Lov?EwE9[#ygnv?p,w~Ϛ[83{X.HQBA3⸏=ZHy(KG%3?cnB:]gpy3۽M9~ kYyf!WTX#.aa@`a %5ٿXS a(}G"K6( t^ / gxǖZHL!ЀnEY6פ f)H$$9uT8F섞`QeF98}U,r7ˉ$v.f `W".q,sLҡO h<$Fzd̦o% Aa>fDZ4ĂDž5=^³AL`ASxNK< jȢX]ʡ? L)Ӳ"AK¦1ʕr){~@#6<4PGtߧlxpyyG?~+i;e:C^pgd跎@򱼦j8EʾI=Vd0@+8O @SQO;4hߤ | /Ԝ:s),էAoH%H䱥P4Gf+]"ߥ} ƌ0?qf l:at;]Y./+W-baT#(om%'/쭭3Y}6tO\QV8y:i>R I!agrꗪ9QwpzPW%B6WUZW|0^9t]7h˕9i5z |uE/MU/+Fgk>G|FC=6!P]U&\Rz)dfu .C跊exAN,& nJ Dr}Pp5v{5ˬIXR_Ӵ)x d6>.IN-A5ș(G_Yd6٤bygja0YT8NW,PHiu^@ûRfݗ7h`$_`hUVj!HdU:Qm$kKKK>kRww]}?yO#?#FjYEÒF>ݲiL/L*8Ӳ&;E̦̚v` N_W%Jo;Ck01ih)]]p[-F3fI