Page 1 of 4

Warzone Database (Stats viewer & calculator) by crab

Posted: 26 Sep 2013, 00:44
by 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? :roll:

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
my_designer.png
(need hosting for my project) http://wz2100-db-ru.1gb.ru/stats.php

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 26 Sep 2013, 23:45
by 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!

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 27 Sep 2013, 03:33
by vexed
What was this written in, and what kind of database is it using ?

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 27 Sep 2013, 09:17
by crab_
vexed wrote: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 :)

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 27 Sep 2013, 20:44
by 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!

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 28 Sep 2013, 00:33
by 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

Rommel wrote: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.
Rommel wrote: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

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 28 Sep 2013, 11:10
by 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 :)

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 28 Sep 2013, 11:28
by Rommel
crab_ wrote:Hello.

@Rommel Thanks for nice words,it's pleasure to me
No problem, you deserve it for such a useful contribution!
crab_ wrote: 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.
crab_ wrote: 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.

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 28 Sep 2013, 12:49
by crab_
Rommel wrote: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.
Rommel wrote: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..
Rommel wrote: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 :)

Rommel wrote: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
research_tree_sample.png (79.93 KiB) Viewed 16187 times
Rommel wrote: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.

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 28 Sep 2013, 13:18
by 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.

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 30 Sep 2013, 02:57
by 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/

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 30 Sep 2013, 11:04
by crab_
Rommel wrote: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)

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 01 Oct 2013, 15:27
by 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!

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 01 Oct 2013, 20:56
by crab_
Pushed codes to github.
https://github.com/crab312/warzone2100-database
Rommel wrote: I ask this because then more people (like me) can help you with it!
help is welcomed :D 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

Re: Warzone Database (Stats viewer & calculator) by crab

Posted: 03 Oct 2013, 11:39
by Duha
crab_ wrote:Pushed codes to github.
https://github.com/crab312/warzone2100-database
Rommel wrote: I ask this because then more people (like me) can help you with it!
help is welcomed :D 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.