What's new

TFS 0.3.5 B??d przy save playera

Status
Not open for further replies.

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Witam gdy zalogowywuje si? na chara (patrz screen poni?ej) jest ok, lecz gdy chce wylogowa? to pisze error save i mi nie zapisa? go...Pomo?e kto?? Oczywi?cie reput :)



Edit

Aj przepraszam zapomnia?em dac screena

errorl.png
 

Backy

User
Joined
Feb 23, 2009
Messages
33
Reaction score
2
Odp: TFS 0.3.5 B??d przy save playera

Jak wnioskuje z tych error'?w twoja posta? jest w gildi.
Nie posiadasz r?wnie? tabel z gildiami, dodaj to do bazy.
Code:
CREATE TABLE IF NOT EXISTS `guild_ranks` (
  `id` int(11) NOT NULL auto_increment,
  `guild_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `level` int(11) NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
  PRIMARY KEY  (`id`),
  KEY `guild_id` (`guild_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
Code:
CREATE TABLE IF NOT EXISTS `guild_invites` (
  `player_id` int(11) NOT NULL default '0',
  `guild_id` int(11) NOT NULL default '0',
  UNIQUE KEY `player_id` (`player_id`,`guild_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
By? mo?e jak to nie pomo?e to trzeba b?dzie jeszcze dorzuci? tabele guilds.
Ale zobaczymy spr?buj tego.
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

Tez tak podejrzewalem ale moja postac nie jest w gildii tak jest na kazdej postaci ale jeszcze pytanko (i tak masz reputa)...jak dodac to do bazy?
 

ReDe

Active User
Joined
May 28, 2008
Messages
68
Reaction score
12
Odp: TFS 0.3.5 B??d przy save playera

localhost/phpmyadmin
logujesz na roota --> wchodzisz do bazy danych serwa i u g?ry masz zak?adke SQL nacikasz na ni? wpisujesz to co napisa? kolega i zatwierdzasz i potem powr?t i wsio ;D
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

Panowie dzi?ki bardzo tibia.net.pl rz?dzi zawsze pomo?e jeszcze raz dzi?ki :D
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

od?wie?am

Daj? itemki do domku przyk?adowo club. Robi? save wy??czam silnik potem w??czam a itemk?w nie ma :( Pomo?e kto?? Wyskakuj? przy save errory co? tam pisze o tabeli house Backy mo?e da?by? mi co? podobnego co mi wcze?niej da?e??


errorhouse.png
 

Backy

User
Joined
Feb 23, 2009
Messages
33
Reaction score
2
Odp: TFS 0.3.5 B??d przy save playera

Prosz? bardzo

Code:
CREATE TABLE IF NOT EXISTS `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `listid` int(11) NOT NULL,
  `list` text NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

oraz

Code:
CREATE TABLE IF NOT EXISTS `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL default '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
  KEY `sid` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
Last edited:

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

Ok dzi?ki ale nadal nie dzia?a :( To samo tylko, ?e teraz prosi o tabelk? theforgottenserver.tiles m?g?by? mi te? j? przes?a? w postaci tego co wy?ej?



EDIT

Albo mi si? wydaje, albo ja nie mam p?? bazy danych...
 

Backy

User
Joined
Feb 23, 2009
Messages
33
Reaction score
2
Odp: TFS 0.3.5 B??d przy save playera

Tiles
Code:
CREATE TABLE IF NOT EXISTS `tiles` (
  `id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `x` int(5) unsigned NOT NULL,
  `y` int(5) unsigned NOT NULL,
  `z` tinyint(2) unsigned NOT NULL,
  UNIQUE KEY `id` (`id`,`world_id`),
  KEY `x` (`x`,`y`,`z`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

Dzi?ki ale jeszcze s? jakie? errory...


errortabela.png
 

Drassil

Active User
Joined
Jun 18, 2008
Messages
91
Reaction score
0
Odp: TFS 0.3.5 B??d przy save playera

W ogole wrzuciles schema.mysql do bazy?



CREATE TABLE IF NOT EXISTS `tiles` (
`id` int(10) unsigned NOT NULL,
`world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
`x` int(5) unsigned NOT NULL,
`y` int(5) unsigned NOT NULL,
`z` tinyint(2) unsigned NOT NULL,
UNIQUE KEY `id` (`id`,`world_id`),
KEY `x` (`x`,`y`,`z`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

Wrzuci?em schema.mysql to co mi da?e? te? wrzuci?em ale nie dzia?a :( ci?gle teraz prosi o world_id i house_id
 

Drassil

Active User
Joined
Jun 18, 2008
Messages
91
Reaction score
0
Odp: TFS 0.3.5 B??d przy save playera

Masz house_data w bazie?
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

Tak mam house_data w bazie.

Notka moderatorska:
U?ywaj opcji Edytuj //Ognisty
 
Last edited by a moderator:

Backy

User
Joined
Feb 23, 2009
Messages
33
Reaction score
2
Odp: TFS 0.3.5 B??d przy save playera

trzymaj kolejne:
Code:
CREATE TABLE IF NOT EXISTS `house_lists` (
  `house_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL default '0',
  `listid` int(11) NOT NULL,
  `list` text NOT NULL,
  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

trzymam...ale nie dziala to samo :( Mam tego dosc
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: TFS 0.3.5 B??d przy save playera

odswie?am

To pomo?esz mi Backy albo Drassil albo kto? inny?
 
Status
Not open for further replies.
Top