21.11.2011, 11:40
I was just about to just re-write it, cause before, it worked... last night, it was working perfectly... but now its... meh' pissing me off kinda.
I'll come back with the results.
Edit:
Also, run which Query twice?
format(Query, 128, "SELECT * FROM serverdata WHERE Enabled = 1");
Is ran three times, actually once.
1. To check if there's data in the Database.
2.A. If there's no data it is not ran the 2nd or 3rd time and the script moves on.
2.B. If there's data it's ran again, to get the Primary Key that is Enabled.
3. If there's data and the 2nd Query grabbed the Primary Key then this is called to start sending the data to MySQL and store them in the Server variable.
Like I said, I did no changes to the script since last night except try to find the problem by adding alot of print("Debug."); after every other line to see where it stops and it worked perfectly last night.
I'll come back with the results.
Edit:
Also, run which Query twice?
format(Query, 128, "SELECT * FROM serverdata WHERE Enabled = 1");
Is ran three times, actually once.
1. To check if there's data in the Database.
2.A. If there's no data it is not ran the 2nd or 3rd time and the script moves on.
2.B. If there's data it's ran again, to get the Primary Key that is Enabled.
3. If there's data and the 2nd Query grabbed the Primary Key then this is called to start sending the data to MySQL and store them in the Server variable.
Like I said, I did no changes to the script since last night except try to find the problem by adding alot of print("Debug."); after every other line to see where it stops and it worked perfectly last night.