Update Stats directly in DB

[ezramod]

Hello,
Im new in this world and I want to know is I can modify character info, stats directly from database without rollback from server, for example is health in db if I put 800.000 when I login health is back to 88
SOME IDEEA?

 

[ExO]

Hello there, welcome.

No you cannot update their health in character db like that, you need to buff it for everyone in this case, or add them some special item with a lot of health.

 

[cliffsmits]

There is a way to update evreything into your world database at once like damage and stats..

Open Navicat/HeidiSQL And go to WORLD


2º Click on Query

UPDATE items SET `dmg_min1` = `dmg_min1` * 100 ;
UPDATE items SET `dmg_max1` = `dmg_max1` * 100 ;

Now The Gear Stats...
Open A new Query

UPDATE items SET `stat_value1` = `stat_value1` * 100 ;
UPDATE items SET `stat_value2` = `stat_value2` * 100 ;
UPDATE items SET `stat_value3` = `stat_value3` * 100 ;
UPDATE items SET `stat_value4` = `stat_value4` * 100 ;
UPDATE items SET `stat_value5` = `stat_value5` * 100 ;
UPDATE items SET `stat_value6` = `stat_value6` * 100 ;
UPDATE items SET `stat_value7` = `stat_value7` * 100 ;
UPDATE items SET `stat_value8` = `stat_value8` * 100 ;
UPDATE items SET `stat_value9` = `stat_value9` * 100 ;
UPDATE items SET `stat_value10` = `stat_value10` * 100 ;

This will update the stats like 5000% stats and weapon dmg

or you can do it like this

and if u want more % just change number 1.15 if 25% = 1.25 etc

UPDATE `Item_template` SET stat_value1 = (stat_value1 * 1.15) WHERE `Name` LIKE '%Wrathful%';
UPDATE `Item_template` SET stat_value2 = (stat_value2 * 1.15) WHERE `Name` LIKE '%Wrathful%';
UPDATE `Item_template` SET stat_value3 = (stat_value3 * 1.15) WHERE `Name` LIKE '%Wrathful%';
UPDATE `Item_template` SET stat_value4 = (stat_value4 * 1.15) WHERE `Name` LIKE '%Wrathful%';
UPDATE `Item_template` SET stat_value5 = (stat_value5 * 1.15) WHERE `Name` LIKE '%Wrathful%';
UPDATE `Item_template` SET stat_value6 = (stat_value6 * 1.15) WHERE `Name` LIKE '%Wrathful%';
UPDATE `Item_template` SET stat_value7 = (stat_value7 * 1.15) WHERE `Name` LIKE '%Wrathful%';
UPDATE `Item_template` SET stat_value8 = (stat_value8 * 1.15) WHERE `Name` LIKE '%Wrathful%';

 

[ezramod]

thx verry much for ideea, im new in this world , i come from MU ONLINE , and i try to do something with RESET System, but after any reset player need to receive much more POWER

for example in characters db i see table "characters_stats" there i have agility, strenght......but i play in game and that table is 0 don't have any register
i want to know for what is that table

 

[ezramod]

for example all stats is saved in player_levelstats table if we add new row in character table for example "RESET" = 2 all information from player_levelstats * RESET(2) = MUCH MORE POWER

 

[slawa92]

 

[cliffsmits]

cliffsmits +rep for me to bro that is what i was looking for

haha your welcome