Gender Stats on Forumhome Addon

This Hack based on the Gender Image In Postbit from tnguy3n but it can change to your Gender Options.
Instructions todo are in the gender_stats_language.txt.

Before install the plugin.xml read the gender_stats_language.txt!

For members which have 2 gender-options (like: Female + Male) take the 2_options.zip
Seen on the first picture.
For members which have 3 gender-options (like: Female + Male + Undisclosed) take the 3_options.zip.
Seen on the second picture.

For members which havn't a gender hack from first boardinstalltime get this query:
Replace fieldX with you fieldID fo gender.

UPDATE `userfield` SET `fieldX` = 'Male' WHERE `fieldX` = ''

On User Profile Field Manager the ProfileField "gender" must be "Set Default:" to Yes.

[Invalid ID]

It gave me the following error, My forum disappeared, so I immediately deleted the plugin to restore my forum:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT( * ) as field7
FROM userfield WHERE field7 = 'Female';

MySQL Error : Unknown column 'field7' in 'where clause'
Error Number : 1054

[SLY LS1]

Originally Posted by Invalid ID

It gave me the following error, My forum disappeared, so I immediately deleted the plugin to restore my forum:


Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT( * ) as field7
FROM userfield WHERE field7 = 'Female';

MySQL Error : Unknown column 'field7' in 'where clause'
Error Number : 1054

thats because you didnt create a new field and change the field7 to the new field number like field52 ect etc

[geevest.com]

how to insert gender in registration?

[ckgb]

Would be nice to have it ported to 4.2.2