vb.org Archive - Add-On Releases - Spiders Display on Forumhome and Who's Online for vb4

Page 8 of 12

Show 40 post(s) from this thread on one page

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Add-On Releases - Spiders Display on Forumhome and Who's Online for vb4 (https://vborg.vbsupport.ru/showthread.php?t=243460)

Boofo

12-10-2011 03:46 PM

The only way to find out for sure is to disable the mods around that, then install this mod. and enable them one by one to see which one is affecting it.

Maybe try reverting the template which hides the what's going on and see if that does it. Changing the plugin activation order might also fix it. But I can say for sure that this mod is not the one misbehaving.

spillage

12-13-2011 11:25 PM

Let me add an extra thank you, Boofo.
The combination of this mod, and Ban Spiders by User Agent, has allowed me to weed out all the undesirables, and retain those that are useful.

Philster

12-13-2011 11:51 PM

Thanks Boofo, keep up the great work!

Delfi_r

12-14-2011 10:35 PM

Installed fine and working on my production site

Now I have to decide if the spiders should get any color set for them

Boofo

12-14-2011 10:46 PM

Quote:

Originally Posted by Delfi_r (Post 2277843)

Installed fine and working on my production site

Now I have to decide if the spiders should get any color set for them

Than link does not work for guests.

If you install my "Usergroup Legend on Forumhome" mod, it will display the word "Spiders" in the legend, also.

OldSchoolDSL

12-14-2011 11:54 PM

Can you please tell me what tables does this add to the database?

Boofo

12-14-2011 11:59 PM

None. It has nothing to do with your tempate edited issue. You should know my mods better than that.

OldSchoolDSL

12-15-2011 12:00 AM

Quote:

Originally Posted by Boofo (Post 2277866)

None. It has nothing to do with your tempate edited issue.

How would one manually uninstall this through phpmyadmin ?

Boofo

12-15-2011 12:13 AM

You can't uninstall this through myphpadmin. It makes no entries into the db at all. It only reads what is already there. What is your problem? If you don't want to use it, uninstall it through the product manager.

Boofo

12-15-2011 12:16 AM

Did you really think adding over 200 mods wasn't going to cause you headaches somewhere along the line? That borders on the ridiculous.

OldSchoolDSL

12-15-2011 12:20 AM

Quote:

Originally Posted by Boofo (Post 2277870)

OK.... What I know is I mistakenly turned this on, when it was originally disabled. Kind of got mixed up between tabs... test install and live site.

Upon activating this modification I got the following

Warning: mysqli_query(): (42S22/1054): Unknown column 'language.phrasegroup_global' in 'field list' in [path]/includes/class_core.php on line 1395

The e-mail I get tells me this

Code:

Invalid SQL:



                                       SELECT languageid,

                       phrasegroup_global AS phrasegroup_global,

                       phrasegroup_vbcms AS phrasegroup_vbcms,

                       phrasegroupinfo AS lang_phrasegroupinfo,

                       options AS lang_options,

                       languagecode AS lang_code,

                       charset AS lang_charset,

                       locale AS lang_locale,

                       imagesoverride AS lang_imagesoverride,

                       dateoverride AS lang_dateoverride,

                       timeoverride AS lang_timeoverride,

                       registereddateoverride AS lang_registereddateoverride,

                       calformat1override AS lang_calformat1override,

                       calformat2override AS lang_calformat2override,

                       logdateoverride AS lang_logdateoverride,

                       decimalsep AS lang_decimalsep,

                       thousandsep AS lang_thousandsep

                                       FROM language

                                       WHERE languageid = 1;



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

Error Number  : 1054

So yes, I was hoping there was a way to disable this... Since I can not even access my AdminCP at this time.

I didn't mean any disrespect in my inquire and do not understand your "anger" toward my inquire.

Boofo

12-15-2011 12:25 AM

My anger comes from the fact that there is no way on earth that this mod is causing anything near what you are experiencing. You have a rogue mod acting up and it will act up later on when you change or install another mod that that causes it to blow up again. You need to find what mod is originally causing that and stop blaming mods that can in no way be the trouble spot.

Boofo

12-15-2011 12:29 AM

My advice to you is to look through your mods (you should have them backed up on your HD) and see which ones are for the forum home that write to the db and check those out.

OldSchoolDSL

12-15-2011 12:29 AM

Quote:

Originally Posted by Boofo (Post 2277874)

Again, the only person who I asked help from was you.... This 1x.... If you don't want people asking questions about possible conflicts.... Simply do not submit future modifications.

There is no reason for your hostility.

Boofo

12-15-2011 12:31 AM

Do you see the "Not Supported" in the first post? This is exactly why that has been added to my mods. Blaming a mod for problems that it in no way can be a part of does not bode well for coders wanting to write and support mods.

HMBeaty

