<?php

/*function basic_connect() {   //  Delete as soon as possible -> use connect::query() o connect::connect_simple() instead
    $db = new mysqli('localhost', USER, PASS, DATAB);
    if ($db->connect_errno) {
    echo '<div id="submit"><h2>Error!</h2><p>Couldn\'t connect to the database (' . $db->connect_errno .  ')</p><p><a href="JavaScript:void(0);" onclick="history.back()">Go back?</a></p>';
    return false;
    }
    return $db;
}
*/


function isodd($num) { /* Check if a number is even or odd */
$a = ($num % 2) ? 0 : 1;
return $a;
}

function table_class($i) {
    switch(isodd($i)) {
    case 0:
    return 'light';

    case 1:
    return 'dark';

    default:
    return 'light';

    }
}


/* handle queries and more repetitive tasks (e.g. displaying tables and statistics)

For quick queries where no further calls to mysqli object are needed, use connect::query ->> will return the result from a query
When needed to access the mysqli object, .e.g to get affected rows in last query, etc., just use connect::connect_simple -> will return the mysqli object itself

*/

class connect {

    public static function query($query) {    // We send a query and return the resulting array
    $db = new mysqli('localhost', USER, PASS, DATAB);
    if ($db->connect_errno) {
    return false;
    }
    $result = $db->query($query);
    $db->close();
    return $result;

     }



    public static function connect_simple() {
    $db = new mysqli('localhost', USER, PASS, DATAB);
    if ($db->connect_errno) {
    return false;
    }
    return $db;
    }



    function retrieve($query) {        // certain predefined queries to send to connect::query()

    switch($query) {

    case 'now':
    return $this->query('select * from anime where status = 1 order by name');

    case 'old':
    return $this->query('select * from anime where status = 0 order by name');

    case 'total_series':
    return $this->query('select * from anime where count >= 0');

    case 'count1':
    return $this->query('select * from anime where count = 1 or count = 0');

    case 'count2':
    return $this->query('select * from anime where count > 1');
    }
}


    private function _destruct() {    // Does this even work or do something?
    if (isset($result)) { $result->free(); }
    if (isset($db)) { $db->close(); }
    }

}




/* handle the different actions from index.php */

function index_action($act) {

switch($act) {

case 'error':
require('error.php');
break;

case 'add':
require('add.php');
break;

case 'submit':
require('submit.php');
break;

case 'delete':
require('submit.php');
break;

case 'login':
require('login.php');
break;

case 'logout':
require('logout.php');
break;

case 'changelog':
require('changelog.php');
break;

default:
include('main.php');
}
}



/* Here we will process all the data we get form the DB. Apart from making it more secure, try to get rid of incongruencies, format it, etc.
To be used both in the tables and elsewhere, e.g. statistics */

class anime {
private $data, $id, $name, $totaleps, $watchedeps, $year, $season, $status, $rating, $count, $comment;


    function __construct($db_data) {        // whenever we create an object of this class we need to input the raw data from the db

     $this->data = $db_data;
    }

    function get_id() {
    $this->id = $this->data['animeID'];
    return $this->id;
    }

    function get_name() {
    $this->name = $this->data['name'];
    $this->name = ucwords($this->name);
    $this->name = htmlentities($this->name, ENT_QUOTES, 'UTF-8');
    return $this->name;
    }


    function get_totaleps() {
    $this->totaleps = $this->data['total-episodes'];
    $this->totaleps = (int)$this->totaleps;
    if ($this->totaleps < 10) { $this->totaleps = 0 . $this->totaleps; }
    if ($this->totaleps == 0) { return 'N/A'; }
    else { return $this->totaleps; }
    }


    function get_watched() {
    $this->watchedeps = $this->data['total-watched'];
    $this->watchedeps = (int)$this->watchedeps;
    if ($this->watchedeps < 10) { $this->watchedeps = 0 . $this->watchedeps; }
    return $this->watchedeps;
    }


    function get_year() {
    $this->year = $this->data['year-watched'];
    $this->year = (int)$this->year;
    if ($this->year == 0) { return 'N/A'; }
    else if ($this->year < 1970) { return 'N/A'; }
    else if ($this->year > (date('Y') + 2)) { return 'N/A'; }
    else { return $this->year; }
    }


