Statistics

[pcs305]

(I'm a PHPfreechat newbie and a relative PHP newbie)
I would like to keep stats by nickname. I'm using MySQL .

What I would like to do is write the stats away with each post into a separate table.

Where would the best place be to insert the code to do this?

Thanks

[OldWolf]

Well, I'm not sure I entirely understand, so if the following link doesn't help you could you please explain in different words?

http://www.phpfreechat.net/parameters#nickmeta

[pcs305]

OldWolf,

Thanks for the reply and patience. (english id not my first language)

What I want is to keep a post count for each user.
ie. Joe's post count:22
John's post count:44

Then , because it will be a technical chatroom, the posts must be searchable.

So I want to store each user posts in MySQL and keep count of each post by user.

Thank you.

[OldWolf]

What do you mean by "post"? Are you talking about specific lines in phpfreechat, or are you using another software package?

[pcs305]

I'm talking about phpfreechat.

By post I mean every 'send' or entry a user makes.

I want to keep conversations and count them in searchable archives.
And then also add keep a count of each send/entry a user makes. Similar to the forum here's post counts.

Thanks

[OldWolf]

Hmm... that's a good question. This may be very taxing on your server, but I suppose it could be done. Starting with your post count:
Since you're using mysql, you should be able to effectively add a post count field into your table. From there, I would suggest that you simply add a count on each "posting" to that field, rather than doing a query for all the posts. This should cut down on the server cost.

Next, you could do one of two things:
1. Set nickmeta to the value of posts the user has. The downside is that this value may (or might not, I'm having trouble picturing it) stay static; that is to say that they may keep the same post count during their whole session.
2. Set their post count where their nick is set in the code. That should keep it dynamic, but again I can be certain.

Then for the search, I would suggest a link in nick_meta, with their userid, which leads to another page where they can enter the text and it will search from that id.