Web Wiz Forums Modifications - [MOD] Profile Fields

Print Page | Close Window

[MOD] Profile Fields

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20410
Printed Date: 28 March 2026 at 7:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: [MOD] Profile Fields

Posted By: aks427
Subject: [MOD] Profile Fields
Date Posted: 24 June 2006 at 12:29am

Hey all, I finally got around to converting my Profile Fields mod to WWF 8.

There is a readme file included that has everything you need (unless I missed something).

http://www.codingfx.com/uploads/profilefields_wwf8.zip - http://www.codingfx.com/uploads/profilefields_wwf8.zip

Replies:

Posted By: chicken
Date Posted: 24 June 2006 at 11:41am

i get this when i click on create

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/admin_profile_fields.asp, line 44

Posted By: aks427
Date Posted: 24 June 2006 at 3:55pm

Sorry, I missed a field in the setup. Redownload it and then run the setup again (you'll have to drop tblProfileFields and tblProfileFieldData first).

Posted By: Exis
Date Posted: 24 June 2006 at 5:26pm

Do we have to make all the changes noted in the ReadMe or is there a way of it being done already?

Many Thanks!

Posted By: aks427
Date Posted: 24 June 2006 at 5:57pm

It would probably be better if you just did all the changes yourself, because if those pages are modded it at all, it would mess it up.

If you have totally unaltered register.asp and member_profile.asp files, I could send you the ones with the mod in them.

Posted By: Exis
Date Posted: 24 June 2006 at 6:54pm

If you could do that I would very much appreciate it. I have modded the member_profile.asp somewhat! hehe

Do you have MSN messenger at all?

Regards,

Posted By: aks427
Date Posted: 24 June 2006 at 7:42pm

I just added it to my profile.

I'll send you the register.asp file, but you'll have to modify the member_profile.asp file yourself.

EDIT: Here is a link to download those two files.

http://www.codingfx.com/uploads/register&member_profile.zip - http://www.codingfx.com/uploads/register&member_profile.zip

You won't want to replace the files you have now if you have modified them at all.

Posted By: chicken
Date Posted: 27 June 2006 at 4:32pm

i am running version 8.3 and i get this

Microsoft OLE DB Provider for SQL Server (0x80040E14)
The text, ntext, and image data types cannot be used in an ORDER BY clause.
member_profile.asp, line 499

Posted By: SUJO
Date Posted: 27 June 2006 at 4:52pm

yeah, the ORDER BY used like this here is not correct... I modified it into this:

" ORDER BY f.Order_ID"

to order the fields as you specify it in admin section...

-------------
Who are you? What do you want?

Posted By: aks427
Date Posted: 27 June 2006 at 6:02pm

SUJO is right, it should have been ordering by Order_ID, not FieldType. I have no clue how it got switched, but it is fixed now.

Posted By: Ali Bilgrami
Date Posted: 28 June 2006 at 4:34pm

hi i added the mod and made all changes in the files bt when opened forum_posts.asp in the left cell it gives this error in the first post of topic

ADODB.Recordset error '800a0e79'

Operation is not allowed when the object is open.

/forum2/forum_posts.asp, line 902

and its not scrolling down...what can be the problem?

line 902 is

rsCommon.Open strSQL, adoCon

Posted By: aks427
Date Posted: 28 June 2006 at 4:41pm

Have you modded forum_posts.asp any before this? It seems some other mod is using the rsCommon recordset.

Posted By: Ali Bilgrami
Date Posted: 28 June 2006 at 5:51pm

Sorry...I forgot...I am using the thank mod, which shows rep points in forum_posts.asp, so what shud i do now?

Posted By: aks427
Date Posted: 28 June 2006 at 8:31pm

Move the profile field part out of the thanks mod. Before or after the thanks mod has the rsCommon recordset open.

Posted By: Ali Bilgrami
Date Posted: 29 June 2006 at 8:03am

thanks man, its working like a charm :)

Posted By: Ali Bilgrami
Date Posted: 30 June 2006 at 7:14am

btw is it possible to integrate a picture with a drop down list?

Posted By: aks427
Date Posted: 03 July 2006 at 8:56pm

Um, not with this mod. You'd have to research for yourself to see if you can have pictures with select lists.

Posted By: chicken
Date Posted: 06 July 2006 at 1:30am

