View Single Post
Black Rose
Veteran Member
Join Date: Feb 2011
Location: Stockholm, Sweden
Old 08-18-2023 , 09:46   Re: mysql table flag
Reply With Quote #2

Code:
    len += formatex(sql[len], MAX_QUERY_LENGTH - len, "  `delivered_flag`            BIGINT UNSIGNED     NOT NULL DEFAULT 0,");     len += formatex(sql[len], MAX_QUERY_LENGTH - len, "  `captured_flag`            BIGINT UNSIGNED     NOT NULL DEFAULT 0,");     len += formatex(sql[len], MAX_QUERY_LENGTH - len, "  `returned_flag`            BIGINT UNSIGNED     NOT NULL DEFAULT 0,");
I don't get it, it's basically copy-paste.

You still have to do some things in other parts of the plugin(s) to actually load, increase and save the number though.
If your table already exist you'd have to add the columns to it or recreate it from scratch.

Just as a side note, there's no point of actually using BIGINT UNSIGNED vs. INT (SIGNED) since AMXX doesn't have a data type over 32-bits and there's no way of choosing signed/unsigned.
__________________

Last edited by Black Rose; 09-04-2023 at 14:52.
Black Rose is offline