Profile acitivity index plugin

good work papilon,

have you got this working on a big site with a lot of users? any performance issues?

I have a point system that works but doesnt run on database queries but on physical activity and has many simple hacks for various extensions... for example uploading an avatar you get "x" points added to a field in the database when the moderator approves it by click the approve button, at this instance an extra line of code is added is processed that adds the points.

This means that when people look at the profile only one query is required... that being how many points are in the points field. Instead of whats the status of that field, if its equal to that multiply it by that and so on in order to get you final points tally... perhaps i should just create it this way anyway and see what people think about it

I was originally concerned with the amount of additional queries and calculations the server would have to perform when running on a site with 1000's of users checking the stats, saying that though a site with 1000's of users should be perhaps generating enough cash to have a better server....

Post edited by: sa247, at: 2007/08/29 06:10

Post edited by: sa247, at: 2007/08/29 06:12

Hi papillon,

a big THANKS for that plugin. It work perfectly for me and it´s looking very nice.

Thanks for that
grinch

sa247 wrote:

have you got this working on a big site with a lot of users? any performance issues?

My site is not very big (about 700 users, not more than 30 online) and my site is the only dynamic one running on this server (the rest are static sites) hence I can't say very much about the performance.

I have a point system that works but doesnt run on database queries but on physical activity and has many simple hacks for various extensions...

First, I don't like hacking very much, because every update I have to make the hacks again.
Second, I think that a point system is something different to the activity index, because it don't take care of the fact when the entries and so on are made.
But I am very interested in a point system too, perhaps you post yours in this forum

I was originally concerned with the amount of additional queries and calculations the server would have to perform when running on a site with 1000's of users checking the stats...

The plugin makes 6 database queries if you have activated all sections. Perhaps somebody wants to look into the code to make some performance tuning.

Other idea is, to add an additional field in the database where the index with a timestamp is saved an is only generated each x hours or each day when the profile is visited first.
Do you understand what I mean? Sorry for my bad english.

This modification is easy to made.
Perhaps somebody could test the plugin on a big side.

Papi

Bravo!

Really good work Papillon. It work great!

sa247,
Could you share your point system! could we see it in action?

This is a great idea. I'd like to implement that with my Karma points system somehow... Is there a DEMO somewhere?

ok i just put my demo version online to show you that you can integrate a points system - thing is like i mentioned i had to hack the code a little to get it to work...

however as requested am going to redo this and do it based on database queries instead...

I think this will be better overall and easier to install and you will be able to control how many points etc will be allocated via a admin panel

if you register on my site you will see you get a 100 points to start with

if you post in the message board you will get an extra point

if you give someone karma on the message board you will get a point

if someone gives you bad karma you will loose a point

if you invite someone via the invite tab you will gain two points

demo site can be found at www.jaymoreno.com

Post edited by: sa247, at: 2007/08/30 05:57