getEndeavorHtml.php

<?php
/*
 * getEndeavorHtml.php -- by Dave Humphrey (dave@uesp.net), June 2022
 * 
 * Returns HTML fragments of Endeavor quests.
 * 
 * TODO:
 *
 */

	// Database users, passwords and other secrets
require("/home/uesp/secrets/esolog.secrets");
require("esoCommon.php");


class CEsoEndeavorHtml
{
	public $showDesc = false;
	public $showAll = false;
	public $showLatestInHistory = false;
	
	public $db = null;
	
	public $endeavors = [];
	public $allEndeavors = [];
	public $dailyStartTimestamp = -1;
	public $weeklyStartTimestamp = -1;
	public $latestDailyTimestamp = -1;
	public $latestWeeklyTimestamp = -1;
	
	public $errorMessages = [];
	
	
	public function __construct()
	{
		$this->ParseInputParams();
		$this->InitDatabase();
	}
	
	
	public function ReportError($errorMsg)
	{
		error_log($errorMsg);
		$this->errorMessages[] = $errorMsg;
		return false;
	}
	
	
	private function ParseInputParams ()
	{
		$this->inputParams = $_REQUEST;
		
		if (array_key_exists('showall', $this->inputParams)) $this->showAll = intval($this->inputParams['showall']);
		if (array_key_exists('showdesc', $this->inputParams)) $this->showDesc = intval($this->inputParams['showdesc']);
		if (array_key_exists('showlatest', $this->inputParams)) $this->showLatestInHistory = intval($this->inputParams['showlatest']);
	}
	
	
	private function InitDatabase()
	{
		global $uespEsoLogReadDBHost, $uespEsoLogReadUser, $uespEsoLogReadPW, $uespEsoLogDatabase;
		
		$this->db = new mysqli($uespEsoLogReadDBHost, $uespEsoLogReadUser, $uespEsoLogReadPW, $uespEsoLogDatabase);
		if ($this->db->connect_error) return $this->ReportError("ERROR: Could not connect to mysql database!");
		
		return true;
	}
	
	
	private function OutputHtmlHeader()
	{
		ob_start("ob_gzhandler");
		
		header("Expires: 0");
		header("Pragma: no-cache");
		header("Cache-Control: no-cache, no-store, must-revalidate");
		header("Pragma: no-cache");
		header("content-type: text/html");
		
		header("Access-Control-Allow-Origin: *");
	}
	
	
	private function MakeId($name)
	{
		$id = preg_replace('/ /', '_', trim($name));
		$id = preg_replace('/[^A-Za-z0-9_-]+/', '', $id);
		return strtolower($id);
	}
	
	
	private function MakeIconUrl($icon)
	{
		$icon = str_replace(".dds", ".png", $icon);
		$icon = $this->EscapeHtml($icon);
		return "https://esoicons.uesp.net" . $icon;
	}
	
	
	private function EscapeHtml($string)
	{
		return htmlspecialchars($string);
	}
	
	
	private function LoadLatestEndeavors()
	{
		$this->lastQuery = "select max(startTimestamp) as m from endeavors where type=0;";
		$result = $this->db->query($this->lastQuery);
		if ($result === false) return $this->ReportError("Error: Failed to find latest daily endeavor timestamps!");
		
		$maxDailyTimestamp = $result->fetch_assoc()['m'];
		if ($maxDailyTimestamp == null || $maxDailyTimestamp <= 0) return $this->ReportError("Error: Failed to find latest daily endeavor timestamp!");
		$maxDailyTimestamp = intval($maxDailyTimestamp);
		$this->dailyStartTimestamp = $maxDailyTimestamp;
		$this->latestDailyTimestamp = $maxDailyTimestamp;
		
		$this->lastQuery = "select max(startTimestamp) as m from endeavors where type=1;";
		$result = $this->db->query($this->lastQuery);
		if ($result === false) return $this->ReportError("Error: Failed to find latest weekly endeavor timestamps!");
		
		$maxWeeklyTimestamp = $result->fetch_assoc()['m'];
		if ($maxWeeklyTimestamp == null || $maxWeeklyTimestamp <= 0) return $this->ReportError("Error: Failed to find latest weekly endeavor timestamp!");
		$maxWeeklyTimestamp = intval($maxWeeklyTimestamp);
		$this->weeklyStartTimestamp = $maxWeeklyTimestamp;
		$this->latestWeeklyTimestamp = $maxWeeklyTimestamp;
		
		$this->lastQuery = "SELECT * FROM endeavors WHERE (startTimestamp=$maxDailyTimestamp AND type=0) OR (startTimestamp=$maxWeeklyTimestamp AND type=1);";
		
		$result = $this->db->query($this->lastQuery);
		if ($result === false) return $this->ReportError("Error: Failed to load endeavor data!");
		if ($result->num_rows == 0) return $this->ReportError("No matching endeavor data found!");
		
		$this->endeavors = [];
		
		while ($row = $result->fetch_assoc())
		{
			$type = intval($row['type']);
			$this->endeavors[$type][] = $row;
		}
		
		return true;
	}
	
	
	private function LoadAllEndeavors()
	{
		$this->itemTimestamp = -1;
		$this->lastQuery = "SELECT * FROM endeavors;";
		
		$result = $this->db->query($this->lastQuery);
		if ($result === false) return $this->ReportError("Error: Failed to load all endeavors data!");
		if ($result->num_rows == 0) return $this->ReportError("No endeavor data found!");
		
		$this->allEndeavors = [];
		$latestWeeklyTimestamp = 0;
		$latestDailyTimestamp = 0;
		
		while ($row = $result->fetch_assoc())
		{
			$ts = intval($row['startTimestamp']);
			$type = intval($row['type']);
			
			if ($type == 0 && $ts > $latestDailyTimestamp) $latestDailyTimestamp = $ts;
			if ($type == 1 && $ts > $latestWeeklyTimestamp) $latestWeeklyTimestamp = $ts;
			
			
			$this->allEndeavors[$ts][$type][] = $row;
		}
		
		$this->latestDailyTimestamp = $latestDailyTimestamp;
		$this->latestWeeklyTimestamp = $latestWeeklyTimestamp;
		
		krsort($this->allEndeavors);
		return true;
	}
	
	
	private function OutputHtmlError($msg)
	{
		print("Error: $msg\n");
		print(implode("\n", $this->errorMessages));
		return false;
	}
	
	
	private function OutputGroupedEndeavorsHtml($titlePrefix, $endeavors, $timestamp)
	{
		$output = "";
		
		if ($endeavors == null) $endeavors = $this->endeavors;
		if ($timestamp == null) $timestamp = $this->itemTimestamp;
		
		ksort($endeavors);
		
		if (count($endeavors) == 0) return "";
		
		$formatDate = "";
		$formatDateId = "";
		
		if ($timestamp > 0) 
		{
			$formatDateId = gmdate('Y-m-d', $timestamp + 1);
			$formatDate = gmdate('j F Y', $timestamp + 1);
		}
		
		$output .= "<a name='uespesoEndeavors_$formatDateId'></a>\n";
		$output .= "<h4>$titlePrefix$formatDate</h4>\n";
		$output .= "<ul class='uespesoEndeavorList'>\n";
		
		foreach ($endeavors as $type => $endeavorTypes)
		{
			if (count($endeavorTypes) == 0) continue;
			
			$typeLimit = intval($endeavorTypes[0]['typeLimit']);
			$typeName =GetEsoTimedActivityTypeText($type);
			$output .= "<li><span class='uespesoEndeavorTypeTitle uespesoEndeavorTypeTitle$type'>$typeName Endeavors (perform any $typeLimit)</span><ul class='uespesoEndeavorList$type'>\n";
			
			foreach ($endeavorTypes as $endeavor)
			{
				$rewards = $this->EscapeHtml($endeavor['rewards']);
				$name = $this->EscapeHtml($endeavor['name']);
				$desc = $this->EscapeHtml($endeavor['description']);
				$endTimestamp = $endeavor['endTimestamp'];
				
				$formatEndDate = gmdate('j F Y', $endTimestamp);
				
				$output .= "<li title='$desc'><span class='uespesoEndeavorName'>$name</span> -- <span class='uespesoEndeavorReward'>$rewards</span>";
				//$output .= " (ends on $formatEndDate)";
				if ($this->showDesc) $output .= "<br/><div class='uespesoEndeavorDesc'>$desc</div>";
				$output .= "</li>\n";
			}
			
			$output .= "</ul></li>\n";
		}
		
		$output .= "</ul>\n";
		return $output;
	}
	
	
	private function OutputLatestEndeavorsHtml()
	{
		return $this->OutputGroupedEndeavorsHtml("Latest Endeavors for ", $this->endeavors, $this->dailyStartTimestamp);
	}
	
	
	private function OutputAllEndeavorsHtml()
	{
		$output = "<div class='uespesoEndeavorHistory'>";
		
		foreach ($this->allEndeavors as $timestamp => $endeavors)
		{
			if ($timestamp == $this->latestDailyTimestamp && !$this->showLatestInHistory) unset($endeavors[0]);
			if ($timestamp == $this->latestWeeklyTimestamp && !$this->showLatestInHistory) unset($endeavors[1]);
			
			$output .= $this->OutputGroupedEndeavorsHtml("Endeavors for ", $endeavors, $timestamp);
		}
		
		$output .= "</div>";
		return $output;
	}
	
	
	private function OutputHtml()
	{
		$output = "<div class='uespesoGoldenVendor'>\n";
		
		if ($this->showAll)
			$output .= $this->OutputAllEndeavorsHtml();
		else
			$output .= $this->OutputLatestEndeavorsHtml();
		
		$output .= "</div>\n";
		
		print($output);
		
		return true;
	}
	
	
	public function Render()
	{
		$this->OutputHtmlHeader();
		
		if ($this->showAll)
		{
			if (!$this->LoadAllEndeavors()) return $this->OutputHtmlError();
		}
		else
		{
			if (!$this->LoadLatestEndeavors()) return $this->OutputHtmlError();
		}
		
		$this->OutputHtml();
		
		return true;
	}
};


$end = new CEsoEndeavorHtml();
$end->Render();