關於SQL語法

jhg681291 · 發表於 2013-11-23 13:40:28

本帖最後由 jhg681291 於 2013-11-24 08:55 AM 編輯

請問一下
這個視窗的怪物英文如何顯示成中文名子
搞不清楚是如何修改SQL語法的哪個部分..

以下是部分腳本

<div class="blockcode"><blockquote>mes "你必須去狩獵怪物:";
query_sql("SELECT ID FROM `mob_db` WHERE left(Sprite , 4) != 'meta' AND left(Sprite , 2) != 'E_' AND ~Mode & 32 AND LV > 1 AND LV < 5 AND EXP > 0 AND MVP1id = 0 AND DropCardid > 4000 AND DropCardid < 5000 AND ID < 2000 AND instr('"+.Blacklist$+"',ID) = 0 ORDER BY rand() LIMIT "+.Quests, .@mob);
for (set .@i,0; .@i<.Quests; set .@i,.@i+1) {
setd "Mission"+.@i, .@mob[.@i];
setd "Mission"+.@i +"_",0;
}
set #Mission_Count, rand(.Count[0],.Count[1]);
callsub Mission_Status;
next;
close;

複製代碼

與mob_DB的SQL

DROP TABLE IF EXISTS `mob_db`;
CREATE TABLE `mob_db` (
`ID` mediumint(9) unsigned NOT NULL default '0',
`Sprite` text NOT NULL,
`kName` text NOT NULL,
`iName` text NOT NULL,
`LV` tinyint(6) unsigned NOT NULL default '0',
`HP` int(9) unsigned NOT NULL default '0',
`SP` mediumint(9) unsigned NOT NULL default '0',
`EXP` mediumint(9) unsigned NOT NULL default '0',
`JEXP` mediumint(9) unsigned NOT NULL default '0',
`Range1` tinyint(4) unsigned NOT NULL default '0',
`ATK1` smallint(6) unsigned NOT NULL default '0',
`ATK2` smallint(6) unsigned NOT NULL default '0',
`DEF` smallint(6) unsigned NOT NULL default '0',
`MDEF` smallint(6) unsigned NOT NULL default '0',
`STR` smallint(6) unsigned NOT NULL default '0',
`AGI` smallint(6) unsigned NOT NULL default '0',
`VIT` smallint(6) unsigned NOT NULL default '0',
`INT` smallint(6) unsigned NOT NULL default '0',
`DEX` smallint(6) unsigned NOT NULL default '0',
`LUK` smallint(6) unsigned NOT NULL default '0',
`Range2` tinyint(4) unsigned NOT NULL default '0',
`Range3` tinyint(4) unsigned NOT NULL default '0',
`Scale` tinyint(4) unsigned NOT NULL default '0',
`Race` tinyint(4) unsigned NOT NULL default '0',
`Element` tinyint(4) unsigned NOT NULL default '0',
`Mode` smallint(6) unsigned NOT NULL default '0',
`Speed` smallint(6) unsigned NOT NULL default '0',
`aDelay` smallint(6) unsigned NOT NULL default '0',
`aMotion` smallint(6) unsigned NOT NULL default '0',
`dMotion` smallint(6) unsigned NOT NULL default '0',
`MEXP` mediumint(9) unsigned NOT NULL default '0',
`MVP1id` smallint(9) unsigned NOT NULL default '0',
`MVP1per` smallint(9) unsigned NOT NULL default '0',
`MVP2id` smallint(9) unsigned NOT NULL default '0',
`MVP2per` smallint(9) unsigned NOT NULL default '0',
`MVP3id` smallint(9) unsigned NOT NULL default '0',
`MVP3per` smallint(9) unsigned NOT NULL default '0',
`Drop1id` smallint(9) unsigned NOT NULL default '0',
`Drop1per` smallint(9) unsigned NOT NULL default '0',
`Drop2id` smallint(9) unsigned NOT NULL default '0',
`Drop2per` smallint(9) unsigned NOT NULL default '0',
`Drop3id` smallint(9) unsigned NOT NULL default '0',
`Drop3per` smallint(9) unsigned NOT NULL default '0',
`Drop4id` smallint(9) unsigned NOT NULL default '0',
`Drop4per` smallint(9) unsigned NOT NULL default '0',
`Drop5id` smallint(9) unsigned NOT NULL default '0',
`Drop5per` smallint(9) unsigned NOT NULL default '0',
`Drop6id` smallint(9) unsigned NOT NULL default '0',
`Drop6per` smallint(9) unsigned NOT NULL default '0',
`Drop7id` smallint(9) unsigned NOT NULL default '0',
`Drop7per` smallint(9) unsigned NOT NULL default '0',
`Drop8id` smallint(9) unsigned NOT NULL default '0',
`Drop8per` smallint(9) unsigned NOT NULL default '0',
`Drop9id` smallint(9) unsigned NOT NULL default '0',
`Drop9per` smallint(9) unsigned NOT NULL default '0',
`DropCardid` smallint(9) unsigned NOT NULL default '0',
`DropCardper` smallint(9) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM;# Monster Database
#
# Structure of Database :
#REPLACE INTO `mob_db` VALUES ( ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);
# Note: Keep the Sprite_Name field as it is in the game client.REPLACE INTO `mob_db` VALUES (1001,'SCORPION','蠍子','Scorpion',24,1109,0,287,176,1,80,135,30,0,1,24,24,5,52,5,10,12,0,4,23,0x3195,200,1564,864,576,0,0,0,0,0,0,0,990,70,904,5500,757,57,943,210,7041,100,508,200,625,20,0,0,0,0,4068,1);
REPLACE INTO `mob_db` VALUES (1002,'PORING','波利','Poring',1,50,0,2,1,1,7,10,0,5,1,1,1,0,6,30,10,12,1,3,21,0x83,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,512,150,619,20,0,0,0,0,4001,1);
#REPLACE INTO `mob_db` VALUES (1003,'TESTEGG','Test Egg','Test Egg',2,100000,0,10,10,0,3,9,99,0,1,99,1,1,1,1,10,12,0,4,22,0x0,512,0,512,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
REPLACE INTO `mob_db` VALUES (1004,'HORNET','蜂兵','Hornet',8,169,0,19,15,1,22,27,5,5,6,20,8,10,17,5,10,12,0,4,24,0x1189,150,1292,792,216,0,0,0,0,0,0,0,992,80,939,9000,909,3500,1208,15,511,350,518,150,0,0,0,0,0,0,4019,1);
REPLACE INTO `mob_db` VALUES (1005,'FARMILIAR','吸血蝙蝠','Familiar',8,155,0,28,15,1,20,28,0,0,1,12,8,5,28,0,10,12,0,2,27,0x3885,150,1276,576,384,0,0,0,0,0,0,0,913,5500,1105,20,2209,15,601,50,514,100,507,700,645,50,0,0,0,0,4020,1);

複製代碼

sinya · 發表於 2013-11-23 17:04:50

本帖最後由 sinya 於 2013-11-23 05:33 PM 編輯

strmobinfo(1,.@j[.@i])
改
strmobinfo(2,.@j[.@i])

jhg681291 · 發表於 2013-11-24 08:55:05

sinya 發表於 2013-11-23 05:04 PM
strmobinfo(1,.@j[.@i])
改
strmobinfo(2,.@j[.@i])

謝謝 . 可以顯示中文名稱了

		自動登錄	找回密碼
密碼			註冊