Znote database - luanluciano93/styller GitHub Wiki

Guild Shop

ALTER TABLE znote_accounts ADD guild_points smallint unsigned NOT NULL DEFAULT '0';

Powergamers

ALTER TABLE znote_players ADD exphist_lastexp bigint NOT NULL DEFAULT '0', ADD exphist1 bigint NOT NULL DEFAULT '0', ADD exphist2 bigint NOT NULL DEFAULT '0', ADD exphist3 bigint NOT NULL DEFAULT '0', ADD exphist4 bigint NOT NULL DEFAULT '0', ADD exphist5 bigint NOT NULL DEFAULT '0', ADD exphist6 bigint NOT NULL DEFAULT '0', ADD exphist7 bigint NOT NULL DEFAULT '0', ADD onlinetimetoday mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetime1 mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetime2 mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetime3 mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetime4 mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetime5 mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetime6 mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetime7 mediumint unsigned NOT NULL DEFAULT '0', ADD onlinetimeall int unsigned NOT NULL DEFAULT '0';

UPDATE znote_players AS z INNER JOIN players AS p ON p.id = z.player_id SET z.exphist_lastexp = p.experience;