could members chave there own colour scheme and background with in the profile page?

Posted By: Ali Bilgrami
Date Posted: 07 July 2006 at 2:15pm

are you talking about the multi-skin mod ?

Btw Andrew, is it possible to show the data from this MOD in member_profile.asp in different section? right now it shows all the fields after the Interests Section.

Posted By: chicken
Date Posted: 07 July 2006 at 4:05pm

Yeah but each member can chose there own scheme for there profile.

Posted By: Ali Bilgrami
Date Posted: 07 July 2006 at 4:17pm

chicken wrote:

Yeah but each member can chose there own scheme for there profile.

chech this thread

http://forums.webwiz.net/forum_posts.asp?TID=20512&PN=2 - http://forums.webwiz.net/forum_posts.asp?TID=20512&PN=2

Posted By: Ali Bilgrami
Date Posted: 11 July 2006 at 10:33pm

hi just had this error

while long registration form enabled

after submitting this occurs

***EDIT II***

and things are going nuts :S just enabled long registration form and this occured

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near 'LIMIT'.

/forum2/register.asp, line 1015

line 1015 is

adoCon.Execute(strSQL)

of custom fields mod

the user gets to registered though...any ideas?

-------------
Lets!

Posted By: aks427
Date Posted: 11 July 2006 at 10:57pm

Are you using MySQL? Otherwise it shouldn't be using LIMIT.

There was a bug in the very first version I posted so that one of the sql querys would use LIMIT instead of TOP, no matter the database.

Posted By: Ali Bilgrami
Date Posted: 12 July 2006 at 7:25pm

i am using MS SQL

-------------
Lets!

Posted By: aks427
Date Posted: 12 July 2006 at 7:28pm

Ok, redo Code Section #2 of the register.asp section in the ReadMe.

Posted By: Ali Bilgrami
Date Posted: 13 July 2006 at 9:10pm

u mean i shud replace limit with top?

-------------
Lets!

Posted By: aks427
Date Posted: 13 July 2006 at 9:13pm

No, redo that whole code section.

Code Section #2 for the register.asp file. If you open the ReadMe file, you will be able to figure it out.

Posted By: chicken
Date Posted: 14 July 2006 at 10:11am

is it possable for people to upload a css file so they can change the look of there own profile ?

Posted By: aks427
Date Posted: 14 July 2006 at 4:19pm

No, but you might be able to make a File field working similar to the image field.

If you did have them be able to upload their own css file, you would have to make sure and split it into more than one, so they can only update one. Otherwise you will have problems with them hiding ads, messing up the general layout, etc.

Posted By: chicken
Date Posted: 18 July 2006 at 12:13pm

true

what about something like faceparty have where users can pick colours and backgrounds from a defult section.

Posted By: ramone_johnny
Date Posted: 13 August 2006 at 1:20am

An explanation of what this mod actually does would be useful.

Posted By: aks427
Date Posted: 13 August 2006 at 2:00am

It lets you create more fields in the profile.

You could think of it as create more fields like 'Interests'.

Posted By: PhilG
Date Posted: 21 August 2006 at 5:28am

Great Mod, I've found it really useful - I'm having one slight problem though - I have a sequence of fields set up: a couple of radio buttons, a select list, a multi-line text field, followed by two image fields...

They all work, but the text and image fields that come after the radio buttons/select list (if the user chooses not to fill them in) are showing the same value as whatever was chosen in the field before them. If a user overwrites these values with their own it's then fine.

To clarify: If a user chooses "Orange" from the select list, then the following text and image fields, will have default value of Orange as well.

Any ideas?

Thanks in advance,

Phil

Posted By: Exis
Date Posted: 24 August 2006 at 11:03pm

Hi Aks427,

Previously you were talking about having some information being displayed in the forum_posts.asp ? Do you have a working mod for this?

Many Thanks!

Posted By: aks427
Date Posted: 25 August 2006 at 4:07am

PhilG, I will definitely look into that.

Exis, it shows how to add those fields in the ReadMe file.

Posted By: Exis
Date Posted: 25 August 2006 at 5:33pm

So it does, sorry about that.

Cheers

Posted By: chicken
Date Posted: 22 December 2006 at 6:30pm

Hi there,