    function get_season() {
    $this->season = $this->data['season-watched'];
    $this->season = (int)$this->season;
    switch ($this->season) {
        case 1:
        return 'Winter';
        case 2:
        return 'Spring';
        case 3:
        return 'Summer';
        case 4:
        return 'Fall';
        default:
        return 'N/A';
        }
    }

    function get_status() {
    $this->status = (int)$this->data['status'];
    if ($this->status != 1 && $this->status != 0) { return 0; }
    else { return $this->status; }
    }




    function ratingtext($param, $param2)  {  //$param is the rating value from the db. $param2 determines which array to use

    $rating_now = array('No rating', 'I\'m not enjoying it', 'I\'m liking it &hearts;', 'I\'m loving it &hearts;&hearts;', 'Favorite &hearts;&hearts;&hearts;');
    $rating_old = array('No rating', 'I didn\'t enjoy it', 'I liked it &hearts;', 'I loved it &hearts;&hearts;', 'Favorite &hearts;&hearts;&hearts;');

    if ($param2 == 0) {
        $rating = &$rating_old;
    }

    else {
        $rating = &$rating_now;
    }

    switch($param) {
        case 0:
        return sprintf('<span class="norating">%s</span>', $rating[0]);
        case 1:
        return sprintf('<span class="dislike">%s</span>', $rating[1]);
        case 2:
        return sprintf('<span class="like">%s</span>', $rating[2]);
        case 3:
        return sprintf('<span class="love">%s</span>', $rating[3]);
        case 4:
        return sprintf('<span class="favorite">%s</span>', $rating[4]);
        default:
        return 'N/A';
        }
    }



    function get_rating() {
    $this->rating = (int)$this->data['rating'];
    if ($this->get_status() == 0) { return $this->ratingtext($this->rating, 0); }
    else { return $this->ratingtext($this->rating, 1); }

    }

    function get_count() {
    $this->count = (int)$this->data['count'];
    if ($this->count < 1) { return 'Dropped'; }
    else if ($this->count > 1 && $this->get_status() == 1) { return sprintf('%d <abbr class="cursor_help" title="Rewatching"> (R)</abbr>', $this->count); }
    else { return $this->count; }
    }

    function get_comment() {
    $this->comment = $this->data['comment'];
    if (strlen($this->comment) == 0) { return 'No comment'; }
    else { return $this->comment; }
    }


} /* end class anime */




    /* Function to draw the table with the data from the DB */

function draw_table($param)  // 0 = current, 1 = completed
{

$db = new connect();


    // This determines which data to retrieve from database. This allows us to use the same loop for both animes we're watching and completed animes, and allows us to potentially use it for any other table with other data
    if ($param == 0) { $result = $db->retrieve('now'); }
    else { $result = $db->retrieve('old'); }

      $rows = $result->num_rows;


    // We create the table header

       $format = '<table class="currently-watching"><tr><th class="number">#</th><th class="series">Series</th><th class="episodes">Eps</th><th class="rating">Impression</th><th class="season">Season</th><th class="count">Count</th>';

    if (check_login()) {   // If valid session, we also get the "ACTIONS" column
        $format = sprintf('%s <th class="actions">Actions</th></tr>', $format);
    }

 /* loop to retrieve the data from db and draw the table with it. For each row retrieved, we generate a table row. Every time we iterate, we will add a new row to the variable $format, so at the end it will contain the whole table */

    for ($i = 0; $i < $rows; $i++) {

    $style = table_class($i);
    $rowres = $result->fetch_assoc();
    $table = new anime($rowres);

     $format =  sprintf("%s <tr class='%s'><td class='number'>%s</td><td class='series'>%s</td><td class='episodes'>%d / %d</td><td class='rating'>%s</td><td class='season'>%d (%s)</td><td class='count'>%s</td>", $format, $style, $i + 1, $table->get_name(), $table->get_watched(), $table->get_totaleps(), $table->get_rating(), $table->get_year(), $table->get_season(), $table->get_count());




    if (check_login()) {   // If valid session, we also add the row with the actions available to manage it

    $format = sprintf('%s <td class="action">', $format);

            if ($param == 0) {   // if watching, we give the option to update list after watching an episode
            $format = sprintf('%s <a title="Increment episode by one" href="javascript:void(0)" onclick="increment_entry(%d)">Ep +1</a> | ', $format, $table->get_id());
            }

        // We add delete links

            $format = sprintf('%s <a title="Delete?" href="javascript:void(0)" onclick="delete_entry(%d, \'%s\')">Del</a></td></tr>', $format, $table->get_id(), $table->get_name());

    }  else {  // if not, we just close the row
        $format = $format . '</tr>';
        }



    unset($table);

    } /* end for */

    unset($db);

     /* end else */

    $format = sprintf('%s </table>', $format); // we close the table

    return $format ;
}





