Seems to be using mssql,
and no its not complete but i remember this server files being released before
it could be that those did have the db ?
Try looking for stuff like this in hex
SELECT FriendID, Status, SvrNum, Position FROM tblMyFriend WHERE GameID
you see stuff like this meaning you can create a basic table already for the friends stuff
Code:
CREATE TABLE `tblMyFriend` (
`GameID` INT NOT NULL ,
`FriendID` INT NOT NULL ,
`Status` VARCHAR( 255 ) NOT NULL ,
`SvrNum` INT NOT NULL ,
`Position` INT NOT NULL ,
INDEX ( `GameID` )
) ENGINE = MYISAM
Made the table in mysql since i dont have mssql currently installed.
But you get my point.
But there is also stuff like this
CALL SP_UpdateFriendPos('%s',%d)
meaning you have to make these 2 in the mssql db
and figure out what the 2 values are and what you might need to do with them ;).
Code:
SELECT ProcessID, ServiceID, IP, Port, ChannelType, MaxChannelNum, GameName, UserCount, MaxUserCount , MinLvCondition , MaxLvCondition FROM %s WHERE GameType = %d and ServiceID > 0
SELECT ProcessID, ServiceID, IP, Port, ChannelType, MaxChannelNum, GameName, UserCount, MaxUserCount , MinLvCondition , MaxLvCondition FROM %s WHERE GameType = %d AND ProcessID > %d and ServiceID > 0
SELECT ProcessID, ServiceID, IP, Port, ChannelType, MaxChannelNum, GameName, UserCount, MaxUserCount , MinLvCondition , MaxLvCondition FROM %s WHERE GameType = %d AND ProcessID <= %d and ServiceID > 0
SELECT COUNT(*) FROM %s WHERE GameType = %d AND ServiceID > 0
SELECT COUNT(*) FROM %s WHERE GameType = %d AND ProcessID > %d and ServiceID > 0
SELECT COUNT(*) FROM %s WHERE GameType = %d AND ProcessID <= %d and ServiceID > 0
easy to find in hex etc,
To bad the pdb files arent included since that most of the time contains enough information to completly restore the db :p.