Group Legend Positioning

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

Yes, I did

I even deleted it and re-ran it.

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

o.k, have you purged the cache?

runegirlie · 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

Gremlinn · 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 · 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 · 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 · 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?

CoC · 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 · Post by **Sentzu** » Mon Jan 28, 2008 10:50 pm

Thank you CoC

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 · 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 · 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?

CoC · 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 · Post by **Sentzu** » Thu Jan 31, 2008 7:11 pm

Thanks, that did it

Cawkroach · 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.

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

Great Mod, Works great! thanks