Web Wiz Forums Modifications - Gender Script Question

Print Page | Close Window

Gender Script Question

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=22264
Printed Date: 30 March 2026 at 5:58am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Gender Script Question

Posted By: iaforce
Subject: Gender Script Question
Date Posted: 24 December 2006 at 12:01pm

Scotty32 wrote:

Gender Script
Mod version: V1.03
Mod Download: http://www.s2h.co.uk/wwf/mods/gender_script.asp - Website
Mod Author: Scotty32
Release Date: 13 May 2006

Great Mode..Only I'm using MySQL
any Gender mode for MySQL ??

Replies:

Posted By: Mikey
Date Posted: 24 December 2006 at 1:49pm

Please do not post support questions in the mod index.

[Moved from index to new topic]

-------------
Handyman man?

Posted By: Scotty32
Date Posted: 24 December 2006 at 5:26pm

i think the only thing stopping you from using it on MySQL is the update script to add the field to the database, if you have access to the db, you can always add an Int field to the "tblAuthor" table and call the field "Gender_Mod"

also if your using 8.05, best to wait as it was only updated for 8.04 and changes to WebWizForum have been made to the same files.

the next version of this mod will have a MySQL update script with it
and it will be released when i have time to work on it - which will be sometime after christmas

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: iaforce
Date Posted: 25 December 2006 at 10:16am

Hello Scotty
Yep, I'm using ver 8.05

I also have access to the DB.
I created new filed named "Gender_Mod" at Author table.
Data Type= INT ; Not Null ; Default= 0

it should work the same as MSSQL however when I try register or update user gender I keep getting an error.
I do not get an error if its in defaults ("private, 0)

Error Message :

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum/register.asp, line 856

line 856 : .Fields("Gender_Mod") = intGender

When I open the database and change the value (to 1/2), I can see it on the profile.
however, I can not create or update from the forum itself . I keep getting the error.

If you can come with any idea or with a script for MySQL, you will make someone happy ... :)

Happy Holiday !!

Posted By: Scotty32
Date Posted: 28 December 2006 at 1:09pm

This mod has been updated to be compatible with the latest version of web wiz forums (Version 8.05).

am sorry i was unable to release a MySQL update file as i dont have a MySQL forum to test it on - i did create a file but i havent tested it. If anyone would like to be my Ginni pig send me a PM - once the update file is sorted i'll add it to the release.

and iaforce - your problem is to do with the SQL statement - use the latest file and it should work fine.

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: iaforce
Date Posted: 28 December 2006 at 8:17pm

The problem was whitin the code itself

at page " forum_posts.asp "

Instade your line : '20 = tblAuthor.Gender

I have changed the line to '20 = tblAuthor.Gender_Mod (don't know how I missed that)

everything works fine now

anyway, I'll check your update aswell.

Many thanks for the code

Posted By: Scotty32
Date Posted: 29 December 2006 at 9:44am

the above line you mention i think i spotted in the upgrade.

but thats just a comment and bares no relivence to the page (in terms of coding) so it wouldnt course any problems

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: Ali Bilgrami
Date Posted: 30 December 2006 at 11:51pm

I am facing the same problem i.e

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/forum2/register.asp, line 883

Line 883 = .Fields("Gender_Mod") = intGender

I did update from the latest version of your mod as I too am using 8.05. Though I did not rewrite the file but only inserted the code of your mod. any ideas???

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

Posted By: Scotty32
Date 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.

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: Ali Bilgrami
Date 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 & " " & " " & "<img src=""" & strImagePath & "m.gif"">")
 Elseif intGender = 2 then
 Response.Write (vbCrLf & " " & " " & "<img src=""" & strImagePath & "f.gif"">")
 Else
 Response.Write(vbCrLf & " " & " " & strTxtGenderTitle & ": " & strTxtGenderPrivate)
 End if

-------------

in forum_posts.asp it always shows the gender:Private...

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

Posted By: Ali Bilgrami
Date 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!

Posted By: Ali Bilgrami
Date 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!

Posted By: amuleth
Date 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.

Posted By: Scotty32
Date 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?

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .

Posted By: amuleth
Date 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.

Posted By: Scotty32
Date 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 - http://forums.webwiz.net/forum_posts.asp?TID=17689

-------------
S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins

For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum .