Thread: Counters for male and female

Here is the code to diplay the number of couples in your admin panel.
(For male/female see this post.)

// number of coupled members

$couple_arr = db_arr( 'SELECT COUNT(ID) FROM Profiles where profiletype = "couple" ' );


and

<tr class="text">
<td class="text" bgcolor="#ffffff" align="left" valign="middle"><img src=images/arrow.gif> Couples</td>
<td width="50" bgcolor="ffffff" align="right"><? echo $couple_arr[0]; ?></td>
</tr>


Todd

After looking at the code and wondering why my table numbers were not adding up I changed the code for determining how many male and female members you have registered...

The old code does not filter out male and females from the couples.
This code will tell you how many single males and single females are registered.

Used with the couples code below gives an accurate count of members and their status.

// number of Male Members
$male_arr = db_arr( 'SELECT COUNT(ID) FROM Profiles where sex = "male" AND ProfileType = "single" ' );

// number of Female Members
$female_arr = db_arr( 'SELECT COUNT(ID) FROM Profiles where sex = "female" AND ProfileType = "single" ' );

Enjoy.

Todd

thanks very much...really worked well, you should post this in the mods part.
Thanks!

Originally Posted by Greggers

Add the following to index.php:

Below:

Code:

$members_online = get_users_online_number();

Add:

Code:

// number of Single Male Members
$male_single_arr = db_arr( 'SELECT COUNT(ID) FROM Profiles where ProfileType = "Single" AND sex = "male" ' );
// number of Single Female Members
$female_single_arr = db_arr( 'SELECT COUNT(ID) FROM Profiles where ProfileType = "Single" AND sex = "female" ' );
// number of Couple Profiles
$couple_arr = db_arr( 'SELECT COUNT(ID) FROM Profiles where ProfileType = "Couple" ' );

Below:

Code:

  $out .= "<tr><td width=17 align='right'><img src=$site[images]us6.gif></td><td width=100% align=\"left\">&nbsp;"._t("_Total")." - $total_arr[0]</td></tr>\n";

Add:

Code:

//show Female, Male & Couple Numbers
$out .= "<tr><td width=17 align='right'><img src='$site[images]us2.gif'></td><td width=100% align=\"left\">&nbsp;"._t("_Female")." -  $male_single_arr[0]</td></tr>\n";
$out .= "<tr><td width=17 align='right'><img src='$site[images]us3.gif'></td><td width=100% align=\"left\">&nbsp;"._t("_Male")." - $female_single_arr[0] </td></tr>\n";
$out .= "<tr><td width=17 align='right'><img src='$site[images]us3.gif'></td><td width=100% align=\"left\">&nbsp;"._t("_Couple")." - $couple_arr[0] </td></tr>\n";

In your English-lang.php add

Code:

case '_Couple': return 'Couple';

Can be seen in action at http://www.adultonlydating.com/index1.php

Great Mod Greggers works really well with Dolphin - Version of current script is 5.6.0004
After changing code a bit and where you put it.
If anyone wants the mod let me know and I post it.

http://www.expertzzz.com/Downloadz/view/1644

Here the mod for 6.x