Hi, I am developing a plugin which runs a query as follows (the IP addresses are converted into numbers):
sql = 'SELECT * FROM iprangebans WHERE start_ip <= %d AND end_ip >= %d AND time_end > 0' % (comparisonIP, comparisonIP)
cursor = self.console.storage.query(sql)
The correct results are returned (for example, 1 row). However, I then externally edit the data in MySQL (for example, delete all rows in the table) and it STILL CONTINUES to return the original data. When I restart b3, then it notices that the data has changed.
Does anyone know what the cause of this is, and how I can get around it? This is driving me insane.