thanks
Printable View
thanks
anyone have the updated file from the source? or any public repo with updated DB?
Thanks!
Small tool to easy understand the mu_online_game.world_template.flags column
https://mega.nz/file/G7xCACwb#QCzWLU...RNldy3XiOt8Ip0
https://i.ibb.co/0ySNQNG/legend.png
How to solved ?
Quote:
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;
@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
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);
https://i.imgur.com/mfP1j9l.jpg
https://i.imgur.com/ktxzK6q.jpg