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[ _&\nKĄ"UQkf)갓nv p׏4fǿkySfL̲E4ZA"SڕtϚ1S>q"Y^<;uhj1^ȱ\5Y.3u:g)`)L4aV&Wyȉ\EI;wS6@ ܃5%x7~&ά3ՙYV0aRm?C0fh ݭƀ%&?q5wBm %eˍXY/:ϬuFV^-ý YH) o  =e.2("Ūkc nIHo&? -UjBBmt"|t^ETƃRaHR||勄E5Eνz;̊LclEC:6L9 j-"_ Y⤰Ou3 Np/ 43If#? WsBIfg}?W O,`ª݅x#Ls\C-2~oʃl͐9׭ڵ$LnR)mY1MUgrK+'- *s%R "yK"px$!,% TO[VNc^J/Rd,[9Ȋ^{:f [EA6{ +pA4s +VvG~8r0Ya30D3Yz!TP]KhY=@3|^:r?Z ǠRhӦgwJ<Ȅ6F!-_$ i\)50x#wa6 UP4@ qP/OjJawS'0*_ L@1kIʊx<(qJF1JXQ 0+b-ӶfY6$0ƫ%ZHҲ_ӹP-;>{6"4biwrLK$'b,3ʼ+A֗:KZc-PCmF@ c-jnzkzؗz5] ؗU/c5vGE8y3r.=u)7`p#*0޼ [լBk6{:xghuyXf SwGpgyg4hoYI`)Db+dXi+zF*տR:$5jzM+pM!6wIuŨwQX{x@ V5d-Hh))@Sʵ|椞zGiM5P_Wui׷{ZuZa(‚lm& 5] ^U244 䣢N$ *hvFK[L(ކ3-qgj&@v+3JW)rKJzڋMl(nMP=# ⡋tS$ &՝ErIT7\`@RnЈэ4ٺqŁu(Uoa,V^&Z,.R;N>b`ͬ `-a lRWll A &k[@Ќu ih.ztUhX :fiQŸZb`t %J`\Vve"Qi狫 &* „{QTNSBtUnYX& }^.$iKg!!*K'J5Fǁl s8VNFh õ|Z=B\H'lfbcXƑws5*^SGJE|_Z3ZFF3KVDu&| K"蕀s81dqI7ۅlZϡU %4T愕vNHRo9dم`ش*@f>iB)>.mP`QuyuG*Ĉxx h'ƟWJj_DN|= Yf@e諫J⪪ ț9!+~Vh=vU.L)!йM/|5"9m'/L]V3  h3,V ֪ߔFWj~I'|كO@ܵF JCr;vrJ9_A*8oۏ;}Ĕ-~r5pu .Š2eP){bPk++dُpXVO5bOؖ4kʚw|} :8cs:$ Yݔ]@+DzĩTS~#.^td@ؔif*5y c<1*dT*?0so%oea0n]I/!:O= BDERxJhV¾vƕ@;N$/r'9iXI2:<9i#(" ?,Wa#tjRT '4Dr?xQ5h@wv*InDFfW t}T7Tm8oK^-?7 @O@iV*4HfhgC`n!4LxM#tEIVNDsud[e(]B>I)`aD:}%&?TP ׃߳80ZQiCȬ<*,A*f(DE1r/FSڢ^SdǑ>3;c)N|D S[ @HVSz%צ%1GVd0HeV>)t2\ ad04NA2Pb\OFsj8 ӕ ? `DsfB h}$1b#S9ao߷b~ 3p~ ^-@H>?яJ;rJqKpU,t#DG{B[-y~UA)[<*'La P lR.hPaQ)^7-:c`֠JVc 8 &|2NH~T4s>qWq_-#/nEB99Oo˩2x"5'V.l34-\78vvDŽ+d//qΤ%oH)txTE71 [q 8|,AFyrup_/y9q3f) 5?&=6?#F&L_U`l=gs;t!QY&& p$H<FPS*e茪ʈq 6V2f0|iESpp*?0 T!P +.;xe%h[ xM۫bEtTxb⃲0'G:& >ZOĽ䃧{īe$-`3CE=ՁS:&?KqX _G>49|yN3.lg|>ةvuXq*k:m%&! mڔP-<9WCh]`rNJU1+v36HghHuDG9{eD,PSg[K}'[c0m߯91idga"2J ͐ ,,B)ތp2ray{C>H 7;Bnۄ8sS8q%\0j@T* GYqU+88}9|ps1&23k0&T0*=̜W*@BPR4 ^;u.a6 +F$ g̓$wvּ{L:iaѸj>ʣMݻt`KZl4ŕ?Y!Hzz2YfJ3*oLub8 ?jݰ3f19JW?RKP -8`a O ݼH.{d..l!K Y"4g͜<31D3ź'ba<4JtwE&R) j68"!#ps " d.J0Г F*rT7 ttyIVb91 +Ou=&p 398 i!:2'MG(", ~GRB蹝_ ԐW=l̠χ@q']PP $G>T!R_)(4bd0`IR,QEbR"h,&gbŰ#+8RPj!SH(TA lCgC ecvp-3cG0uQ1qΎ2OU J~Hܪ.͂"\E?X(⏏)>y||;̐&pvc`C0\FJnf䃮LɮjPͣ#n0WN79-ĘJeITw`qʲ)~OK aHBUzb/N4L`0EHrz58E29 _|4# A"&R)SkUD5s]#K/lf"j1Yk5XBovrᏉω5 FXd9R‹Vd4C сٜ|B?-$*O#%1 L4"@!{¨Qs1TGUO;+;lZ_]* Eak(! xR]R d]RP#6k æπ0w1$s'LR %$u >!VVac=6|7MCbiɒa[.K[sGUBdy0Ў~ט _#pT!!vIBsi`M/2܌KQg _V`VFngH:u "Ó]H&E+L:trmo_TЊmhC ph&=Asg' 釈5dn rw EOH%qaԶBhQEU)Vt}92TMt sY{*f*J2 0 TpNbO;&8cqX pq, pdT+9F \ B`wƓɀZB:O_xٔ[(}MTǮy_ܷy)'UV}*Г5.OwvdDWq'`Vۗ/ź^'{!j:BŸs(|ӸqDH }͡\z佥.+|@Sln q l00;0{5l0;a؀#RW͇8qڍLbu?:*X[!3C^~zOoy7fT r}-4`fsR؄mesSz`_%At5(d)ō"셴D}q\ Aj>sE * YA{Zd;w#CUYG@3>maq^X`C{l|U,%CY]v6QiH&|w dE q,8%[\ǵE_(Z!~D0A< \ũ_0ֲJFadyi':D^$c@ wt`M^fq56<~$`tQAY(O4)CQ #e9(b_[ܻ @@.Y|cT))Y-KE~a]Cϸ;rEf;0sqOCn>vb_Ï_\EDNq3+il37Ll`(q;kD"E1~ 9@]ZJ'n;nĻNqz}s#BC'9@w솑8GÇ,`pRӀO,~ ;;bH\X qݽ cCLH}D,Hpf( > W!1]^D4V72_+{f-0Bx*]u O $*7t+WG}EȄL6$Z\. *L!dd\n.p6L-7/DF xx2aųNkBq6ˋc|=![w:wقizg]L:#xW2Oaў%݊CpM[ ~b?܇@&',Էfc:U_\e8oOQU0HIxf',Q.tm="'?Q*?5v?|D%˅>08qPCگ,4fB2k~._^z`#8 ` /~f}(oO.8 rxQ(I0f6s2+O,yW~ e?V*ՏU`m CX Kzui`-牓m<' Q6b:Į'0m0M ь?[iH>@ni|+./ٔY|J7\=Xs>FLBOYt_oet_H</en[v^Aeʕ;4[ű׷ˎhznбPR힛O#?#XiچUƈ䬉~kht0OXOgPk3, y'Lw vfs Ko_vbphXkBOl'yY5Ah܄o N(/AaaC|oE/~`-k 9<`Mʇչ3%5x.օϛ8*~L?%>kM; Ϫw=PM"`kFVM~;klZ5Kdۘ{=jSkn`zn$B՝oC$4dr)Q@$_|Af"-Π[J:EM*5ͪޮ'$wM|UuJ.RQrӱymy!kf}V$C>?//z7~MS$>ƿt >,}MOnmW|+V?yY^otB#r#2x@mg C4R2mZ3_VV\T < Pv(hChVn"UTy`tUr:-cqP XdI./^tbP+t#Xþ27W OU$XmHt=/ěC.|l12'%J&ϲ(Zn6p+KVn6jmYDJ,^PV٨^5Y#V(!]L\ |8VLO29#)6Icq]! [ MSE2Dj~w{5uݳni`d`$WzkɫRx\z,3y P^bZ^IBͱ9 ՝ UZOz3yPkw&G3*a٭/{ul Lŋkg;s P0)'踕ӂ1ivޘ/qXaHz3iU,W<㥥+Əp@B:. )?(3+<>:t̔њ9-ĉ)䧡qZ+9.Y62`0x"x$f,63jRDt HD}J<8TO^Ym,Sh$}FhT_ZJHPΜ(E,12>76gInaq bS)ԅȟ·#P|$_?l"1k"S}X*Kڦ=J^bUw#gXHh É`ل~wbL6h:%X0۬]oF;-޵ڭ^N-G]ȮwF:^36ưqzsls6O9ٍÙ&*2*$lWpw%?*P-ͧ~]HQcmw)l[ۗ֎k%l!"68Q< t<.<{m^)yC*}\OmrE8Ap/C^MG|n-[[Ũ(S#fHHÝ3  -'!9AE[A}&ToX{J89j;!} mH,g30!)sVUUy AZ"'ΐW(7GӇsG[ G8/R->jO}cE סVasUdM[e.A O{+y|/_څڢqMw.XJ sNYbW~4ťȗ& ܯ>eS~JN(ϐp%K +=DF *lv s@q&Ω @Z^l/D [&=2wqWpV+pRj2 WY $Kwv:٣6n2> ?ݠg!ruiuWK++fflxEx%\7.Y .]-ѷRd:`Ϧw=:#4/v&ax82l.X2ƀ| M_1?/iAOIp)h軶,/K24 r/0p\V4̛EMȣ̳pIwF]NDk9a[ 0]q rƼi*zZOoH7YM0(@:5^0m (:ˁjh{M,c_TZ0i4o:P B7BAn4Ud ,($3"tN$u@4v@<h)cvW& zDH6@vaijhM0@ e&uIk]"hs3mc} μ`\SkV u{ Dk#A@$]KGGAB[ƨ[(:2Ug@ꀰI4c P7ZC{mh~ & u|]ߣ#L~~5bSdOnC) '-HxBgȢՕ]l*K.@xSr?Ue a08GKA af]iƒ}OTICpu+wCx7e\k+PYF#anU2mahj434T{ZAK<J"6d fA][`&5ꠤ4Q0@6@  Q:vuaRBm쨠Uj*tPX7=k4Ђn@v耚kAb5R ;\m'?amCc:ZnWIB@Qqh.3/lo 1:w| FKۯl$0>BH xTh$^#cBZu V]C9Q}#F(Т*³sw6OϺ'i=mmxPS-Ll5X 8!|ΘړR9s MʍIi'_wveՇ?g!>)B2onn* ϓM:OA  5 :o(ow"]-}p띷 Xۼ6GHڈ7#^"S#9g}̜z65Tt:-(6`y%`2`(bP@EqD)?BXA z(J {7?lQmCq[S<㫜{s{W>F\dlesmVY<>/Bcϩm_8f zVC$xzL 2  .3!G*%< ` Ӂo'_PYDЩmu#CtRɪ*',Qr7BsǿA9ޔSQ@:+'4-[ǙdXpDž5ݨUǽfnڥ\}?)f`@bKLmΡ:@ W1)!S$R3E 2[ޟt"Ko-5XT*n'+ŋ'CgwډQZҗM)ߡJ353gAŕ ?rEff̗᩽La%zlhe[ƭ/#Į'g4U)jgb/P۹X+NC6*LI&=%NiPrkR"J^m酫]jVnlm#ҁ7U ?ZئV]%q 0 l %[u.Ƭ!V}I%aY#=}҃OHeUG- ~3ky.? -PlؤJ Y*A}<ղQft 3c"Lc{QryMss47t f{-30v\dk˚;\fӇ/bbFN-ܛ2q[rO#^֯WNΔmYQ=Ӫ "1+bj|D>Y.gq+m𺆬+q/qJ£bY`DGyNf:bx*:,kooi6@ ͽ M_@xE ?2p#Stv8`Ϡobu,lϚt|O**?3eU|E၄lӛM7]Yֽ,!Hx݈ݲ߳C)kijWKגGTTЌ8cMOo-s6,ҁqJ |EשxMH.oao\i-B9,ds 2vJ dGny8b0%vb1AgxE97@`,G>GZyK\}OB:3>KBE-%C] h@7#kҌy ňz͎kuxFs:*[vLOvm0(2U-衿jB SRV k#>JͿD[M?%X)H)xqØ(]WzRϧ{YNj9[P`/j68g-<2$D 9:e ;i2s6Ztzh4r/r|ȧStrB+i@h (r{J=?B|桌<8x+t82\^Q?T|t!/d2[ ?crGHPF|5f"e$ ])2ixCӀ'L; c( iRCfp|LC65\ 45rP+| :ylFi3aJH7iH/1D̸\ji#!)dzy:1 SZ% ]^t9 V9Z¨"Q c|&PIN4Źϟ;;Sl  #lvfzU4:еR^)w$?|8W Xc YW?*"0zݓL 'x0c֮qBU,# p|j90iepS $jo tC1EIo\fL’%NO' qiLtjlFE9:sf-fC@;P3. JSX|8i\ j$.?}admF}Y,wD# $)$*CwzN qyA&3cz1 Y[Z[jq}ذȖ (1Kat:1{; KBEQ_#gΤwg^sYq @1mg} ޢu}.gRGz`drE