wow_alpha_books.php

<?php

/*
  Author: X'Genesis Qhulut <XGenesis-Qhulut@protonmail.com>
  Date:   August 2022

  See LICENSE for license details.
*/

// BOOKS (page_text)

function simulateBookPage ($row, $page = 0)
  {
  echo "<p><div class='simulate_box page_text'>\n";
  if ($page)
    boxTitle ("Page $page");
  echo "<p>";
  echo nl2br_http (fixQuestText ($row ['text']));
  endDiv ('simulate_box page_text');
  }

function showTextDetails ()
{
  global $id, $item, $items;

  $page = 0;

  // to avoid loops
  $shown = array ();

//  boxTitle ($items [$item]);
  // for each page ...

  while ($id)
    {
    $row = dbQueryOneParam ("SELECT * FROM ".PAGE_TEXT." WHERE entry = ?", array ('i', &$id));
    if (!$row)
      break;
    $page++;
    simulateBookPage ($row, $page);
    $shown [$id] = true;
    $id = $row ['next_page'];
    // avoid endless loops
    if (array_key_exists ($id, $shown))
      break;
    } // end of while each page
} // end of showTextDetails

function showText ()
  {
  global $id, $item, $items;
  $name = $items [$item];
  pageContent (false, 'Page', $name , 'books', function ($info)
    {
     middleSection (false, function ($info)
          {
          showTextDetails ();
          });
    }
  , PAGE_TEXT);
  } // end of showText

function bookTopLeft ($row)
{
  global $id, $item, $items;
  showOneThing (PAGE_TEXT, 'entry', $id, "", "", array (),
                array ('entry', 'next_page'));
} // end of bookTopLeft

function bookTopMiddle ($row)
{
  global $id, $item, $items;
  boxTitle ('In-game view');
  simulateBookPage ($row);
} // end of bookTopMiddle


function bookRelatedItem ($row)
  {
  global $id, $item, $items;

  $page_text = PAGE_TEXT;
  $item_template = ITEM_TEMPLATE;

 // find the page chains

  $pages = array ();
  $results = dbQuery ("SELECT entry, next_page FROM $page_text");
  while ($chainRow = dbFetch ($results))
    $pages [$chainRow ['next_page']] = $chainRow ['entry'];
  dbFree ($results);

  // now we can work back until we find the start of the chain
  $doneThis = array ();
  do
    {
    if (!array_key_exists ($id,  $pages))
      break;  // no previous, this must be the start of the chain
    $prevPage = $pages [$id];
    if (array_key_exists ($id,  $doneThis))
      break;    // doing the same one again, give up
    $doneThis [$id] = true;
    $id = $prevPage;
    } while ($prevPage);

  $results = dbQueryParam (
        "SELECT T2.entry AS item_key
          FROM $page_text AS T1
              INNER JOIN $item_template AS T2
          ON (T1.entry = T2.page_text)
          WHERE T1.entry = ?",
          array ('i', &$id));

  if (count ($results) > 0)
    {
   listItems ('Items containing this page', ITEM_TEMPLATE, count ($results), $results,
      function ($row) use ($items)
        {
        listThing ($items, $row ['item_key'], 'show_item');
        },
        true);
    }
  else
    {
    boxTitle ('Items containing this page');
    echo "<ul><li>No items containing this page could be found.</ul>";
    }

  } // end of bookRelatedItem

function bookDetails ($row)
  {
  global $id;

  topSection    ($row, function ($row) use ($id)
      {
      topLeft   ($row, 'bookTopLeft');
      topMiddle ($row, 'bookTopMiddle');
      });

  middleSection ($row, function ($row) use ($id)
      {
      middleDetails ($row, 'bookRelatedItem');
      });

  bottomSection ($row, function ($row) use ($id)
      {
      showOneThing (PAGE_TEXT, 'entry', $id, "Database entry for page", "", array ());
      });

  } // end of bookDetails

function showOneBook ()
  {
  global $id;

  if (($id === false && !repositionSearch()) || !checkID ())
    return;

  // we need the item info in this function
  $row = dbQueryOneParam ("SELECT * FROM ".PAGE_TEXT." WHERE entry = ?", array ('i', &$id));

  if (!$row)
    {
    ShowWarning ("Page $id is not on the database");
    return;
    }

  setTitle ("Book page (entry) $id");

  pageContent ($row, 'Page', "Page (entry) $id", 'books', 'bookDetails', PAGE_TEXT);
  } // end of showOneBook

function showBooks ()
  {
  global $where, $params, $maps, $sort_order, $matches;

  $sortFields = array (
    'entry',
    'text',
    'next_page',
  );

  setTitle ('Books listing');

  if (!in_array ($sort_order, $sortFields))
    $sort_order = 'entry';

  $td  = function ($s) use (&$row) { tdx ($row  [$s]); };
  $headings = array ('Entry', 'Text', 'Next Page');

  $results = setUpSearch ('Pages', $headings, $sortFields);

  if (!$results)
    return;

  $searchURI = makeSearchURI (true);
  $pos = 0;

  foreach ($results as $row)
    {
    $pos++;
    echo "<tr>\n";
    $id = $row ['entry'];
    tdh ("<a href='?action=show_book&id=$id$searchURI&pos=$pos&max=$matches'>$id</a>");
    echo "<td>" . nl2br_http (fixQuestText ($row ['text'])) . "</td>\n";

    $td ('next_page');
    showFilterColumn ($row);
    echo "</tr>\n";
    }

  wrapUpSearch ();


  } // end of showBooks
?>