Altimage Posted June 14, 2012 Group: Members Topic Count: 23 Topics Per Day: 0.00 Content Count: 96 Reputation: 1 Joined: 03/07/12 Last Seen: January 19, 2023 Share Posted June 14, 2012 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 Quote Link to comment Share on other sites More sharing options...
Bahmut Posted June 14, 2012 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 382 Reputation: 39 Joined: 01/17/12 Last Seen: February 13, 2020 Share Posted June 14, 2012 Yeah it's a bug and will be fixed soon: http://rathena.org/board/tracker/issue-6013-sql-files-error-when-executing-sql-file/ Quote Link to comment Share on other sites More sharing options...
Altimage Posted June 16, 2012 Group: Members Topic Count: 23 Topics Per Day: 0.00 Content Count: 96 Reputation: 1 Joined: 03/07/12 Last Seen: January 19, 2023 Author Share Posted June 16, 2012 thk Quote Link to comment Share on other sites More sharing options...
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.