+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Website Scripting & Security (https://lckb.dev/forum/forumdisplay.php?fid=197)
+---- Forum: Website Releases (https://lckb.dev/forum/forumdisplay.php?fid=135)
+----- Forum: Ep1 Websites (https://lckb.dev/forum/forumdisplay.php?fid=185)
+----- Thread: Time Point To Cash (/showthread.php?tid=1042)
Pages:
1
2
- ReturnKratos - 08-22-2012
Hey Guys I worked on it for abiut 3 hours ;D
I want to show you my new script for change time point for cash !!!
Here Are :
// Check For Login
if( $User->LoggedIn == true )
{
$mysql1 = mysql_select_db( $SiteSQL["config-database_auth"] , $Site_sqlcon) or die( mysql_error() );
$query1 = mysql_query("SELECT cash from bg_user WHERE user_code = ". $User->ID ."");
$result1b = mysql_fetch_array( $query1 );
$mysql2 = mysql_select_db( $SiteSQL["config-database_site"] , $Site_sqlcon) or die( mysql_error() );
$query2 = mysql_query("SELECT a_online_time from t_user_log WHERE a_account_index = ". $User->ID ."");
$result2b = mysql_fetch_array( $query2 );
$cash = $result1b['cash'];
$onlinetimepoints = $result2b['a_online_time'];
echo'<center>';
echo 'Your Currenty Cash Is : ';
print $cash;
echo'<br>';
echo 'Your Currenty Online Time Points : ';
print $onlinetimepoints;
echo '<br>';
if(isset($_POST['change'])) {
$mysql1 = mysql_select_db( $SiteSQL["config-database_auth"] , $Site_sqlcon) or die( mysql_error() );
$query1 = mysql_query("UPDATE bg_user SET cash = cash + ". $onlinetimepoints ." WHERE user_code = ". $User->ID ."");
$mysql2 = mysql_select_db( $SiteSQL["config-database_site"] , $Site_sqlcon) or die( mysql_error() );
$query2 = mysql_query("UPDATE t_user_log SET a_online_time = 0 WHERE a_account_index = ". $User->ID ."");
$mysql1 = mysql_select_db( $SiteSQL["config-database_auth"] , $Site_sqlcon) or die( mysql_error() );
$query1 = mysql_query("SELECT cash from bg_user WHERE user_code = ". $User->ID ."");
$result1b = mysql_fetch_array( $query1 );
$mysql2 = mysql_select_db( $SiteSQL["config-database_site"] , $Site_sqlcon) or die( mysql_error() );
$query2 = mysql_query("SELECT a_online_time from t_user_log WHERE a_account_index = ". $User->ID ."");
$result2b = mysql_fetch_array( $query2 );
$curonlinept = $result2b['a_online_time'];
$curcash = $result1b['cash'];
echo 'Now You Got(Cash) : ';
print $curcash;
echo '<br>Now You Got(OnlinePoints) :';
print $curonlinept;
}
?>
<form id="form1" name="form1" method="post" action="">
<input name="change" value="Time For Cash !" type="submit" />
</form>
</html>
<?php
echo '</center>';
}
else{
echo 'No Logged ! Please Login For Excange Online Time Points !' ;
}
You Must Use It For Your Page ;D
Have Fun !
Some Things :
2
2
THIS IS CREATED BY MYSELF !!!
- MrBeaN - 08-22-2012
Nice release and nice work
- ReturnKratos - 08-22-2012
Nice release and nice work
And Nice Thanks ;D
i'm looking for addeals.php and addseals.tpl you got it ? if yes can send me a pm with link ?
- someone - 08-23-2012
I wouldn't use MySql library from PHP, since with the latest versions of PHP it gotten deprecated, I suggest using MySQLi, or PDO, mysqli only available for mysql, where PDO is available for 8 databases types.
If you have experience with mysql, mysqli will be easier to understand since the function names are the same only is added the I in the function names.
2
- Blackfire - 08-23-2012
I wouldn't use MySql library from PHP, since with the latest versions of PHP it gotten deprecated, I suggest using MySQLi, or PDO, mysqli only available for mysql, where PDO is available for 8 databases types.
If you have experience with mysql, mysqli will be easier to understand since the function names are the same only is added the I in the function names.
2
PDO and Mysqli is harder >.>
- Blackfire - 08-23-2012
Its actually quite simple, I personally wouldn't say one is harder over another.
Well i'm already used to mysql and i'm still pretty noob at it xd
- barroso - 08-27-2012
how i can create a a_online_time in db
- ReturnKratos - 08-27-2012
barroso if you're using navicat just design table button and add a_online_time | varchar | 200 | 0 | Not NULL
- Wizatek - 08-27-2012
Its really not that hard to make it in pdo.
Also, if u want to edit that later u will spend hours on tracing back all the variables u used.
<?php
try
{
$db = new PDO('mysql:host=localhost', 'username', 'password');
}
catch
{
die('Unable to connect to the database<br />Please try again later');
}
if( $User->LoggedIn == true )
{
$dbauth = $SiteSQL["config-database_auth"];
$dbsite = $SiteSQL["config-database_site"];
$uid = $User->ID;
$query = sprintf
("
SELECT
u.cash as cash,
l.a_online_time as time
FROM
%s.bg_user u,
%s.t_user_log l
WHERE
u.user_code = :uid
AND
l.a_account_index = u.user_code
", $dbauth,
$dbsite );
$dbh = $db->prepare($query);
$dbh->bindParam(':uid', $uid, PDO:
ARAM_INT);$dbh->execute();
$result = $dbh->fetch();
$cash = $result['cash'];
$time = $result['time'];
if( isset($_POST['change']))
{
$dbh = $db->prepare( sprintf('UPDATE %s.bg_user SET cash = cash + :timepoints WHERE user_code = :uid', $auth));
$dbh->bindParam(':timepoints', $time, PDO:
ARAM_INT);$dbh->bindParam(':uid', $uid, PDO:
ARAM_INT);$dbh->execute();
$dbh = $db->prepare( sprintf('UPDATE %s.t_user_log SET a_online_time = 0 WHERE a_account_index = :uid', $db));
$dbh->bindParam(':uid', $uid, PDO:
ARAM_INT);$dbh->execute();
$cash -= $time;
$time = 0;
}
printf
('
<center>
Your Current Cash Is : %d<br />
Your current online time points : %d<br />
<form id="form1" name="form1" method="post">
<input name="change" value="Time For Cash !" type="submit" />
</form>
</center>
', $cash, $time);
}
else
echo 'Please login to exchange Online Time Points for Cash';
?>
- Sutz - 08-29-2012
Sorry but this has to be said now..
THIS IS CREATED BY MYSELF !!!
Lol if you look closer at the code, yea go on have a look!
if( $User->LoggedIn == true )
{
}
$SiteSQL["config-database_auth"]
All of this [CeNsOrEd] originates from my sites with originates from Wizateks EP2 control pannel
So quoting "THIS IS CREATED BY MYSELF !!!" means you used our code learn't alittle an got a script to work.
Its not fully created by yourself.. lol