편집토론문서 역사

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

(내용을 " {{틀:방어구DB |키=FBL-8u 언더스튜 데저트 디지털}}"(으)로 바꿈)
태그: 대체됨
1번째 줄: 1번째 줄:
 +
{{#get_db_data:
 +
db=ID
 +
|from=MAIN_INFORMATION
 +
|where='데버스테이터 산탄총'=ITEM_KOR_NAME
 +
|data=ITEM_KOR_NAME=ITEM_KOR_NAME, ITEM_NAME = ITEM_NAME, ITEM_JSON_CLASS = ITEM_JSON_CLASS, ITEM_JSON_CLASS_ITEMNAME = ITEM_JSON_CLASS_ITEMNAME, ITEM_INI_CLASS = ITEM_INI_CLASS, ITEM_SHOP_CLASS = ITEM_SHOP_CLASS, ITEM_DESC = ITEM_DESC,ITEM_REF=ITEM_REF
 +
}}
  
−
{{틀:방어구DB |키=FBL-8u 언더스튜 데저트 디지털}}
+
{{#get_db_data:
 +
db=ID
 +
|from=FPS_WEAPON
 +
|where='{{#external_value:ITEM_JSON_CLASS}}'=FPS_WEAPON_CLASS_NAME
 +
|data=FPS_WEAPON_ENG_NAME=FPS_WEAPON_ENG_NAME,
 +
FPS_WEAPON_GRADE=FPS_WEAPON_GRADE,
 +
FPS_WEAPON_SIZE=FPS_WEAPON_SIZE,
 +
FPS_WEAPON_TYPE=FPS_WEAPON_TYPE,FPS_WEAPON_CLASS=FPS_WEAPON_CLASS,FPS_WEAPON_EFRANGE=FPS_WEAPON_EFRANGE,FPS_WEAPON_MAXRANGE=FPS_WEAPON_MAXRANGE,FPS_WEAPON_MANUFACTURER_NAME=FPS_WEAPON_MANUFACTURER_NAME,FPS_WEAPON_FIREMODE1_NAME=FPS_WEAPON_FIREMODE1_NAME,FPS_WEAPON_FIREMODE1_RPM=FPS_WEAPON_FIREMODE1_RPM,FPS_WEAPON_FIREMODE1_APS=FPS_WEAPON_FIREMODE1_APS,FPS_WEAPON_FIREMODE1_PPS=FPS_WEAPON_FIREMODE1_PPS,FPS_WEAPON_FIREMODE1_PHY_DPSHOT=FPS_WEAPON_FIREMODE1_PHY_DPSHOT,FPS_WEAPON_FIREMODE1_ENG_DPSHOT=FPS_WEAPON_FIREMODE1_ENG_DPSHOT,FPS_WEAPON_FIREMODE1_DIS_DPSHOT=FPS_WEAPON_FIREMODE1_DIS_DPSHOT,FPS_WEAPON_FIREMODE1_THE_DPSHOT=FPS_WEAPON_FIREMODE1_THE_DPSHOT,FPS_WEAPON_FIREMODE1_BIO_DPSHOT=FPS_WEAPON_FIREMODE1_BIO_DPSHOT,FPS_WEAPON_FIREMODE1_STUN_DPSHOT=FPS_WEAPON_FIREMODE1_STUN_DPSHOT,FPS_WEAPON_FIREMODE1_PHY_DPS=FPS_WEAPON_FIREMODE1_PHY_DPS,FPS_WEAPON_FIREMODE1_ENG_DPS=FPS_WEAPON_FIREMODE1_ENG_DPS,FPS_WEAPON_FIREMODE1_DIS_DPS=FPS_WEAPON_FIREMODE1_DIS_DPS,FPS_WEAPON_FIREMODE1_THE_DPS=FPS_WEAPON_FIREMODE1_THE_DPS,FPS_WEAPON_FIREMODE1_BIO_DPS=FPS_WEAPON_FIREMODE1_BIO_DPS,FPS_WEAPON_FIREMODE1_STUN_DPS=FPS_WEAPON_FIREMODE1_STUN_DPS,FPS_WEAPON_FIREMODE2_NAME=FPS_WEAPON_FIREMODE2_NAME,FPS_WEAPON_FIREMODE2_RPM=FPS_WEAPON_FIREMODE2_RPM,FPS_WEAPON_FIREMODE2_APS=FPS_WEAPON_FIREMODE2_APS,FPS_WEAPON_FIREMODE2_PPS=FPS_WEAPON_FIREMODE2_PPS,FPS_WEAPON_FIREMODE2_PHY_DPSHOT=FPS_WEAPON_FIREMODE2_PHY_DPSHOT,FPS_WEAPON_FIREMODE2_ENG_DPSHOT=FPS_WEAPON_FIREMODE2_ENG_DPSHOT,FPS_WEAPON_FIREMODE2_DIS_DPSHOT=FPS_WEAPON_FIREMODE2_DIS_DPSHOT,FPS_WEAPON_FIREMODE2_THE_DPSHOT=FPS_WEAPON_FIREMODE2_THE_DPSHOT,FPS_WEAPON_FIREMODE2_BIO_DPSHOT=FPS_WEAPON_FIREMODE2_BIO_DPSHOT,FPS_WEAPON_FIREMODE2_STUN_DPSHOT=FPS_WEAPON_FIREMODE2_STUN_DPSHOT,FPS_WEAPON_FIREMODE2_PHY_DPS=FPS_WEAPON_FIREMODE2_PHY_DPS,FPS_WEAPON_FIREMODE2_ENG_DPS=FPS_WEAPON_FIREMODE2_ENG_DPS,FPS_WEAPON_FIREMODE2_DIS_DPS=FPS_WEAPON_FIREMODE2_DIS_DPS,FPS_WEAPON_FIREMODE2_THE_DPS=FPS_WEAPON_FIREMODE2_THE_DPS,FPS_WEAPON_FIREMODE2_BIO_DPS=FPS_WEAPON_FIREMODE2_BIO_DPS,FPS_WEAPON_FIREMODE2_STUN_DPS=FPS_WEAPON_FIREMODE2_STUN_DPS,FPS_WEAPON_FIREMODE3_NAME=FPS_WEAPON_FIREMODE3_NAME,FPS_WEAPON_FIREMODE3_RPM=FPS_WEAPON_FIREMODE3_RPM,FPS_WEAPON_FIREMODE3_APS=FPS_WEAPON_FIREMODE3_APS,FPS_WEAPON_FIREMODE3_PPS=FPS_WEAPON_FIREMODE3_PPS,FPS_WEAPON_FIREMODE3_PHY_DPSHOT=FPS_WEAPON_FIREMODE3_PHY_DPSHOT,FPS_WEAPON_FIREMODE3_ENG_DPSHOT=FPS_WEAPON_FIREMODE3_ENG_DPSHOT,FPS_WEAPON_FIREMODE3_DIS_DPSHOT=FPS_WEAPON_FIREMODE3_DIS_DPSHOT,FPS_WEAPON_FIREMODE3_THE_DPSHOT=FPS_WEAPON_FIREMODE3_THE_DPSHOT,FPS_WEAPON_FIREMODE3_BIO_DPSHOT=FPS_WEAPON_FIREMODE3_BIO_DPSHOT,FPS_WEAPON_FIREMODE3_STUN_DPSHOT=FPS_WEAPON_FIREMODE3_STUN_DPSHOT,FPS_WEAPON_FIREMODE3_PHY_DPS=FPS_WEAPON_FIREMODE3_PHY_DPS,FPS_WEAPON_FIREMODE3_ENG_DPS=FPS_WEAPON_FIREMODE3_ENG_DPS,FPS_WEAPON_FIREMODE3_DIS_DPS=FPS_WEAPON_FIREMODE3_DIS_DPS,FPS_WEAPON_FIREMODE3_THE_DPS=FPS_WEAPON_FIREMODE3_THE_DPS,FPS_WEAPON_FIREMODE3_BIO_DPS=FPS_WEAPON_FIREMODE3_BIO_DPS,FPS_WEAPON_FIREMODE3_STUN_DPS=FPS_WEAPON_FIREMODE3_STUN_DPS,FPS_WEAPON_FIREMODE4_NAME=FPS_WEAPON_FIREMODE4_NAME,FPS_WEAPON_FIREMODE4_RPM=FPS_WEAPON_FIREMODE4_RPM,FPS_WEAPON_FIREMODE4_APS=FPS_WEAPON_FIREMODE4_APS,FPS_WEAPON_FIREMODE4_PPS=FPS_WEAPON_FIREMODE4_PPS,FPS_WEAPON_FIREMODE4_PHY_DPSHOT=FPS_WEAPON_FIREMODE4_PHY_DPSHOT,FPS_WEAPON_FIREMODE4_ENG_DPSHOT=FPS_WEAPON_FIREMODE4_ENG_DPSHOT,FPS_WEAPON_FIREMODE4_DIS_DPSHOT=FPS_WEAPON_FIREMODE4_DIS_DPSHOT,FPS_WEAPON_FIREMODE4_THE_DPSHOT=FPS_WEAPON_FIREMODE4_THE_DPSHOT,FPS_WEAPON_FIREMODE4_BIO_DPSHOT=FPS_WEAPON_FIREMODE4_BIO_DPSHOT,FPS_WEAPON_FIREMODE4_STUN_DPSHOT=FPS_WEAPON_FIREMODE4_STUN_DPSHOT,FPS_WEAPON_FIREMODE4_PHY_DPS=FPS_WEAPON_FIREMODE4_PHY_DPS,FPS_WEAPON_FIREMODE4_ENG_DPS=FPS_WEAPON_FIREMODE4_ENG_DPS,FPS_WEAPON_FIREMODE4_DIS_DPS=FPS_WEAPON_FIREMODE4_DIS_DPS,FPS_WEAPON_FIREMODE4_THE_DPS=FPS_WEAPON_FIREMODE4_THE_DPS,FPS_WEAPON_FIREMODE4_BIO_DPS=FPS_WEAPON_FIREMODE4_BIO_DPS,FPS_WEAPON_FIREMODE4_STUN_DPS=FPS_WEAPON_FIREMODE4_STUN_DPS,FPS_WEAPON_MAG_NAME=FPS_WEAPON_MAG_NAME,FPS_WEAPON_OPTICS_SIZE=FPS_WEAPON_OPTICS_SIZE,FPS_WEAPON_BARREL_SIZE=FPS_WEAPON_BARREL_SIZE,FPS_WEAPON_UNBARREL_SIZE=FPS_WEAPON_UNBARREL_SIZE,FPS_WEAPON_CLASS_NAME=FPS_WEAPON_CLASS_NAME}}
 +
 
 +
{{#get_db_data:
 +
db=ID
 +
|from=ITEM_SHOP
 +
|where='{{#external_value:ITEM_SHOP_CLASS}}'=ITEM_SHOP_CLASS
 +
|data=ITEM_SHOP_CLASS=ITEM_SHOP_CLASS,
 +
ITEM_SHOP_TYPE=ITEM_SHOP_TYPE,ITEM_SHOP_AREA18_NAME=ITEM_SHOP_AREA18_NAME,ITEM_SHOP_AREA18_CLASS=ITEM_SHOP_AREA18_CLASS,ITEM_SHOP_AREA18_PRICE=ITEM_SHOP_AREA18_PRICE,ITEM_SHOP_BAIJINI_NAME=ITEM_SHOP_BAIJINI_NAME,ITEM_SHOP_BAIJINI_CLASS=ITEM_SHOP_BAIJINI_CLASS,ITEM_SHOP_BAIJINI_PRICE=ITEM_SHOP_BAIJINI_PRICE,ITEM_SHOP_ARC_L1_NAME=ITEM_SHOP_ARC_L1_NAME,ITEM_SHOP_ARC_L1_CLASS=ITEM_SHOP_ARC_L1_CLASS,ITEM_SHOP_ARC_L1_PRICE=ITEM_SHOP_ARC_L1_PRICE,ITEM_SHOP_ARC_L2_NAME=ITEM_SHOP_ARC_L2_NAME,ITEM_SHOP_ARC_L2_CLASS=ITEM_SHOP_ARC_L2_CLASS,ITEM_SHOP_ARC_L2_PRICE=ITEM_SHOP_ARC_L2_PRICE,ITEM_SHOP_ARC_L3_NAME=ITEM_SHOP_ARC_L3_NAME,ITEM_SHOP_ARC_L3_CLASS=ITEM_SHOP_ARC_L3_CLASS,ITEM_SHOP_ARC_L3_PRICE=ITEM_SHOP_ARC_L3_PRICE,ITEM_SHOP_ARC_L4_NAME=ITEM_SHOP_ARC_L4_NAME,ITEM_SHOP_ARC_L4_CLASS=ITEM_SHOP_ARC_L4_CLASS,ITEM_SHOP_ARC_L4_PRICE=ITEM_SHOP_ARC_L4_PRICE,ITEM_SHOP_ARC_L5_NAME=ITEM_SHOP_ARC_L5_NAME,ITEM_SHOP_ARC_L5_CLASS=ITEM_SHOP_ARC_L5_CLASS,ITEM_SHOP_ARC_L5_PRICE=ITEM_SHOP_ARC_L5_PRICE,ITEM_SHOP_LORVILLE_NAME=ITEM_SHOP_LORVILLE_NAME,ITEM_SHOP_LORVILLE_CLASS=ITEM_SHOP_LORVILLE_CLASS,ITEM_SHOP_LORVILLE_PRICE=ITEM_SHOP_LORVILLE_PRICE,ITEM_SHOP_EVERUS_NAME=ITEM_SHOP_EVERUS_NAME,ITEM_SHOP_EVERUS_CLASS=ITEM_SHOP_EVERUS_CLASS,ITEM_SHOP_EVERUS_PRICE=ITEM_SHOP_EVERUS_PRICE,ITEM_SHOP_HUR_L1_NAME=ITEM_SHOP_HUR_L1_NAME,ITEM_SHOP_HUR_L1_CLASS=ITEM_SHOP_HUR_L1_CLASS,ITEM_SHOP_HUR_L1_PRICE=ITEM_SHOP_HUR_L1_PRICE,ITEM_SHOP_HUR_L2_NAME=ITEM_SHOP_HUR_L2_NAME,ITEM_SHOP_HUR_L2_CLASS=ITEM_SHOP_HUR_L2_CLASS,ITEM_SHOP_HUR_L2_PRICE=ITEM_SHOP_HUR_L2_PRICE,ITEM_SHOP_HUR_L3_NAME=ITEM_SHOP_HUR_L3_NAME,ITEM_SHOP_HUR_L3_CLASS=ITEM_SHOP_HUR_L3_CLASS,ITEM_SHOP_HUR_L3_PRICE=ITEM_SHOP_HUR_L3_PRICE,ITEM_SHOP_HUR_L4_NAME=ITEM_SHOP_HUR_L4_NAME,ITEM_SHOP_HUR_L4_CLASS=ITEM_SHOP_HUR_L4_CLASS,ITEM_SHOP_HUR_L4_PRICE=ITEM_SHOP_HUR_L4_PRICE,ITEM_SHOP_HUR_L5_NAME=ITEM_SHOP_HUR_L5_NAME,ITEM_SHOP_HUR_L5_CLASS=ITEM_SHOP_HUR_L5_CLASS,ITEM_SHOP_HUR_L5_PRICE=ITEM_SHOP_HUR_L5_PRICE,ITEM_SHOP_NEW_BABBAGE_NAME=ITEM_SHOP_NEW_BABBAGE_NAME,ITEM_SHOP_NEW_BABBAGE_CLASS=ITEM_SHOP_NEW_BABBAGE_CLASS,ITEM_SHOP_NEW_BABBAGE_PRICE=ITEM_SHOP_NEW_BABBAGE_PRICE,ITEM_SHOP_TRESSLER_NAME=ITEM_SHOP_TRESSLER_NAME,ITEM_SHOP_TRESSLER_CLASS=ITEM_SHOP_TRESSLER_CLASS,ITEM_SHOP_TRESSLER_PRICE=ITEM_SHOP_TRESSLER_PRICE,ITEM_SHOP_MIC_L1_NAME=ITEM_SHOP_MIC_L1_NAME,ITEM_SHOP_MIC_L1_CLASS=ITEM_SHOP_MIC_L1_CLASS,ITEM_SHOP_MIC_L1_PRICE=ITEM_SHOP_MIC_L1_PRICE,ITEM_SHOP_MIC_L2_NAME=ITEM_SHOP_MIC_L2_NAME,ITEM_SHOP_MIC_L2_CLASS=ITEM_SHOP_MIC_L2_CLASS,ITEM_SHOP_MIC_L2_PRICE=ITEM_SHOP_MIC_L2_PRICE,ITEM_SHOP_MIC_L3_NAME=ITEM_SHOP_MIC_L3_NAME,ITEM_SHOP_MIC_L3_CLASS=ITEM_SHOP_MIC_L3_CLASS,ITEM_SHOP_MIC_L3_PRICE=ITEM_SHOP_MIC_L3_PRICE,ITEM_SHOP_MIC_L4_NAME=ITEM_SHOP_MIC_L4_NAME,ITEM_SHOP_MIC_L4_CLASS=ITEM_SHOP_MIC_L4_CLASS,ITEM_SHOP_MIC_L4_PRICE=ITEM_SHOP_MIC_L4_PRICE,ITEM_SHOP_MIC_L5_NAME=ITEM_SHOP_MIC_L5_NAME,ITEM_SHOP_MIC_L5_CLASS=ITEM_SHOP_MIC_L5_CLASS,ITEM_SHOP_MIC_L5_PRICE=ITEM_SHOP_MIC_L5_PRICE,ITEM_SHOP_ORISON_NAME=ITEM_SHOP_ORISON_NAME,ITEM_SHOP_ORISON_CLASS=ITEM_SHOP_ORISON_CLASS,ITEM_SHOP_ORISON_PRICE=ITEM_SHOP_ORISON_PRICE,ITEM_SHOP_OLISAR_NAME=ITEM_SHOP_OLISAR_NAME,ITEM_SHOP_OLISAR_CLASS=ITEM_SHOP_OLISAR_CLASS,ITEM_SHOP_OLISAR_PRICE=ITEM_SHOP_OLISAR_PRICE,ITEM_SHOP_CRU_L1_NAME=ITEM_SHOP_CRU_L1_NAME,ITEM_SHOP_CRU_L1_CLASS=ITEM_SHOP_CRU_L1_CLASS,ITEM_SHOP_CRU_L1_PRICE=ITEM_SHOP_CRU_L1_PRICE,ITEM_SHOP_CRU_L2_NAME=ITEM_SHOP_CRU_L2_NAME,ITEM_SHOP_CRU_L2_CLASS=ITEM_SHOP_CRU_L2_CLASS,ITEM_SHOP_CRU_L2_PRICE=ITEM_SHOP_CRU_L2_PRICE,ITEM_SHOP_CRU_L3_NAME=ITEM_SHOP_CRU_L3_NAME,ITEM_SHOP_CRU_L3_CLASS=ITEM_SHOP_CRU_L3_CLASS,ITEM_SHOP_CRU_L3_PRICE=ITEM_SHOP_CRU_L3_PRICE,ITEM_SHOP_CRU_L4_NAME=ITEM_SHOP_CRU_L4_NAME,ITEM_SHOP_CRU_L4_CLASS=ITEM_SHOP_CRU_L4_CLASS,ITEM_SHOP_CRU_L4_PRICE=ITEM_SHOP_CRU_L4_PRICE,ITEM_SHOP_CRU_L5_NAME=ITEM_SHOP_CRU_L5_NAME,ITEM_SHOP_CRU_L5_CLASS=ITEM_SHOP_CRU_L5_CLASS,ITEM_SHOP_CRU_L5_PRICE=ITEM_SHOP_CRU_L5_PRICE,ITEM_SHOP_GRIM_NAME=ITEM_SHOP_GRIM_NAME,ITEM_SHOP_GRIM_PRICE=ITEM_SHOP_GRIM_PRICE, ITEM_SHOP_GRIM_CLASS=ITEM_SHOP_GRIM_CLASS}}
 +
 
 +
{{#get_db_data:
 +
db=ID
 +
|from=MAIN_INFORMATION
 +
|where='{{#external_value: FPS_WEAPON_MAG_NAME}}'=ITEM_KOR_NAME
 +
|data=MAG_NAME=ITEM_KOR_NAMEM
 +
}}

2022년 9월 12일 (월) 19:16 판




SELECT item_kor_namem FROM `MAIN_INFORMATION` WHERE '오류: 지역 변수가 설정되어 있지 않습니다.'=ITEM_KOR_NAME 쿼리는 유효하지 않습니다. (Error 1054: Unknown column 'item_kor_namem' in 'field list' (127.0.0.1:3307) Function: EDConnectorRdbms::fetch Query: SELECT item_kor_namem FROM `MAIN_INFORMATION` WHERE '오류: 지역 변수가 설정되어 있지 않습니다.'=ITEM_KOR_NAME )