1 <!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 3.2//EN">
4 <TITLE> [IRCServices Coding] mysql support
6 <LINK REL=
"Index" HREF=
"index.html" >
7 <LINK REL=
"made" HREF=
"mailto:ircservices-coding%40ircservices.za.net?Subject=%5BIRCServices%20Coding%5D%20mysql%20support&In-Reply-To=F196Kegi0hz2UuQNlCl00005871%40hotmail.com">
8 <META NAME=
"robots" CONTENT=
"index,nofollow">
9 <META http-equiv=
"Content-Type" content=
"text/html; charset=us-ascii">
10 <LINK REL=
"Previous" HREF=
"001032.html">
11 <LINK REL=
"Next" HREF=
"001035.html">
13 <BODY BGCOLOR=
"#ffffff">
14 <H1>[IRCServices Coding] mysql support
</H1>
16 <A HREF=
"mailto:ircservices-coding%40ircservices.za.net?Subject=%5BIRCServices%20Coding%5D%20mysql%20support&In-Reply-To=F196Kegi0hz2UuQNlCl00005871%40hotmail.com"
17 TITLE=
"[IRCServices Coding] mysql support">aragon at phat.za.net
19 <I>Wed Jul
3 14:
33:
58 PDT
2002</I>
21 <LI>Previous message:
<A HREF=
"001032.html">[IRCServices Coding] mysql support
23 <LI>Next message:
<A HREF=
"001035.html">[IRCServices Coding] Re: [IRCServices Coding]
25 <LI> <B>Messages sorted by:
</B>
26 <a href=
"date.html#1034">[ date ]
</a>
27 <a href=
"thread.html#1034">[ thread ]
</a>
28 <a href=
"subject.html#1034">[ subject ]
</a>
29 <a href=
"author.html#1034">[ author ]
</a>
34 <PRE>|
<i> By Craig McLure
<<A HREF=
"http://www.ircservices.za.net/mailman/listinfo/ircservices-coding">frostycoolslug at hotmail.com
</A>>
35 </I>|
<i> [
2002-
07-
03 18:
59 +
0200 ]
36 </I>><i> I heard it wasnt done cause of the way the Databases were structured..
37 </I>><i> *ShRuGs* i'll get
1 of my Tech Admins to look at it :)
39 It shouldn't be too difficult to structure the sql tables for services. I
40 think the biggest difficulty is constructing all the queries to take care of
41 things like linked nicks, access lists, levels, etc. From my limited
42 understanding of how services works currently, it reads the entire db files
43 into memory and works with the data from there, dumping memory to the hard
44 drive every so often. You could probably employ the same technique with sql,
45 but that would mean *only* services would be able to perform changes safely.
46 Which kinda defeats the purpose of using sql :/
48 I wrote a script a while ago that reads in ircservices's nick.db and dumps
49 it into some sql tables so I can integrate some services features into our web
50 page. It works quite nicely. Users can login using their nickserv passwords,
51 check memos, edit their web info, etc. But, unfortunately its read only.
52 Hopefully I'll have time to convert chan.db sometime too.
64 <LI>Previous message:
<A HREF=
"001032.html">[IRCServices Coding] mysql support
66 <LI>Next message:
<A HREF=
"001035.html">[IRCServices Coding] Re: [IRCServices Coding]
68 <LI> <B>Messages sorted by:
</B>
69 <a href=
"date.html#1034">[ date ]
</a>
70 <a href=
"thread.html#1034">[ thread ]
</a>
71 <a href=
"subject.html#1034">[ subject ]
</a>
72 <a href=
"author.html#1034">[ author ]
</a>