Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Add fields to MEMBERS_PENDING?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ahdkaw
Starting Member

United Kingdom
13 Posts
Posted - 11 January 2003 :  06:47:07  Show Profile  Visit ahdkaw's Homepage
I recently installed the excellent Email Verification mod to my Snitz forum, thanks to irritants such as nasty posts, and ridiculous amounts of registrations from the same person.

However, as I already have other mods installed (including an Avatar mod, Active Users mod, and a Poll mod), I have noticed that if a new member registers and they choose their avatar, upon verifying their email address, the avatar is not passed to the MEMBERS table, but this is down to MEMBERS_PENDING table not storing that information in the first place.

So my question is this: Is there anyway to add the fields I require to the MEMBERS_PENDING by use of a SQLstring? I would manually add them through Access but I have Access2000 and it will not allow me to convert the Snitz database.

The following fields are what is required in the MEMBERS_PENDING table:
M_AUHIDE (Active User mod)
M_AVATAR_URL (Avatar mod)

Thanks in advance

Hamlin
Advanced Member

United Kingdom
2386 Posts
Posted - 11 January 2003 :  07:42:41  Show Profile
You could create a dbs file and add something like this


MEMBER PENDING CHANGE
[ALTER]
MEMBERS_PENDING
ADD#M_AVATAR_URL#varchar (255)#NULL#
ADD#M_AUHIDE#varchar(1)#NULL#
[END]


Then run the dbs file from the admin options panel, the new fields should then be added to the database.
Go to Top of Page

GauravBhabu
Advanced Member

4288 Posts
Posted - 11 January 2003 :  08:03:47  Show Profile
You can also use Alternative Mod setup from Admin Panel
Add the following code in the textarea and Press submit. That will create the required fields.


[ALTER]
MEMBERS_PENDING
ADD#M_AVATAR_URL#varchar (255)#NULL#
ADD#M_AUHIDE#varchar(1)#NULL#
[END]




Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts
Posted - 11 January 2003 :  08:10:35  Show Profile
quote:

You can also use Alternative Mod setup from Admin Panel

Pre 3.4.X.X forums will not have this link will they? And ahdkaw had to add the email validation mod on his own so he cant be using 3.4.X.X...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07