get_var("SELECT display_name FROM ".$wpdb->users." WHERE ID='" . intval($id) . "' LIMIT 1"); if ($name!="") return $name; else return false; } function al_GetList($id, $onlyactive=true) { global $wpdb, $table_prefix; $list=array(); $cond=""; if($onlyactive) $cond=" AND vote <> 2"; $data = $wpdb->get_results("SELECT user, vote FROM ".$table_prefix."attendance_list WHERE post = " . intval($id) .$cond. " ORDER BY date ASC"); if(count($data)>0 && is_array($data)) { foreach($data as $r) { if(al_UserData($r->user)) $list[$r->user] = $r->vote; } return $list; } return false; } function al_GetListNegative($id) { global $wpdb, $table_prefix; $list=array(); $data = $wpdb->get_results("SELECT user, vote FROM ".$table_prefix."attendance_list WHERE post = " . intval($id) . " AND vote = 2 ORDER BY date ASC"); if(count($data)>0 && is_array($data)) { foreach($data as $r) { if(al_UserData($r->user)) $list[$r->user] = $r->vote; } return $list; } return false; } function al_VoteName($vote) { global $al_lang; if($vote==1) return $al_lang[vote1]; if($vote==2) return $al_lang[vote2]; if($vote==3) return $al_lang[vote3]; return ""; } function al_AddVote($post, $vote) { global $wpdb, $current_user, $table_prefix; if ($current_user->ID > 0 && $post > 0 && $vote > 0) { $list = al_GetList($post, false); //check, if user already on list if (empty($list[$current_user->ID])) { $res=$wpdb->query(sprintf("INSERT INTO `".$table_prefix."attendance_list` (`post`, `user`, `vote`, `date`) VALUES (%d, %d, %d, %d)", intval($post), intval($current_user->ID), intval($vote), time() )); } else { $res=$wpdb->query(sprintf("UPDATE `".$table_prefix."attendance_list` SET `vote`=%d, `date`=%d WHERE post=%d AND user=%d LIMIT 1", intval($vote), time(), intval($post), intval($current_user->ID) )); } if($res) return true; } return false; } function al_AddCss(){ echo ''; } function al_AjaxVote($vars) { global $wpdb, $current_user, $al_lang; $res=al_AddVote(intval($vars["al_postid"]), intval($vars["al_vote"])); return al_DrawList(intval($vars["al_postid"]), intval($current_user->ID)); } function al_DrawList($id=0, $uid=0) { global $post, $current_user, $al_lang; if($id==0) $id=$post->ID; $list = al_GetList($id); $listneg = al_GetListNegative($id); $draw=''; if(count($list)>0 && is_array($list)) { $counter=1; foreach($list as $k=>$v) { if($uid == $k) $feature=' class="featured"'; else $feature=''; $draw.=''; $counter++; } } if(count($listneg)>0 && is_array($listneg)) { $counter=1; if(count($list)>0 && is_array($list)) $draw.=''; foreach($listneg as $k=>$v) { if($uid == $k) $feature=' class="featured"'; else $feature=''; $draw.=''; $counter++; } } $draw.='

'; $draw.=$al_lang['listheader'].'
'.$counter.'.	'.al_UserData($k).'	'.al_VoteName($v).'
'.$counter.'.	'.al_UserData($k).'	'.al_VoteName($v).'

'; return $draw; } ?>