vb.org Archive - Forum Display Enhancements - Colors For Usergroup In Forum Last Post

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Forum Display Enhancements - Colors For Usergroup In Forum Last Post (https://vborg.vbsupport.ru/showthread.php?t=218773)

Quote:

Originally Posted by inciarco (Post 1879689)

Seems to me like something happened on the Installing Process of the Mod that Affects vBulletin, and All I'm Asking from the Author and from the vBulletin Moderators and Gurus is a Process to Correct whatever this Mod Caused on my Board, on Stangger5's Board, and on Anyone else's Board.

I'm 100% Sure that Was This Mod, and It BROKE my Test Forum Too where I Installed it First with the Exact same Problem that Later Happened on my Real Forum, because I only Installed this mod a little after 3:09PM, and

Take a Look:

(pmtextid 9814) - Bienvenido a MY FORUM NAME - from administracion - 01-Sep-2009 12:29 PM

(pmtextid 9819) - Bienvenido a - from administracion - 01-Sep-2009 03:52 PM
(Missing FORUM NAME on PM)

I downloaded the Mod at 3:09PM and Immediatelly Installed on my Test Board, when I saw the ForumHome Result I Installed on my Real Board, but the Consequences that I Described that were Caused by THIS MOD I noticed only when I Tested the Registration Process on a Mod that I'm Testing since Yesterday, (but the Problem on Displaying the Username on the Welcome Back Login Message I noticed since September 02 but I thought that was other Mod and since Stangger5's Post I KNOW that was caused by THIS MOD).

I don't want to Condemn the Author, I Just Want a Solution to the Problem that THIS MOD caused on My Board, Stangger5's Board, and perhaps in the Future other Users will Report this same Problems on their Boards.

A vBulletin Problem Triggered by something on the Installation Process? Perhaps a Problem on the Installation Process under Unknow Circumstances? Something on the Forum Table Alter? Something on the Filling of that Table? Something on the Work of the Plugins? I DON'T KNOW, I just know that this Mod Triggered Those Problems, and I Hope the vBulletin Moderators, Gurus, that Perhaps Experienced this Same Problem and Got it Solved could Point Us into the Solution.

By the Way, that's the Reason I Posted a Thread on the Community Forum, to ASK FOR HELP to Any Webmaster and Guru that Know How to Solve this HUGE PROBLEM.

My Best Regards and Hopes For a Solution.

What Should I Do? What Should I Check? Is There a Table on the DataBase that Controls those Variables? What Processes on the DataBase Control those Variables and the Use of them on the Routines could've been Damaged and How Can they be Repaired?

:(

Yes - I read many times that you are sure that this mod causing the problems. Also read that after dissabling this mod problem still occures, that's why I don't believe it is this mod cause.

I read rest of discussion - new idea appears that this mod is crashing phrases (probably during installation proces). Just look inside of product file - this mod even is not using phrases. Not at all... Also look on instalation code - it uses only 'forum' table - nothing more.

This mod has nothing common with phrases.

I read that you are 100% sure that this mod is guilty. I'm not at all, but I'm willing to check it. Since everything is working well on my forum I cannot reproduce the issue. Someone wrote that he is 100% sure, because he put it on test forum and then issue appears. Please give me access to such test forum, before this mod installation. I will install it myself and see what is happening :)

If this mod is cause of your problems, I will be really glad to help you guys - just let me help you :)

Quote:

Originally Posted by inciarco (Post 1880109)

I Confirm the "Phrasetype" Table Losses:

I Confirm that the Phrases that don't Contain a Value in the "product" Column are Being Deleted. :eek:

In my Backup Copy of my Board Before Installing this Mod I had 104 Registers (9.1 Kb) in the phrasetype table, and Now I have 44 Registers (4.1 Kb). :eek:

If I get this Table Right it mentiones the Names of Phrases of other Installed Products (in the product column), so it should be causing Anomalies in other Product Variables not being included in some Places, is that right? :confused:

Is there a way to Fix it? :confused: (besides Restoring an Old Backup and Losing All Changes made during that Period :()

My Best Regards.

:)

