What's new

Baza Danych

xxxfilipekxxx1

Advanced User
Joined
Jul 1, 2009
Messages
215
Reaction score
5
Age
32
Witam mam problem otoz niechcacy z bazy localhost/phpmyadmin skasowa?em postacie dzieki ktorymi mozna bylo robi? posta? na OTS tzw. druid sorc knight pall , a res charow teraz nie bardzo moge zrobi? ;D pomoze kto? ??
Mozna zrobic jakos te postacie??
 

Szumek

Advanced User
Joined
Feb 26, 2009
Messages
212
Reaction score
20
Odp: Baza Danych

zmien w htdocs/config/config.ini install na "no" i zainstaluj stronke od nowa, bo te postacie tworza sie podczas instalowania stronki, innych postaci nie powinno usun?? w tym momencie, ale na wszelki wypadek mozesz sobie z exportowa? tabele
 

xxxfilipekxxx1

Advanced User
Joined
Jul 1, 2009
Messages
215
Reaction score
5
Age
32
Odp: Baza Danych

Nom thx sa te postacie ale..
Ale jest jeszcze 1 problem nowe konto moge zrobic normalnie ale jak chce sie zalogowac wyskakuje
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forgottenserver.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Account.php(771): OTS_Account->loadBan() #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(156): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 794
oraz
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\highscores.php on line 78

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forgottenserver.bans' doesn't exist' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Account.php(771): OTS_Account->loadBan() #2 C:\xampp\htdocs\highscores.php(93): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(125): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 794

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\guilds.php on line 31

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\guilds.php on line 37
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'forgottenserver.bans' doesn't exist' in C:\xampp\htdocs\bans.php:15 Stack trace: #0 C:\xampp\htdocs\bans.php(15): PDO->query('SELECT `bans`.`...') #1 C:\xampp\htdocs\index.php(107): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\bans.php on line 15
 
Last edited:

Szumek

Advanced User
Joined
Feb 26, 2009
Messages
212
Reaction score
20
Odp: Baza Danych

podaj swoje gg to sproboje ci pomoc.
 

Samik

Advanced User
Joined
Jul 18, 2008
Messages
436
Reaction score
54
Odp: Baza Danych

Wejd? do zak?adki SQL w bazie danych i wpisz to:

PHP:
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans`
(
	`id` INT UNSIGNED NOT NULL auto_increment,
	`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
	`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',
	`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',
	`active` TINYINT(1) NOT NULL DEFAULT TRUE,
	`expires` INT NOT NULL,
	`added` INT UNSIGNED NOT NULL,
	`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
	`comment` TEXT NOT NULL,
	`reason` INT UNSIGNED NOT NULL DEFAULT 0,
	`action` INT UNSIGNED NOT NULL DEFAULT 0,
	`statement` VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (`id`),
	KEY `type` (`type`, `value`),
	KEY `active` (`active`)
) ENGINE = InnoDB;
Powinno pom?c na wszystkie opr?cz tego b??du z guild.php. Wklej ten plik tutaj, prosz?.
 

Myron 27

User
Joined
Jan 8, 2010
Messages
10
Reaction score
0
Odp: Baza Danych

Ja mam problem z godem robieniu w bazie danych wszystko widze ze jest ok ale jak sie loguje to mi nie wchodzi prosze o odpisanie jak cos gg 8183693
 
Top