...Bank System...

[fewdox]

Hi All, Anyone have a bank system via database MySql ...
if have please post link or code here tanks ..
:thumbup:

and if someone help me with this method form `buy points`..
i need to put bank system via database mysql in my ot ..
and buy points form with balance of bank ..
type ..

Test have 9000 gp in bank ..

Buy points form is .. if player have 9000 gp in bank .. he can buy 1 point ..

i have this db commands but i have one NPC via website . but i dont know how i make for the when player buyed 1 points .. he lost the balance money ..

example

1-> i deposited 9k in balance
2-> need buy 1 points (1 point price is 9k)
3-> db check if you have 9k
4-> after check ... but have a submit button . and you get 1 point in site
5->after 1 point added db remove the 9k from you account balance

$player_data = $SQL->query("SELECT * FROM `players` WHERE `name` = '".$player."';")->fetch(); 
$SQL->query("UPDATE `accounts` SET `premium_points` = `premium_points` + '".$points."' WHERE `id` = '".$player_data['account_id']."'");





if($config['site']['shop_system'] == 1)
{
if($logged)
{
  $user_premium_points = $account_logged->getCustomField('balance');
}
else
{
  $user_premium_points = 'Login first';
}

Please help me .. i need this very munch .!!!!

 

[Tarielle]

okay as I understand now you want a code for each point given to the player:

this is a remake of the first thing you requested

$PlayerQuery=mysql_query('SELECT balance, name FROM players WHERE name = '.$player.'') or die(mysql_error());
$PlayerRows = mysql_fetch_array($PlayerQuery);

if($config['site']['shop_system'] == 1) 
{ 
	if($logged) 
	{ 
		$user_premium_points = $account_logged->getCustomField('balance'); 
		
		if($PlayerRows['balance'] >= ($points*9000))
		{
		
			$newBalance = ($PlayerRows['balance']-($points*9000));
			mysql_query('UPDATE players SET balance = '.$newBalance.' WHERE id = '.$player.'') or die(mysql_error());
			
			for($i=1; $i <= $points; $i++)
			{
				
				$randomCode = rand(0,1000000);
				$randomPassword = rand(0,1000000);
				$hashedRandomPassword = sha1($randomPassword);
				mysql_query("INSERT INTO codes (code, password) VALUES('$randomCode', '$hashedRandomPassword') ") or die(mysql_error());  
				
				echo $i.': Code = '.$randomCode.' and password = '.$randomPassword;
			}		
		}	  
	} 
	else 
	{ 
	  $user_premium_points = 'Login first'; 
	} 
}

and with this they get their points

echo'
<form method="post">
Code<br>
<input name="code"><br>
Password<br>
<input name="password"><br>
<input type="submit" name="submitCode">
</form>
';


if($_POST['submitCode'])
{
	
	$code = mysql_real_escape_string($_POST['code']);
	$password = mysql_real_escape_string($_POST['password']);

	$points = 'define please';
	
	$codeQuery = mysql_query('SELECT id, code, password FROM codes WHERE code = '.$code.'') or die(mysql_error());
	$codeRows = mysql_fetch_array($codeQuery);
	
	
	if(sha1($codeRows['password']) == $password)
	{
		mysql_query('UPDATE accounts SET premium_points = '.$points.' WHERE id = '.$player_data['account_id'].'') or die(mysql_error());
		mysql_query('DELETE FROM codes WHERE id = '.$codeRows['id'].' LIMIT 1') or die(mysql_error());
	}
}

 

[fewdox]

i dont know how to finish please someone help me ?

 

[fewdox]

..

i have one error

<?php
    mysql_connect("localhost", "root", "005566");
    mysql_select_db("talisman");
echo'
<form method="post">
Code<br>
<input name="code"><br>
Password<br>
<input name="password"><br>
<input type="submit" name="submitCode">
</form>
';
if($logged)
if($_POST['submitCode'])
{

    $codeQuery = mysql_real_escape_string($_POST['code']);
    $password = mysql_real_escape_string($_POST['password']);

    $points = '1';
    $account= $player_data['account_id'];

    $codeQuery = mysql_query('SELECT id, code, password FROM codes WHERE code = '.$code.'') or die(mysql_error());
    $codeRows = mysql_fetch_array($codeQuery);

    if($codeRows['password'] == $password)
    {
        mysql_query('UPDATE accounts SET premium_points = '.$points.' WHERE id = '.$account.'') or die(mysql_error());
        mysql_query('DELETE FROM codes WHERE id = '.$codeRows['id'].' LIMIT 1') or die(mysql_error());
    }
}
?>

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

[fewdox]

no any know how to fix this error ?

 

[fewdox]

127 views = 0 know

 

[fewdox]

??? how i can fix guys please ??

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

 

[fewdox]

i fixed the problem but db dont check the code and password .. to add points .

<?php
@mysql_connect("localhost","root","00119977");
@mysql_select_db("talisman");

{
$main_content .='
<form action="" method="post">
Character Name<br>
<input type="textbox" name="character"><br>
Code<br>
<input type="textbox" name="code"><br>
Password<br>
<input type="textbox" name="password"><br>
<input type="submit" name="submitCode" value="submitCode">
</form>';
}
if($_POST['submitCode'])
{
$code = mysql_real_escape_string($_POST['code']);
$password = mysql_real_escape_string($_POST['password']);
$codeQuery = mysql_query ('SELECT id, password, FROM codes where passsword = '.$password.'') or die(mysql_error());
$codeQuery = mysql_query ('SELECT id, code, password FROM codes WHERE code = '.$code.'') or die(mysql_error());
$player = stripslashes(ucwords(strtolower(trim($_REQUEST['character']))));
$points = '1';

    $codeRows = mysql_fetch_array($codeQuery)or die(mysql_error());
    $player_data = $SQL->query("SELECT * FROM `players` WHERE `name` = '".$player."';")->fetch();
    {
        mysql_query('DELETE FROM codes WHERE id = '.$codeRows['id'].' LIMIT 1') or die(mysql_error());
    }
    {
       mysql_query("UPDATE `accounts` SET `premium_points` = `premium_points` + '".$points."' WHERE `id` = '".$player_data['account_id']."'");
    }

    if(sha1($codeRows['password']) == $password)
    {
     $main_content .= '<b><center>'.$points.' Premium Points added to the account of <i>'.$player.'</i> !</b></center>';
    }
}
?>

 

[fewdox]

.. and need one method to put code = leters password = numbers .. with lenght 6++

<?php
    mysql_connect("localhost", "root", "00119977");
    mysql_select_db("talisman");

for($i=0; $i <= 10; $i++)
{

    $randomCode = rand(10,100000000);
    $randomPassword = rand(100000,1000000000);
    $hashedRandomPassword = sha1($randomPassword);
    mysql_query("INSERT INTO codes (code, password) VALUES('$randomCode', '$hashedRandomPassword') ") or die(mysql_error());

    echo $i.': Code = '.$randomCode.' and password = '.$randomPassword;
}
?>
[PHP]