Was just wondering if you could add a section where people can view you buddy list so people can see who if ur friend(s)

Anther thing is it possable for you to add a url to a video like on utube on ur profile?

Posted By: MortiOli
Date Posted: 08 January 2007 at 10:06pm

aks427, brilliant MOD, however having the same problem as PhilG.

Just a suggestion - it would be good if you could have an option to show the field in forum_posts.asp or not. This way people can add the forum_posts.asp code, but can choose if they're to be shown or not.

PS - The WWF link in the readme takes you to a different site - http://www.webwizforum.com/ - http://www.webwizforum.com/ - should be 's' on the end.

Keep up the awesome work!

Posted By: mbd2
Date Posted: 11 January 2007 at 2:26pm

Has anybody tried this in WW8.05 and if so any modifications needed?

-------------
Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video

Posted By: MortiOli
Date Posted: 11 January 2007 at 8:44pm

Yeah, I tested it on 8.05, and it works fine. No extra modifications needed.

Posted By: EvoIX_mr2006
Date Posted: 28 January 2007 at 11:13pm

I installed this mod on WWF 8.05 and the only time it actually saves to the database is when the user edits their profile after they register. If they register with the new profile field filled in, the only thing that occurs it that the input the user typed in is saved for the next user to read...any suggestions?

Posted By: aks427
Date Posted: 30 January 2007 at 6:31pm

Try using this code instead of the code in the ReadMe for register.asp Code Section #2.

  '******************************************
  '***   Create/Update Custom Fields ***
  '******************************************
   Dim rsCustomFields
   Dim rsPortal
   Set rsCustomFields = Server.CreateObject("ADODB.Recordset")
   Set rsPortal = Server.CreateObject("ADODB.Recordset")
   strSQL = "SELECT * FROM " & strDbTable & "ProfileFields"
   rsPortal.Open strSQL,adoCon
   
   if not rsPortal.EOF then
   do until rsPortal.EOF
    If strMode = "new" AND lngUserProfileID = 2 then
     strSQL = "SELECT" & strDBTop1 & " Author_ID FROM " & strDbTable & "Author ORDER BY Author_ID desc" & strDBLimit1
     rsCustomFields.Open strSQL,adoCon
     lngUserProfileID = rsCustomFields("Author_ID")
     rsCustomFields.Close
    End If
    If lngUserProfileID <> 2 then
     If Request.Form("Field" & rsPortal("Field_ID")) = "" then
      strSQL = "DELETE FROM " & strDbTable & "ProfileFieldData WHERE Field_ID = " & rsPortal("Field_ID") & " AND Author_ID = " & lngUserProfileID
      adoCon.Execute(strSQL)
     Else
      strSQL = "SELECT * FROM " & strDbTable & "ProfileFieldData WHERE Field_ID = " & rsPortal("Field_ID") & " AND Author_ID = " & lngUserProfileID
      rsCustomFields.Open strSQL,adoCon,3,3
 
      if rsCustomFields.EOF then
       rsCustomFields.AddNew
      end if

      rsCustomFields("Field_ID") = rsPortal("Field_ID")
      rsCustomFields("Author_ID") = lngUserProfileID
      If rsPortal("FieldType") = 3 then
       rsCustomFields("FieldData") = ", " & Request.Form("Field" & rsPortal("Field_ID")) & ","
      Else
       rsCustomFields("FieldData") = Request.Form("Field" & rsPortal("Field_ID"))
      End if
 
      rsCustomFields.Update
      rsCustomFields.Close
     End If
    End If
   rsPortal.MoveNext
   Loop
   end if
   rsPortal.Close
   
   
   If isObject(rsCustomFields) Then
    Set rsCustomFields = Nothing
   End If
   
   If isObject(rsPortal) Then
    Set rsPortal = Nothing
   End If

Posted By: EvoIX_mr2006
Date Posted: 30 January 2007 at 10:07pm

that threw errors...

Posted By: EvoIX_mr2006
Date Posted: 31 January 2007 at 12:26am

never mind, fixed, thanks!

Posted By: chicken
Date Posted: 01 February 2007 at 2:38pm

is there any way of having more then 7 fields

Posted By: aks427
Date Posted: 01 February 2007 at 3:24pm

Yes, edit the variable at the top of admin_profile_fields.asp