The forums will be going offline for an extended maintenance period at 1400hrs GMT on 19th June 2025. The number of hours for this downtime is intentionally not advertised due to the nature of these upgrades.
×
- 0
Mob db Sql Error
-
Recently Browsing 0 members
- No registered users viewing this page.
Question
Altimage
cannot import mobdb.sql
# 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). You may change Name,JName field though
REPLACE INTO `mob_db`
VALUES ( 1001, 'SCORPION', 'Scorpion', 'Scorpion', 24, 1109, NULL , 287, 176, 1, 80, 135, 30, NULL , 1, 24, 24, 5, 52, 5, 10, 12, NULL , 4, 23, 0x3195, 200, 1564, 864, 576, NULL , NULL , NULL , NULL , NULL , NULL , NULL , 990, 70, 904, 5500, 757, 57, 943, 210, 7041, 100, 508, 200, 625, 20, NULL , NULL , NULL , NULL , 4068, 1 ) ;
MySQL :
#1048 - Column 'SP' cannot be null
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.