TQ Data for Actions?

[theshadowpriest]

I've been looking thought some sources from the pinned thread here (

) and epvpers. I'm seeing some reference in some of them to officla TQ data for things like drop tables and actions.

 

Is the officla tq database leak available anywhere and/or what version of the game was it from?

 

The link here mentions there was a leak from 5066. I had a copy of some database that appeared to be tq data but referencing things like guns which sounds like Pirate items, which wasn't added until 5570 or so. For example I think one of the COPSv6 Sources some something in comments like "Generated from official database ([email protected])" 

 

Trying to find that original data it was ported from, unless this is more likely that it WAS convertedf rom the 5066 or later leaked data and stripped down and/or manually filled in to fit for 4351

 

I was trying to look for something further back like actual 5066 or earlier if there was anything available from that era? 

[CptSky]

There were multiple leaks around the patch 5065/5072/5095, but they are Chinese databases. Then, you have more recent leaks with English databases, but a lot has changed since then, so they are not always useful. Depends what you want to do with them.

The database you see in my old source is actually from 4356 and in English, but it isn't public nor shared.

[theshadowpriest]

Actual english or a translated to english version? Can cross reference some of the data from the chinese database to match up with some of the client side files like itemtype.dat, but the thing i noticed between the leaked data and the older client version is a lot of the itemtype ids differe.

I saw theres one on the mega.nz dump under the downloads here, a copy of the ZfServer which I assume is around the 5066 version leaks.

From what I could tell, it looks like the olde client itemtype.dat had 7 groups of item ids for helmets and armors, which appears to be the item stats of the same items but grouped into each dye colour for armor/helmet. In the leaked server side table for itemtypes, they don't seem to have those 7 groups. Was wanting to try do a cleaner convert for actions. 

 

Howed the older database data get around? I assume it was maybe more of a black market sale that was getting around... though surprised any of it was in english lol. 

 

 

 

[Konichu]

23 hours ago, theshadowpriest said:

Actual english or a translated to english version? Can cross reference some of the data from the chinese database to match up with some of the client side files like itemtype.dat, but the thing i noticed between the leaked data and the older client version is a lot of the itemtype ids differe.

I saw theres one on the mega.nz dump under the downloads here, a copy of the ZfServer which I assume is around the 5066 version leaks.

From what I could tell, it looks like the olde client itemtype.dat had 7 groups of item ids for helmets and armors, which appears to be the item stats of the same items but grouped into each dye colour for armor/helmet. In the leaked server side table for itemtypes, they don't seem to have those 7 groups. Was wanting to try do a cleaner convert for actions. 

Howed the older database data get around? I assume it was maybe more of a black market sale that was getting around... though surprised any of it was in english lol. 

There are leaks from 6800-7100+ DB in english, retail stuff but they're not easy to get and you may get scammed by some people too. There are some people claiming to have newer stuff, but it's probably not true.

There is also a very rare 4351 (or something close) english db, but this one you probably wont find out there. 

[theshadowpriest]

Yeah, I'd really love to have the 4351 database for reference, I don't have any interest in all the newer stuff. I'm not intersted in making another Online Poker game, I want to work with Conquer 2.0 when it was still an mmorpg

 

The chinese part doesnt bother me tooo much, I am more interseted in the actions and data for the original game. 

 

Is the ZfServer from Spirited's Cloud Share here (https://mega.nz/folder/xJQnlSRD#d4oLOGq2LNbKm_k8kYVKJw/folder/lVwX3YLJ) the 5066 one? 

[Konichu]

There are two leaks, one from Apr 2008 (~5040) and other Oct 2008 (~5071).

I havent downloaded that one from the link, but you may find out by the date.

No Flower or Rank module, files from Apr 19 2008, this is the version before talismans and new compose system, around 5040.

Version 5071 date is Oct 21 2008 and has Flower and Rank modules.

Edited March 26 by Konichu

[theshadowpriest]

Hmmm, thanks!

Well the files like the config.ini file and some others have a modified date of Octover 2008, so I'm guessing it would be the roughly 5071 if thats the case.

When trying to extract the data from the SQL server from those files however, there's data that was a little off putting, such as the cq_itemtype table containing items for pistols and guns, which suggested to me that it might actually be closer to version 5570 when Pirates were actually added.

If it IS in fact the 5071 leak which lines up with those dates as you suggest, it just means that TQ had data for the new ninja/pirate classes in the server long before they were actually implemented into the client and game itself.

I was really looking to find an older official leak to base our project on. The 4351 one would be as close to perfect as it could get I think. I jus didnt want to have to wade through and deal with all that extra crap if possible. If you know of anything better I could base from, I'd greatly apricate it. The project I'm working on aims to recreate and preserve a classic conquer experience. Viva nostalgia

[Konichu]

Those are the only two public leaks, I'm sorry.

I'd sugest you to re-create the scripts using LUA instead of hard coding in the server or using actions and tasks from tq bins.

[theshadowpriest]

Yeah, definitely dont plan on hard coding that crap, aiming to move all that crap out of SQL into lua, just didnt want to have to deal with all the extra crap from that version

For example, all the extra items for ninja/pirates that appear in the tq database. Another thing that was quickly relevant with the cq_itemtype table when comparing it to the itemtype.dat of the 4300~ client around 2.0 was that all the armor/hats have an item id for each of the dye colours, where the cq_itemtype table does not, so a lot of the items, for armors/hats, dont match up. 

Edited March 26 by theshadowpriest

[Konichu]

ur database probably just aint clean

[theshadowpriest]

Well it's just the TQ database. Loaded up the binary and mysql server that came with it and dumped the data out.

AFAIK it's a "clean" dump of the original tq data, it just has heaps of extra crap from newer versions. And I wasn't sure if it was the 5071 database since I noticed the cq_itemtype table had a bunch of ninja and pirate items. But it seems like the data for pirates/ninjas was just in the database well before they were announced and offically added to the game. 

Anyway I think it's the best I'm gonna get. The structure is just an god damn nightmare lol. 

 

If there is anything else you can share I'd apricate it though. It's interesting content to review and ill take anything I can get