function adminViewUnilevelNetwork($id)
{
    $table_prefix = mlm_core_get_table_prefix();
    //$obj = new UnilevelTree();
    global $wpdb;
    get_currentuserinfo();
    //get no. of level
    $mlm_general_settings = get_option('wp_mlm_general_settings');
    $mlm_no_of_level = $mlm_general_settings['mlm-level'];
    $res = mysql_fetch_array(mysql_query("SELECT user_key FROM {$table_prefix}mlm_users WHERE user_id = '" . $id . "'"));
    $total = mysql_fetch_array(mysql_query("SELECT count(*) as num FROM {$table_prefix}mlm_hierarchy WHERE pid = '" . $res['user_key'] . "'"));
    $total = $total['num'];
    $member_page_id = $wpdb->get_var("SELECT id FROM {$table_prefix}posts  WHERE `post_content` LIKE '%mlm-view-child-level-member%'\tAND `post_type` != 'revision'");
    if (!empty($_GET['lvl']) && $_GET['lvl'] != '') {
        $level = $_GET['lvl'];
        $level_data = getLevelInfo($res['user_key'], $level);
        ?>
	 
	
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
  google.load('visualization', '1', {packages: ['table']});
</script>
<script type="text/javascript">
var visualization;
var data;
var options = {'showRowNumber': true};
function drawVisualization() {
  // Create and populate the data table.
  var dataAsJson =
  {cols:[
	{id:'A',label:'<?php 
        echo _e("Username", "unilevel-mlm-pro");
        ?>
',type:'string'},
	{id:'B',label:'<?php 
        echo _e("First Name", "unilevel-mlm-pro");
        ?>
',type:'string'},
	{id:'C',label:'<?php 
        echo _e("Last Name", "unilevel-mlm-pro");
        ?>
',type:'string'},
    {id:'D',label:'<?php 
        echo _e("Sponsor", "unilevel-mlm-pro");
        ?>
',type:'string'},
	{id:'E',label:'<?php 
        echo _e("Email", "unilevel-mlm-pro");
        ?>
',type:'string'},
    {id:'F',label:'<?php 
        echo _e("Status", "unilevel-mlm-pro");
        ?>
',type:'string'}],
  rows:[
  <?php 
        for ($i = 0; $i < count($level_data); $i++) {
            ?>
                        {c:[{v:'<?php 
            echo $level_data[$i]['username'];
            ?>
'},
                        {v:'<?php 
            echo $level_data[$i]['first_name'];
            ?>
'},
                        {v:'<?php 
            echo $level_data[$i]['last_name'];
            ?>
'},
                        {v:'<?php 
            echo $level_data[$i]['sponsor'];
            ?>
'},
						{v:'<?php 
            echo $level_data[$i]['email'];
            ?>
'},
                        {v:'<?php 
            echo $level_data[$i]['status'];
            ?>
'}]},
  <?php 
        }
        ?>
  ]};
  data = new google.visualization.DataTable(dataAsJson);
  // Set paging configuration options
  // Note: these options are changed by the UI controls in the example.
  options['page'] = 'enable';
  options['pageSize'] = 10;
  options['pagingSymbols'] = {prev: 'prev', next: 'next'};
  options['pagingButtonsConfiguration'] = 'auto';
  //options['allowHtml'] = true;
  //data.sort({column:1, desc: false});
  // Create and draw the visualization.
  visualization = new google.visualization.Table(document.getElementById('table'));
  draw();
}
function draw() {
  visualization.draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
// sets the number of pages according to the user selection.
function setNumberOfPages(value) {
  if (value) {
	options['pageSize'] = parseInt(value, 10);
	options['page'] = 'enable';
  } else {
	options['pageSize'] = null;
	options['page'] = null;  
  }
  draw();
}
// Sets custom paging symbols "Prev"/"Next"
function setCustomPagingButtons(toSet) {
  options['pagingSymbols'] = toSet ? {next: 'next', prev: 'prev'} : null;
  draw();  
}
function setPagingButtonsConfiguration(value) {
  options['pagingButtonsConfiguration'] = value;
  draw();
}
</script>
<!--va-matter-->
    <div class="va-matter">
    	<!--va-matterbox-->
    	<div class="va-matterbox">
        	<!--va-headname-->
        	<div class="va-headname"><strong><?php 
        _e('Level ' . $level . ' Members', 'unilevel-mlm-pro');
        ?>
</strong></div>
            <!--/va-headname-->
			<div class="va-admin-leg-details">
            	<!--va-admin-mid-->
				<div class="paging">
				  <form action="">
					<div class="left-side" style="width:30%;float:left;">
						<?php 
        _e('Display Number of Rows', 'unilevel-mlm-pro');
        ?>
 : &nbsp; 
					</div>
					<div class="right-side">
						<select style="font-size: 12px" onchange="setNumberOfPages(this.value)">
						  <option value="5">5</option>
						  <option selected="selected" value="10">10</option>
						  <option value="20">20</option>
						  <option  value="50">50</option>
						  <option value="100">100</option>
						  <option value="500">500</option>
						   <option value="">All</option>
						</select>
					</div>	
					</form>
					<div class="right-members">
					<?php 
        _e('Total Records', 'unilevel-mlm-pro');
        ?>
: <strong><?php 
        echo count($level_data);
        ?>
</strong>
					</div>
					<div class="va-clear"></div>
				  </div>
				<div id="table"></div>
				<div class="va-clear"></div>
			</div>		
		</div>
	</div>	
	
	 
	 
<?php 
    } else {
        ?>

 		<table border="0" cellspacing="5" cellpadding="5" width="50%">
			<TR>
			<TD align="center" ><strong><?php 
        _e('Levels', 'unilevel-mlm-pro');
        ?>
</strong></TD>
			<TD align="center" > <strong><?php 
        _e('No. of Members', 'unilevel-mlm-pro');
        ?>
</strong></TD>
			</TR>
		<?php 
        for ($j = 1; $j <= $mlm_no_of_level; $j++) {
            if (returncountLevelMember($res['user_key'], $j) == 0) {
                $num = "Level " . $j;
            } else {
                $num = "<a href='?page=mlm-user-account&ac=network&lvl=" . $j . "'> Level " . $j . "</a>";
            }
            ?>
		<TR>
			<TD align="center" ><strong><?php 
            _e($num, 'unilevel-mlm-pro');
            ?>
</strong></TD>
			<TD align="center" > <?php 
            _e(returncountLevelMember($res['user_key'], $j), 'unilevel-mlm-pro');
            ?>
</TD>
			</TR>
		    
			<?php 
        }
        ?>
 
        <TR>
			<TD align="center" ><strong><?php 
        _e('Total', 'unilevel-mlm-pro');
        ?>
</strong></TD>
			<TD align="center" > <?php 
        _e($total, 'unilevel-mlm-pro');
        ?>
</TD>
			</TR>			
		</table>
		
<?php 
    }
}
Example #2
0
<?php

$LEVELNAME = "hacklandsecurityagency";
$LEVELANSWER = "bbroygbvgw";
$LEVELPOINTS = "";
$LEVELFLAG = "..";
$USERLOGGEDIN = false;
require_once "../session.inc.php";
$LEVELINFO = getLevelInfo($LEVELNAME);
$LEVELID = getLevelId($LEVELNAME);
$ANSWERSTATUS = "";
$WIN = false;
if (isset($_POST["level{$LEVELID}_passkey"])) {
    if ($_POST["level{$LEVELID}_passkey"] == $LEVELANSWER) {
        $ANSWERSTATUS = "Congratulations! {$LEVELPOINTS} have been added to your score. <a href='../'>Click here</a>";
        require_once "../mysql.inc.php";
        updateUserWin($LEVELNAME, $LEVELPOINTS);
        $WIN = true;
    } else {
        $ANSWERSTATUS = "Wrong Answer!";
        require_once "../mysql.inc.php";
        updateUserLost($LEVELNAME);
    }
}
$BODY = <<<BODY
<div id=startcontent>
<h2>LEVEL {$LEVELID}</h2>


BODY;
if ($WIN == false) {
function mlm_my_child_member_details_page()
{
    $table_prefix = mlm_core_get_table_prefix();
    $error = '';
    global $current_user;
    get_currentuserinfo();
    $sponsor_name = $current_user->user_login;
    if (!empty($_GET['lvl']) && $_GET['lvl'] != '') {
        $level = $_GET['lvl'];
    }
    $res = mysql_fetch_array(mysql_query("SELECT user_key FROM {$table_prefix}mlm_users WHERE username = '******'"));
    $level_data = getLevelInfo($res['user_key'], $level);
    ?>
 
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
  google.load('visualization', '1', {packages: ['table']});
</script>
<script type="text/javascript">
var visualization;
var data;
var options = {'showRowNumber': true};
function drawVisualization() {
  // Create and populate the data table.
  var dataAsJson =
  {cols:[
	{id:'A',label:'<?php 
    echo _e("Username", "unilevel-mlm-pro");
    ?>
',type:'string'},
	{id:'B',label:'<?php 
    echo _e("First Name", "unilevel-mlm-pro");
    ?>
',type:'string'},
	{id:'C',label:'<?php 
    echo _e("Last Name", "unilevel-mlm-pro");
    ?>
',type:'string'},
    {id:'D',label:'<?php 
    echo _e("Sponsor", "unilevel-mlm-pro");
    ?>
',type:'string'},
	{id:'E',label:'<?php 
    echo _e("Email", "unilevel-mlm-pro");
    ?>
',type:'string'},
    {id:'F',label:'<?php 
    echo _e("Status", "unilevel-mlm-pro");
    ?>
',type:'string'}],
  rows:[
  <?php 
    for ($i = 0; $i < count($level_data); $i++) {
        ?>
                        {c:[{v:'<?php 
        echo $level_data[$i]['username'];
        ?>
'},
                        {v:'<?php 
        echo $level_data[$i]['first_name'];
        ?>
'},
                        {v:'<?php 
        echo $level_data[$i]['last_name'];
        ?>
'},
                        {v:'<?php 
        echo $level_data[$i]['sponsor'];
        ?>
'},
						{v:'<?php 
        echo $level_data[$i]['email'];
        ?>
'},
                        {v:'<?php 
        echo $level_data[$i]['status'];
        ?>
'}]},
  <?php 
    }
    ?>
  ]};
  data = new google.visualization.DataTable(dataAsJson);
  // Set paging configuration options
  // Note: these options are changed by the UI controls in the example.
  options['page'] = 'enable';
  options['pageSize'] = 10;
  options['pagingSymbols'] = {prev: 'prev', next: 'next'};
  options['pagingButtonsConfiguration'] = 'auto';
  //options['allowHtml'] = true;
  //data.sort({column:1, desc: false});
  // Create and draw the visualization.
  visualization = new google.visualization.Table(document.getElementById('table'));
  draw();
}
function draw() {
  visualization.draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
// sets the number of pages according to the user selection.
function setNumberOfPages(value) {
  if (value) {
	options['pageSize'] = parseInt(value, 10);
	options['page'] = 'enable';
  } else {
	options['pageSize'] = null;
	options['page'] = null;  
  }
  draw();
}
// Sets custom paging symbols "Prev"/"Next"
function setCustomPagingButtons(toSet) {
  options['pagingSymbols'] = toSet ? {next: 'next', prev: 'prev'} : null;
  draw();  
}
function setPagingButtonsConfiguration(value) {
  options['pagingButtonsConfiguration'] = value;
  draw();
}
</script>
<!--va-matter-->
    <div class="va-matter">
    	<!--va-matterbox-->
    	<div class="va-matterbox">
        	<!--va-headname-->
        	<div class="va-headname"><strong><?php 
    _e('My Level ' . $level . ' Members', 'unilevel-mlm-pro');
    ?>
</strong></div>
            <!--/va-headname-->
			<div class="va-admin-leg-details">
            	<!--va-admin-mid-->
				<div class="paging">
				  <form action="">
					<div class="left-side" style="width:30%;float:left;">
						<?php 
    _e('Display Number of Rows', 'unilevel-mlm-pro');
    ?>
 : &nbsp; 
					</div>
					<div class="right-side">
						<select style="font-size: 12px" onchange="setNumberOfPages(this.value)">
						  <option value="5">5</option>
						  <option selected="selected" value="10">10</option>
						  <option value="20">20</option>
						  <option  value="50">50</option>
						  <option value="100">100</option>
						  <option value="500">500</option>
						   <option value="">All</option>
						</select>
					</div>	
					</form>
					<div class="right-members">
					<?php 
    _e('Total Records', 'unilevel-mlm-pro');
    ?>
: <strong><?php 
    echo count($level_data);
    ?>
</strong>
					</div>
					<div class="va-clear"></div>
				  </div>
				<div id="table"></div>
				<div class="va-clear"></div>
			</div>		
		</div>
	</div>	
		
<?php 
}