who has AnnieRuru's PVP Ladder with announcement files and SQL queries?

[Zirius 1]

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!

[AnnieRuru 957]

of course I have, I'm the author

 

.... but some google search, somebody already mirror my file

 

http://pastebin.com/Ynze1S7P

http://tbro-ph.com/rAFreeFiles/NPC Scripts/

 

now I look back at this script ... that I made 6 years ago ... a lot of places can be improved

and I remember that I left out the "modify a value" option, which was took out from 2.7

 

though, I can guarantee this script still works in latest hercules

Edited August 31, 2014 by AnnieRuru

[Zirius 1]

of course I have, I'm the author

 

.... but some google search, somebody already mirror my file

 

http://pastebin.com/Ynze1S7P

http://tbro-ph.com/rAFreeFiles/NPC Scripts/

 

now I look back at this script ... that I made 6 years ago ... a lot of places can be improved

and I remember that I left out the "modify a value" option, which was took out from 2.7

 

though, I can guarantee that it will still works in latest hercules

 

but but I reached page 6. Thanks mam!

 

LOL. You can do some throwback and do " a lot of places can be improved ". That would be very exciting to wait for.

Edited August 31, 2014 by Zirius

[AnnieRuru 957]

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

 

however if changing 'replace into' into 'update' might need to update the whole script

and I have no motivation to improve this script, I rather focus on battleground scripts

[Zirius 1]

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

 

however if changing 'replace into' into 'update' might need to update the whole script

and I have no motivation to improve this script, I rather focus on battleground scripts

 

for me because of the stat and announcing the kills and deaths makes it more competitive and daring.

 

i'll read the whole script later, i just fixed the current to completely end the announce statement, seems like you need 3 args on announce, that's why the script's announce alters new broadcast's color.

 

thanks again.

[AnnieRuru 957]

i'll read the whole script later, i just fixed the current to completely end the announce statement, seems like you need 3 args on announce, that's why the script's announce alters new broadcast's color.

no, I put 16 | .announce

announce "blahblah",16|.announce;

16 is bc_blue

remove the 16 and you can put color code

 

btw, I have no idea why .announcekill was defaulted to off, it has to turn on

set .announcekill, 0; // announce who pawn who's head : 0 - off, 1 - on

[Zirius 1]

 

i'll read the whole script later, i just fixed the current to completely end the announce statement, seems like you need 3 args on announce, that's why the script's announce alters new broadcast's color.

no, I put 16 | .announce

announce "blahblah",16|.announce;

16 is bc_blue

remove the 16 and you can put color code

 

btw, I have no idea why .announcekill was defaulted to off, it has to turn on

set .announcekill, 0; // announce who pawn who's head : 0 - off, 1 - on

 

 

*Hope, I would be able to describe this. LOL.*

 

Mam, refer to attachment:

 

PVP Script outputs announcement 1 (blue)

Another script outputs announcement 2 (should be yellow)

 

But instead of yellow, outputs color blue as shown on 3.

 

LOL.

 

Btw, "|" operator is OR?

Edited August 31, 2014 by Zirius

[jaBote 438]

Yep, | is bitwise OR operator. Returns 1 on a bit if either A or B bits are set to 1.

[Zirius 1]

Thanks!

 

@AnnieRuru,

 

I don't know mam, but defining flag and color fixed that in mine. 

[hytsuya123 0]

how to enter Query this SQL statements ?? i am not understand ,give me a description placing SQL eddit sound announce..and give examples..

sorry iam newbie

[Pandaaa 2]

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

 

however if changing 'replace into' into 'update' might need to update the whole script

and I have no motivation to improve this script, I rather focus on battleground scripts

is this still compatible in Latest Hercules?? any updates?

[mrlongshen 22]

 

 

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

 

however if changing 'replace into' into 'update' might need to update the whole script

and I have no motivation to improve this script, I rather focus on battleground scripts

is this still compatible in Latest Hercules?? any updates?

Yes it work perfectly.

[DiversityRO 0]

Help. I added a new custom map and it doesnt announce there?

[AnnieRuru 957]

found a bug on this script

[Debug]: script debug : 2000000 110000960 : AnnieRuru is sit-killing EnnyRuru for 6 times
[Debug]: script debug : 2000000 110000960 : AnnieRuru is sit-killing EnnyRuru for 7 times
[SQL]: DB error - Out of range value for column 'streaks' at row 1
[Debug]: at d:\ragnarok\rathena\src\map\script.cpp:16590 - replace into pvpladder values ( 150000, 'AnnieRuru', -3, 0, 0, from_unixtime(1547405452) )
[Debug]: Source (NPC): DOTAPVP (invisible/not on a map)
[SQL]: DB error - Out of range value for column 'streaks' at row 1
[Debug]: at d:\ragnarok\rathena\src\map\script.cpp:16590 - replace into pvpladder values ( 150000, 'AnnieRuru', -2, 1, 0, from_unixtime(1547405460) )
[Debug]: Source (NPC): DOTAPVP (invisible/not on a map)
[SQL]: DB error - Out of range value for column 'streaks' at row 1
[Debug]: at d:\ragnarok\rathena\src\map\script.cpp:16590 - replace into pvpladder values ( 150000, 'AnnieRuru', -1, 2, 0, from_unixtime(1547405464) )
[Debug]: Source (NPC): DOTAPVP (invisible/not on a map)

should have used signed int for that field

yeah and this script didn't index the kill or death field either

maybe should release version 3 someday

[Virtue 10]

On 1/14/2019 at 2:55 AM, AnnieRuru said:

found a bug on this script

[Debug]: script debug : 2000000 110000960 : AnnieRuru is sit-killing EnnyRuru for 6 times
[Debug]: script debug : 2000000 110000960 : AnnieRuru is sit-killing EnnyRuru for 7 times
[SQL]: DB error - Out of range value for column 'streaks' at row 1
[Debug]: at d:\ragnarok\rathena\src\map\script.cpp:16590 - replace into pvpladder values ( 150000, 'AnnieRuru', -3, 0, 0, from_unixtime(1547405452) )
[Debug]: Source (NPC): DOTAPVP (invisible/not on a map)
[SQL]: DB error - Out of range value for column 'streaks' at row 1
[Debug]: at d:\ragnarok\rathena\src\map\script.cpp:16590 - replace into pvpladder values ( 150000, 'AnnieRuru', -2, 1, 0, from_unixtime(1547405460) )
[Debug]: Source (NPC): DOTAPVP (invisible/not on a map)
[SQL]: DB error - Out of range value for column 'streaks' at row 1
[Debug]: at d:\ragnarok\rathena\src\map\script.cpp:16590 - replace into pvpladder values ( 150000, 'AnnieRuru', -1, 2, 0, from_unixtime(1547405464) )
[Debug]: Source (NPC): DOTAPVP (invisible/not on a map)

should have used signed int for that field

yeah and this script didn't index the kill or death field either

maybe should release version 3 someday

were you able to update this or still usable?