And now that I have 2 minutes to spare, I'll tell you the simplest way.
First, make a points category in your database by executing the following query:
Code:
alter table accounts add column sitePoints int(3) not null default 0
That will add a whole column where we're going to store the data.
Next, on your website, you're going to have to make sure you have the ability to login and make sure the page recognizes the accounts. If that's not done, you need to code that (probably PHP or HTML depending on how yours is setup).
Once the login page is created, you'll need to basically make a PHP SQL query to be performed when the user performs a certain action (IE. clicks a voting link). I'm not going to go in detail on how to do that, as there's no time and I really shouldn't have to.
You basically need to have that file connect to the database, grab the amount of points the LOGGED IN account has, and then update that amount with however many points you want to award per-action. So basically, you want these queries executed (with modification to accommodate your PHP files, of course):
Code:
select sitePoints from accounts where username = '______';
You'll have to store that into a variable, which would basically be like:
Code:
$oldpoints = 'select sitePoints from accounts where username = '".POST[$username]."';';
That's assuming the command for the file is "POST" and the variable for $username is what your username is stored into.
After that's done, you'll need to basically update the value:
Code:
$newpoints = $oldpoints + x
Where 'x' is however many points you're giving for it.
Now to actually update the values:
Code:
update table accounts set sitePoints = ."$newpoints". where username = ."POST[$username]".;
Of course, I didn't add how to actually query it via PHP, so you'll have to do that yourself. I'm just trying to give you a little guide on what you have to do.
And please, correct the PHP if it's incorrect syntax, because it's really late and I'm rushing like hell to finish typing this. Got work in 5 hours and I have slept in about 54 hours, so I'm a little bugged-out right now.
