• 0
Zirius

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

Question

14 answers to this question

  • 0

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 by AnnieRuru

Share this post


Link to post
Share on other sites
  • 0

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 by Zirius

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

just mirror ... in-case

attachicon.gifdota_pvpladder.2.9.txt

attachicon.gifdotasoundeffect_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.

Share this post


Link to post
Share on other sites
  • 0

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

post-4102-0-34408000-1409524361_thumb.jpg

Share this post


Link to post
Share on other sites
  • 0

 

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:

post-6720-0-59593200-1409527566_thumb.png

 

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 by Zirius

Share this post


Link to post
Share on other sites
  • 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 :D

Share this post


Link to post
Share on other sites
  • 0

just mirror ... in-case

attachicon.gifdota_pvpladder.2.9.txt

attachicon.gifdotasoundeffect_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?

Share this post


Link to post
Share on other sites
  • 0

 

 

just mirror ... in-case

attachicon.gifdota_pvpladder.2.9.txt

attachicon.gifdotasoundeffect_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.

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0
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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now