$DB, "UID"=>$UID, "PWD"=>$PWD); $conn = sqlsrv_connect( $HOST, $connectionInfo); if ($conn) { $selectPoints = "SELECT * FROM tCash WHERE userNo='".$_SESSION['userID']."' AND cashtype='0'"; $doSelectQuery = sqlsrv_query($conn, $selectPoints, array(), array( "Scrollable" => 'static' )); $count = sqlsrv_num_rows($doSelectQuery); if ($count == 0) { $insertPoints = "INSERT INTO tCash VALUES('".$_SESSION['userID']."', '0', '0', '0')"; $doInsertQuery = sqlsrv_query($conn, $insertPoints); $userCoins = 0; } else if ($count == 1) { $coinValue = sqlsrv_fetch_array($doSelectQuery); $userCoins = $coinValue['cash']; } else { echo 'There has been an error loading user point information.'; } } else { } ?>

Cash ShopYou have Coins

Here you can buy some special items for Anonymous Coins. If you run out of coins you can buy more using form below.

'static' )); // If neither category nor item are set if ( $catID == NULL && $itemViewID == 0 ) { while ($category = sqlsrv_fetch_array($doCatQuery)) { // It's not even getting to this line echo '

'.$category['name'].'See all

'; // Select top 4 items from this category $selectItems = sqlsrv_query($conn, "SELECT TOP 3 * FROM tItem WHERE category = ".$category['category']." AND isSell = 'True' ORDER BY registerDate DESC", array(), array( "Scrollable" => 'static' )); echo ''; while ( $item = sqlsrv_fetch_array( $selectItems ) ) { if ( $item['imageName'] == NULL ) $item['imageName'] = "NONE"; echo ''; } echo ''; echo '

['.$item['unit'].'x] '.$item['name'].'


'; if($item['price'] == 0) echo 'Free'; else echo $item['price'].' Gold'; // echo '

'; } } else if ($itemViewID != 0) { $selectItemInfo = sqlsrv_query($conn, "SELECT * FROM tItem WHERE goodsNo = $itemViewID AND isSell = 'True'", array(), array( "Scrollable" => 'static' )); if (sqlsrv_num_rows($selectItemInfo) == 1 ) { $item = sqlsrv_fetch_array($selectItemInfo); $selectCategoryName = sqlsrv_query($conn, "SELECT name FROM tItemCategory WHERE category = (SELECT category FROM.tItem WHERE goodsNo = $itemViewID)"); $categoryRow = sqlsrv_fetch_array($selectCategoryName); if ( $item['imageName'] == NULL ) $item['imageName'] = "NONE"; echo '

['.$item['unit'].'x] '.$item['name'].''.$categoryRow['name'].'

'; echo '

'; if($item['price'] == 0) echo 'Free'; else echo $item['price'].' Gold'; echo '
'.$item['description'].'
'; echo '
'; echo '
'; echo '
'; if ( $_POST['Buy'] ) { // First check if user has enought points $selectPoints = sqlsrv_query($conn, "SELECT * FROM tCash WHERE userNo = '".$_SESSION['userID']."' AND cashtype = '0';", array(), array( "Scrollable" => 'static' )); $userPoints = sqlsrv_fetch_array($selectPoints); if ($userPoints['cash'] >= $item['price'] ) { $newCash = ($userPoints['cash'] - $item['price'] ); $changePoints = sqlsrv_query($conn, "UPDATE tCash SET cash = ".$newCash." WHERE userNo = ".$_SESSION['userID']." AND cashtype = 0;" ); if ( $changePoints ) { $insertItem = sqlsrv_query($conn, "INSERT INTO tChargeItem(userNo, goodsNo) VALUES(".$_SESSION['userID'].",".$item['goodsNoCheck'].");" ); if ( $insertItem ) { echo ''; } else { //showMessage( 'error', 'Internal item purchase error' ); } } else { //showMessage( 'error', 'Internal item error' ); } } else { //showMessage( 'error', 'You do not have enought coins.' ); } } } else { //showMessage( 'error', 'Item not found!' ); } } else { $selectCategory = sqlsrv_query($conn, "SELECT name FROM tItemCategory WHERE category = '$catID' AND status = 'True'", array(), array( "Scrollable" => 'static' )); if ( sqlsrv_num_rows( $selectCategory ) == 1 ) { // Select sub-categories $selectSubCategories = sqlsrv_query($conn, "SELECT * FROM tItemCategory WHERE parent = '$catID' AND status = 'True';", array(), array( "Scrollable" => 'static' )); if ( sqlsrv_num_rows( $selectSubCategories ) > 0 ) { while ( $category = sqlsrv_fetch_array( $selectSubCategories ) ) // This is just like it I guess that's why this isnt working either { echo '

'.$category['name'].'See all

'; // Select top 4 items from this category $selectItems = sqlsrv_query($conn, "SELECT TOP 3 * FROM tItem WHERE category = ".$category['category']." AND isSell = 'True' ORDER BY registerDate DESC;", array(), array( "Scrollable" => 'static' )); echo ''; while ( $item = sqlsrv_fetch_array( $selectItems ) ) { if ( $item['imageName'] == NULL ) $item['imageName'] = "NONE"; echo ''; } echo ''; echo '

['.$item['unit'].'x] '.$item['name'].'


'; if($item['price'] == 0) echo 'Free'; else echo $item['price'].' Gold'; echo '

'; } } // Select Items in Category/Subcategory $selectCategoryItems = sqlsrv_query($conn, "SELECT * FROM tItem WHERE category = '$catID' AND isSell = 'True' ORDER BY registerDate DESC;", array(), array( "Scrollable" => 'static' )); $catName = sqlsrv_fetch_array($selectCategory); echo '

'.$catName['name'].'Cash Shop Home Page

'; if ( sqlsrv_num_rows( $selectCategoryItems ) > 0 ) { $column = 1; echo ''; while ( $item = sqlsrv_fetch_array( $selectCategoryItems ) ) { if ( $item['imageName'] == NULL ) $item['imageName'] = "NONE"; if ( $column == 1 ) { echo ''; } $column++; echo ''; if ( $column == 4 ) { echo ''; $column = 1; } } echo '

['.$item['unit'].'x] '.$item['name'].'


'; if($item['price'] == 0) // echo 'Free'; else echo $item['price'].' Gold'; echo '
'; } else { //showMessage( 'info', 'There are no items in this category.' ); } } else { //showMessage( 'error', 'Category not found' ); } } ?>