[Release] Buy Jewels

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
* It Doesn't work without Web Bank / Depositor for Rena, Stone and Jewels
* Your depositor has to work with in ONE SQL table or you have to include additional updating queries


PHP:
<?php 
// 97D+
	$option['buy_jewels']      = 1   ;	    // Option On-Off 1 = enable, 0 =  disable
	$option['select_version']  = 0   ;      // Select Version available options  0=97+, 1 = 99T+       
	$option['discount']        = 0.9 ;	    // Normal Price (for 1 - 10)(If is 1 - No Discount)
	$option['discount_mid']    = 0.7 ;	    // Mid Price (for 20)        (If is 1 - No Discount)
	$option['discount_max']    = 0.6 ;	    // Max Price (for 30)        (If is 1 - No Discount)
	$option['creation_price']  = 3   ;      // Jewel of Creation Price
	$option['soul_price']      = 4   ;      // Jewel of Soul 
	$option['bless_price']     = 5   ;      // Jewel of Creation Price
	$option['life_price']      = 5   ;      // Jewel of Soul 
	$option['stone_price']     = 6   ;      // Stone Price
	$option['rena_price']      = 10  ;      // Rena Price
	
// 99T+                
	$option['guardian_price']  = 20  ;      // Jewel of Guardian Price
	$option['bm1']             = 40  ;      // Stack of Bless x10
	$option['bm2']             = 60  ;      // Stack of Bless x20
	$option['bm3']             = 80  ;      // Stack of Bless x30
	$option['sm1']             = 40  ;      // Stack of Soul x10
	$option['sm2']             = 60  ;      // Stack of Soul x20
	$option['sm3']             = 80  ;      // Stack of Soul x30
////////////////////////////////////////////////////////////////////////	
// Type your session (it's individual) and Credits Table / Columns  
	$your_session   = 'yoursession'    ;      // Type your Session
    $credits_table  = '[Memb_Credits]' ;    // Type your Credits Table
	$credits_column = '[credits]'      ;    // Type your Credits Column
	$credits_user   = '[memb___id]'    ;    // Type your Credits Username

//----------------------------------------------------------------------
// Only works if your depositer deposit all jewels in one SQL table
    $deposit_table         = '[YourDepositor]'      ;  // Type your Depositor Table
	$deposit_user          = '[Depositor User]'     ;  // Type your Depositor User
	$stone_column          = '[stone]'              ;  // Type your Depositor Stone Column
	$rena_column           = '[rena]'               ;  // Type your Depositor Rena Column
	$bless_column          = '[bless]'              ;  // Type your Depositor Bless Column
    $soul_column           = '[soul]'               ;  // Type your Depositor Soul Column
	$guardian_column       = '[guardian]'           ;  // Type your Depositor Guardian Column
	$creation_column       = '[creation]'           ;  // Type your Depositor Creation Column
	$life_column           = 'life'                 ;  // Type your Depositor Life Column
	$soul_mix_10_column    = '[soulmix1]'           ;  // Type your Depositor Soul Mix x10 Column
	$soul_mix_20_column    = '[soulmix2]'           ;  // Type your Depositor Soul Mix x20 Column
	$soul_mix_30_column    = '[soulmix3]'           ;  // Type your Depositor Soul Mix x30 Column
	$bless_mix_10_column   = '[blessmix1]'          ;  // Type your Depositor Bless Mix x10 Column
	$bless_mix_20_column   = '[blessmix2]'          ;  // Type your Depositor Bless Mix x20 Column
	$bless_mix_30_column   = '[blessmix3]'          ;  // Type your Depositor Bless Mix x30 Column
//----------------------------------------------------------------------
	
$post_jewels = $_POST['jewels'];  // <- Secure the "Post" with your own web functions

