WordPress.org
Get WordPress

Plugin Directory

Changeset 2180661


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

Added Approval Date to character details, fixed complaint about using count on an object for PHP7, inbox summary lists correct number of emails based on shortcode input.

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r2056049 r2180661  
    3333                AND chara.PRIVATE_CLAN_ID = privclan.ID";
    3434    $result = $wpdb->get_results($wpdb->prepare($sql, $characterID));
    35    
     35       
    3636    if (count($result) == 0) {
    3737        $result[0]->priv = '';
    … …  
    934934                           chara.date_of_birth,
    935935                           chara.date_of_embrace,
     936                           IFNULL(cgen.APPR_DATE,playxp.XP_AWARDED) approval_date,
    936937                           gen.name gen,
    937938                           gen.bloodpool,
    … …  
    945946                           chara.ID,
    946947                           chara.last_updated
    947                     FROM " . $table_prefix . "CHARACTER chara,
     948                    FROM " . $table_prefix . "CHARACTER chara
     949                        LEFT JOIN (
     950                            SELECT CHARACTER_ID, MIN(DATE_OF_APPROVAL) AS APPR_DATE
     951                            FROM " . $table_prefix . "CHARACTER_GENERATION
     952                            GROUP BY CHARACTER_ID
     953                        ) cgen
     954                        ON cgen.CHARACTER_ID = chara.ID
     955                        LEFT JOIN (
     956                            SELECT CHARACTER_ID, MIN(AWARDED) AS XP_AWARDED
     957                            FROM " . $table_prefix . "PLAYER_XP
     958                            GROUP BY CHARACTER_ID
     959                        ) playxp
     960                        ON playxp.CHARACTER_ID = chara.ID
     961                        ,
    948962                         " . $table_prefix . "CLAN pub_clan,
    949963                         " . $table_prefix . "CLAN priv_clan,
    … …  
    965979                      AND chara.id                  = path_totals.character_id";
    966980
     981    //print $wpdb->prepare($sql, $character);
    967982    $character_details = $wpdb->get_row($wpdb->prepare($sql, $character));
    968983   
    … …  
    9871002    }
    9881003
    989     if (count($character_details) > 0) {
     1004    if (vtm_count($character_details) > 0) {
    9901005        if ($group == "") {
    9911006            $output  = "<table class='gvplugin' id=\"" . vtm_get_shortcode_id("gvid_cdb") . "\"><tr><td class=\"gvcol_1 gvcol_key\">Character Name</td><td class=\"gvcol_2 gvcol_val\">" . vtm_formatOutput($character_details->char_name) . "</td></tr>";
    … …  
    10041019            $output .= "<tr><td class=\"gvcol_1 gvcol_key\">Road or Path rating</td><td class=\"gvcol_2 gvcol_val\">"   . $character_details->path_value      . "</td></tr>";
    10051020            $output .= "<tr><td class=\"gvcol_1 gvcol_key\">Last Updated</td><td class=\"gvcol_2 gvcol_val\">"          . $character_details->last_updated    . "</td></tr>";
     1021            $output .= "<tr><td class=\"gvcol_1 gvcol_key\">Character Creation Date</td><td class=\"gvcol_2 gvcol_val\">"       . $character_details->approval_date . "</td></tr>";
    10061022           
    10071023            if ($vtmglobal['config']->USE_NATURE_DEMEANOUR == 'Y') {
    … …  
    14181434   
    14191435    $args = array(
    1420         //'posts_per_page'   => $listno,
     1436        'posts_per_page'   => $list + 1, // need the extra +1 to generate the "More.." link
    14211437        'orderby'          => 'date',
    14221438        'order'            => 'DESC',
Note: See TracChangeset for help on using the changeset viewer.