New/Modification of ingame stats/pooled stats

[Roh]

Hello, I am working with a few friends on a project, in which we decided to the MCcodes engine meet alot of the needs of the project. I'll be curt though.

The current ingame stats are Strength,agility,guard,labour,and IQ.

And the pooled stats Exp, brave, hp ...etc

before directly asking for a mod; I was wondering if any member of the board could direct me to the files or what process is necessary for adding additional stats.

The project we are working on calls for the following battle stats;

Strength(physical attacking stat),Agility, (physical accuracy stat),Vitality,(A physical defensive stat)

Intelligence(energy/mental/magic attacking stat), Guile(energy/mental/magic accuracy stat), spirit(energy/mental/magic defensive stat).

and 2 diffrent action pools (like brave) which are generated off of the corresponding physical and mental stats.

Any information on how to add/or convert to more stats will be appreciated. Thank you very much for your time

[corruptcity || skalman]

hi for the action stats you add them in the users table and the other stats in the userstats table but then after doing that you would then need to recode alot of files starting with globals and glob_funcs, docrime, jobs gym, index, loggedin, attack and finaly staff_users and jobs.

when ive done the same b4 it takes me no longer than about 30 mins to make all the changes

[Roh]

Thanks, i'll try that and get back to you guys with updates.

[Roh]

Changed/added the stat information on, Index, loggedin,staff_users,gym etc.

Alot more seems involved, with Globals, Globals_func,and attack

Could someone run me through the jist of information that would need to be changed or altered for the game to recognize the stats I'd like the engine to run off of.

Strength,Agility,Vitality,Intelligence(IQ),Spirit,Guile.

Or really to be more exact, the files that i need to add the new users stats too (if there are more) and the page which calculates The header stats, like Brave, Hp, Will etc.... as I would like to change/alter these.

As it stands I receive the following error (which i assume is normal)

.QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND us.userid != 1 AND u.user_level != 0' at line 1

Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.vitality > AND us.userid != 1 AND u.user_level != 0

[Analog]

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND us.userid != 1 AND u.user_level != 0' at line 1

Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.vitality > AND us.userid != 1 AND u.user_level != 0

Your problem is that you are missing what us.vitality is greater than..

[mysql]WHERE us.vitality > ?[/mysql]

[Roh]

Perhaps i'm not looking in the right file, but none of what i've seen thus far is, in the sql.file index/loggedin/globals/global_func have anything resembling

vitality.us >

is there a particular file in which you set what vit(or any ingame stat) is greater or less then.

Thank you for bearing with me thus far, I appreciate it.

[Roh]

here is what i have edited into the files so far, perhaps a key concept has blown right overmy head haha.

userstats table

 

CREATE TABLE `userstats` (

`userid` int(11) NOT NULL default '0',

`strength` decimal(11,4) NOT NULL default '0.0000',

`agility` decimal(11,4) NOT NULL default '0.0000',

`vitality` decimal(11,4) NOT NULL default '0.0000',

`IQ` decimal(11,4) NOT NULL default '0.000000'

`guile` decimal(11,4) NOT NULL default '0.000000'

`spirit` decimal(11,4) NOT NULL default '0.000000'

) ENGINE=MyISAM ;

index.php

<tr><td>Property: {$ir['hNAME']}</td></tr></table>";

print "<hr><h3>Stats Info:</h3>";

$ts=$ir['strength']+$ir['agility']+$ir['vitality']+$ir['IQ']+$ir['guile']+$ir['spirit'];

$ir['strank']=get_rank($ir['strength'],'strength');

$ir['agirank']=get_rank($ir['agility'],'agility');

$ir['vitrank']=get_rank($ir['vitality'],'vitality');

$ir['IQrank']=get_rank($ir['IQ'],'IQ');

$ir['guirank']=get_rank($ir['guile'],'guile');

$ir['sptrank']=get_rank($ir['spirit'],'spirit');

$tsrank=get_rank($ts,'strength+agility+vitality+IQ+guile+spirit');

$ir['strength']=number_format($ir['strength']);

$ir['agility']=number_format($ir['agility']);

$ir['vitality']=number_format($ir['vitality']);

$ir['IQ']=number_format($ir['IQ']);

$ir['guile']=number_format($ir['guile']);

$ir['spirit']=number_format($ir['spirit']);

$ts=number_format($ts);

print "<table><tr><td><center>Alter Level: {$ts} [Ranked: $tsrank]</td></tr>

 

<tr><td>

Strength: {$ir['strength']} [Ranked: {$ir['strank']}]

Agility: {$ir['agility']} [Ranked: {$ir['agirank']}]

Vitality: {$ir['vitality']} [Ranked: {$ir['vitrank']}] </td></tr>

<tr><td>

Intelligence: {$ir['IQ']} [Ranked: {$ir['IQrank']}]

Spirit: {$ir['spirit']} [Ranked: {$ir['sptrank']}]

Guile: {$ir['guile']} [Ranked: {$ir['guirank']}]</td></tr></table>";

if(isset($_POST['pn_update']))

{

loggedin.php

$ts=$ir['strength']+$ir['agility']+$ir['vitality']+$ir['IQ']+$ir['guile']+$ir['spirit'];

$ir['strank']=get_rank($ir['strength'],'strength');

$ir['agirank']=get_rank($ir['agility'],'agility');

$ir['vitrank']=get_rank($ir['vitality'],'vitality');

$ir['IQrank']=get_rank($ir['IQ'],'IQ');

$ir['guirank']=get_rank($ir['guile'],'guile');

$ir['sptrank']=get_rank($ir['spirit'],'spirit');

$tsrank=get_rank($ts,'strength+agility+vitality+IQ+guile+spirit');

$ir['strength']=number_format($ir['strength']);

$ir['agility']=number_format($ir['agility']);

$ir['vitality']=number_format($ir['vitality']);

$ir['spirit']=number_format($ir['spirit']);

$ir['IQ']=number_format($ir['IQ']);

$ir['guile']=number_format($ir['guile']);

$ir['spirit']=number_format($ir['spirit']);

$ts=number_format($ts);

print <<<OUT

<tr>

<td class="h" colspan="2">Stats Info</td></tr>

<tr>

<td>Strength: {$ir['strength']} [Ranked: {$ir['strank']}]</td>

<td>Agility: {$ir['agility']} [Ranked: {$ir['agirank']}]</td>

<td>Vitality: {$ir['vitality']} [Ranked: {$ir['vitrank']}]</td></tr>

<tr>

<td>Intelligence: {$ir['IQ']} [Ranked: {$ir['IQrank']}]</td>

<td>Guile: {$ir['guile']} [Ranked: {$ir['guirank']}]</td>

<td>Spirit: {$ir['spirit']} [Ranked: {$ir['sptrank']}]</td></tr>

[corruptcity || skalman]

hi that count(*) is in glob_funcs under the function get_trank i do believe and you have to make sure what you have in the db is the same as what in the script or if errors what you get so if in the db its Vitality its gotta be Vitality in the script or it chucks a wobbler

if you have or are willing to use team viewer i can have a look at it and try to sort you out

[Roh]

I am now willing to pay, to have ingame and pooled stats added/edited on the current engine. Please Email me for further information, [email protected]

I realize this is a rather drastic modification of the engine and am willing to discuss a price point which matches the work involved.