[under-dev]Character monitor

hi my friends
hi rappelz dev.

i'm going to finish my first application for RAPPELZ private server
maybe it's simple but it's seem to be helpful and maybe in new versions make it controller not
just a monitor

but i need some help to complete it and release it

before i tell you my problem i want to tell you the specification of my application :

first this is the english main window :

[Only registered and activated users can see links. Click Here To Register...]

as you can see it give u some of most checked things about any character

as a brief of specification:

*very easy to use
*you can use it without upload it to server
*view all character in game(to make it easy looking for character)
*view most checked properties in character (as in photo)
--*like gold,chaos,level ,max level reached,AP ,P...etc
*view the job of character
*view other char. at same account in one click
*view items in bag
*view items in warehouse
*view character skills
*view character buffs(states)
*view character titles
*(soon) check character properties(like :p.atk,p.def,m.def,m.atk ...)
* very easy to translate the application to other language

i think the last one is special and it's to easy ; all u have to do is to copy any file from LANG folder then rename it and start translating the files then the app. will automatically add this language to menu


now my problems

*as i said before i'm going to make the application check for character property like p.atk m.atk ...etc , but i searched for this in Telecaster Table by table but can't find any thing related for this ,, so if any one could help me finding it

* the other problem is about huntaholic and arena enter count :
these two value are from table [Telecaster.dbo.Character]
columns :
1- huntaholic = huntaholic_enter_count
2-arena = arena_mvp_count

but i don't think these column which i want ..isn't it ?!!
so i want to make sure about this


===========
about arena count i really confused about two column and what is it for

arena_penalty_count
arena_mvp_count
===========

-----------------------------------------------------------

and i want to ask what do you suggest to make the application better for monitoring characters in game
i want to try to make it the best character monitoring tool hhhh :pimp: ;) :pimp:
===============

my pleasure ColonelX [eng.Ibraheem]

Very nice project, man, good luck i will translate it in french when you post the download link :)

Quote:

Originally Posted by Tosh54 Very nice project, man, good luck i will translate it in french when you post the download link :)

of course, i will be proud :D

Good luck ! :)

good job

if u want to calculate the p.atk .... etc

u'll have to calculate the stats from buffs - items - passive skills - jlv - titles - basic stats(wisdom .. etc) - every thing which affects on the stats

i think this is the only way to get the stats

lol !! it's seems to be hard

Quote:

Originally Posted by colonelx lol !! it's seems to be hard

It isnt that hard as you think. Split your work into 3 parts.

1st: calculate basic stats (without buffs , equip, etc)
{ if you want i could send you these formels, since i needed them for my "Manage it" program i allready got them}

2nd: calculate the stats given by buffs (this is the hard part i think :D)

3rd: calculate the stats wich are given by equip (dont forget soulstones, beltpets, etc)


Then you just need to add step 2 and 3 to the calculated stats of step 1 ;)


Edit: Added textfile with stat calculate Formular

thank you very much TheOnlyOneRaskim

but i have some question

*about 1st point do you mean to check what is his job and grab the stats from arcadia
table named JobLevelBonus and if that what you mean there is multi column with same property like vit1,vit2 ,vit3,default vit
which one will help ?!

*how can i check for items he use it(wear it)?

if you PM me for it will be better and thankyou again bro :)

Quote:

Originally Posted by colonelx thank you very much TheOnlyOneRaskim but i have some question *about 1st point do you mean to check what is his job and grab the stats from arcadia table named JobLevelBonus and if that what you mean there is multi column with same property like vit1,vit2 ,vit3,default vit which one will help ?! *how can i check for items he use it(wear it)? if you PM me for it will be better and thankyou again bro :)

At first, please dont call me "bro".

For your question. You just have to do a little sql join query


Select * from arcadia.dbo.statresource join telecaster.dbo.character on job = id wher name = 'playername'

This will return the basic stats of the current player job