Profile View

    <?php
        if(empty($_REQUEST['enterCodeId'])){

                echo "<script>
                    location.replace('".$_SERVER['HTTP_REFERER']."');
                    </script>";
        }else{
                global $wpdb;
        /*
                $getId=substr($_REQUEST['enterCodeId'], 4, 10);
                $querystr = $wpdb->prepare("SELECT ID FROM wp_7d8ftw_users WHERE ID='%s'",$getId);
                $querystr = "SELECT ID FROM wp_7d8ftw_users WHERE ID='".$getId."'";
        */
        $getId = null;
        $getCode = $_POST['enterCodeId'];
        // please set table name 'wp_usermeta' with you actual table name //wp_7d8ftw_usermeta
                $querystr = $wpdb->prepare("SELECT user_id FROM wp_7d8ftw_usermeta WHERE meta_key='myaccesskey' AND meta_value='%s'",$getCode);
                $querystrChecking = mysql_query($querystr);
                if(mysql_num_rows($querystrChecking)<=0){
                    echo "<script>
                    location.replace('".$_SERVER['HTTP_REFERER']."');
                    </script>";
                }
        elseif ($row = mysql_fetch_assoc($querystrChecking)) {
            $getId = $row['user_id'];
        }
                $uploads = wp_upload_dir();
            //
        }
        ?>
    <?php get_header(); ?>
    <div id="wrapper2nd" class="inner">
        <div class="content" id="inner">

        <h1>PROFILE</h1>
        <div id="profileView">
            <div class="alignLeft">
             <strong> Name:</strong> <?php the_author_meta( 'first_name', $getId ); ?>   <?php the_author_meta( 'last_name', $getId); ?><br />
              <strong> Nick Name:</strong> <?php the_author_meta( 'nickname', $getId ); ?><br />
              <strong>Age:</strong><?php get_the_author_meta( 'dateofbirth', $getId );?><br />
              <strong>Birthday: </strong>
              <?=get_the_author_meta( 'dateofbirth', $getId );?><br />
              <strong>Birthplace:</strong>
              <?=get_the_author_meta( 'birthplace', $getId );?><br />
              <strong>Current City:</strong>
              <?=get_the_author_meta( 'currentcity', $getId );?> <br />
              <strong>Favourite Colour:</strong>
              <?=get_the_author_meta( 'favouritecolour', $getId );?> <br />
              <strong>Favourite Book:</strong>
              <?=get_the_author_meta( 'favouritebook', $getId );?><br />
              <strong>Favourite Film:</strong>
              <?=get_the_author_meta( 'favouritefilm', $getId );?><br />
              <strong>Favourite Restaurant: </strong>
              <?=get_the_author_meta( 'favouriterestaurant', $getId );?><br />
              <strong>Favourite Quote:</strong>
              <?=get_the_author_meta( 'favouritequote', $getId );?><br />
              <strong>Favourite Quality in Women: </strong>
              <?=get_the_author_meta( 'favouritequalityinwomen', $getId );?> <br />
              <strong>My Favourite TV programs: </strong><br />
            <?=get_the_author_meta( 'myfavouritetvprograms', $getId );?><br />
            <strong>My Favourite Groups:</strong><br />
            <?=get_the_author_meta( 'myfavouritegroups', $getId );?><br />
            <strong>My Favourite Links:</strong><br />
            <?=get_the_author_meta( 'myfavouritelinks', $getId );?>

          </div>
             <div class="alignRight">
                <div class="left"><i>About Me:</i>
                    <p> <?=the_author_meta( 'description', $getId); ?></p>
                </div>
                <div class="right">
                    <?php if(get_the_author_meta( 'userphoto_thumb_file', $getId )!=""){?>
                        <img src="<?=$uploads['baseurl'];?>/thumbs/<?=get_the_author_meta( 'userphoto_thumb_file', $getId );?>" />
                    <?php }?>
                <a href="#" class="allpic">see all pictures</a>
                </div>
                <div class="clr"></div>
                <div class="contact"><strong>Contact information:</strong> <?= get_the_author_meta('user_email', $getId );?></div>
             </div>
             <div class="clr"></div>
        </div>
        </div>
    </div>

     <?php if ( is_active_sidebar('inner')): ?>
    <div id="wrapper3rd">
      <div id="innerSidebarContent">
     <?php dynamic_sidebar( 'inner' ); ?>

      </div>
    </div>
    <?php endif; // end sidebar widget area ?>
 <?php get_footer(); ?>