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[ _&6q:^)PJR>byIsMyce4 ؔQ4d6h~0 EN³(bؽvu ]HlH''p8|Q;UgfM:6ZJ "E.'uVPe ?+-Z]́k|:#+r|̅,$Քmv뷅?2fYr``bյ1@߅Gl d$7̖̆*}UЏ 6~6WkV"pM*CS0 qxA  ;j?{Fw0؎0.vlsZD:YİOu3 "Ow?RU1~пױu{T\2IB2F3F$.2[tYLc-avo%/Z9uldG/m.VBj>N1+H*П6(0z ۽kT܅1,m7`1PjPYC\US3̻m=cY]mu6C{w[il-+sȟ̚mwzFjr=PԲoM{Q﵁7 }d93{cNsOpUUHIZ`%t1a&J"1`w)eٌXchmqJ*GM ysDLSk B"S_/Ta.;W g8ouiКexj:dHإrk-鎪3Ԙ|󁒲o5\>\[ѴF* )CJ:̇ a쟢5m3o0l&eTkHڕ Hwbt}Z">͆&NJ-@4Ad; rs1n>w"ӕG|hH69ȟNBLF:\O?Uh` t >0ͱs%(_fʘ)r6Cܴ"hʒ 3Ie49VV-w)=̇9j?ޕN(a UJ0c6"֒ON0;xPNcL3(С`VpZmcu [ρ$2[BH:hްbPR*JV ɰVfG1NU@)ztuHjV%NՕٛV1BluE֓Q*z[k0ZRR" ^+K@3amI=qlj.F9剿FWҮoME6U?}<0P ;Mj㽪dd9,hi@hGE;#xIT*68&QF -hg*[@}s0ᵑ9`-7MfVf86f R*.Օ-PtH,{FZsC'馪I>#APM;䒞݁o8&0\_{ݠi7uc0PF/XjL2Y vCc] v|F}fY=0[ؤ*\Iu lH@ڝ5 M0_kh@:5 ]iiv YY"ux :e%5؋qi9jKJ7W<ʚEWM<)UU *̣ JK]Uo;3F :`%:̱>MAi}*]JӖ)BCaUڗ~L j,0p6`돝 q7 kEzZ8ORĚǤ #Z0jT zi,t32b7"fj|/ gėM,Z-e+'cqbHL⒄o0 ٴC./ZK|ih2 +?*&/lS$1r0a=KKiEU\|+hR |\HTg/NylxPeb=$ Gx1Itnpu_&=6$FQz.UcY`uh8˰RR8ㅸK+R$CZ^FURf(:T[++̗zCG%8̖x\%WOҲe5/[c.[5"8 ERh%7E[(oHy|o4$T|J6K/,n.a/;_⭥y ]yC&˛6ɾ^Wy@-d-n)n2|, a6]u#uۡv#Yul/n]JٴarӮz^f,[~IT|\eޤeUvkWlm^q-[&":J1/v:eίP_jąͯ3*9O_TMՓGUR׶%FR,K?(X\,7o,;y T1,[c.CNvq?-SA _bV|yQY)s5ӫwFm`(dՌCm,5w߈oXP2 ]YKZGCkltƽ׃Jj_FťΤ|= Yf@e諫J ț9!+~Vh=vU.L) !ЅM/|=29m'/L]V3+ h3,V ֪WWߔFWj~I'|كO@ܵF JCr;vrJ9_A*8oۏ;}Ԕ-~r 5pu /ʊ2eP){bPo++tُpXVO5bOؖ4kʚw|} x8c :$Yl''ZYGwi)?~F/`:2 el43֚deX@ukϔQ2*97 ~iⒷ20P?yӤ|I|lMPgyt|ǡ@")R<%4+ba_;?Nkcogn$d~9ˀE4_WfH [??$Wa#tzRT '4Dr?xq5h@wv*InDFf t}T7T}8K^/?7 @O@iV*G4IfhgC`n!4LxM#tEIVNE ud͡i3.!$0~W̰G" y*Q|Yx}ds(!dVWAnK^I Vo|#9)mQN/)~FF ]1 'W>Vb-dx|J)CkS ̇JTڒ#+Ad2A$\L2+K:iG.02C 1˧Ad]Nċʩ0gV^3!C>FVѰ7K1rZ8wAT֎>GPxV $G%W9%D @*sI :vv2w}  %;FAeRF}ϴ!DZEs(c6.a\Z3_#b59p ?\QůVzPO7qPց` Ev=dG&{ Va/Ϯ)Su%T0[9{ԩhXTaʬW|<}2@ 5Uqæe Ʃ<\sUW @(:``N9##r )!|艱ՆFaz ׍3㝝1! 4Ê0"+3i qҬd WG`MxLBV@+ eQ\K}qZ̷Y CρC|MIcrafWǕ?[=]HT5&|ĸɵ"8 > Rv4OhnƔy:2t\h#!}%2_ZOLU殮 rfg^Y 3O`KhLKk-^ .1Hb(fji?8ީ: "U ұ`b&䷠E*$- 㞋H}\K=sI?G$ecyp!AG=J}2ǛZ-rدm),'$yh:XQxW/,Lɸ맦֠ws^}~=Y2[C0EYtPsfu=%0@U„#sցlA{⁣ cO73 5P]A-sK:(+1HC سxK.0$ ;P4w tʐ)#1_JuvɃOG l@0(v@8JBO2ruwV%d0,ΎVLІW7a#8`b}f^I vv~-PC^5;pγ12R<4?ōwpHL2EH/|3%C,}Vr7Qh0`<9sYB3!GOA%ĤD:YM2Ű#+8RPj!SH(TA lC.fC ecvp=3?䱃cʃ8gNJ|%o?%YnUyfOXQ̟R, ''<99 B$3 X=P2 -",bk!O依džFWw+,ۿ_V/=X"V40U/tɺ?= cdqظ xp}ebwq)#d(#w=ٱ!40,ie8 9=ո[$\8Ll6`Pkozv"r_F{{ F^J7U)L;K8#,pAM",t_(B!l5T̕ E E~A%(1OiiuqL9SXy/0P8p=,3* ņ+3VHM8~PyݳvObc? õÊdp?PNo8WUE9J͊˻1@?\R~ 8KhΧ ;,GPQgx9Y[FlWiwt\9<0b'cpTE.h`Ì*E&{d#UA>B9GGƎPԄnf72Eg g&}@>TU037;;$ 2ōukv`IX$)D4Oj1󔡬OXWGE0b1Łޢ>_6BrIKs`k @ ב?cp2'`k D Zz*q7:Ƨ~/"0L4+^X , Tժwz(DS!$W'ZSP$C̠/ O H;rt)b"2VEiY3) %ho9"Vi)65}<1_CXjy!(f|Z M,q)X`daK (%؏mEF1L@9)Lw-ROr`L4QX| D#9'*L,)/*8'HJAfQ\ [AIPF]€g`-0)9_P@+5bC9l GJ2w$5)I`p@XJRG<0:NbY56c)w 4n),岴5xqT]_Y%NG _~ }5 :Oqb$8yI1:Bq)L Hí IA|x ԸHw%pWNNZ- Zq m(#-֤'sd!FMAN.A)|8.VU-"ȲJ 5}kbx;6/$RЪOY%RzۿΓ~R=*L p%X7`Ы370d0PMBGHbo@S"~9kA"P@<Wv/(q}M1_ӭ!Nޓcaffff-f' p *}t0xR>RVLGe[r Wy?dr>|t˯Tc6m;ƌW.1ϳ̬~Np@ۢln^߸$囬25R֟?/!Hp'.ޱH+\ZACe2+h|OXĈ$3²psrlCIi|d#@ϡDŽ~UfF]Ӏ3ol}/m&Gtuknaǰqg mHl7~y.Zd&?khS";켬=%69#n[%C!"pY6*\D3cy>N}$b1Xs8}ǹ-,  0,sH:QR8Ÿ/mg1ʋza|0H_GJSpȵy\ _4~X+ď3&(4g|8|9YyZvY (`1lW,7/D"^h‹d ԃ9,ƆgN K4ܝA2%(*0_ӺqJ"m\r\w$uK8bgLIplt _*"N3U<"~ݙ+O(b5 {rti ~,'"vYOc㞑ygJfFۑX#( `#H@Sd2Ts"LQW `?$Ĵ Lr0wY8y BJfTŀ>$ վ !+j 5k(bc%%^8[pt"| ӥ)tq>&N[?ۗ1w?"0H{tn)( s4_Q{!`0p8銀E" VѼoZ4agW 3[WYu ~)8)]hE u<X*$ˋ(ўFfk bϬ%Fh6Z\X;M6]-$<D%P0BןUb5fܜ}hOOx>x֩3pU(ܦuuy]xd NUg.[0M/KUBQsJ)?2[qhikO9# ֬7\1,SJՁk) ) #$`e7JbÅ ^/ +} QwN{'s`tu'`=I bT&V=/LHFvՕ??1O"[ EϬE=yrAt/0;`0?3FyNS-=K9~ޕ_CYACDr!TT~Iܶ jNj(OY`ppabW6X'&hF˟-ȴmq$QjwCn O{kxM4J׀l,|[z% | U ,yjk| O| #Ht)UU'G|ᣇ{/Q_,3䷍R1w/^k;hx5FTrc F_zA x)d%Was%gd a "9/{hHOKRih`I)dHs 11MN1J8's|aq-~[njyH K)otZ# ckO:-іvelX/7kFݨt"&>x@m C8R2Z3_VV ]Hz"UG-]չ\vX!8lʔ]Woq!"r z#.$hC36`ez[`-xucr|Sٸ &Ep{Z0&8|  +28 Ioך,N2^?*wJ-b-7.o8Z>Yq3^Zb / $/A /+Ύ3¹?_KLsBHB~Zec2N80u=(i*'G@iƢo!a<!&Z*Yk.E4oN1Dtާ41c~AE%2]N@hVM L*A š!%̉JPt(scst6x.p)*v?B](K|H<Ň~NS?̤U,ֱfH7R4Xea %> 20P% l6E6b ȩ5P!O)DcKlp”  y+لwM6ZL)(Zufz=l7:hlYny=]oF=Bv3ҙha4[{Fw` n7QѨQ!绂.Qji>#7BҮ$tKھvx,` 鴙lj" ϡ㱱qkzOaD]H3Ois=epK9% yUl1nQ+S%O0XXT$ˡYkbU\ϛ [`" rH}Z]eJ]OLVE@vY$eV9Rǣ*I\ -gH+p|@6s_[G/R-jO}c%-VasmdP[e^A O{+yu^^ ~>Ί/bgmыm ,^\x~A'ƬYӏbq@$ 7~Cv#k+-3-n@5_p;TJP pB@MY$GS\C5CgBU."}xǫ&Zsȋ(x$4ʈ `Th|&My"ijxFSoGoO1F"ZI3r/$?Onb%'ڹ59#pk>FU'L׭"< wrZ/^f]b@/,77Q <|pً>cڃƫwx/ +۸)GLFzHJJ;؄5t&}Ev 2(OI~=. G`b*bCI'N7V悙|7BDnL~Irw&.3G軶,/K24 \/0q\V,[]ȣ̳pIcLNxb?4`<i@J2RiO}$'] eD{qwsՐNfA  N&F('s,>+kذ9  3χ3naAZ)Q9E_QDvn׺ކ2Mx+m Ө!3]@YoM s91/6>)sx.YTؗtutn s0gggY>55zzKH^![V̇)mImIM` ?=M[x)"*Q@n0 kNNЛvhNիw[I nZ:Vl-lGM :ޓ\Iե6ꥒ@4E*oMZXBooHDui$.!uIm`nBo# ^ "@A$u`GgS0 @*m8 ?Kq~ ]Y G D^JȫwڭO8aL,LQ[ZPu)0'H-J i-:Jvsv^wZYo?~RN׺t>u@;]jF{FkjFjun;~;R* R t@ȴ WВBx64:GT҃J;Ѡ'ϭ!)r\6IeH&pk::c,Za,DRB]"5]Df@o?N|Д=_05FVO & ~Hk_ufuMVy9U Oze BV@9F83ZAF(z t;*IRNoYPI1fF(횝HW]x쀈2DRVRM4@VGl@ka-(1:`A-MhГлD悵gty-@tO7' ztG8;IZT QOPud^XpahfrC2R9B%j}%& u|Pߣ*L~`ҽbUd30 ;Hx$hȢQٕ]*K;@x5s20AvM% k0O.A`΄'~!;Ӂс\[̜2]XeUTfTR0zߔ2}qhj<c4W{ZAK<5JD"6d hAa[`,˯5ꠦ4Q0@6@  Q>vuDaRB}쨠Wj*vP\7=k4Ўn@v耢kAbuR ;^mWmCc:Z nW<oۨ,2K N2hnPA]ۃ, 6tF$a63`P':==}r^OZ6c)c:-TlУRt{T[( <;T u h Vtу浡'.e atsAsOgT0$@1v(vWjΟ?˵REX"f~P4%_VKYZ8Al#2n"$!(u.3/lno 4 1w| nGK7Y%$Zi -B sWBW;S5؍ iZt Da]DgC&4ݩ?Y<07=cEQ;FZ왲%wj8`;wE,q%=4iHkcɕWԾ< JnWJd\){e͑S֠d[^(kE-${kD:s׍.·2 x-;J"'3( -a>SCBSw]q8<+H0Ӆ7ecQ~ >%E/DqʅweLIKTW}W]j.ߔt.m2 0D%.:`ƽRҲq9KɖleT7VR`Rdblrӝpjt3xQSfTj gj[/ܐI̱8֍{?z1/ѩS-mXt*__ǢM߿n o-D+zI q^ NRo7YT߸`Mb^:dXKRI?f*mV{ҟ?\qkv^kI7^˟NZzGezfש~^(>Z7P󇫅mnEpJr~`KJKB2y/npX%Xfɏ'oo<Dcߏ_1s[,Af@3?v\~ZLIZTX*xje%VfEϽD`6.<h/o 3 jϨèoqeW.kpUϿU9upooɩS 6Ĭxg 4NĮ\C\ƭ* Jx#e:g4o[ *? &67}y{U:c1~y,Oѭx?׹?=Qdg~5Vqn?Lov7Ewe9[#ynv#?r,w~\8 {_Y.HQRA3<5=¦Hy(+S_g~`a7!b ^|Ц fr |́ *-pɎ0Bq8` J0 0 bUBar^l)Y0GZyK\}OB:3KBE-%C] h@7#kҌy ň{͎kuxFs:*[vBOvm0(2U-衿jB SRV #>JͿD[M?%X)H)xrØ(]W:yӽHDA(0Lx5ӓsX"PҲ˝\Kx4H9CPA\8a.ȧ1FSt)"1/Bˊ|6A'/ebv/~K#g/cL̃3?bL^|-AE۫B{{ Cu3?$~ e4Wc)RM"3ZLZ'v%b!^3ˁI+H Q#\~[~'@2\.jMz2+d,l4-x ,>YKcS @` &%f 7r.їֹ3[$o1Xށq!LH,P*g';(I4zpV'q s%k3b#Y I!W%Z5ӫwFmK 2qk[G*U2Y\F