software/!RELEASES/ircservices/achurch.org/services/lists/ircservices/2001/001876.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
   2 <HTML>
   3  <HEAD>
   4    <TITLE> AW: [IRCServices] nick.db version 8 format (Addendum)
   5    </TITLE>
   6    <LINK REL="Index" HREF="index.html" >
   7    <LINK REL="made" HREF="mailto:ircservices%40ircservices.za.net?Subject=AW%3A%20%5BIRCServices%5D%20nick.db%20version%208%20format%20%28Addendum%29&In-Reply-To=EMEAJDMIHJFMOHONHAEDGEDECCAA.Georges%40Berscheid.lu">
   8    <META NAME="robots" CONTENT="index,nofollow">
   9    <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
  10    <LINK REL="Previous"  HREF="001875.html">
  11    <LINK REL="Next"  HREF="001877.html">
  12  </HEAD>
  13  <BODY BGCOLOR="#ffffff">
  14    <H1>AW: [IRCServices] nick.db version 8 format (Addendum)</H1>
  15     <B>Johan Yves August Grasmo</B>
  16     <A HREF="mailto:ircservices%40ircservices.za.net?Subject=AW%3A%20%5BIRCServices%5D%20nick.db%20version%208%20format%20%28Addendum%29&In-Reply-To=EMEAJDMIHJFMOHONHAEDGEDECCAA.Georges%40Berscheid.lu"
  17        TITLE="AW: [IRCServices] nick.db version 8 format (Addendum)">johanyg at ifi.uio.no
  18        </A><BR>
  19     <I>Wed May 16 20:59:01 PDT 2001</I>
  20     <P><UL>
  21         <LI>Previous message: <A HREF="001875.html">AW: [IRCServices] nick.db version 8 format (Addendum)
  22 </A></li>
  23         <LI>Next message: <A HREF="001877.html">AW: AW: [IRCServices] nick.db version 8 format (Addendum)
  24 </A></li>
  25          <LI> <B>Messages sorted by:</B>
  26               <a href="date.html#1876">[ date ]</a>
  27               <a href="thread.html#1876">[ thread ]</a>
  28               <a href="subject.html#1876">[ subject ]</a>
  29               <a href="author.html#1876">[ author ]</a>
  30          </LI>
  31        </UL>
  32     <HR>
  33 <!--beginarticle-->
  34 <PRE>On Wed, 16 May 2001 20:54:28 +0200 Georges Berscheid &lt;Georges Berscheid &lt;<A HREF="http://www.ircservices.za.net/mailman/listinfo/ircservices">Georges at berscheid.lu</A>&gt;&gt; wrote:
  35
  36 &gt;<i> Re,
  37 </I>
  38 &gt;<i> if you want to link services to your mysql db, use the C API which is
  39 </I>&gt;<i> documented at <A HREF="http://www.mysql.com/doc/C/_/C_API_function_overview.html">http://www.mysql.com/doc/C/_/C_API_function_overview.html</A>
  40 </I>
  41 Thank you very much Georges.
  42
  43 My main problem wasn't that I couldn't fetch the information
  44 from the mysql-db, but I didn't seem to construct the
  45 nicklists correctly.
  46 Below is a snippet of my code in load_ns_dbase in nickserv.c
  47
  48 Sorry for spamming like this, but I'm on the brink of giving
  49 up :(
  50
  51 Johan
  52
  53
  54 [snip]
  55     i = 0;
  56     while ((row = mysql_fetch_row(res))) {
  57
  58         ni = scalloc( sizeof *ni, 1 );
  59         nicklists[i++] = ni;
  60
  61         strcpy(ni-&gt;nick,row[1]);
  62         strcpy(ni-&gt;pass,row[0]);
  63         ni-&gt;email = sstrdup(row[2]);
  64
  65         log(&quot;debug: Loading user from mysql :  %s %s %s&quot;,
  66             ni-&gt;nick,
  67             ni-&gt;pass,
  68             ni-&gt;email);
  69
  70         ni-&gt;link = NULL;
  71         ni-&gt;accesscount = 0;
  72
  73         ni-&gt;last_quit = 0;
  74         ni-&gt;time_registered = 0;
  75         ni-&gt;last_seen = 0;
  76         ni-&gt;url = NULL;
  77         ni-&gt;status &amp;= ~NS_TEMPORARY;
  78
  79         if (!ni-&gt;last_usermask)
  80           ni-&gt;last_usermask = sstrdup(&quot;@&quot;);
  81         if (!ni-&gt;last_realname)
  82           ni-&gt;last_realname = sstrdup(&quot;&quot;);
  83         ni-&gt;id_timestamp = 999936289;
  84     }
  85     log(&quot;debug: Loaded users from database, found %d nicks&quot;, i);
  86
  87     mysql_close(sock);
  88
  89     /* Adjust next/prev pointers for all records.
  90        Remember: i points past the last element */
  91     nicklists[ 0 ]-&gt;prev = NULL;
  92     for ( j = 0; j &lt; i; ++j ) {
  93       if (j &gt; 0) {
  94         nicklists[ j ]-&gt;prev = nicklists[ j-1 ];
  95         nicklists[ j-1 ]-&gt;next = nicklists[ j ];
  96       }
  97     }
  98     nicklists[ i-1 ]-&gt;next = NULL;
  99
 100     /* ... and insert sentinel */
 101     nicklists[ i ] = NULL;
 102
 103
 104
 105 [/snip]
 106
 107
 108 </PRE>
 109
 110 <!--endarticle-->
 111     <HR>
 112     <P><UL>
 113         <!--threads-->
 114         <LI>Previous message: <A HREF="001875.html">AW: [IRCServices] nick.db version 8 format (Addendum)
 115 </A></li>
 116         <LI>Next message: <A HREF="001877.html">AW: AW: [IRCServices] nick.db version 8 format (Addendum)
 117 </A></li>
 118          <LI> <B>Messages sorted by:</B>
 119               <a href="date.html#1876">[ date ]</a>
 120               <a href="thread.html#1876">[ thread ]</a>
 121               <a href="subject.html#1876">[ subject ]</a>
 122               <a href="author.html#1876">[ author ]</a>
 123          </LI>
 124        </UL>
 125
 126 </body></html>