MySQL Multiserver Chat Idea

[Bite That Apple]

Hey, what's up ULX members, so do I have a question for you guys. Please give feedback on the idea:

So, without further ado, time to interest people who have multiple servers. My friend and I have created a MySQL chat system.
It's original purpose was to log chat for a web based thing (long story short: "That will be kept as secret as possible"), anyways it got more complex.

Now, this is my thing about this situation: I want to know if it will be any use the community, because it does has one bug in it, and I wasn't planning to fix it, though if the community finds it useful then I may give in and fix it to give to the entire ulx community.

Not only that, but I was going to keep this thing secret and have it as one of the tens to hundreds (being serious. I have a lot of free time, so these things happen a lot) of archived files of discontinued projects. Though, before I was going to move it there, I realized that I'm not going to make a garry's mod server ever again, and why leave this to sit in a sector in my hard drive forever, when maybe I might be willing to give it to the ulx community.

.. maybe one day when I have more time and care, I'll release more secret archived files..


So my last statement is:
If you think this might be a good idea and you would want it, then vote yes and leave a reply about it. If you have any questions about it, feel free to ask me.

[Megiddo]

Real-time multiserver chat using MySQL is not really a very good idea, but if it's something you think you can fix up in a few hours time, I know it has been requested on the forums before.

[Bite That Apple]

Real-time multiserver chat using MySQL is not really a very good idea, but if it's something you think you can fix up in a few hours time, I know it has been requested on the forums before.

Yes indeed it has been requested before.
http://forums.ulyssesmod.net/index.php/topic,5516.msg25146.html#msg25146

Yeah, I've been told this before to not use MySQL, instead use sockets or something like that, but there is a reason for what I wanted this to be MySQL

Also, it's not realtime. There's a three second pause, because it can't connect fast enough for real time.

[Bite That Apple]

I'm going to give this till next Monday. If not enough response happen for this to happen, then I'll close the thread and place the file in the archive.

End of Trail:
8/26/13

[Organik]

I suppose I'd be interested in this. Although I agree with Megiddo about MySQL being a bad solution to multi-server chat. I've been doing my best to avoid it and find something like sockets instead for this purpose. But for the ease of use.. I may give it a shot. And for my purpose.. I'd be using it for a server chat box on my community website. So maybe it won't be that bad.

[Bite That Apple]

I suppose I'd be interested in this. Although I agree with Megiddo about MySQL being a bad solution to multi-server chat. I've been doing my best to avoid it and find something like sockets instead for this purpose. But for the ease of use.. I may give it a shot. And for my purpose.. I'd be using it for a server chat box on my community website. So maybe it won't be that bad.

I don't like sockets. I haven't had much success with them. What ends up happening is that because it's realtime, it lags it or it expects the next message to fast.

[Organik]

This addon works great: http://facepunch.com/showthread.php?t=1256119

However, it doesn't work for my intended purpose yet. He included a basic PHP class with the addon, but it's limited to just sending messages to the server right now, and I don't have the technical know how on sockets to be able to write a receive PHP function.

But.. does this mean you'll release yours? 

[Bite That Apple]

This addon works great: http://facepunch.com/showthread.php?t=1256119

However, it doesn't work for my intended purpose yet. He included a basic PHP class with the addon, but it's limited to just sending messages to the server right now, and I don't have the technical know how on sockets to be able to write a receive PHP function.

But.. does this mean you'll release yours? 

I don't know yet. I've been going over the thing again, and it appears that there's a lot wrong with the chat. I'll have to check something again, I just need to fix the last received ID, then it will be working

[Organik]

Well, take your time. Since you say you have a lot of it anyways.

I don't need it anytime soon anyways.

[Megiddo]

What ends up happening is that because it's realtime, it lags it or it expects the next message to fast.

That's not how sockets work. If programmed properly, it should be waiting on system interrupts for data, which would cause zero lag.

[rainbow Dash]

if it uses MySQL, it would start filling up a database fast full of text. So how does it handle that?

And how does it handle special characters?

[Bite That Apple]

if it uses MySQL, it would start filling up a database fast full of text. So how does it handle that?

And how does it handle special characters?

It was made to delete any message ID that is past 50, and only stores the last 50 messages. Special characters just don't get inserted.

I'll give an example on how it done, off the top of my head. So most likely did it wrong.

Code: [Select]

local tb = {a,A,b,B,c,C,1,2,3}
local checker = string.explode(tb,",")
local abc = string.find(text, checker)
if abc == true then return end


[rainbow Dash]

I see. What sort of transfers are we talking about aswell? Can it like do one way connections, or elaborate setups where certain servers can hear others and some cannot, or is it just "Everyone can hear everyone"? or can that be configured?

[Bite That Apple]

I see. What sort of transfers are we talking about aswell? Can it like do one way connections, or elaborate setups where certain servers can hear others and some cannot, or is it just "Everyone can hear everyone"? or can that be configured?

Everyone can hear everyone. There is a little identify variable though when each server talks.
I.E. If Server {A} talks, then when Server {B} is listening to it, it will display "{A} Player Name: text"

[rainbow Dash]

Ahh... I see.

Well, I think this is a really good mod for those with large communities (or those who wish to monitor stuff from a test server huehue)



*edit: Please refrain from using swear words.*