Author |
Topic |
|
richfed
Average Member
United States
999 Posts |
Posted - 11 May 2003 : 15:29:06
|
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
|
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 |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 12 May 2003 : 05:27:02
|
Appreciated, HuwR ... will give that a go. Can you point me to where you have your forum code available for download?
Thanks. |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 17 May 2003 : 09:24:19
|
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 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 May 2003 : 20:04:29
|
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 |
|
|
richfed
Average Member
United States
999 Posts |
Posted - 21 May 2003 : 05:35:17
|
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] |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 May 2003 : 07:38:07
|
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 |
|
|
richfed
Average Member
United States
999 Posts |
|
|
Topic |
|