[ALPHA] Ranksystem Extension

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

[ALPHA] Ranksystem Extension

Post by GameZelda »

NOTE: This mod is NOT related whit Extended Rank System
Hello everyone,

I will post my MOD: Ranksystem Extension.

Features:
:arrow: Rank by gender: Admin can configure diferent rank titles and images for gender. Requires Gender MOD by Niels. 100%
:arrow: Rank color: Admin can configure rank color in Admin CP. 100%
:arrow: Ban rank: You can assign a rank automaticaly to banned users. 90% (Remains the ban for IP).
:arrow: No querys in viewtopic and profile.

Supported DB Types:

:arrow: MySQL/MySQL4 (Tested)
:arrow: PostgreSQL (Tested)

Posible new features:
:arrow: rank colors in admin list -> Selected
:arrow: Request one :wink:


Download link:
http://nukezelda.shinranet.com/yugiohmo ... d.php?id=1

Screenshots:

Image
Image
Image
Last edited by GameZelda on Thu Jan 05, 2006 5:29 pm, edited 15 times in total.
Sorry 4 bad english
User avatar
smithy_dll
Former Team Member
Posts: 7630
Joined: Tue Jan 08, 2002 6:27 am
Location: Australia
Name: Lachlan Smith
Contact:

Post by smithy_dll »

Hello,

Could you please edit your topic title with a prefix as outlined in MOD Development forum rules section 3.a. This will allow people to see the development status of your MOD at a glance.

Thank you,
The phpBB MOD Team
Systems Engineering
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

Ok, i will add now :D .

Now I will post the first release and screenshots
Sorry 4 bad english
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

I'm packing the next version :D
Sorry 4 bad english
arkange_17
Registered User
Posts: 44
Joined: Sun Aug 15, 2004 5:02 pm
Location: La rochelle
Contact:

Post by arkange_17 »

Greats mods ! :)


i'm waiting for a stable/next version :wink:
[ Liandli ] : forum Libre et Libéré
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

Updated attachment
Sorry 4 bad english
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

I am working in rank colors, i have writed the function, whit a little changes, this function will be implemented. my objective is set a diferent rank color for style.
Sorry 4 bad english
User avatar
bonelifer
Community Team Member
Community Team Member
Posts: 3511
Joined: Wed Oct 27, 2004 11:35 pm
Name: William
Contact:

Post by bonelifer »

Please update your attachment permissions for that forum so that Guest can download.
Knowledge Base | phpBB Board Rules | Search Customisation Database
Image
Please don't contact me via PM or email for phpBB support .
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

Alot of sorry... updated for guests and registered... :oops:
Sorry 4 bad english
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

Attachment updated. Version 0.30 Posted. Rank colors added. DB Installer added . DB Support only for MySQL, PostgreSQL and MSSQL (Not tested).
Sorry 4 bad english
User avatar
bonelifer
Community Team Member
Community Team Member
Posts: 3511
Joined: Wed Oct 27, 2004 11:35 pm
Name: William
Contact:

Post by bonelifer »

ERROR:

Code: Select all

Couldn't update rank_1

DEBUG MODE

SQL Error : 1054 Unknown column 'rank_1' in 'field list'

UPDATE phpbb_themes SET rank_1 = 'FFA34F' WHERE themes_id = 1

Line : 138
File : admin_ranks_colors.php
I had to use this SQL statement to add the rank_1:

Code: Select all

ALTER TABLE `phpbb_themes` ADD `rank_1` VARCHAR( 25 ) NOT NULL ;
UPDATE: I now notice that the rank_# is created when you create the RANK. You should put in something to take into account many people already have "Site Admin" and it should be "upgraded" when you install the mod.
Last edited by bonelifer on Mon Oct 10, 2005 3:24 am, edited 1 time in total.
Knowledge Base | phpBB Board Rules | Search Customisation Database
Image
Please don't contact me via PM or email for phpBB support .
k10magic
Registered User
Posts: 314
Joined: Thu Mar 20, 2003 11:38 pm
Location: Canada

Post by k10magic »

Does this work with PCP?
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

bonelifer wrote: ERROR:

Code: Select all

Couldn't update rank_1

DEBUG MODE

SQL Error : 1054 Unknown column 'rank_1' in 'field list'

UPDATE phpbb_themes SET rank_1 = 'FFA34F' WHERE themes_id = 1

Line : 138
File : admin_ranks_colors.php
I had to use this SQL statement to add the rank_1:

Code: Select all

ALTER TABLE `phpbb_themes` ADD `rank_1` VARCHAR( 25 ) NOT NULL ;
UPDATE: I now notice that the rank_# is created when you create the RANK. You should put in something to take into account many people already have "Site Admin" and it should be "upgraded" when you install the mod.


In the versions next to 0.30, you have an installer that automaticaly adds rank_* to themes table.

Code: Select all

#
#-----[ DIY INSTRUCTIONS ]------------------------------------------
# 
Run the DB installer (install/install.php) or realize this querys and delete alll ranks (you will get a sql error foreach rank)
ALTER TABLE `phpbb_ranks` ADD `rank_title_male` VARCHAR( 50 ) NOT NULL AFTER `rank_title` ;
ALTER TABLE `phpbb_ranks` ADD `rank_title_female` VARCHAR( 50 ) NOT NULL AFTER `rank_title_male` ;
ALTER TABLE `phpbb_ranks` ADD `rank_image_male` VARCHAR( 255 ) AFTER `rank_image` ;
ALTER TABLE `phpbb_ranks` ADD `rank_image_female` VARCHAR( 255 ) AFTER `rank_image_male` ;
I recomend to upgrade to 0.32:

0.30 => 0.31

Code: Select all

Copy all files of root dir
0.31 => 0.32

Code: Select all

Copy all files of root dir.

OPEN ADMIN_RANKS.PHP

FIND:

		// In the up query, rank_id is not defined. Now we will

BEFORE ADD:

		if (!$rank_id)
		{

FIND:

				message_die(GENERAL_ERROR, "Couldn't insert color column into themes table", "", __LINE__, __FILE__, $sql);

AFTER ADD:

			}


------------------------------------------------

I think that it isn't PCP compatible, because PCP includes rank by gender. I posibly create an adaptation after approved by MODDB ( :roll: )
Sorry 4 bad english
lms_X
Registered User
Posts: 18
Joined: Tue Mar 01, 2005 10:46 pm

Post by lms_X »

could yo make it compatible with extended ranks system?, so this will be the nicest addon.

Also some version for groups or related.
GameZelda
Registered User
Posts: 32
Joined: Fri Apr 29, 2005 5:18 pm

Post by GameZelda »

lms_X wrote: could yo make it compatible with extended ranks system?, so this will be the nicest addon.

Also some version for groups or related.


I will try to adapt this MOD. Extended rank system already includes trank by gender, i will try to adapt color :D
Sorry 4 bad english
Post Reply

Return to “[2.0.x] MODs in Development”