Broadcaster NPC request

[Radian]

Hey everyone! does anyone of you got this kind of Broadcaster npc?

1. Payment per broadcast : zeny
2. Delay before player can broadcast again.
3. Can select previous message or message that has been broadcast
4. Banned an account by using this npc only?

If yes please can you share it with the community?

[Emistry]

try this 

https://pastebin.com/K0w5yFDL

 

[Radian]

Works perfectly... thanks @Emistry !

[Radian]

@Emistry Is it possible if the player selected their history message it wont show up again in the history selection?

[Emistry]

4 hours ago, Radian said:

@Emistry Is it possible if the player selected their history message it wont show up again in the history selection?

https://pastebin.com/K0w5yFDL

[Radian]

6 minutes ago, Emistry said:

https://pastebin.com/K0w5yFDL

[SQL]: DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[Debug]: at script.cpp:16434 - UPDATE `e_broadcast` SET `repeat` = 1 WHERE `id` = 1 LIMIT
[Debug]: Source (NPC): broadcast_main (invisible/not on a map)

SQL error. when history message selected.

[Emistry]

4 hours ago, Radian said:

SQL error. when history message selected.

you didnt re-create the sql table that provided.

[Radian]

3 hours ago, Emistry said:

you didnt re-create the sql table that provided.

I did update the SQL. with the latest one that has this one repeat right?

[Gouki]

having the same issue 

this is when you use one of the historical broadcast

[Emistry]

query_sql("UPDATE `e_broadcast` SET `repeat` = 1 WHERE `id` = "+.@id[.@i]+" LIMIT ");

change to 

query_sql("UPDATE `e_broadcast` SET `repeat` = 1 WHERE `id` = "+.@id[.@i]+" LIMIT 1");