VOTING SCRIPT PROBLEM

[Cloud']

Votepoints won't add, can anyone help me?

Votingscript

 Spoiler

<div id="page">
<center>
<?php
$ip = $_SERVER['REMOTE_ADDR'];
$votepoint = 3;
$time=date('d.m.Y H:i:s');
$voterIP = $_SERVER['REMOTE_ADDR']; // voter ip address
$time=date('Y.m.d H:i:s');
$pingUsername = $_SESSION['user']; // $pingUsername is a custom field you can use to track your players user name or id number.
if(!isset($_SESSION['user']))
{

echo "No se olvide de iniciar sesi&oacute;n!";
}
else

{
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$vpuntos = odbc_exec($mssql, 'SELECT votepoints FROM [ACCOUNT_TBL] WHERE account=\''.mssql_escape_string($_SESSION['user']).'\'');

echo '<i>You have '.odbc_result($vpuntos, 'votepoints').' VPoint(s) </i><br /><br />';
echo 'You can vote 1 time every <b>12</b> hour(s).<br />';
echo 'Each time you vote, you earn 2 points for every vote.<br /><br />';





?>
<a href="http://www.gtop100.com/topsites/Flyff/sitedetails/asda-21179?vote=1&pingUsername=<?php echo''.$_SESSION['user'].''?>" target="_blank"><img src="images/vote.png" width="120" height="50" border="0" alt="Vota por Flyff"/></a>

<?php
}


}

?>

</center>
</div>

Pingback

 Spoiler

<?php
$authorized = array("127.0.0.1"); // authorized ips to prevent exploitation

if(!in_array($_SERVER["REMOTE_ADDR"],$authorized))
exit;

$success = abs($_POST["Successful"]); // 1 for error, 0 for successful
$reason = $_POST["Reason"]; // log reason the vote failed
$pingUsername = $_POST["pingUsername"];

include('/Inc/config.inc.php');

if($success == 0)
{
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints+\'3\' WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints1=votepoints1+\'3\' WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints2=votepoints2+\'3\' WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
}
?>

[xTwiLightx]

Any errors shown in the PHP error log?
Replace the \'3\' with 3, so remove the escaped quote signs. votepoints - votepoints2 are for sure integers, but you are trying to add a string to a number. This might work in PHP somehow, but fails in a lot of languages, this includes SQL.

[Cloud']

Originally Posted by xTwiLightx

Any errors shown in the PHP error log?
Replace the \'3\' with 3, so remove the escaped quote signs. votepoints - votepoints2 are for sure integers, but you are trying to add a string to a number. This might work in PHP somehow, but fails in a lot of languages, this includes SQL.

 Spoiler

<?php
$authorized = array("127.0.0.1"); // authorized ips to prevent exploitation

if(!in_array($_SERVER["REMOTE_ADDR"],$authorized))
exit;

$success = abs($_POST["Successful"]); // 1 for error, 0 for successful
$reason = $_POST["Reason"]; // log reason the vote failed
$pingUsername = $_POST["pingUsername"];

include('/Inc/config.inc.php');

if($success == 0)
{
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints1=votepoints1+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints2=votepoints2+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
}
?>

Still wont work

[raventh1984]

Make an check to see if you got any errors.

if($success == 0)
{
odbc_exec($mssql, 'USE [ACCOUNT_DBF]'); 
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints1=votepoints1+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints2=votepoints2+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
}
else
{
	echo 'There was an error';
}

In that case if you see on you web. There was an error then you can ask your self why is $_POST['Successful'] giving me an error .

[xTwiLightx]

Originally Posted by Cloud'

 Spoiler

<?php
$authorized = array("127.0.0.1"); // authorized ips to prevent exploitation

if(!in_array($_SERVER["REMOTE_ADDR"],$authorized))
exit;

$success = abs($_POST["Successful"]); // 1 for error, 0 for successful
$reason = $_POST["Reason"]; // log reason the vote failed
$pingUsername = $_POST["pingUsername"];

include('/Inc/config.inc.php');

if($success == 0)
{
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints=votepoints+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints1=votepoints1+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
odbc_exec($mssql, 'UPDATE [ACCOUNT_TBL] SET votepoints2=votepoints2+3 WHERE account=\''.mssql_escape_string($pingUsername ).'\'');
}
?>

Still wont work

Then check your PHP error logs...

[Cloud']

 Spoiler

[01-Nov-2016 00:37:28 Asia/Manila] PHP Warning: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver]Login timeout expired, SQL state S1T00 in SQLConnect in C:\Inetpub\vhosts\test-flyff.net\httpdocs\modules\vote.php on line 10
[01-Nov-2016 00:37:28 Asia/Manila] PHP Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\test-flyff.net\httpdocs\includes\xinc_functions.php on line 357
[01-Nov-2016 00:37:28 Asia/Manila] PHP Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\test-flyff.net\httpdocs\includes\xinc_functions.php on line 358
[01-Nov-2016 00:37:28 Asia/Manila] PHP Warning: odbc_result() expects parameter 1 to be resource, null given in C:\Inetpub\vhosts\test-flyff.net\httpdocs\includes\xinc_functions.php on line 359
[01-Nov-2016 00:37:28 Asia/Manila] PHP Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\test-flyff.net\httpdocs\modules\vote.php on line 92
[01-Nov-2016 00:37:28 Asia/Manila] PHP Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\test-flyff.net\httpdocs\modules\vote.php on line 93
[01-Nov-2016 00:37:28 Asia/Manila] PHP Warning: odbc_result() expects parameter 1 to be resource, null given in C:\Inetpub\vhosts\test-flyff.net\httpdocs\modules\vote.php on line 95
[31-Oct-2016 16:37:59 UTC] PHP Warning: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver]Login timeout expired,

This is my php error log.