[2.0.6] Custom Title MOD

The cleanup is complete. This forum is now read only.
Post Reply
AbelaJohnB
Former Team Member
Posts: 5674
Joined: Fri Jul 06, 2001 11:56 pm

[2.0.6] Custom Title MOD

Post by AbelaJohnB »

MOD Name: Custom Title MOD
Author: Aexoden
MOD Description: Adds a custom title/rank field to a user's profile. Admin-configurable.

MOD Version: 1.0.2a


Download File: custom_title_1-0-2a.zip
File Size: 16532 Bytes
Last edited by AbelaJohnB on Mon Apr 30, 2007 12:30 am, edited 4 times in total.
AbelaJohnB
Former Team Member
Posts: 5674
Joined: Fri Jul 06, 2001 11:56 pm

Post by AbelaJohnB »

MOD Validated/Released :mrgreen:

Personal Notes:
This impressed the MOD Validators, so I'm sure this sucker rocks!
mm3guy
Registered User
Posts: 197
Joined: Tue Oct 14, 2003 8:13 pm

Post by mm3guy »

PCP Compatible?
Diskmaster
Registered User
Posts: 105
Joined: Mon Jun 09, 2003 3:57 pm
Contact:

Post by Diskmaster »

Are there any code changes between 1.0.2 and 1.0.2a, or is this just a repackage of 1.0.2?
Murphy's Law is recursive.
Aexoden
Registered User
Posts: 364
Joined: Mon Jan 14, 2002 1:18 am
Location: Medical Lake, WA
Name: Jason Lynch
Contact:

Post by Aexoden »

It's a repackaging for the database after I messed up the initial packaging. I silently upgraded the version on my site at the time, since it was only a packaging issue.
User avatar
drumstix42
Registered User
Posts: 1100
Joined: Tue Sep 24, 2002 11:01 pm
Location: NJ
Contact:

Post by drumstix42 »

*whew* ;)
Need a phpBB update or mod installed? PM me for any questions and pricing!
HostMonster.com (Unlimited Space, Unlimited Transfer, Unlimited Domains, $6.95/month )
Diskmaster
Registered User
Posts: 105
Joined: Mon Jun 09, 2003 3:57 pm
Contact:

Post by Diskmaster »

Aexoden wrote: It's a repackaging for the database after I messed up the initial packaging. I silently upgraded the version on my site at the time, since it was only a packaging issue.


Sweet. Now if only there was a way to intergrate this with the PCP...
Murphy's Law is recursive.
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34459
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut »

Are there any major changes from 1.0.0 to 1.0.2?
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
Aexoden
Registered User
Posts: 364
Joined: Mon Jan 14, 2002 1:18 am
Location: Medical Lake, WA
Name: Jason Lynch
Contact:

Post by Aexoden »

A_Jelly_Doughnut wrote: Are there any major changes from 1.0.0 to 1.0.2?

One line has changed, and it corrects bugs involving limiting access by days. The patch is on my site listed as activate_by_days.txt.
rascott
Registered User
Posts: 50
Joined: Wed Oct 22, 2003 8:09 am
Location: oklahoma
Contact:

Post by rascott »

Progress :: . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Duplicate column name 'user_custom_title'
SQL :: ALTER TABLE phpbb_users ADD COLUMN user_custom_title varchar(255) NULL, ADD COLUMN user_custom_title_status tinyint(1) default '0' not null


An error occured.

Updating data
Progress :: .... Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Duplicate entry 'custom_title_days' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_title_days', 0)


Error :: Duplicate entry 'custom_title_posts' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_title_posts', 0)


Error :: Duplicate entry 'custom_title_mode' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_title_mode', 0)


Error :: Duplicate entry 'custom_title_maxlength' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('custom_title_maxlength', 45)


An error occured. Please PM Aexoden with the details of the error.



this is what i got when i ran the title install.php
i have no idea exactly what all this means
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34459
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Post by A_Jelly_Doughnut »

That error probably means that you installed Custom Title MOD previously, and it should work.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
rascott
Registered User
Posts: 50
Joined: Wed Oct 22, 2003 8:09 am
Location: oklahoma
Contact:

Post by rascott »

it doesnt work, thats the problem
User avatar
drumstix42
Registered User
Posts: 1100
Joined: Tue Sep 24, 2002 11:01 pm
Location: NJ
Contact:

Post by drumstix42 »

Then the error is somewhere in your code. Recheck all your work, going over the install file again.

Just ignore the SQL step, if it's saying Duplicated Entry, than the SQL stuff is already in, like said.
Need a phpBB update or mod installed? PM me for any questions and pricing!
HostMonster.com (Unlimited Space, Unlimited Transfer, Unlimited Domains, $6.95/month )
The Other Guy
Registered User
Posts: 33
Joined: Mon Mar 24, 2003 3:55 am
Location: Here
Contact:

Post by The Other Guy »

First, I got an error saying my custom title was too long (even with one letter!)

Then, when I left it blank, I go this error:

Code: Select all

Could not update users table

DEBUG MODE

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

UPDATE phpbb_users SET user_email = '[email protected]', user_icq = '', user_website = 'http://www.dotmanandbob.com', user_occ = 'Web Designer, Comic Artist', user_from = 'I am where I am and that''s where I am.', user_interests = 'Guess', user_custom_title = '', user_sig = '[size=10:ec8eb1bda4]I need no signature for you! Okay, okay, this is my signature: Go to [url]http://www.dotmanandbob.com[/url][/size:ec8eb1bda4]', user_sig_bbcode_uid = 'ec8eb1bda4', user_viewemail = 1, user_aim = 'TheOtherGuy444', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 0, user_timezone = -8, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 483
File : /usr/local/4admin/apache/vhosts/dotmanandbob.com/httpdocs/forums/includes/usercp_register.php
Er... yeah.
rascott
Registered User
Posts: 50
Joined: Wed Oct 22, 2003 8:09 am
Location: oklahoma
Contact:

Post by rascott »

drumstix42 wrote: Then the error is somewhere in your code. Recheck all your work, going over the install file again.

Just ignore the SQL step, if it's saying Duplicated Entry, than the SQL stuff is already in, like said.



templates/subBlack3d/viewtopic_body.tpl

in that file i could not find <span class="postdetails">

however, <span class=postdetails> was there. not a programmer so im not sure what the apostrophes signify. i went ahead and threw em in tho.

think im just gonna start from scratch again
Post Reply

Return to “[2.0.x] MOD Database Cleanup”