class statistics {  //statistics for the profile

private $sum2, $sum;

    function get_data($param) {     // we prepare to get the data depending on parameter supplied. Each of the queries matches one of the predefined actions in the class connect
    switch ($param) {
    case 1:
    $query = 'count1';
    break;

    case 2:
    $query = 'count2';
    break;

    case 3:
    $query = 'total_series';
    break;
    }

    $this->db = new connect();
    return $this->db->retrieve($query);
    }



    function get_totalseries() {
    $this->result = $this->get_data(3);
    return $this->result->num_rows;
    }



    function prep_eps1() {          // we get the shows we've watched only once or 0 -> no maths needed
    $this->result = $this->get_data(1);
    while ($this->rows = $this->result->fetch_assoc()) {
    $this->process = new anime($this->rows);
    $this->sum = $this->sum + $this->process->get_watched();    // we only neeed to get watched episodes if we've only watched it once or 0 (= dropped)
    unset ($this->process);
    }
    return $this->sum;
    }



    function prep_eps2() {      // we get shows we've watched more than once
    $this->result = $this->get_data(2);
    while ($this->rows = $this->result->fetch_assoc()) {
    $this->process = new anime($this->rows);

 /* The watched episodes can be either all of them (e.g. 12 out of 12) if not currently watching it, but it could also be that we're rewatching it and we've watched 5 out of 12, for example, so we can't just multiply total episodes * count. Afte rthis, we'd get the total episodes, and multiply it by total count - 1, since one of the counts is already implied in watched */

    $this->sum2 = $this->sum2 + $this->process->get_watched() + $this->process->get_totaleps() * ($this->process->get_count() - 1);
    unset ($this->process);
    }
    return $this->sum2;
    }


    function get_total_episodes() {   // and now we sum the output from the two and get total episodes
    return $this->prep_eps2() + $this->prep_eps1();

    }
}



function check_login() {         // check if user is logged in, either through $_SESSION or cookies

  if (isset($_SESSION['user'])) {
   return true;
  }


  else if (isset($_COOKIE['SAL_AUTH'])) {

    $cookie = $_COOKIE['SAL_AUTH'];

    $array_cookie = explode("[]", $cookie);
    $user = $array_cookie[0];
    $pass = $array_cookie[1];



     $query = sprintf('select * from auth where User = "%s" and Password = "%s"', $user, $pass);
      $result = connect::query($query);

        if ($result->num_rows == 1) {
          $_SESSION['user'] = $user;
         return true;
        }
        else { return false; }

    } // end else if

   else { return false; }

} // end function check_login



function redir_index() {  // redirects in 2 seconds to index.php using javascript (if possible use headers though)
$redirect = '<script>setTimeout("to_index()", 2000)</script>';
echo $redirect;
}


function login_form() {   // Display the login form  (??? should go back to html portion, the function doesn't make any sense)

?>

<h3>User: Kirino<br />
Password: imouto</h3>


<form name="login" method="post" action="log_user.php">
<table><tr>
<td>User: </td><td><input type="text" name="user" /></td></tr>
<tr><td>Password: </td><td><input type="password" name="pass" /></td></tr>
<tr><td colspan="2"  style="text-align: center">
<input type="submit" value="Log in" /></td></tr></table>
</form>

<?php
}



function get_error($errno) {       // return the error message based on $_GET['type'] when directed to error.php

switch($errno) {
case 'nofound':
return '<p>No records in database!<br />';

case 'connect':
return '<p>There was an error connecting with the database or processing the data (' . $no . ') <br />';

case 'emptylogin':
return '<p>You didn\'t provide your username or password. <a href="javascript:void(0)" onclick="history.back()">Go back?</a>';

case 'errorlogin':
return '<p>Your username and password didn\'t match. <a href="javascript:void(0)" onclick="history.back()">Go back?</a>';

default:
return '<p>There was an error<br />';

}
}
?>