R5qAuvj0

1CREATE TABLE IF NOT EXISTS `zPrivate_spawns_mob` (
2`mob_id` SMALLINT unsigned NOT NULL,
3`mob_iName` text NOT NULL,
4`mob_kName` text NOT NULL,
5`map_iName` text NOT NULL,
6`map_kName` text NOT NULL,
7`amount` TINYINT unsigned NOT NULL,
8`serial_number` SMALLINT unsigned NOT NULL auto_increment,
9PRIMARY KEY (`serial_number`)
10) ENGINE=MyISAM AUTO_INCREMENT=1;
11INSERT INTO `zprivate_spawns_mob` VALUES (3747, 'Elite Buffalo Bandit', '精英草寇(精英散彈槍草寇)', 'rockmi1', '洛克理奇岩嶺礦山', 3, 2331);
12INSERT INTO `zprivate_spawns_mob` VALUES (3748, 'Elite Buffalo Bandit', '精英草寇(精英左輪手槍草寇)', 'rockmi1', '洛克理奇岩嶺礦山', 8, 2332);
13INSERT INTO `zprivate_spawns_mob` VALUES (3749, 'Elite Buffalo Bandit', '精英草寇(精英彎刀草寇)', 'rockmi1', '洛克理奇岩嶺礦山', 6, 2333);
14
15//================================================
16//========          上面是SQL              ========
17//========          下面是Script           ========
18//================================================
19
20prontera,255,72,4	script	撰寫中	738,{
21set .@1st$,"精英草寇";
22set .@blur_search$,escape_sql(.@1st$);
23.@qty = query_sql("select `mob_id` from `zprivate_spawns_mob` where `mob_kName` LIKE '%"+escape_sql(.@blur_search$)+"%' order by `mob_id` asc ", .@ids$);
24announce ""+getmonsterinfo(.@ids$[0],MOB_NAME),bc_all;
25announce ""+getmonsterinfo(.@ids$[1],MOB_NAME),bc_all;
26announce ""+getmonsterinfo(.@ids$[2],MOB_NAME),bc_all;
27end;
28}
29
30
31
32//輸出結果會變成
33//精英草寇(精英散彈槍草寇
34//精英草寇(精英左輪手槍草
35//精英草寇(精英彎刀草寇)