vb.org Archive - vB3 Boardstatistic Version 2

Page 2 of 14

Last »

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

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)

nineball

07-03-2004 03:35 PM

I got the same problem. For now I just commented it out and the rest of the hack seems to work ok.

Maybe it has to do with the version of mysql which is running. I also tried to run in in phpmyadmin and had a problem.

Sam FT

07-03-2004 04:26 PM

Well I am running MySQL version 3.23.58.

Scrub

07-03-2004 08:31 PM

Take out the ' around pm and try it? :p.

b4ne	07-03-2004 08:45 PM

Hi

Im getting the following Error :

Warning: Invalid argument supplied for foreach() in /home/b4ne/www/global.php on line 639

If I try to view a Forum ...

Unable to add cookies, header already sent.
File: /home/b4ne/www/global.php
Line: 639

Made the manual instalation

VB 3.0.1

Tryed to leave the second edit out of global.php snd run the resetshop (as suggested on page 1)

No luck

any idas ?

GamerJunk.net

07-03-2004 08:47 PM

Quote:

Originally Posted by Vega

Here you can see the stats in action. It's actually german, but maybe you can get a first impression of that. :)

http://www.space-dementia.de/goth-board/statistik.php?

Wow that is really german.

Ntenze

07-03-2004 09:47 PM

I've tried a couple of times to install but recieve this error. I had version 1 working but deleted it to install V.2. Not for sure what i've done wrong
Really nice hack PCFreak

Database error in vBulletin 3.0.1:

Invalid SQL:
INSERT INTO `statistik_einstellungen` VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)

mysql error: Table 'portal.statistik_einstellungen' doesn't exist

mysql error number: 1146

PcFreak

07-03-2004 10:23 PM

@Ntenze

I update the zipfile, because there are few problems with some TABLE_PREFIX in the installation file.

Download the new one and install the hack again, please.

I think (hope) that you don´t get errors again. (all the other members, witch get errors, too. Use the new zipfile in my first posting in this thread, please)
Please give me feedback, if it work.

Thank you

PcFreak

Sir_Yaro

07-03-2004 10:57 PM

Quote:

Originally Posted by PcFreak

4 Juli
Old file was downloaded 93 times.

The requested URL /images/statistik/spider/msnbot.gif was not found on this server.

You forget about directory with searchrobots pictures

upload this to /images/statistik/spider

PcFreak

07-03-2004 11:07 PM

Quote:

Originally Posted by Sir_Yaro

The requested URL /images/statistik/spider/msnbot.gif was not found on this server.

You forget about directory with searchrobots

No i have not.
In the install text i have explain this

Quote:

Originally Posted by PcFreak in the install.text

For the Spiderstatistic i release the images later. The paths for it are already in the database.
(I had no time to look for 92 little pictures for it)

PcFreak

PS: wc3 is not a spider. Its a service ;)

Ntenze

07-04-2004 03:47 AM

Sorry PCFreak.... Still getting same error. Cleared cookies etc. What could i be doing wrong?

Database error in vBulletin 3.0.1:

Invalid SQL:
INSERT INTO statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)

mysql error: Table 'portal.statistik_einstellungen' doesn't exist

mysql error number: 1146

Date: Sunday 04th of July 2004 04:48:10 AM

SaN-DeeP

07-04-2004 08:12 AM

i am using the old version of this statistik.
and i want to install this new version.

can u specify the upgrade instructions too ?

thnx.

PcFreak

07-04-2004 08:34 AM

Ntenze
Sorry, but i dont understand this mysql error. Table "portal.statistik_einstellungen"
because the insert go to the table statistik_einstellungen.
When you dont need TABLE_PREFIX for your board!
Open the file statistikadmin.php and delete all " . TABLE_PREFIX . " atributes for the arrey statistik_einstellungen.

PcFreak

PcFreak

07-04-2004 08:39 AM

Quote:

Originally Posted by SaN-DeeP

i am using the old version of this statistik.
and i want to install this new version.

can u specify the upgrade instructions too ?

thnx.

You cant upgrade the new version with the old version. To many changed was made.

But installing the new version is very easy. Del all old templates. Del the tables for the old staistic in your database. And then install the new one.

PcFreak

esnecca

