Jump to content
Maintenance ×
×
×
  • Create New...
  • 0

Item/mob proto from xml to sql


Denny2399

Question

6 answers to this question

Recommended Posts

  • 0
11 minutes ago, Woytman said:

For example? Send one line from convert and one line, how do you want to have it. //sorry bad english :)

The one I want to convert: <Mob vnum="155" name="Li-An" locale_name="Li-An" type="0" rank="3" battle_type="4" level="24" size="0" gold_min="0" gold_max="0" exp="250" max_hp="1200" regen_cycle="15" regen_percent="20" def="29" ai_flag="1" setRaceFlag="1" setImmuneFlag="0" st="25" dx="17" ht="45" iq="9" damage_min="59" damage_max="72" attack_speed="100" move_speed="130" aggressive_hp_pct="50" aggressive_sight="2000" attack_range="175" enchant_curse="0" enchant_slow="0" enchant_poison="0" enchant_stun="0" enchant_critical="20" enchant_penetrate="20" resist_sword="0" resist_twohand="0" resist_dagger="0" resist_bell="0" resist_fan="0" resist_bow="0" resist_fire="0" resist_elect="0" resist_magic="0" resist_wind="0" resist_poison="0" resurrection_vnum="0" drop_item="0" on_click="0" empire="0" folder="tiger" dam_multiply="2.000000" summon="0" drain_sp="0" mob_color="13434828" polymorph_item="0" skill_vnum0="0" skill_level0="0" skill_vnum1="0" skill_level1="0" skill_vnum2="0" skill_level2="0" skill_vnum3="0" skill_level3="0" skill_vnum4="0" skill_level4="0" sp_berserk="0" sp_stoneskin="0" sp_godspeed="0" sp_deathblow="0" sp_revive="0" />

What I get when I click on convert: INSERT INTO `mob_proto` (`vnum`, `name`, `locale_name`, `rank`, `type`, `battle_type`, `level`, `size`, `ai_flag`, `mount_capacity`, `setRaceFlag`, `setImmuneFlag`, `empire`, `folder`, `on_click`, `st`, `dx`, `ht`, `iq`, `damage_min`, `damage_max`, `max_hp`, `regen_cycle`, `regen_percent`, `gold_min`, `gold_max`, `exp`, `def`, `attack_speed`, `move_speed`, `aggressive_hp_pct`, `aggressive_sight`, `attack_range`, `drop_item`, `resurrection_vnum`, `enchant_curse`, `enchant_slow`, `enchant_poison`, `enchant_stun`, `enchant_critical`, `enchant_penetrate`, `resist_sword`, `resist_twohand`, `resist_dagger`, `resist_bell`, `resist_fan`, `resist_bow`, `resist_fire`, `resist_elect`, `resist_magic`, `resist_wind`, `resist_poison`, `dam_multiply`, `summon`, `drain_sp`, `mob_color`, `polymorph_item`, `skill_level0`, `skill_vnum0`, `skill_level1`, `skill_vnum1`, `skill_level2`, `skill_vnum2`, `skill_level3`, `skill_vnum3`, `skill_level4`, `skill_vnum4`, `sp_berserk`, `sp_stoneskin`, `sp_godspeed`, `sp_deathblow`, `sp_revive`) VALUES (155, 'Li-An', 'Li-An', 3, 0, 4, 24, '0', 'AGGR', 0, 'ANIMAL', '0', 0, 'tiger', 0, 25, 17, 45, 9, 59, 72, 1200, 15, 20, 0, 0, 250, 29, 100, 130, 50, 2000, 175, 0, 0, 0, 0, 0, 0, 20, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.000000, 0, 0, 13434828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

The one how it has to be: INSERT INTO `mob_proto` VALUES ('155', '?? ??', 0x4C692D416E, '3', '0', '4', '24', '', 'AGGR', '0', 'ANIMAL', '', '0', 'tiger', '0', '25', '17', '45', '9', '59', '72', '1200', '15', '20', '1950', '2860', '5000', '29', '100', '130', '50', '2000', '175', '0', '0', '0', '0', '0', '0', '20', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

English:
As you can see it writes out the example before the right output. I think something is wrong with php script.
Czech:
Vypisuje to nějaký vzorový výsledek před tím který potřebuji. Myslím, že je něco špatně v php scriptu.

Link to comment
Share on other sites

  • 0

Czech:

Nu podle toho co koukám tak je to správně, ta vzorová část je pro Navicat (nebo jiný sql manager), aby veděl kam ty údaje doplnit, počítá s tím, že mob_proto.sql ještě neexistuje, ten vzor slouží pro vytvoření tabulky s příslušnými sloupci, nebo pro kontrolu zda staré sloupce souhlasí s novými query.

English:

So, what I look to make it right, the sample part is for Navicat.

  • Love 1
Link to comment
Share on other sites

  • 0

English:
Oh, now I understand. Thank you :) 
It would be nice to make application form from it.

Czech: 
Už rozumím. Děkuju moc :) 
Bylo by hezké z toho zkompilovat aplikaci/exe soubor :) 
Pokud se znáš s autorem, nebo jsi jím sám, tak bych tohle uvítal.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.


  • Activity

    1. 0

      erorrs after update granny to 2.9

    2. 0

      Navicat Premium 16.1.1 x64

    3. 5

      problem Dargon Soul Changre Attribute

    4. 5

      problem Dargon Soul Changre Attribute

    5. 41

      Global Chat

    6. 5

      problem Dargon Soul Changre Attribute

    7. 2

      Startup Loading Window Library

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.