UnrealIRCd RPC → SQL Live (beta)

Questions/suggestions/support regarding the admin panel, the JSON-RPC interface and other such software

Moderator: Supporters

Post Reply
armyn
Posts: 7
Joined: Sun Dec 28, 2025 5:57 pm

UnrealIRCd RPC → SQL Live (beta)

Post by armyn »

Hi,

Yesterday I started a new project, which is this one: https://github.com/Madriix/UnrealIRCd-RPC-SQL-Live
Its purpose is to enable the live recording of UnrealIRCd JSON-RPC data into a MySQL/MariaDB database, additionally aided by a bot connected to the IRC server. It's an alternative to UnrealIRCd SQL Stats (https://github.com/Madriix/unrealircd-sql-stats), which allows you to record data into MySQL at regular intervals set by crontab.

If you have any feedback, please let me know.
Valware
Official supporter
Posts: 76
Joined: Wed Mar 31, 2021 3:17 am
Location: Internet
Contact:

Re: UnrealRPC Tracker (beta)

Post by Valware »

Hey armyn,

Hope you're doing well. Nice project! I've starred it! Thanks for always thinking of UnrealIRCd in your projects, too.

Something I'm working on that you may be interested in... The ability to write server-side scripts in JavaScript! Here's a working example which implements an example bot directly on the IRCd: https://pastebin.com/LX2XE937

Come speak to me on the support network if you're interested
Got an idea for a module? Don't be shy! Come talk to me on #unreal-support
Like the support? Consider supporting us with a donation.
armyn
Posts: 7
Joined: Sun Dec 28, 2025 5:57 pm

Re: UnrealRPC Tracker (beta)

Post by armyn »

Hi @Valware

Since 2020/2021, I have several bots that I created using Node.js. Here are their names: https://i.postimg.cc/WzrP9hvh/share-8c3 ... e45fd3.png

I have already considered publishing the Quizz bot on GitHub (which is a copy of Trivia, with questions coming from a .txt file), as well as Tapavu (which is like a Seen bot).

The two other quiz bots are the same as Quizz but with shorter .txt files containing easier questions, and they are for two other channels.

There's also the text-based Uno game.

I have already thought about publishing this on GitHub, but these Node.js projects are my first creations, meaning the code is very messy, full of bugs, but still functional. The bugs on IRC aren't very noticeable (only about 1%). There are no classes; everything is in a single file named server.js. All the bots run on irc-framework. I would be embarrassed to publish this on GitHub. I've thought about starting over, redoing everything using classes, but it would take too long, and there are several bots. Would you like to see my Trivia bot via email? You could test it and import a .txt file. You'll see the code and be shocked :) But when you test it, you'll think, "At least it works."

The questions are pulled directly from the text file; they are not loaded into a cache first, so it's a dirty method.

As for the Sysop bot, here is everything it does (to be translated into English): https://www.wiki-irc.fr/Sysop The page isn't always up to date, but I code for Sysop several times a month to add features. Its code is also very messy, but I just don't feel motivated to redo everything in a professional way.
armyn
Posts: 7
Joined: Sun Dec 28, 2025 5:57 pm

Re: UnrealRPC Tracker (beta)

Post by armyn »

@Valware I spent about two hours adapting all of your Trivia code; it’s now available on the UnrealRPC Tracker. It was cool. I discovered that it’s much easier to build things when all the functions are already in place.
Post Reply