Poll

Shall I finish this project, and fix it up to release it into the ulx community?

Yes
6 (85.7%)
No
1 (14.3%)

Total Members Voted: 7

Author Topic: MySQL Multiserver Chat Idea  (Read 15565 times)

0 Members and 1 Guest are viewing this topic.

Offline rainbow Dash

  • Newbie
  • *
  • Posts: 35
  • Karma: -2
  • Owner of Friendship is Gaming Servers
    • Friendship is Gaming
Re: MySQL Multiserver Chat Idea
« Reply #15 on: October 20, 2013, 11:14:07 PM »
So uh, any chance this has been finished?
Uhm, whats a signature?

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 858
  • Karma: 416
  • Apple Innovations 2010®
    • Fun 4 Everyone Gaming
Re: MySQL Multiserver Chat Idea
« Reply #16 on: November 08, 2013, 10:56:53 PM »
So uh, any chance this has been finished?


Finished... oh god no...
Though, I've sent almost three years on this idea, and I started making it a year ago, with the help of some people who understand MySQL better than I do.  I've made some amount of progress on this, and I'll be linking a video shortly. It still has some issues, in all because it's mysql and not sockets... because sockets suck :p

This is from the Datatable. So you can get an idea of how it works.



These are some links here, you can watch me test around the thing. If you can, somehow try to watch the videos at the same time, though mute Server #1 because it has me talking and stuff. Also has a song that shouldn't be placed on this forum, so sorry :(
SERVER #1 - http://youtu.be/h_JPoKR7mVM
SERVER #2 - http://youtu.be/1PRsFrv7SnE
« Last Edit: November 09, 2013, 12:32:25 AM by chaos13125 »
Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.

Offline sabo

  • Full Member
  • ***
  • Posts: 136
  • Karma: 2
  • Hello :)
    • The Elite Gaming
Re: MySQL Multiserver Chat Idea
« Reply #17 on: November 09, 2013, 04:55:16 AM »
Looks really interesting, good job so far!

Are you able to use commands over multiple servers? Because if one does !slay * in one server it would slay all in all other servers <.< which might not be such an good idea ;_;

Offline Decicus

  • Hero Member
  • *****
  • Posts: 552
  • Karma: 81
    • Alex Thomassen
Re: MySQL Multiserver Chat Idea
« Reply #18 on: November 09, 2013, 05:01:15 AM »
This looks quite interesting, nice work!

Are you able to use commands over multiple servers? Because if one does !slay * in one server it would slay all in all other servers <.< which might not be such an good idea ;_;
Seems like this is possible, and that may cause issues in the future.
Contact information:
E-mail: alex@thomassen.xyz.
You can also send a PM.

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 858
  • Karma: 416
  • Apple Innovations 2010®
    • Fun 4 Everyone Gaming
Re: MySQL Multiserver Chat Idea
« Reply #19 on: November 09, 2013, 01:26:24 PM »
Looks really interesting, good job so far!

Are you able to use commands over multiple servers? Because if one does !slay * in one server it would slay all in all other servers <.< which might not be such an good idea ;_;

Well no. If you were watching carefully, you would notice you type !gslap... and it's only the commands that are listed in here. Though this thing requires ULX anyways, so if you don't have ulx then it won't work.

I couldn't remember (if their is a way to do it anyways) the way to just use console commands, but I remembered ULX has that there, so I just used it.


Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.

Offline Decicus

  • Hero Member
  • *****
  • Posts: 552
  • Karma: 81
    • Alex Thomassen
Re: MySQL Multiserver Chat Idea
« Reply #20 on: November 09, 2013, 02:18:33 PM »
Ah, fair enough. I didn't actually notice that. Thanks for verifying.
Contact information:
E-mail: alex@thomassen.xyz.
You can also send a PM.

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: MySQL Multiserver Chat Idea
« Reply #21 on: November 09, 2013, 02:33:12 PM »
Nicely done!
Experiencing God's grace one day at a time.

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 858
  • Karma: 416
  • Apple Innovations 2010®
    • Fun 4 Everyone Gaming
Re: MySQL Multiserver Chat Idea
« Reply #22 on: November 09, 2013, 02:51:01 PM »
Ah, fair enough. I didn't actually notice that. Thanks for verifying.

You are welcome. I also just remembered it was game.ConsoleCommand("\n"). So now I remember... anyways yeah.

Nicely done!

Thanks.


 I hope to be done by the end of the year. It still has some minor bugs, but I'm working them out. Anyone have any other suggestions to more commands I should add?
Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 858
  • Karma: 416
  • Apple Innovations 2010®
    • Fun 4 Everyone Gaming
Re: MySQL Multiserver Chat Idea
« Reply #23 on: November 09, 2013, 07:39:21 PM »
Anyone here REALLY good with any of the following:
Arithmetics
Mathematics
MySQL
???



I need some advice on something here for my addon.
Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 858
  • Karma: 416
  • Apple Innovations 2010®
    • Fun 4 Everyone Gaming
Re: MySQL Multiserver Chat Idea
« Reply #24 on: November 30, 2013, 02:20:21 AM »
So I'm almost done with it now, 99.8% glitch free now. The garry's mod addon part is finished, now I'm finishing the dumb steam open id part. Having a redirect issue now, as I don't really know how Open ID works or know too much php, it may take me a little longer than expected. You can see what public version of my Garry's Mod webchat part of the multiserver chat addon.

http://thetriworlds.com/dev/chat/
IF YOU DO DECIDE TO LOG IN, AFTER YOU CLICK THE LOGIN BUTTON ON THE STEAMCOMMUNITY.COM WEBSITE, YOU WILL NEED TO CLICK THIS LINK AGAIN AS IT DOES NOT REDIRCT YOU TO THE SAME PAGE FOR WHATEVER REASON.

So if your page looks like this after you successfully logged in, you did it correctly
Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: MySQL Multiserver Chat Idea
« Reply #25 on: November 30, 2013, 07:43:33 AM »
Very nice, Chaos!

Does the web chat auto-refresh?
Experiencing God's grace one day at a time.

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 858
  • Karma: 416
  • Apple Innovations 2010®
    • Fun 4 Everyone Gaming
Re: MySQL Multiserver Chat Idea
« Reply #26 on: November 30, 2013, 10:27:01 AM »
Very nice, Chaos!

Does the web chat auto-refresh?

Yes, because mysql is better for websites, and much better for chat systems (if you're going to use them like that), then it will auto refresh every second. The garry's mod one does every 3 seconds or it would crash. One thing that does not auto refresh is if you were to change your name while the website chat has been loaded...

Just that darn redirect issue remains.
Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.