[Release] Legend.mu client & server source code S16 1.1

Page 16 of 41 FirstFirst ... 68910111213141516171819202122232426 ... LastLast
Results 226 to 240 of 605
  1. #226
    Account Upgraded | Title Enabled! metallica is offline
    True MemberRank
    Feb 2004 Join Date
    Tandil, ArgentiLocation
    403Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    @jpra110 lol I was setting that MAX but only the Strengh just for test, I didnt realize that never work if you dont add that settings for ALL stats..now is working, thanks

    Fixed adding points :

    PHP Code:
    INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0''Character.MaxAgility''10000'), ('0''Character.MaxEnergy''10000'), ('0''Character.MaxLeadership''10000'), ('0''Character.MaxStrength''10000'), ('0''Character.MaxVitality''10000'
    Level settings:

    PHP Code:
    INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0''Character.MaxLevelMajestic''400'), ('0''Character.MaxLevelMaster''400'), ('0''Character.MaxLevelNormal''400'
    Fixed trade (at least with zen, I couldnt test with items yet):

    PHP Code:
    INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0''Character.MaxZen''1999999999'

    Server Online Stability: 12hours without crash with 2 online
    Web Developer
    Tandil Ajedrez WebMaster
    MuX Online comming soon !!

  2. #227
    Account Upgraded | Title Enabled! dezner is offline
    True MemberRank
    Aug 2006 Join Date
    BrasilLocation
    235Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    @jpra110 not work add monster crash add server code "0" instanced

  3. #228
    Registered jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    Some index, fk updates

    uniq constraint: duplicate seetting for the same server

    Code:
    ALTER TABLE `mu_online_game`.`settings` 
    ADD UNIQUE INDEX `uniq_setting_server` (`key` ASC, `server_id` ASC);
    ;

    Code:
    ALTER TABLE `mu_online_game`.`monster` 
    ADD CONSTRAINT `server_fk`
      FOREIGN KEY (`server`)
      REFERENCES `mu_online_login`.`server_list` (`server`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `monster_template_fk`
      FOREIGN KEY (`id`)
      REFERENCES `mu_online_game`.`monster_template` (`id`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION

    uniq constraint: duplicate world for the same server, and world fks

    Code:
    ALTER TABLE `mu_online_login`.`world_server` 
    ADD INDEX `server_fk_idx` (`server` ASC),
    ADD INDEX `world_fk_idx` (`world` ASC),
    ADD UNIQUE INDEX `server_unique_world` (`world` ASC, `server` ASC);
    ;
    ALTER TABLE `mu_online_login`.`world_server` 
    ADD CONSTRAINT `server_fk`
      FOREIGN KEY (`server`)
      REFERENCES `mu_online_login`.`server_list` (`server`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION;
    uniq constraint: duplicate character name
    Code:
    ALTER TABLE `mu_online_login`.`accounts` 
    ADD UNIQUE INDEX `unique` (`account` ASC);
    character fk
    Code:
    ALTER TABLE `mu_online_characters`.`character_info` 
    ADD INDEX `account_fk_idx` (`account_id` ASC),
    ADD UNIQUE INDEX `unique_name` (`name` ASC),
    ADD INDEX `world_fk_idx` (`world` ASC);
    ;
    ALTER TABLE `mu_online_characters`.`character_info` 
    ADD CONSTRAINT `account_fk`
      FOREIGN KEY (`account_id`)
      REFERENCES `mu_online_login`.`accounts` (`guid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION;
    working on
    mu_online_game.monster.respawn_id fk reference ??
    monster.type ===> monster soul data ===> table monster_soul_converter

  4. #229
    Registered jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    Some index, fk updates

    uniq constraint: duplicate seetting for the same server

    Code:
    ALTER TABLE `mu_online_game`.`settings` 
    ADD UNIQUE INDEX `uniq_setting_server` (`key` ASC, `server_id` ASC);
    ;

    Code:
    ALTER TABLE `mu_online_game`.`monster` 
    ADD CONSTRAINT `server_fk`
      FOREIGN KEY (`server`)
      REFERENCES `mu_online_login`.`server_list` (`server`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `monster_template_fk`
      FOREIGN KEY (`id`)
      REFERENCES `mu_online_game`.`monster_template` (`id`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION

    uniq constraint: duplicate world for the same server, and world fks

    Code:
    ALTER TABLE `mu_online_login`.`world_server` 
    ADD INDEX `server_fk_idx` (`server` ASC),
    ADD INDEX `world_fk_idx` (`world` ASC),
    ADD UNIQUE INDEX `server_unique_world` (`world` ASC, `server` ASC);
    ;
    ALTER TABLE `mu_online_login`.`world_server` 
    ADD CONSTRAINT `server_fk`
      FOREIGN KEY (`server`)
      REFERENCES `mu_online_login`.`server_list` (`server`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION;
    uniq constraint: duplicate character name
    Code:
    ALTER TABLE `mu_online_login`.`accounts` 
    ADD UNIQUE INDEX `unique` (`account` ASC);
    character fk
    Code:
    ALTER TABLE `mu_online_characters`.`character_info` 
    ADD INDEX `account_fk_idx` (`account_id` ASC),
    ADD UNIQUE INDEX `unique_name` (`name` ASC),
    ADD INDEX `world_fk_idx` (`world` ASC);
    ;
    ALTER TABLE `mu_online_characters`.`character_info` 
    ADD CONSTRAINT `account_fk`
      FOREIGN KEY (`account_id`)
      REFERENCES `mu_online_login`.`accounts` (`guid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION;
    working on
    mu_online_game.monster.respawn_id fk reference ??
    monster.type ===> monster soul data ===> table monster_soul_converter

  5. #230
    Registered jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    Quote Originally Posted by dezner View Post
    @jpra110 not work add monster crash add server code "0" instanced

    try this



    Some index, fk updates

    uniq constraint: duplicate seetting for the same server

    Code:
    ALTER TABLE `mu_online_game`.`settings` 
    ADD UNIQUE INDEX `uniq_setting_server` (`key` ASC, `server_id` ASC);
    ;

    Code:
    ALTER TABLE `mu_online_game`.`monster` 
    ADD CONSTRAINT `server_fk`
      FOREIGN KEY (`server`)
      REFERENCES `mu_online_login`.`server_list` (`server`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `monster_template_fk`
      FOREIGN KEY (`id`)
      REFERENCES `mu_online_game`.`monster_template` (`id`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION

    uniq constraint: duplicate world for the same server, and world fks

    Code:
    ALTER TABLE `mu_online_login`.`world_server` 
    ADD INDEX `server_fk_idx` (`server` ASC),
    ADD INDEX `world_fk_idx` (`world` ASC),
    ADD UNIQUE INDEX `server_unique_world` (`world` ASC, `server` ASC);
    ;
    ALTER TABLE `mu_online_login`.`world_server` 
    ADD CONSTRAINT `server_fk`
      FOREIGN KEY (`server`)
      REFERENCES `mu_online_login`.`server_list` (`server`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION;
    uniq constraint: duplicate character name
    Code:
    ALTER TABLE `mu_online_login`.`accounts` 
    ADD UNIQUE INDEX `unique` (`account` ASC);
    character fk
    Code:
    ALTER TABLE `mu_online_characters`.`character_info` 
    ADD INDEX `account_fk_idx` (`account_id` ASC),
    ADD UNIQUE INDEX `unique_name` (`name` ASC),
    ADD INDEX `world_fk_idx` (`world` ASC);
    ;
    ALTER TABLE `mu_online_characters`.`character_info` 
    ADD CONSTRAINT `account_fk`
      FOREIGN KEY (`account_id`)
      REFERENCES `mu_online_login`.`accounts` (`guid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
    ADD CONSTRAINT `world_fk`
      FOREIGN KEY (`world`)
      REFERENCES `mu_online_game`.`world_template` (`entry`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION;
    working on
    mu_online_game.monster.respawn_id fk reference ??
    monster.type ===> monster soul data ===> table monster_soul_converter

  6. #231
    Account Upgraded | Title Enabled! dezner is offline
    True MemberRank
    Aug 2006 Join Date
    BrasilLocation
    235Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    @jpra110 I will wait for someone to try to reproduce to check if they have the same error, my memo with its changes I keep getting crash

  7. #232
    Registered jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    Could you share the log file ?

    - - - Updated - - -

    Quote Originally Posted by Sam3000 View Post
    @jpra110 yeah, add stats is working now, thx.

    - - - Updated - - -


    You need to update code too
    Code:
       for ( uint8 i = 0; i < Element::MAX; i++ )
       {
        add_monster->SetResistance(i, fields[loop++].GetUInt8());
       }
    - - - Updated - - -

    Resistance order from server
    Code:
    namespace Element
    {
      enum
      {
        ICE,
        POISON,
        LIGHTNING,
        FIRE,
        EARTH,
        WIND,
        WATER,
        MAX
      };
    }
    - - - Updated - - -


    Lol i missed this :D

    - - - Updated - - -

    @jpra110 use mudev_s16 data folder, with some regex (simply in notepad++) you can easlity make csv and import

    - - - Updated - - -

    I will do it now

    - - - Updated - - -

    https://mega.nz/file/BOxiECoB#Edn9uI...4PMoZNGvneA62c
    But i dont know where to put Level column (now is min_level), AttackType and MonsterExpLevel, RegenTime and Attribute too
    Other columns i think is ok.
    Skill column need to move in monster_skill

    - - - Updated - - -

    About resistance, checked mudev_s16 folder max value is 255, so it's ok to be tinyint unsigned

    - - - Updated - - -

    ps. guys i dont using update to MonsterManager from MuLegend. Dont want for now

    - - - Updated - - -

    Ok, so MonsterExpLevel is useless i think. Check source


    - - - Updated - - -

    AttackType is useless too, cant find any lines in code about it.
    Found:


    - - - Updated - - -

    Maybe Attribute is life, mana, sd or stamina? And RegenTime it's time?

    - - - Updated - - -

    My current db https://github.com/samik3k/mu_online.../main/Database (with updates my and from topic)

    - - - Updated - - -

    https://mega.nz/file/ZeQAQZzS#Pnycs9...u8QA-4q6FiWyjU monster_ai tables without monster_ai_data (from mudev, they have differenet ai)
    @Sam3000 monster_template column order is not correct

    - - - Updated - - -

    Quote Originally Posted by dezner View Post
    @jpra110 not work add monster crash add server code "0" instanced
    I just realized, server is the first column not the last as metion here

    Quote Originally Posted by jpra110 View Post
    A column is missing in mu_online_game.monster, look at the cycle start index, it starts at index 1, so a column is missing at index 0 in the monster table. I am currently looking for the name of the current column. Fixed this, the mob spawn correctly.



    edit:
    found, the first column is 'server' instead of the last one. from https://github.com/DimensionGamers/L...me/monster.sql

  8. #233
    Ultimate Member Sam3000 is offline
    MemberRank
    Oct 2007 Join Date
    MoscowLocation
    187Posts

    Re: [Release] Legend.mu client &amp;amp;amp;amp; server source code S16 1.1

    Quote Originally Posted by jpra110 View Post
    @Sam3000 monster_template column order is not correct
    First row of csv file is column mapping.
    Check:
    Click image for larger version. 

Name:	photo_2021-03-14_01-57-28.jpg 
Views:	60 
Size:	21.4 KB 
ID:	169351

    Btw, check my monster_soul_*, but i didnt done reward, dunnno about data.
    https://github.com/samik3k/mu_online...fa984c54e04894

    - - - Updated - - -

    Quote Originally Posted by jpra110 View Post
    I just realized, server is the first column not the last as metion here
    I added this fixes to my db.
    Thx for constraints. Wanter to fill data and after add unique keys and other stuff

    - - - Updated - - -

    ps. why you want to use unique key for settings if you have already PRIMARY KEY (`server_id`,`key`)?

  9. #234
    Account Upgraded | Title Enabled! metallica is offline
    True MemberRank
    Feb 2004 Join Date
    Tandil, ArgentiLocation
    403Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    Web Developer
    Tandil Ajedrez WebMaster
    MuX Online comming soon !!

  10. #235
    Registered jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

    Re: [Release] Legend.mu client &amp;amp;amp;amp; server source code S16 1.1

    Quote Originally Posted by Sam3000 View Post

    ps. why you want to use unique key for settings if you have already PRIMARY KEY (`server_id`,`key`)?
    Whoops i miss this, my bad

  11. #236
    Ultimate Member Sam3000 is offline
    MemberRank
    Oct 2007 Join Date
    MoscowLocation
    187Posts

    Re: [Release] Legend.mu client &amp;amp; server source code S16 1.1

    Quote Originally Posted by jpra110 View Post
    Whoops i miss this, my bad
    Do you know where to put AttackType, Attribute and RegenTime from monsters.txt (mudev_s16)?

    - - - Updated - - -

    My monster_template
    https://mega.nz/file/YXY2WTTQ#dBeoxy...czTE1gq6Bno1QM
    Skipped AttackType and RegenTime
    Added exp column


    - - - Updated - - -

    Testing monster spawn, looking where i can set monster quantity

    - - - Updated - - -

    mu_online_game.monster.type
    OBJECT_TYPE_NONE,
    OBJECT_TYPE_PLAYER,
    OBJECT_TYPE_MONSTER,
    OBJECT_TYPE_WORLD_ITEM,
    - - - Updated - - -

    this->SetRespawnLocation((data->GetX1() == data->GetX2() && data->GetY1() == data->GetY2()) ? MONSTER_RESPAWN_NORMAL: MONSTER_RESPAWN_ZONE);
    About respawn
    Last edited by Sam3000; 14-03-21 at 11:50 AM.

  12. #237
    Registered jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    @Sam3000, @mesosa commits some changes, and specifically MonsterManger has changed, are you using the latest commit?

    I think you are missing something, the '```model' column refers to the bmd skin of the mob (or the mob itself), with the latest schema/code changes.

    For example
    id, name, model, ....
    0, BullFigther, 3 ....
    Is actually a Spider because 3 is the internal id of the bmd or something like that. Currently if I change the model for another id I get a diferent mob for the same row

    Currently my monster_template > model === id for every row

    update: can confirm that is only the skin, not the actual monster
    Because the damage it does is the damage defined for the spider




    I am not understanding if it is because of the AttackType that is missing at the moment or if there is some problem with agility, the mob hits me 30 times at the same time
    Last edited by jpra110; 14-03-21 at 06:35 PM. Reason: more info

  13. #238
    OMEGA favgames is offline
    True MemberRank
    Oct 2006 Join Date
    LorenciaLocation
    313Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    minimap table is correct?

    has how to turn off the / auth system?
    Last edited by favgames; 14-03-21 at 08:39 PM.

  14. #239
    Registered dns360 is offline
    MemberRank
    Jun 2009 Join Date
    5Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    How change resolution?

  15. #240
    OMEGA favgames is offline
    True MemberRank
    Oct 2006 Join Date
    LorenciaLocation
    313Posts

    Re: [Release] Legend.mu client & server source code S16 1.1

    Client\LauncherOption.if >> DevModeIndex:3



Advertisement