Nodes As Tabs 1.5.1

[jayramfootball]

Been trying this all day a few different ways..

The most promising approach, below, read all rows (80) but did not pass any values to $response - my output just shows 80 blank rows.

Lol, everywhich way gives me some success but not what I want

<?php
class SummaryRatings_Model_SummaryRatings
    {
        public static function getRatings(XenForo_ControllerPublic_Abstract $controller, XenForo_ControllerResponse_Abstract &$response)
            {
                $db = XenForo_Application::getDb();
 
                $ratings = $db->query("
                    SELECT *
                    FROM ratings
                    ");
 
                while ($rating = $ratings->fetch())
                {
                    $allratings[] = array(
                        'player_image' => base64_encode( $rating['player_image']) ,
                        'player_name' => $rating['player_name'],
                        'rating' => $rating['rating']
                    );
                }
 
                $response->params['row'] = $allratings;
       
            }
           
    }
?>

 

[Jake Bunce]

<?php
class SummaryRatings_Model_SummaryRatings
    {
        public static function getRatings(XenForo_ControllerPublic_Abstract $controller, XenForo_ControllerResponse_Abstract &$response)
            {
                $db = XenForo_Application::getDb();
 
                $ratings = $db->fetchAll("
                    SELECT *
                    FROM ratings
                    ");

                $allratings = array();
                foreach ($ratings AS $rating)
                {
                    $allratings[] = array(
                        'player_image' => base64_encode( $rating['player_image']) ,
                        'player_name' => $rating['player_name'],
                        'rating' => $rating['rating']
                    );
                }
 
                $response->params['rows'] = $allratings;
       
            }
           
    }
?>

Then in your template you can "foreach" over the rows:

<table CELLPADDING=30 border =5 >

<xen:foreach loop="$rows" value="$row">
<tr>
<td>{$row.title}</td>
<td>{$row.player_name}</td>
<td>{$row.rating}</td>
</tr>
</xen:foreach>

</table>

 

[jayramfootball]

OK I got to the point - after 8 hours where I know my query is ok up the $response command.

I have echoed out one of the variables to ensure that the data is being read by the query below (and it is)

<?php
class SummaryRatings_Model_SummaryRatings
    {
        public static function getRatings(XenForo_ControllerPublic_Abstract $controller, XenForo_ControllerResponse_Abstract &$response)
            {
                $mysqli = new mysqli("localhost", "arsenalt_admin", "ramsday00",  "arsenalt_xenforo");
 
                /* check connection */
                if (mysqli_connect_errno()) {
                    printf("Connect failed: %s\n", mysqli_connect_error());
                    exit();
                }
 
                $query = "SELECT title, player_name, player_image, rating FROM ratings";
                $result = $mysqli->query($query);
 
                /* associative and numeric array */
               
                while($row = $result->fetch_array(MYSQLI_ASSOC))
                {
                $rows[] = $row;
                }
 
                foreach($rows as $row)
                {
                $row['player_image'] = base64_encode( $row['player_image'] );
                echo $row['rating'];
                }
                $response->params['row'] = $rows;
               
       
            }
           
    }
?>

BUT, all i get in the xenforo page template are 80 blank rows - so I suspect that the $response command is not reading the data...

I am completely stuck on where to go next.

Please help me get over last hurdle

cheers

J

 

[Jake Bunce]

I like your previous code better, the one that I amended, and the one that uses XF's $db object.

 

[jayramfootball]

I like your previous code better, the one that I amended, and the one that uses XF's $db object.

If you were a woman I would be proposing right now - I had missed your ammended code using the $db object and have just swapped it back.... it works!

Thank you very much! With this I can adapt it now for so much of what I want to do

Anyone trying to do something similar - Jake's amended code in post #222 is the code that works...

 

[jayramfootball]

Jake - you helped me a lot with this one - here's the output

http://arsenaltalk.net/pages/ratingsummary/

this takes the data from 'simple forms', summarises all the data into a single table via a cron job, and updates a page node with the data using a callback and template...
xenforo is good.

 

[andrewkm]

How can i change the text color of a node title that is a tab. I would like one of my node tabs to be a different color then the default (Only one though)

 

[Jake Bunce]

How can i change the text color of a node title that is a tab. I would like one of my node tabs to be a different color then the default (Only one though)

Admin CP -> Appearance -> Templates -> EXTRA.css

.navTabs .navTab.nodetab1 .navLink
{
	color: red;
}

You need to enter the node_id of the node that is a tab.

 

[andrewkm]

Admin CP -> Appearance -> Templates -> EXTRA.css

.navTabs .navTab.nodetab1 .navLink
{
color: red;
}

You need to enter the node_id of the node that is a tab.

Hmm this doesnt seem to work for me. I am getting the ID from the url at the bottom when holding my mouse over it in applications -> node tree.
http://www.website.com/forum/admin.php?nodes/thenodesname.59/edit

Looks as such:

.navTabs .navTab.nodetab59 .navLink
{
    color: red;
}
.discussionListItem.unread .title a:before
{
    content: '[Unread] ';
    color: grey;
    font-weight: bold;
}
.discussionListItem.locked .title a:before
{
    content: '[Locked] ';
    color: red;
    font-weight: bold;
}
.discussionListItem.sticky .title a:before
{
    content: '[Sticky] ';
    color: gold;
    font-weight: bold;
}

 

[Jake Bunce]

Hmm this doesnt seem to work for me.

What is the forum URL? I can take a look.

Some old custom styles have this problem which requires you to manually fix the code in the navigation template:

http://xenforo.com/community/threads/extratabid-missing-from-nav-tab.25643/

 

[Jake Bunce]

Yep, your navigation template is bugged. Edit the template:

Admin CP -> Appearance -> Templates -> navigation

There is at least one instance of this:

$extraTabId

That needs to be replaced with this:

{$extraTabId}

The correct code is shown here:

http://xenforo.com/community/threads/extratabid-missing-from-nav-tab.25643/

 

[andrewkm]

Yep, your navigation template is bugged. Edit the template:

Admin CP -> Appearance -> Templates -> navigation

There is at least one instance of this:

$extraTabId

That needs to be replaced with this:

{$extraTabId}

The correct code is shown here:

http://xenforo.com/community/threads/extratabid-missing-from-nav-tab.25643/

Thank you! It worked and I successfully colored the tab I wanted to

 

[CurseCraft]

Is it possible to remove the
/pages/name
So it could just be /Hello
Or /vote
instead of /pages/Hello
/pages/vote

 

[Jake Bunce]

Is it possible to remove the
/pages/name
So it could just be /Hello
Or /vote
instead of /pages/Hello
/pages/vote

You can rename the 'pages' route with this addon:

http://xenforo.com/community/resources/route-changer.447/

But you can't completely remove it.

 

[Itworx4me]

Jake,
I setup a tab as a link forum and can't get the links template to display below the tab. Any ideas?

Thanks,
Itworx4me

 

[Jake Bunce]

Jake,
I setup a tab as a link forum and can't get the links template to display below the tab. Any ideas?

Thanks,
Itworx4me

The links template option requires you to actually create the template in your style. Did you do that?

 

[Itworx4me]

The links template option requires you to actually create the template in your style. Did you do that?

Yes....I can get it working on all the tabs but not a linked forum tab..

Thanks,
Itworx4me

 

[Jake Bunce]

Yes....I can get it working on all the tabs but not a linked forum tab..

Thanks,
Itworx4me

Then I assume this has to do with tab selection? The row of secondary links is bound to the selected tab. Link-forums don't normally support tab selection, but there is an option for it that works well in many situations (see #1):

http://xenforo.com/community/resources/nodes-as-tabs.9/update?update=1441

 

[Forsaken]

Jake, would it be possible to set a unique menu ID similarly to the Account, Conversations and Alert menu? I'm trying to set columns similar to how the account menu is, and I need to modify the width of the tab added by this addon to do so, but it only used the XenForoUniq# ID.

 

[Jake Bunce]

Jake, would it be possible to set a unique menu ID similarly to the Account, Conversations and Alert menu? I'm trying to set columns similar to how the account menu is, and I need to modify the width of the tab added by this addon to do so, but it only used the XenForoUniq# ID.

All tabs created by this addon have an id of:

nodetab#

Where # is the node_id of the node. You can use that in CSS selectors for custom styling of node tabs. Here is an example:

http://xenforo.com/community/threads/nodes-as-tabs.26687/page-12#post-435085

And please read the few posts after that too. There used to be a bug in the default navigation template, and that bug is still included in many custom styles that people use.