tables

Recommend this page to a friend!

      gStats  >  All threads  >  tables  >  (Un) Subscribe thread alerts  
Subject:tables
Summary:missing table
Messages:8
Author:valentino1
Date:2007-07-18 11:33:35
Update:2009-02-02 10:54:52
 

  1. tables   Reply   Report abuse  
Picture of valentino1 valentino1 - 2007-07-18 11:33:35
I've installed the software and testing.

but there isn't
gstats_ads_click

in db install

I'm asking how big will be the mysql database, if it tracks every click.

But it's an interesting solution.
Perhaps you can filter clicks only on adsense clicks, that's the most interesting feature for me.

Great job and good work.
Spataro

  2. Re: tables   Reply   Report abuse  
Picture of Cesar D. Rodas Cesar D. Rodas - 2007-07-18 14:38:40 - In reply to message 1 from valentino1
Sorry. I've forgotten.

Here is the SQL code, I will include in 4 hours or more in the code.

CREATE TABLE `gstats_ads_click` (
`userId` int(11) NOT NULL,
`visitor` int(11) NOT NULL,
`page` varchar(250) NOT NULL,
`ads` varchar(50) NOT NULL,
`size` varchar(10) NOT NULL,
`dtime` datetime NOT NULL
);

  3. Re: tables   Reply   Report abuse  
Picture of Cesar D. Rodas Cesar D. Rodas - 2007-07-18 14:58:21 - In reply to message 1 from valentino1
If you track every click the DB is not so big, I implement two days ago into my blog. My blog recieve 500 unique visitors and 700 hits and it has 100kb per day. Not so much, and it brings useful information like Where users go (out links) and from where they come.

And you can modify the class and comment the insert to every click.

I will start tomorrow to offer a new useful way to do more personalized way to track what you want.

Thanks for download my class.


  4. Re: tables   Reply   Report abuse  
Picture of valentino1 valentino1 - 2007-07-20 11:56:43 - In reply to message 3 from Cesar D. Rodas
I've installed the missing table, and now is again on line for testing.

I have 50.000 pages a day, but i've installed just in one of my sites. I'll tell you my stats.

At the moment the only litte bug I verify is some errors of duplicate entries in the mysql log.

Did you verify if it is ok with adsense rules ?

Spataro

  5. Re: tables   Reply   Report abuse  
Picture of Cesar D. Rodas Cesar D. Rodas - 2007-07-20 14:06:09 - In reply to message 4 from valentino1
That is not an error, that is duplicated when the same user open the same page, so the DB ignore the entry

That is not a bug.

  6. Front End screen   Reply   Report abuse  
Picture of Gurpreet Singh Gurpreet Singh - 2007-09-13 04:01:30 - In reply to message 5 from Cesar D. Rodas
Hi Cesar,

Do you have a utility to view the stats on nicely formatted page?

That would be great.

-Thanks,
Bablooji

  7. Re: tables   Reply   Report abuse  
Picture of Cesar D. Rodas Cesar D. Rodas - 2007-09-13 04:47:58 - In reply to message 6 from Gurpreet Singh
Not yet! And that is a good idea, i usually see my stats in a mysqlclient prompt, but that is not so nice, I will build one and share.

And if anyone can do, that will be cool too ;-)

  8. Re: tables   Reply   Report abuse  
Picture of remo williams remo williams - 2009-02-02 10:54:52 - In reply to message 7 from Cesar D. Rodas
hi,

i suggest that you correct the very first line of the file "db_install.sql".
it says: "DROP TABLE IF EXISTS `gstats_out_clicks`;"
while it should be: "DROP TABLE IF EXISTS `gstats_ads_click`;"

no offense dude! :)

 

For more information send a message to info at phpclasses dot org.