[Blacklite]

Quote:

Originally Posted by Kar X-X why don't you use smart updating.. you've been doing this shit for so long and still make those large queries.. obviously looks like some sort of mysql_format problem... '%d'? you've been here to long for that shit man.. no offence Try format, or try MySQL R7-2 plugin

There's nothing wrong with long queries. They are usually better than lots of short ones, and with UPDATE queries you can thread them and not bother retrieving the response.

Also one UPDATE means that you only search for the player record once - means less searching, even if your tables are indexed correctly (which they should be!).

I'd like to see how you update large amounts of account data.