Fixing creation of fresh database and linux build error

[DuelistRag3]

Edited Files:

• 1_auth.sql
• 2_characters.sql
• 2022_01_24_world_fix_trainers.sql
• DBUpdater.h
• NGrid.h

Created Files

• 2022_03_22_00_Update_Characters.sql

Also edited:
Master files for hotfix and world database (not included)

[DuelistRag3]

What i did in the base files basically is moving sql querys to fix foreign key errors and removing the database specification at the top (the config file always determines the used database)

For the Linux Build error: not quiet shure if it will cause bugs, but its a hack fix to enable builds on linux

[DuelistRag3]

Just saw that i actually build in a database specification by myself ^^ will fix that later

[SargeroDeV]

@DuelistRag3 A column of coordinates must always be float, this way it would be fine:
ALTER TABLE characters
ADD COLUMN camp_x float NULL DEFAULT NULL AFTER numRespecs,
ADD COLUMN camp_y float NULL DEFAULT NULL AFTER camp_x,
ADD COLUMN camp_z float NULL DEFAULT NULL AFTER camp_y,
ADD COLUMN camp_o float NULL DEFAULT NULL AFTER camp_z,
ADD COLUMN camp_mapid smallint(5) NULL DEFAULT NULL AFTER camp_o;

[DuelistRag3]

makes totaly sence yes

[SargeroDeV]

But mapid is not a float but an int so it is declared as smallint
ADD COLUMN camp_mapid smallint(5) NULL DEFAULT NULL AFTER camp_o;

[Nexon99]

Tested and working ? Win + Linux ?

[Nexon99]

@DuelistRag3 up

[Thordekk]

Any news on that pr or is abandoned?