Solved Cannot create guilds or houses!

[Zaggyzigzig]

Cannot create guilds
cannot create houses! cant find file tried allot of different locations! including the one in the world file..
Using Nicaww acc and avesta 7.6 and is is possible to create a guild master in game with an sql server? Or create a !createguild command?

 

[Ignazio]

ALTER TABLE `guilds` ADD `motd` VARCHAR (255) NULL DEFAULT NULL;

Are you sure you wrote in the correct path to houses.xml in your config file?

Ignazio

 

[Zaggyzigzig]

how do i correctly wright it in?

ALTER TABLE `guilds` ADD `motd` VARCHAR (255) NULL DEFAULT NULL;

Are you sure you wrote in the correct path to houses.xml in your config file?

Ignazio

Guilds work now,



but players cannot join it says
string(73) "SELECT `player_id`, `guild_id` FROM `guild_invites` WHERE `guild_id`='1';"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'yahoo.guild_invites' doesn't exist

 

[Zaggyzigzig]

and for the houses how do i correctly wright the paths? do i put xml at the end? and when i do it dose no work i have tried everything

LINUX users: Make sure www-data have read access to file.
WINDOWS users: Learn to write correct file path.
I have windows!

 

[Ignazio]

Isn't there a line in the config file where you assign the path to your house.xml? What AAC are you using?

CREATE TABLE IF NOT EXISTS `guild_invites` (
  `player_id` int(11) NOT NULL,
  `guild_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Ignazio

 

[Zaggyzigzig]

I think its Z-note and will try that Create table when I get home, thanks really appreciate your help, I have been playing/hosting ots since 2004

Just wondering is there a place to find all of the nessasary inserts like this create table? really appreciate the help guys

 

[Limos]

If you are missing a table you can type CREATE TABLE `name` in search to find the querys to create the table or you can also look in sql files from servers if they are default tables that are used on alot of servers.
You can also type the error in search if you're not sure what kind of query it will be.

 

[Zaggyzigzig]

Thanks will try all this when I am done work, If I knew how to rep++ you guys I would! lmao!

 

[Zaggyzigzig]

Now i get this problem, what do i write for guildwars?

CREATE TABLE IF NOT EXISTS `guild_wars` (
`player_id` int(11) NOT NULL,
`guild_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Tried making my own but this did nothing? What do I do?

It says

string(133) "SELECT `id`, `guild1`, `guild2`, `name1`, `name2`, `status`, `started`, `ended` FROM `guild_wars` ORDER BY `started` DESC LIMIT 0, 30"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'yahoo.guild_wars' doesn't exist

Just like in the picture above!

 

[Zaggyzigzig]

CREATE TABLE IF NOT EXISTS `guild_wars` (
`id` int(11) NOT NULL,
`guild1` int(11) NOT NULL
`guild2` int(11) NOT NULL
`name1` int(11) NOT NULL
`name2` int(11) NOT NULL
`status` int(11) NOT NULL
`started` int(11) NOT NULL
`ended` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


tried this its still not working ;< really would appreciate some help! Where do I learn to script this way? I'm use to old xml scripting not this sql stuff!

 

[Ignazio]

Usually you get these tables with the AAC or the OT, you might have an older OT than the AAC, or just not perfectly compatible.

The hard issue is to know the data type of the columns, I simply guess, guess accurately I suppose. Some are IDs and therefor ints, some are strings which become (most usually, if they are short) varchar, 255. Some are datetime and some are bigger texts. Some are booleans (true or false, tinyint) and some are blobs (images). I'm guessing the guild1 and 2 are ids to connect them to existing guilds, where as the names (characters or guild names) are strings, thus varchar. Started and ended might be unix timestamps or datetime, I'm guessing datetime.

Try this

DROP TABLE IF EXISTS `guild_wars`;
CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` int(11) NOT NULL,
  `guild1` int(11) NOT NULL,
  `guild2` int(11) NOT NULL,
  `name1` varchar(255) DEFAULT NULL,
  `name2` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `started` datetime NOT NULL,
  `ended` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[Zaggyzigzig]

Usually you get these tables with the AAC or the OT, you might have an older OT than the AAC, or just not perfectly compatible.

The hard issue is to know the data type of the columns, I simply guess, guess accurately I suppose. Some are IDs and therefor ints, some are strings which become (most usually, if they are short) varchar, 255. Some are datetime and some are bigger texts. Some are booleans (true or false, tinyint) and some are blobs (images). I'm guessing the guild1 and 2 are ids to connect them to existing guilds, where as the names (characters or guild names) are strings, thus varchar. Started and ended might be unix timestamps or datetime, I'm guessing datetime.

Try this

DROP TABLE IF EXISTS `guild_wars`;
CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` int(11) NOT NULL,
  `guild1` int(11) NOT NULL,
  `guild2` int(11) NOT NULL,
  `name1` varchar(255) DEFAULT NULL,
  `name2` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `started` datetime NOT NULL,
  `ended` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Worked! One step closer to having a perfect webpage for my server!