コード例 #1
0
 /**
  * return raid plan info array to send to template for tooltips in day/week/month/upcoming calendar
  *
  * @param int $month this month
  * @param int $day today
  * @param int $year this year
  * @param string $group_options
  * @param string $mode
  * @return array
  */
 public function DisplayCalendarRaidTooltip($month, $day, $year, $group_options, $mode)
 {
     global $db, $user, $config, $phpbb_root_path, $phpEx;
     $raidplan_output = array();
     $x = 0;
     $raidplan_counter = 0;
     // build sql to find raids on this day
     $day = $day < 10 ? ' ' . $day : $day;
     $month = $month < 10 ? ' ' . $month : $month;
     $sql_array = array('SELECT' => 'r.raidplan_id ', 'FROM' => array(RP_RAIDS_TABLE => 'r'), 'WHERE' => "(raidplan_access_level = 2\n\t\t\t\t\t   OR (r.poster_id = " . $db->sql_escape($user->data['user_id']) . " )\n\t\t\t\t\t   OR (r.raidplan_access_level = 1 AND (" . $group_options . ")) )\n\t\t\t\t\t  AND (r.raidplan_day = '" . $db->sql_escape($day . '-' . $month . '-' . $year) . "' ) ", 'ORDER_BY' => 'r.raidplan_start_time ASC');
     $sql = $db->sql_build_query('SELECT', $sql_array);
     $result = $db->sql_query_limit($sql, $x, 0, 86400);
     // we need to find out the time zone to display on tooltip
     if ($user->data['user_id'] == ANONYMOUS) {
         //grab board default
         $tz = $config['board_timezone'];
     } else {
         // get user setting
         $tz = (int) $user->data['user_timezone'];
     }
     $timezone = $user->lang['tz'][$tz];
     $rpcounter = 0;
     $raidplan = new Raidplan($this->game_id, $this->guild_id, $this->eventlist);
     while ($row = $db->sql_fetchrow($result)) {
         $raidplan->id = $row['raidplan_id'];
         $raidplan->Get_Raidplan();
         $raidplan->Check_auth();
         $fsubj = $subj = censor_text($raidplan->getSubject());
         if ($config['rp_display_truncated_name'] > 0) {
             if (utf8_strlen($subj) > $config['rp_display_truncated_name']) {
                 $subj = truncate_string($subj, $config['rp_display_truncated_name']) . '...';
             }
         }
         $correct_format = $config['rp_time_format'];
         if ($raidplan->getEndTime() - $raidplan->getStartTime() > 86400) {
             $correct_format = $config['rp_date_time_format'];
         }
         $pre_padding = 0;
         $padding = 0;
         $post_padding = 0;
         /* if in dayview we need to shift the raid to its time */
         if ($mode == "day") {
             // find padding values
             $pre_padding = 4 * $user->format_date($raidplan->getStartTime(), "H", true);
             $padding = 4 * $user->format_date($raidplan->getEndTime(), "H", true) - $pre_padding;
             $post_padding = 96 - $padding - $pre_padding;
         }
         $rolesinfo = array();
         $userchars = array();
         // only show signup tooltip if user can actually sign up
         if ($raidplan->getSignupsAllowed() == true && $raidplan->getLocked() == false && $raidplan->getFrozen() == false && $raidplan->getNochar() == false && $raidplan->getSignedUp() == false && $raidplan->getSignedOff() == false && $raidplan->getAccesslevel() != 0 && !$user->data['is_bot'] && $user->data['user_id'] != ANONYMOUS) {
             foreach ($raidplan->getMychars() as $key => $mychar) {
                 if ($mychar['role_id'] == '') {
                     $userchars[] = array('MEMBER_ID' => $mychar['id'], 'MEMBER_NAME' => $mychar['name']);
                 }
             }
             foreach ($raidplan->getRoles() as $key => $role) {
                 $rolesinfo[] = array('ROLE_ID' => $key, 'ROLE_NAME' => $role['role_name']);
             }
         }
         $evtype = $raidplan->getEventType();
         if (!isset($this->eventlist[$evtype])) {
             $this->eventlist = new \bbdkp\controller\raidplanner\rpevents(0);
             $this->eventlist = $this->eventlist->events;
         }
         if (strlen($this->eventlist[$evtype]['imagename']) > 1) {
             $eventimg = $phpbb_root_path . "images/bbdkp/event_images/" . $this->eventlist[$raidplan->getEventType()]['imagename'] . ".png";
         } else {
             $eventimg = $phpbb_root_path . "images/bbdkp/event_images/dummy.png";
         }
         $signuplist = $raidplan->getSignups();
         $raidinfo = array('TZ' => $timezone, 'RAID_ID' => $raidplan->id, 'PRE_PADDING' => $pre_padding, 'POST_PADDING' => $post_padding, 'PADDING' => $padding, 'ETYPE_DISPLAY_NAME' => $this->eventlist[$raidplan->getEventType()]['event_name'], 'FULL_SUBJECT' => $fsubj, 'EVENT_SUBJECT' => $subj, 'COLOR' => $this->eventlist[$raidplan->getEventType()]['color'], 'IMAGE' => $eventimg, 'EVENT_URL' => append_sid("{$phpbb_root_path}dkp.{$phpEx}", "page=planner&amp;view=raidplan&amp;raidplanid=" . $raidplan->id), 'EVENT_ID' => $raidplan->id, 'S_ANON' => $user->data['user_id'] == ANONYMOUS ? true : false, 'S_LOCKED' => $raidplan->getLocked(), 'S_FROZEN' => $raidplan->getFrozen(), 'S_NOCHAR' => $raidplan->getNochar(), 'S_SIGNED_UP' => $raidplan->getSignedUp(), 'S_SIGNED_OFF' => $raidplan->getSignedOff(), 'S_CONFIRMED' => $raidplan->getConfirmed(), 'S_SIGNUPMAYBE' => $raidplan->getSignedUpMaybe(), 'S_CANSIGNUP' => $raidplan->getSignupsAllowed(), 'S_LEGITUSER' => $user->data['is_bot'] || $user->data['user_id'] == ANONYMOUS ? false : true, 'S_SIGNUP_MODE_ACTION' => append_sid("{$phpbb_root_path}dkp.{$phpEx}", "page=planner&amp;view=raidplan&amp;raidplanid=" . $raidplan->id . "&amp;action=signup"), 'INVITE_TIME' => $user->format_date($raidplan->getInviteTime(), $correct_format, true), 'START_TIME' => $user->format_date($raidplan->getStartTime(), $correct_format, true), 'END_TIME' => $user->format_date($raidplan->getEndTime(), $correct_format, true), 'DISPLAY_BOLD' => $user->data['user_id'] == $raidplan->getPoster() ? true : false, 'ALL_DAY' => $raidplan->getAllDay() == 1 ? true : false, 'SHOW_TIME' => $mode == "day" || $mode == "week" ? true : false, 'COUNTER' => $raidplan_counter++, 'RAID_TOTAL' => $raidplan->getRaidTeamNeeded(), 'CURR_CONFIRMED_COUNT' => $signuplist['confirmed'], 'S_CURR_CONFIRMED_COUNT' => $signuplist['confirmed'] > 0 ? true : false, 'CURR_CONFIRMEDPCT' => sprintf("%.0f%%", $raidplan->getRaidTeamNeeded() > 0 ? round($signuplist['confirmed'] / $raidplan->getRaidTeamNeeded(), 2) * 100 : 0), 'CURR_YES_COUNT' => $signuplist['yes'], 'S_CURR_YES_COUNT' => $signuplist['yes'] + $signuplist['maybe'] > 0 ? true : false, 'CURR_YESPCT' => sprintf("%.0f%%", $raidplan->getRaidTeamNeeded() > 0 ? round($signuplist['yes'] / $raidplan->getRaidTeamNeeded(), 2) * 100 : 0), 'CURR_MAYBE_COUNT' => $signuplist['maybe'], 'S_CURR_MAYBE_COUNT' => $signuplist['maybe'] > 0 ? true : false, 'CURR_MAYBEPCT' => sprintf("%.0f%%", $raidplan->getRaidTeamNeeded() > 0 ? round($signuplist['maybe'] / $raidplan->getRaidTeamNeeded(), 2) * 100 : 0), 'CURR_NO_COUNT' => $signuplist['no'], 'S_CURR_NO_COUNT' => $signuplist['no'] > 0 ? true : false, 'CURR_NOPCT' => sprintf("%.0f%%", $raidplan->getRaidTeamNeeded() > 0 ? round($signuplist['no'] / $raidplan->getRaidTeamNeeded(), 2) * 100 : 0), 'CURR_TOTAL_COUNT' => $signuplist['yes'] + $signuplist['maybe']);
         $rpcounter += 1;
         $hourslot = $user->format_date($raidplan->getInviteTime(), 'Hi', true);
         $raidplan_output[$hourslot . '_' . $rpcounter] = array('raidinfo' => $raidinfo, 'userchars' => $userchars, 'raidroles' => $rolesinfo);
     }
     $db->sql_freeresult($result);
     return $raidplan_output;
 }