rsx_request_count: Article Request Counter

paularms · 2005-01-24 05:24:55

Ramanan: I see that you have a page displaying your most viewed articles and giving the number of views. Is this another plugin that you plan to release or do I really need to learn PHP?

and colak, there is a graphical way to add that in phpMyAdmin instead of just entering in the SQL. click on the txp_textpattern table and at the bottom, right after “Print view” and “Propose table structure”, click the GO button and you can add the stuff manually.

Last edited by paularms (2005-01-24 05:26:42)

colak · 2005-01-24 10:30:47

Ramanan, thanks for the response. I am new with mysql and phpmyadmin. Can you please be more specific. On adding a new field I am presented with
Field
Type
Length/Values*
Collation
Attributes
Null
Default**
Extra

4 radio buttons and a checkbox

Am I correct in assuming that the fields should be filled like this
Field: request_count
Type: INT
Length/Values*
Collation
Attributes
Null: not nul
Default** : 0
Extra

the 3rd radi button selected
and the checkbox uncheckked

Your advise would be appreciated…

Last edited by colak (2005-01-24 10:31:10)

ramanan · 2005-01-24 12:59:09

Field: request_count
Type: INT
Attribute : Unsigned (not needed really)
Null: Not Null
Default: 0
Extra:

Primary:
Index:
Unique:
- : <— select this radio button

fulltext:

That should be correct. You don’t need to check the unique radio button, because there is only one row in this table.

colak · 2005-01-25 07:33:50

Thank you ramanan. Done it and it doesn’t work… will have to experiment a bit more.

colak · 2005-01-29 09:57:54

It somehow started working now. thanx again!

dai · 2006-12-19 15:01:31

When I try there to download rsx_request_count.txt I got 404 error. Seems like ramanan removed plugin for some reasons :(

plugin can be found at http://www.funkaoshi.com/static/rsx_request_count.txt

ramanan · 2007-10-20 02:45:06

The link at the start of this post works; i’m confused? Or maybe I fixed it after the fact.

Last edited by ramanan (2007-10-20 02:45:56)

amavai · 2010-03-25 18:55:00

Hi Forum,

Roman, thanks for the plugin. But I would like to ask if someone can help me with the addition into de database. I tried several times with no sucess..

I have MySQL 5,0 and the options when I try to creat the entry are:

Field: request_count
Type; INT
Lenght/Values:
Default: Here I have some options: None, As Defined, NULL, Current_timestamp
and then a blank box, where I supouse I have to fill with 0
Collation:
Atributes:
Null ( check box , unchecked I supouse)
Index: Unique
AUTO_INCREMENT: Should be check?
Comments;

I added, deleted, and always receive the same error: #1062 – Duplicate entry ‘0’ for key 2

Could you please help me to let me know how I configure this?

Thanks a lot!

Amavai

Pat64 · 2012-12-18 15:48:35

Hi Folks ;)

~~I use this plugin for a project that need it. I notice article access weren’t well updated. The only way to correct is to disable the “send lastmod” preferences option.~~

~~But, in this case, the website is much slower. Is there a better way?~~

Thanks for your advices.

Problem solved: this occures with smd_xml without “cache_time” attribute set.

Last edited by Pat64 (2012-12-18 17:25:37)

Textpattern CMS

Textpattern CMS support forum

#16 2005-01-24 05:24:55

Re: rsx_request_count: Article Request Counter

#17 2005-01-24 10:30:47

Re: rsx_request_count: Article Request Counter

#18 2005-01-24 12:59:09

Re: rsx_request_count: Article Request Counter

#19 2005-01-25 07:33:50

Re: rsx_request_count: Article Request Counter

#20 2005-01-29 09:57:54

Re: rsx_request_count: Article Request Counter

#21 2006-12-19 15:01:31

Re: rsx_request_count: Article Request Counter

#22 2007-10-20 02:45:06

Re: rsx_request_count: Article Request Counter

#23 2010-03-25 18:55:00

Re: rsx_request_count: Article Request Counter

#24 2012-12-18 15:48:35

Re: rsx_request_count: Article Request Counter

Board footer