Witam
mam taki skrypt:
<?php
require 'config.php';
$conn = mssql_connect(\"$host\",\"$alogin\",\"$apass\");
mssql_select_db('MuOnline', $conn);
$query_reset = mssql_query(\"SELECT * FROM Character WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'\");
while($row_reset = mssql_fetch_array($query_reset))
{
$resetcount = $row_reset['Reset'];
$resetplus = $resetcount + 1;
$value_points = 350 * $resetplus;
}
if (mssql_num_rows(mssql_query(\"SELECT * FROM Character WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'\")) > 0) {
$row = mssql_fetch_array(mssql_query(\"SELECT * FROM Character WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'\"));
if ($row['cLevel'] > '349') {
if ($row['Money'] > $money) {
$money_total = $row['Money'] - $money ;
$query = mssql_query(\"
UPDATE Character SET cLevel = '1' WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'
UPDATE Character SET Money = Money-50000000 WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'
UPDATE Character SET Experience = '0' WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'
UPDATE Character SET LevelUpPoint
= Reset*200 WHERE Name
= '\".$_POST['name
'].\"' AND AccountID
= '\".$_POST['login
'].\"' UPDATE Character SET Strength = '30' WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'
UPDATE Character SET Dexterity = '30' WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'
UPDATE Character SET Vitality = '30' WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'
UPDATE Character SET Energy = '30' WHERE Name = '\".$_POST['name'].\"' AND AccountID = '\".$_POST['login'].\"'
UPDATE Character SET
Reset = Reset+1 WHERE Name
= '\".$_POST['name
'].\"' AND AccountID
= '\".$_POST['login
'].\"'\"); if (!$query) {
echo \"<font color='0099FF'><font size='2'>Character Reset could not be properly preformed. Database threw an error.\"; } else {
echo \"<font color='0099FF'><font size='2'>\".$_POST['name'].\" is successfully Reseted..\"; }
} else {
echo \"<font color='0099FF'><font size='2'>Character Reset could not be preformed. Not enough zen.\"; echo \"<br>Actual (\".$row['Money'].\") - Needed ($money)\"; }
} else {
echo \"<font color='0099FF'><font size='2'>Character Reset could not be preformed. Your not Level 350.\"; }
} else {
echo \"<font color='0099FF'><font size='2'>Character Reset could not be performed. Character \".$_POST['name'].\" or the Login given do not match.\"; }
?>
ale chciałabym aby on działał dopiero wtedy gdy w kolumnie (rys. poniżej) ConnectStat wartość była 0, a gdy w tej samej kolumnie była wartość 1 to skrypt powyższy niezadziałał by