Monster.SData

08/20/2013 05:05 [Admin]Slice#1
does anybody know how to make a MonsterEx.SData so i could get the .sql file for my Monster.SData ? or is there any other way i could get the Monster.Sql
thanks ^.^
08/20/2013 08:16 killer870#2
if you already have the server files you can import the mobs and mobsitem .csv to the monsters.sdata and as son as you save it a monsterEX will appeared and the .sql quiery too, there is info scattered everywhere in this forum about that, all you have to do is read.
08/20/2013 12:53 AxelMac#3
[Only registered and activated users can see links. Click Here To Register...]
08/21/2013 01:11 [Admin]Slice#4
Quote:
Originally Posted by killer870 View Post
if you already have the server files you can import the mobs and mobsitem .csv to the monsters.sdata and as son as you save it a monsterEX will appeared and the .sql quiery too, there is info scattered everywhere in this forum about that, all you have to do is read.
how do i get the csv files like if i want to edit my monster.sdata how do i get the sql file for it

how do i get the csv files like if i want to edit my monster.sdata how do i get the sql file for it

o.o
08/30/2013 15:30 oasis1984#5
Inside SQL Management Studio, open a New Query window
Run
Quote:
USE PS_GameDefs
SELECT *
FROM Mobs
Save the results as ANSI for importing into the Monster.SData.

Do the same for the MobItems table, save Monster.SData and it'll create a MonsterEx.SData.

ADDITION: All the MonsterEx.SData adds, is the current mob drops and amounts.
09/26/2013 01:47 [Admin]Slice#6
[Only registered and activated users can see links. Click Here To Register...] when I try to import it..
[Only registered and activated users can see links. Click Here To Register...]
09/26/2013 08:52 geor123#7
Quote:
Originally Posted by [Admin]Slice View Post
[Only registered and activated users can see links. Click Here To Register...] when I try to import it..
[Only registered and activated users can see links. Click Here To Register...]
Check if your table RowID exists, if there ... verifies that you are saving the file to Ansi and also that your file have expressed tables at startup.

Example;

Code:
RowID;MobID;MobName;Level;Exp;AI;Money1;Money2;QuestItemID;HP;SP;MP;Dex;Wis;Luc;Day;Size;Attrib;Defense;Magic;ResistState1;ResistState2;ResistState3;ResistState4;ResistState5;ResistState6;ResistState7;ResistState8;ResistState9;ResistState10;ResistState11;ResistState12;ResistState13;ResistState14;ResistState15;ResistSkill1;ResistSkill2;ResistSkill3;ResistSkill4;ResistSkill5;ResistSkill6;NormalTime;NormalStep;ChaseTime;ChaseStep;ChaseRange;AttackType1;AttackTime1;Attackrange1;Attack1;Attackplus1;Attackattrib1;Attackspecial1;Attackok1;Attacktype2;Attacktime2;Attackrange2;Attack2;Attackplus2;Attackattrib2;Attackspecial2;Attackok2;Attacktype3;Attacktime3;Attackrange3;Attack3;Attackplus3;Attackattrib3;Attackspecial3;Attackok3
1;0;Error Monster;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;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;0;0;0;0;0;0;0;0;0;0;0
09/26/2013 12:44 [Admin]Slice#8
Quote:
Originally Posted by geor123 View Post
Check if your table RowID exists, if there ... verifies that you are saving the file to Ansi and also that your file have expressed tables at startup.

Example;

Code:
RowID;MobID;MobName;Level;Exp;AI;Money1;Money2;QuestItemID;HP;SP;MP;Dex;Wis;Luc;Day;Size;Attrib;Defense;Magic;ResistState1;ResistState2;ResistState3;ResistState4;ResistState5;ResistState6;ResistState7;ResistState8;ResistState9;ResistState10;ResistState11;ResistState12;ResistState13;ResistState14;ResistState15;ResistSkill1;ResistSkill2;ResistSkill3;ResistSkill4;ResistSkill5;ResistSkill6;NormalTime;NormalStep;ChaseTime;ChaseStep;ChaseRange;AttackType1;AttackTime1;Attackrange1;Attack1;Attackplus1;Attackattrib1;Attackspecial1;Attackok1;Attacktype2;Attacktime2;Attackrange2;Attack2;Attackplus2;Attackattrib2;Attackspecial2;Attackok2;Attacktype3;Attacktime3;Attackrange3;Attack3;Attackplus3;Attackattrib3;Attackspecial3;Attackok3
1;0;Error Monster;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;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;0;0;0;0;0;0;0;0;0;0;0
ROWID is there, and I am saving as ANSI