NPC,PETのステータス変更

mobをランダムで強く

ヘルバウンドのmobを作成したテーブルを元に強化

「npc_rudpowerup」テーブルを作成し、その数値を使って数値をランダムに変更します。
下のFLOOR「( 1 + (RAND() * 10) )」は、1から10までの乱数を発生させます。
どのように数値が変化したかは、クエリの指定したモンス一覧を作るで確認することができます。
SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE `npc_rudpowerup` (
`id` decimal(11,0) NOT NULL default '0',
`idTemplate` int(11) NOT NULL default '0',
`name` varchar(200) default NULL,
`serverSideName` int(1) default '0',
`title` varchar(45) default '',
`serverSideTitle` int(1) default '0',
`class` varchar(200) default NULL,
`collision_radius` decimal(5,2) default NULL,
`collision_height` decimal(5,2) default NULL,
`level` decimal(2,0) default NULL,
`sex` varchar(6) default NULL,
`type` varchar(20) default NULL,
`attackrange` int(11) default NULL,
`hp` decimal(8,0) default NULL,
`mp` decimal(6,0) default NULL,
`hpreg` decimal(8,2) default NULL,
`mpreg` decimal(5,2) default NULL,
`str` decimal(7,0) default NULL,
`con` decimal(7,0) default NULL,
`dex` decimal(7,0) default NULL,
`int` decimal(7,0) default NULL,
`wit` decimal(7,0) default NULL,
`men` decimal(7,0) default NULL,
`exp` decimal(9,0) default NULL,
`sp` decimal(8,0) default NULL,
`patk` decimal(5,0) default NULL,
`pdef` decimal(5,0) default NULL,
`matk` decimal(5,0) default NULL,
`mdef` decimal(5,0) default NULL,
`atkspd` decimal(3,0) default NULL,
`aggro` decimal(6,0) default NULL,
`matkspd` decimal(4,0) default NULL,
`rhand` decimal(5,0) default NULL,
`lhand` decimal(5,0) default NULL,
`armor` decimal(1,0) default NULL,
`walkspd` decimal(3,0) default NULL,
`runspd` decimal(3,0) default NULL,
`faction_id` varchar(40) default NULL,
`faction_range` decimal(4,0) default NULL,
`isUndead` int(11) default '0',
`absorb_level` decimal(2,0) default '0',
`absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') NOT NULL default 'LAST_HIT',
`ss` int(4) default '0',
`bss` int(4) default '0',
`ss_rate` int(3) default '0',
`AI` varchar(8) default 'fighter',
`drop_herbs` enum('true','false') NOT NULL default 'false',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `npc_rudpowerup` VALUES
('22320', '22320', 'ロウアー オブザーバー', '0', '', '0', 'LineageMonster4.eyeless', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22321', '22321', 'ロウアー サマナー', '0', '', '0', 'LineageMonster2.vampire_witch', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22327', '22327', '魔法陣の巡察兵', '0', '', '0', 'LineageMonster.dark_mahum', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22328', '22328', '魔法陣の警備兵', '0', '', '0', 'LineageMonster3.Succubus_Raid', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22329', '22329', '魔法陣の監視兵', '0', '', '0', 'LineageMonster3.Death_Blader_Raid', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22330', '22330', 'オールド シュライン ゴースト', '0', '', '0', 'LineageMonster3.zombie_laborer', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22334', '22334', 'サンド スコーピオン', '0', '', '0', 'LineageMonster2.sandScorpion', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22335', '22335', 'デザート スコーピオン', '0', '', '0', 'LineageMonster2.sandScorpion', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22336', '22336', 'ボディ イレーサー', '0', '', '0', 'LineageMonster2.imperial_warlord_zombie_sand', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22337', '22337', 'ソウル プランダー', '0', '', '0', 'LineageMonster.skeleton_knight_sand', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22339', '22339', 'ディスポウズド キャラバン', '0', '', '0', 'LineageMonster4.Caravan', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22340', '22340', 'サンド ストーム', '0', '', '0', 'LineageMonster4.SandTourbillon', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22342', '22342', 'ダリオンの執行者', '0', '', '0', 'LineageMonster.silhouette', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22343', '22343', 'ダリオンの処刑者', '0', '', '0', 'LineageMonster.shadeless', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22349', '22349', '地のキメラ', '0', '', '0', 'LineageMonster4.Chimera', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22350', '22350', '闇のキメラ', '0', '', '0', 'LineageMonster4.Chimera', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22351', '22351', '風のキメラ', '0', '', '0', 'LineageMonster4.Chimera', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22352', '22352', '炎のキメラ', '0', '', '0', 'LineageMonster4.Chimera', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22324', '22324', 'アイレス ハンター', '0', '', '0', 'LineageMonster4.eyeless_080p', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'),
('22325', '22325', 'アイレス オブザーバー', '0', '', '0', 'LineageMonster4.eyeless_080p', '34.00', '35.00', '80', 'male', 'L2Monster', '40', '10000', '2011', '80.58', '3.09', '40', '43', '30', '21', '20', '10', '18133', '8366', '5000', '562', '1296', '19533', '493', '0', '333', '0', '0', '0', '60', '200', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');

UPDATE npc_rudpowerup,npc
set npc.level = npc_rudpowerup.level + FLOOR( 1 + (RAND() * 10) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.hp = npc_rudpowerup.hp + FLOOR( 2000 + (RAND() * 2000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.mp = npc_rudpowerup.mp + FLOOR( 1000 + (RAND() * 1000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.patk = npc_rudpowerup.patk + FLOOR( 50000 + (RAND() * 1000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.matk = npc_rudpowerup.matk + FLOOR( 2000 + (RAND() * 2000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.pdef = npc_rudpowerup.pdef + FLOOR( 20000 + (RAND() * 2000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.mdef = npc_rudpowerup.mdef + FLOOR( 2000 + (RAND() * 2000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.exp = npc_rudpowerup.exp + FLOOR( 1000 + (RAND() * 1000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.sp = npc_rudpowerup.sp + FLOOR( 1000 + (RAND() * 1000) )
WHERE npc_rudpowerup.id = npc.id;

UPDATE npc_rudpowerup,npc
set npc.atkspd = npc_rudpowerup.atkspd + FLOOR( 50 + (RAND() * 50) )
WHERE npc_rudpowerup.id = npc.id;

ペットのステータスを上昇(*10や*5などは10倍,5倍という意味です。)

HPを10倍

update pets_stats
set pets_stats.hpMax = pets_stats.hpMax * 10
where pets_stats.hpMax;

MPを10倍

update pets_stats
set pets_stats.mpMax = pets_stats.mpMax * 10
where pets_stats.mpMax;

攻撃力を5倍

update pets_stats
set pets_stats.patk = pets_stats.patk * 5
where pets_stats.patk;

防御力を5倍

update pets_stats
set pets_stats.pdef = pets_stats.pdef * 5
where pets_stats.pdef;

攻撃速度を2倍

update pets_stats
set pets_stats.atk_speed = pets_stats.atk_speed * 2
where pets_stats.atk_speed;

移動速度を2倍

update pets_stats
set pets_stats.speed = pets_stats.speed * 2
where pets_stats.speed;