· 6 years ago · May 19, 2019, 08:46 AM
1prontera,256,73,4 script 怪物æœå°‹ 738,{
2input .@mobname$;
3
4if( getstrlen(.@mobname$) < 3 )
5{
6 message strcharinfo(0),"å—數ä¸è¶³(僅能使用ä¸æ–‡ä¸”至少兩個å—)";
7 end;
8}
9
10.@qty = query_sql("select `mob_id`,`map_iName`,`map_kName`,`amount` from `zprivate_spawns_mob` where `mob_kName` LIKE '%"+escape_sql(.@mobname$)+"%' order by `amount` desc limit 9", .@ids, .@iName_map$, .@kName_map$, .@amount);
11
12for (.@i = 0; .@i < .@qty; .@i++)
13{
14 announce ""+.@i+" : "+getmonsterinfo(.@ids[.@i],MOB_NAME)+"Lv."+getmonsterinfo(.@ids[.@i],MOB_LV)+" 數é‡: "+.@amount[.@i]+"("+.@kName_map$[.@i]+")"+.@iName_map$[.@i],bc_all;
15}
16
17announce "-------------------The End(全部共"+.@qty+"ç†)-------------------",bc_all;
18
19end;
20}
21
22//================================================
23//========== 已上為Script ==========
24//================================================
25//================================================
26//========== 已下為Sql ==========
27//================================================
28
29CREATE TABLE IF NOT EXISTS `zPrivate_spawns_mob` (
30`mob_id` SMALLINT unsigned NOT NULL,
31`mob_iName` text NOT NULL,
32`mob_kName` text NOT NULL,
33`map_iName` text NOT NULL,
34`map_kName` text NOT NULL,
35`amount` TINYINT unsigned NOT NULL,
36`serial_number` SMALLINT unsigned NOT NULL auto_increment,
37PRIMARY KEY (`serial_number`)
38) ENGINE=MyISAM AUTO_INCREMENT=1;
39INSERT INTO `zprivate_spawns_mob` VALUES (1036, 'Ghoul', 'ç¶ è…å±', 'nameless_n', 'ç„¡å島', 40, 1);
40INSERT INTO `zprivate_spawns_mob` VALUES (1866, 'Hellhound', '地ç„貴賓狗', 'nameless_n', 'ç„¡å島', 17, 2);
41INSERT INTO `zprivate_spawns_mob` VALUES (1867, 'Banshee', '惡耗女妖', 'nameless_n', 'ç„¡å島', 16, 3);
42INSERT INTO `zprivate_spawns_mob` VALUES (1865, 'Ragged Zombie', '襤褸è…å±', 'nameless_n', 'ç„¡å島', 12, 4);
43INSERT INTO `zprivate_spawns_mob` VALUES (1864, 'Zombie Slaughter', 'å± æ®ºè…å±', 'nameless_n', 'ç„¡å島', 12, 5);
44INSERT INTO `zprivate_spawns_mob` VALUES (1869, 'Flame Skull', 'ç«ç„°éª·é«\é ', 'nameless_n', 'ç„¡å島', 3, 6);
45INSERT INTO `zprivate_spawns_mob` VALUES (1269, 'Clock', 'å¤é˜é”', 'c_tower2', '艾爾帕è˜é˜å¡” 地上2樓', 40, 609);
46INSERT INTO `zprivate_spawns_mob` VALUES (1199, 'Punk', '朽é”', 'c_tower2', '艾爾帕è˜é˜å¡” 地上2樓', 40, 610);
47INSERT INTO `zprivate_spawns_mob` VALUES (1195, 'Rideword', '飛行é”書', 'c_tower2', '艾爾帕è˜é˜å¡” 地上2樓', 12, 611);
48INSERT INTO `zprivate_spawns_mob` VALUES (1191, 'Mimic', '邪惡箱', 'c_tower2', '艾爾帕è˜é˜å¡” 地上2樓', 3, 612);
49INSERT INTO `zprivate_spawns_mob` VALUES (1377, 'Elder', '邪éˆé”導士', 'c_tower2', '艾爾帕è˜é˜å¡” 地上2樓', 2, 613);
50INSERT INTO `zprivate_spawns_mob` VALUES (1270, 'Clock Tower Manager', 'é˜å¡”守è·è€…', 'c_tower2', '艾爾帕è˜é˜å¡” 地上2樓', 1, 614);
51INSERT INTO `zprivate_spawns_mob` VALUES (1193, 'Alarm', 'é˜æ€ª', 'c_tower3', '艾爾帕è˜é˜å¡” 地上3樓', 80, 615);
52INSERT INTO `zprivate_spawns_mob` VALUES (1191, 'Mimic', '邪惡箱', 'c_tower3', '艾爾帕è˜é˜å¡” 地上3樓', 7, 616);
53INSERT INTO `zprivate_spawns_mob` VALUES (1195, 'Rideword', '飛行é”書', 'c_tower3', '艾爾帕è˜é˜å¡” 地上3樓', 6, 617);
54INSERT INTO `zprivate_spawns_mob` VALUES (1270, 'Clock Tower Manager', 'é˜å¡”守è·è€…', 'c_tower3', '艾爾帕è˜é˜å¡” 地上3樓', 3, 618);
55INSERT INTO `zprivate_spawns_mob` VALUES (1269, 'Clock', 'å¤é˜é”', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 35, 619);
56INSERT INTO `zprivate_spawns_mob` VALUES (1320, 'Owl Duke', 'é´žè£Šé¦–é ˜', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 30, 620);
57INSERT INTO `zprivate_spawns_mob` VALUES (1193, 'Alarm', 'é˜æ€ª', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 30, 621);
58INSERT INTO `zprivate_spawns_mob` VALUES (1195, 'Rideword', '飛行é”書', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 15, 622);
59INSERT INTO `zprivate_spawns_mob` VALUES (1191, 'Mimic', '邪惡箱', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 12, 623);
60INSERT INTO `zprivate_spawns_mob` VALUES (1179, 'Whisper', '白幽éˆ', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 5, 624);
61INSERT INTO `zprivate_spawns_mob` VALUES (1270, 'Clock Tower Manager', 'é˜å¡”守è·è€…', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 3, 625);
62INSERT INTO `zprivate_spawns_mob` VALUES (1377, 'Elder', '邪éˆé”導士', 'c_tower4', '艾爾帕è˜é˜å¡” 地上4樓', 2, 626);
63INSERT INTO `zprivate_spawns_mob` VALUES (2919, 'Neo Punk', '惡éˆæœ½é”', 'c_tower2_', '夢é˜å¯†ç©´é˜å¡” 2樓', 40, 627);
64INSERT INTO `zprivate_spawns_mob` VALUES (2916, 'Big Ben', '大笨é˜', 'c_tower2_', '夢é˜å¯†ç©´é˜å¡” 2樓', 40, 628);
65INSERT INTO `zprivate_spawns_mob` VALUES (2918, 'Time Keeper', '時光守è·è€…', 'c_tower2_', '夢é˜å¯†ç©´é˜å¡” 2樓', 1, 629);
66INSERT INTO `zprivate_spawns_mob` VALUES (2920, 'Arc Elder', '邪éˆé•·è€', 'c_tower2_', '夢é˜å¯†ç©´é˜å¡” 2樓', 2, 630);
67INSERT INTO `zprivate_spawns_mob` VALUES (2917, 'Big Bell', '大é˜æ€ª', 'c_tower3_', '夢é˜å¯†ç©´é˜å¡” 3樓', 110, 631);