I have a script that runs everyday using a cron job but I can’t figure out why the database won’t update.
This script is from 2005, I haven’t scripted since then so learning mysqli has been difficult. I would appreciate any help.
<?php $con=mysqli_connect("domain","user","password","database"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if ($_GET[pass] == 'password') { mysqli_query("update players set age=age + 1"); mysqli_query("update players set donator=donator - 1 where donator > 0 , $con"); mysqli_query("update players set zonedays=zonedays + 1 where zone > 0 , $con"); mysqli_query("update players set sentence=sentence - 1 where sentence > 0 , $con"); mysqli_query("update players set jailed='N' where sentence = 0 AND jailed='Y' , $con"); exit; } print "ERROR COMMAND NOT GIVENEmail: | |
Password: | |