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[ _&ݮ! E$# Sa'ml `._?zۛ'4sJMLyw2%2ƿ3Yhj!LjWN=kLas?di{ԱigTzQ$s"rpd x<2Yll(Zm2O4?^M"'rCg"wPzvuF} @8{ a'̸_xM ICvg̬֙ SÆ]+]~Bh4Mحƀ%&?q5wBm %eˍXY<:7uFV^-ý YH)   =e..<Ūkc nIHo&? -UjBBmt"|t^ETƃRaH:uj9jy/VBI#"vՀfwfVdRcc:۱aBa"BxA: CyrH &BKΑ_ ,EEZ< /tFߨ3Io៫;IF6DH?ܯ ]Yua`yG@ވـU|U &þnJ]1`XNCaX:F'߳mX ADzz3Z+9muE7m3 TCK w]ZJeu;c= PԱ?Z},  }w2 {T/2ѕ2MpEw1Z!yHe!)t a:iNJ=kcjj}Avz7glY#ܳ-F9bh/`~src6t^c;z3YNhZ^*Zio46𦡏8|^<`o4z PVic VX) UP}=?.&DiB$lK/H:q 2a mb8N@)\V^HR9ޣZ /`N3hiJw8 {7 K c'"Ћө15[#ufGX^tũ8_!HC6B~a;ܵΡǮ4B4fv#~zY~Z3v`*R*,egjYA\@,\Z.Z OMW,: T.{#0QuqSo}>PR #יs+bQDau0eHi_0!x}}Pc?Of`nٶMR֐+$ DDF}ҷ% MZفi6vb4 }P2D+i@3 4Lm6r%xՑ?'4 6;u":eV7.}`cJR?l!41GSdlϹnEЮ%yfrJ1mˊir:[Zy.?nIP+)fHh[s% if)zJܲr%Rzi"&lUeIAVڃlUՙ5XM* Y U$Y <Ñk?X e Qp% "` R]B*'Wj֑90R8<MEˠ6>?ƾ#WTF&1 mF$aHN! Q@E\ebmMz|TSzs~+:V R(e<وXK=>ƈV$ASj4:Q2Z?@>WGYk5rG'1^(IFUjlݳ!Ad!eCNKcrX%>c%QXL\RA5F_jkj/5j @k PV{@w[ ԫ] ]t,z9Lpx;*(1-p90ӵN9`+s0LEQM8 ުfX!Pd4\]Dq;C{4l>2k~l}^5zmcEa&3feFm;w%XjB/@#]5(ֵ5)65,etp5着z93ntDS7KICkjzORDviHG bKX&p8HȂqsTE5 *>|80/ ]\s}ˎsxS"h;3Z8D˼e2Txq'>_WJj_DN|= Yf@e諫J⪪ ț9!+~Vh=vU.L)Y!йM/|5"9m'/L]V3{ h3,V ֪ߔFWj~I'|كO@ܵF JCr;vrJ9_A*8oۏ;}Ĕ-~r5pu 2Š2eP){bPo++ُpXVO5bOؖ4kʚw|} :8cs:7$(YbǮ^cYJwi)?~F/`:2 el43֚OeeX@ukOQ2*97 ~iⒷ20Pߙyä|I|lMPyxt@")R<%4+ba_;Nkcogn'd~9ՋE4_UfH [?}}0z5H)`V?"Z<祥4u;;$7͌K"+ѪjD_^cd1- `IѕJ#3`+:>ZA*Kp{h  @'4+C G$SzJ!07Z{~uEt ~<Ŧ:$+'"D994 \`%&/HWBa O{=8O=PyϸO|6"-t 2ivΊRMTy(Gb4-* 1HxYވ?s8&GJ^ ? Qi5eWxmy}ZJP[sd%L#IzPfrAG1 (FfCS$u u4l4x1]9L1Wk&bH*02C}!0CO .JC*HW2}.I}AC&9W19`CɎQP ~?0-FVќ5<4 8 @9WF׈XfM,n)OAThTS9MtTy!u`0BQɟU˳rnF2V,b u0U2kypO |3©3f d8fܰsxΰii,'㄁ĻqA%A3w2B*;P$N d+s8SN**/pJg/2_3zbl!f03@cuhg'yLA-0 HLZx\4+BGUm9XizqaЊ'Bd'W9(RG'7mPs`sAk3 adXtiYQ#6ioCOop 51krm0OZ`d1%b^Ψ8.`c%<`fc_̗V4@⮹˺WV6e*ؒ d$f˅h sm ,ZwH`U2t,{s#"-h nKv3p\IYx26c +AP`RLV}˰KG[J+ +~>Àg$*VtGGՋ'&>( 9|r4c2 5l.@˸O>x'KZfKBy(;3T߃Y(?c㰄5JudCC:4U-ESg,fcѰaH2p&><~M2}ghͻ7^$ÿ۪*+i^V&K,_YiB)N,GG v???V2k^Z  w%G؂,Ăi@ise,-` !+S>3g&(cFÃY~_V, gFi.DJ{ 2Ax#";C;da2x.yb.G]jFՁ(~^U$G2&q0s9R-wJ#篜ԼRȬ+I8aac?Vqtwz `dGdE azHŐQXfD#./٪U,G‚8a𩓿G.!y&gavv<-D2@Gf6 A33E%HJ=[as(nĴ *QD '1Sj?D+%}&Y ,?Iʓ3%4r4 THLJ#%,SXWbTcG J-d񈨚 & :HAퟵ|l!plg&y *&ّ2{i<2DOI[UޥYSd>qkhb3E1' jgGj.ˤJȓogU4A(f K0׫  bGrK'gFOX#YuC(6n^:,rw_2)ļA`tp\ʈ)/Iĝ-Eavo` KhNh%NO5n50;0 a4۴8n?n ?iiݴܗޞa š b9px 0Sxg/+ \q`Ȳ0˪"3/PH#[ <:stCBQ+JSZjZ]n-L6a#e"3JB!+POt7bR߻2Txql/XOp}U2HbE('Fط?qD+nec*%f݇md . DJ)V4SvyDſxSM|Zbi|KTߨDS#-#ëb t4;Ib.^^Uk1KU8*"|u_$Nf@"`=^gG(jG|_Pulzeor 3 a[d`r*q* RWNV_5M;$^,JDP"ZUQ{yP'׫"@1@jos^X_q [^!9Z5v Pȟ18n0HC"-p CeTD?B]aod/w|PACzj; Hhuie)D)x(WMfօԧ1JZ"Ô4X|a4Qtɚ>_!,5D<|>-&`[G L|NI0ްĂ%̉^lǶ"]V&hV&t^i'90T xY(P,y>ad F&—|lH|g%r=JǨpu}.ܹ-]a{wGҤVPL(H]C a30O|ǖ ʜ^( b畂! \S6} 濣q%;fؔ~Q08 ,y%#H' r滉o @HK rYښ+e8.Wo'c ϣ hv\ل+ KROkA MX!͸ueFleVIS >5}[bx;6/$RЪOY%RzۿΓ~R=*L p%X7`Ы370d0PMBGHbo@S"~9+A"P@<Wv/(q}M1ҭ!Nޓcaffff-f' pW *}t0xR>RVLGGe[r Wy?dr>|t˯Tb6m;ƌW.0ϳ̬~Np@ۢln^߹$囬25B_?/!H_pg.ޱH+\ZACe2+h|OXĈ$3²psrlCIi|d#@ϡDŽ~UfF]Ӏ3ol}/m&Gty[naǰqg mHl=n]LE1bDѦLv yY{Km :uF0W6;' B:D|1+lvU6fڧN}HPcVp0Pq奏s[X+na.X;GKP8lV>8MTxZ*/ ]8,B"~n)A| NV!q-|Wcb?"H dMԯdkud%\ ư_YܼJxUd /1 R;:p&/_: .*,]Tpw6 MPF$dH|~N)n/.2x F%i}_;cJʀkfˠkRq_xr9 ά\0BN(\ӐۤOmؗ<<g;S },3>S246J܎4GQnvq@zU"jajGmϏEBcpLyz8Y(@_sPWXtO3!ٵ˗<& oU0Y{?>'a?Xp(ƃ\ϤSK9?Zzs+܏+ǃ*06 v!TT~Iܶ jNj(OY`psabW6X&hF˟-ȴmq$QjwCn O{kxW4Jwl,|[z% | U ,yjk } #Ht!UU',O Ư2|:ǯR$ٗ4 j0 ۝{)Wl)^;Y-P* )o1B3Yh+cDrDR5wS:A'K 3T<&ENYp;͹t^;1jI4F'}x fnBw7  0K°!~J׷٢wLW?RGӵ?CY0U&wsCgN-w*@ S?>o>`ni0Po5gKX^Ar4À}Z7unHבּ8kF/{c= Џ59Oxx#JWwUg eIH`;.DUT|K]rnwYl4@I+I5q4{Ҟd8*q + HE 5NJeiЮ]Dgud] ]kBg Z FOE6=Іx I3K6er@䖒ϻS NK][bfyپY Oʍ`~VP?%LŴ*|M,w(R%HZHyؚrdzK-gq[׋9@D ahYB*CSM{*Ҋ.FSЭ?NC#[}︌AKnAE@|5LWy60f HL f[8N^,F^32< 6 ig`"D2TYhJ.~(!sB2{9#O0JR>;sSp gPܙǰ;"?fE*>コ 0x1fɏჷRY3*TÖYJQWK.;%(_gnRPYeĮ:6j [Ս"4XqtP\-P %Q9+ye]׀L\D n8>QLO20mR*WU\zYz걔1mVc9˩rA=8sRhy+ !jv'q|V1@DE(ZGIfہpmvz*ɞF4rr[)vՙqC-L %#>8| W +dkC'z/~RvGI%s 0[|$x3"VJu!N"̎gM, gEGk; ȸ_Pݵ+3k,/8Zn[q3^Zbfz|qٗ ^7gmY|1SFk'U}k-?`u:d]fKڸJk/x$f uΡ  5Q %o;ޜ Oib+Kb MoPxKM L*A Ł!%̉JPt(bst6x:IS?\@reVYcSs*=Xgr]]hdrDg IU Zz|+MQd59#z:*P1=%(zlXCF!u7oè'9gЊ]f突 G0-;xM+Vܪ[UV*7=-2 xbEc*ӏ hIx;;+" \F%I$_YΒL+E4' QUI"ӕW AiOh 1̀X0+1~pӞDg9 +ĕfa nA8/èKh!G=L.8S=]1ve>PXe4g"/=t&{}rvuF} Mb6tXk’S}PZ*vZΧ5(,AU VfX sgE|rlB#ewbD6ZL X /Lzv{ntѸٲ]5Au5{2N{ԅzg3u;ch ;6g3"!I/Q/B2vwwy]|Gn<݅]U6}mk/aK*o!"68Q)l<<m^(yC(a\Om i>g [&m1Q2W[X rsÚ0X$7f=}+DUWxUg"ַ҆s/3Sm'?PIl&$%nNRJ*/aHKR< !<'HܙEĶk"2NT˥fZSJGI}ezhs.HZS[ȭ2"a_@ǧM^^ ~>Ίbgmыhlۅ˟^y{щ1k)v"=4enJmؐW |~e[RJr@kC ,ta^t <M9!\65IR@Cc=b6_ṖxEfElFe~<n/!bo,U_8MxyF;Ή0/ct0qU4DDb؊ǫpomQugfo22|Wv.4 YgwG+!ꌡƨ/VŎ0<~R6 1.H u9_4$G ݤ-K² %1Ԋps\V4>ȣf̳p NF&Çi,<Bx Oƃ x{2H+c$'29m}ׅGx@YFVd܉.,}2ooYJ3?sl͗D^m^ņрnn>3\x_"z=H+%ʟ[#':>q ZP& oMd,ŹF(>"wB>])s`^l"R4>.f]L-'12Nzx!lza"COOO}iBzCn ͍3SVےڒPV4]Ǡ}PZd?;$8)ϔ[MՃD qfKI׵Vu[vhMhj^gzջ-遤ZmvzVGFtzhFn6ڍ^o&PUIIR@kRa!":-,7w$ 4ZV607/eڌ :@ 5bC08JϮ2#fѻTy@_dfZB޶ftЬiM -V+ H`.wېeUoQ]oFtZ&C!Ydd< ɮU "چxLaQ킷:EGO.VR=fl_83tL zZ 3t zz# 6 x"3zм6tS݅,zb&6xn6T:othvP:5]V K !*bI0KK'0mRu$T70e: ä-u Bd:&]}sDP>;Ih- p+] ^oOHbA/%nGk5T)Շ)J0Е6J)7ɏ &F[rnDG`={S#˕:CJS?z̻xSrd2^M k}<eӵ_qr)1Kg :7>y>Μ 9ﾻ?53xG kSJLBy8rkՈ>mC^%'ijU,:`Oݷz80CGiM(&^^O*=OѪVgh;q?y<6DZ?sIY>G||.E\vO>8g1< ?f{ 街m5tx6fgRћ?w_+19TK`kV5S1O=RS s8 JJ][JJۅO[G݉mIէ]خhFVoҊ?3ZyFl<,)mw #'QTӄ%dny4&țζ.kY ѭ7>yQ]xq7ZO<4Z:0ӛ^et[EϠHI3X6I(@PS#?r[^n縕D٭ YB:uA<KFfg ńnl+s:`E-<61|>y,J(B[U N=}dO`o++mZ_Д0oP #g,v ~ zc^+Ο]r+x\[Q6 N)x.+jgfͯP۹Y+NC6*uw? } ;ixEU9^HȩSE!.VM:YKo"x9"9FPqfLott)x;OHzu -4|Gt1#-`"hxa< o"jTy9yieF%2S.K/"ŵO^@b4w5iMළ!*q3Ѕ,&u=ڼd3,5 "s`M鼅mUk(5/VS8S| \`mǩ;ޒ(NQ {6>xjGm0TxXE< ~|v~ ˿no{n +^G+.$+Z8JA][' Kc?HǡP["7vm(bk3#J^'Q6(THj}vɭ%׋rQ&&w4q6ejkm՞ժwh]қ^͖u9#[*$5_!ϸ6f} _++͒}@*ȯ}|bџů]lVMКe TgU[-.`J0&`+d|=Ol% k7r1=GSyϧ૏nӂ=w^aE]?'eV/>}8*V!fԙ)g%RN ?r%nxKٖU=p`z)U+ٺ%dup0c[{q(e5-\rZ ??ye6ƈE:0BI^-ޟ:ϳ M/lU RfF N³p\iOcrBE0br_t N_`6ME_(_)G<1n#f~oňn1>w[;ǃW2 wA~g~L"(hƌSdA٣+Ef0 xJpɐ{FJ|C/AR'-݆:m9<\i. uV0fhWK-md<$ŘLN0%G[8\uYBdJ@r:ZsQEFL?wvNf<FxʌPޱz}ˀJd 1AߺA[}́H+Kz>lvfzU4:R^)w$?|87 Xc YW?*"0zݓL 'x0c֮qBU,# p|j90iepS $j tC1CIo\fL’%NO' qaLtjlFE9:sf-fC@;#TE ©z,bBz4NSwj{޾0W6#\,+|PU;zkچ!WVi} %-->ldKElr?e0hwZzc1;; KBEQ_#g|aReřW%5)bl1kt`/Pr|;8E_IAXmti>*?׫d{ncOE