| Author |
 Topic Search  Topic Options
|
Scotty32 
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 31 December 2006 at 2:21pm |
i already answered the problem in my post below it. you need to add the field to the SQL statement. if you look at line 704 of my mods register.asp file you will see
'## Gender Mod ##
'Intialise the strSQL variable with an SQL string to open a record set for the Author table
strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Group_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Real_name, " & strDbTable & "Author.User_code, " & strDbTable & "Author.Password, " & strDbTable & "Author.Salt, " & strDbTable & "Author.Author_email, " & strDbTable & "Author.Homepage, " & strDbTable & "Author.Location, " & strDbTable & "Author.MSN, " & strDbTable & "Author.Yahoo, " & strDbTable & "Author.ICQ, " & strDbTable & "Author.AIM, " & strDbTable & "Author.Occupation, " & strDbTable & "Author.Interests, " & strDbTable & "Author.DOB, " & strDbTable & "Author.Signature, " & strDbTable & "Author.No_of_posts, " & strDbTable & "Author.No_of_PM, " & strDbTable & "Author.Join_date, " & strDbTable & "Author.Avatar, " & strDbTable & "Author.Avatar_title, " & strDbTable & "Author.Last_visit, " & strDbTable & "Author.Time_offset, " & strDbTable & "Author.Time_offset_hours, " & strDbTable & "Author.Date_format, " & strDbTable & "Author.Show_email, " & strDbTable & "Author.Attach_signature, " & strDbTable & "Author.Active, " & strDbTable & "Author.Rich_editor, " & strDbTable & "Author.Reply_notify, " & strDbTable & "Author.PM_notify, " & strDbTable & "Author.Skype, " & strDbTable & "Author.Login_attempt, " & strDbTable & "Author.Banned, " & strDbTable & "Author.Info, " & strDbTable & "Author.Gender_Mod " &_
"FROM " & strDbTable & "Author" & strRowLock & " " & _
"WHERE " & strDbTable & "Author.Author_ID = " & lngUserProfileID & ";"
'## Gender Mod ## |
you need to add the part in red to your file.
|
|
|
 |
Ali Bilgrami
Senior Member
Joined: 14 April 2005
Location: Pakistan
Status: Offline
Points: 492
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 December 2006 at 8:32pm |
ok...thanks, its working in register.asp now...but a new problem im facing here....in member_profile I see the gender change even with an image...but the forum_posts.asp is showing no signs of change 
here is the code for showing the gender in member_profile.asp
--------
><% = strTxtGenderTitle %>:</td> <td><% If strGender = "" Or isNull(strGender) Then Response.Write(strTxtGenderPrivate) Elseif intGender = 1 then Response.Write("<img src=""" & strImagePath & "m.gif"">" & strGender) Elseif intGender = 2 then Response.Write("<img src=""" & strImagePath & "f.gif"">" & strGender) End if -------------
in forum_posts.asp it is...
---------------
'Display the post authors gender If intGender = 1 then Response.Write (vbCrLf & " <br />" & "<br />" & "<img src=""" & strImagePath & "m.gif"">") Elseif intGender = 2 then Response.Write (vbCrLf & " <br />" & "<br />" & "<img src=""" & strImagePath & "f.gif"">") Else Response.Write(vbCrLf & " <br />" & "<br />" & strTxtGenderTitle & ": " & strTxtGenderPrivate) End if -------------
in forum_posts.asp it always shows the gender:Private...
|
|
Lets!
|
|
Ali Bilgrami
Senior Member
Joined: 14 April 2005
Location: Pakistan
Status: Offline
Points: 492
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 December 2006 at 8:35pm |
|
I tried the member_profile.asp code in forum_posts.asp too but its always the same...
|
|
Lets!
|
|
Ali Bilgrami
Senior Member
Joined: 14 April 2005
Location: Pakistan
Status: Offline
Points: 492
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 December 2006 at 8:45pm |
k, forget about all that 
my mistake...needed to change the sarry value as it was using the same from topics count both given 20 ...
|
|
Lets!
|
|
amuleth
Newbie
Joined: 20 February 2007
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 February 2007 at 1:34pm |
|
I try to use 1.04 but whenever I click the submit button appears a blank page. DB path is correct. I don't know why does this happen.
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 February 2007 at 5:58pm |
|
could you please explain your problem a bit more?
which page is the "submit" button on?
which database are you using?
what version of webwizforum are you using?
|
|
|
|
amuleth
Newbie
Joined: 20 February 2007
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 May 2007 at 9:34pm |
|
I use access and 8.05a.
I'm talking about ms_access_update.asp
I wrote the path like this: database/forum.mdb
but appears only a blank page when I press "run update" button.
Edited by amuleth - 02 May 2007 at 9:36pm
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 May 2007 at 10:05pm |
ok, i'll try and investigate this tomorrow. but in the meantime i would advise you to move your forum, as a potential hacker could download your forum. if possible try to move your forum below the root, if you cant, i believe renaming the database to .asp will stop people being able to download it, and the server can still read it as a database. you can get more info by reading this: http://forums.webwiz.net/forum_posts.asp?TID=17689
|
|
|
|
