Anope IRC Services

Anope.org => General Chat => Topic started by: iScripters on February 06, 2006, 08:36:59 PM

Title: MySQL Structure
Post by: iScripters 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
Title:
Post by: Dave Robson 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 :)
Title:
Post by: iScripters on February 06, 2006, 08:57:54 PM
Ahh good one :) Will do this later tho..
Busy on some PHP script atm xD
Title:
Post by: Vorex 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.
Title:
Post by: iScripters on February 07, 2006, 05:18:21 AM
ty, looks good :)
Fixed spelling ;)
Title:
Post by: Vorex 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
Title:
Post by: Pieter Bootsma 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]
Title:
Post by: Vorex 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
Title:
Post by: FiXato on February 15, 2006, 05:24:11 AM
Looks nice guys!
Maybe a nice ERD to finish it? :)
Title:
Post by: iScripters 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]
Title:
Post by: FiXato 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.
Title:
Post by: Symphonics 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.
Title:
Post by: iScripters 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
Title:
Post by: Trystan Scott Lee on February 23, 2006, 05:27:51 AM
Try out the xmlrpc module.. its real time

http://searchirc.com/boards/viewtopic.php?t=3637
Title:
Post by: MicroLord on February 24, 2006, 12:59:01 AM
hey,
can anyone write a howto to install xmlrpc to anope?