- Joined
- Jun 21, 2009
- Messages
- 5
- Reaction score
- 0
thanks
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
anyone have the updated file from the source? or any public repo with updated DB?
Thanks!
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
2021-03-15_11:37:11 ERROR In mysql_stmt_prepare() id: 10, sql: "INSERT INTO quest_mu (`ID`, `Name`, `Server`, `Day`, `TemplateType1`, `Chapter`, `Category`, `Importance`, `StartType`, `StartSubType`, `LevelMin`, `LevelMax`, `RepeatCycle`, `PrecedenceQuest`, `StartItemType`, `StartItemIndex`, `CheckGens`, `Zen`, `DarkWizard`, `DarkKnight`, `FairyElf`, `MagicGladiator`, `DarkLord`, `Summoner`, `RageFighter`, `GrowLancer`, `RuneWizard`, `Slayer`, `GunCrusher`, `AddClass1`, `TemplateType2`, `ObjectiveType`, `ObjectiveMainType`, `ObjectiveMainSubType`, `TargetNumber`, `TargetMaxLevel`, `DropRate`, `GateID`, `MapID`, `X`, `Y`, `RewardExperience`, `RewardZen`, `RewardGensPoints`, `RewardItemType01`, `RewardItemIndex01`, `RewardItemCount01`, `RewardItemType02`, `RewardItemIndex02`, `RewardItemCount02`, `RewardItemType03`, `RewardItemIndex03`, `RewardItemCount03`, `RewardType`, `RewardSubType`, `RewardNumber`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-15_11:37:11 ERROR Unknown column 'TemplateType1' in 'field list'
How to solved ?
DROP TABLE IF EXISTS `quest_mu`;
CREATE TABLE IF NOT EXISTS `quest_mu` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(255) DEFAULT NULL,
`server` smallint(5) UNSIGNED DEFAULT NULL,
`day` tinyint(3) UNSIGNED DEFAULT NULL,
`TemplateType1` tinyint(3) UNSIGNED DEFAULT NULL,
`chapter` tinyint(3) UNSIGNED DEFAULT NULL,
`category` tinyint(3) UNSIGNED DEFAULT NULL,
`importance` tinyint(3) UNSIGNED DEFAULT NULL,
`StartType` tinyint(3) UNSIGNED DEFAULT NULL,
`StartSubType` smallint(5) UNSIGNED DEFAULT NULL,
`LevelMin` smallint(5) UNSIGNED DEFAULT NULL,
`LevelMax` smallint(5) UNSIGNED DEFAULT NULL,
`RepeatCycle` tinyint(4) DEFAULT NULL,
`PrecedenceQuest` smallint(6) DEFAULT NULL,
`StartItemType` tinyint(4) DEFAULT NULL,
`StartItemIndex` smallint(6) DEFAULT NULL,
`CheckGens` tinyint(4) DEFAULT NULL,
`zen` int(11) DEFAULT NULL,
`DarkWizard` tinyint(3) UNSIGNED DEFAULT NULL,
`DarkKnight` tinyint(3) UNSIGNED DEFAULT NULL,
`FairyElf` tinyint(3) UNSIGNED DEFAULT NULL,
`MagicGladiator` tinyint(3) UNSIGNED DEFAULT NULL,
`DarkLord` tinyint(3) UNSIGNED DEFAULT NULL,
`Summoner` tinyint(3) UNSIGNED DEFAULT NULL,
`RageFighter` tinyint(3) UNSIGNED DEFAULT NULL,
`GrowLancer` tinyint(3) UNSIGNED DEFAULT NULL,
`RuneWizard` tinyint(3) UNSIGNED DEFAULT NULL,
`Slayer` tinyint(3) UNSIGNED DEFAULT NULL,
`GunCrusher` tinyint(3) UNSIGNED DEFAULT NULL,
`AddClass1` tinyint(3) UNSIGNED DEFAULT NULL,
`TemplateType2` tinyint(3) UNSIGNED DEFAULT NULL,
`ObjectiveType` tinyint(3) UNSIGNED DEFAULT NULL,
`ObjectiveMainType` smallint(6) DEFAULT NULL,
`ObjectiveMainSubType` smallint(6) DEFAULT NULL,
`TargetNumber` smallint(6) DEFAULT NULL,
`TargetMaxLevel` smallint(6) DEFAULT NULL,
`DropRate` smallint(6) DEFAULT NULL,
`GateID` smallint(5) UNSIGNED DEFAULT NULL,
`MapID` smallint(5) UNSIGNED DEFAULT NULL,
`x` smallint(6) DEFAULT NULL,
`y` smallint(6) DEFAULT NULL,
`RewardExperience` int(11) DEFAULT NULL,
`RewardZen` int(11) DEFAULT NULL,
`RewardGensPoints` tinyint(3) UNSIGNED DEFAULT NULL,
`RewardItemType01` tinyint(4) DEFAULT NULL,
`RewardItemIndex01` smallint(6) DEFAULT NULL,
`RewardItemCount01` smallint(6) DEFAULT NULL,
`RewardItemType02` tinyint(4) DEFAULT NULL,
`RewardItemIndex02` smallint(6) DEFAULT NULL,
`RewardItemCount02` smallint(6) DEFAULT NULL,
`RewardItemType03` tinyint(4) DEFAULT NULL,
`RewardItemIndex03` smallint(6) DEFAULT NULL,
`RewardItemCount03` smallint(6) DEFAULT NULL,
`RewardType` smallint(6) DEFAULT NULL,
`RewardSubType` smallint(6) DEFAULT NULL,
`RewardNumber` smallint(6) DEFAULT NULL,
`disabled` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
This is because we have two "development" versions of that table, if you use the original source this is the correct dump:
metallica Could you share the most updated db please thank you
check the last prepareStmt
https://github.com/DimensionGamers/Lgd-Server/blob/main/Common/GameServerDatabase.cpp
minimap table is correct?
has how to turn off the / auth system?
"move" is working now...
Just register valeus in table world_server.
Link for download: https://cdn.discordapp.com/attachme...8988791078912/database_login_world_server.sql
just set value 0 in column secured in table accounts
need add more map 0 to 30.
from maps lorencia, noria, davias, etc...
VALUES (0,0),(0,1),(0,2),(0,3),(0,4),(0,5),(0,6),(0,7),(0,8),(0,9),(0,10),(0,11),(0,12),(0,13),(0,14),(0,15),(0,16),(0,17),(0,18),(0,19),(0,20),(0,21),(0,22),(0,23),(0,24),(0,25),(0,26),(0,27),(0,28),(0,29),(0,30),(0,31),(0,32),(0,33),(0,34),(0,35),(0,36),(0,37),(0,38),(0,39),(0,40),(0,41),(0,42),(0,43),(0,44),(0,45),(0,46),(0,47),(0,48),(0,49),(0,50),(0,51),(0,52),(0,53),(0,54),(0,55),(0,56),(0,57),(0,58),(0,59),(0,60),(0,61),(0,62),(0,63),(0,64),(0,65),(0,66),(0,67),(0,68),(0,69),(0,70),(0,71),(0,72),(0,73),(0,74),(0,75),(0,76),(0,77),(0,78),(0,79),(0,80),(0,81),(0,82),(0,83),(0,84),(0,85),(0,86),(0,87),(0,88),(0,89),(0,90),(0,91),(0,92),(0,93),(0,94),(0,95),(0,96),(0,97),(0,98),(0,99),(0,100),(0,101),(0,102),(0,103),(0,104),(0,105),(0,106),(0,107),(0,108),(0,109),(0,110),(0,111),(0,112),(0,113),(0,114),(0,115),(0,116),(0,117),(0,118),(0,119),(0,120),(0,121),(0,122),(0,123),(0,124),(0,125),(0,126),(0,127),(0,128),(0,129),(0,130),(0,131),(0,132),(0,133),(0,134),(0,135),(0,136),(0,137),(0,138),(0,139),(0,140),(0,141),(0,142),(0,143),(0,144),(0,145),(0,146),(0,147),(0,148),(0,149);
Source + Boost + Files + DB -> Link: https://drive.google.com/file/d/1npzaTksgRGQGhQ8ASY8oMPx5zLBUj2Fk/view
Client Source , use vs2013 same boost: https://drive.google.com/file/d/13ytdc2wDmYCLkOb77JeFBsdfhbvoqqNz/view
I think mysql better than ini or txt files.I humbly prefer to stick with config as it is by default, although mysql adds a layer of complexity, and some users will have to read about mysql it also offers many benefits over plain txt, xml or whatever.
Also, if someone decide to go in that direction the source must be updated to handle extraordinary cases such as duplicate ids, etc. (data integrity)
I'm not a fan of mysql but thank goodness it's not mssql either! On the other hand, this configuration offers certain characteristics and it is good to consider them, such as tables with descriptive names, exact columns numbers with exact TYPES and descriptive name, others
(The only really important thing here is the type haha) . The era of 1 invalid typo and the server crash ends at least in the not so distant future when all pk, fk, indexes, etc. are correctly defined.
There are some users who are doing a monumental job in this regard.
Maybe, someday, someone will release client sourcesI think that last days we progress alot, some guys are working on spots, another on skills, others in NPC/items, anothers trying to start to begining from 0 zero that is also good too!
Personally I'm happy because I could have running vs2013 and now I can compile the source, that for me is a great step for debugging
So I know that is not easy the DB, and I know that are plenty of good coders and developers that was working for years and prefer having all on config files because dont wanna to start from 0, I strongly understand their "frustation" but in another hand if we are going to that direction (at least at this moment) we need to rework all the files, I think that this could be a MOD in a near future when we have a 99% server running and working with all features....anyway if some of you wanna to go with that direction is ok too!, the reason of the Discord is talk also each other to explore all the Alternatives.
Also we need a web. we need maybe some tools etc....there is a lot of work to do xD