MrCosmo666 / Teeworlds-MRPG

Other
7 stars 9 forks source link

Progress to update 2.0.1 #37

Closed kurosio closed 4 years ago

kurosio commented 4 years ago

Patch notes

Assignees can edit a issue in case of progress or changes, as well as attach a link to the PR under each task Release type Current version Update to version
Game 2.0.0 2.0.1
Protocol 1024 1025

Shared side

Client side

Server side

Protocol side

No changes

Database changes are attached to Update

Changes from #36

-- remove EnchantMax field
ALTER TABLE `tw_items_list` DROP `EnchantMax`;

-- set strength how unfield (this will not address 'tw_accounts' Strength) and drop it from 'tw_accounts_data'
UPDATE `tw_attributs` SET `field_name` = 'unfield' WHERE `tw_attributs`.`ID` = 4;
ALTER TABLE `tw_accounts_data` DROP `Strength`;

-- drop enum_craft_tabs (unused only confuses)
DROP TABLE `ENUM_CRAFT_TABS`;

Changes from #49

-- change the Strength type to hard where is the power of each weapon
UPDATE `tw_attributs` SET `at_type` = '4' WHERE `tw_attributs`.`ID` = 4;
-- import it without check foreign keys
-- some corrections with the attribute structure
SET foreign_key_checks = 0;

DROP TABLE `tw_attributs`;

CREATE TABLE `tw_attributs` (
  `ID` int(11) PRIMARY KEY NOT NULL,
  `name` varchar(32) NOT NULL,
  `field_name` varchar(32) NOT NULL DEFAULT 'unfield',
  `price` int(11) NOT NULL,
  `at_type` int(11) NOT NULL COMMENT '0.tank1.healer2.dps3.weapon4.hard5.jobs 6. others',
  `divide` int(11) NOT NULL DEFAULT 0 COMMENT 'if the value is set the final stats will be divided by the set number'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `tw_attributs` (`ID`, `name`, `field_name`, `price`, `at_type`, `divide`) VALUES
(1, 'Shotgun Spread', 'SpreadShotgun', 100, 3, 0),
(2, 'Grenade Spread', 'SpreadGrenade', 100, 3, 0),
(3, 'Rifle Spread', 'SpreadRifle', 100, 3, 0),
(4, 'Strength', 'unfield', -1, 4, 10),
(5, 'Dexterity', 'Dexterity', 1, 2, 5),
(6, 'Crit Dmg', 'CriticalHit', 1, 2, 5),
(7, 'Direct Crit Dmg', 'DirectCriticalHit', 1, 2, 5),
(8, 'Hardness', 'Hardness', 1, 0, 5),
(9, 'Lucky', 'Lucky', 1, 0, 5),
(10, 'Piety', 'Piety', 1, 1, 5),
(11, 'Vampirism', 'Vampirism', 1, 1, 5),
(12, 'Ammo Regen', 'AmmoRegen', 1, 3, 5),
(13, 'Ammo', 'Ammo', 30, 3, 0),
(14, 'Efficiency', 'unfield', -1, 5, 0),
(15, 'Extraction', 'unfield', -1, 5, 0),
(16, 'Hammer Power', 'unfield', -1, 4, 10),
(17, 'Gun Power', 'unfield', -1, 4, 10),
(18, 'Shotgun Power', 'unfield', -1, 4, 10),
(19, 'Grenade Power', 'unfield', -1, 4, 10),
(20, 'Rifle Power', 'unfield', -1, 4, 10),
(21, 'Lucky items', 'unfield', -1, 6, 5);

SET foreign_key_checks = 1;
-- Progress -> Step
ALTER TABLE `tw_accounts_quests` CHANGE `Progress` `Step` INT(11) NOT NULL DEFAULT **'1';**

Things needed to be done for this update

Anime-pdf commented 4 years ago

What about my issue about rework upgrade system, its more like idea but still an able update

Anime-pdf commented 4 years ago

Am I the only one who does nothing? :(

Anime-pdf commented 4 years ago

I suggest use python discord bot instead of c++ cuz of python lib have much more functional. Or use some python code in c++ using Boost.Python

MrCosmo666 commented 4 years ago

I suggest use python discord bot instead of c++ cuz of python lib have much more functional. Or use some python code in c++ using Boost.Python

I would prefer Node.js over Python: https://discord.js.org/

Anime-pdf commented 4 years ago

I suggest use python discord bot instead of c++ cuz of python lib have much more functional. Or use some python code in c++ using Boost.Python

I would prefer Node.js over Python: https://discord.js.org/

first of all i have friends with expirience making bots on node js. Their lib is not stable they can change names of methods and ur code won't work. In python u can use older version of lib and it will be fine. Also i have expirience in making bots on python and it is easier to use.

MrCosmo666 commented 4 years ago

You can choose the version you want to use in node.js and don't think python is easier to use. But if you want to use python you can do it of course.

kurosio commented 4 years ago

@Anime-pdf There are a couple of questions other than working with the database how you want to communicate between the server and the discord.

In this case it will be divided as separate components not connected with themselves in any case you will need a bridge between them.