편집토론문서 역사

"TEST DB ACCESS"의 두 판 사이의 차이

(내용을 "{{#get_db_data: db=ID |from=NAME_DESC |where='SW16BR1 "Buzzsaw" Repeater'=ITEM_NAME |data=ITEM_DESC=ITEM_DESC }} {{#external_value: ITEM_DESC}}"(으)로 바꿈)
태그: 대체됨
1번째 줄: 1번째 줄:
 
{{#get_db_data:
 
{{#get_db_data:
 
  db=ID
 
  db=ID
−
  |from=SHIP_WEAPON
+
  |from=NAME_DESC
−
  |where='C-788 Cannon'=SHIP_WEAPON_ENG_NAME
+
  |where='SW16BR1 "Buzzsaw" Repeater'=ITEM_NAME
−
  |data=SHIP_WEAPON_KOR_NAME=SHIP_WEAPON_KOR_NAME,
+
  |data=ITEM_DESC=ITEM_DESC
−
SHIP_WEAPON_ENG_NAME=SHIP_WEAPON_ENG_NAME,
+
}}
−
SHIP_WEAPON_GRADE=SHIP_WEAPON_GRADE,
 
−
SHIP_WEAPON_SIZE=SHIP_WEAPON_SIZE,
 
−
SHIP_WEAPON_TYPE=SHIP_WEAPON_TYPE,SHIP_WEAPON_CLASS=SHIP_WEAPON_CLASS,SHIP_WEAPON_MAXRANGE=SHIP_WEAPON_MAXRANGE,SHIP_WEAPON_MANUFACTURER_NAME=SHIP_WEAPON_MANUFACTURER_NAME,SHIP_WEAPON_FIREMODE1_NAME=SHIP_WEAPON_FIREMODE1_NAME,SHIP_WEAPON_FIREMODE1_RPM=SHIP_WEAPON_FIREMODE1_RPM,SHIP_WEAPON_FIREMODE1_APS=SHIP_WEAPON_FIREMODE1_APS,SHIP_WEAPON_FIREMODE1_PPS=SHIP_WEAPON_FIREMODE1_PPS,SHIP_WEAPON_FIREMODE1_PHY_DPSHOT=SHIP_WEAPON_FIREMODE1_PHY_DPSHOT,SHIP_WEAPON_FIREMODE1_ENG_DPSHOT=SHIP_WEAPON_FIREMODE1_ENG_DPSHOT,SHIP_WEAPON_FIREMODE1_DIS_DPSHOT=SHIP_WEAPON_FIREMODE1_DIS_DPSHOT,SHIP_WEAPON_FIREMODE1_THE_DPSHOT=SHIP_WEAPON_FIREMODE1_THE_DPSHOT,SHIP_WEAPON_FIREMODE1_BIO_DPSHOT=SHIP_WEAPON_FIREMODE1_BIO_DPSHOT,SHIP_WEAPON_FIREMODE1_STUN_DPSHOT=SHIP_WEAPON_FIREMODE1_STUN_DPSHOT,SHIP_WEAPON_FIREMODE1_PHY_DPS=SHIP_WEAPON_FIREMODE1_PHY_DPS,SHIP_WEAPON_FIREMODE1_ENG_DPS=SHIP_WEAPON_FIREMODE1_ENG_DPS,SHIP_WEAPON_FIREMODE1_DIS_DPS=SHIP_WEAPON_FIREMODE1_DIS_DPS,SHIP_WEAPON_FIREMODE1_THE_DPS=SHIP_WEAPON_FIREMODE1_THE_DPS,SHIP_WEAPON_FIREMODE1_BIO_DPS=SHIP_WEAPON_FIREMODE1_BIO_DPS,SHIP_WEAPON_FIREMODE1_STUN_DPS=SHIP_WEAPON_FIREMODE1_STUN_DPS,SHIP_WEAPON_FIREMODE2_NAME=SHIP_WEAPON_FIREMODE2_NAME,SHIP_WEAPON_FIREMODE2_RPM=SHIP_WEAPON_FIREMODE2_RPM,SHIP_WEAPON_FIREMODE2_APS=SHIP_WEAPON_FIREMODE2_APS,SHIP_WEAPON_FIREMODE2_PPS=SHIP_WEAPON_FIREMODE2_PPS,SHIP_WEAPON_FIREMODE2_PHY_DPSHOT=SHIP_WEAPON_FIREMODE2_PHY_DPSHOT,SHIP_WEAPON_FIREMODE2_ENG_DPSHOT=SHIP_WEAPON_FIREMODE2_ENG_DPSHOT,SHIP_WEAPON_FIREMODE2_DIS_DPSHOT=SHIP_WEAPON_FIREMODE2_DIS_DPSHOT,SHIP_WEAPON_FIREMODE2_THE_DPSHOT=SHIP_WEAPON_FIREMODE2_THE_DPSHOT,SHIP_WEAPON_FIREMODE2_BIO_DPSHOT=SHIP_WEAPON_FIREMODE2_BIO_DPSHOT,SHIP_WEAPON_FIREMODE2_STUN_DPSHOT=SHIP_WEAPON_FIREMODE2_STUN_DPSHOT,SHIP_WEAPON_FIREMODE2_PHY_DPS=SHIP_WEAPON_FIREMODE2_PHY_DPS,SHIP_WEAPON_FIREMODE2_ENG_DPS=SHIP_WEAPON_FIREMODE2_ENG_DPS,SHIP_WEAPON_FIREMODE2_DIS_DPS=SHIP_WEAPON_FIREMODE2_DIS_DPS,SHIP_WEAPON_FIREMODE2_THE_DPS=SHIP_WEAPON_FIREMODE2_THE_DPS,SHIP_WEAPON_FIREMODE2_BIO_DPS=SHIP_WEAPON_FIREMODE2_BIO_DPS,SHIP_WEAPON_FIREMODE2_STUN_DPS=SHIP_WEAPON_FIREMODE2_STUN_DPS,SHIP_WEAPON_FIREMODE3_NAME=SHIP_WEAPON_FIREMODE3_NAME,SHIP_WEAPON_FIREMODE3_RPM=SHIP_WEAPON_FIREMODE3_RPM,SHIP_WEAPON_FIREMODE3_APS=SHIP_WEAPON_FIREMODE3_APS,SHIP_WEAPON_FIREMODE3_PPS=SHIP_WEAPON_FIREMODE3_PPS,SHIP_WEAPON_FIREMODE3_PHY_DPSHOT=SHIP_WEAPON_FIREMODE3_PHY_DPSHOT,SHIP_WEAPON_FIREMODE3_ENG_DPSHOT=SHIP_WEAPON_FIREMODE3_ENG_DPSHOT,SHIP_WEAPON_FIREMODE3_DIS_DPSHOT=SHIP_WEAPON_FIREMODE3_DIS_DPSHOT,SHIP_WEAPON_FIREMODE3_THE_DPSHOT=SHIP_WEAPON_FIREMODE3_THE_DPSHOT,SHIP_WEAPON_FIREMODE3_BIO_DPSHOT=SHIP_WEAPON_FIREMODE3_BIO_DPSHOT,SHIP_WEAPON_FIREMODE3_STUN_DPSHOT=SHIP_WEAPON_FIREMODE3_STUN_DPSHOT,SHIP_WEAPON_FIREMODE3_PHY_DPS=SHIP_WEAPON_FIREMODE3_PHY_DPS,SHIP_WEAPON_FIREMODE3_ENG_DPS=SHIP_WEAPON_FIREMODE3_ENG_DPS,SHIP_WEAPON_FIREMODE3_DIS_DPS=SHIP_WEAPON_FIREMODE3_DIS_DPS,SHIP_WEAPON_FIREMODE3_THE_DPS=SHIP_WEAPON_FIREMODE3_THE_DPS,SHIP_WEAPON_FIREMODE3_BIO_DPS=SHIP_WEAPON_FIREMODE3_BIO_DPS,SHIP_WEAPON_FIREMODE3_STUN_DPS=SHIP_WEAPON_FIREMODE3_STUN_DPS,SHIP_WEAPON_FIREMODE4_NAME=SHIP_WEAPON_FIREMODE4_NAME,SHIP_WEAPON_FIREMODE4_RPM=SHIP_WEAPON_FIREMODE4_RPM,SHIP_WEAPON_FIREMODE4_APS=SHIP_WEAPON_FIREMODE4_APS,SHIP_WEAPON_FIREMODE4_PPS=SHIP_WEAPON_FIREMODE4_PPS,SHIP_WEAPON_FIREMODE4_PHY_DPSHOT=SHIP_WEAPON_FIREMODE4_PHY_DPSHOT,SHIP_WEAPON_FIREMODE4_ENG_DPSHOT=SHIP_WEAPON_FIREMODE4_ENG_DPSHOT,SHIP_WEAPON_FIREMODE4_DIS_DPSHOT=SHIP_WEAPON_FIREMODE4_DIS_DPSHOT,SHIP_WEAPON_FIREMODE4_THE_DPSHOT=SHIP_WEAPON_FIREMODE4_THE_DPSHOT,SHIP_WEAPON_FIREMODE4_BIO_DPSHOT=SHIP_WEAPON_FIREMODE4_BIO_DPSHOT,SHIP_WEAPON_FIREMODE4_STUN_DPSHOT=SHIP_WEAPON_FIREMODE4_STUN_DPSHOT,SHIP_WEAPON_FIREMODE4_PHY_DPS=SHIP_WEAPON_FIREMODE4_PHY_DPS,SHIP_WEAPON_FIREMODE4_ENG_DPS=SHIP_WEAPON_FIREMODE4_ENG_DPS,SHIP_WEAPON_FIREMODE4_DIS_DPS=SHIP_WEAPON_FIREMODE4_DIS_DPS,SHIP_WEAPON_FIREMODE4_THE_DPS=SHIP_WEAPON_FIREMODE4_THE_DPS,SHIP_WEAPON_FIREMODE4_BIO_DPS=SHIP_WEAPON_FIREMODE4_BIO_DPS,SHIP_WEAPON_FIREMODE4_STUN_DPS=SHIP_WEAPON_FIREMODE4_STUN_DPS}}
 
  
−
{{#external_value: SHIP_WEAPON_KOR_NAME}}
+
 
 +
{{#external_value: ITEM_DESC}}

2022년 8월 21일 (일) 21:35 판

SELECT item_desc FROM `NAME_DESC` WHERE 'SW16BR1 "Buzzsaw" Repeater'=ITEM_NAME 쿼리는 유효하지 않습니다. (Error 1146: Table 'sc_wiki_item_db.NAME_DESC' doesn't exist (127.0.0.1:3307) Function: EDConnectorRdbms::fetch Query: SELECT item_desc FROM `NAME_DESC` WHERE 'SW16BR1 "Buzzsaw" Repeater'=ITEM_NAME )


오류: 지역 변수가 설정되어 있지 않습니다.