7 minutos atrás, vankk disse:

Você tem que pegar o schema.sql para o seu servidor utilizar 0.4 ou 1.x, dependendo da versão, você simplesmente importa a schema.sql na sua database.

 

Se você utilizar 0.4 você pode utilizar a schema do server do @Sekk

https://raw.githubusercontent.com/s3kk/Heromassa/master/schemas/war_cast_mysql.sql

 

Só lembre de limpar as tabelas.

 

*edit

@Sekk

Limpa as tabelas

 

 

 

o meu servidoré 0.4, abri o link que me mandou, devo copia-lo e salvalo como schema.sql e importar la na minha databse ? se não o que devo fazer ?

 

EDIT: CONSEGUI ADICIONAR LA CERTINHO, E AGORA QUAL O PROXIMO PASSO ?

Editado Fevereiro 18, 2016 9 anos por Werner (veja o histórico de edições)

7 minutos atrás, vankk disse:

você simplesmente importa a schema.sql na sua database.

 

 

Acho que isso responde sua pergunta

1 minuto atrás, vankk disse:

 

Acho que isso responde sua pergunta

Consegui, mas não sei se você consegue me ajudar com só mais uma coisa: no STEP 4 aparece isso:

AAC installation is disabled. To enable it make file install.php in main AAC directory and put there your IP.

 

Eu consegui colocar a senha mas o site não abre quando tento abrir acontece isso:

Citar

Query:	SELECT `id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_new_time`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = '1'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 4;
SQLSTATE:	42S22
Driver code:	1054
Error message:	Unknown column 'g.logo_gfx_name' in 'field list'

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\latestnews.php on line 32

 

Query:	SELECT
SQLSTATE:	42000
Driver code:	1064
Error message:	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Query:	SELECT `date` FROM `z_news_tickers` WHERE `hide_ticker` = '0'
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 5;
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM z_featured_article ORDER BY id DESC LIMIT 1
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT `players`.`id`, `players`.`name`, `players`.`world_id`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`rank_id`, `players`.`guildnick`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`direction`, `players`.`loss_experience`, `players`.`loss_mana`, `players`.`loss_skills`, `players`.`loss_containers`, `players`.`loss_items`, `players`.`premend`, `players`.`online`, `players`.`marriage`, `players`.`promotion`, `players`.`deleted`, `players`.`description`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char`, `players`.`signature` FROM `players` WHERE `account_id` = '1' ORDER BY `name` ASC
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT `players`.`name`, `z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`icon_id`, `z_forum`.`post_smile`, `z_forum`.`id`, `z_forum`.`replies`, `z_forum`.`post_date` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`section` = 1 AND `z_forum`.`first_post` = `z_forum`.`id` ORDER BY `z_forum`.`last_post` DESC LIMIT 6
SQLSTATE:	42S22
Driver code:	1054
Error message:	Unknown column 'z_forum.icon_id' in 'field list'

Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\pages\latestnews.php on line 512

 

Leia o erro do install, que você conseguirá.

 AAC installation is disabled. To enable it make file install.php in main AAC directory and put there your IP.

 

E utilize esses comandos no SQL

ALTER TABLE `guilds` ADD `logo_gfx_name` varchar(255) NOT NULL DEFAULT '';

CREATE TABLE IF NOT EXISTS `z_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sticky` tinyint(1) NOT NULL DEFAULT '0',
`closed` tinyint(1) NOT NULL DEFAULT '0',
`first_post` int(11) NOT NULL DEFAULT '0',
`last_post` int(11) NOT NULL DEFAULT '0',
`section` int(3) NOT NULL DEFAULT '0',
`replies` int(20) NOT NULL DEFAULT '0',
`views` int(20) NOT NULL DEFAULT '0',
`author_aid` int(20) NOT NULL DEFAULT '0',
`author_guid` int(20) NOT NULL DEFAULT '0',
`post_text` text NOT NULL,
`post_topic` varchar(255) NOT NULL,
`post_smile` tinyint(1) NOT NULL DEFAULT '0',
`post_date` int(20) NOT NULL DEFAULT '0',
`last_edit_aid` int(20) NOT NULL DEFAULT '0',
`edit_date` int(20) NOT NULL DEFAULT '0',
`post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
PRIMARY KEY (`id`),
KEY `section` (`section`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

1 minuto atrás, vankk disse:

Leia o erro do install, que você conseguirá.

 AAC installation is disabled. To enable it make file install.php in main AAC directory and put there your IP.

 

E utilize esses comandos no SQL

ALTER TABLE `guilds` ADD `logo_gfx_name` varchar(255) NOT NULL DEFAULT '';

CREATE TABLE IF NOT EXISTS `z_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sticky` tinyint(1) NOT NULL DEFAULT '0',
`closed` tinyint(1) NOT NULL DEFAULT '0',
`first_post` int(11) NOT NULL DEFAULT '0',
`last_post` int(11) NOT NULL DEFAULT '0',
`section` int(3) NOT NULL DEFAULT '0',
`replies` int(20) NOT NULL DEFAULT '0',
`views` int(20) NOT NULL DEFAULT '0',
`author_aid` int(20) NOT NULL DEFAULT '0',
`author_guid` int(20) NOT NULL DEFAULT '0',
`post_text` text NOT NULL,
`post_topic` varchar(255) NOT NULL,
`post_smile` tinyint(1) NOT NULL DEFAULT '0',
`post_date` int(20) NOT NULL DEFAULT '0',
`last_edit_aid` int(20) NOT NULL DEFAULT '0',
`edit_date` int(20) NOT NULL DEFAULT '0',
`post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0',
PRIMARY KEY (`id`),
KEY `section` (`section`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

Onde é esse AAC Directory ? "desculpa sou noob d+"