I can only find this: http://neeroscriptcollection.blogspot.com/2013/08/pvp-dota-sound.html but I cannot understand it fully, google translate is blocked here in my network.
it doesn't have the SQL queries. So if anyone has the Annie Ruru's PVP ladder, can somebody please share it? its eathena topic is 404.
Thanks!
just mirror ... in-case
dota_pvpladder.2.9.txt
dotasoundeffect_2.rar
actually I want to drop this script
just ... I have no idea it can become so popular ...
that "replace into" was slower than "update" statement, I learned that only after 3 years completed this script
I was using 'replace into' just because I wanted to squeeze that accessing 12 times query_sql into just 4 times
and ultramage also proposed to make the table make a huge 'update' every 1 minute to safe further memory