Firespider Posted August 16, 2022 Share Posted August 16, 2022 Why is not working? SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */ CREATE TABLE `groupranks` ( `index` int(11) NOT NULL, `groupID` int(11) NOT NULL, `rankID` int(11) NOT NULL DEFAULT '1', `rankName` tinytext, `rankPayment` int(11) DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Indexek a kiírt táblákhoz -- -- -- A tábla indexei `groupranks` -- ALTER TABLE `groupranks` ADD PRIMARY KEY (`index`); -- -- A kiírt táblák AUTO_INCREMENT értéke -- -- -- AUTO_INCREMENT a táblához `groupranks` -- ALTER TABLE `groupranks` MODIFY `index` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; dbExec(connection, "INSERT INTO groupranks (groupID, rankID, rankName, rankPayment) VALUES (?,?,?,?)", groupId, rankId, rankName, rankPayment) table.insert(availableGroups [groupId].ranks, { name = rankName, pay rankPayment Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now