How to up item 190 in Zero Offline!

[nguyetdan]

How to up item 190 in Zero Offline! and somebody can help me edit data by kill monster drop zps

[idlemonkey]

to have an item level 190 you have to actually make that item in both the database and client .... currently there are not tools released that make it easy to do this other than a basic hex editor ...
to make a mob give zps either add an item that gives zps to the dropitem rule for that type or
add an action to award zps directly to that player ...
the structure of your action depends on your preferences
good luck

[nguyetdan]

Where can i edit by tool hex from?

[-The-Shadow-]

itemtype.dat (is the client side file needing updates to add higher level items or new items) using any commercial (payware, I tend to use winhex or ultraedit) or free hex editor (many can be found using google), you must add to the itemtype matching qualities of an item (0-9) in both the table cq_itemtype and the client itemtype.dat, then for compose purposes (support to +12) you must add matching compose values for every level of compose in both cq_itemaddition table and the itemaddition.ini.

However, manual addition of itemtypes will take a long time and takes understanding of the dat structure, unless you are well versed in such matters in regards to structure breakdowns I would give up now. Even with such understanding and mapping of the structure (which isn't public and I won't make it public) you would be better off making a db to dat dumping tool, otherwise it would take forever to manually add such content and have it work properly. (The tools I wrote do just that, db to dat creation after having remade the base tables from scratch due to them being garbage with huge inconsistencies and bugs.)

If you plan to break down the structure to actually learn how to do this properly, good luck to you and I suggest you use newer dat data to update the server side tables before making new dats with updated content. However few have the patience to actually spend the year+ doing this (reverse engineering dat structures and making table update scripts using dat data) and end up looking for an easy route when there isn't one.

Anyway, Good luck

Edit: I forgot to mention, besides adding the items to tables and dats so they exist, they also need client side model and texture bindings in the 3d ini's handling obj and textures by id match (mesh and textures) for every quality and level.


Edit 2: also.... if you are wondering why some servers who have people running them have added 190's when they don't know how to actually add them, it's simple, they are either using the stolen omniwar itemtype.dat from and older version that had 190's already added, or the bugged crazyzo dat, in short they just took already done work, but it isn't the right way, and doesn't match server tables, leaving fun bugs and glitches, the dat's NEED to match the server tables. So if you are going to do it, do it right and don't use someone's files that don't match. (ex: nates pos server that keeps coming back, uses stolen dats that don't match the server tables making it a forever bugged server)

[fayrouzena]

the shadow , why you keep frustrating everyone asking for knowledge and tell them to give up , you didn't give up did you ?? you know stuff that you have no intentions in sharing them with anyone thats fine just stop pushing people back its not the first time i seen you tell someone to better give up , we love the game and if too many of us united to create as bugless server as possible we would be happy to do it , or is it thats what you want ? the less people who figure out how to do it the better ?

[-The-Shadow-]

Originally Posted by fayrouzena

the shadow , why you keep frustrating everyone asking for knowledge and tell them to give up , you didn't give up did you ?? you know stuff that you have no intentions in sharing them with anyone thats fine just stop pushing people back its not the first time i seen you tell someone to better give up , we love the game and if too many of us united to create as bugless server as possible we would be happy to do it , or is it thats what you want ? the less people who figure out how to do it the better ?

I sure didn't, but wish I did in the end (I am also a dev with decades of experience to start with, not a beginner). Was it worth the 2 years I spent working on all of it? In my opinion, Nope ;p (I did also say what was needed to do the addition of 190's, so wasn't a brushoff, I did say what was needed and did say what to edit and what to use to do so and what the best course of action was for doing it right.)

I did say good luck if he plans on trying, but I have sat here for years answering the same questions with no one ever making progress because its real work (painful time consuming work) that pays nothing. I suggest giving up so they don't have to waste their life on something this broken just to make it playable with minimal bugs (can't actually fix them all, not without source or an emulated server written from scratch), I regret spending all that time that I could have worked on literally anything else and I actually like zo, and most who do spend the time on things like this end up regretting it in the end too.

I have nothing to gain from not having people run servers, I don't run one, I don't compete here, I retired from it, and it is as simple as that. To this day few have wanted to put in the effort in doing whats needed once they get into it, and knowing how much work it involves, I would always advise to not bother burning years of your life trying to fix this when you can make something you own instead without all the flaws and copyright problems, and if your just getting started, this is not the game to learn on.

So if you hate having a life/wife/girlfriend/(boyfriend/husband for the girl devs out there)/or income, then this is the best way to burn 16hours a day with endless frustration and ungrateful users who make you want to quit every day for a couple years then, if that is what you want to do with your life then go for it. That is what it means to fix this game and add to it. There isn't a single easy thing to work on as far as this game goes unless the intent is to steal someone elses work and swap paint textures, otherwise, years of work and headaches and just overall giving up having a life of any kind at all. It will consume every free moment you have. (Can ask idle to confirm that, he's become quite familiar with how much time working on zo consumes just to do every little thing and how much work it really is, he's been dealing with it for quite some time now and it only gets to be more work every time something needs to be fixed or added.)

For the record I have been over time helping those privately who have shown they are willing to put in the work and actually burn their days away working on it. They can choose to teach others if they feel like it, and it is up to them to go public if they want to. No Names will be given.