07-04-2004 03:15 PM

PcFreak, this hack is a thing of beauty. The amount of work you've put into it glows from every detailed touch. I am charmed by the handful of German words remaining and have no intention of ever changing them: they are both a tribute to the brilliance of their author and, I believe, a symbol of the cultural diversity the internet has brought into everyone's home.

Congratulations and many thanks. :up:

Battle_Ring

07-04-2004 11:58 PM

where can we get add ons and stuff for this

your site is german i cant read it

Phalynx

07-05-2004 12:14 PM

Any chance to get this in GERMAN? :)

PcFreak

07-05-2004 02:42 PM

@Battle_Ring
At the moment there are no Add Ons released.
But you get them here.
@Phalynx
Du bekommst die deutsche Version auf meinem Board oder bei vBulletin Germany.

PcFreak

SaN-DeeP

07-05-2004 08:21 PM

Quote:

Originally Posted by PcFreak

hey pcfreak.
thnx for the nice hack..
but as you specified when i deleted those 6 table entire forums crashed down ;)

I fixed it, installing the new version. but it again had table prefix problems. :(

i had to manually run the queries using phpmyadmin finished everything till here ->

Code:

  $resetzeit = TIMENOW;

 

  UPDATE vb3_statistik_zaehler

  SET Summe = '$resetzeit'

  WHERE Zaehler_fuer  = 'Statistik_Aktiv'

 ;



 print_form_header('install_statistik_english', '');

 print_table_header("vBulletin 3 Statistik 2.0 Installation Script");

 print_description_row("Congratulations! The board statistics version 2.0 was successfully installed!<br><b>PLEASE DELETE THIS FILE!</b>");

 

}



?>

not sure what to do.
i ran the foll. query sucessfully ->

Code:

UPDATE vb3_statistik_zaehler

  SET Summe = '$resetzeit'

  WHERE Zaehler_fuer  = 'Statistik_Aktiv'

 ;

again via phpmyadmin.

but now when i goto my stats page.
this is the error i am getting.

Code:

 Database error in vBulletin 3.0.0:

Invalid SQL: 

  SELECT Summe as Datum

  FROM statistik_zaehler

  WHERE Zaehler_fuer = 'Statistik_Aktiv'

                

mysql error: Table ***.statistik_zaehler' doesn't exist

mysql error number: 1146

i am using vb3_ as table prefix.

Thnx a lot for this nice STATS :) ALways useful
Regards,

zetetic

07-05-2004 09:51 PM

Quote:

Originally Posted by SnowBot

Step 2)
=================================================
Create two new Phrases in the Phrasegroup:
Control center messages (I hope this is the english name for this group)

:) :)

I think its

Control Panel Global

Lets hope im right :)

I guessed that too. Doesn't appear to be right, though. I get a phrase not found error message after saving config changes.

ChuanSE

07-05-2004 10:43 PM

Great hack :D

[high]* ChuanSE clicks install[/high]

ChuanSE

07-05-2004 10:45 PM

Quote:

Originally Posted by tmhall

I guessed that too. Doesn't appear to be right, though. I get a phrase not found error message after saving config changes.

But it saved the config. the error msg is there because the phrasegroup doesn't exist. Allthough it gives a error message, your changes are saved ;)

Rampag33

07-06-2004 03:38 AM

Which group does the phrases go into?

weitalia

07-06-2004 05:13 PM

Fantastic hack but,man ur code is completely arabian for non english people...including vars..I think this is not a good way to code :(
And last but not least,no phrasing arrgh :(
By the way congratulations,for all the hard work u did,thanx ;)

;)

Jolten

07-06-2004 05:15 PM

48 queries.. ugh... okay only superadmins will get this.

MGM	07-07-2004 12:49 AM

hey im having a huge problem here

whenever I go to any page outside of the first page (eg: www.domain.com/forums/statistik.php) it works fine, but when i try to visit any of the other pages this happens, check it out for yourself:

http://www.forevergaming.com/forums/...do=last_x_days

any clue why?

MGM out

weitalia

07-07-2004 12:56 AM

Quote:

Originally Posted by SnowBot

Unfortunately you are not right.
If you take a look at the statistic.php file you find:

PHP Code:


		
			
  print_stop_message("statistik_zurueck_gesetzt");

