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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Converting User Fields MOD Code to Response.Write
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

richfed
Average Member

United States
999 Posts

Posted - 11 May 2003 :  15:29:06  Show Profile  Visit richfed's Homepage
In my old 3.3.05 forum, I had used HuwR's User Field Mod version 2 - and some assistance from MeTV - to both add a field AND have it show up in users' posts [as with rank & stars, country, etc.]. When I upgraded to version 3.4, I of course lost all of that.

However, the field still exists in the database, so I was thinking that members who had inputted data in there via their profile can still have it appear in the posts if I can figure out how to call it. I can't, so I need your help.

The old code [for version 3.3] was two identical bits on topic.asp, one in the topic section & one in the reply section. It was:

<% '########## Added by MeTV ########
if (intUserFields = 1 ) then
set rstemp = My_Conn.Execute("SELECT * FROM " & strMemberTablePrefix & "USERFIELDS ORDER BY USR_FIELD_ID")
do until rstemp.EOF
response.write "<br>"
if rstemp("USR_FIELDTYPE") = "C" then
if getUserFieldValue(rstemp("USR_FIELD_ID"),rsReplies("MEMBER_ID")) = "1" then
response.write "Yes"
Else
response.write "No"
End If
Else
response.write getUserFieldValue(rstemp("USR_FIELD_ID"),rsReplies("MEMBER_ID"))
End If
rstemp.MoveNext
loop
rstemp.Close
set rstemp = nothing
end if
'####################################### %>

How can this code be changed so that it will work in the latest version. I'd also like to use <font size=1>.

Of course, not having a 3.4 version of the User Field Mod, I can't add code to Register & Profile, therefore no one else can have the info, but, for now, that's ok ... looking to call what is there ...

Thanks to anyone!


Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]

Edited by - richfed on 18 May 2003 14:01:26

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 11 May 2003 :  15:47:03  Show Profile  Visit HuwR's Homepage
it should still work fine in the current version, also if you download my forum code you will be able to se where it goes in the 3.4 version of the code
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 12 May 2003 :  05:27:02  Show Profile  Visit richfed's Homepage
Appreciated, HuwR ... will give that a go. Can you point me to where you have your forum code available for download?

Thanks.
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 17 May 2003 :  09:24:19  Show Profile  Visit richfed's Homepage
Well, I placed the above code - minus the <% %> - in two places so that the data from the added field would show up just above the COUNTRY. However, the was no change whatsoever ... no error message, no new text ... nothing. So, I'm thinking that more changes need to be made on topic.asp so that the above code knows what its looking for? Maybe under the "set rsTopic" area?

Can anyone assist me on this? USER_7 is the field I'm trying to call. I need a lot of help with this ...

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]

Edited by - richfed on 18 May 2003 14:04:21
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 18 May 2003 :  20:04:29  Show Profile  Visit HuwR's Homepage
you need to look in pop_profile most likely to see how it retrieves the data, there are a couple of functions, but don't remember off hand what they are sorry
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 21 May 2003 :  05:35:17  Show Profile  Visit richfed's Homepage
That's ok, HuwR ... I've lived without it since upgrading back in November. My choice!

Doesn't sound right about pop_profile, though. You see, I've made no changes to my current Snitz files as far as the User Field mod goes. There is simply data retained in the database that was inputed before I upgraded.

I'm trying to figure out how to call that info on topic.asp - to show with the poster's info, ala avatars, country, number of posts, etc.

The above code, as I said, produces no results whatsoever, so I think something more needs done on topic.asp.

Who the heck knows!?! :)

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 21 May 2003 :  07:38:07  Show Profile  Visit HuwR's Homepage
if you download the latest code from my site www.magicmushroom.org.uk and look in pop_profile, it will show you how to retrieve the user field info you need
Go to Top of Page

richfed
Average Member

United States
999 Posts

Posted - 25 May 2003 :  05:44:28  Show Profile  Visit richfed's Homepage
Probably over my head - I'm pretty much a copy & paste kind of guy [with direction!] - but I'm going to go download your code & see what I can see.

If you don't hear from me in a while, I'm buried!

Thanks, Huw.

Rich
[size=1]A Complete Idiot's Guide to MOD Implementation || On the Trail of the Last of the Mohicans[/size=1]
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.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07