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

Zirius · Aug 31, 2014

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 · Aug 31, 2014

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

Zirius · Aug 31, 2014

AnnieRuru said:
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.

AnnieRuru · Aug 31, 2014

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 · Aug 31, 2014

AnnieRuru said:
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 · Aug 31, 2014

Zirius said:
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 | .announceannounce "blahblah",16|.announce;16 is bc_blueremove 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 · Sep 1, 2014

AnnieRuru said:
Zirius said:

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.

Click to expand...

no, I put 16 | .announceannounce "blahblah",16|.announce;16 is bc_blueremove 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?

jaBote · Sep 1, 2014

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

Zirius · Sep 1, 2014

Thanks!

@AnnieRuru,

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

hytsuya123 · Mar 31, 2016

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 · Jan 24, 2017

AnnieRuru said:
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 · Jan 25, 2017

Pandaaa said:
AnnieRuru said:

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

Click to expand...

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

Yes it work perfectly.

DiversityRO · Feb 28, 2017

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

AnnieRuru · Jan 13, 2019

found a bug on this script

Code:

[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 · Mar 14, 2019

AnnieRuru said:

found a bug on this script

Code:

[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?

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

Zirius

New member

AnnieRuru

~~Cute~Cute~Scripter~~

Zirius

New member

AnnieRuru

~~Cute~Cute~Scripter~~

Attachments

Zirius

New member

AnnieRuru

~~Cute~Cute~Scripter~~

Zirius

New member

jaBote

Community Contributors

Zirius

New member

hytsuya123

New member

Pandaaa

New member

mrlongshen

Noobies

DiversityRO

New member

AnnieRuru

~~Cute~Cute~Scripter~~

Virtue

New member

We value your privacy