phpBB Statistics

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
marian0810
Former Team Member
Posts: 3011
Joined: Mon May 21, 2007 9:17 pm
Location: The Netherlands
Name: Marian
Contact:

Re: phpBB Statistics

Post by marian0810 »

marc1706 wrote:I'm currently working on some add-ons, including ... phpBB Arcade.
That would be so awesome! :D
Unfortunately, I'll have to redo the phpBB Arcade Add-On after I lost some data on my old computer.
I hope that didn't stop you 8-) Really looking forward to this!
You and me, time and space. You watch us run!
johanx
Registered User
Posts: 14
Joined: Wed Dec 02, 2009 2:52 pm

Re: phpBB Statistics

Post by johanx »

Hi there,

I Installed the mod and see the link. But, when i try to see the statistics...I get an HTTP-error 500, internal server error.

Can you tell me what I did wrong?

Johan
User avatar
Marc
Development Team Leader
Development Team Leader
Posts: 5479
Joined: Tue Oct 30, 2007 10:57 pm
Location: Munich, Germany
Name: Marc
Contact:

Re: phpBB Statistics

Post by Marc »

You have uploaded all files? On what PHP Version is your server running?
With what editor did you edit your files?

@noelcrowley: I'm currently trying to set up an IIS Server with MSSQL, but I'm kind of having a hard time, so it will take some more time. :roll:
noelcrowley
Registered User
Posts: 32
Joined: Sat Apr 21, 2007 12:39 pm

Re: phpBB Statistics

Post by noelcrowley »

Thanks Marc.

I am greatful for your help. I understand that it is best effort. Thank you again.

Noeel
User avatar
Marc
Development Team Leader
Development Team Leader
Posts: 5479
Joined: Tue Oct 30, 2007 10:57 pm
Location: Munich, Germany
Name: Marc
Contact:

Re: phpBB Statistics

Post by Marc »

Ah, I finally got my SQL Server 2008 working on Windows 7. You can't imagine how hard it was to make that work, probably the reason why most servers run Apache. :roll:

Anyhow, now I can start taking a look at your errors. ;)
User avatar
Traction
Registered User
Posts: 288
Joined: Fri Jun 06, 2003 8:42 pm
Location: Staten Island, New York
Contact:

Re: phpBB Statistics

Post by Traction »

I once used a mod about 5 years ago that said stats for the days and months. For example, it would say something like 4,767 post in October 2009, 5,497 in November 2009, etc. Does this do that?
Failure is not an option.
Zap! Classic Video Game Forums
User avatar
Marc
Development Team Leader
Development Team Leader
Posts: 5479
Joined: Tue Oct 30, 2007 10:57 pm
Location: Munich, Germany
Name: Marc
Contact:

Re: phpBB Statistics

Post by Marc »

Yes, this MOD does that. Just take a look at my site: www.m-a-styles.de/stats.php
User avatar
Marc
Development Team Leader
Development Team Leader
Posts: 5479
Joined: Tue Oct 30, 2007 10:57 pm
Location: Munich, Germany
Name: Marc
Contact:

Re: phpBB Statistics

Post by Marc »

@noelcrowley:
Fixed a lot of bugs with MSSQL and comitted to SVN:
http://phpbbstatistics.svn.sourceforge. ... evision=78
noelcrowley
Registered User
Posts: 32
Joined: Sat Apr 21, 2007 12:39 pm

Re: phpBB Statistics

Post by noelcrowley »

marc1706 wrote:@noelcrowley:
Fixed a lot of bugs with MSSQL and comitted to SVN:
http://phpbbstatistics.svn.sourceforge. ... evision=78

Thanks Marc, it will be monday before I can test. I will let you know how I get on.
johanx
Registered User
Posts: 14
Joined: Wed Dec 02, 2009 2:52 pm

Re: phpBB Statistics

Post by johanx »

Problem solved. Conflicted with the quick language mod.

