[Lesane]

Originally posted by Reeve of shinra
First, back up your forum!

To set the defaul value as zero this is what you need to do:

1. Find out the # of the custom field you created to use for the 'points' (you should already know this if its installed).

2. Go into PhPmyAdmin (which your webhost likely provides).

3. On the left frame should be a list of databases, look for vbulletin, or VB, or forum or whatever you set yours up as during the install.

4. Click the plus button to expand the directory for your VB and look for a link that says 'userfield' and click on it.

5. The right frame should now have a list of all your custom profile fields. Look for the one you created. If this was your first it should be field5.

6. Click 'change'

7. Where is says 'TYPE' click the drop down box under it and change it to 'INT'

8. Change 'Null' to 'Not Null'

9. For 'Default' Put in 0.


Click Save and your set.

That worked great, thanks "Palmer of Shinra".