and 4 lines after

PHP Code:


		
			
 print_stop_message("statistik_cp_gespeichert");

By this you can understand that we have to put both phrases in Control Panel Stop Message, to avoid errors.

;)

kall	07-07-2004 05:34 AM

I have this installed, but many of the images aren't showing.

http://forums.nzboards.com/statistik.php?do=polls for example..

SaN-DeeP

07-07-2004 10:18 AM

can someone tell me whats the error -> http://207.58.143.178/

how do i fix it ?

thnx

SaN-DeeP

07-07-2004 12:00 PM

Quote:

Originally Posted by SaN-DeeP

can someone tell me whats the error -> http://207.58.143.178/

how do i fix it ?

thnx

fixed it and added admin permissions only ^_^

PcFreak

07-07-2004 02:47 PM

Quote:

Originally Posted by kall

I have this installed, but many of the images aren't showing.

http://forums.nzboards.com/statistik.php?do=polls for example..

Replace the template statistic_polls_bit.txt with this code.

Code:

<tr>

  <td class="$bgclass"> <div align="left"><a title="$thementitel_alt_text" href="showthread.php?t=$themenid">$thementitel</a></div></td>

  <td class="$bgclass"><div align="center"><a title="Show Profil of $autor" href="member.php?u=$sticky_autorid">$autor</a></div></td>

  <td class="$bgclass"><div align="left"><a title="$frage_alt_text" href="poll.php?do=showresults&amp;pollid=$pollid">$frage</a></div></td>

  <td class="$bgclass"><div align="center">$polldatum</div></td>

  <td class="$bgclass"><div align="center">$moegliche_antworten</div></td>

  <td class="$bgclass"><div align="center">$abgestimmt_haben</div></td>

  <td class="$bgclass"><div align="center"><img src="$umfrage_aktive" alt="Poll aktiv/ Not aktive" width="15" height="15" /></div></td>

  <td class="$bgclass"><div align="center">$umfrage_ende (days)</div></td>

  <td class="$bgclass"><div align="center"><img src="$mehrauswahl" alt="'Multiple choice possible / not possible" width="15" height="15" /></div></td>

  <td class="$bgclass"><div align="center"><img src="$oeffentlich" alt="publicly / not publicly" width="15" height="15" /></div></td>

  <td class="$bgclass"><div align="center">$bestaunt</div></td>

</tr>

I dont?know why, but something is missed in this template on your board.

@MetalGearMaster
I think there is a other hack (storehack?) witch make problems. You dont use the orginal headinclude, header or footer template.

PcFreak

MGM	07-08-2004 01:59 AM

Do you mean I have to Revert those 3 templates to the vB default?? i don't understand why they're causing trouble... could you please give me a bit more information, thanks!

MGM out

Smitty

07-08-2004 05:35 AM

I just installed this on my production board. The installation went flawlessly. Your installation script is excellent and appreciated. It made installation not only easy but fast. I have been 'playing' with it for a bit now and so far as I can tell everything works as it should.

I am very impressed and I appreciate your sharing all your hard work on this!

Smitty

07-08-2004 06:25 AM

Question: I have Google's AdSense on my forums. I would like to be able to distinguish between the AdSense bot visits and the 'standard' Google indexing bot visits, as I can in online.php, in the 'statistik.php?do=spider' statistics page.

Can anyone tell me where and/or how to do this?

#######################################
EDIT ADD:
In statistic_last_x_threads_bit

Original:

PHP Code:


		
			
 <tr>

    <td>

    <a title="$postinfo" href="showthread.php$session[sessionurl]t=$beitragsid">$beitragstitel</a>

<br />

from

    <a title="Show Profile of $geschrieben_von" href="member.phpu=$schreiberid">$geschrieben_von</a>

written $geschrieben_am

<br />

last reply from

<a title="Show Profile of $letzte_antwort" href="member.phpu=$lastposterid">$letzte_antwort</a>

written $letzte_antwort_am

</td>

</tr>

Added ? to links:

PHP Code:


		
			
 <tr>

    <td>

    <a title="$postinfo" href="showthread.php$session[sessionurl]?t=$beitragsid">$beitragstitel</a>

<br />