If you have backup and only phrases are wrong - just restore phrases table. Best way - inserting with ignoring changes if key already exists - this way you will put all your old phrases and keep all new phrases if you have such.

Quote:

Originally Posted by NLP-er (Post 1880293)

Thank You for your Reply NLP-er. :up:

Stangger5 told me that he was able to Restore that Table, it'd be nice that he can Share with us the Process in this Thread; I'll replicate the Solution in the other Thread I Created on the Community Forum so that it can be Useful to other Webmasters with the same Problem.

My Best Regards.

:)

if you take out the:

Code:

require_once(DIR . '/global.php');

from the <installcode>,,,everything works fine...

The phrasetype table isnt altered with that taken out...

Stangger5, How did You Restore the Registers in the "Phrasetype" Table? :confused:

What are the Steps to do that? :confused:

It'd be nice if a Moderator could tell us why does that Code Line Affects the Install Process and Causes that Data Loss in that Particular Table (perhaps in some Boards or maybe in All of them if other Users confirm the Data Loss in the "Phrasetype" Table)? :confused:

My Best Regards.

:)

Quote:

Originally Posted by inciarco (Post 1880427)

Stangger5, How did You Restore the Registers in the "Phrasetype" Table? :confused:

What are the Steps to do that? :confused:

:)

I had an older backup..
I found the missing tables and added them back one by one..
Some tables was still there,,I just had to edit the default settings back..

Quote:

Originally Posted by stangger5 (Post 1880409)

if you take out the:

Code:

require_once(DIR . '/global.php');

from the <installcode>,,,everything works fine...

The phrasetype table isnt altered with that taken out...

global.php is native vB file and it crashes vB :eek:
Which version of VB are you using? This is vB bug - maybe it should be noticed to vB stuff... assuming that it is not corrected yet. I'm using vb 3.8.2 and it is ok.

Since like most users I never had this issue, I trust your work and want to thank you :)

1.0.1 is already released correcting this issue (without including global.php). There is no need to update. Change was made only in installation section. It is for future users.

Nice Mod installed and work fine, can you modify the Mod that he works in last post in the forums?

i mean color the nicknames in the forumdisplay from the forums.

sorry for bad english

Raiden

Quote:

Originally Posted by Lord Raiden (Post 1882832)

Nice Mod installed and work fine, can you modify the Mod that he works in last post in the forums?

i mean color the nicknames in the forumdisplay from the forums.

sorry for bad english

Raiden

There is already other mod which colors everything without last forum post. My make the rest ;) So use booth :)

Working good for 3.8.4, thank you.

Very Useful, thank you! ^^

Quote:

Originally Posted by NLP-er (Post 1883074)

There is already other mod which colors everything without last forum post. My make the rest ;) So use booth :)

Hmm, can you tell me the link to the mod ?

Quote:

Originally Posted by Lord Raiden (Post 1888804)

Hmm, can you tell me the link to the mod ?

It should be somewhere here in this discussion :)

If I uninstall this product I've a Database Error message on my forum.

Edit:

This error

Code:

Database error in vBulletin 3.8.4:



Invalid SQL:



                                SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid, lastposter_displaygroupid

                                        

                                FROM forum AS forum;



MySQL Error   : Unknown column 'lastposter_displaygroupid' in 'field list'

Error Number  : 1054

Request Date  : Thursday, October 1st 2009 @ 01:49:09 PM

Error Date    : Thursday, October 1st 2009 @ 01:49:10 PM

Script        : http://www.mydomain.ext

Referrer      : http://www.mydomain.ext

IP Address    : XXX.XXX.XXX.XXX

Username      : br3

Classname     : vB_Database

MySQL Version : 5.0.82sp1-log

Solved.

Go to PhpMyAdmin>SQL and write:

Code:

ALTER TABLE forum ADD COLUMN lastposter_displaygroupid smallint(5);

Quote:

Originally Posted by cionfs (Post 1893225)

If I uninstall this product I've a Database Error message on my forum.

Edit:

This error

Code:

Database error in vBulletin 3.8.4:



Invalid SQL:



                                SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid, lastposter_displaygroupid

                                        

                                FROM forum AS forum;



MySQL Error   : Unknown column 'lastposter_displaygroupid' in 'field list'

Error Number  : 1054

Request Date  : Thursday, October 1st 2009 @ 01:49:09 PM

Error Date    : Thursday, October 1st 2009 @ 01:49:10 PM

Script        : http://www.mydomain.ext

Referrer      : http://www.mydomain.ext

IP Address    : XXX.XXX.XXX.XXX

Username      : br3

Classname     : vB_Database

MySQL Version : 5.0.82sp1-log

Solved.

Go to PhpMyAdmin>SQL and write:

Code:

ALTER TABLE forum ADD COLUMN lastposter_displaygroupid smallint(5);

It is not a good solution - but still it works :) Mod is cleaning DB changes during uninstall. Usage of this column is added by mod plugin (Update cache) so if mod is uninstalled then vB should delete all plugins for it and what you are describing shouldn't ever happen. If it does - for me it means some vB bug.

Hello,

I've installed this modification and it has been running great for a while, and it still does but I would like to report a problem.

If I change the color of an usergroup or change someone's usergroup if that person was in any of the last posts his name color wont change.. I had to unistall and re-install the mod so the changes I made to my usergroups could be shown.

Thats all, I hope you can fix this.

Thanks NPL-er and working 3.8.1 Version....

Quote:

Originally Posted by Lautaro (Post 1894098)

Yes - I'm aware of this issue. It stays in old way since it is cached. And when you change usergroup for someone, or color of usergroup it doesn't affect the cache. I didn't care about it before because it is usually short termed - when someone writes anything new then cache will be populated with actual data - even it it is same guy who previously stays in old fashion style.

I put it in my TODO list, but it has low priority for me - will be fixed when I find time for it.

Till then you can just relax - you don't have to uninstall and install it again - all what is needed it is wait till new post occurs for specific forum :) Mostly people don't have enough time to see it. And even if do - it is harmless :)

Quote:

Originally Posted by RedHacker (Post 1894196)

Thanks NPL-er and working 3.8.1 Version....

Thanks for letting know :)

I find one problem... If one user change usergroup not change the color in last post of threads....

Quote:

Originally Posted by RedHacker (Post 1898957)

I find one problem... If one user change usergroup not change the color in last post of threads....

https://vborg.vbsupport.ru/showpost....&postcount=139

Thanks for the hack, very nice. I wish the update to include usergroup colors as well in the search results page will be included soon, that's the only thing missing now.

To work globally would be the winner but I bet that will be hard to make.

Quote:

Originally Posted by Charlie98902 (Post 1909941)

To work globally would be the winner but I bet that will be hard to make.

Not really :P I'm playing with usernames in many places working on translation mod to not translate usernames (this is the mod: http://www.vbenterprisetranslator.co...lator-2-x.html).

So it will be very easy for me to use this experience in this one. I just have to focus first on bigger mod - vBET. Then on my tagger (https://vborg.vbsupport.ru/showthread.php?t=218350). And then I can add new possibilities to this one :)

It will not be hard, just need some time, cause each place where username is displayed have to be handled individually. So global working means here - handle all occurrences ;)

Thanks Xd.............

Can update to the vBulletin 4.....?

where do i upload this?

does this work for VB 4.X ?

Hi

Confirmed on Vb 3.8.5

Thx for

excellent...thanx :D

Any one using it on 3.8.7 PL2 ? Thanks

Quote:

Originally Posted by newguy (Post 2232862)

Any one using it on 3.8.7 PL2 ? Thanks

Works like a charm :D

using this with vbseo makes te homepage urls go to 0.html.

Quote:

Originally Posted by MentaL (Post 2232987)

using this with vbseo makes te homepage urls go to 0.html.

Really? That is no good for me

Some option for vbulletin 4.1.7 ?

Nice touch! Thank you! :)

Dont work for me (VB 3.8.2)

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02226 seconds Memory Usage 1,840KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (15)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: