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[ _&I&N]/%BTIGm?Nݵ$0 \yrg4JMLy2%2ƿ3Yhj!Ls+'5c|갳D4ywԴ٩3b*(9cj8\fuR\Sq,M66i~6'LjcBl1Oz:'΃ѨS6PfkO)?p7i:W5a<`оk+3^c '.NYl <+Gs5Ȋ߫aw>s! I5bmEօXum P5!?-) $zg!_߿ZF|Pk?_5]`&;9T"y#OTU~@}UҞG5;`3+2i`c4䘨"*NTǃ3u=;a@Lc I˴x8^mQ?j?B؇wm{X#‹ : .tߏ.U5 /^ǃL}0b /<[s,VPY0ۉNPZϓضA,{͍XL\ ٜMEWAV^GtoL;ޮk % Bݲ1`oR3-¾̀sTA@I{=w]FZZ^pJ,u"߻-Jwkcjj8n[زFVWy`[vr^]l[cʃvjw~+g 4GfFo۝ѴZzT8[h{mMC٣q̱xj-Flm3_U-2RVsz{~>X 4]LX҄H d_ qOYqnx;NDgS'bj8Fg5лq~ f %s׺b֨ јALgiF؁H cadrXDpi h2<5] $R\HtGjLE@I7_\gέh#E!} U|A=]?ulyeێ7,s?tHZCҮl@0CeTIߖh64qRjg"l'iqs,`Aȸ9=:KF&@0UGvdy_5) X*Aw);W2if ߛ .g3|M+v,+0Ti[VLceՙsI_T\ρ1h,Z)y5,72!QhW" C A 8],°.bD= kkB p|}p`%K >f#b- Pp[8%N4F4k<`^fWe6#UvfҞxU$]k4IZVk:7e''wφPR 9-NaiddCtFbs0qU"HUV>XT}Ykj;Ԩ57d2:cCuz[Zo-XR `"v5t0q, H'`S3=u)7`p#*0޼ [լBk6{:xghuyXf SwGpgyg4hoYI`)Db+dXi+zF*տR:$5jzM+pM!6wIuŨwQX{x@ V5d-Hh))@Sʍ|椞zGiM5P_Wui׷{ZuYa(‚lm& 5] ^U244 䣢N$ *hvFK[L(ކ3-qj&@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& }Q.%iKg!!*K'J5Fǁl s8VNFh õ|Z=B\J'lfbcXƑw 5*^SGJe|_Z3FFF3KVDu&| K2蕀s81dqI7ۅlZϡU %4T愕vNHRo9d٥`ش*@f>iB)>.mP`QuyuG*Ĉxx h'.5zPT(ؙzQo! }uU^^Wy3'd7O N嵂?Z ?!?Т)GV4^6g嗩ˊc&X\PSm*BZ2軝7| WMS2IDo:{ 蜻ֈaB{_UnN\N)8hBQuRCGmqǻeNWNnY6OY1Ô',z."&+L9%' J .2`/']owўueG:y\/(3?b3>e4͚h{FT9`Y]ZA*Kp{h  @g4+# $SzJ!07Z{~}Mt ~<Ŧ:$+"D94 \`%&/DWBa3O{=8O=PyϸO|6˪"-t eۨ(?0HhJ[T@ bl8'f@5pL>ɕ(D3~j y(?+jPƔ317$J F >'@bQ!)H@ihCmgbrj'L(c7L$U,`d*G4Roa\]8ޫɗG Q {UN)n e\Lr<)~b}_s`CɎQP ~?0-FVќ58en,ġ&$@ı\90pяǕ?[O=]HT5&|ĸɵ"8 > Rv4OhnƔy:2t\h#!}%2_[LU殮 rfg^Y O`KhLKk-^ .1Hb(fji?8ީ: "U ұ`c&OwE*$- 㞋HC\K=sIF$ecyq/AG=J}2ǛZ-rدm),g$yh:XQxW/,Lɸ福֠q/>?y,j-{ 1,:tf蹿:P~Ja ?k4P0܇u 9Go"4ix٥;CL|y}M2}gh~IYG'/;UUV@^y{3tIC'+CS0[{PV&KrhZ/4a֔?Y ;gf+6pqc-~mQN"lo FbA<ͫ4'r rؐ(Bc_x C1q{r/+Yʳ΢4ށJ|wPtn"=CnpA큠f<as!20<"1.I5Ϣ@Ft?*FOͣZGQyx9ԜJ)|~pzЖ;vWqj^^+ud֕_L.0ű+$:G=VF{ ;_ӂ&A};ל1r{(|W>]@-sK:(+1HC سxG.0$ ;P4w tʐ)#1_JuvɃG 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ʣ8gNJo|%o?$YnUyfTQR, ''<99HfW8;zd.#%73AW[DtY&dB,}; * B1cWX:^^z0E= !=UǤ^4Ň8Ѵ2a"U֔xD<P{瀫&3~CӂcĎ\d]bHLU}ZaJt [,yUmMdMd"`A~ EB0˭c\J?&>'$YoYbijDJ /6c[Q.+tA4` +Dfs:] ԓS<,vC(<0H2ш~  xDJDKJ6I$>ҳ|{PGcTi>BƖ창УkiR~-vD&aQW0cKuLJeW/uJAؐGkl)p>`Sĸ̝t3I lJRh?+$X{V` _7 [g %Keo,m͵2^nUWV 1Q_B;y_c.|lµSp\% )E^R5 &f\:S#2p$?CҩkE">7`2¹)?4 cUSJ1pcsTC5Д#Bmk|,#-tυ]  v\fwbSLtkfgfsy٫f ᵂm>}TndSmqbUF+}}1KLl3j@&m#Ķ(7. A&LdM)na/gO jR$,RVPY S'"%)8 n&7ܜztPn|f_و;sh`1_㢙GW%4[1[cߋ}]][1E/rRf,48č|I(#@(ԟ;;+Kz DgjfVz CH/}%\ͮ &L~ŀ>$ վ !+j 5k(bc/%%^8[_pt"| ӥ)tq&N[Ŀۗ1w??"0H{t/n!( s4|XQ{!`0p8銀E" Hh^7-^+DG-ݫ:?TQAnM"qщ |nH`º B {Ehcu#3@ng#4xW-UBp@2qMrEKx$ +B&dA rI(TggDu !#r{p- dmy)7'r_7ZuEnZG_!' ! ׾؏5FO-"pM$.}Co*AaH]<;$G4il}7גP)j P%iVev=)G%! tjUKVuv4dm< ]4S#Idք~1Alz+%I8cga1nʠ'-%z)p]i*wɋ}gWӕߔ6 yE_~HK pUv$$!XryBPt9SOi0vwx ا** .j*XWW $Ȫ9BPU?HuLUřhs$ݓv@9{`o۳XSSߙYziw'O5[:ϰ5-%2#n6K~(!sE'ea_J%C0`%9+gީbIVr9?,{Xr_y61]6{X\ V S?d)8tBO4ڜpCt2gv+M󶬦[W T RFR0#RmiiƦbfԍzMk a" ahYB*CSU{9*ҊG.FSЭ?NC[=t\F^8NP"Y >!E|w3]$&< a?x]tD]}/x l /  }4~B"pjE4U?iP9%=_Eek%)J*NU+S(eX=Ka͢@l` qلI~mVHc!ѝYdfo*#Y?dȞCv+?ˢhټDy,A+ڨeg+{^PzH?@уrXe6_{dp[SUJ p _}prBg kyQTjy`", hM usa c{ᏦţڏO3^}zvӣ'MxJE!f _6員ky uƙM$rLWChmY|>^\\ 8VLO29##)vIcq]! [ M3E2Dj~w{5unYad=FG Bfxi'&%NY'}0tǧRx\z,3y P^bZ^IBͱ9 ՝ gUZOz3yPw&G3*aٯ/{ul MlgÝ P0)'蹕*Ԃ1ivޘ/ qXaHz+xVMtnrVtT :,a뿳Њ5 ]߹"Q1zCsiU,W<㥥+Əp@B:.+)?|3+<>Ot̔њ9*-ĉ)GqZ+94YË62`0x"x$f,63jRDt7HDCJ<8TO^Y-Sh$}FiT_[JHPΜ(E,12>76gInaq bS)ԅه#P|N_?l#7(BҮ4$ԻKھvx,a A鴙lj" 㱴qlPaD]HK is=e7}K9&ynlannjuVza HC"ĶV0 <"k[GfHmھ̀F{H\ r/: [`" r*K+_Ͷe0wt>3vBgS)ۘ!XfbBR"tnԫ&qmDN!%:HV3 ?2b>xyeEWT/ o\#@muzhssBJS[rB2O*_@ϧݕ-^^>Њ/bomэhl݇͟^#ynЋ1ot^D{P] i`ax NYȄģ 'Hd4e"t/1ϥ<>h6gBb9`@7kX4-Ʌx, Zw!xtҢzqtfp_d$nht mЀK1nv|͞nKՍN[~eUq}7Y%smDg]l7$,9z`8?mc~~Ze*F}>~F䋝yc@kN0< A49Ib%R6lkwqc].t @ꦯ6}跻_Ҧq:v&3Rڲ,\dZnʝ%HE0d}Lt3$/MIx]9<3 m"Qishۜ}$ݙ.g^ ^fyJ#OZ9Tg5q % N$3Ƕi\N[GZl lw\~޲\EzVJ?FNt|>A۵.-L5PJ>4*`s3 pc-s;Sd"s.9c^lS!.f]L-'14 s4rI3 sgggY>6zzK36?7e-- #܊+:8d^'cw95lv'Mу匉eeސo@PtQdLPywЀkuA=h^)}B]P3pP)FG<7 jU49ztxF CgKC=~dVtHiw{K?v 1c\&?=]Hb$DžwxTC"'w+%; ɼ[ [ [ ] f>ivqqqqqDZn1n1f1nc;=ow;v-',쮕yww_X6OćIڈh7C3 <%曇S#9Ml}̜S65T:N2(hۜV3]LJPœwj}UgUrYtl/H$zvMc­U t#"ݰ%;Z9;PS`r@ס޹Y bh tK #cx;M' pR_VYG;=RA{ Ȟy6VU*M s0rF˂'P;@cpqtoOE@/CEmS)3:ǦL*Op _%)_qᴝI/&Bzn`xh`ŢR^JN|vЙ|-k__?5?y*Ͱ֬A(WjR0lye!3_3G\OpW=Kz?-Vx_b׳sw+;iwDw\mĕh^!I&W8d\R^6(^:^)q /6GBN"h+}-}IW9Z2-=;JZ#'3[d -a>'`ZDt]qج8QkH›(??wûvlf_"o 8B66R\$+ud Tоn5KsJ{X6ߙN\0]HK_ZK)i^8ʜdK6ò+`)0)q}1 6Bpijt`xQSftj gj[/ܐI̱8֍NjHb^jSMNKX͗?b tWVl=c]/IF;ΫAPI& qzϿ]+}7YrIʝd7ZEtjϝ/ߚݭW74Zr~W{VQ-u?*D.)BS !ja[ܡܸ_ l %[u!wƬ!V}I%aY#=;ѻg2*Rᘹ- ~3}E.? -PlؤJ Y*A}<ղQft 3c"LǗS{QroyMs 47t v{-37v\dsk_*Č:[7e⌷TO)Gĭ_?:;SeGpO^>6Ĭxo 4NĮ\cο\ƭ* Jxƣe :*~L v4C Aǿ/ooJx#}8)u;Vq0g7q&w|u}6^:'jlF*"@6CV,g^y|s$<unGnY ǡִp~5s+˥#*P*hFB챦9[Tc8%ypcl<&vV XtxXUo9Aa>2[^( D XLPY(,~?q  0@p:LVo)WdeӶ2NEe?a/PQKP)MH<4cނ?b1iD^$\zΆ քГs=JL(#g 7z/ZP”B}R/9Vdabϭq q{E(Rtkg0fj|? |ו}^*@ 1#d1}+Q <^'xŜG&?$Gr!x RfF p\OcrRE0br_l N_`6ME_}/_+G<1r=^'goŘn1>w[;ǃW3 A~g~L1(hƌSdAkEf0 xpɐ{FJ|E/AR'-݈:m9<\i& Z0fhK-md<$ŘL_0Jg{8\v}SDˋfê5GXUj~a;;@8#K{g@pjm?C_9aX̨S+Jz=G)̄v$N 0s+zuP#;QqzPWB6Y9[W|0^9|]7hU9i54}^/=^U"T} gs{lBO ȭ9L^$S:?Y.̘+A\o$YLZܔ@;*zu}\6?J/"6@~gҟ2FzF;-tQýq %!'X wުo3s~gRe3JjSĬbn8p ^3vpӗ/c%75*U;5էJ