Tennis

The Field in the xf_nflj_pickem_team is a varchar(5), so you'd need to edit the field and increase it to what ever size you need. Once that is done, you will need to edit the DataWriter for that table which is library/NFLJ/Pickem/DataWriter/Team.php and change the max length on line 20 from 5 to the same or lesser value as the one you set for the field. The input field on the create/edit form isn't "limited" so you won't have to make an adjustment there. I just added a change to the field size on the installer to change it from 5 to 25 on the next update, but will be keeping the DataWriter to 5, so you will have to apply the change to the DataWriter as I want the CORE addon to throw an error if more than 5 characters are added (because of the core layout). Hope thats OK with you?

 

you need to modify the getTeamsBySport method in the team Model (/library/NFLJ/Pickem/Model/Team.php

currently the ORDER BY is by team_abbr (Team Abbreviation). You can change it to team_id, team_city or team_nick. If I was doing a "player" type thing.. I'd put the players first name in City and Last name in nick and then sort by team_nick

PHP:

    public function getTeamsBySport($sportId)
    {
        return $this->_getDb()->fetchAll('
            SELECT teams.*,
                sport.*
            FROM xf_nflj_pickem_team as teams
                LEFT JOIN xf_nflj_pickem_sport AS sport
                    ON (sport.sport_id = teams.sport_id)           
            WHERE teams.sport_id = ? 
            ORDER BY team_abbr ASC
        ', $sportId);                   
    }    

 

To edit Admin Templates, you need to put your forum in debug mode and its an option in the Development Tab. You edit them just like regular templates, cept there are a lot of different xen syntax for admin templates.

 

Nice

 

Nice!! That is looking good

 

I haven't Phrased those yet, cause I am not done with the entire alerts system yet, so you will need to edit the two templates

alert_pickem_reminders_reminder1
alert_pickem_reminders_reminder2

This is what both templates look like. Just remove the word Week

HTML:

<b>1st Reminder</b>:
<a href="{xen:link pickem-picks, $content}" class="PopupItemLink">Week {$content.week_name}</a> of the {$content.pool_name} Pool closes in {$content.timeremaining} Hours. 

HTML:

<b>2nd Reminder</b>:
<a href="{xen:link pickem-picks, $content}" class="PopupItemLink">Week {$content.week_name}</a> of the {$content.pool_name} Pool closes in {$content.timeremaining} Hours.

 

Sorry, didn't see the other post.... there are no sidebar blocks for the forum home page. Someone paid me to build [bd] widget framework blocks and then someone else paid me to build XenPorta Blocks. They both then donated them back for everyone to use. That is the only reason those are available. You'll need to add a request for what you want (if you want them the same as others that I've done, just tell me which one(s)).