12-15-2011 12:31 AM

To sum it all up, and again say that this mod is not causing the issue that you're having, the ONLY query this modification executes is this:

Code:

    $spiders = $db->query_read("

        SELECT useragent

        FROM " . TABLE_PREFIX . "session

        WHERE lastactivity > " . intval($datecut) . "

            AND userid = 0

    ");

Nothing about phrasegroup, or language, or anything. It selects from the table session the users useragent. Basically the same as if you were to view the Who's Online page. It reads what's already there, and prints it out on your who's online.

Boofo

12-15-2011 12:32 AM

And does NOT write, or add, anything to the db, hence the "db->query_read".

TheLastSuperman

12-15-2011 03:15 AM

Quote:

Originally Posted by OldSchoolDSL (Post 2277873)

Code:

Invalid SQL:



                                       SELECT languageid,

                       phrasegroup_global AS phrasegroup_global,

                       phrasegroup_vbcms AS phrasegroup_vbcms,

                       phrasegroupinfo AS lang_phrasegroupinfo,

                       options AS lang_options,

                       languagecode AS lang_code,

                       charset AS lang_charset,

                       locale AS lang_locale,

                       imagesoverride AS lang_imagesoverride,

                       dateoverride AS lang_dateoverride,

                       timeoverride AS lang_timeoverride,

                       registereddateoverride AS lang_registereddateoverride,

                       calformat1override AS lang_calformat1override,

                       calformat2override AS lang_calformat2override,

                       logdateoverride AS lang_logdateoverride,

                       decimalsep AS lang_decimalsep,

                       thousandsep AS lang_thousandsep

                                       FROM language

                                       WHERE languageid = 1;



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

Error Number  : 1054

Try this next time a issue comes up with accessing your admincp - https://vborg.vbsupport.ru/showthread.php?t=259619

Let's also cheer up in here gosh!

Merry Christmas :D

Boofo

12-15-2011 03:51 AM

Nothing to cheer up. He has clicked the uninstall button and apparently uninstalled the mod so all is well in the Spider Display land again.

Paul M

12-15-2011 12:04 PM

Quote:

Originally Posted by Boofo (Post 2277920)

He has clicked the uninstall button and apparently uninstalled the mod so all is well in the Spider Display land again.

That may be, but your reactions were rather OTT. Take a deep breath next time. :)

Boofo

12-15-2011 05:53 PM

I don't agree as I, as well a other mod authors, have had to deal with this sort of nonsense from him in the past.

Stefan118

12-15-2011 09:29 PM

1 Attachment(s)

Ok, after this endless discussion, i might have a simple question.

Gread mod btw.

The question is: Where can i change the color of the spidernames?
Attachment shows you why i would like a diffrent color.

Thanks

Boofo

12-15-2011 09:42 PM

Per the first post in this thread:

Quote:

6. Go to your Admin CP -> Styles & Templates -> Style Manager -> StyleVars (In the All Style Options drop-down) -> Boofo -> boofo_spiders_color
Enter the color code of the font color that you want the spiders to show up in.

Stefan118

12-16-2011 12:58 PM

Dang!!!, missed that! :o
Thanks!

ruger

12-19-2011 07:29 AM

1 Attachment(s)

Quote:

Originally Posted by HMBeaty (Post 2276103)

It's VERY hard to see, but it's there.

Might want to reupload it as a zip, ruger ;)

Sorry..works well with my site. Heres how it looks as well as the zip for anyone that needs.

BaanFarsang

01-01-2012 02:42 PM

vBulletin 4.1.10 Alpha 2 doesn't display both of user who is online as well as spider!

Boofo

01-01-2012 02:58 PM

As far as I know they haven't changed anything in 4.1.10 that would cause that. I would suspect you have something else going on. Maybe you need to revert the forumhome template?

Stefan118

01-01-2012 09:55 PM

Hey Boofo,

Very nice that you have modified the mod for a white spider.
Now I can see the spider perfect on my layout.

However, is it possible to make it so that you can select the color of the spider per layout?
I have 3 layouts, 2 with a white space where the spider image comes, and 1 dark.

The dark is the default style, but becouse of complains from members with glasses i have made 2 lighter layouts.

If the mod could be made just like the color of the spider name (changeble per style in the stylevars) it would be realy great!
I now have renamed the white spider image to black, and uploaded that image to the dark layout folder :D

Dr.osamA

01-01-2012 11:14 PM

thanxxxx for update big bro

Boofo

01-02-2012 08:10 AM

Quote:

Originally Posted by Stefan118 (Post 2282895)

Your wish has been granted.

Stefan118

01-02-2012 08:42 AM

Thanks!
Installed, and works perfect!

puertoblack2003

01-02-2012 04:00 PM

thanks:up: boofo i too have a light version layout :)

