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{@خ#Ť$ʒ)9$\Mvu^J$&~^33OQGGnc`0sۏ_=:c?nÿ1ݡpW{VDnZwCGP*Ik|:Pa} pS GO>EekhAtv?2;2p|>0QNN>O5n]B;t#>D~]rJ^e>{'߫rY^ ; wf696ajXnGww` jC:ܜA % !4Mıfh{nͳYH6|9]`,Ū+_Gx II_Mx?[6 g e[`fF'h4j MZ?c#1Ǫx TiзVј1.o~/ݛ:D[Dx=,Ow\`|c6֠ _a7jCm6$XNMCU鞚3>|oY11471qNg.5TREP侦7vW&;ݨWh궹0Fطrx{oTm6c9UD8w:^Ӛ.Dڀ貆pZ/ C=G~Tn nmjIO ? FWEM[;M}c?͞n x c^i]{˴D=+9镻i`Lo;zzc}+=Ger]d`dZW}k } |l[n̰Wfck.&8%`iZ#$4|l}{r]4BiB$|B'OG0v J@~> , 4GvtDp,0/qt 1C=kM}sr%md4d@H>Js&9b.Q1}=ڇ( S ^gy;iAh|XDhuiКyxj$\\e-鎪Kt 1 #%pFmbY<(vG)0¶0pigd[wӲlwX&^`J5{]yt'a *z@92ʨ-lhveN#NS77Y1*q's]I{tg-43[Ilj- $ԟdYGo%B- aН72@;i+qD1PԻͦ+ ܊] +KJ+&bښXXu&\~RH] 2R.%! $s! if)zJ\rz)Js&[TYɊ~6-:Ɋ_Q^dEdHH33YLQ11zEBJRa40y\k0rr@ U\ρyh,Y5bkQh" C A:w"~AՅ\H[ĵ%! SMA>Q{a_ Aq גON0R;[6v4k<=? X˴mӯԶwm20ƫVU5] زgC(LCH)F'Addx= Fb0q5"Hӂ#wAkշmi۪V55WTok{@v}o)v^].Uρjı[ fnz"O9clp;S'!>?h&/s"`/#*oPаY2<>uﵗQa%~x[ wZDzA:/1 ̅T`A*۪Q͝*kRv[!Ue -voZqTf껍lVce%,%d4M D4|h&,9'U5P_V֮*CR`S3 EVӂZ8VU#Wel@4 \N}&iPAkWY}MK֘&8P6`;C=P[+DF ҷvl6_-UPk3h▪ʹ{{( fZ6]& !@] L8;6 $M \Fqvy*js//^&ZMakY v|2(͂54{a7I5\bZ"-Y}I~k%Ѭ5Vmkw .k557a efqhIk()ZT沲 k׶x,UU "}JK]Uocj6 b݅ e`uhucOY*;gf.D~Pe2^8|jPlZxpOUs&-M IL890]8Rrˈ]niԂ Mm[UXZ+,t}`L7ۅlZϡUbŋv:L, N]Yi6)@S - #; vPT'b>VP(Џs[#TV,ίBH׀8}qRsl;tۅZ0)$Q8261$aQk2陵$1ouj"Q~, LueXq)`)bU"% l~]8UrQtDW,VY,`Kp$A5$%wuM\ | rx=eW!+UAEj(7^(?s"H@I~.BxMT)(Mc_@\u*Y-5}=Yr>_\kɝ/XZu^AF](?Gr]5?G]ikKWJeœg_̻e!㮀uMvWiWz/îRUdוdUYdՕr eӊUK]{s>,YIT|\y=?eUvKWV^V/ӡeˤעc=P\V/s~bTx6 !Er1UMɣ*k&Kk5҃%keekW@HJ]YŽE; [ryxݙN܂9X8>wɋz8$x0=nsoYaɌfێwaԸ\Cqߴ[Ƿ5bS;__<2VUb i@'N4]3M/$d"Gs=OVc(糓8WZ`\w̙i x+ B,N,PcZ&8T(e Tă$H|_??ﱍ}_W.JոsOً(:_PD.T/*BΫhE ׏⚸jሻ—}3<-:в7 0Hf (L›P~^|K?oM(Kπ#\/V(ԁXC~ x[Q@Ks rp?=cݜzxo~2>F'wrxEG6M5ǯ^<9LG fКCwTQ>T>v)7U WOѯo%o5@im$?KvLpd7uK2Pucm*>_I"yDH]=y. Ntz\AVZg^R nJYmjWn1#_Kc_W3 tc䦙qIēRʿ! /.H*reKtRxAIc EVPt ~(vܮC)CJR9"f8&z6 vn#_^OnL&E=Y$f'4p9J@L0~GΰG2N I/"(>yP}ϸxV+ Z2+Ϫ*!D%/ˤٌ(qH ?-* 1H|nS>P =Lprc5 |/Gm!CVԖ9"bGl?Lr~K3`
f=vAH>;яJ= JqKA II:66rf,~bmf~d(L ~Z|FVќjxc>0#s.Zzgc_C2sh sH(@VÊWv>s GʫMn@-yvWpA[??*\a P ,T'hҠ#”Y ȃӨx](Qz_ F:[%6uǦe tA>' $ގS?T+y`zW^#/nens9)Se W8_lH8hD1 9Nqol$ q?P !@_\IKP8 Jq6~+}0ܸ Ipъht2U~l}#oT{Oa90y:  4+g05,wrO@[oӅDU \֤Ϛu>T G,t;6UVվAlf!xa#pp*Ox T!P+h;xe%Oi[aw隌KȏXhxh ?{)?v~T[Lٌԇ`j_9߫AB>4f <'wJlC{0T}\>U"ݶX6%4Çg?U L]IɹJ9fҮ]ṁI0 T'N4yS\2Ɲ{([MCfBESg\XK{v 00a |e(۾n?tNW& J&&b IA+C’[nU 1YF.ϲ 7?5 99Y&`՘EBVLUv,PE6=3D*)WqBKYp^5rx9&2cs0&zT 0:&*=̜*@VDP\4 ^+u :%QdN<}(L2}c@/@ѿIKZDPWm*ޥ=E<0zy+31pͳׇ:CV6׆<5EE\5n7yܭd.mo%CVOBlѧ4Gr rP)Bc\sl!ĘUJ&Yʳa@ ;(:'.HiLvAPsɰ9r9Lc2~?%x%4v8@Gb$ 9} c&A}5_0rz!{(}W1]A-.wa WtPVr"腱g!{ L2@Y P"S{\ L/FR}sL~<3g1ـ` QF8JBO rō{Hv.CeR12g_$_HY~o0aIyr沄fBn,A̒h.SyPťʒWSPja 3A>H(Tn {@CA.̎ab7~"֯BA=I6͂'XQō')E 'ON>ɰ|5BJv髹Z23)$",640&䌽]) o^Z=wa`yXQ7vD*WQt2p&h$?5)\L:2c)wBk`CR\}QN"l.z cyh`P@7pBL zqYIp #GMY)p^[?ZZ: m7L"EbhRAৠ 3c/錀w.@,*%X`"Vՠ`LW~1h:¹Ʃ4 <ȫ^Wr8 1w ?]\~Ov$jQ1 Q$}dSnՃW4SUa~K o[%J A ZiR8-B@kBnldDAu߭A KnWEdp0PMBGHuo@S"ɱ>X1|,Уlε4Bʪ.O([5Ď{rfe:f:w,aVa]Ržm>cmTԮTkNGerW8dX9>:UDZd-;oU%,HczGdK YV2/6h, EY”8ֿ I^v7Ye"kjq# {!Q_H_pG!Px[ACe3+hbO\C ̂J$3²O9 %pkbd#@ϡcB*E3#*Ji3l}/@m&Gtq[naTİ|qg -HlR7~y!2<*-}W(/*3F Ssm~18!y_ ea8}~z?©[ U=qg..O&/v dvH XpJ6kϟI5I<>x6X$0?'q"0<ݯrMUȓ)7$ B1Г*nb|(}HPV;߄ܮ14x,֬# =|zL*nK|ʋKWU[ͭthKrN8Nts_.v'P@"I)ǸS^LsRrS:JxY^_>]ޥd7/`&b0ARݯB'Q&?c+p}TM.yIܶ 5AEBu\'BXU A!eLKO%vp}78[F,9+?])p|/\=h[%&u!8( vЧNY]2hR$Q=-\b^@e+vx/oh5%.ZJ( owfHџn?+䮉~sbצt1 T&\B;t\"{;͹ׯf:6=A]woI(zꊡ?ۇ ucf2 V-P~|5mvjz%ʈSkTݿz~;~T1_on5[s`z{k}mK@b! uN͝&crwtBD\*NCf9xAT1y8{.a$d&E}wɤLQSJaM*w<d9* @jR2ǙnX"% <4/N /v!=<9tY9_ܵ_)'<ME /ф9iʠ'fɁjm&ݑ;UI Fc͎xL% +ǹߕ6,"xu7D$^U@᳜eȔЕLyQ4o٬$W,b؊ yX(^ /eoM4S/L _`恟?oP"?K]:q\ _ &Þ D#xpC3#$v}4Zy ?= zŭ rsLd,V@| $Ֆq=2r eiaT|Y?\׀LBDF* J>,r4M4c1m,e hsRhyˤgj3ERD}Y(G}$d({j?,'Ƕ<0̇2|W PvR J8fA xWe+dcN'}:>^"sJF pK`bv+:fh M%e%wY0P%[B 2 w}xd#lK=U睱ft\XfcGt Az{N˾1+Ύo2D6R)5sQVIP(.*}s-1q@'enf%m\^S$lYWa"!& /m۝Зy((M⸿x*v6<t$,g*@ 24"ő$0E#Yre tT-#뀞 fSju0Y~JWwb(섞II#6Gjj̞0)`浌> ZQk|c)x5d6 #&L+Fܨ#*f-Rdߗ/=-vH*ĂKЁZ}?`.д& W/@ޤz0. /&|AH%#f'79s{-g?yN{ eVbW˙\\#Y/tCt` ٮr^#UBm1 C<"bX F86 X2;r*`qyz i+@PBh4C dLbI?,]ZuK oKX4nr:֊iD;U4 '-d!%ާҐSo{ 0x] HQߟZ}P:se| J:YfוE""Y|J샥63 C`Z69{4nMK|2W_ q8+/6ǥ*?+1c|s?1 P9PߖŨ7"Uk8K!fns.ZoZ<nXU9KஆiWt^l,o$ >j !8^ʉc 6l s5k};Ct]-w4)R 3u`%<׷Zovףd T6#1Sь2 v8:)B D;m\M4CE p9(ؾkx|F`-mRm.@4T[)Vk+U?rsߎRumuWV07[ҟb@ߢo[=Ze;7*sjMn Aq5Uis36~zW {8cQw \A @ƒ%*8!Hhg(62- LhxG@Tܠg @ nˤσџvvxo0CkM[m"1ַYxnFe*qxe9O?XD²MRU GwK^M]&K"ȵq_l]<;fB%Eۧ0A} G Ϡ@2\c'Xx[7Tl_O7_OUV} _9fNR&p&P65B=|QTGҘDA뺎Q|y.'E? 0m?9կ ֿboCi0E&TphCM1\A|zr{jS']]]) lx #zbTe WC`bqwxm{䁂TnfpR[N~1+ TSVUA\^s뚚s+/ ;~+4v0u+?cs8v> p*g{2_|r#9]8smrF0p=g ٛ> (cZj7t"L|pKg ЄB¡Ũ̋99pYu#I#̨T ܸڸ](؝_X(oI}D̸o4YV67ort]2RAu%{_$;0O=O=tݽ ##ԡ6~ 2md_X:$noX5O We3%Hqσط.Ӎy.,c-j&4{<.*ml+Rx44r-<ZExԆZ+ ŭ5U׻߄5l?f:!}Po^ה/Ҭ,tF.ץ{)XQIWΩK^.̗%D*Mm.zǤkb,Əp)w0pPSލ,Ury@/HorgIѩ߲NQ[yæ ]g]5‘g3$ifU M6 ^ ̀gF詋1rߏ5}s.H7ZwEnk_^hE-)ڵarwbj]a-7U_AiJuM- tϾl nlߌ;5^>~dlB xg1"]mj9EŏJD<8 $R0֘R~.^[ïG-<ڮ{I4er{f"wѧOIjHrXse7JۉOŷ~NW,_NjT^A~|Vk֫Ɯ eBsSi)HZ!>B)%N([_6+^W|5|xkzR|'?غgE'}ɷ@K}A4ˁx3{AN&A2?PJDIc]`֐xBf}iyM.Ji\a(2:'phB'(Ȱw+"0y `t2) 4q<{-W3bYM#ERn QzbG.G֧~Ξxxţȩ~yg"Vqz(δ;v-[ԩqKWŘf$gazϮ$]Yx2+ w4k7aOwEDkmWG{[HrFsPq53}kG=oST*ĞUq@ONc2~=r{'y#n-^/ x"w,0s{S9Ϋlp̼țF5*䃫 ^fo}žlw5{ӛ*wg*Č=uqSў5[E/)v@^vVĬ %hv {t z3d]y!̵eܢh)["+Ejd-~{M9s`xk,Z Ti ܧ$wg$GvYyalbU@dq}LSߞ6 Y+4q~YS_gpaz)^J&=b8mgKDENv׷E'jf̭m)ʹkI #{_X.}<Mfr+z&˜5l1,:&Cq~M=ߚз`kߋ,g9 7Y\i-9, "vJ |yCL7I& |`@,&(Q/)Oh* (|DQ+oxI(WdӺ2v,[~d.0@:GAP-xEbImMbOIo!{Eu,ߛXxN`,#g 'Ea=Q(AJB!c-]iZ;d'zu!2NLE.qO4O2=a?)|>1C$eW:#ܲtN+`6EGU.sBg)[& Eh|+Ft mw./(fU9̐p#n@Нr(Ss=-8eߘ e/U4] d?? 9Oh( NG]L89mN