• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

TFS 1.X+ mysql query.

Decrik

*Poland bro*
Joined
Feb 27, 2012
Messages
487
Reaction score
60
Location
Poland.
Hi guys. I have a little problem with this i don't know what i need to do.
Imgur <<<<<<<<<
Can someone explain me this?
 
Solution
Hi guys. I have a little problem with this i don't know what i need to do.
Imgur <<<<<<<<<
Can someone explain me this?

you no have a table called z_ots_guildcomunication


Edit, create it:

Lua:
CREATE TABLE IF NOT EXISTS `z_ots_guildcomunication`
(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `type` varchar(255) NOT NULL,
    `action` varchar(255) NOT NULL,
    `param1` varchar(255) NOT NULL,
    `param2` varchar(255) NOT NULL,
    `param3` varchar(255) NOT NULL,
    `param4` varchar(255) NOT NULL,
    `param5` varchar(255) NOT NULL,
    `param6` varchar(255) NOT NULL,
    `param7` varchar(255) NOT NULL,
    `delete_it` int(2) NOT NULL DEFAULT '1',
     PRIMARY KEY (`id`)
)...
Hi guys. I have a little problem with this i don't know what i need to do.
Imgur <<<<<<<<<
Can someone explain me this?

you no have a table called z_ots_guildcomunication


Edit, create it:

Lua:
CREATE TABLE IF NOT EXISTS `z_ots_guildcomunication`
(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `type` varchar(255) NOT NULL,
    `action` varchar(255) NOT NULL,
    `param1` varchar(255) NOT NULL,
    `param2` varchar(255) NOT NULL,
    `param3` varchar(255) NOT NULL,
    `param4` varchar(255) NOT NULL,
    `param5` varchar(255) NOT NULL,
    `param6` varchar(255) NOT NULL,
    `param7` varchar(255) NOT NULL,
    `delete_it` int(2) NOT NULL DEFAULT '1',
     PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13107;
 
Solution
open phpmyadmin in Browser ->check database name -> SQL query (top site) -> in writable place : paste upon code and click "go"
 
Back
Top