Is it possible to convert an existing 2008 DB to 1.5 DB?

[gago117]

If it's possible, any ideas?

[MentaL]

[Dave]

It is. The most important tables would be AccountItem/Account/Character/CharacterItem/Clan/ClanMembers/Friend and Login.
I done that for 2007 -> 1.5.

Ideas, you say?
Just use SQL statements to convert it.

Example:

INSERT INTO GunzDB2.dbo.Login
(UserID, AID, Password, LastConnDate, LastIP)

SELECT 
GunzDB.dbo.Login.UserID,
GunzDB.dbo.Login.AID,
GunzDB.dbo.Login.Password,
GunzDB.dbo.Login.LastConnDate,
GunzDB.dbo.Login.LastIP
FROM GunzDB.dbo.Login 

Be sure to pay attention to the AID/CID's. If you ever deleted 1 row then you miss 1 CID/AID.

[gago117]

Too bad my AIDs/CIDs are messed up. So it isn't possible for my case.

[Dave]

Too bad my AIDs/CIDs are messed up. So it isn't possible for my case.

It is, I also had that problem. I just made a few scripts to correct the AID's.

[gago117]

Mind if you share 'em?


Well as I inspect the database, there are some blank registrations which I believe.. messed up the database.

[gago117]

Anyone?