bulldog51981

01-02-2012 09:21 PM

I'm getting a double comma between names, anyone getting this?

https://vborg.vbsupport.ru/external/2012/01/65.jpg

HMBeaty

01-02-2012 09:34 PM

Quote:

Originally Posted by bulldog51981 (Post 2283151)

I'm getting a double comma between names, anyone getting this?

https://vborg.vbsupport.ru/external/2012/01/65.jpg

That's from your style. You either need to revert your forumhome template or you may also have some css that adds that comma (as discussed earlier in this thread)

bulldog51981

01-02-2012 09:34 PM

The only difference between the two templates is as follows

PHP Code:


		
			
<vb:comment>   <div id="pagetitle">
        <h1>{vb:raw vboptions.bbtitle}</h1>
        <p id="welcomemessage" class="description">{vb:rawphrase welcome_to_the_x, {vb:raw vboptions.bbtitle}}</p>
    </div> </vb:comment>

PHP Code:


		
			
<div id="pagetitle">
        <h1>{vb:raw vboptions.bbtitle}</h1>
        <p id="welcomemessage" class="description">{vb:rawphrase welcome_to_the_x, {vb:raw vboptions.bbtitle}}</p>

    </div>

After reverting the FORUMHOME template, the double commas are still there.

bulldog51981

01-02-2012 09:48 PM

Quote:

Originally Posted by HMBeaty (Post 2283155)

... you may also have some css that adds that comma (as discussed earlier in this thread)

If it is something in the CSS, I'm not sure what would cause it (i.e. I don't know what I should look for there). I know it's probably asking a lot, but does anyone know what I should be on the look out for?

HMBeaty

01-02-2012 10:03 PM

Try this, in your FORUMHOME template, find and replace everything between:

HTML Code:

            <!-- logged-in users -->

CODE HERE

            <!-- end logged-in users -->

With this:

HTML Code:

            <!-- logged-in users -->

            <div id="wgo_onlineusers" class="wgo_subblock section">

                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/users_online.png" alt="{vb:rawphrase currently_active_users}" />{vb:rawphrase currently_active_users}</h3>

                <div>

                    <p>{vb:rawphrase there_are_x_y_online_link, {vb:raw totalonline}, {vb:raw session.sessionurl_q}} <span class="shade">{vb:rawphrase x_members_and_y_guests, {vb:raw numberregistered}, {vb:raw numberguest}}</span></p>

                    <p>{vb:rawphrase most_users_ever_online_was_x_y_at_z, {vb:raw recordusers}, {vb:raw recorddate}, {vb:raw recordtime}}</p>

                    <vb:if condition="$activeusers">

                    <ol class="commalist" id="wgo_onlineusers_list">

                        <vb:each from="activeusers" value="loggedin">

                            <li>{vb:stylevar dirmark}<a class="username" href="{vb:link member, {vb:raw loggedin}}">{vb:raw loggedin.musername}</a>{vb:raw loggedin.invisiblemark}{vb:raw loggedin.buddymark}{vb:raw loggedin.comma}</li>

                        </vb:each>

                    </ol>

                    </vb:if>

                </div>

            </div>

            <!-- end logged-in users -->

HMBeaty

01-02-2012 10:04 PM

***Make a backup of your FORUMHOME template before applying the code I posted above***

bulldog51981

01-02-2012 10:18 PM

Backup made, changes applied.....still two

grrrrrr

(not this mods fault I'm sure, but frustrating non the less)

bulldog51981

01-02-2012 10:42 PM

Update - I still do not know the original cause of the double comma, but I found in the CSS template->vbulletin.css

PHP Code:


		
			
.commalist li:after {
    content:",";
}

that the Currently Active Users calls from. So, I'm sure that there's a better way to do this but this is what I did:

In FORUMHOME find:

PHP Code:


		
			
<ol class="commalist" id="wgo_onlineusers_list">

Replace with:

PHP Code:


		
			
<ol class="commalist2" id="wgo_onlineusers_list">

In vbulletin.css

Find:

PHP Code:


		
			
.commalist li {
    display:inline;
}

.commalist li:after {
    content:",";
}

.commalist li:last-child:after {
    content:"";
}

ul.username li a,
ol.username li a,
a.username {}
.commalist li a.username {
    display:inline;
}

Add below:

PHP Code:


		
			
.commalist2 li {
    display:inline;
}

.commalist2 li:after {
    content:"";
}

.commalist2 li:last-child:after {
    content:"";
}

ul.username li a,
ol.username li a,
a.username {}
.commalist2 li a.username {
    display:inline;
}

All times are GMT. The time now is 07:44 PM.

Page 8 of 12

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01751 seconds Memory Usage 1,876KB 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 (3)bbcode_code_printable (2)bbcode_html_printable (7)bbcode_php_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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: