• I’ve written this piece of code and when I want to load it in WP admin I have to sign in again! what’s wrong?

    <?php
    
    function bedehkar_page() {
    
    	global $pagenow, $wpdb;
    
    	if($pagenow == 'admin.php' && $_GET['page'] == 'bedehkar' ){
    
    //		$R_delete = @$_GET['delete_id'];
    //
    //		if(is_numeric($R_delete)){
    
    //			$Check_Order = $wpdb->get_results("SELECT id FROM ".$wpdb->prefix."ticket_title WHERE id = '$R_delete'");
    //
    //			if($Check_Order){
    //
    //				foreach ($Check_Order as $row ) {
    //					$Get_ID = $row->id;
    //				}
    //
    //				$sql = $wpdb->query("DELETE FROM ".$wpdb->prefix."ticket_title WHERE id = '$R_delete'");
    //
    //				if($sql){
    //
    //					$sql = $wpdb->query("DELETE FROM ".$wpdb->prefix."ticket_body WHERE title_id = '$R_delete'");
    //
    //					if($sql){
    //						$msg[] = "???? ???? ??? ??? ?? ?????? ???? ??? ?????";
    //					}
    //
    //				}
    //
    //			}
    //
    //		}
    //
    		//======================================================================
    
    		$Limit = "40";
    
    		$R_page     = @$_GET['my-page'];
    		$R_w_search = @$_POST['w_search'];
    		$R_close    = @$_REQUEST['close'];
    
    		$records = $wpdb->get_results("SELECT u.ID
    											  FROM ".$wpdb->prefix."users AS u
    
    											  LEFT JOIN ".$wpdb->prefix."usermeta AS m
    											  ON u.ID = m.user_id
    
    											  WHERE (u.user_email LIKE '%$R_w_search%') and m.meta_key='balance' and m.meta_value < 0");
    		if($records){
    
    			$R_this_page = $R_page;
    			$Total_Rec   = $wpdb->num_rows;
    			$Suffix      = "./admin.php?page=bedehkar&my-page=";
    
    			list($R_this_page, $Total_page, $Limitvalue) = GetPageNumber ($R_this_page, $Total_Rec, $Limit);
    
    			$Page_NeBa = ($Total_page != "1")? PageListNextBack ($R_this_page, $Total_page, $Limit, $Total_Rec, $Suffix) : "";
    
    		}
    
    		//Select Record
    		//======================================================================
    
    		$records = $wpdb->get_results("SELECT *
    											  FROM ".$wpdb->prefix."users AS u
    
    											  LEFT JOIN ".$wpdb->prefix."usermeta AS m
    											  ON u.ID = m.user_id
    
    											  WHERE (u.user_email LIKE '%$R_w_search%') and m.meta_key='balance' and m.meta_value < 0
                                                                                              ORDER BY convert( m.meta_value, decimal ) asc
    											  LIMIT $Limitvalue, $Limit");
    
    		$My_Record = "";
    
    		if($records){
    
                $C = $Limitvalue;
    
    			foreach ( $records as $record ) {
    
                    $C++;
    
    				$V_id              = $record->id;
    				$V_user_id         = $record->user_id;
    				$V_user_email      = $record->user_email;
    				$V_user_balance    = $record->meta_value;
    
    				$V_last_name       = get_the_author_meta( 'last_name', $V_user_id ); //Get name from wordpress db
    
    				//===================================================
    
    				//===================================================
    
    				$Class = ($C % 2 == 0)? 'td_02' : 'td_01';
    
    				//===================================================
    
    				$My_Record .= "\n
    				 			   <tr class='$Class'>
    
    							   		<td height='35' align='center'>$C</td>
    
    									<td height='35' class='title column-title'>
                                            <span>$V_last_name</span>
    									</td>
    
    									<td height='35' class='title column-title'>
                                            <span><a href=\"./user-edit.php?user_id=$V_user_id\" target=\"_blank\">$V_user_email</a></span>
    									</td>
    
    									<td height='35' class='title column-title'>
                                            <span>$V_user_balance</span>
    									</td>
    
                          		   </tr>
    							   \n";
    
    			}
    
    		}
    		//========================================================================
    
    ?>		
    
       <style type="text/css">
    
    	   a {
    			text-decoration: none;
    	   }
    
    	   .title {
    			font: bold normal 12px Tahoma, Geneva, sans-serif;
    			color: #F00;
    	   }
    
    	   .star {
    			color: #F00;
    	   }
    
    	   .normal {
    	       font: normal 12px Tahoma, Geneva, sans-serif;
    	       text-decoration: none;
    	       color: #00F;
    	   }
    
    	   .blue {
    	       color: #00F;
    	   }
    
    	   .green {
    	       color: #090;
    	   }
    
    	   .red {
    	       color: #F00;
    	   }
    
    	   .row-actions {
    	       font: normal 11px Tahoma, Geneva, sans-serif;
    	       margin-top: 10px;
    	   }
    
    	   .msg {
    	       padding: 5px;
    	       margin-top: 10px;
    	       margin-bottom: 10px;
    	       border: 1px solid #FFAEAE;
    	       background: #FFECEC;
    	   }
    
    	   .wp-list-table thead {
    		   background: #CCC;
    	   }
    
    	   .td_01 {
    			background: #F9F9F9;
    	   }
    
    	   .td_02 {
    			background: #FFF;
    	   }
    
    	   .link-box {
    		   margin: 0px;
    	   }
    
    	   .link-box .item {
    			float: right;
    			width: 60px;
    			height: 60px;
    			border: 1px solid #D1D1D1;
    			margin-bottom: 10px;
    			margin-left: 30px;
    			display:block;
    			color:#fff;
    	   }
    
       	   .link-box .item span{
    			float: left;
    			border: 1px solid linen;
    			display:block;
    			border-radius:5px;
    			background:none repeat scroll 0 0 brown;
    			color:#ffff;
    			margin:3px;
    			padding:1px;
    	   }	   
    
    	   .link-box .select-item {
    	   		border: 1px solid #F00;
    	   }
    
    	   .link-box .link_06 {
    		   background: url(<?php bloginfo('template_url'); ?>/images/list-icon.png) no-repeat -427px -2px;
    	   }
    
    	   .link-box .link_07 {
    		   background: url(<?php bloginfo('template_url'); ?>/images/list-icon.png) no-repeat -513px -2px;
    	   }
    
        </style>
    
    	<table width="100%" border="0" cellspacing="1" cellpadding="1">
    
              <tr>
                <td height="25">
                    <?php if(!empty($msg)){ ?>
     					 <div class="msg">
                    	<?php
                        	foreach ($msg as $v => $k){
            					echo $k."<br />";
            				}
                   		?>
                    	</div>
                	<?php } ?>
                </td>
              </tr>
    
              <form action="admin.php?page=bedehkar" method="post">
              <tr>
                <td height="10">
                	<input name="w_search" type="text" value="<?php echo $R_w_search; ?>" />
                    <input name="search-btn" type="submit" value="*?????" class="button-primary" />
                </td>
              </tr>
              </form>
    
              <tr>
                <td height="40">
    
                    <table class="wp-list-table widefat fixed posts" cellspacing="0">
                      <thead>
                          <tr>
    
                          	<td height="40" width="40" align="center"><b>????</b></td>
    
                            <td width="120"><b>??? ?????</b></td>
    
                            <td width="170"><b>?????</b></td>
    
                            <td width="150"><b>??????</b></td>
    
                          </tr>
                       </thead>
    
                       <tbody id="the-list">
                          <?php echo $My_Record; ?>
                       </tbody>
    
                    </table>
    
                </td>
              </tr>
    
              <?php if($Total_page != "1"){ ?>
              <tr>
              	<td height="45" style="padding:2px 0px 0px 5px;" align="left"><?php echo  $Page_NeBa; ?></td>
              </tr>
            <?php  } ?>
    
        </table>
    
    <?php 
    
    	}
    
    }
    
    ?>

    GetPageNumber and PageListNextBack are simple functions for pagination.

  • The topic ‘Why loading this code need login?’ is closed to new replies.