from

    <a title="Show Profile of $geschrieben_von" href="member.php?u=$schreiberid">$geschrieben_von</a>

written $geschrieben_am

<br />

last reply from

<a title="Show Profile of $letzte_antwort" href="member.php?u=$lastposterid">$letzte_antwort</a>

written $letzte_antwort_am

</td>

</tr>

kall	07-08-2004 08:56 AM

Quote:

Originally Posted by PcFreak

Replace the template statistic_polls_bit.txt with this code.

Code:

<tr>

  <td class="$bgclass"> <div align="left"><a title="$thementitel_alt_text" href="showthread.php?t=$themenid">$thementitel</a></div></td>

  <td class="$bgclass"><div align="center"><a title="Show Profil of $autor" href="member.php?u=$sticky_autorid">$autor</a></div></td>

  <td class="$bgclass"><div align="left"><a title="$frage_alt_text" href="poll.php?do=showresults&amp;pollid=$pollid">$frage</a></div></td>

  <td class="$bgclass"><div align="center">$polldatum</div></td>

  <td class="$bgclass"><div align="center">$moegliche_antworten</div></td>

  <td class="$bgclass"><div align="center">$abgestimmt_haben</div></td>

  <td class="$bgclass"><div align="center"><img src="$umfrage_aktive" alt="Poll aktiv/ Not aktive" width="15" height="15" /></div></td>

  <td class="$bgclass"><div align="center">$umfrage_ende (days)</div></td>

  <td class="$bgclass"><div align="center"><img src="$mehrauswahl" alt="'Multiple choice possible / not possible" width="15" height="15" /></div></td>

  <td class="$bgclass"><div align="center"><img src="$oeffentlich" alt="publicly / not publicly" width="15" height="15" /></div></td>

  <td class="$bgclass"><div align="center">$bestaunt</div></td>

</tr>

Hmm, that didn't work.

What do you suggest I do?

Reinstall completely?

Smitty

07-08-2004 08:59 AM

In statistic_polls_bit I also found this:

PHP Code:


		
			
<a title="Show Profil of $autor" href="member.php?u=$sticky_autorid">$autor</a>

It does not give a user ID. Clicking the link takes you to a message saying the user is not registered.

What it is calling is: http :// site . com/Forums/member.php?u=

As you can see there is no user ID appended to the link.

EDIT ADD:

Changed to:

PHP Code:


		
			
<a title="Show Profil of $autor" href="member.php?u=$autorid">$autor</a>

GeoffE

07-09-2004 01:45 PM

Great hack .. having a couple of small problems though ..

In the main page, the Visitors total is 19 since I installed the hack (7/7), but looking at the board we have 27 online at the moment ..

In countries, we only seem to have 15 visitors (from England), but I know there have been a lot more from other countries, France and India to name a couple, and in referrers we only seem to have 3 visitors ..

Any ideas?

thanks for your help ..

Smitty

07-09-2004 02:48 PM

I'm not sure. I'm still playiing with what I installed and haven't really zeroed in on several numbers and how they're computed. I'm not a php / MySQL guru ato begin with.

I still have one bug I can't figure out how to fix where, in the Most Popular Forums popup, no forum ID is given when someone clicks on the forum name.

I've chaged some labels and such.

You can check mine at http://Elsmar.com/Forums/

Natch

07-09-2004 03:10 PM

the country visitors are based on the domain name in their referer - so this is not really that accurate :( much more heavey work on the server to reverse DNS the names to get IP's then parse thelookup to find a country name, then parse that against the databse table of country names ?

vBFreak

07-09-2004 04:03 PM

Quote:

Originally Posted by PcFreak

dont forget... I?m german. English is not my motherlanguage. So be friendly with me.

why do you not attach a translated version for all german people like me here? Now I have to translate it by myself :(

PcFreak

07-09-2004 04:33 PM

Quote:

Originally Posted by vBFreak

why do you not attach a translated version for all german people like me here? Now I have to translate it by myself :(

The german version is relased on the vBulletin germany board

http://www.vbulletin-germany.com/

or you can get the geman version on my board.

PcFreak

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

Page 2 of 14

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01911 seconds Memory Usage 1,871KB 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 (5)bbcode_code_printable (6)bbcode_php_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (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: