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[ _&\Mv_J$&~^33OQڍ$0 \w~t˛'4sJMLydJdg, BOծ{֌~"ܙcGSfΈHDr>JsMyce4 ؔQ4d6h~0 ENg~0g3;'p',ع5nfPw aEGmn(MZ;UgfM:ZJL3vm/D1F]ޖZm XBmYs'FPR܈ 9՚]gdEՂ0;r N`S"C \P6ȟ̀aᖔfxِR^!=!*8|M5z:XIži,T?,;0B{s5 Z. p.-VVYC]*˽a8Aȷ>()\냑չM`d:2|v>m3o0l&eTkHڕ Hwbt}\">͆&NJ-@4Ad; rs1n>w"ӕG|hH69 ȟNB6;u&6eV7.}`cJQl!41[SdlϹiEЮ%yfrJ1mˊir:[Zy.?nIP+)fHh[s% if)zJܲr%Rzi"6lUeIAVƃlUՙ5Xm* Y[ U$Y ?ƾ#WTF&1 mL$aHN! Q@E\abmMz|TSzsԾ+NPˆ)2alD% `+v)5(f`G݃PC+#LƚydnwLړJkF#I˪MfvB5D 2Ӑ2R!19,lL\(Zp&Jj X_렚j/5k@ ٗ @VglNo=]`_vLĮ.t`_GW&E8<\pp u̘~asVCfhl0ù &"x&voU ey(2."|8^=Qa5LI?e>Ý摞u<aKg6&Ta͎bTRVKԬJ+-785c0ޭ'UF}c%)X1֐a DN)7"Wfښzن7\rB]Ս"]#km~.yf` vPW;3tE7{Ur;XЌӀfvG:w4U:l.qm1MzZPTak#sZo ۭpl*_-U\+mcj/[4躑6CY6.NMU|GlzTwZo%=S1wCT3sq8$W̧ 5BʃE#59F_ؚ9.4V'z I̧c(¨5}PEHTe"_ס|.RKIi f.nJ܆iy]8UJBPmX3_H2[IKp%ꖸ\>vxKn;P nlPl%oXlՈH@7ImJ EJ09ygRS*,5>vSj>I|ƊFT-dԧwM$'͛ȳOoRӫ$2{a./Eȷql[ȴ[i+^ݦȮ[wՍdmڍdխu+eӆMKzsqXlI$mSqՂxUUI^ 1y=fe:l(Xj8?et+댗9?C}1uc6?pCLh}MT*Us2 ..=v&\DTa0*G_]UUA Y!Bry`HO:.hʼ|!~h;!~e _k8GaJ`PV 5n"UTL=}x:5bPW)-S75Pqp]TwPx~CDlSF[VLSV0 D= Ss h&)$L؋Hkm'?p]YyE00~ŲxuG{ǶVԖY ""bG " },p"^LWN-$i<e̵ 1İL分__-̐¹ v><{:!D?*a)-!RULKR_бI'U̼kNx,`(1 *2LBt0U4| >fck vε?>#5"YC GAmUj1ZUT(?zW^qn PjCv\~mg@of쪜2[Q"@e KwJ*:EZzzӇ* pꌁY*Y57l]0lZv 8a nzPC0]9zJ S0>- ً׌[mHhD p8(:IBs?xP C(9 y8 JqU;xk^܄$to P ;zo|08t\ڄH8+0Fn;zu\9ȟAӅDE[c \jgM\(2 eGYv@mL3*#Nǥ&X8B8W"M9|4P@ϸkꪮ `v@? n$ $Ľ -r%}><B$kh:"X@( 9!oH~ ZB@>xﺿ7̵43$~DR9&4J@}AzyC,h'x)lp2,!іByBŠ߬07oGqt蘌k_~jh *? 2ْP)ʢCg{0tL0FU }hXs:Bg] 3ģ&|ST;2 tJLCD) [6yr>К=S% L?cV$Sglb3Ӊ&#s s{eD,P3g[K}'[c0m߯91idga"2J ͐ ,,B)ތp2ray{SC>H 7;Bnۄ8sS8~%\0j@T*KGYq]+88}9zps1&23k0&T0*=̜W*@BPR4 ^;u.a6 kF$ g̓Cn;;ODk޽yJ& d0hV5WYuN{Ѧ]:% ^6ʟ My\$nu=z͡L{,YiB)N-GG vއV2f^Z w%뚣D؂_,Ăi@ise,-` !+Rƾ3g&(cFcW~_V, gEi.DJ{ 2Ax#";C;da2x.Eb.G]jEՁ(~^U$G2&q0s9R-wF#篜ԼVȬ+?I8a]ac?VItwyyrr̐&pvc`C0\FJnf䃮LɮjPͣcn0W69+ĘJ-14T*oY"^`֩c?kq$1~*5X*h:/XE3JHUPЇCdG5#ہ/:62LYCI0P`o-2_98AL~Lx`+gqc/DݚXF/IJDe%"(*MSZ5y !=UǤ^4Ň?;Ѵ2a"U֔xD<P{瀫&3~BӂcĎ\d]bHLU}ZaJt [,yUmMdMd"`A~ EB0˭c\J?&>'$YoXbijDJ /6c[Q.+tA4` +Dfs:] ԓS<,vC(<0H2ш~  xDJDKJ6I$>ҳ|sPGcTi>BƖ창УkiR~)vD&aQW0cKuLJeW/uJAؐGkl)p>`Qĸ̝t3I lJRh?)$X{V` _7 [g %Keo,m͵2^nUV 1Qg_B;y_c.|lµSp\% )E^R5 VGp3.E)|Y[iU!5O"ts#D0R ~|V\nC fC5 ;;YH?D=, vSK}J6F*!/ UBl/R/H9$kfTP5сeT'2bBC*(Ð7RqF::>>7`2¹)?4 cUSJ1pc?,xd`0t,HԢ|y+Ȧ݂GhTC5Д#Blk|,#-tυ]  v\fwbSLtkfgfsy٫f ᵂm>}TndSmqbUF+}}λ1KLl3j@&m#Ķ(W. A&LdM)na/'O jR$w,RVPY S'"%)8 n&=nN=zBm(\7 vv>2Xl940vЯqȣqp捘-ױ򈮮~-V" D )3MO>}E$_~ vMmd❝3gs5ms+}Rp!C.fWkh}~ ܩ[ U=f q\]8}xbeI:XJal2vUyT/LfvH XpJ6k/^B 13`By7SʗXˮ#+b6 ɒ楝PRī"MxQz0|15yME wga@>yФ eD JJ&ė}nR1~&wxqs]0:(It/-ƨSR\0[]엊t(OȁpwfeʇXvBa➆&ݥ}l#ľ4<l;߉fVظgd!/o٠QvֈD$0Ca]! "JZ 3k f|ǫW!~`8 Qɦ \%<!2 hq$Fj3YLs=^2X߼"7 OG:u& Ł۴.lcܩe %u2W8JxY_>]F{Xw+m7m-pR01pDPߚ+e`T:|y =EU %_z2ZLFIlеËCEaE6Or!ełu…]O````-L#+D }\ ?Z(W\])o$n.{!T0;%}!<) ҥLWUX'+>' hHx>g_{0XklwT\{X{}?hfwl~Ծ;T@x6xp%Sg=ѸWƈ䬉~khgt0OXOgPk3, y'Lw vfs Ko_ټvjphXk6zZNew>sr޾{V(G8L]@Y U͇c?:5qȂ 4+i S?>n>`n~8?%>s ;Q Ūw_M`kFVM~;klZy5+d֘:daQ婭g:CAWyjj(9 LE(J_/}fJX 3Md(_}u- ^šfUv}oWړrT;_ȦVe޺a%_(AXѼL6̓ڵKs>&KKv`Ml$ =s ?ڟO\}_:Xs>Ҧ zBHR57q+>qޕv~ן<[,/7Kq6~!A\U `W}ꇴɹVeOB+%wZ)ŏ3TP=mw'0yQj٭xu==jI*D UD >?iV%goÖƑ9J=a=X㻾n=eى;5)(V{ySlt5>~mݧE,#2#nJ~(EsU#aa_J%?0`#9+gޚWbIVr?+{VXr#y61?6{X\ V S?"{td)8~tBO.4ڜpCt2v+.Mն[W T R?F;R0#RmiKbfԍzMk a"WԆq0,!)SJѢu=jizѸJyi`ŒM:.#>c~rF~k[Pj, mUd{ .t⇄0:"@V,B k7̆ ~ 羇'A`cg!} am"wߪ,JH휒̞sΈϞ1̵\&Ww=1,ȏY}fbp=ʸølB"Lvj?uxY#~#=|V*Tմ|6QC[=O)b*݅c#%P** UgFuQ 7.xc. *+_[Ej@$ X#r%"b{Qkncc &Z1 S@S-4@AءD7w3aZT'R8xlU˕`B+#s`YZD%Adx Civ͋ b[\5 n>mVHc!ѥXdfo*#Y?dȜ;v+?ˢhٺDy,YA+ڨeg+;^PzHAуrXe6_{dp[cSJ ?  _|rBg kyQTjy`" hM uό B^op4W3^|xrÃGMx n_A6員kysM1$y~뀤ں&ܫׁfZYC_d5:т9-bu)lHC+D 'I7AE[A䀑,k(5ǁv&~+E9w/s>2vB#c o(y!XfaBR"tepԫ&qDN!%~©"#',^DF,"o _xH\~({KhjEs j&|v2w,YPXv$ҥp;$ץ2ɉN;^֡3[ΦPZg|q 5'M{ BZt "\PL!x17TIVJ0Khv4d SSk eP޸HC?[QL-?ax!>E½3Q 9Ĥ `&#y|4OԜ<_i,<1<xvl͞ &!~{ 8/$1p)tdNGEh}f0'Jj\a&8$Y2t1nȣAj'j*nUNZvGmwsn44ͅjJxY J8ڙ ^S]owϒ%z*7ŠL,T8]>~F=Qc!ꋝ b'aN^9n RH~D_BwC ٸ1?][MKxvg.gV.+wdFNQ+B7Fi< O~7ޞ.1 Ҁ];T)"R6]L2[eYH{qkwtM wZx[rUchLy>{6G>GOS<ܨ/~׃R5r>7ܮui e/+VAQ3Tg>N"OB>]!)s~üذ}]̺ZNfcdP6`;йM녉?;;9Qk[Bj&ˇ)mImIM` FlKvKmh 5DۭL74aXhX|N0xKd=07 ٟ!gbWv1L,P9xT햁k -aCX|tY}sw/wķ=S$ ANѹ6u +hd4SL "UfZ `ݶ5kOk h'0OIۆ,+(z gFTZ&?PHUbD:ĮU*v[t w *[ C%?T hMeO'mhauւ*3&wHv3PF~&ۆt@ @)ݮxF ;QA4QMۀ75aڝ&b֠vPEYPxXKmtI 2mg ,BtEzzbŽUm5SCtZ̠G:h,jAs;:Pxw ґP*n0}.-kC7O] ʢ*^&aCͩF'MϨ@aH" c^lPm?&J_Aዟ"2Y?, fiI2QTʔ|ʣ|&u}8 c]f؟*3z̸xvd1^wM kho<e#UZq)1Kgk\bG ?:$rB9~].GKG}/ _,GwHkZb3ޯM *?읎 b2_6Ya'h.fHoT|Z:Pwe&FAL/N% D7mlGڢ>/0. >%VQBXT#լ;(;8a(ȶ H鴑-5*Y*rRg>Hle[tV2">C}m_8h\ 2ul9(:쮪g(6,()Бk "ODXt`[FI9Tv:=t\r݈& ]TDꇊN+K\P*ܹ_7T({Z6uf5v_/tPuk6蒭]ƇgSow:Ʌ d*4谡 aZ+1J>|LX ڐC΢N>faZ]z? 6fx[:OP_خ) +oXVGN0%;KԹM?xn]F9Rڡhf.&tXz Z5kiu`D!xO$65E |&O3#Gx])r_]'m|/Q][b]umT|^iR*pBZOZJI:Q,m^'[SXQKI9hx&.GMmQ~q)mipC&Y~0ǶZ7żGN7[ʗױh?/,n鄯yqKӊ+8*.Ǻ^Br-37vW%e%Mn#7.}?XWn?!;咔/Ϸov~՞/OޚݭW74ZE#~W{7^қ^:@ۑb/j*ɍ{ ]U*_Zؘ9~qê/: 6K~_>y+=xT_%~bџ/]lVMКe T٧S[-.`J0&`+d|=ϼl% kr1׽GSyg૏nӂ=/^aE]&eV/>xIBȩs;S&xKNu ~Ke)ݗ-8j{xZQA fEL]H;Ku5. m^7u2 2nUIxtL:6P,xDl#gvҼ^Fs pgjksӗ77I:ݺ9+63ش|;`>c+JOzGYS_gx fwSm!xWu/K<5?:~fa#rPykZp?ҍ(4#~!NX[˜-lt`[?_1u6xA;+˛_xg,m:a,WZ˪@@3 ȿ0Y-/Z`@,&(Q,(F (|D7[?Y< DL3Qx`88$TR2` t/A&͘OH8G&1g$7ޮ¹5a'dc(S5‰(0%ean>cGNՄ'Yعrk\e^"]Yg'9ߍuC x>K:YAJ|1W0=h1q%!!-kܹ5U¥34.0xӘE?Cܗ㓤eE>2X1M;GS@їkʥ3d~&|桙o[1[L/r}U y!Ý~:c 21)&YPZL@&?e29OCQ@>РEtD2+\ń:j09uRX ϥߐKcKNi038WDڿJx5'`5~RKI1&kD=~a|"W8j]Y./ O髈@߃ Twvс|qËΙ,~6p\QV8M8y:M>R I!.agVouw}]2+l̯rз`r"_!oЖ~s "k 4}^=^U"~T] gs{lB ȭ9L^$S:?Y.̘@\o$YLZܔ@7;*j