08.11.2018, 09:21
I am sorry to say but I see no 'many changes'. You only fixed the unknown columns in line 216, everything else remained the same:
- no escaping input
- not deleting cache in one place
- no affected rows = success message anyway
- no index
Changing LIMIT 10 to LIMIT 100 does not change anything. You do not need LIMIT in the first place, just GROUP BY `S.No` and remove WHERE clause as well.
You also removed global option DUPLICATE_CONNECTIONS for no reason. Now any gamemode connecting to the same database and server will result in warning in mysql logs.
- no escaping input
- not deleting cache in one place
- no affected rows = success message anyway
- no index
Changing LIMIT 10 to LIMIT 100 does not change anything. You do not need LIMIT in the first place, just GROUP BY `S.No` and remove WHERE clause as well.
You also removed global option DUPLICATE_CONNECTIONS for no reason. Now any gamemode connecting to the same database and server will result in warning in mysql logs.