[8.60] Latest forgottenserver 1.3. Clean downport.

MaR0

Member
Joined
Apr 16, 2018
Messages
258
Reaction score
24
I just downgraded the latest forgottenserver 1.3 and will keep it up to date to master branch.
If you want to submit issue (bugs), do it in github repo, not here.

Repository:
will be there a 8.10 version? or what ever another versions?
 

Mustafa1337

Î Àm ŁĕğẹňĎ
Joined
Mar 4, 2017
Messages
105
Reaction score
20
Location
Egypt
Can someone post a SQL query to add player for this?
I tried this
Code:
INSERT INTO `accounts` (`id`, `name`, `password`, `secret`, `type`, `premdays`, `lastday`, `email`, `creation`) VALUES ('1', '1', '356a192b7913b04c54574d18c28d46e6395428ab', NULL, '3', '365', '0', '', '0');
Code:
INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`) VALUES ('1', 'God', '3', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '136', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', 0x0, '40000', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0');
But I am getting error
Unknown column 'offlinetraining_time' in 'field list'
Unknown column 'offlinetraining_skill' in 'field list'
And also if I added or removed those colum I tried like this
Code:
ALTER TABLE `players` ADD COLUMN `offlinetraining_time` int(10) DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `offlinetraining_skill` int(10) DEFAULT 0;
The groups.xml gets empty
XML:
<?xml version="1.0" encoding="UTF-8"?>
<groups>
</groups>
And when I add groups back, the GM account cannot use like 50% of the commands, I didn't touch or edit the groups.
also I don't have website or anything because I am just doing quick tests while editing my server.
Edit :
Fixed by downloading the updated schema.sql, entering the above queries and editing the account type to "6" although I am using not exist offline training columns but that's just for quick testing.
 
Last edited:

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
79
Reaction score
4
Location
Sweden
Can someone post a SQL query to add player for this?
I tried this
Code:
INSERT INTO `accounts` (`id`, `name`, `password`, `secret`, `type`, `premdays`, `lastday`, `email`, `creation`) VALUES ('1', '1', '356a192b7913b04c54574d18c28d46e6395428ab', NULL, '3', '365', '0', '', '0');
Code:
INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`) VALUES ('1', 'God', '3', '1', '1', '0', '150', '150', '0', '0', '0', '0', '0', '136', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', 0x0, '40000', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '43200', '-1', '2520', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0', '10', '0');
But I am getting error


And also if I added or removed those colum I tried like this
Code:
ALTER TABLE `players` ADD COLUMN `offlinetraining_time` int(10) DEFAULT 0;
ALTER TABLE `players` ADD COLUMN `offlinetraining_skill` int(10) DEFAULT 0;
The groups.xml gets empty
XML:
<?xml version="1.0" encoding="UTF-8"?>
<groups>
</groups>
And when I add groups back, the GM account cannot use like 50% of the commands, I didn't touch or edit the groups.
also I don't have website or anything because I am just doing quick tests while editing my server.
Edit :
Fixed by downloading the updated schema.sql, entering the above queries and editing the account type to "6" although I am using not exist offline training columns but that's just for quick testing.
It's beacuse of alot of the values are not in tfs 1.3 recommend fresh database!

(Worked instead of converting) alot easier!)
 
Top