Group Legend Positioning

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
runegirlie
Registered User
Posts: 173
Joined: Sun Jul 31, 2005 6:08 pm

Re: Group Legend Positioning

Post by runegirlie » Thu Jan 24, 2008 2:37 am

Yes, I did :( I even deleted it and re-ran it.

User avatar
CoC
Registered User
Posts: 280
Joined: Tue Jul 18, 2006 11:16 am
Location: Coventry
Contact:

Re: Group Legend Positioning

Post by CoC » Thu Jan 24, 2008 3:51 am

o.k, have you purged the cache?

runegirlie
Registered User
Posts: 173
Joined: Sun Jul 31, 2005 6:08 pm

Re: Group Legend Positioning

Post by runegirlie » Thu Jan 24, 2008 4:04 am

Sure did :) now, this may seem like a silly question as I am new to phpbb3 (but been using phpbb2 for a few years) .. I hand coded all of that. Is there a way to upload it and have my pages automatically modded (like Easy Mod)? Is that what the Modx is for? Maybe if I try that. Anywho, I rolled back and deleted the sql command .. I would really like to install the mod ;)

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: Group Legend Positioning

Post by Gremlinn » Thu Jan 24, 2008 12:21 pm

The modx is a template standard based on XML and reading from a browser. Last I knew, there was no "easymod" for phpBB3. It looks like the sql changes were not applied.

runegirlie
Registered User
Posts: 173
Joined: Sun Jul 31, 2005 6:08 pm

Re: Group Legend Positioning

Post by runegirlie » Thu Jan 24, 2008 1:41 pm

Grem .. thanks for the response :) Sql was done - that is not the problem. I am going to try this again today and see what happens.

runegirlie
Registered User
Posts: 173
Joined: Sun Jul 31, 2005 6:08 pm

Re: Group Legend Positioning

Post by runegirlie » Fri Jan 25, 2008 9:23 pm

EDIT: previous post deleted

It works perfectly .. I was having problems with my SQL database. Flawless install .. no issues whatsoever. Thanks much for the assistance!

Sentzu
Registered User
Posts: 4
Joined: Fri Jan 25, 2008 6:25 pm

Re: Group Legend Positioning

Post by Sentzu » Mon Jan 28, 2008 2:40 am

I hope someone can help me.. this is what I'm getting:

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'group_legend_pos' in 'field list' [1054]

SQL

SELECT group_id, group_name, group_colour, group_type, group_legend_pos FROM phpbb3_groups WHERE group_legend = 1 ORDER BY group_legend_pos ASC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: index.php
LINE: 61
CALL: dbal_mysqli->sql_query()
I noticed this line:

Code: Select all

ALTER TABLE phpbb_groups ADD group_legend_pos SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0';
in the instructions, but had no idea what to do with it... was there something I missed?

User avatar
CoC
Registered User
Posts: 280
Joined: Tue Jul 18, 2006 11:16 am
Location: Coventry
Contact:

Re: Group Legend Positioning

Post by CoC » Mon Jan 28, 2008 4:43 pm

Sentzu wrote:I hope someone can help me.. this is what I'm getting:

I noticed this line:

Code: Select all

ALTER TABLE phpbb_groups ADD group_legend_pos SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0';
in the instructions, but had no idea what to do with it... was there something I missed?
Have a read of this, http://www.phpbb.com/community/viewtopi ... 6&t=588696

Sentzu
Registered User
Posts: 4
Joined: Fri Jan 25, 2008 6:25 pm

Re: Group Legend Positioning

Post by Sentzu » Mon Jan 28, 2008 10:50 pm

Thank you CoC :D

I'm still not quite there yet though...


I was able to get that SQL thing taken care of, and now I no longer get any error messages at all. However, my acp group settings window looks the same as it always has. No mod... I've checked each of the files I need to modify, and redid them one at a time to make sure I wasn't missing anything. Still nothing has changed.

The few things I did that may have been wrong are these:
(only things I did different than the instructions said)

When the SQL command didn't do anything I changed it to:

Code: Select all

ALTER TABLE phpbb3_groups ADD group_legend_pos SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0';
(changed phpbb to phpbb3)

After putting that in, the error message went away when I tried visiting my forums.

Then I got this error when I went to the group settings page on the ACP:

Code: Select all

Parse error: syntax error, unexpected T_STRING in /home/lbarbuto/public_html/forums/includes/acp/acp_groups.php on line 705
Page 5 of this thread had a note on this, so I did what was suggested and went into the acp_groups.php and changed:

Code: Select all

 ORDER BY g.group_type ASC, g.group_legend_pos
