Warzone Database (Stats viewer & calculator) by crab

[crab_]

Hello.
I'm working on my new project - "Warzone Stats Calculator".
http://warzone2100.info/

GitHub link https://github.com/crab312/warzone2100-database

Do anyone interested in such stuff?

Current supported functions

• View parameters of each weapon, body, propulsion etc (sort, search by columns, filter)
  note: use 'choose columns' button to see any avaiable parameters in tables
• View approximate time of research
• View parameters of given tanks for given research state (Tank Designer)
• Show DPS of tank design
• Show "abilities" of tanks

Planning

• View research requirements for each weapon,body, propulsion
• Calculate DPS of weapons for different states of research

(need hosting for my project) http://wz2100-db-ru.1gb.ru/stats.php

[Goth Zagog-Thou]

Actually thats a REALLY good idea. A stats editor/calculator running in a web browser would eliminate almost ALL issues with compatibility between 'Nix, Wind32 and MacOS, and could be readi.y updated/maintained.

There's no good reason it shouldn't work.

Nice going!

[vexed]

What was this written in, and what kind of database is it using ?

[crab_]

What was this written in, and what kind of database is it using ?

Program written in javascript, no database use.
Program read stats ini-files directly (using php parse_ini_file)
So it can run on any web server supporting php

[Rommel]

Excellent work Crab! I would like to suggest that you have side by side comparisons of the tank designer to allow one to easily compare builds - not a big issue and only something to do if it is easy and you have the time.

Oh and I would like to ask, what type of JS grid are you using there, looks like a nice one

Thanks again!

[crab_]

Hello.

I just upgraded my demo web-site.
Tank designer was improved http://wz2100-db-ru.1gb.ru/stats.html
List of new functions

• Tank designer: Show more parameters of tank design (time to build, time to research etc)
• Tank designer: Show DPS of tank design
• Tank designer: Show "abilities" of tanks. Enjoy!

Comparer of tanks is not ready yet, and i did not even started

I'm afraid my web-page will work slow on slow computers (i never care of performance, and i rarely care of testing my apps, of course)

@Rommel Thanks for nice words,it's pleasure to me

I would like to suggest that you have side by side comparisons of the tank designer to allow one to easily compare builds - not a big issue and only something to do if it is easy and you have the time.

This function in my ToDo list, you should understand: we cannot calculate total effectiveness of units because we cannot emulate players actions, but yes, we can do approximate calculations.

Oh and I would like to ask, what type of JS grid are you using there, looks like a nice one

I use JqGrid. i just learning web

[Rommel]

Thanks for the update Crab! Great work, especially seeing that you are just learning!

There is also another cool JQuery widget called JqTree: http://mbraak.github.io/jqTree/ which would be great for showing the research path for items, hint... hint... It would be a great addition to your web app as this seems the only thing to be lacking at this time, ie a good visual display of the research paths for each tech.

It would be cool if you had this in the research tab in the right pane below the "Props of selected item" block - ie when you click on a research item it would show the research path in the JqTree.

Once again, thanks for your hard work, I am sure many will come to appreciate the effort.

BTW if you have any trouble generating the JSON for the tree from the research ini files(or whatever they are), let me know as I might be able to help with this part as these recursive type routines can be difficult if you are just beginning - - although you seem to be doing pretty well so maybe you are a programmer learning web app design and don't need any help at all

[Rommel]

Hello.

@Rommel Thanks for nice words,it's pleasure to me

No problem, you deserve it for such a useful contribution!

This function in my ToDo list, you should understand: we cannot calculate total effectiveness of units because we cannot emulate players actions, but yes, we can do approximate calculations.

I wonder if NoQ could have some input here, he is very knowledgable about the equations and stuff, it would be nice if you could have like a "versus" feature where you could simulate in a basic way the outcome between two armies - hehe this would be fairly complex, but cool nonetheless!

Oh and I wanted to mention that some icons of the tech would be nice - you can actually get them from this link:

download these are the files to create the old docs and have most of the icons you would need. You can see how it works here - this is very old and out of date so you would only want to use the icons and generate the data as you are from the ini files.

Oh I see the research icons are missing from that - they used to be with the old techtree on this site, but have disappeared, someone must have them though.

I'm afraid my web-page will work slow on slow computers (i never care of performance, and i rarely care of testing my apps, of course)

