[3.0.7] Extra Ranks Mod 1.1.0

[ddaddy]

Also, has anyone installed this on subsilver2 style?

[Zohall MeisaM]

it seems we not cant to add extra rank on groups

[ddaddy]

I can confirm I now have this working on 3.0.8 and on subsilver2 :-)

What i'd really like to do, is have the Paypal Mod change rank2 instead of the group.
This is the code from Paypal Mod that changes the group

Code: Select all

group_user_add($config['paypal_supporters_group_id'], array($this->sender_data['user_id']), array($this->sender_data['username']), $config['paypal_supporters_group'], false);


Any idea what I can change this to, or add to it, so it changes rank2 from this mod to a set rank?

Thanks

[khaosxthoery44]

Code: Select all

SQL ERROR [ mysql4 ]

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

SQL

UPDATE phpbb_users SET user_rank = 1, user_rank2 = 0, user_rank3 = 0, user_rank4 = 0 WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/acp/acp_users.php
LINE: 1785
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Please can someone explain how I fix this (in simple terms)

OK guys

FIXED The issue - for anyone that is interested user_rank was missing so I basically created it in phpmyadmin and now all is great.
Awesome mod bro thanks.

[khaosxthoery44]

My only thing about this is on

The view profile all the ranks are there BUT rank three has no title.

EG.

1.Site admin
2.Moderator
3.
4.Donator

3 is blank can someone help please

[Element_Five]

Is it possible to get a guide also for subsilver2? Because the style files do not look the same.

[Knight Rider Paul]

I've installed this MOD on my Board, and then tried to uninstall it, with the error it can't drop the tables.
So, I forced the uninstall, because I no longer want it on the board.
However, I'm not the owner of the domain. I just manage the forum.
When trying to update a user's rank, I get the following error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

UPDATE phpbb_users SET user_rank = 9, user_rank2 = 0, user_rank3 = 0, user_rank4 = 0 WHERE user_id = 54

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_users.php
LINE: 1897
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_users->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

When trying to view The Team, I get:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'u.user_rank' in 'field list' [1054]

SQL

SELECT u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id FROM (phpbb_users u CROSS JOIN phpbb_groups g) LEFT JOIN phpbb_user_group ug ON (ug.group_id = g.group_id AND ug.user_pending = 0 AND ug.user_id = 54) WHERE u.user_id IN (2, 54, 55, 56) AND u.group_id = g.group_id ORDER BY g.group_name ASC, u.username_clean ASC

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/memberlist.php
LINE: 171
CALL: dbal_mysql->sql_query()

This is urgent. Any thoughts?

[Sniper_E]

Do you have access to the database? It looks like it's missing the user_rank field.
The phpbb_users table has the user_rank field and this mod adds three more user_rank2,3,4 to it.
I don't see how the uninstall could take those fields out.

When you have to do a force uninstall then that means it could not find the lines in the template to take out.
That means you have to open those edited templates and manually remove the edits that were put in there.
Or you have to manually make those edits to install it.

Was the sql ran to add those extra fields to the phpbb_users table? They can stay there if so.
Uninstalling the mod from the files would be enough to remove it. Yet it wasn't completely removed.
Can you open the install file/directions and manually un-edit those files and templates?

Before you clicked the force uninstall, it showed the the files it could not edit.
You need that list of files or you have to check all 12 of them.

[Knight Rider Paul]

I've looked at an exported version of the database on my localhost server, and have seen the user_rank 2,3, and 4.
I don't have online access, as I don't own the domain.
I'm just the forum administrator.
I did export the database, and can view it on my localhost server on my PC.

I've viewed the install.xml file, and it's a jumbled mess of code, that is very difficult to read.

[Sniper_E]

You open the Extra ranks mod 1.1.0/install_mod.xml with your web browser and it will be readable.
If you can't edit the files and upload them then you can not fix this.