Evening Everyone, I'm asking for a great help with the problem with ads on the Roleplay OWL server! What do I have to do and what to do in the database?
ERROR: advertisements\advertisements.lua:117: call: failed to call 'mysql:select' [string "?"]
ERROR: advertisements\advertisements.lua:117: bad argument #1 to 'ipairs' (table expected, got boolean)
this ad structure is good to the database is from the OWL gamemode?
CREATE TABLE `advertisements` (
`id` int(11) NOT NULL,
`phone` varchar(10) NOT NULL,
`name` varchar(50) NOT NULL,
`address` varchar(100) NOT NULL,
`advertisement` text NOT NULL,
`start` int(11) NOT NULL,
`expiry` int(11) NOT NULL,
`created_by` int(11) NOT NULL,
`section` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
and please nice can you give me a good ad resource and structure to go on the server!
Thank you for your support!