Hi all,

I would like to create a point system that can display how many points the user has. But first,

1. I would like to add another column to the php_users table via the phpmyadmin. Will the extra column affects other normal operations?

Extra info:
(My point system is a easy one that just displays the amount of points and can only be updated occasionally by me, through phpmyadmin)

Any comment / help will be appreciated.
Thank you.

__________________

No - it shouldn't affect anything. All calls and database queries should be absolute to the table they call information from. If in doubt, add the new entity to the end of the table so that any relative calls will not be affected.

__________________
John
♫ www.theMouthPiece.com - Brass music discussion
♫ www.DeFuturo.com - Legal discussion and advice for forum & website owners
♫ www.vBXtra.com - All new and exciting vBulletin styles, customisation and conversion

thanks, theMusicMan

I have added a column to the end of the user table and now i'm wondering where should i put the query to pull out the points...i only intend to show them on the viewtopic page (under player's avatar).

Any help / comment will be appreciated.
Thanks.

__________________

Put the code in viewtopic.php en connect it to the function in de template files, so viewtopic_body.tpl should contain the HTML.

__________________
.premodded - Premodded phpBB.

Thanks

I've get it working^^
Sometimes, the response here is better than the phpbb.com..Anyway, i would like to set up a page for my moderator to increment the points. I would like to know is it better to create another new page for this task?

Further help will be appreciated.Thanks.

__________________

Thanks, though this is a small forum, so we have more time to help a user.

Depending on what you prefer, the points hack has a botton to add points in the viewtopic.php (correct me if I'm wrong!).

__________________
.premodded - Premodded phpBB.

Well, wouldn't it depend upon which point system he uses, since some are sloppily coded?

True, but I just know the Cash Mod and the Points Hack (and I think that there are others) both support this feature.

__________________
.premodded - Premodded phpBB.

Thanks for the comments.

I think it would be easier to integrate this into the profile page of the user. Meaning that there will be three predefined image (for incrementing 1, 3, 5 points repsectively) available for the moderator if they view anyone's profile.

Upon clicking the button, the points will be inserted into the database

Now i just need to sort out the following stuff;

1. How to check if the viewer is a moderator? (so that to show point increment image)

2. How to update user table in a new php script? (let say after i click the image for 5 points increment, it will run point.php)

Any further help would be appreciated.

Thanks.

__________________

Not difficult, just make an if statement.
If the userlevel_id is that of an Admin or Mod it will show the images/

You can put a SQL statement in point.php that will update the user table.

__________________
.premodded - Premodded phpBB.