Hi! How can I converter SDCH database (users) to PtokaX database?
P.S Sorry, I don't now english. =) I'm from Russia.
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?
QuoteOriginally 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. ;)
Thanks. Problem is no. I rename tables and columns and export to xml files. (SDCH's db is access)
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.
QuoteOriginally 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.
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
I want to convert DDCH registered users to PTOKAX. Registered users in DDCH are saved in 'Microsoft Office Access Database' file. Help needed.
can you export it to XML or CSV and send it to bastyaelvtars [at] gmail [dot] com mail addy?
how do i export it to xml or csv ?
or shall i send an example file ?
Quote from: enigma on 09 April, 2006, 23:55:23
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.
ya bastya i have sent u my ddch registered users file on ur mail address
Quote from: enigma on 10 April, 2006, 10:06:26
ya bastya i have sent u my ddch registered users file on ur mail address
Got it, and will try to export/convert.
ok tx