Кода работи но, когато се се изпълнява този резд:
, после като не си обновява $modprice
трабва да рифрешвам за да стане... ето и целия код...
Код:
} else {mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$change' WHERE id='1'");, после като не си обновява $modprice
Код:
$query="SELECT `leva` FROM " . $tprefix . "finansi WHERE id = '1' ";
$result=mysql_query($query);
$modprice=mysql_result($result,0,"leva");трабва да рифрешвам за да стане... ето и целия код...
Код:
<?php
// Start PHP
$Mesg = (isset($_GET['Mesg']) ? $_GET['Mesg'] : 'None'); // Check language
$Action = (isset($_GET['Action']) ? $_GET['Action'] : 'Show'); // Check Action
$Type = (isset($_GET['Type']) ? $_GET['Type'] : 'public'); // Check Action
$Offset = (isset($_GET['Offset']) ? $_GET['Offset'] : 0); // Check Action
$Order = (isset($_GET['Order']) ? $_GET['Order'] : 'newsstamp'); // Check Action
$sort = (isset($_GET['Sort']) ? $_GET['Sort'] : 'Default'); // Check Action
// Do includes
include "../Config/mysql.php";
// end includes
// Connect to mysql DB
$dbl = @mysql_connect($hn,$un,$pw) // Connect to mysql dbase
or die ("
<html>
<head>
<title>K2News Management | Administration Control Panel</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1251\">
<link href=\"Templates/template.css\" rel=\"stylesheet\" type=\"text/css\">
</head>
<body bgcolor=\"#e4eaed\" leftmargin=\"0\" topmargin=\"0\" marginwidth=\"0\" marginheight=\"0\">
<Br><BR><BR>
<table width=\"40%\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\" bgcolor=\"415263\" align=center valign=middle>
<tr>
<td class=\"formtop\">
<font color=\"FFFFFF\">Mysql Error</font>
</td>
</tr>
<tr>
<td valign=\"top\">
<table width=\"100%\" border=\"0\" cellpadding=\"4\" cellspacing=\"0\" bgcolor=\"FFFFFF\">
<tr>
<td class=\"row1\"><b><img src='Images/error.gif' border=0></b> <font color=red><b>There has been an error connecting to the mySQL database. Please check your mysql.php file and make sure all the details are correct.</font></b><br></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
");
mysql_select_db($db); $chars="SET CHARACTER SET cp1251";mysql_query($chars);
// End connecting
// Do another Include
include "ad_functions.php";
// process language file
$sqlss = mysql_query_err("SELECT * FROM " . $tprefix . "settings WHERE setname='deflang'");
if ($sqlss)
{
while($row = mysql_fetch_array($sqlss))
{
$Lang = $row['setvalue'];
}
}
// End Another Include
// Do Session
session_start();
header("Cache-control: private");
if (!session_is_registered('k2news_isloggedin')) {
header("Location: index.php?Mesg=Session&Type=SessionCheck");
exit;
}
echo GetTemplate("Admin-Header.tpl");
echo GetTemplate("Admin-TopBar.tpl");
echo GetTemplate("Admin-NavBar.tpl");
// Do Middle
$buffer = " ";
echo GetTemplate("Admin-MidTableTop.tpl", "Валути и курсове");
echo GetTemplate("Admin-MidTableCellTop.tpl");
echo "<div class=\"creditstitle\">K<sup>2</sup>News Management - Credits</div><br><br>";
$query="SELECT `leva` FROM " . $tprefix . "finansi WHERE id = '1' ";
$result=mysql_query($query);
$modprice=mysql_result($result,0,"leva");
include "fiksing_bnb.php";
echo "<table border=\"0\" width=\"600\" id=\"table1\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"300\">
<p align=\"left\"><font size=\"3\">USD</font> <input type=\"text\" name=\"dada0\" value=\"$res[1]\" size=\"9\"> <font size=\"3\">$</font></td>
<td width=\"300\">
<p align=\"right\"><font size=\"3\">USD</font> <input type=\"text\" name=\"dada\" value=\"$modprice\" size=\"9\"> <font size=\"3\">$</font></td>
</tr>
</table><br><br>";
echo "<form method=\"POST\" action=\"ad_fiksing.php\">
<select size=\"1\" name=\"T2\">
<option selected value=\"1\">Добави към сегашната стойност.</option>
<option value=\"2\">Въведи нова стойност.</option>
</select><span lang=\"bg\"> </span>
<input type=\"text\" name=\"T1\" size=\"20\"><span lang=\"bg\">
</span><input type=\"submit\" value=\"Submit\" name=\"B3\"><input type=\"reset\" value=\"Reset\" name=\"B4\">
</form>";
$change = $_POST["T1"];
$type = $_POST["T2"];
$submit=$_POST["B3"];
$sum= round ($change+$res[1], 2);
if ($submit=="Submit"){
if ($type==1){
mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$sum' WHERE id='1'");
} else {mysql_query_err("UPDATE " . $tprefix . "finansi SET leva='$change' WHERE id='1'");
}
}
echo GetTemplate("Admin-MidTableCellBottom.tpl");
echo GetTemplate("Admin-MidTableBottom.tpl");
echo GetTemplate("Admin-Footer.tpl");
// na purvata stranica 6e ima zapis na dolara ot bnb v bazata danni
?>