Looking for a query

General assistance and guidelines for editing the server side of Soma.

Looking for a query

Postby gallim » Mon Apr 08, 2013 10:24 am

I've tried searching and only found the monster/monsterset guide which helps explain the fields.

I need a basic Query which I can edit to input monster/monsterset values.

Thx
gallim
SD Five Star
SD Five Star
 
Posts: 305
Joined: Tue Feb 26, 2008 6:31 pm

Re: Looking for a query

Postby gallim » Mon Apr 08, 2013 6:48 pm

INSERT INTO MONSTERSET
(sSid, sZone, sMinX, sMinY, sMaxX, sMaxY, sNum, sTableNum, sRegenType, sRegenTime, sRegenEvent, sGroup, sGuild, sGuildOpt, sChat01, sChat02, sChat03, sMaxItemNum, sItem01, sItem01Rand, sItem02, sItem02Rand, sItem03, sItem03Rand, sItem04, sItem04Rand, sItem05, sItem05Rand, sItem06, sItem06Rand, sItem07, sItem07Rand, sItem08, sItem08Rand, sItem09, sItem09Rand, sItem10, sItem10Rand, sItem11, sItem11Rand, sItem12, sItem12Rand, sItem13, sItem13Rand, sItem14, sItem14Rand, sItem15, sItem15Rand, sEventNum, sMoneyType, sMoneyMin, sMoneyMax)
VALUES (4450, 4, 36, 14, 36, 14, 1, 4450, 0, 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, -1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, 1510, 0, 0, 0)

INSERT INTO MONSTER
(sSid, sPid, tType, sTypeAI, sMinDamage, sClass, strName, sBlood, sLevel, iMaxExp, sStr, sWStr, sAStr, sDex_at, sDex_df, sIntel, sCharm, sWis, sCon, sMaxHp, sMaxMp, iStatus, iMoral, at_type, can_escape, can_find_enemy, can_find_our, have_item_num, haved_item, have_magic_num, haved_magic, have_skill_num, haved_skill, search_range, movable_range, move_speed, standing_time, regen_time, bmagicexp, wmagicexp, dmagicexp, sRangeRate, sBackRate, sHowTarget, sMoneyRate, sMagicNum01, sMagicRate01, sMagicNum02, sMagicRate02, sMagicNum03, sMagicRate03, sDistance)
VALUES (4450, 999, 0, 0, 0, 0, '!Trollcave', 0, 1, 0, 9, 11, 0, 7, 7, 2, 0, 0, 0, 47, 1, 0, 0, 0, 0, 0, 0, 0, - 1, 0, - 1, 0, - 1, 10, 10, 1, 20000, 5000, 0, 0, 0, 100, 0, 0, 0, - 1, 0, - 1, 0, - 1, 0, 1)


found an example
gallim
SD Five Star
SD Five Star
 
Posts: 305
Joined: Tue Feb 26, 2008 6:31 pm

Re: Looking for a query

Postby gallim » Mon Apr 08, 2013 6:48 pm

wow its too quiet..........
gallim
SD Five Star
SD Five Star
 
Posts: 305
Joined: Tue Feb 26, 2008 6:31 pm

Re: Looking for a query

Postby phoenixgolden » Mon Apr 08, 2013 11:50 pm

Monster
310 149 1 0 20 0 Yogi Bear 7 99 455000 130 370 210 130 0 90 1000 500 3 7000 10000 0 8 1 0 1 1002 0 -1 0 -1 0 -1 8 6 2500 1000 5000 0 0 0 70 30 1 100 29 7 -1 -1 -1 0 1



MonsterSet
3831 4 40 40 40 40 10 2081 0 900000 -1 -1 -1 -1 -1 -1 -1 1 1594 5000 1593 5000 1592 5000 1591 5000 1590 5000 1589 5000 1588 5000 1587 5000 1586 5000 1585 5000 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 0 0 0 300000

Is this what u looking for or you want something different?
Phoenix.

Image

Human @Inca SomaDev (retired)
phoenixgolden
SD Pro 5 Star
SD Pro 5 Star
 
Posts: 1170
Joined: Sat Oct 08, 2011 9:24 pm

Re: Looking for a query

Postby gallim » Tue Apr 09, 2013 5:00 pm

gallim wrote:INSERT INTO MONSTERSET
(sSid, sZone, sMinX, sMinY, sMaxX, sMaxY, sNum, sTableNum, sRegenType, sRegenTime, sRegenEvent, sGroup, sGuild, sGuildOpt, sChat01, sChat02, sChat03, sMaxItemNum, sItem01, sItem01Rand, sItem02, sItem02Rand, sItem03, sItem03Rand, sItem04, sItem04Rand, sItem05, sItem05Rand, sItem06, sItem06Rand, sItem07, sItem07Rand, sItem08, sItem08Rand, sItem09, sItem09Rand, sItem10, sItem10Rand, sItem11, sItem11Rand, sItem12, sItem12Rand, sItem13, sItem13Rand, sItem14, sItem14Rand, sItem15, sItem15Rand, sEventNum, sMoneyType, sMoneyMin, sMoneyMax)
VALUES (4450, 4, 36, 14, 36, 14, 1, 4450, 0, 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, -1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, - 1, 1510, 0, 0, 0)

INSERT INTO MONSTER
(sSid, sPid, tType, sTypeAI, sMinDamage, sClass, strName, sBlood, sLevel, iMaxExp, sStr, sWStr, sAStr, sDex_at, sDex_df, sIntel, sCharm, sWis, sCon, sMaxHp, sMaxMp, iStatus, iMoral, at_type, can_escape, can_find_enemy, can_find_our, have_item_num, haved_item, have_magic_num, haved_magic, have_skill_num, haved_skill, search_range, movable_range, move_speed, standing_time, regen_time, bmagicexp, wmagicexp, dmagicexp, sRangeRate, sBackRate, sHowTarget, sMoneyRate, sMagicNum01, sMagicRate01, sMagicNum02, sMagicRate02, sMagicNum03, sMagicRate03, sDistance)
VALUES (4450, 999, 0, 0, 0, 0, '!Trollcave', 0, 1, 0, 9, 11, 0, 7, 7, 2, 0, 0, 0, 47, 1, 0, 0, 0, 0, 0, 0, 0, - 1, 0, - 1, 0, - 1, 10, 10, 1, 20000, 5000, 0, 0, 0, 100, 0, 0, 0, - 1, 0, - 1, 0, - 1, 0, 1)


found an example


Already done it. Your a total knob mate.
gallim
SD Five Star
SD Five Star
 
Posts: 305
Joined: Tue Feb 26, 2008 6:31 pm


Return to Server Development

Who is online

Users browsing this forum: No registered users and 1 guest

cron