From 23b33823473bc830c8f3c1e8850c03b1a5583450 Mon Sep 17 00:00:00 2001 From: DukePyrolator Date: Sun, 29 Nov 2009 07:56:35 +0000 Subject: updated database converter git-svn-id: http://anope.svn.sourceforge.net/svnroot/anope/trunk@2675 5417fbe8-f217-4b02-8779-1006273d7864 --- src/tools/db-convert.c | 1367 +++++++----------------------------------------- src/tools/db-convert.h | 1166 +++++++++++++++++++++++++++++++++++++++++ 2 files changed, 1344 insertions(+), 1189 deletions(-) create mode 100644 src/tools/db-convert.h (limited to 'src') diff --git a/src/tools/db-convert.c b/src/tools/db-convert.c index 5fb7bfd57..32cc2dbc2 100644 --- a/src/tools/db-convert.c +++ b/src/tools/db-convert.c @@ -14,306 +14,7 @@ * GNU General Public License for more details. */ - -#include -#include -#include -#include -#include -#include - -#ifndef _WIN32 -#include -#else -#include -#include -#endif -#include "sysconf.h" - -#include -#include -#include - -#ifndef _WIN32 -#define C_LBLUE "\033[1;34m" -#define C_NONE "\033[m" -#else -#define C_LBLUE "" -#define C_NONE "" -#endif - -#define getc_db(f) (fgetc((f)->fp)) -#define HASH(nick) ((tolower((nick)[0])&31)<<5 | (tolower((nick)[1])&31)) -#define HASH2(chan) ((chan)[1] ? ((chan)[1]&31)<<5 | ((chan)[2]&31) : 0) -#define read_buffer(buf,f) (read_db((f),(buf),sizeof(buf)) == sizeof(buf)) -#define write_buffer(buf,f) (write_db((f),(buf),sizeof(buf)) == sizeof(buf)) -#define read_db(f,buf,len) (fread((buf),1,(len),(f)->fp)) -#define write_db(f,buf,len) (fwrite((buf),1,(len),(f)->fp)) -#define read_int8(ret,f) ((*(ret)=fgetc((f)->fp))==EOF ? -1 : 0) -#define write_int8(val,f) (fputc((val),(f)->fp)==EOF ? -1 : 0) -#define SAFE(x) do { \ - if ((x) < 0) { \ - printf("Error, the database is broken, trying to continue... no guarantee.\n"); \ - } \ -} while (0) -#define READ(x) do { \ - if ((x) < 0) { \ - printf("Error, the database is broken, trying to continue... no guarantee.\n"); \ - exit(0); \ - } \ -} while (0) - -typedef struct memo_ Memo; -typedef struct dbFILE_ dbFILE; -typedef struct nickalias_ NickAlias; -typedef struct nickcore_ NickCore; -typedef struct chaninfo_ ChannelInfo; -typedef struct botinfo_ BotInfo; -typedef struct badword_ BadWord; -typedef struct hostcore_ HostCore; - -struct memo_ { - uint32 number; /* Index number -- not necessarily array position! */ - uint16 flags; /* Flags */ - time_t time; /* When was it sent? */ - char sender[32]; /* Name of the sender */ - char *text; -}; - -struct dbFILE_ { - int mode; /* 'r' for reading, 'w' for writing */ - FILE *fp; /* The normal file descriptor */ - char filename[1024]; /* Name of the database file */ -}; - -typedef struct { - int16 memocount; /* Current # of memos */ - int16 memomax; /* Max # of memos one can hold*/ - Memo *memos; /* Pointer to original memos */ -} MemoInfo; - -typedef struct { - uint16 in_use; /* 1 if this entry is in use, else 0 */ - int16 level; - NickCore *nc; /* Guaranteed to be non-NULL if in use, NULL if not */ - time_t last_seen; -} ChanAccess; - -typedef struct { - int16 in_use; /* Always 0 if not in use */ - int16 is_nick; /* 1 if a regged nickname, 0 if a nick!user@host mask */ - uint16 flags; - union { - char *mask; /* Guaranteed to be non-NULL if in use, NULL if not */ - NickCore *nc; /* Same */ - } u; - char *reason; - char *creator; - time_t addtime; -} AutoKick; - -struct nickalias_ { - NickAlias *next, *prev; - char *nick; /* Nickname */ - time_t time_registered; /* When the nick was registered */ - time_t last_seen; /* When it was seen online for the last time */ - uint16 status; /* See NS_* below */ - NickCore *nc; /* I'm an alias of this */ -}; - -struct nickcore_ { - NickCore *next, *prev; - - char *display; /* How the nick is displayed */ - char pass[32]; /* Password of the nicks */ - char *email; /* E-mail associated to the nick */ - char *greet; /* Greet associated to the nick */ - uint32 icq; /* ICQ # associated to the nick */ - char *url; /* URL associated to the nick */ - uint32 flags; /* See NI_* below */ - uint16 language; /* Language selected by nickname owner (LANG_*) */ - uint16 accesscount; /* # of entries */ - char **access; /* Array of strings */ - MemoInfo memos; /* Memo information */ - uint16 channelcount; /* Number of channels currently registered */ - int unused; /* Used for nick collisions */ - int aliascount; /* How many aliases link to us? Remove the core if 0 */ - - char *last_quit; /* Last quit message */ - char *last_realname; /* Last realname */ - char *last_usermask; /* Last usermask */ -}; - -struct chaninfo_ { - ChannelInfo *next, *prev; - - char name[64]; /* Channel name */ - char *founder; /* Who registered the channel */ - char *successor; /* Who gets the channel if the founder nick is dropped or expires */ - char founderpass[32]; /* Channel password */ - char *desc; /* Description */ - char *url; /* URL */ - char *email; /* Email address */ - time_t time_registered; /* When was it registered */ - time_t last_used; /* When was it used hte last time */ - char *last_topic; /* Last topic on the channel */ - char last_topic_setter[32]; /* Who set the last topic */ - time_t last_topic_time; /* When the last topic was set */ - uint32 flags; /* Flags */ - char *forbidby; /* if forbidden: who did it */ - char *forbidreason; /* if forbidden: why */ - int16 bantype; /* Bantype */ - int16 *levels; /* Access levels for commands */ - uint16 accesscount; /* # of pple with access */ - ChanAccess *access; /* List of authorized users */ - uint16 akickcount; /* # of akicked pple */ - AutoKick *akick; /* List of users to kickban */ - uint32 mlock_on, mlock_off; /* See channel modes below */ - uint32 mlock_limit; /* 0 if no limit */ - char *mlock_key; /* NULL if no key */ - char *mlock_flood; /* NULL if no +f */ - char *mlock_redirect; /* NULL if no +L */ - char *entry_message; /* Notice sent on entering channel */ - MemoInfo memos; /* Memos */ - char *bi; /* Bot used on this channel */ - uint32 botflags; /* BS_* below */ - int16 *ttb; /* Times to ban for each kicker */ - uint16 bwcount; /* Badword count */ - BadWord *badwords; /* For BADWORDS kicker */ - int16 capsmin, capspercent; /* For CAPS kicker */ - int16 floodlines, floodsecs; /* For FLOOD kicker */ - int16 repeattimes; /* For REPEAT kicker */ -}; - -struct botinfo_ { - BotInfo *next, *prev; - char *nick; /* Nickname of the bot */ - char *user; /* Its user name */ - char *host; /* Its hostname */ - char *real; /* Its real name */ - int16 flags; /* Bot flags */ - time_t created; /* Birth date */ - int16 chancount; /* Number of channels that use the bot. */ -}; - -struct badword_ { - uint16 in_use; - char *word; - uint16 type; -}; - -struct hostcore_ { - HostCore *next, *last; - char *nick; /* Owner of the vHost */ - char *vIdent; /* vIdent for the user */ - char *vHost; /* Vhost for this user */ - char *creator; /* Oper Nick of the oper who set the vhost */ - time_t time; /* Date/Time vHost was set */ -}; - -dbFILE *open_db_write(const char *service, const char *filename, int version); -dbFILE *open_db_read(const char *service, const char *filename, int version); -NickCore *findcore(const char *nick, int version); -NickAlias *findnick(const char *nick); -BotInfo *findbot(char *nick); -ChannelInfo *cs_findchan(const char *chan); -char *strscpy(char *d, const char *s, size_t len); -int write_file_version(dbFILE * f, uint32 version); -int mystricmp(const char *s1, const char *s2); -int delnick(NickAlias *na, int donttouchthelist); -int write_string(const char *s, dbFILE * f); -int write_ptr(const void *ptr, dbFILE * f); -int read_int16(int16 * ret, dbFILE * f); -int read_int32(int32 * ret, dbFILE * f); -int read_uint16(uint16 * ret, dbFILE * f); -int read_uint32(uint32 * ret, dbFILE * f); -int read_string(char **ret, dbFILE * f); -int write_int16(uint16 val, dbFILE * f); -int write_int32(uint32 val, dbFILE * f); -int read_ptr(void **ret, dbFILE * f); -int delcore(NickCore *nc); -void alpha_insert_chan(ChannelInfo * ci); -void insert_bot(BotInfo * bi); -void close_db(dbFILE * f); - -ChannelInfo *chanlists[256]; -NickAlias *nalists[1024]; -NickCore *nclists[1024]; -BotInfo *botlists[256]; - -int b64_encode(char *src, size_t srclength, char *target, size_t targsize); - - -#define LANG_EN_US 0 /* United States English */ -#define LANG_JA_JIS 1 /* Japanese (JIS encoding) */ -#define LANG_JA_EUC 2 /* Japanese (EUC encoding) */ -#define LANG_JA_SJIS 3 /* Japanese (SJIS encoding) */ -#define LANG_ES 4 /* Spanish */ -#define LANG_PT 5 /* Portugese */ -#define LANG_FR 6 /* French */ -#define LANG_TR 7 /* Turkish */ -#define LANG_IT 8 /* Italian */ -#define LANG_DE 9 /* German */ -#define LANG_CAT 10 /* Catalan */ -#define LANG_GR 11 /* Greek */ -#define LANG_NL 12 /* Dutch */ -#define LANG_RU 13 /* Russian */ -#define LANG_HUN 14 /* Hungarian */ -#define LANG_PL 15 /* Polish */ - - -const std::string GetLanguageID(int id) -{ - switch (id) - { - case LANG_EN_US: - return "en"; - break; - case LANG_JA_JIS: - case LANG_JA_EUC: - case LANG_JA_SJIS: // these seem to be unused - return "en"; - break; - case LANG_ES: - return "es"; - break; - case LANG_PT: - return "pt"; - break; - case LANG_FR: - return "fr"; - break; - case LANG_TR: - return "tr"; - break; - case LANG_IT: - return "it"; - break; - case LANG_DE: - return "de"; - break; - case LANG_CAT: - return "ca"; // yes, iso639 defines catalan as CA - break; - case LANG_GR: - return "gr"; - break; - case LANG_NL: - return "nl"; - break; - case LANG_RU: - return "ru"; - break; - case LANG_HUN: - return "hu"; - break; - case LANG_PL: - return "pl"; - break; - default: - abort(); - } -} +#include "db-convert.h" int main(int argc, char *argv[]) { @@ -521,39 +222,49 @@ int main(int argc, char *argv[]) // Enc pass b64_encode(nc->pass, hashm == "plain" ? strlen(nc->pass) : 32, (char *)cpass, 5000); - // Get language identifier - fs << "NC " << nc->display << " " << hashm << ":" << cpass << " "; - fs << nc->email << " " << nc->flags << " " << GetLanguageID(nc->language) << std::endl; + fs << "NC " << nc->display << " " << hashm << ":" << cpass << " " << nc->email; + fs << " " << GetLanguageID(nc->language) << nc->memos.memomax << " " << nc->channelcount << std::endl; std::cout << "Wrote account for " << nc->display << " passlen " << strlen(cpass) << std::endl; - if (nc->greet) - fs << "MD NC " << nc->display << " greet :" << nc->greet << std::endl; + fs << "MD NC greet :" << nc->greet << std::endl; if (nc->icq) - fs << "MD NC " << nc->display << " icq :" << nc->icq << std::endl; + fs << "MD NC icq :" << nc->icq << std::endl; if (nc->url) - fs << "MD NC " << nc->display << " url :" << nc->url << std::endl; + fs << "MD NC url :" << nc->url << std::endl; if (nc->accesscount) { - fs << "MD NC " << nc->display << " obsolete_accesscount :" << nc->accesscount << std::endl; for (j = 0, access = nc->access; j < nc->accesscount; j++, access++) - fs << "MD NC " << nc->display << " ns_access " << *access << std::endl; + fs << "MD NC access " << *access << std::endl; } - fs << "MD NC " << nc->display << " " << nc->memos.memomax; - + fs << "MD NC flags " + << ((nc->flags & NI_KILLPROTECT ) ? "KILLPROTECT " : "") + << ((nc->flags & NI_SECURE ) ? "SECURE " : "") + << ((nc->flags & NI_MSG ) ? "MSG " : "") + << ((nc->flags & NI_MEMO_HARDMAX ) ? "MEMO_HARDMAX " : "") + << ((nc->flags & NI_MEMO_SIGNON ) ? "MEMO_SIGNON " : "") + << ((nc->flags & NI_MEMO_RECEIVE ) ? "MEMO_RECEIVE " : "") + << ((nc->flags & NI_PRIVATE ) ? "PRIVATE " : "") + << ((nc->flags & NI_HIDE_EMAIL ) ? "HIDE_EMAIL " : "") + << ((nc->flags & NI_HIDE_MASK ) ? "HIDE_MASK " : "") + << ((nc->flags & NI_HIDE_QUIT ) ? "HIDE_QUIT " : "") + << ((nc->flags & NI_KILL_QUICK ) ? "KILL_QUICK " : "") + << ((nc->flags & NI_KILL_IMMED ) ? "KILL_IMMED " : "") + << ((nc->flags & NI_MEMO_MAIL ) ? "MEMO_MAIL " : "") + << ((nc->flags & NI_HIDE_STATUS ) ? "HIDE_STATUS " : "") + << ((nc->flags & NI_SUSPENDED ) ? "SUSPENDED " : "") + << ((nc->flags & NI_AUTOOP ) ? "AUTOOP " : "") + << ((nc->flags & NI_NOEXPIRE ) ? "NOEXPIRE " : "") + << ((nc->flags & NI_FORBIDDEN ) ? "FORBIDDEN " : "") << std::endl; if (nc->memos.memocount) { memos = nc->memos.memos; - fs << "MD NC " << nc->display << " obsolete_memocount :" << nc->memos.memocount << std::endl; for (j = 0; j < nc->memos.memocount; j++, memos++) - fs << "ME " << nc->display << " " << memos->number << " " << memos->flags << " " << memos->time << " " << memos->sender << " :" << memos->text << std::endl; + fs << "ME " << memos->number << " " << memos->flags << " " << memos->time << " " << memos->sender << " :" << memos->text << std::endl; } - - fs << "MD NC " << nc->display << " channelfoundercount " << nc->channelcount << std::endl; - /* we could do this in a seperate loop, I'm doing it here for tidiness. */ for (int tmp = 0; tmp < 1024; tmp++) { @@ -570,28 +281,24 @@ int main(int argc, char *argv[]) std::cout << "Writing: " << na->nc->display << "'s nick: " << na->nick << std::endl; - fs << "NA " << na->nc->display << " " << na->nick << " " << na->time_registered << " " << na->last_seen << std::endl; - -/* SAFE(write_int8(1, f)); - SAFE(write_string(na->nick, f)); - SAFE(write_string(na->last_usermask, f)); // core - SAFE(write_string(na->last_realname, f)); // core - SAFE(write_string(na->last_quit, f)); // core - SAFE(write_int32(na->time_registered, f)); - SAFE(write_int32(na->last_seen, f)); - SAFE(write_int16(na->status, f)); // needed? - SAFE(write_string(na->nc->display, f)); -*/ - + if (nc->last_usermask) + fs << "MD NA last_usermask :" << nc->last_usermask << std::endl; + if (nc->last_realname) + fs << "MD NA last_realname :" << nc->last_realname << std::endl; + if (nc->last_quit) + fs << "MD NA last_quit :" << nc->last_quit << std::endl; + if ((na->status & NS_FORBIDDEN) || (na->status & NS_NO_EXPIRE)) + { + fs << "MD NA flags " + << ((na->status & NS_FORBIDDEN) ? "FORBIDDEN " : "") + << ((na->status & NS_NO_EXPIRE) ? "NOEXPIRE" : "") << std::endl; + } } } } } - - - /* Section II: Chans */ // IIa: First database if ((f = open_db_read("ChanServ", "chan.db", 16))) @@ -603,7 +310,6 @@ int main(int argc, char *argv[]) for (i = 0; i < 256; i++) { - std::cout << "iteration " << i << std::endl; int16 tmp16; int32 tmp32; int n_levels; @@ -615,7 +321,6 @@ int main(int argc, char *argv[]) while ((c = getc_db(f)) == 1) { - std::cout << "got a channel" << std::endl; int j; if (c != 1) @@ -822,105 +527,135 @@ int main(int argc, char *argv[]) { int j; - /* if (!ci->founder) + /* commented because channels without founder can be forbidden + if (!ci->founder) { std::cout << "Skipping channel with no founder (wtf?)" << std::endl; continue; }*/ - fs << "CH " << ci->name << " " << (ci->founder ? ci->founder : "") << " " << (ci->successor ? ci->successor : " ") << " " << ci->time_registered << " " << ci->last_used << " " << ci->flags << std::endl; - + fs << "CH " << ci->name << " " << ci->time_registered << " " << ci->last_used; + fs << " " << ci->bantype << " " << ci->memos.memomax << std::endl; + if (ci->founder) + fs << "MD CH founder " << ci->founder << std::endl; + if (ci->successor) + fs << "MD CH successor " << ci->successor << std::endl; + fs << "MD CH lvl"; for (j = 0; j < 36; j++) { - fs << "CHLVL " << ci->name << " " << j << " " << ci->levels[j] << std::endl; + fs << " " <levels[j]; + } + fs << std::endl; + fs << "MD CH flags " + << ((ci->flags & CI_KEEPTOPIC ) ? "KEEPTOPIC " : "") + << ((ci->flags & CI_SECUREOPS ) ? "SECUREOPS " : "") + << ((ci->flags & CI_PRIVATE ) ? "PRIVATE " : "") + << ((ci->flags & CI_TOPICLOCK ) ? "TOPICLOCK " : "") + << ((ci->flags & CI_RESTRICTED ) ? "RESTRICTED " : "") + << ((ci->flags & CI_PEACE ) ? "PEACE " : "") + << ((ci->flags & CI_SECURE ) ? "SECURE " : "") + << ((ci->flags & CI_FORBIDDEN ) ? "FORBIDDEN " : "") + << ((ci->flags & CI_NO_EXPIRE ) ? "NOEXPIRE " : "") + << ((ci->flags & CI_MEMO_HARDMAX ) ? "MEMO_HARDMAX " : "") + << ((ci->flags & CI_OPNOTICE ) ? "OPNOTICE " : "") + << ((ci->flags & CI_SECUREFOUNDER ) ? "SECUREFOUNDER " : "") + << ((ci->flags & CI_SIGNKICK ) ? "SIGNKICK " : "") + << ((ci->flags & CI_SIGNKICK_LEVEL) ? "SIGNKICKLEVEL " : "") + << ((ci->flags & CI_XOP ) ? "XOP " : "") + << ((ci->flags & CI_SUSPENDED ) ? "SUSPENDED" : "") << std::endl; + if (ci->desc) + fs << "MD CH desc :" << ci->desc << std::endl; + if (ci->url) + fs << "MD CH url :" << ci->url << std::endl; + if (ci->email) + fs << "MD CH email :" << ci->email << std::endl; + if (ci->last_topic) // MD CH topic