Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: MySQL Structure  (Read 12651 times)

0 Members and 1 Guest are viewing this topic.

iScripters

  • Guest
MySQL Structure
« on: February 06, 2006, 08:36:59 PM »

Hi,

I've been working on a page displaying all of the tables and fields created by Anope, and would like to share it :)

I'm still adding information, it's not finished yet.. some things I can't figure out on my own because either the fields in my database are empty or because i can't make anything out of the field name..

Help would be apreciated (and creditted)



http://jals.kicks-ass.net/anope.html
Logged

Dave Robson

  • Team
  • *
  • Offline Offline
  • Posts: 357
(No subject)
« Reply #1 on: February 06, 2006, 08:56:37 PM »

It might be nice to include this in the wiki, that way people could update it without needing to email you if they know what the unknown fields do.

Just a suggestion :)
Logged

iScripters

  • Guest
(No subject)
« Reply #2 on: February 06, 2006, 08:57:54 PM »

Ahh good one :) Will do this later tho..
Busy on some PHP script atm xD
Logged

Vorex

  • Guest
(No subject)
« Reply #3 on: February 06, 2006, 10:11:19 PM »

Quote
Originally posted by iScripters
Ahh good one :) Will do this later tho..
Busy on some PHP script atm xD

I whipped up a bash script to convert your info iScripters:
http://wiki.anope.org/MySQL

Now it just needs some linkage from the Main Page and it's all good.
Logged

iScripters

  • Guest
(No subject)
« Reply #4 on: February 07, 2006, 05:18:21 AM »

ty, looks good :)
Fixed spelling ;)
Logged

Vorex

  • Guest
(No subject)
« Reply #5 on: February 07, 2006, 05:32:10 AM »

Quote
Originally posted by iScripters
ty, looks good :)
Fixed spelling ;)


I can't spell for the life of me
Logged

Pieter Bootsma

  • Team
  • *
  • Offline Offline
  • Posts: 189
    • http://geniusdex.net/
(No subject)
« Reply #6 on: February 07, 2006, 09:05:45 AM »

I moved the page to http://wiki.anope.org/Technical_Documents:MySQL:Scheme . I'm updating the main page as we speak to include a link to this document. Also, if someone wants to make those table headers stand out a bit more (bold or something), please do so :)

[Edited on 7-2-2006 by GeniusDex]
Logged

Vorex

  • Guest
(No subject)
« Reply #7 on: February 07, 2006, 12:33:38 PM »

Quote
Originally posted by GeniusDex
I moved the page to http://wiki.anope.org/Technical_Documents:MySQL:Scheme . I'm updating the main page as we speak to include a link to this document. Also, if someone wants to make those table headers stand out a bit more (bold or something), please do so :)

[Edited on 7-2-2006 by GeniusDex]


After I posted it I saw http://wiki.anope.org/Other:ComparisonChart and figured it would have been nice to keep a consitancty with tables so maybe today i'll add some colour =P
Logged

FiXato

  • Guest
(No subject)
« Reply #8 on: February 15, 2006, 05:24:11 AM »

Looks nice guys!
Maybe a nice ERD to finish it? :)
Logged

iScripters

  • Guest
(No subject)
« Reply #9 on: February 17, 2006, 11:35:00 PM »

Uhhm, ERD? :P

Good you replied, reminds me of the fact that it's not even finished yet... xD


//Edit: Done some Googling... Entity Relationship Diagram? :)

[Edited on 17-2-2006 by iScripters]
Logged

FiXato

  • Guest
(No subject)
« Reply #10 on: February 18, 2006, 02:42:24 AM »

Indeed, that's the one.
It shows what relations there are between the tables and the minimal and maximal cardinalities between them.
So for instance, the relation of a user that can have multiple rooms, but a room that can't be owned by more than one user, can be shown in an ERD.
Logged

Symphonics

  • Guest
(No subject)
« Reply #11 on: February 19, 2006, 05:47:52 PM »

I was going to make a web interface for my network, but it wouldn't be much good unless it was live.
In the future, when anope might use mysql alone, I'll reconsider it.

Very usefull, though. Good job.
Logged

iScripters

  • Guest
(No subject)
« Reply #12 on: February 19, 2006, 07:20:01 PM »

I'm working on the same thing.. that's why I made this, I was also looking for some1 that could make a module, but the person I found did not reply my email :( so if any1 wants to make me the DLL, pmsg me for details
Logged

Trystan Scott Lee

  • Contributor
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 343
(No subject)
« Reply #13 on: February 23, 2006, 05:27:51 AM »

Try out the xmlrpc module.. its real time

http://searchirc.com/boards/viewtopic.php?t=3637
Logged
my God my tourniquet, return to me salvation

MicroLord

  • Guest
(No subject)
« Reply #14 on: February 24, 2006, 12:59:01 AM »

hey,
can anyone write a howto to install xmlrpc to anope?
Logged
Pages: [1]   Go Up