Znote aac tfs 0.4

[Yaboihunna]

getting this error on logout player goes to level 1 with no vocation

[3:36:29.452] Error while saving player: Nature.
[3:36:43.522] mysql_real_query(): SELECT guild_id FROM guild_invites WHERE player_id = 3 - MYSQL ERROR: Table 'otserver.guild_invites' doesn't exist (1146)

 

[tuduras]

add new querry

phpmyadmin-->sql

CREATE TABLE guild_invites
(
player_id INT NOT NULL DEFAULT 0,
guild_id INT NOT NULL DEFAULT 0,
UNIQUE (player_id, guild_id),
FOREIGN KEY (player_id) REFERENCES players(id) ON DELETE CASCADE,
FOREIGN KEY (guild_id) REFERENCES guilds(id) ON DELETE CASCADE
) ENGINE = InnoDB;

 

[Yaboihunna]

guld ranks ? dont have guild ranks table

 

[tuduras]

only znote_ tables? in phpmyadmin?

 

[Yaboihunna]

no i have server tables im just missing the tables in this error
mysql_real_query(): SELECT id FROM guild_ranks WHERE guild_id = 0 AND level = 0 LIMIT 1 - MYSQL ERROR: Table 'otserver.guild_ranks' doesn't exist (1146)

u have query to add those?

 

[tuduras]

up@


CREATE TABLE IF NOT EXISTS guild_ranks (
id int(11) NOT NULL AUTO_INCREMENT,
guild_id int(11) NOT NULL COMMENT 'guild',
name varchar(255) NOT NULL COMMENT 'rank name',
level int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
PRIMARY KEY (id),
FOREIGN KEY (guild_id) REFERENCES guilds (id) ON DELETE CASCADE
) ENGINE=InnoDB;

 

[Yaboihunna]

can u check my website to see if it is online?
venore-war.servegame.com

how can i add my custom client to the downloads tab of website?

 

[tuduras]

venore-war.servegame.com doesn't work

Custom client > znote/www/config.php

Ctrl+F , download link (590line ~~
replace actual exsisting url