WordPress.org
Get WordPress

Plugin Directory

Changeset 2180663


Ignore:
Timestamp:
10/26/2019 02:51:20 PM (6 years ago)
Author:
magent
Message:

Added approval data to character class, declared empty array for rituals so it has a value

File:
1 edited

Legend:

Unmodified
Added
Removed

  • vampire-character/trunk/inc/classes.php

    r2056047 r2180663  
    3030    var $date_of_birth;
    3131    var $date_of_embrace;
     32    var $date_of_approval;
    3233    var $sire;
    3334    var $combo_disciplines;
    … …  
    9293                         " . VTM_TABLE_PREFIX . "ROAD_OR_PATH paths,
    9394                         " . VTM_TABLE_PREFIX . "SECT sects,
    94                          " . VTM_TABLE_PREFIX . "CHARACTER_STATUS cstatus
     95                         " . VTM_TABLE_PREFIX . "CHARACTER_STATUS cstatus,
     96                         " . VTM_TABLE_PREFIX . "CHARACTER_GENERATION cgen
    9597                    WHERE chara.PUBLIC_CLAN_ID = pub_clan.ID
    9698                      AND chara.PRIVATE_CLAN_ID = priv_clan.ID
    … …  
    164166        $user = get_user_by('login',$this->name);
    165167        $this->display_name = isset($user->display_name) ? $user->display_name : 'No character selected';
     168       
     169        // Character Generation
     170        $sql = "SELECT DATE_OF_APPROVAL FROM " . VTM_TABLE_PREFIX . "CHARACTER_GENERATION WHERE CHARACTER_ID = '%s'";
     171        $result = $wpdb->get_row($wpdb->prepare($sql, $characterID));
     172        if (empty($result->DATE_OF_APPROVAL)) {
     173            $sql = "SELECT AWARDED FROM " . VTM_TABLE_PREFIX . "PLAYER_XP WHERE CHARACTER_ID = '%s' ORDER BY AWARDED";
     174            $result = $wpdb->get_row($wpdb->prepare($sql, $characterID));
     175            if ($result)
     176                $this->date_of_approval = $result->AWARDED;
     177        }
     178        else
     179            $this->date_of_approval = $result->DATE_OF_APPROVAL;
     180       
    166181       
    167182        // Profile
    … …  
    729744        $result = $wpdb->get_results($sql);
    730745        $i = 0;
     746        $this->rituals = array();
    731747        foreach ($result as $ritual) {
    732748            $this->rituals[$ritual->discname][$i] = array(
Note: See TracChangeset for help on using the changeset viewer.