function display_wpmlm_member_profile_search_page() { /*List of members*/ $objCommonClass = new CommonClass(); $sql = "SELECT \n\t\t\tid, user_id, user_key, parent_key, sponsor_key, leg, \n\t\t\tpayment_status, create_date, paid_date \n\t\tFROM \n\t\t\t" . WPMLM_TABLE_USER . " \n\t\tORDER BY id ASC"; $rs = mysql_query($sql); $listArr = array(); if ($rs && mysql_num_rows($rs) > 0) { $i = 0; while ($row = mysql_fetch_array($rs)) { $userInfoArr = $objCommonClass->GetUserInfoById($row['user_id']); $sponsorArr = $objCommonClass->getSponsorName($row['sponsor_key']); $listArr[$i]['username'] = $userInfoArr['userlogin']; $listArr[$i]['userid'] = $row['user_id']; $listArr[$i]['userid_base64'] = base64_encode($row['user_id']); $listArr[$i]['userKey'] = $userInfoArr['userKey']; $listArr[$i]['name'] = $userInfoArr['name']; $listArr[$i]['referrer'] = $userInfoArr['referrer']; $listArr[$i]['sponsorname'] = $sponsorArr; $listArr[$i]['creationDate'] = $userInfoArr['creationDate']; $listArr[$i]['payment_status'] = $userInfoArr['payment_status']; $i++; } } ?> <div class='wrap'> <div id="icon-options-general" class="icon32"></div><h2>Search the Member </h2> <br /> <div class="notibar msginfo"> <a class="close"></a> <p>Use this screen to search the member in the network.</p> </div> <table cellpadding="0" cellspacing="0" border="0" class="stdtable" id="dyntable2"> <colgroup> <col class="con0" style="width: 10%" /> <col class="con1" style="width: 20%" /> <col class="con0" /> <col class="con1" /> <col class="con0" /> <col class="con1" /> </colgroup> <thead> <tr> <th class="head0">User Name</th> <th class="head0">Name </th> <th class="head1">Member Key</th> <th class="head0">Sponsor Name</th> <th class="head1">Sponsor</th> <th class="head1">Status</th> <th class="head0 nosort">View</th> </tr> </thead> <tfoot> <tr> <th class="head0">User Name</th> <th class="head0">Name </th> <th class="head1">Member Key</th> <th class="head0">Sponsor Name</th> <th class="head1">Sponsor</th> <th class="head1">Status</th> <th class="head0 nosort">View</th> </tr> </tfoot> <tbody> <?php foreach ($listArr as $element) { ?> <tr class="gradeX"> <td><?php echo $element['username']; ?> </td> <td><?php echo $element['name']; ?> </td> <td><?php echo $element['userKey']; ?> </td> <td><?php echo $element['sponsorname']; ?> </td> <td><?php echo $element['referrer']; ?> </td> <td class="center"><?php echo $element['payment_status']; ?> </td> <td class="center"><a href="?page=wpmlm-member-profile&tab=dashboard&uid=<?php echo $element['userid_base64']; ?> "><img src="<?php echo WPMLM_ADMIN_IMG_URL; ?> /view.png" alt="View Details" title="View Details" /> </a></td> </tr> <?php } ?> </tbody> </table> </div> <?php }