to

Code: Select all

 ORDER BY g.group_type ASC, g.group_legend_pos';
( adding the '; )

After that, everything worked again with no error messages, but I don't see anything different... no mod.

- Any suggestions on what I may be missing?
This is my only mod on this forum, I have never changed anything in the affected files before.

Thanks a lot in advance... :)

ibelphegor
Registered User
Posts: 453
Joined: Wed Oct 24, 2007 8:37 am

Re: Group Legend Positioning

Post by ibelphegor » Tue Jan 29, 2008 2:50 am

Thanks for the mod.
How can i add ORDER to ranks page? ;

Code: Select all

<?php
/**
*
* @package phpBB3
* @version $Id: ranks.php,v 1.0 2007/02/01 22:28:42 Nicolas Fraga Exp $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
* @ignore
*/
define('IN_PHPBB', true);
$phpbb_root_path = './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup('mods/ranks');

$sql = 'SELECT *
	FROM ' . RANKS_TABLE . '
	ORDER BY rank_min ASC, rank_special ASC, rank_title ASC';
$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))
{
	$template->assign_block_vars('ranks', array(
		'S_RANK_IMAGE'		=> ($row['rank_image']) ? true : false,
		'S_SPECIAL_RANK'	=> ($row['rank_special']) ? true : false,
		'RANK_IMAGE'		=> $phpbb_root_path . $config['ranks_path'] . '/' . $row['rank_image'],
		'RANK_TITLE'		=> $row['rank_title'],
		'MIN_POSTS'			=> $row['rank_min'])
	);
}

$db->sql_freeresult($result);

$r_title = $user->lang['BR_RANKS_PAGE_TITLE'];
$template->assign_vars(array(
	'L_BR_RANKS_IMAGE'		=> $user->lang['BR_RANKS_IMAGE'],
	'L_BR_RANKS_TITLE'		=> $user->lang['BR_RANKS_TITLE'],
	'L_BR_RANKS_MINIMUM'	=> $user->lang['BR_RANKS_MINIMUM'],
	'L_BR_RANKS_PAGE_TITLE'	=> $user->lang['BR_RANKS_PAGE_TITLE'],
	'L_BACK_TO_TOP'			=> $user->lang['BACK_TO_TOP'])
);

page_header($r_title);

$template->set_filenames(array(
	'body' => 'ranks_body.html')
);

page_footer();

?>
Regards,
uzi.

Cawkroach
Registered User
Posts: 9
Joined: Thu Jan 31, 2008 5:05 am

Re: Group Legend Positioning

Post by Cawkroach » Thu Jan 31, 2008 6:53 am

I have altered MySQL.

'ALTER TABLE phpbb_groups ADD group_legend_pos SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0';'

so considering I've done this and I believe I have followed the installing instructions correctly.

But my mod doesn't appear anywhere to be found??

like it doesn't show up in my "manage usergroup section" I have no option to edit the legend.
what could be the problem?

User avatar
CoC
Registered User
Posts: 280
Joined: Tue Jul 18, 2006 11:16 am
Location: Coventry
Contact:

Re: Group Legend Positioning

Post by CoC » Thu Jan 31, 2008 4:43 pm

ibelphegor wrote:Thanks for the mod.
How can i add ORDER to ranks page? ;

Regards,
uzi.
Don't know ranks.php is not part of the phpBB file structure.
Cawkroach wrote:But my mod doesn't appear anywhere to be found??

like it doesn't show up in my "manage usergroup section" I have no option to edit the legend.
what could be the problem?
You will find the option in USERS AND GROUPS -> Manage Groups -> Settings -> Group Legend Position.

If you're not seeing it purge the cache.

Sentzu
Registered User
Posts: 4
Joined: Fri Jan 25, 2008 6:25 pm

Re: Group Legend Positioning

Post by Sentzu » Thu Jan 31, 2008 7:11 pm

Thanks, that did it :D

Cawkroach
Registered User
Posts: 9
Joined: Thu Jan 31, 2008 5:05 am

Re: Group Legend Positioning

Post by Cawkroach » Thu Jan 31, 2008 7:33 pm

ahh thank you... it seems as though I just jumped to conclusions rather than thoroughly thinking.

=/ I feel like an idiot.

hah but thanks very much works perfectly.

User avatar
RATT
Registered User
Posts: 734
Joined: Fri Aug 19, 2005 6:27 am

Re: Group Legend Positioning

Post by RATT » Sun Feb 17, 2008 3:14 pm

Great Mod, Works great! thanks :)

Locked

Return to “[3.0.x] MOD Database Releases”