if ($option['buy_jewels'] == 1 ){
	
  $current_credits = mssql_fetch_row(mssql_query("Select ".$credits_column." from ".$credits_table." where  ".$credits_user." = '".$_SESSION[''.$your_session.'']."'"));

  // Jewel Of Bless Price
	if (($post_jewels) == 'b1'){
		$price = $option['bless_price'];
		$item = "1 x Jewel of Bless";
		$column = $bless_column;
		$count  = 1;
	}
		if (($post_jewels) == 'b10'){
		$price = ceil((10*($option['bless_price'])*$option['discount']));
		$item = "10 x Jewel of Blesses";
		$column = $bless_column;
		$count  = 10;
	}
		if (($post_jewels) == 'b20'){
		$price = ceil((20*($option['bless_price'])*$option['discount_mid']));
		$item = "20 x Jewel of Blesses";
		$column = $bless_column;
		$count  = 20;
	}
		if (($post_jewels) == 'b30'){
		$price = ceil((5*($option['bless_price'])*$option['discount_max']));
		$item = "30 x Jewel of Blesses";
		$column = $bless_column;
		$count  = 30;
	}
  // Jewel Of Soul Price
		if (($post_jewels) == 's1'){
		$price = $option['soul_price'];
		$item = "1 x Jewel of Soul";
		$column =  $soul_column ;
		$count  = 1;
	}
		if (($post_jewels) == 's10'){
		$price = ceil((10*($option['soul_price'])*$option['discount']));
		$item = "10 x Jewel of Souls";
		$column =  $soul_column ;
		$count  = 10;
	}
		if (($post_jewels) == 's20'){
		$price = ceil((20*($option['soul_price'])*$option['discount_mid']));
		$item = "20 x Jewel of Souls";
		$column =  $soul_column ;
		$count  = 20;
	}
		if (($post_jewels) == 's30'){
		$price = ceil((30*($option['soul_price'])*$option['discount_max']));
		$item = "30 x Jewel of Souls";
		$column =  $soul_column ;
		$count  = 30;
	}
   // Jewel Of Guardian Price
		if (($post_jewels) == 'g1'){
		$price = $option['guardian_price'];
		$item = "1 x Jewel of Guardians";
		$column = $guardian_column;
		$count  = 1;
		
	}
		if (($post_jewels) == 'g10'){
		$price = ceil((10*($option['guardian_price'])*$option['discount']));
		$item = "10 x Jewel of Guardian";
		$column = $guardian_column;
		$count  = 10;
	}
		if (($post_jewels) == 'g20'){
		$price = ceil((20*($option['guardian_price'])*$option['discount_mid']));
		$item = "20 x Jewel of Guardians";
		$column = $guardian_column;
		$count  = 20;
	}
		if (($post_jewels) == 'g30'){
		$price = ceil((30*($option['guardian_price'])*$option['discount_max']));
		$item = "30 x Jewel of Guardians";
		$column = $guardian_column;
		$count  = 30;
	}
	// Jewel Of Creation Price
		if (($post_jewels) == 'c1'){
		$price = $option['guardian_price'];
		$item = "1 x Jewel of Creation";
		$column = $creation_column;
		$count  = 1;
	}
		if (($post_jewels) == 'c10'){
		$price = ceil((10*($option['guardian_price'])*$option['discount']));
		$item = "10 x Jewel of Creations";
		$column = $creation_column;
		$count  = 10;
	}
		if (($post_jewels) == 'c20'){
		$price = ceil((20*($option['guardian_price'])*$option['discount_mid']));
		$item = "20 x Jewel of Creations";
		$column = $creation_column;
		$count  = 20;
	}
		if (($post_jewels) == 'c30'){
		$price = ceil((30*($option['guardian_price'])*$option['discount_max']));
		$item = "30 x Jewel of Creations";
		$column = $creation_column;
		$count  = 30;
	}
	// Jewel Of Life Price
		if (($post_jewels) == 'l1'){
		$option['life_price'];
		$item = "1 x Jewel of Life";
		$column = $life_column  ;
		$count  = 1;
	}
		if (($post_jewels) == 'l10'){
		$price = ceil((10*($option['life_price'])*$option['discount']));
		$item = "10 x Jewel of Lifes";
		$column = $life_column;
		$count  = 10;
	}
		if (($post_jewels) == 'l20'){
		$price = ceil((20*($option['life_price'])*$option['discount_mid']));
		$item = "20 x Jewel of Lifes";
		$column = $life_column  ;
		$count  = 20;
	}
		if (($post_jewels) == 'l30'){
		$price = ceil((30*($option['life_price'])*$option['discount_max']));
		$item = "30 x Jewel of Lifes";
		$column = $life_column  ;
		$count  = 30;
	}
	// Jewel Of Soul Mix Price
			if (($post_jewels) == 'sm10'){
		$price = ceil((($option['sm1'])*$option['discount']));
		$item = "10 x Soul Mixes";
		$column = $soul_mix_10_column;
		$count  = 1;
	}
		if (($post_jewels) == 'sm20'){
		$price = ceil((($option['sm2'])*$option['discount_mid']));
		$item = "20 x Soul Mixes";
		$column = $soul_mix_20_column;
		$count  = 1;
	}
		if (($post_jewels) == 'sm30'){
		$price = ceil((($option['sm3'])*$option['discount_max']));
		$item = "30 x Soul Mixes";
		$column = $soul_mix_30_column;
		$count  = 1;
	}
	// Jewel Of Bless Mix Price
		if (($post_jewels) == 'bm10'){
		$price = ceil((($option['bm1'])*$option['discount']));
		$item = "10 x Bless Mixes";
		$column = $bless_mix_10_column;
		$count  = 1;
	}
	    if (($post_jewels) == 'bm20'){
		$price = ceil((($option['bm2'])*$option['discount_mid']));
		$item = "20 x Bless Mixes";
		$column = $bless_mix_20_column; 
		$count  = 1;
	}
		if (($post_jewels) == 'bm30'){
		$price = ceil((($option['bm3'])*$option['discount_max']));
		$item = "30 x Bless Mixes";
		$column = $bless_mix_30_column;
		$count  = 1;
	}
	// Stone Price
		if (($post_jewels) == 'sto1'){
		$price = $option['stone_price'];
		$item = "1 x Stone";
		$column = $stone_column;
		$count  = 1;
	}
		if (($post_jewels) == 'sto10'){
		$price = ceil((10*($option['stone_price'])*$option['discount']));
		$item = "10 x Stones";
		$column = $stone_column;
		$count  = 10;
	}
		if (($post_jewels) == 'sto20'){
		$price = ceil((20*($option['stone_price'])*$option['discount_mid']));
		$item = "20 x Stones";
		$column = $stone_column;
		$count  = 20;
	}
		if (($post_jewels) == 'sto30'){
		$price = ceil((30*($option['stone_price'])*$option['discount_max']));
		$item = "30 x Stones";
		$column = $stone_column;
		$count  = 30;
	}
		// Rena Price
		if (($post_jewels) == 're1'){
		$price = $option['rena_price'];
		$item = "1 x Rena";
		$column = $rena_column;
		$count  = 1;
	}
		if (($post_jewels) == 're10'){
		$price = ceil((10*($option['rena_price'])*$option['discount']));
		$item = "10 x Rena";
		$column = $rena_column;
		$count  = 10;
	}
		if (($post_jewels) == 're20'){
		$price = ceil((20*($option['rena_price'])*$option['discount_mid']));
		$item = "20 x Rena";
		$column = $rena_column;
		$count  = 20;
	}
		if (($post_jewels) == 're30'){
		$price = ceil((30*($option['rena_price'])*$option['discount_max']));
		$item = "30 x Rena";
		$column = $rena_column;
		$count  = 30;
	}
       if ($option['select_version'] == 1){
         	$show = '';
            $end  =	'';
            }
           else {
       	   $show = '<!--';
           $end  =	' -->';	
            }			
if (isset($_POST['buy'])){
	  if($price > $current_credits[0] ){
		  echo"<div style='text-align:center;color:#FF7373;margin-top:20px;'>You do not have enough credits, you have to pay ".$price ." credits to buy ".$item."!</div>";
	  }
	  else {
		    mssql_query("Update ".$credits_table." set ".$credits_column." = ".$credits_column."-".$price." where ".$credits_user." = '".$_SESSION[''.$your_session.'']."'");
			mssql_query("Update ".$deposit_table." set ".$column." = ".$column."+".$count." where ".$deposit_user." = '".$_SESSION[''.$your_session.'']."'");

            // Optional make logs  time(), $ip, and etc);
			
		   echo "<div style='text-align:center;color:#B9FF73;margin-top:20px;'>".$_SESSION[''.$your_session.'']." paid ".$price." credits and bought ".$item."</div> ";
	  }
}
  $updated_credits = mssql_fetch_row(mssql_query("Select ".$credits_column." from ".$credits_table." where  ".$credits_user." = '".$_SESSION[''.$your_session.'']."'"));
?>

    <table style='margin-top:100px;' align='center'width='300' >
	<tr> <td colspan='2' style='text-align:center; color:#99FFE5'>You have <?=$updated_credits[0];?> credits
	</td></tr>
       <tr style='background:#444;'><td align='center'>Choose Jewel/Stone/Rena To Buy</td><td align='center'>Buy</td></tr><tr>
		  <form id='tab' method='post'>  
		    <td><select style='width:150px; color:white;' name='jewels'> 
						<option value ='re1' >Rena x1                /  <?php echo $option['rena_price']." credits";?></option>
						<option value ='re10'>Rena x10               /  <?php echo ceil((10*($option['rena_price'])*$option['discount']))." credits";?></option>
						<option value ='re20'>Rena x20               /  <?php echo ceil((20*($option['rena_price'])*$option['discount_mid']))." credits";?></option>
						<option value ='re30'>Rena x30               /  <?php echo ceil((30*($option['rena_price'])*$option['discount_max']))." credits";?></option>
						<option value ='sto1' >Stone x1              /  <?php echo $option['stone_price']." credits";?></option>
						<option value ='sto10'>Stone x10             /  <?php echo ceil((10*($option['stone_price'])*$option['discount']))." credits";?></option>
						<option value ='sto20'>Stone x20             /  <?php echo ceil((20*($option['stone_price'])*$option['discount_mid']))." credits";?></option>
						<option value ='sto30'>Stone x30             /  <?php echo ceil((30*($option['stone_price'])*$option['discount_max']))." credits";?></option>
						<option value ='b1' >Jewels of Bless x1 -    /  <?php echo $option['bless_price']." credits";?></option>
						<option value ='b10'>Jewels of Bless x10     /  <?php echo ceil((10*($option['bless_price'])*$option['discount']))." credits";?></option>
						<option value ='b20'>Jewels of Bless x20     /  <?php echo ceil((20*($option['bless_price'])*$option['discount_mid']))." credits";?></option>
						<option value ='b30'>Jewels of Bless x30     /  <?php echo ceil((30*($option['bless_price'])*$option['discount_max']))." credits";?></option>				  	
						<option value ='s1' >Jewels of Soul x1       /  <?php echo $option['soul_price']." credits";?></option>
						<option value ='s10'>Jewels of Soul x10      /  <?php echo ceil((10*($option['soul_price'])*$option['discount']))." credits";?></option>
						<option value ='s20'>Jewels of Soul x20      /  <?php echo ceil((20*($option['soul_price'])*$option['discount_mid']))." credits";?></option>
						<option value ='s30'>Jewels of Soul x30      /  <?php echo ceil((30*($option['soul_price'])*$option['discount_max']))." credits";?></option>	
						<option value ='l1' >Jewels of Life x1       /  <?php echo $option['life_price']." credits";?></option>
						<option value ='l10'>Jewels of Life x10      /  <?php echo ceil((10*($option['life_price'])*$option['discount']))." credits";?></option>
						<option value ='l20'>Jewels of Life x20      /  <?php echo ceil((20*($option['life_price'])*$option['discount_mid']))." credits";?></option>
						<option value ='l30'>Jewels of Life x30      /  <?php echo ceil((30*($option['life_price'])*$option['discount_max']))." credits";?></option>	
						<option value ='c1' >Jewels of Creation x1   /  <?php echo $option['creation_price']." credits";?></option>
						<option value ='c10'>Jewels of Creation x10  /  <?php echo ceil((10*($option['creation_price'])*$option['discount']))." credits";?></option>
						<option value ='c20'>Jewels of Creation x20  /  <?php echo ceil((20*($option['creation_price'])*$option['discount_mid']))." credits";?></option>
						<option value ='c30'>Jewels of Creation x30  /  <?php echo ceil((30*($option['creation_price'])*$option['discount_max']))." credits";?></option>	
<?php echo $show;?>		<option value ='g1' >Jewels of Guardian x1   /  <?php echo $option['guardian_price']." credits";?></option>
						<option value ='g10'>Jewels of Guardian x10  /  <?php echo ceil((10*($option['guardian_price'])*$option['discount']))." credits";?></option>
						<option value ='g20'>Jewels of Guardian x20  /  <?php echo ceil((20*($option['guardian_price'])*$option['discount_mid']))." credits";?></option>
						<option value ='g30'>Jewels of Guardian x30  /  <?php echo ceil((30*($option['guardian_price'])*$option['discount_max']))." credits";?></option>	
						<option value ='sm10'>Soul Mix x10           /  <?php echo $option['sm1']." credits";?></option> 
						<option value ='sm20'>Soul Mix x20           /  <?php echo ceil($option['sm2']) ." credits";?></option> 
						<option value ='sm30'>Soul Mix x30           /  <?php echo ceil($option['sm3']) ." credits";?></option> 
						<option value ='bm10'>Bless Mix x10          /  <?php echo ceil($option['bm1']) ." credits";?></option>	 
						<option value ='bm20'>Bless Mix x20          /  <?php echo ceil($option['bm2']) ." credits";?></option>
						<option value ='bm30'>Bless Mix x30          /  <?php echo ceil($option['bm3']) ." credits";?></option><?php echo $end;?>
				    </select></td>                                    
					
	  <td align='center' colspan = '4'><input type='submit' name='buy' class='button' value ='Buy Jewels'/></td></tr>
			</form>
			
	</table>	

<?php 
}
else {
	echo "This module is disabled! For more information contact the administrators";
}

?>
 
Last edited:
error
This module is disabled! For more information contact the administrators
 
I have it in 1 and follows the same
Help!!
 
Last edited: