here is a buy query. Any advice to make it work ?
thanks.
This one is taken from another shop & i mofify some link to php file to sync with this shop.
<?php
////////////GM connection
$is_gm=false;
$r=query_db('select * from '.DB_GAM.'.dbo.cabal_character_table where CharacterIdx between '.$v1.' * 8 and '.$v1.' * 8 + 5 and nation=3');
if (mssql_num_rows($r)>0) $is_gm=true;
if (MAINTMODE==true and $is_gm==false) die ('Maintmode activated');
if ($confirm>0 && $item==0){
if (!$link) die('Database connection error.');
$q="select * from ".DB_ACC.".dbo.cabal_auth_table where UserNum='".$v1."'and AuthKey='".$v2."'";
if (IPVALIDATION==true) $q=$q." and LastIp='".$ip."'";
$r=query_db($q);
$row = mssql_fetch_row($r);
$name=$row[1];
$r=query_db("exec ".DB_CSH.".dbo.getbankalz '".$v1."'");
$row = mssql_fetch_row($r);
$alz=$row[1];
$r=query_db("select * from ".DB_CSH.".dbo.ShopItems where Id='".$confirm."' and Available>0");
if (mssql_num_rows($r)==0){
error_box('Error','unavailable item.');
}
else{
$row = mssql_fetch_row($r);
$itemidx=$row[3];
$durationidx=$row[4];
$itemopt=$row[5];
$price=$row[8];
$available=$row[10];
if ($alz<$price){
error_box('Error','insuffisant fond to buy item');
}
else{
$newalz=$alz-$price;
$newavailable=$available-1;
hardlog('Item purchased: '.$itemidx.','.$durationidx.','.$itemopt.','.$price.','.$available.' ('.$alz.'/'.$newalz.')');
$r=query_db("update ".DB_CSH.".dbo.ShopItems set Available='".$newavailable."' where Id='".$row[0]."'");
$r=query_db("exec ".DB_CSH.".dbo.setbankalz '".$v1."','".$newalz."'");
$r=query_db("exec ".DB_CCA.".dbo.up_AddMyCashItemByItem '".$v1."','1','".SVR_IDX."','".$itemidx."','".$itemopt."','".$durationidx."'");
error_box('Item bought. Click on close to go back to cashshop.');
}
}
}
elseif ($item>0 && $confirm==0){
$r=query_db("select * from ".DB_CSH.".dbo.ShopItems where Id='".$item."' and Available>0");
if(mssql_num_rows($r)==0){
error_box('Error','Quantity not available');
}
else{
echo '<DIV id=wrapper style="DISPLAY: none">';
echo '<TABLE height="100%" width="100%">';
echo '<TBODY><TR><TD vAlign=center align=middle>';
echo '<TABLE cellSpacing=0 cellPadding=0 border=0><TBODY>';
echo '<TR><TD width=35><IMG height=40 src="http://forum.ragezone.com/images/Item_Game_Box_s_01.gif" width=35></TD>';
echo '<TD class=white style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 5px" vAlign=top align=middle background="http://forum.ragezone.com/images/Item_Game_Box_s_02.gif"><STRONG>Are you sure ?</STRONG></TD>';
echo '<TD width=35><IMG height=40 src="http://forum.ragezone.com/images/Item_Game_Box_s_03.gif" width=35></TD></TR>';
//Please, confirm your purchase.
echo '<TR>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_04.gif"> </TD>';
echo '<TD class=orange style="PADDING-BOTTOM: 20px; PADDING-TOP: 20px; background: #191D20" align=middle width=200><STRONG><SPAN style="WIDTH: 280px">Please, confirm your purchase.</SPAN></STRONG></TD>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_06.gif"> </TD>';
echo '</TR>';
echo '<TR>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_04.gif"> </TD>';
echo '<TD class=orange style="PADDING-BOTTOM: 20px; PADDING-TOP: 20px; background: #191D20" align=middle>';
echo '<IMG style="CURSOR: pointer" onclick="javscript:location.href=\'/_buy.php?v1='.$v1.'&v2='.$v2.'&co='.$item.'\'" alt="Confirm your purchase" src="http://forum.ragezone.com/images/Btn_Yes.gif" border=0> ';
echo '<IMG style="CURSOR: pointer" onclick="javscript:location.href=\'./wshop.php?v1='.$v1.'&v2='.$v2.'\'" alt="Cancel your purchase" src="http://forum.ragezone.com/images/Btn_No.gif" border=0>';
echo '</TD>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_06.gif"> </TD>';
echo '</TR>';
echo '<TR>';
echo '<TD><IMG src="http://forum.ragezone.com/images/Item_Game_Box_s_07.gif" width=35></TD>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_08.gif"> </TD>';
echo '<TD><IMG src="http://forum.ragezone.com/images/Item_Game_Box_s_09.gif" width=35></TD>';
echo '</TR></TBODY>';
echo '</TABLE>';
echo '</TD></TR></TBODY>';
echo '</TABLE>';
echo '</DIV>';
}
}
else {
error_box('Putz >.<','Please report all errors to the staff.');
}
echo '<table width="100%" height="100%" align="center" id="loading">';
echo '<tr>';
echo '<td align="center" valign="middle">';
echo '<table bgcolor="#666666" cellspacing="9" border="1" width="250" height="60">';
echo '<tr>';
echo '<td align="center">';
echo '<font size="2" color="#eeeeee">loading...</font>';
echo '</td>';
echo '</tr>';
echo '<tr>';
echo '<td>';
echo '<marquee direction="right" width="250" scrollamount="8">';
echo '<table width="250" height="5" bgcolor="white">';
echo '<tr><td><p></td></tr>';
echo '</table>';
echo '</marquee>';
echo '</td>';
echo '</tr>';
echo '</table>';
echo '</td>';
echo '</tr>';
echo '</table>';
function error_box($title,$msg) {
global $v1, $v2;
echo '<DIV id=wrapper style="DISPLAY: none">';
echo '<TABLE height="100%" width="100%">';
echo '<TBODY><TR><TD vAlign=center align=middle>';
echo '<TABLE cellSpacing=0 cellPadding=0 border=0><TBODY>';
echo '<TR><TD width=35><IMG height=40 src="http://forum.ragezone.com/images/Item_Game_Box_s_01.gif" width=35></TD>';
echo '<TD class=white style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 5px" vAlign=top align=middle background="http://forum.ragezone.com/images/Item_Game_Box_s_02.gif"><STRONG>'.$title.'</STRONG></TD>';
echo '<TD width=35><IMG height=40 src="http://forum.ragezone.com/images/Item_Game_Box_s_03.gif" width=35></TD></TR>';
echo '<TR>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_04.gif"> </TD>';
echo '<TD class=orange style="PADDING-BOTTOM: 20px; PADDING-TOP: 20px; background: #191D20" align=middle width=200><STRONG><SPAN style="WIDTH: 280px">'.$msg.'</SPAN></STRONG></TD>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_06.gif"> </TD>';
echo '</TR>';
echo '<TR>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_04.gif"> </TD>';
echo '<TD class=orange style="PADDING-BOTTOM: 20px; PADDING-TOP: 20px; background: #191D20" align=middle>';
echo '<IMG style="CURSOR: pointer" onclick="javscript:location.href=\'./wshop.php?v1='.$v1.'&v2='.$v2.'\'" alt="Close" src="http://forum.ragezone.com/images/Btn_close.gif" border=0>';
echo '</TD>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_06.gif"> </TD>';
echo '</TR>';
echo '<TR>';
echo '<TD><IMG src="http://forum.ragezone.com/images/Item_Game_Box_s_07.gif" width=35></TD>';
echo '<TD background="http://forum.ragezone.com/images/Item_Game_Box_s_08.gif"> </TD>';
echo '<TD><IMG src="http://forum.ragezone.com/images/Item_Game_Box_s_09.gif" width=35></TD>';
echo '</TR></TBODY>';
echo '</TABLE>';
echo '</TD></TR></TBODY>';
echo '</TABLE>';
echo '</DIV>';
}
function query_db($query,$caller='Desconhecido'){
global $link;
hardlog($query);
$r=mssql_query($query);
return $r;
}
function hardlog($text){
$h=fopen('hardlog.txt','a');
if (is_writable('hardlog.txt')) {
if (!$h=fopen('hardlog.txt','a')) {
die('error opening hardlog.txt. Verify permissions.');
}
if (fwrite($h,"[".date("H:i:s G:i:s")."] ".$text."\n")===false){
die('Error on writing hardlog.txt, Verify permissions.');
}
fclose($h);
}
else{
die('Error on writing on hardlog.txt');
}
}
?>
<script>
document.body.scroll = "no";
function loaded()
{
setTimeout
loading.style.display = 'none';
wrapper.style.display = '';
}
</script>
</body></html>