ALTER TABLE "accounts" ADD "vipdays" INTEGER NOT NULL DEFAULT 0
thanks i fixed all of this but i can fix that and when any character login the server doesn't say1. Go to data/globalevents/globalevents.xml and remove the line with type globalsave.
2. You can use strftime('%s', 'now') instead of UNIX_TIMESTAMP()
https://www.sqlite.org/lang_datefunc.html
For the guild_wars table:
https://otland.net/threads/tfs-0-3-6-to-0-4-some-bugs-needed-to-be-fixed.225269/page-2#post-2185017
3. I assume you use this.
https://otland.net/threads/the-best-vip-system-ever-action-movevent-globalevent.71638/
So run this query.
Code:ALTER TABLE "accounts" ADD "vipdays" INTEGER NOT NULL DEFAULT 0