My Source 1711 Fix

[rencro]

Well, thats slightly unfair as the latest peq (at this time) is 1751 and this missing info comes from 1711. Now the assumption is that all the updates prior to 1751 are present in the db when peq_1751, along with load_players gets sourced at creation(newdb), but for whatever reason, part of 1711's is not. Now, what else is missing? Should ALL required sql be sourced? Going how far back?

For me, I modified 1711.sql from

ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

to

ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

sourced it, then went on to source all the "required" from 1752 up to my latests pull, which was 1887...

Actually I copied all the required sql's to be sourced to a new directory, along
with my fixed sql above, then I run this bat file from that new directory:

@echo off
setlocal
set files=*.sql
set output=merged_req.sql
echo. > %output%
for %%A in (%files%) DO call :MERGE %%A %output%
goto end

:MERGE
if '%1'=='%output%' goto EOF
echo -- %1 >> %2
type %1 >> %2
echo. >> %2
goto EOF
:END
:EOF

then I source merged_req.sql but thats OT..