frost
Banned
BEFORE YOU BEGIN DOING THIS PLEASE KNOW HOW TO CHANGE A DATABASE STRUCTURE NOT THE
DATA IN THE DATABASE!
Ok, Welcome to my Tutorial.
if anyone knows a better way to do this by all means
post a reply with a different method.
first things first:
files to edit:
1)dbcenums.h
2)objectmgr.cpp
dbcenums.h
objectmgr.cpp
Stats Edit to allow higher hp/dmg etc:
now the fun part.
you must change your sql tables data structures for this to work:
if you use navicat rightclick the table and goto design table!
edit these rows in items_template "structure"
if you use navicat rightclick the table and goto design table!
edit these rows in creature_template "structure"
Credits to slp13at420 for the toolz:
Next step:
toolz for 255 realm stats
Please consider donating for access to these tools
edit: changed values from mediumint to bigint
newest fixes are in green
thankyou to Rochet2 for the stats updated info see his post below
DATA IN THE DATABASE!
Ok, Welcome to my Tutorial.
if anyone knows a better way to do this by all means
post a reply with a different method.
first things first:
files to edit:
1)dbcenums.h
2)objectmgr.cpp
dbcenums.h
Code:
DEFAULT_MAX_LEVEL = 255,
MAX_LEVEL = 255,
STRONG_MAX_LEVEL = 255,
objectmgr.cpp
Stats Edit to allow higher hp/dmg etc:
Code:
// these edits are stats changes that make items/creatures stats cap go up.(like adding a shirt that adds 20394 health.
// NOTE: When making your gear [SIZE=3][COLOR="#FFFF00"]don't go ape shit with the stats[/COLOR][/SIZE] as there is still a cap because too high of stats
// and you get a few problems like npc's dead or spawning with low hp or too high of hp
// these edits require database table changes!!! don't set huge values for the tables lenth... i reccommend the max be set to 20
//you must change the table structures to the new data types or you will fail and shit wont work.
//if anyone has an sql file that can do the table edits please by all means post them here and ill add them to this tutorial :)
//in the itemtemplate database when you edit the tables look for these rows
//find these lines and change them to the ones below inside of objectmgr.cpp
itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt32()); // changed to bigint
[COLOR="#00FF00"]itemTemplate.Damage[i].DamageMin = fields[50 + i*3].GetUInt32(); // changed from float to bigint
itemTemplate.Damage[i].DamageMax = fields[51 + i*3].GetUInt32(); // changed from float to bigint[/COLOR]
creatureTemplate.ModHealth = fields[70].GetUInt32(); // changed to bigint from float
creatureTemplate.mindmg = fields[24].GetUInt32(); //change to bigint from float
creatureTemplate.maxdmg = fields[25].GetUInt32(); // change to bigint from float
now the fun part.
you must change your sql tables data structures for this to work:
if you use navicat rightclick the table and goto design table!
edit these rows in items_template "structure"
Code:
stat_value1 // change to bigint length 12
stat_value2 // change to bigint length 12
stat_value3 // change to bigint length 12
stat_value4 // change to bigint length 12
stat_value5 // change to bigint length 12
stat_value6 // change to bigint length 12
stat_value7 // change to bigint length 12
stat_value8 // change to bigint length 12
stat_value9 // change to bigint length 12
stat_value10 // change to bigint length 12
[COLOR="#00FF00"]DamageMin //change to bigint and a lenth of 8
DamageMax //change to bigint and a lenth of 8[/COLOR]
if you use navicat rightclick the table and goto design table!
edit these rows in creature_template "structure"
Code:
ModHealth //to bigint length 8
mindmg //to bigint length 8
maxdmg //to bigint length 8
Next step:
toolz for 255 realm stats
Please consider donating for access to these tools
edit: changed values from mediumint to bigint
newest fixes are in green
thankyou to Rochet2 for the stats updated info see his post below
Last edited: