Dofus 2.42 (Azote)

[xlw00tlx]

any way to solve my problem?im using xampp and server ask for ssl

 

[AdeptGamer]

french

If you search long enough you can find one of the other language files, I just gave up because I got tired of reading French forums.

 

[slawdos]

Client included i18n-files for de, en, es, fr, it, pr language.
It's another matter whether the server can work with these languages.

 

[nhed57]

How to change languages to english or (other languages available in data\i18n folder?)

1. rename i18n_fr.d2i to i18n_en.d2i
2. rename i18n_en.d2i to i18n_fr.d2i

 

[walter307]

any way to solve my problem?im using xampp and server ask for ssl

Still waiting for answer about it

 

[yanicoiii]

How to use ssl on mysql?
Windows os

 

[matheos]

no pnj and boutique?

 

[Fur Zi]

Proper installation for both server and client will be much appreciated. I will be hosting this for people to try.

 

[walter307]

Proper installation for both server and client will be much appreciated. I will be hosting this for people to try.

That's awesome of you @Fur Zi. Did you try to run it on your pc?

 

[Fur Zi]

That's awesome of you @Fur Zi. Did you try to run it on your pc?

Hi there! Yes I have but currently it gives problem whenever you open the server. If a proper installation is released then I will host this for people to try on

 

[matheos]

bd no complète

 

[walter307]

Hi there! Yes I have but currently it gives problem whenever you open the server. If a proper installation is released then I will host this for people to try on

Ikr! :laugh: well, in my case. At first it gives me error on the ssl connection using a web sql but later i transferred it on a mysql server which eventually removes the error perfectly. But then, another error pops up and tells about a improper sql query.

Maybe downgrading the sql server will fix the deprecated query. :hmmmm: then again, a proper installation will surely suffice our need to run and test the server out.

 

[slawdos]

I have other DB for 2.42 azote. Didn't check, no have time...
Link after upload.

You must be registered to see links

epsilon & sigma. 500 mb

 

[walter307]

I have other DB for 2.42 azote. Didn't check, no have time...
Link after upload.

You must be registered to see links

epsilon & sigma. 500 mb

thanks for that slawdos. btw do you, by any chance, have any instructions on how we would set this up? we definitely need those instructions.

 

[slawdos]

sorry, i didn't not.

 

[matheos]

everything works fine for me i will test the news db

 

[walter307]

everything works fine for me i will test the news db

hello matheos. what db platform did you use? can you provide us your steps on how you set it up?

 

[Azzypoo]

Some map data is missing you cant move from the tutorial area, and the tutorial guide isn't working as data for that is also missing (maybe just me?), I wouldn't waste your time on trying to get this setup.

For those of you who still wish to try and are having the SSL issue here's how I fixed it.

open project in VS17

Open - \\Core\Stump.ORM\DatabaseConfiguration.cs

On line 62 change

return string.Format("database={0};uid={1};password={2};server={3};port={4}", DbName, User, Password, Host, Port);

To

return string.Format("database={0};uid={1};password={2};server={3};port={4};SslMode=none", DbName, User, Password, Host, Port);

Rebuild and then launch .bat files

it will force the game to turn SSL off.

 

[chulin]

para los que les queda trabado el personaje el el mapa de inicio
cambien estos valores en la db

/*
Navicat MySQL Data Transfer

Source Server : Dofus
Source Server Version : 50505
Source Host : localhost:3306
Source Database : world

Target Server Type : MYSQL
Target Server Version : 50505
File Encoding : 65001

Date: 2019-01-18 16:20:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for breeds
-- ----------------------------
DROP TABLE IF EXISTS `breeds`;
CREATE TABLE `breeds` (
`Id` int(11) NOT NULL,
`GameplayDescriptionId` int(11) NOT NULL,
`ShortNameId` int(11) NOT NULL,
`LongNameId` int(11) NOT NULL,
`DescriptionId` int(11) NOT NULL,
`MaleLookString` mediumtext NOT NULL,
`FemaleLookString` mediumtext NOT NULL,
`CreatureBonesId` smallint(6) NOT NULL,
`TombBonesId` smallint(6) NOT NULL,
`MaleGhostBonesId` smallint(6) NOT NULL,
`FemaleGhostBonesId` smallint(6) NOT NULL,
`MaleArtwork` int(11) NOT NULL,
`FemaleArtwork` int(11) NOT NULL,
`StatsPointsForStrengthCSV` mediumtext NOT NULL,
`StatsPointsForIntelligenceCSV` mediumtext NOT NULL,
`StatsPointsForChanceCSV` mediumtext NOT NULL,
`StatsPointsForAgilityCSV` mediumtext NOT NULL,
`MaleColorsCSV` mediumtext NOT NULL,
`StatsPointsForVitalityCSV` mediumtext NOT NULL,
`StatsPointsForWisdomCSV` mediumtext NOT NULL,
`BreedSpellsIdCSV` mediumtext NOT NULL,
`FemaleColorsCSV` mediumtext NOT NULL,
`StartMap` int(11) NOT NULL,
`StartCell` smallint(6) NOT NULL,
`StartDirection` int(11) NOT NULL,
`StartActionPoints` int(11) NOT NULL,
`StartMovementPoints` int(11) NOT NULL,
`StartHealthPoint` int(11) NOT NULL,
`StartProspection` int(11) NOT NULL,
`StartStatsPoints` smallint(5) unsigned NOT NULL,
`StartSpellsPoints` smallint(5) unsigned NOT NULL,
`StartStrength` smallint(6) NOT NULL,
`StartVitality` smallint(6) NOT NULL,
`StartWisdom` smallint(6) NOT NULL,
`StartIntelligence` smallint(6) NOT NULL,
`StartChance` smallint(6) NOT NULL,
`StartAgility` smallint(6) NOT NULL,
`StartLevel` smallint(6) NOT NULL,
`StartKamas` int(11) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of breeds
-- ----------------------------
INSERT INTO `breeds` VALUES ('1', '598583', '685', '116103', '305968', '{1|10||135}', '{1|11||125}', '15', '0', '0', '0', '198', '199', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16765564,7098157,15972912,5468254,7098157', '0,1', '0,3', '3,6,2,1,19,4,17,18,9,20,8,11,13,5,12,14,15,16,10,7,1901', '16103775,6833184,13661190,13661190,6963462', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('2', '598597', '697', '116101', '305966', '{1|20||130}', '{1|21||125}', '16', '0', '0', '0', '200', '202', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '15973470,16777166,4836573,2827027,16761904', '0,1', '0,3', '21,22,34,26,28,35,37,38,30,33,40,39,24,23,36,32,25,31,27,29,1902', '16759376,16777164,2726594,2827027,2726594', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('3', '598579', '681', '116105', '305969', '{1|30||120}', '{1|31||95}', '17', '0', '0', '0', '203', '204', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '15973470,16777166,4404257,16767286,10904329', '0,1', '0,3', '51,41,43,49,55,47,48,45,53,57,52,44,50,54,42,56,58,59,46,60,1903', '15384674,15982756,4404257,16777164,11373881', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('4', '598617', '701', '116106', '305965', '{1|40||140}', '{1|41||155}', '18', '0', '0', '0', '205', '206', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '15919294,3101814,3101814,3101814,8748628', '0,1', '0,3', '61,65,72,66,68,63,74,75,79,78,71,62,69,77,73,67,70,64,76,80,1904', '15384674,16777198,4157854,4157854,14872505', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('5', '598627', '705', '706', '305960', '{1|50||110}', '{1|51||110}', '22', '0', '0', '0', '207', '208', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '7957320,6178082,2775654,14523954,4336658', '0,1', '0,3', '83,81,88,93,82,92,97,84,100,98,85,96,90,87,89,86,94,95,91,99,1905', '7957320,16777166,2512998,13945509,2512998', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('6', '598087', '677', '116109', '305963', '{1|60||150}', '{1|61||150}', '34', '0', '0', '0', '209', '210', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16380634,13726012,16735778,2786186,16761904', '0,1', '0,3', '109,103,105,102,113,111,117,119,101,107,116,106,108,104,115,118,110,112,114,120,1906', '16380634,14378769,14568735,13201181,2057046', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('7', '598094', '673', '582016', '305962', '{1|70||110}', '{1|71||115}', '36', '0', '0', '0', '211', '212', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16765564,7360545,14453532,6048816,4734007', '0,1', '0,3', '124,129,122,125,128,126,123,133,130,134,127,131,136,135,132,121,138,137,139,140,1907', '14785337,16707772,16707772,11941144,15388778', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('8', '598592', '693', '694', '305967', '{1|80||140}', '{1|81||140}', '38', '0', '0', '0', '213', '214', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16765564,16355883,16777185,2910064,14561799', '0,1', '0,3', '141,143,142,155,145,154,147,151,158,150,148,144,152,153,149,156,157,160,146,159,1908', '16103775,15430419,16777185,14432786,14432786', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('9', '598088', '689', '116108', '305970', '{1|90||140}', '{1|91||135}', '40', '0', '0', '0', '215', '216', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16762983,14774542,5792768,5845776,16422159', '0,1', '0,3', '161,164,169,163,165,172,167,168,162,170,171,166,173,174,176,175,178,177,179,180,1909', '16761703,14775312,8091904,14053895,6963462', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('10', '598613', '661', '662', '305961', '{1|100||150}', '{1|101||145}', '12', '0', '0', '0', '217', '218', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '8537887,8164099,14402669,14402669,11960892', '0,1', '0,3', '183,186,193,200,195,182,192,197,189,181,199,191,198,196,190,194,185,184,188,187,1910', '8537887,8557826,16114596,16114596,15128478', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('11', '598609', '665', '666', '305964', '{1|110||145}', '{1|111||140}', '13', '0', '0', '0', '219', '220', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16765564,16753434,9809704,5664802,16771138', '0,1', '0,3', '432,431,434,444,449,436,437,438,433,443,440,442,441,445,439,446,447,448,435,450,1911', '16565105,16753434,5992482,6003530,16769340', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('12', '598601', '669', '576693', '305959', '{1|120||160}', '{1|121||145}', '14', '0', '0', '0', '221', '222', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '15457984,5197108,7673110,15457984,4015915', '0,1', '0,3', '686,692,687,689,690,699,688,693,694,695,696,697,698,691,700,701,702,703,704,705,1912', '16380634,4538925,9711889,15457984,9711889', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('13', '598605', '653', '654', '652', '{1|1405||160}', '{1|1407||155}', '1537', '0', '0', '0', '1527', '1528', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '14785337,2567713,2567713,3419419,16777164', '0,1', '0,3', '2794,2808,2778,2795,2763,2796,2801,2802,2803,2807,2797,2806,2805,2809,2804,2810,2811,2812,2813,2815,2817', '14785337,677462,2567713,3419419,3419419', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('14', '598631', '657', '658', '656', '{1|1437||150}', '{1|1438||145}', '1538', '0', '0', '0', '1573', '1574', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16761703,14428465,4863523,1855824,15262931', '0,1', '0,3', '2881,2879,2899,2872,2896,2891,2893,2882,2880,2887,2885,2890,2895,2894,2888,2883,2892,2886,2889,2897,2898', '16761703,14428465,4863523,1855824,15262931', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('15', '601393', '92496', '577202', '112815', '{1|1663||160}', '{1|1664||160}', '1886', '0', '0', '0', '1932', '1933', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16699794,16511423,3417882,16377759,11242064', '0,1', '0,3', '3210,3206,3212,3215,3205,3217,3202,3213,3204,3203,3209,3221,3214,3220,3219,3207,3218,3208,3211,3216,3278', '16699794,16511423,3417882,16377759,11242064', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('16', '598089', '504829', '507144', '504832', '{1|3179||145}', '{1|3180||140}', '3087', '0', '0', '0', '3089', '3090', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '15066084,8036512,10641706,2722985,14207124', '0,1', '0,3', '5383,5359,5361,5382,5370,5381,5389,5371,5372,5368,5386,5397,5388,5367,5390,5391,5400,5401,5402,5403,5485', '15066084,8036512,10641706,2722985,14207124', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('17', '598588', '577229', '577238', '583059', '{1|3285||140}', '{1|3286||135}', '3372', '0', '0', '0', '3374', '3375', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '16378832,16775898,2709077,4492945,15791081', '0,1', '0,3', '5833,5832,5831,5829,5830,5836,5838,5843,6227,5844,5840,6226,5846,5845,6413,5841,5850,5842,5839,6228,6440', '16378832,16775898,2709077,4492945,15791081', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');
INSERT INTO `breeds` VALUES ('18', '715322', '715320', '716113', '715323', '{1|3498||155}', '{1|3499||145}', '3941', '0', '0', '0', '3374', '3375', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '0,1|100,2|200,3|300,4', '6247226,8805673,11300885,3551007,8733459', '0,1', '0,3', '8322,8318,8310,8330,8316,8331,8336,8319,8325,8317,8327,8333,8334,8328,8324,8400,8320,8335,8315,8311,8484', '9795660,14196511,11300885,3551007,13395490', '154010883', '383', '1', '6', '3', '55', '100', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500');