<?PHP
  session_name("m2hp");
  session_start();

  error_reporting(E_ALL&~E_NOTICE);
?>

<?php

	error_reporting(0);
	session_start();
	$serverIp 	= "local";
	$userName 	= "sa";
	$password 	= "PW";
	$dbName1  	= "SRO_VT_ACCOUNT";
	$dbName2  	= "SHARD";
	$dbConn = mssql_connect($serverIp, $userName, $password) or die ("Couldn't connect to server");
	mssql_select_db($dbName1, $dbConn) or die ("Couln't select database $dbName1");


		$userID = $_SESSION['name'];

               $emailor = mssql_query("select * FROM TB_User where struserid = '$userID'");
                while($row = mssql_fetch_array($emailor)) {
                                $JID = $row['JID'];
                }
	mssql_select_db($dbName2, $dbConn) or die ("Couln't select database $dbName1");
               $emailor2 = mssql_query("SELECT * FROM _User WHERE UserJID = '$JID'");
                while($row = mssql_fetch_array($emailor2)) {
                                $CharID = $row['CharID'];
                }

               $emailor3 = mssql_query("SELECT * FROM _Char where CharID = '$CharID'");
                while($row = mssql_fetch_array($emailor3)) {
                                $CharNAME = $row['CharName16'];
                }

               $emailor4 = mssql_query("SELECT * FROM _User WHERE UserJID = '$JID' AND NOT CharID = '$CharID'");
                while($row = mssql_fetch_array($emailor4)) {
                                $CharID1 = $row['CharID'];
                }
               $emailor5 = mssql_query("SELECT * FROM _Char where CharID = '$CharID1'");
                while($row = mssql_fetch_array($emailor5)) {
                                $CharNAME1 = $row['CharName16'];
                }

               $emailor6 = mssql_query("SELECT * FROM _User WHERE UserJID = '$JID' AND NOT CharID = '$CharID' AND NOT CharID = '$CharID1'");
                while($row = mssql_fetch_array($emailor6)) {
                                $CharID2 = $row['CharID'];
                }
               $emailor7 = mssql_query("SELECT * FROM _Char where CharID = '$CharID2'");
                while($row = mssql_fetch_array($emailor7)) {
                                $CharNAME2 = $row['CharName16'];
                }


        if(!isset($_SESSION['loggedin'])) {
                header("location:?notLoggedIn");
        } else {
                echo 'Global 10x<br />';
                echo '<img src="img/global.jpg" title="ShinMo" /><br />';
                echo 'Price: 10coints<br />';
                print "
                        <b>Select Char</b>
                        <br />
                        <form name='form' method='post' action='?Item'>
                                <select name='CharName'>
                                <option value='$CharNAME'>$CharNAME</option>
                                <option value='$CharNAME1'>$CharNAME1</option>
                                <option value='$CharNAME2'>$CharNAME2</option>
                                </select>
                                <input type='submit' class='button' value='Buy' name='item1' />
                        </form>
                ";
                echo ' <br />';
                echo 'HolyBible(Weapon) 1x<br />';
                echo '<img src="img/weapon.jpg" title="ShinMo" /><br />';
                echo 'Price: 5coints<br />';
                print "
                        <b>Select Char</b>
                        <br />
                        <form name='form' method='post' action='?Item'>
                                <select name='CharName'>
                                <option value='$CharNAME'>$CharNAME</option>
                                <option value='$CharNAME1'>$CharNAME1</option>
                                <option value='$CharNAME2'>$CharNAME2</option>
                                </select>
                                <input type='submit' class='button' value='Buy' name='item2' />
                        </form>
                ";
              echo ' <br />';
                echo 'HolyBible(Protector) 1x<br />';
                echo '<img src="img/pro.jpg" title="ShinMo" /><br />';
                echo 'Price: 5coints<br />';
                print "
                        <b>Select Char</b>
                        <br />
                        <form name='form' method='post' action='?Item'>
                                <select name='CharName'>
                                <option value='$CharNAME'>$CharNAME</option>
                                <option value='$CharNAME1'>$CharNAME1</option>
                                <option value='$CharNAME2'>$CharNAME2</option>
                                </select>
                                <input type='submit' class='button' value='Buy' name='item3' />
                        </form>
                ";
              echo ' <br />';
                echo 'Premium Gold time(4weeks) 1x<br />';
                echo '<img src="img/premium.jpg" title="ShinMo" /><br />';
                echo 'Price: 100coints<br />';
                print "
                        <b>Select Char</b>
                        <br />
                        <form name='form' method='post' action='?Item'>
                                <select name='CharName'>
                                <option value='$CharNAME'>$CharNAME</option>
                                <option value='$CharNAME1'>$CharNAME1</option>
                                <option value='$CharNAME2'>$CharNAME2</option>
                                </select>
                                <input type='submit' class='button' value='Buy' name='item4' />
                        </form>
                ";
             echo ' <br />';
                echo 'Angel Spirit M 1x<br />';
                echo '<img src="img/AngelM.jpg" title="ShinMo" /><br />';
                echo 'Price: 250coints<br />';
                print "
                        <b>Select Char</b>
                        <br />
                        <form name='form' method='post' action='?Item'>
                                <select name='CharName'>
                                <option value='$CharNAME'>$CharNAME</option>
                                <option value='$CharNAME1'>$CharNAME1</option>
                                <option value='$CharNAME2'>$CharNAME2</option>
                                </select>
                                <input type='submit' class='button' value='Buy' name='item5' />
                        </form>
                ";
             echo ' <br />';
                echo 'Angel Spirit F 1x<br />';
                echo '<img src="img/AngelW.jpg" title="ShinMo" /><br />';
                echo 'Price: 250coints<br />';
                print "
                        <b>Select Char</b>
                        <br />
                        <form name='form' method='post' action='?Item'>
                                <select name='CharName'>
                                <option value='$CharNAME'>$CharNAME</option>
                                <option value='$CharNAME1'>$CharNAME1</option>
                                <option value='$CharNAME2'>$CharNAME2</option>
                                </select>
                                <input type='submit' class='button' value='Buy' name='item6' />
                        </form>
                ";
              echo ' <br />';
              echo ' <br />';



        }
?>