vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB3 Boardstatistic Version 2 (https://vborg.vbsupport.ru/showthread.php?t=66783)

BamaStangGuy 11-28-2004 07:00 PM

Quote:

Originally Posted by joeychgo
How did you do all that?

AdminCP > Attachments > Attachment Storage Type and move them to filesystem

DS MrSinister 11-28-2004 08:45 PM

Quote:

Originally Posted by goblues
Just taking a stab, did you place the following code into your phpinclude_start template?

Code:

include("./statistik_counter.php");


thanks mate i forgot to do that..

goblues 11-28-2004 08:59 PM

Quote:

Originally Posted by DS MrSinister
thanks mate i forgot to do that..

Glad I could help out!

Takamine334 11-29-2004 09:56 PM

I have 3 styleids. This is what I get when installing
Quote:

Template install completed. 36 templates added to styleid: 2
Click on "Add new database tables" to continue.
how do I get it to add to styleid 1 & 3 ?

urmyantichrist 11-29-2004 10:20 PM

How can I get the arcade addon working?

All I'm getting is a lank white page with the arcade stats info in a line down the middle of the page...

I'm not certain what I did wrong....?

joeychgo 11-30-2004 07:49 AM

Is there any way to reduce the queries?

joeychgo 12-01-2004 07:18 PM

This seems WAY too much --

This is from the overview page

Quote:

Page generated in 10.11654 seconds with 47 queries [Server Loads: 5.38 7.23 : 7.23]
Page generated in 9.92194 seconds with 47 queries [Server Loads: 5.91 6.07 : 6.73]
Page generated in 10.25936 seconds with 47 queries [Server Loads: 4.76 5.68 : 6.54]

Rick Sample 12-01-2004 07:29 PM

Quote:

Originally Posted by joeychgo
This seems WAY too much --

This is from the overview page

How did you find that stuff out?

joeychgo 12-02-2004 06:42 AM

Quote:

Originally Posted by Rick Sample
How did you find that stuff out?


Its magic -- :D


Nah - here is the hack https://vborg.vbsupport.ru/showthrea...ht=server+load

Rick Sample 12-02-2004 06:45 AM

Quote:

Originally Posted by joeychgo
Its magic -- :D


Nah - here is the hack https://vborg.vbsupport.ru/showthrea...ht=server+load


I'll have to give it a try and see how high my stuff is!

joeychgo 12-03-2004 07:24 PM

My host sent me this email today:

Quote:

Your account is utilizing excessive resources, causing a significant
degradation of services on the server. This is a shared environment and we
can not allow one user to utilize the majority of the resources on a server as
it affects all users adversely. Because of this, you have been temporarily
moved to the Quantz server. A detail of the problem is shown below:

Top Process %CPU 30.0 /usr/bin/php
Top Process %CPU 20.0 /usr/bin/php
Top Process %CPU 12.0 /usr/bin/php

Using 4.63% of servers memory

We moved you to Quantz first to solve the issue of the degraded service on
Nasa, and second as a courtesy in order to prevent any downtime on your site to allow you time to rectify the situation. Currently, your site is not
suitable for a shared hosting environment.

The only thing I have installed recently is this hack -- I am waiting now to find out if removing this hack solved the problem ~will advise~

mcyates 12-03-2004 08:10 PM

Quote:

Originally Posted by joeychgo
My host sent me this email today:




The only thing I have installed recently is this hack -- I am waiting now to find out if removing this hack solved the problem ~will advise~

It probably was the statistics causing this problem, i took it off my site as it drastically reduced the speed and adding 5 - 6 queries on each page. Very querie intensive.

joeychgo 12-03-2004 09:36 PM

It appears so - I pulled it and the server loads dropped.

it seems this hack will make a mess unless your on a dedicated server.

Mark.B 12-03-2004 09:44 PM

Certainly, I would not advise use of the Arcade add on...806 queries on one page, sheesh.

mcyates 12-03-2004 09:57 PM

Quote:

Originally Posted by Mark.B
Certainly, I would not advise use of the Arcade add on...806 queries on one page, sheesh.

806??? It only added a couple whe i installed it. You must have done something wrong.

Mark.B 12-03-2004 10:08 PM

Quote:

Originally Posted by mcyates
806??? It only added a couple whe i installed it. You must have done something wrong.

I should qualify, it doesn't add those to the index page, that's the number of queries it seems to use on the actual arcade stats page.

mackers8923 12-03-2004 11:07 PM

*Installed*

Going to give it a go as yet no major increase in server load is noted.

mcyates 12-04-2004 12:00 AM

Quote:

Originally Posted by mackers8923
*Installed*

Going to give it a go as yet no major increase in server load is noted.

this didn't increase my server load one bit. What it did do is increase the quieries and slowed my site down via tha database. But it was only slight slower. i like very fast sites and I actually had this on for 2 months, i've JUST remved it.

Torqued 12-08-2004 01:16 AM

It looks like the script is only counting people that are using custom avatars and not the people using the installed avatars.

I found this code that looks like it's doing that:

PHP Code:

$alle_avatars $DB_site->query_first("SELECT COUNT( * ) as avatar FROM " TABLE_PREFIX "customavatar "); 

How would you fix that so that it would count both people using custom avatars and people using installed avatars?

morrow 12-08-2004 03:13 AM

*Installed tonight in about 8 minutes. Very nice hack so far, let's see what happens when the cron job kicks in! :)

Thanks a bunch for this gem.

*Clicks install

GamerzWorld 12-08-2004 02:32 PM

Hello installed this a while ago but recerntly found

The 10 Top Level Domains
http://www.revival-guild.com (850 entries)
http://forum.legendofmir.net (770 entries)
http://boards.legendofmir.net (415 entries)
http://www.legendofmir.net (366 entries)
http://www.brutal-rape.biz (195 entries)
http://mature.industryofporn.net (161 entries)
http://www.google.com (114 entries)
http://search.yahoo.com (103 entries)
http://www.google.co.uk (31 entries)
http://incest-porn.industryofporn.net (31 entries)


Now obviously im disgusted by this. How do i remove it and what is causing this

Torqued 12-08-2004 04:50 PM

It could be "stealth spamming" where a person signs up for accounts and puts "hidden" links in their sig, avatar, profile, etc. linking to those sites. It's a tactic used to improve their search engine rankings.

Have a look at this article:

Security: Silent Spamming - Is your Website Being Abused?

http://www.theadminzone.com/forums/a...rticle&aid=684

berberber 12-08-2004 04:55 PM

Hello everybody, thanks for that hack, I am using it too (even if one feature is missing, the detection of new little referers (as, one day the main referers have all the space in the referer page)).
But I have a problem, i had little hosting problems, and after outtage I have that ::
Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                        INSERT INTO statistik_log
                        VALUES('','82.******.181','1102512176','Mozilla/5.0 (Windows; U; Windows
NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0')

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Wednesday 08th of December 2004 01:22:56 PM

One time I just had to clear it, the second time I had to repair it using phpmyadmin, but problem is, that without that the forum restarts without problem, so I imagine that table must be different...
Do anyone know how to fix that ?

Thanks,
Bernhard

Noch mal vielen dank ;)

goblues 12-08-2004 05:34 PM

Quote:

Originally Posted by GamerzWorld
Hello installed this a while ago but recerntly found

The 10 Top Level Domains
http://www.revival-guild.com (850 entries)
http://forum.legendofmir.net (770 entries)
http://boards.legendofmir.net (415 entries)
http://www.legendofmir.net (366 entries)
http://www.brutal-rape.biz (195 entries)
http://mature.industryofporn.net (161 entries)
http://www.google.com (114 entries)
http://search.yahoo.com (103 entries)
http://www.google.co.uk (31 entries)
http://incest-porn.industryofporn.net (31 entries)


Now obviously im disgusted by this. How do i remove it and what is causing this

I also am having problems with this. Started yesterday as far as I can tell. Had to disable (just renamed the files for now) until this can be addressed. You can physically remove these entries by deleting them in your statistik_domain & statistik_referer tables in your database.

Torqued 12-08-2004 05:36 PM

You might want to check your server logs for those URL's to see if they are linking to files/content on your site. Check out the article I posted earlier.

PcFreak 12-08-2004 08:47 PM

The last months I had no much time to work on the board statistic.

But i will release a new one in the end of this year.
Sorry that i had no more supported the old one.

More infos here, soon.

Pc Freak

Smitty 12-09-2004 01:57 AM

That would be GREAT!!! And very much appreciated! This is really a great 'hack'!

kall 12-11-2004 10:25 PM

Something everyone may want to know:

This script's main file is now being targetted by referrer spambots.

They go straight for statistik.php?do=referrer and your referrer links get filled with porn sites' URLs.

My advice is to rename the statistik.php to something else, and find/replace in the templates to point to the new file name, and not have this a public feature, otherwise you will end up with the badness like I do.

Smitty 12-11-2004 10:51 PM

That does it for me. I disabled that listing by editing the referrer_bit

Smitty 12-11-2004 11:31 PM

Can anyone explain just how the bots are making these entries?

By the way - I noticed the "adminshop dot com" is also appears to be doing this.

Can anyone give me a SQL query to delete all referrer entries of only 1 in the Zaehler field?

TRStealth 12-12-2004 12:49 AM

I'm getting a problem with this, lately, I've been getting emailed (About 600 of them actually) with a problem caused by this hack:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT ID,Zaehler
FROM statistik_referer
WHERE Referer ='Direkter Zugriff'
ORDER BY ID DESC

mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 12th of December 2004 02:42:26 AM
Script: http://www.enclave1.net/forums/showt...lastpost&t=591
Referer:
Username: Unregistered
IP Address:

I'm not really sure how to fix it.

Smitty 12-12-2004 01:42 AM

I've seen Direkter Zugriff in the database and have scrolled through 70,000+ entries deleting the 'crap'. I've been deleting the Direkter Zugriff references as well as some type of spam.

PcFreak 12-12-2004 02:53 AM

Quote:

Originally Posted by kall
Something everyone may want to know:

This script's main file is now being targetted by referrer spambots.

They go straight for statistik.php?do=referrer and your referrer links get filled with porn sites' URLs.

Thank you.
Good to know this!

The best way to delete all referers is, to use the function empty the statistk_referer table, directly in the mysql.

Or use a query like this:
PHP Code:

Truncate TABLE 'statistik_referer' 

.

PcFreak

Smitty 12-12-2004 03:14 AM

I saw a couple of posts on this but didn't thik much of it until I was doing some maintenance and took a looksie. I was really, really p*$$ed off. I edited the referrer template and disabled those stats. They're mostly google anyway.

It was even kinda creepy. I was going through the referrer and domain database tables with phpMyadmin deleting some entries for the bot entries. I was then checking the server logs with a log analysis app. While I was doing this those bots came!

Oh, well. Anything for an inbound link from another site, eh?

I plan to just leave that page disabled. I doubt my users care about that page anyway.

I do hope this is upgraded - it is a very nice hack. This has been a minor inconvenience.

Takamine334 12-12-2004 06:14 PM

I must have missed something because I've been getting this since December 5th when I installed this hack

Smitty 12-12-2004 06:48 PM

You know spammers. Where there's a will...

I went through my logs and this is relatively new - a week or so for me. I went through the entire database fields domain & referrers and checked and dumped all entries. Now I'll watch for a while. But I am keeping that page 'restricted - That is I edited the template as I said above so where there are typically the stats it just says disabled due to URL spam bots. I assume it's really a person doing this rather than a script or bot but you never know.

Trosun 12-13-2004 08:35 PM

My stats still doesn't track googlebot.

I've changed the functions_statistik.php as Onkel Tom spesified in post #332

Smitty 12-13-2004 09:20 PM

Thankis for the tip!

Takamine334 12-13-2004 11:47 PM

Wish someone could answer my question

PcFreak 12-14-2004 05:50 AM

Quote:

Originally Posted by Takamine334
Wish someone could answer my question

Code:

Step 7)
=========
Now let's activate the statistics and count of visitors

Open Template "phpinclude_start" in your AdminCP

====================================================================
add the following code at the end of the template in the last line!:
====================================================================

//## vB Statistics by PcFreak Start ##

include("./statistik_counter.php");

// ## vB Statistics by PcFreak End ##

;)
PcFreak


All times are GMT. The time now is 05:29 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01760 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
  • (3)bbcode_code_printable
  • (2)bbcode_php_printable
  • (16)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