ty!
noelcrowley
Registered User
Posts: 32
Joined: Sat Apr 21, 2007 12:39 pm

Re: phpBB Statistics

Post by noelcrowley »

noelcrowley wrote:
marc1706 wrote:@noelcrowley:
Fixed a lot of bugs with MSSQL and comitted to SVN:
http://phpbbstatistics.svn.sourceforge. ... evision=78

Thanks Marc, it will be monday before I can test. I will let you know how I get on.

Hi Mark,

Now I am geting this error!

Code: Select all

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'UNSIGNED'. [37000]

SQL

ALTER TABLE phpbb_profile_fields ADD field_stats_show TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0;

BACKTRACE


FILE: includes/db/mssql_odbc.php
LINE: 165
CALL: dbal->sql_error()

FILE: install/install_install.php
LINE: 139
CALL: dbal_mssql_odbc->sql_query()

FILE: install/install_install.php
LINE: 73
CALL: install_install->load_schema()

FILE: install/index.php
LINE: 252
CALL: install_install->main()

FILE: install/index.php
LINE: 53
CALL: module->load()
User avatar
Marc
Development Team Leader
Development Team Leader
Posts: 5479
Joined: Tue Oct 30, 2007 10:57 pm
Location: Munich, Germany
Name: Marc
Contact:

Re: phpBB Statistics

Post by Marc »

Here: http://phpbbstatistics.svn.sourceforge. ... pathrev=78

Before opening the page again, please delete the tables phpbb_stats_config, phpbb_stats_smilies, phpbb_stats_bbcodes from your database. Otherwise you will get another SQL error.

Do you have ICQ or MSN? If you just send me your account info via PM I can help you fast and easy. ;)
noelcrowley
Registered User
Posts: 32
Joined: Sat Apr 21, 2007 12:39 pm

Re: phpBB Statistics

Post by noelcrowley »

marc1706 wrote:Here: http://phpbbstatistics.svn.sourceforge. ... pathrev=78

Before opening the page again, please delete the tables phpbb_stats_config, phpbb_stats_smilies, phpbb_stats_bbcodes from your database. Otherwise you will get another SQL error.

Do you have ICQ or MSN? If you just send me your account info via PM I can help you fast and easy. ;)

Thank you very much for your help with this. I finally got it working. I have to make 2 other changes with the schema file. It is working now and I am greatful for your help.

Code: Select all

CREATE TABLE [phpbb_stats_smilies] (
	[smiley_url] [varchar] (255) DEFAULT ('') NOT NULL ,
	[smiley_count] [int] DEFAULT (0) NOT NULL
) /*ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]*/

CREATE TABLE [phpbb_stats_bbcodes] (
	[bbcode] [varchar] (255) DEFAULT ('') NOT NULL ,
	[bbcode_count] [int] DEFAULT (0) NOT NULL
) /*ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]*/
GO
It is a nice bit of code.
User avatar
Marc
Development Team Leader
Development Team Leader
Posts: 5479
Joined: Tue Oct 30, 2007 10:57 pm
Location: Munich, Germany
Name: Marc
Contact:

Re: phpBB Statistics

Post by Marc »

Oh, I think I also changed that in the SVN.

Glad to hear it's finally working.
User avatar
Traction
Registered User
Posts: 288
Joined: Fri Jun 06, 2003 8:42 pm
Location: Staten Island, New York
Contact:

Re: phpBB Statistics

Post by Traction »

marc1706 wrote:Here: http://phpbbstatistics.svn.sourceforge. ... pathrev=78

Before opening the page again, please delete the tables phpbb_stats_config, phpbb_stats_smilies, phpbb_stats_bbcodes from your database. Otherwise you will get another SQL error.

Do you have ICQ or MSN? If you just send me your account info via PM I can help you fast and easy. ;)
I didn't delete any tables and I don't get any errors.
Failure is not an option.
Zap! Classic Video Game Forums
Locked

Return to “[3.0.x] MOD Database Releases”