bd no complète
bd no complète
Ikr!Originally Posted by Fur Zi
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.then again, a proper installation will surely suffice our need to run and test the server out.
I have other DB for 2.42 azote. Didn't check, no have time...
Link after upload. https://mega.nz/#!WJsRXK6Z!5UGiO05kd...NpoHd_3TY7cE9g
epsilon & sigma. 500 mb
Last edited by slawdos; 21-06-18 at 11:32 AM.
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.
sorry, i didn't not.
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?
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.
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');
Reply With Quote