TFS 1.X+ I'm trying to add a VIP system Tfs 1.5

[abdala ragab]

I added this system

VIP System [The Forgotten Server 1.0]

Credits & Stuff Credits go to @Printer for creating the original system (http://otland.net/threads/vip-system-tfs-1-1.224758/) upon which this system is based and which motivated me to work on it. Thanks for that. This version uses a global variable to look up the current vip days of a player...

otland.net

When I try to add

MySQL queries

ALTER TABLE `accounts`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0 AFTER `lastday`,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0 AFTER `lastday`;

I am facing this error

Error
SQL query: Copy


ALTER TABLE `accounts`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0 AFTER `lastday`,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0 AFTER `lastdays`;
MySQL said: Documentation

#1054 - Unknown column 'lastday' in 'accounts'

How do I solve that?

 

[Gesior.pl]

How do I solve that?

On some TFS 1.3 and all 1.4+ there is no lastday column in accounts table.
Use this to add columns to table:

ALTER TABLE `accounts`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0;

These columns will be added at end of table - list of columns -, but it does not matter for OTS. It's just for visualization in phpMyAdmin and other database managers.

 

[abdala ragab]

On some TFS 1.3 and all 1.4+ there is no lastday column in accounts table.
Use this to add columns to table:

ALTER TABLE `accounts`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0;

These columns will be added at end of table - list of columns -, but it does not matter for OTS. It's just for visualization in phpMyAdmin and other database managers.

Error
SQL query: Copy


ALTER TABLE `accounts`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0;
MySQL said: Documentation

#1060 - Duplicate column name 'viplastday'

 

[Gesior.pl]

Error
SQL query: Copy


ALTER TABLE `accounts`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0;
MySQL said: Documentation

#1060 - Duplicate column name 'viplastday'

IDK how, but it somehow added first column, but not second. Or somehow you already had first column in database.
Execute this to add second column:

ALTER TABLE `accounts`
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0;

 

[abdala ragab]

IDK how, but it somehow added first column, but not second. Or somehow you already had first column in database.
Execute this to add second column:

ALTER TABLE `accounts`
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0;

Error​

SQL query: Copy



ALTER TABLE accounts
ADD COLUMN vipdays int(11) NOT NULL DEFAULT 0;



MySQL said:

#1060 - Duplicate column name 'vipdays'

Post automatically merged: Feb 14, 2024

I solved it and this is the solution

    ALTER TABLE `players`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0 AFTER `level`,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0 AFTER `level`;

 

[Evalor]

Error​

SQL query: Copy



ALTER TABLE accounts
ADD COLUMN vipdays int(11) NOT NULL DEFAULT 0;



MySQL said:

#1060 - Duplicate column name 'vipdays'

Post automatically merged: Feb 14, 2024

I solved it and this is the solution

    ALTER TABLE `players`
        ADD COLUMN `viplastday` int(10) NOT NULL DEFAULT 0 AFTER `level`,
        ADD COLUMN `vipdays` int(11) NOT NULL DEFAULT 0 AFTER `level`;

yeah - nullifying the variable is good option, but still there will be a problem cus of using small ints