thanks
thanks
anyone have the updated file from the source? or any public repo with updated DB?
Thanks!
.....Originally Posted by ScriptKid
Last edited by michi28; 17-03-21 at 03:46 PM. Reason: ..
Small tool to easy understand the mu_online_game.world_template.flags column
https://mega.nz/file/G7xCACwb#QCzWLU...RNldy3XiOt8Ip0
Yeah, i got it yesterday, My mobs working ok, but cant find how to set 40 spiders in box...@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
Normal attack speed and other.
Anyway i will post db updates later and maybe working NPC
How to solved ?
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'
This is because we have two "development" versions of that table, if you use the original source this is the correct dump:
EDIT: Fixed table with original Source
PHP Code: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;
Last edited by metallica; 15-03-21 at 08:54 PM.
@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
At this moment I'm using the version of @ispyder
https://www.mediafire.com/file/q15gb...41-v9.rar/file
Thanks for let me know I made a dump from my development version instead of the original one. I edited that query
Last edited by Ketchup; 06-04-21 at 02:24 AM. Reason: Rule #27
Someone going another way? I wanna rewrite all to config files, if someone wanna do same, pm me and we can do together.
Long time ago. SS16 Oh my god beautiful
"move" is working now...
Just register valeus in table world_server.
Link for download: https://cdn.discordapp.com/attachmen...rld_server.sql
- - - Updated - - -
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);
year, my bad hahaneed 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);
Reply With Quote
