Converter

[Cyxapeff]

Hi! How can  I converter SDCH database (users) to  PtokaX database?

P.S Sorry, I don't now english. =) I'm from Russia.

[HaArD]

There is a converter from PtokaX to SDCH, it shouldn't be hard to reverse the process. Is it just the registered users you need to convert? How many do you have?

[bastya_elvtars]

Originally posted by HaArD
There is a converter from PtokaX to SDCH, it shouldn't be hard to reverse the process. Is it just the registered users you need to convert? How many do you have?

Would be nice to know the file formats.

[Cyxapeff]

Thanks. Problem is no. I rename tables and columns and export to xml files. (SDCH's db is access)

[HaArD]

If you are knowledgable enough to rename tables and export them to XML files from the native Accessdb then you don't need my help to convert the info to Ptokax.

Everything about how PtokaX is configured is either documented on the Wiki or easily decipherable by looking at the files.

Good luck and let us know if you have problems.

[bastya_elvtars]

Originally posted by Cyxapeff
Thanks. Problem is no. I rename tables and columns and export to xml files. (SDCH's db is access)

OK, I did not find the SDCH website, cause I had a limited time. I didn't know that it's stored in an access db which I have no experience with.

[HaArD]

The Shadows Direct Connect Hub is dead. Tasman closed the Sourceforge project and released the 0.3.37 code to the public domain.

I will continue the development of SDCH at Sourceforge watch this site for details --> http://sdch.sourceforge.net

In addition, a group of the beta testers are planning to release a new hubsoft based on that code call DDCH, you can reach them at --> http://www.thescriptvault.net/forum/

Bastya,

For info about the SDCH Database I ran a script to export the table structures to MySQL for you:

# Exported from MS Access to MySQL
# (C) 1997-98 CYNERGI - [URL]www.cynergi.net,[/URL] [EMAIL]info@cynergi.net[/EMAIL]


CREATE TABLE BanNames
     (
     UserName             CHAR(40) NOT NULL,
     BannedBy             CHAR(40),
     RefDate              DATETIME NOT NULL,
     Reason               CHAR(50),
     Perm                 TINYINT NOT NULL,
     KEY (BannedBy),
     KEY (Perm),

     PRIMARY KEY (UserName),
     KEY (RefDate),
     KEY (UserName)
     )\g

# This table has no data

CREATE TABLE ClassTypes
     (
     ID                   SMALLINT NOT NULL DEFAULT 0,
     Name                 CHAR(20),
     KEY (ID),
     KEY (Name),
     PRIMARY KEY (ID)
     )\g

INSERT INTO ClassTypes VALUES (-1, 'Locked')\g
INSERT INTO ClassTypes VALUES (0, 'Unknown')\g
INSERT INTO ClassTypes VALUES (1, 'Regular')\g
INSERT INTO ClassTypes VALUES (2, 'Mentored')\g
INSERT INTO ClassTypes VALUES (3, 'Registered')\g
INSERT INTO ClassTypes VALUES (4, 'Invisible')\g
INSERT INTO ClassTypes VALUES (5, 'VIP')\g
INSERT INTO ClassTypes VALUES (6, 'Op')\g
INSERT INTO ClassTypes VALUES (7, 'Invisible Op')\g
INSERT INTO ClassTypes VALUES (8, 'Super Op')\g
INSERT INTO ClassTypes VALUES (9, 'Invisible Super Op')\g
INSERT INTO ClassTypes VALUES (10, 'Admin')\g
INSERT INTO ClassTypes VALUES (11, 'Invisible Admin')\g

CREATE TABLE Messages
     (
     Inbox                CHAR(40) NOT NULL,
     Date                 DATETIME,
     _From                CHAR(40) NOT NULL,
     Subject              CHAR(50),
     Message              LONGBLOB,
     KEY (Date),
     KEY (Inbox),
     KEY (Inbox)
     )\g

# This table has no data

CREATE TABLE UsrClass
     (
     UserName             CHAR(40) NOT NULL,
     Class                SMALLINT NOT NULL DEFAULT 0,
     KEY (Class),
     KEY (Class),
     PRIMARY KEY (UserName)
     )\g

# This table has no data

CREATE TABLE UsrDynamic
     (
     UserName             CHAR(40) NOT NULL,
     LastLogin            DATETIME,
     LastIP               CHAR(15),
     KEY (LastLogin),
     PRIMARY KEY (UserName),
     KEY (UserName)
     )\g

# This table has no data

CREATE TABLE UsrStatic
     (
     UserName             CHAR(40) NOT NULL,
     Pass                 CHAR(20) NOT NULL,
     RegedBy              CHAR(40) NOT NULL,
     RegDate              DATETIME NOT NULL,
     i18n                 CHAR(3),
     KEY (i18n),
     PRIMARY KEY (UserName),
     KEY (RegDate),
     KEY (RegedBy),
     KEY (UserName),
     KEY (UserName)
     )\g

# This table has no data

[enigma]

I want to convert DDCH registered users to PTOKAX. Registered users in DDCH are saved in 'Microsoft Office Access Database' file. Help needed.

[bastya_elvtars]

can you export it to XML or CSV and send it to bastyaelvtars [at] gmail [dot] com mail addy?

[enigma]

how do i export it to xml or csv ?

[enigma]

or shall i send an example file ?

[bastya_elvtars]

or shall i send an example file ?

You can send your database file (supposed to be .mdb) directly. I have no knowledge to do it from SQL but maybe from XML I can.

[enigma]

ya bastya i have sent u my ddch registered users file on ur mail address

[bastya_elvtars]

ya bastya i have sent u my ddch registered users file on ur mail address

Got it, and will try to export/convert.

[enigma]

ok tx