Recover default player skills [Gesior]

[freddzor11]

When I enter a character at my website I get this error, I use Gesior

 

[Frostie]

When I enter a character at my website I get this error, I use Gesior

Which tfs version ur using and which gesior aac?

 

[freddzor11]

Which tfs version ur using and which gesior aac?

Latest Gesior and 0.3.6

 

[Frostie]

Latest Gesior and 0.3.6

U downloaded the version for 0.3.6?

 

[freddzor11]

U downloaded the version for 0.3.6?

yeah once upon the time, but I have almost changed everything

 

[Frostie]

Drop ur player table in phpadmin and add this one

CREATE TABLE IF NOT EXISTS `players` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`world_id` tinyint(2) unsigned NOT NULL default '0',
`group_id` int(11) NOT NULL default '1',
`account_id` int(11) NOT NULL default '0',
`level` int(11) NOT NULL default '1',
`vocation` int(11) NOT NULL default '0',
`health` int(11) NOT NULL default '150',
`healthmax` int(11) NOT NULL default '150',
`experience` bigint(20) NOT NULL default '0',
`lookbody` int(11) NOT NULL default '0',
`lookfeet` int(11) NOT NULL default '0',
`lookhead` int(11) NOT NULL default '0',
`looklegs` int(11) NOT NULL default '0',
`looktype` int(11) NOT NULL default '136',
`lookaddons` int(11) NOT NULL default '0',
`maglevel` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manamax` int(11) NOT NULL default '0',
`manaspent` int(11) NOT NULL default '0',
`soul` int(10) unsigned NOT NULL default '0',
`town_id` int(11) NOT NULL default '0',
`posx` int(11) NOT NULL default '0',
`posy` int(11) NOT NULL default '0',
`posz` int(11) NOT NULL default '0',
`conditions` blob NOT NULL,
`cap` int(11) NOT NULL default '0',
`sex` int(11) NOT NULL default '0',
`lastlogin` bigint(20) unsigned NOT NULL default '0',
`lastip` int(10) unsigned NOT NULL default '0',
`save` tinyint(1) NOT NULL default '1',
`redskull` tinyint(1) NOT NULL default '0',
`redskulltime` bigint(20) NOT NULL default '0',
`rank_id` int(11) NOT NULL default '0',
`guildnick` varchar(255) NOT NULL default '',
`lastlogout` bigint(20) unsigned NOT NULL default '0',
`blessings` tinyint(2) NOT NULL default '0',
`balance` bigint(20) NOT NULL default '0',
`stamina` bigint(20) NOT NULL default '151200000' COMMENT 'stored in miliseconds',
`direction` int(11) NOT NULL default '2',
`loss_experience` int(11) NOT NULL default '100',
`loss_mana` int(11) NOT NULL default '100',
`loss_skills` int(11) NOT NULL default '100',
`loss_containers` int(11) NOT NULL default '100',
`loss_items` int(11) NOT NULL default '100',
`premend` int(11) NOT NULL default '0' COMMENT 'NOT IN USE BY THE SERVER',
`online` tinyint(1) NOT NULL default '0',
`marriage` int(10) unsigned NOT NULL default '0',
`promotion` int(11) NOT NULL default '0',
`deleted` tinyint(1) NOT NULL default '0',
`description` varchar(255) NOT NULL default '',
`created` int(11) NOT NULL default '0',
`nick_verify` int(5) NOT NULL default '0',
`hide_char` int(11) NOT NULL default '0',
`comment` text NOT NULL,
`exphist_lastexp` bigint(255) NOT NULL default '0',
`exphist1` bigint(255) NOT NULL default '0',
`exphist2` bigint(255) NOT NULL default '0',
`exphist3` bigint(255) NOT NULL default '0',
`exphist4` bigint(255) NOT NULL default '0',
`exphist5` bigint(255) NOT NULL default '0',
`exphist6` bigint(255) NOT NULL default '0',
`exphist7` bigint(255) NOT NULL default '0',
`onlinetimetoday` bigint(255) NOT NULL default '0',
`onlinetime1` bigint(255) NOT NULL default '0',
`onlinetime2` bigint(255) NOT NULL default '0',
`onlinetime3` bigint(255) NOT NULL default '0',
`onlinetime4` bigint(255) NOT NULL default '0',
`onlinetime5` bigint(255) NOT NULL default '0',
`onlinetime6` bigint(255) NOT NULL default '0',
`onlinetime7` bigint(255) NOT NULL default '0',
`onlinetimeall` bigint(255) NOT NULL default '0',
`old_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`deleted`),
KEY `account_id` (`account_id`),
KEY `group_id` (`group_id`),
KEY `online` (`online`),
KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=137 ;/QUOTE]

 

[freddzor11]

Drop ur player table in phpadmin and add this one

didn't worked

 

[Frostie]

Then make all skills of the sample accounts 10 and create an new account and try after it of it worked

 

[freddzor11]

Then make all skills of the sample accounts 10 and create an new account and try after it of it worked

How do I change all sample accounts to skills 10 there is no option when I enter them with skills?

 

[Frostie]

Players* srry said it wrong

 

[freddzor11]

When I use that Query you gaved me even if I have table players, then it gets green, but it doesn't work with website :/

 

[seleo]

try to create a new character and show us the error

 

[freddzor11]

try to create a new character and show us the error

there is no error in console or something just that error at the page

 

[ItWasAllMe]

are you serious? you got the fucking answer in the other thread. You should just install Znote ACC temporarliy and execute his script... you can still keep gesior.

 

[freddzor11]

are you serious? you got the fucking answer in the other thread. You should just install Znote ACC temporarliy and execute his script... you can still keep gesior.

I don't get it to work ZNOTE AAC -.-

 

[Delirium]

Drop ur player table in phpadmin and add this one

Yes, best advice ever. Delete your entire player's table and wipe every character you have on your server. Then re-create the table, with different columns and pray to God that it might match the columns that your server actually needs.

Do you people even think before posting?

 

[freddzor11]

Yes, best advice ever. Delete your entire player's table and wipe every character you have on your server. Then re-create the table, with different columns and pray to God that it might match the columns that your server actually needs.

Do you people even think before posting?

haha, do you know how to fix this then?

 

[Delirium]

haha, do you know how to fix this then?

I am not familiar with OT databases anymore, sorry.

 

[Greypaw]

Do you just want to reset all of the player's skills/levels?

 

[freddzor11]

Do you just want to reset all of the player's skills/levels?

doesn't matter only this error removes