I am pretty sure that once you have it finished the admins would be happy to host it for you here on wz2100.net - at this time it loads pretty fast for me though.

[crab_]

it would be nice if you could have like a "versus" feature where you could simulate in a basic way the outcome between two armies - hehe this would be fairly complex, but cool nonetheless!

i was thinking about it. It is complex, i can make simplified model where tanks not move and have absolute long range.

Oh and I wanted to mention that some icons of the tech would be nice - you can actually get them from this link:

nice! Now i can make better analog of WZ Guide than we have now. Thank you!
Sadly we cannot upload icons directly from game data because in Warzone all icons are 3d models actually.
Hmm, all icons have some uniqui names (not an IDs of warzone components), but i hope i will be able to get collation from code..

I am pretty sure that once you have it finished the admins would be happy to host it for you here on wz2100.net - at this time it loads pretty fast for me though.

He-he. not sure i can finish, because i like impove my stuff over and over until i get bored with it

There is also another cool JQuery widget called JqTree: http://mbraak.github.io/jqTree/ which would be great for showing the research path for items, hint... hint... It would be a great addition to your web app as this seems the only thing to be lacking at this time, ie a good visual display of the research paths for each tech.

I have experience with jqGrid TreeGrid Mode, recently i was making application with this tree.

Research Tree is not tree, actually. It is a graph. I was thinking how i can draw Research Tree.
I have experience of drawing Research Tree in tree controls, but i think this looks not very good.
Below is part of Research Tree required to research Needle Gun:

research_tree_sample.png (79.93 KiB) Viewed 15719 times

It would be cool if you had this in the research tab in the right pane below the "Props of selected item" block - ie when you click on a research item it would show the research path in the JqTree.

i can make it easily, but i'm afraid whole page will be too heavy... hmm i need to do some testing on slow PC..

Thank you.
I will continue work on project after a few days.

[Rommel]

Ah excellent I wasn't aware of the grid tree - I really hope you create something similar to what you have above in that image, it looks good to me You don't really have to do it with all the columns, just if you show the tree in the right pane of the research tab, just for a visual type thing to quickly find the research path. I am not sure how heavy this would be for the slow PC, but not so much I don't think.

[Rommel]

Btw I just found the old guide on the internet archive. Not sure if you had access to this working:

http://web.archive.org/web/201301151511 ... z2100.net/

[crab_]

Btw I just found the old guide on the internet archive. Not sure if you had access to this working:

http://web.archive.org/web/201301151511 ... z2100.net/

link working for me.
though i can see Old WZ Guide direct in my mind because i spent many time viewing it

(added some icons to my web-project)

btw, i like this guide page http://web.archive.org/web/201301182200 ... 100.net/r/
i want make similar page for research and for weapons (list weapon abilities, required research etc)

[Rommel]

Amazing what some images can do eh? Looks great!

In regards to the old guide, I really like the way the information is presented in it. It might be a good idea to try and mimic the way the old guide lays out the stats and such for the weapons etc.

From looking at your Database / Guide it seems that it is basically direct dumps of the data so it might be a good idea to try and format things a bit so it is easy to get to the information you want. I am sure you are doing this (and iin a better way!) just to make sure, that's all...

Anyways stick with it man you are doing an awesome job, this is something that is really needed for WZ now the old guide is gone (well almost gone!). I really love the platform you are using to deploy your guide, I think it will make it super simple to maintain, etc.

Hey have you thought of creating a project for it on Github? I ask this because then more people (like me) can help you with it!

Thanks again!

[crab_]

Pushed codes to github.
https://github.com/crab312/warzone2100-database

I ask this because then more people (like me) can help you with it!

help is welcomed but I am not sure is anyone able to read my codes and understand it correctly, cause i never care about anything in my code.
If you want to start from something, see scripts/common_objects.js
LoadDataObject(...) - reads data from server

[Duha]

Pushed codes to github.
https://github.com/crab312/warzone2100-database

I ask this because then more people (like me) can help you with it!

help is welcomed but I am not sure is anyone able to read my codes and understand it correctly, cause i never care about anything in my code.
If you want to start from something, see scripts/common_objects.js
LoadDataObject(...) - reads data from server

If you need I can make python script that converts ini files to json.