So yeah, can always ask, will likely get an answer eventually on what to dig into to fix (either me or someone else will likely answer), but most never continue once they see how much of a pain the dats are alone (or how much work is involved with replacing almost every single table in the server is, or feel like learning how to write c# or vb to make the tools needed to actually bulk fix and create content). No one ever gets past that part anyway. So I save time by suggesting giving up if your not ready to give up your days and nights for a couple years.

No one has to take my advice/instruction, or listen to what I say when I say what it takes to fix this or that, but if going that far, why bother asking, not a whole lotta people have the answers for this stuff or have spent the years knowing how much of a pain it is to work on and fix. I simply answered with a real answer (with truth, for that matter at least I even answered) and a warning of what it means to work on it. Anyone considering working on this disaster should be aware of the road ahead, they may not want to waste their time once they see how much work it will be (or that no one will hand them free pre-done fixes).

So yeah, this isn't an argument, just stating my peace on the matter.
Have a good one, and good luck to anyone actually putting in the effort.

(note: Personally I will give advice and direction, but will not give handouts and pre-done work or fixes, answers on what to look into will be given, but I won't hold anyone's hand, if your hand needs to be held to work on this game, this is the wrong game for you to work on. Think of it as a game for advanced devs, not beginners, even moderate dev's would have a hard time with this one. To pull off working this game as a beginner, you would have to be borderline obsessed with zo in an unhealthy way.)

[fayrouzena]

sir i apologize for my previous rudeness , as it appears to be you are very nice person , i am not a big follower to zero forum but i log in from time to time to see whats new and lately i think i seen you recommend people against trying to work on their own servers or something like that not sure anymore if that was you but hey never ruin an apology with an excuse .. i actually would like to try building my own server i just dont know where to begin and i have a quiet a big circle of friends who are regular players in zo and other private servers that willing to help if they learn how to do it , i believe that it can be done by a team effort , i am not a developer i am a CG designer not sure if that knowledge can help with something in the data base though

[nguyetdan]

I has edited . Now i do'nt know edit file sql. If you can share it for me?
Just want play offline!

[-The-Shadow-]

Originally Posted by nguyetdan

I has edited . Now i do'nt know edit file sql. If you can share it for me?
Just want play offline!

If by edit sql file, you mean edit the table that is in a running mysql server, then you need a mysql capable client tool, like phpmyadmin connected to that mysql server (runs in apache), or something commercial like navicat or ems mysql.

From there you can edit tables.

[nguyetdan]

Originally Posted by -The-Shadow-

If by edit sql file, you mean edit the table that is in a running mysql server, then you need a mysql capable client tool, like phpmyadmin connected to that mysql server (runs in apache), or something commercial like navicat or ems mysql.

From there you can edit tables.

yeah. I has use Navicat edit table mysql. Now i need edit any things?

[-The-Shadow-]

Originally Posted by nguyetdan

yeah. I has use Navicat edit table mysql. Now i need edit any things?

Yes, as I said, you need to add new entries to both cq_itemtype and cq_itemaddition, cq_itemtype must have all qualities from 0 to 9 (trailing number to the item is quality, it does not get a field to denote quality), and cq_itemaddition for all compose levels up to +12. (Small note, just adding 190's to your tables will mean adding a few hundred new rows of data in both itemtype and itemaddition, I would suggest using the 185's as base data templates to make bulk sql inserts or it will take a long time on the server side update. Secondary note, this also means adding hundreds of new entries to the itemtype.dat file and hundreds more to itemaddition.ini)

ex: 432259 would be 185 hammer ultra, you would need to add 432260 to 432269 for 190. 432 being hammer, 26 being the weapon increment since there are 25 hammers already, and 0 to 9 being the quality. cq_itemaddition does not use qualities but instead the compose increment and the table itself acts as the example.

Since those tables are still in Chinese and probably rendering the text in gibberish ascii on your system, you'll need to either find or write a codepage 437 to codepage 936 conversion app (or change your language display to Chinese which I don't recommend) if you want to turn them into an easy to read Chinese character set for translation. (My suggestion would be to write an encoder app in c# using encoder functions that has 2 multiline textboxes and a go button, where the go button takes the text pasted into the first textbox and outputs encode converted codepage into the second textbox as c# is pretty strait forward and there are plenty of preexisting examples of using encoder in c#.)

The data in the tables is self explanatory (field names give the majority of it away and also double as the hints of what might be in the dats), you just have to identify which item's you are looking for to add higher level versions. Then make sure those new items all exist in the client side with matching corresponding data. (3dobj and texture ini's, itemaddition ini and itemtype.dat, ani's for the icons and floordrop images.)

If none of that makes sense, I would suggest stepping back and working on something easier first, eo has similar table structures and many guides that essentially do the work for you (something I wont do), but it would give you a feel of what to look for and a better sense of what to edit server side. (Another note, eo stuff will not help with the client side dat work, only give a vague feeling of how to work on the server side tables and what might be where, and I am not saying the tables are the same, many are in fact quite different in structure and function.)

All in all this isn't anything quick to do, it will take a decent amount of time and patience to do by hand, not to mention if any single thing isn't matching or has a bad value, you are looking at bugs, so I would suggest doing 1 item type at a time and then test that 1 item type before going to the next so you can bug fix any that come up as things are added.