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); } ?>

~60w=0lkK5IY 7&9mDHbB*IPﵼ]73vmwnc`0s<_>˽Wr-obS?)Y6ȒFS+Yd]9I3S E3ǎNSEωUÑ2S',}<ǎdi)Ohkl>`R;{5epfEl|5~f\G'p$4xPH I+vgֹ̬ SV]+]!}Bh4jcjߟ̚;6gF, ]́|:#+r|̅,$Քmvׅ?1fr`bյ1@߅l d$7Ά̖*}uO 6~6WkV"pM*}30S->T }keҘG5`;¤ |dž=i1QE䫡 U2㩎Mg( {w-9 'i(p~^%~V E0b޽4!BvA/6`Ϫ +|?T*FX=W`2놡h0c9 U^NFwj}mIJgZi+Tn{mYuDZFqP -Fl!"0L 8gI X }gszܕht5R("sF* MN #יL#uX-,&e-avo%/Z9uld`".,-_]0c;ĭ }bV@U?m6Q`$n{ ֨fk/9QEh2fCU^媚Z!;μ3U-F9bh/`~szk6tvjw~+g 4GfFo۝ѴZzT8[h{mMC٣q̱xj-Fl20[Um1RVsz{~>X 4]LX҄H d_ qOYqnx;NDgS'bj8Fg5Щ[2f 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ȗMajk9$Կh^ǟkrgS laUpR9veBCS0A6]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/[4躑6CY6.NMU|GlzTwZo%=S1wCT3sq8$W̧ 5BʃE#59F_ؚ9.4V'z I̧c(¨5}PEHTe"_ס|.RKIi f.nJ܆iy]8UJBPmX3_H2[IKp%ꖸ\>vxKn;P nlPl%oXlՈH@7ImJ EJ09yW_RK*,5vKjھH|ŊF_T-dԗwM$͛ȳ/oR˫$2{a./_Eȷql[ȴ[e+^ݦȮ[wՍdmڍdխu+eӆMKzsqXlE$mSqՂxUUϯI^ 1y=fe:l(Xj8et+댗9B}1uc6pCL.k5zPT(ؙjQo! }uU^^Wy3'd7O N嵂?Z ??Т)GV4^6g嗩ˊc&X\PSm*BZ2軝7| WMS2Iߊ$t /9wlRNiRNWqЄj:"w":5e˶BM/0mݲ l柲b)OX09\DLV^rK'E3M@&]dʿ.^|Oߙ=k:yc\/(S?bS>e!4͚f=#*ߜy0,.0|Ff t}T7T]8J^/?7 @OAiV*G4IfhgC`n!4LxM#tEIVNE sh K'x+fcN_ IO<(>, BE<>1Vp2+/ D%ˤ+JQQ ~`єd?#qdy#O.j|++Qf{12P~:V>GՔ^)g#h%n*AmȊ 2 .&}CO%}4 C! MS ԁ ܇.'tO3Q\+o!Z#I XTh؛ݥ _- *kG#(qW /@R" \$;;xR^愇2)#@~`ZyU9kxp [ s}-ٯ̚XR8 ՟.mWR=ħrDfC(`"T;/ vch?=z0gW):*dXSTa4,0eւ+>>TfSg Tɪq̸aaӲXO OՃJf.؇9*eT vH@V0p0Um9U^^dajCE#`f0GNaŃZ`B ΙiV2}&8\n,ġ&$@ı\90p l~.$*rrU>kbDan);'BjcJTż QUq:.]4Jyƾh yG* ~]sWWu93~9mpˀ' U%A4&%Hho5͖ /aX$1XA3 dBX0ρ0xD;"ݖq$| fឹ$"18mgV ҃#bgVG>MY`a 9WWTWSVf}?ϼI4{{U(<򏏫OM|Psx@d\C3GkPq/>?Yٞ,j-{ ,:tf蹿:Pɏh*a7 @rDh̳K!vx4_v]<`cGZN[zC6%4&OZD\#s )Gs̊]xMpZRx:rvNa31_4wlhTtskIc p,"5!7M@L,LPVWi!%;AU01YF.,ϲ9~o~jrifgYmgUqbP> F ϐ*BYuh"4+œ~'W/Gq|?\s.f8$Xff&Dj=FQ@BX(}Zfk%X<Ƣaqhd>L|y}M2}gh_$۪*+i|t?h8dh˝~;+85/g*2rR&xXq؏{tݣ+O"=zf\ixhkNO9=+.H%H!QYN#I( ; :eȔ_d m]/%@:;F|L6 \`;a %'T 9'娺oA4"Zr$,cV:zM;+grqfgB+Stl&Oh+ɛ0C1>3H/PDXAs;;!E{8OA)ރ;8$]PP $>T!R_+(4bd0`IR,QEbR"h,&gbbX\RY)()#j2 $ !Ҳ1; 1L]aTLcewFUEd>,O|"(r~f)OB$3 X=P2 -",bk!O依džFW+,PV/=X"V40U/tz0= cdqظ xpebwq)#b(%w=ٱ!40,ie8 9=ո[$\8Ll6`Pkozv"r_E{{ F^J7U)L;K8#,pAM",t_(B!l5T̕ E E~A%(1hiuqL9SX 0}P8p=,3* ņ+3VHU8~Py vObc? õÊdp?PNo8Hr7+.?h#hi8&RJ7ϕ9+$*08el?Χ%ƷJ:Ky|:U?V1b;z,pGM3$OQ剆C>1(?U-YG%KhT)6# 1px9:Wv|&|w;0UǦW&):k(>0[ C+' A Q`,q,nl[Ӵ3K2"ID%U% | W&yg e}}$* )ݮ=as+$4G ^$p9-C|pHNawwc|GH"+L ÔLⅵ0BP>aHBUzG1bN4L`0EHrz58E29 ߾|4# A"&R)SkUD5s]#K/lf"j1Yk5XGBov1rᏉω5 F[Xd9R‹Vd4C сٜ|B?-$*O#%1 L4"@#{¨Qs1TnFUO+;l/Z_]* Eak(! xR]R d]RP#6k æπ01$s'LRO %$u >!VUac=6|7MCbiɒa[.K[sGUBdE0Ў~ט _#pT!!vIBsY`M/ #d4*ϐtDOLHtW" udB޽І>29nMz>NkD1A?ȸۡJˁ¨mUТ*ۋ, RNt}92TMt sY{*f*J2 0 TpNbO;&8cqX pqO, pdT+9F \ B`߮?';((ju )yq+*]($#oRN, 4) U"!k\<͈(O */_"u*Ef/y?&6gΫƒ^mљ3ٹx>^8!y_ eµI4>p?}wG-8g|>@^p s2Cl|U,%CY]v6QiL&|w dE q,8%[\ǵE/^MB 13`By7Sʗ`eבp1FerNt()U&Hƀ(H=jlx&IpTa颂Q X Z7N)P?\[ܻ @@>Y|cT))Y-KE~a}CO;rEf;0sqOCn>Svb_Ï_BEDNq3+il37Ll`(q;kD"E1~ ā(VyLbNw@8^ ,󐙛ēw"I>9'"[HӃ'T$0Ca]! "JgZ 3k f|ǫW!p@2qMrEKx$ +B&dA rI(TggDu !#r{p- dmy)7'r_7ZuEn-_ ׅs>*ܵO>'>$S骪ud|ŧ][am>)zuk5|ὂʔ+~oco ѬZ (oDans41"9k"ߚ; %S * Cv "'rs],\Ws65$v֧}x gnBλO6  0K°!~J׷٢wLg?RGӵ?CY0U&ws!;P-eg0T& ^yY s8Oć|9/=c[7j)ch5vCzoXk5:~\3i,^#?x=5>>+DP }">iFPN#Ev@ 'K_ro#bST7\KBo)CY]ە7 ˩UnXɇE*J@n1;$tv`X^]mD Zܒ BU Ѯ%Ȫ2V#03q$GαtOvm3[*nbYvNM}g 'O~?~l=k={lt7uO=`%ZK|eFEQ A;.rO ɘ(J.`KrW\>N>>^ ~(Xlbrl$AD5 t) )mRJ3mq. L72%i9}88 &_i'd]9#.ůWv+xmYM"@""~)NwalM9IG2f3Ȍaͨ@DՇ ahYB*CSU{9*ҊՋ.FSЭ?NCc[=t\F0NP"Y kEw3]$&( a?xStDY'M/u l  }4~B0"d*ڬE4U?fN9%=Cdk%)J)S3(oǰ{"?fE*コ 0Sxqfɏt;,SUD*eKo<(M[wï3Cr,2bWj5ԭFJ,ܸ}I Am _(`e˕< Es&G=.ƍs 6pj(NM`a͌V:êi6RH'~yjKWu.W2gEÓehuAE*6 QzBW2xn9 ,ss0YE"ՆDeI8P;g#spQ^d.,ef 湲dk֖EΟĂ?yAM Ey`|][5mS))܏W$*<~g#Пi( 5FR Гׂ,5]/` B<3`0 c{ᏦE! @^?n.^=nCyuҲ) ],x  e$֍g6-0^4Ӓ+}(׹3:p |"daP)ڈT%, 9> zYz1mVc9˩rA=8sRhy+ ! Tw'WZkDTQB!o}d!(fDc ,'ױ%xboYyB*7Bȟ[Q2+: }?^"aHww\2Z3Gx882[Vo9A[0!2{xQU]{#A4ct-g@Hk-%tgHDJ<8TO^Y=Sh$}Z[BToqvg*VA J/|$q$(Y gNPs}O燘E{հɸOIB4(e!s,O+ :  VX:#8JҔ@#cx&|8 HHH2g`HJd[lBm &5P!N)DcKl&p4” q y+c<ϱ=V|o,d4P u >:5qmZAw*NܩbR)e>AXia\ ū+BSY~DoA@K£mМ[Y/af2-I"IȬppfҼm\Q,g9]znbtuOaR Q J{BM(al NJ[ C􃋜%8a^%7ոDD'aإu΋U\&~~b \ b k|@b- 2k"Bz7|5A6@I ] $}MdroMK=O#X>ζʌ,t0oXMhR0ݜFi:c!av]oYnۍNw87[Vk[&hfO[i]tf7ngla 4V}z;ٌ?HAh˨]]^@4Ow!iWVF> ,ڭKkG؍ǒK[Hskܢ-F]7jFL"{HÛ3ք &q1AEXA%z'o+;i6|9j;!=)?m/H,g30!)q8UUy @Z"'ΐY( 9Fms/"]#wp"<_Z.}=CP:[.xj9on$-YV[0h/J^}bKY["mP`3+#o :1fͺ~,!=?:aΠ\ȗL/#:y$PzhjErx*2|(CM "ɉIB:= לM/ㅴ~'MS\ HࡂgI3`08iXɐq Lqۺ?^DrK phaO95]< zb|xAYQXw]]YO[0_><{uWWO(݈WQJLq I *\O`qcQn2/.'{q`2م (:02ٱ6}dc*8p:~> K-bHb5>_$ Ópj'*eszq~7[nrgA% QFwٞsCߵeiYYXf @rgIf2DhgF{{.U4x O~P,}xO x{5L[7Nh Iq h9N%X ˙MCxK hSdd*̱ͥmrr5yo[-6l|{vw~@aAZ)Q9E_[vn׺ކ2Mx+m ӨN;3w@YoM sn9a^lIR.f]L-'14XېsK幛녉(>;;Qk[B m1=>MYmKjKjc@?[;W6O}ySe a08QGKxC af]iƒ˝COTICpI-w3xi:?ʌk42FNci,_*\ok wۚA 5I7$(A>mCRWuuYFKku(A  ou (,:Vr:ExnrhvTP2i m5 <A(9I 6hz7{] at@뵠 J ҵ] ԶQwߍ1-Жz+7omMԟX`Mp^z؆v:8裮xAQhT> b:]#yn1Lxk0E >XqT@c} 81j9QhZЁ~=ttd*Ԇۄ4 v_ AMtwꂲ蔁O0:IPэ3jVA4lvF[ϿɵRX"f~P_V9KYZ8Al#2n"$!(u.3/fmn,o 1|-GK^Mۻ VPd[(62@K9*"Dp7urMk *Շ=bt-Rz u?uj{ڜOچ9UTWSǷ>)P76 )7$';rnEh={^T#˕:CJS?J^9;Z/7^ Y2q"8B{%x36쐄Ijȟb5$>B2;;;;'33333TҟE%-X-X,XmsVoGnOhVݭޭrO*{um'^fC_Yo <晓ZAE|> D? #pI!عdU=]Oe@DIU]xĵYKy"1OB̡Ⴕ퉠F41N֥"U?TOcZY"Wr)ݕ@Tu ̍OZ3W׬ʏg1jQNz݂K+~/=Z0LŖfۜ5t? !g%BᄏKT|:m;T"`]}fjvl]xL2T6SyvMYx:rE29-XB'mq6ە )g 4t1B[֪9}nםrXΝr(@)?r0P9hv\/1 h4:B1q&8)/w+nN#Ɲ)@zDz/M hᆉF|DS\) *^N(}2 m l1{:w" 7ɥqmN)3:hL+*Op] _%)_qIρ&Bz(gwxh`ŢRq9__^<6Q:#xe/S}UBmZZ4Z^?^_\IK~~!Yaf| rcZV):)C@ش |4}|\ʞ!P>HƸx3 `gA#]Lo./(*^U>ΐ2#nSQ>7<_H7ɂ׊`h24)!y<i-#ԐY*&bAͩ3bX}.M$_N[ uLsy)-$$Qkn[v5[G1K3vN`bm*V[24I*^?|YjF