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[ _:Mvs5I:^)PJR>jyIsMyce4 ؔQ4d6h~0 ENw3uNJǢ<@z7e$?w@ ]O3^5+ۜQ4fwf̚0u0llߵ ەj^c'.NYl <+Gs5Ȋ߫aw>s! I5buEXum P5w!?-) $zِR^1=!*8|M5z:XIžiB؏o_!}[F0t'u\]j^x#f~:Vn+U5 a(u0_xXNCaZ[$@4ms˞As#?WwFCkE6FSѻUP|b]{hZkC Png#`9C?T:Go03%U$`.PbaϝesWѵ ְ\K..G 6},&d6:e0\g2I`]d:貘[€ACQKnU_sn]X[H`v[ 8Ŭ @lH&mQ:_sM`Nod͎R媚Z!;μ3Uؖ]gp10}95bݱ=ߊQ٭vgao4V/N-ִ7^xGhC>sl/=(+`41G lYUEˌzܾޞVMo4!6YB\&O}806Z1'.Q r$HQ`P-0J4SVle}hގASdnXk~ߙay2f AJK uk B"S_/Ta.;W g8ouiКexj:dHإrk-鎪3Ԙ|󁒲o5\>\[ѴF* )CJ:̇ azY6s˶oX~J]ـt'a *@ק%2ʨ-lhbDN=N 7Y8>*q'r8]I{tȗMaj9$Կh^ǟkgS laUpR9veBCS5A6]fHVZYYWZa&7Ӷ&ʪ3yLlv) y%8Ý摞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/O[4躑6CY6.NMU|GlzTwZo%=S1wCT3sqV!.%rT31,ȻEZ/)݌#%؍-Zp#|# m+m xTKqzvJI9@RS$B6Ъ|ŋv_Z*Lsʷd;I TIL)2LXRR0lGQWx 34ZAF(Ry#bD<4苓b[3Dž;DXO!‘3sL]ĺ/YJs|S=*,0U:4eXq)) BܥWU)R!- g*U)\q-`Kۡ#IPfK< | ]W_'oiupVUPѲ-1i")ޛ-Z7tH F>7os*Z>|N%`N|N 70Sgɝ/X꼅yyMZ}~Ud_f/eȼ[ ^2Xm| vZ>O}~˰uu뮺̺PuSQblڰ@isI[/~n3K-?m*v>Z<oRֲ*%+A_66~8یL-~KgUne2/Fn niuϪ&ESRG~ɣ*kۏM#)Ͽ,0cq^Z޼B^l-R|x^nՎl9e,-wgs`NGu,+[Emd |v_NQ1Ƣ0W32m,5wߒoXc(nH{%u~C?e}U^#g͖Μh*Fz" C:mhMMI߮0 8V s K$UgIY0yƔA%1Yڇ/<r3k]"C}oqO<bqXdJ,ϙ@7ir_-"F'4=!CMT*Us2 ..=v&\DTa0*G_]UUA Y!#Bry`HOJ.hʼ|!~h;!~e h8GaJ`PV 5n"UTL}x:5bPW)-S75Pqp]TPx~CDl) #-+x@f)+fE"ОEd)qR4ĔA dFw}@6ړSg?bYgRBkؖG4kʚw|} q`=tH )i1VNNd0SߥO0zӑ)cSh ;LV&T7@L%R#-~ &.y.ʿLH~ɗ6 OGx $,"SB(36vvI"yxLS X<1M38Jqe؈N@ؗ/' ׃2mj(Pn>#{%q@_SIr̸$I[ < K4NՕx:I6@RYVI]+$12Cx VV/} q]z̀48Y`8&rSu J80kS/6&Y9Y$.@'ϡi3.!$0~W̰'" x*Q|Yx}ds(!dVWAnK^I VoGr/FSڢ^SdǑ>cN|D S[ @XVSz%צ%1GVd0HeV>*t2\ ad04NA2Pb\OFsj< ӕS ? `DsfB h}$1b#S9aoחb~ 3p}^-@H>?яJ;rJqKpU,t#5"YC GAmUj)ZUT(?zW^q~ Pjcv\~mg@of쪜2[Q"@e KwJ*:EZzzӇ* pꌁY*Y57l]0lZv 8a ~zPC0]9zJ S0>- ً׌[mHhD p8(:IBs?xP C(9 y8 JqU;x,o^܄H0ފh!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@( 91oH~ ZB@>xﺿ<4̵43$aDR9& J@}AzyC,h'x)lp2,!іB9$aEoC̛DӁWŊ#zyh⃲0q OMAs^}~=Y2[c0EYޙ@!%0@U„#sց^V&K,YiB)N-GG vڿ?V2n^Z w%뚣D؂_,łi@iseO,-` !+Rƾ3g&(cFc[~_V, gEi.DJ{ 2Ax#";C;da2x.Eb.G]jEՁ (~^U$G2&q0s9R-wF#篜ԼVȬ+?I8a]ac?VItw~| 4~"LN Cp^sFH{j;xi40= C2`EA~@ZA La0B_ோ]g,KNQS, ''<99 HfW8;zd.#%73AW[DtY&dB,}; * B1cWX:^^z0E=Pl38 Ϙ8c_. ' ^a=Kl8$F>=2\x_q .gʉ'Q[4(Gɿqc62c"+N\y)NxSM|Zbi|KTߨDSc-#ëb t4;Ib.^]U0b'wOUr&; ~Aձ镉oe%'0L{ po}ʩ `"gƒovvH07Ke\9[}!4 0zHR"*+AhU hc)CY~_~qqnW{[װKZ /^i E^nC?>^Th8$R0[VI1>M#$x&paJYZxg!(MU0VԋFg'V&0" A$ =њR"`pd}/aH}ZpL`>@KL*O˚9Li.A%JMIがRC,ȣA7;RhfuKĚ# K,X2M͜H@)~l+2ee!FLaelNukzC` ŎrŒI& ϑ=aTabH(|W9GzVo*7h* W']ҕzt-M/.Ȅ"L05<wlI.v^)h5ag@l;Wn&MI '’W:⁄qr+ϪLaKpK1 䀴dɰ-Vˍr*!p2<`̀KhG?k̅MVy*$!ŹK4&?2܌KQg _V`VFngH:u "a.wH&E+L:trm߾І>29nM:Dsg' 釈5dn rw ҕQH%qaԶBhQEU)Zt}92TMt sY{*f*J2 0 TpNbO;&8cqX pqO, pdT+9F \9 X!\]Ov:$jQ> Q<} dSnՇW4SUQ~I oGp楜TY@ ZiR8DC@k\fDa8!A KDnWg(o`4Aa𡚄Cbo@S">|,#-tυ]  v\fwbSLtkfgfsy٫f ᵂm>}TndSmqbUF+}}1KLl3j@&m#Ķ(W. A&LdM)na/'O jR$w,RVPY S'"%)8 n&ܜztPn|b_و;sh`1_㢙GW%41[cߋ}]][1E/rRf,4x?y-2|QG5Q?wv^VnΜέI_J,]M1p郼Sp>n1TXs8}ǹ-,  0,sHzϝdq(6q_&*<-c`WI„.\a! ha7 >d+kh1V$fLPh2B&WqWr#kud%\ ưYܼJxUd /1 R;:p&/u\0UX,l'(AIVɄ֍S 1߯-^\ eJ,] d1*vƔ,̖A"t?0]>!r'ܝYYa~"VP!Iwi);//x[y."w"b46Y˛g|d6h0mi5"?9@]ZJn[;nĻNqz}sGGiOsz-#g偁qW^+ ܲi1p"`pQH?4*WM&!pa1cQ"zw* +1ET"6kr\t"q[.pk^ty%XL|[왵 3>UtՁk?0Ld\I!2 hq$Fj3YLs=^2X߼"7 OG:u& Ł۴.lcܩe %u2W8JxY_>]F{X+m7m-R01pDPߚ+e`T:|y =EU %_z2ZLFIlеŠmvB@ni|+/ٔY|J7\=X=s>FLRNyt_oet_H</=i`5; *SR,w4D^;6?hjZ*T<_ S)c3Yh+cDrDR5w3:A'K 3T<&ENYp;͹l^;5jI45zJm'Z; 5o}R(G8L\@YF U͇c?ϵ:5iȂ 4+: ~@ ( a!S?>m>`n6z~K|˗҃&@U/}V9?>ԌAӛ:n7w VAkW1K{G\G&JW7 r0iH`H.DUn|#LUrGYl4@ckI(5u4{Ҟ :* +:HE ȊeiЮ]Rd]$]kBg g \SFOy6=x$ұ3K 7er@?떒oS NߔKK][bfyپYꏳ ʍܯ`~WP?%L*|M_,9{S/@>r ~2X$lbrlȱ$AD55t3 nRJ3mq8 L72Mi9}88& &_i'd^9#nOW\y+xmYM"@""~.NwalM9IG2Ɨ3ҌM# aͨ@DG ahYB*CSE{9*ҊG.FSЭ?NC [}︌y9KnAE@|BLwYy7 0f HLy f[mTn`Z-5CBle`x±S`y(_^F3[m€U(BSpO <-"5K cG/H_=~sCة| y PJX.F8xU`B)S%s`YZa%AdwՊ Civе b[\5 n>mVHc!эYdfo*#Y?dȚ3v+?ˢhٸDy,A+ڨeg+;^PzHCуrXe6_{dmp[3UJ ? p _|prBg kyQTjy`"( hM uό C^op4WO3^|<<&?W//еOb`ᡧ 궪ʌ3t0oaMhRP0ݨFi:!av]oYnۍNw87[Vk[&fO[i]tf7ngla 4V}AlƟsB$ *2*$|Wpw%?*P-ͧ~]HaVlH(۸vkv㱤o-i3Ep/8敏ˆzXw!=/.$ԖM̐s&O +ylnknL=ZLa$5 rsĚX$=sf=>C+0LEt-[7H}+8ws>1vB[" o(m!XfaBR"tgetԫ&qDN!%‘"m&]+^BF$"o# RxH\j4uӷ\7jX6M1%*s2{Yɫ|/ݟۅڢQoم_^ysnЉ1gc؇|Cu1'R1cKJv6 qԐIx6:KcIAE(Mm33) ?9AHCtL3ѵ :,B}N12-:K/@zBԱ$)lѷhVThЙ|ʮ~|^Ǘg_xHbWx{F &*~\_6޲Zm;FPJl q I>ѳ+Vy'bFN]v}c 7vHWF[b' ~*)7?cyO}g dE}/vI8`8ay,TR7}@%Hh7in=#nk,Cpɭ̮ weΒDo%Fc'QG_ ޔi& <ByM)<o11m3*iD4h.8,5/xB<ڥcT])^2\Q699ӉrكV ߫m|g>CTp}{ϭ]qovKm(~<ЄҦ2 ؜l?܉<Z?MNņ$`br2#KclE9pH:^ܳ3ASzF%$^$oxcܔն&0tùOL?;ax)*q@, kNNЛvh [z%=kkzZ遷uNh7ZzF BUu$'KmKhT꛴ތ_.Hj[]B&ހGEj3H)̧ֈ }SiIf^dX>U]_\ zzzx' B03h0mۣFGmiNC #+5n^k [(ΩzݩjhN'Loh  J>]6{PKl iVނviCk݆Iu:-xhmێ{T;zB42mh=U6` fҎ(D4Iokk|(•\|1$A O&pk>:c,5˗dIr,$n)tD7zqB r\ ʲzZOoH7Ya 0(:@5^ m((:ˁkP{M,c_TZJ?i4o:P 7BPQA-z˂bMB܌1Ct@&Zj&:jw%;n򳭷O: s ^ kA9ThiB^%6= 6k 56`{Z9)m@O; = N2ݵt pd(EozZzȭ#Zx pD36E/*$0V[٤oh°0Z)З9(e3疮n#R%{an8 AS5C=ObuWY:r4ۍ#S[#ȮxEąa fVe1<ݽ! Ou4r 0: ӎmVZF#a29hj4|{ZTDK<]K$6d |A[`vכmQeVTbW2c 렪]fG]VPɁU"G=ayF_ Ϡ+Z!@m8i5w}FD5 VmhwAZGRfA`-.5&iȄ!(\Oщ铋zxUT=NO i ^*@iAIGBmMh@^`׌4 ݔ>Aww.(j # 5;]  S1b^:9H/| N8*=>E|^AD? #p'Z!XdUݍe@HIU]槈ĝ]Ky"2OB̡ц퉠F41Nʧ"U?TOZY"Wr)]ԇi`:Ƨo-ҙs֘{5ݨU'fڥkkn|?[v'l@bKLm:@XPz4cg"=R Ն=ljCxe)pFVow0$<'6W7k Ȋ-Ց( i2>N ®?zYvuf~Yg 1#L8-9r D'hc/q+t_ʶiG15v]"-fI׸ؓYx@֕8~˸U%3 Ox*B,0߄:Qg4oW *X? w&67}ysU:ē1vȨyNѭۙd?c s'Wg3~̥{VVC(k+ $|`3~<-dre ǷFp]/6 X5pJY;oM 3\<f/9kzzkM1bPWx+:8lB:Fgpy ۽M9~JkYyf!WTZ=G_&;t š、(40 JT= +!sx@d9 I>^-劬sxVT&Й(G0lE[*j)b0@Ԡ^f[\$F#mv[3KoPܚznGIelDETKJRݰo7Vj-'j“,\x5.2NHE.q,LF{ x>=H:YAJ|1W0=h1q%!!-k{5[¥-0xӘE?Cܗ㓧eE>2X1M;GS@їkʥ3d~&|桙o[1[L/rᠢU y!Ý~: ?21)&YPZL@&?e29OCQ@>РEtD2+\ń:H09uRX ϥߐKcKNi038WDڿJx'`5~RKI1&kD=~|j%W8]Y./-baTG$H흝3Y}4pϪ\QV8My:}>R I!.aG VGouw}]2+l̯rз`r"_!oЖ~s "k 4}^=^U"NT} gs{lBՏ ȭ9L^$S:?Y.̘@\o$YLZܔ@7;*jRww\}?#zO#?N^t2Fpg}ZaIH@ ݲ7y̜ߘT̫|1kہ5b:}\(9fĤ۠UuCϤʏUjG