• Congratulations to the OTLand January Mapping Competition Winner! The grand prize of Otland Premium goes to Andréew.
  • Sign up for February Mapping Competition! The prize includes Otland Premium time.
  • There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows {HELP} LOGIN SERVER

Sharinganja

New Member
Joined
Feb 4, 2018
Messages
5
Best answers
0
Reaction score
0
I am having trouble getting into ot serv tfs 1.2 if someone can help me thanks!

 

bayview

Banned User
Joined
Jan 25, 2018
Messages
611
Best answers
25
Reaction score
291
Says it right there at the bottom of the console.
Code:
unknown column `prey_stamina_1` in 'field list'
Sorry i don't know the value of prey_stamina_1, wish i could help :(
 

bayview

Banned User
Joined
Jan 25, 2018
Messages
611
Best answers
25
Reaction score
291
I just found this. Save this in data\migrations\25.lua and then restart your server.
Lua:
function onUpdateDatabase()
    print("> Updating database to version 25 (Imbuement and Prey System)")
    db.query("CREATE TABLE IF NOT EXISTS `player_prey` (`player_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `mindex` smallint(6) NOT NULL, `mcolumn` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;")
    db.query("CREATE TABLE IF NOT EXISTS `player_preytimes` (`player_id` int(11) NOT NULL, `bonus_type1` int(11) NOT NULL, `bonus_value1` int(11) NOT NULL, `bonus_name1` varchar(50) NOT NULL, `bonus_type2` int(11) NOT NULL, `bonus_value2` int(11) NOT NULL, `bonus_name2` varchar(50) NOT NULL, `bonus_type3` int(11) NOT NULL, `bonus_value3` int(11) NOT NULL, `bonus_name3` varchar(50) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;")
    db.query("ALTER TABLE `players` ADD COLUMN `prey_stamina_1` int(11) DEFAULT NULL")
    db.query("ALTER TABLE `players` ADD COLUMN `prey_stamina_2` int(11) DEFAULT NULL")
    db.query("ALTER TABLE `players` ADD COLUMN `prey_stamina_3` int(11) DEFAULT NULL")
    db.query("ALTER TABLE `players` ADD COLUMN `prey_column` smallint(6) NOT NULL DEFAULT 1")
    db.query("ALTER TABLE `players` ADD COLUMN `bonus_reroll` int(11) DEFAULT NULL")
    db.query("ALTER TABLE `players` ADD COLUMN `xpboost_stamina` smallint(5) DEFAULT NULL")
    db.query("ALTER TABLE `players` ADD COLUMN `xpboost_value` tinyint(4) DEFAULT NULL")
    return true
end
If you are missing anything else in your database check out this folder and add the missing files.
 
OP
S

Sharinganja

New Member
Joined
Feb 4, 2018
Messages
5
Best answers
0
Reaction score
0
So I would like it to be addons and by vocations in place of items could help me ???
Code:
function onAdvance(cid, skill, oldlevel, newlevel)

               if getPlayerLevel(cid) >= 8 and getPlayerStorageValue(cid, 99963) ~= 1 then
                            doPlayerSetBalance(cid, getPlayerBalance(cid) + 2000)
                            setPlayerStorageValue(cid, 99963, 1)
                            doPlayerSendTextMessage(cid, 19, "You have received 2000 gold in your bank for advancing to Level 8.")

            elseif getPlayerLevel(cid) >= 40 and getPlayerStorageValue(cid, 99964) ~= 1 then
                            doPlayerSetBalance(cid, getPlayerBalance(cid) + 10000)
                            setPlayerStorageValue(cid, 99964, 1)
                            doPlayerSendTextMessage(cid, 19, "You have received 10000 gold in your bank for advancing to Level 40.")

           elseif getPlayerLevel(cid) >= 50 and getPlayerStorageValue(cid, 99965) ~= 1 then
                            doPlayerSetBalance(cid, getPlayerBalance(cid) + 30000)
                            setPlayerStorageValue(cid, 99965, 1)
                            doPlayerSendTextMessage(cid, 19, "You have received 30000 gold in your bank for advancing to Level 50.")

             elseif getPlayerLevel(cid) >= 75 and getPlayerStorageValue(cid, 99966) ~= 1 then
                            doPlayerSetBalance(cid, getPlayerBalance(cid) + 60000)
                            setPlayerStorageValue(cid, 99966, 1)
                            doPlayerSendTextMessage(cid, 19, "You have received 60000 gold in your bank for advancing to Level 75.")
               
                           
            elseif getPlayerLevel(cid) >= 100 and getPlayerStorageValue(cid, 99969) ~= 1 then
                            doPlayerSetBalance(cid, getPlayerBalance(cid) + 100000)
                            setPlayerStorageValue(cid, 99969, 1)
                           doPlayerSendTextMessage(cid, 19, "You have received 10000 gold in your bank for advancing to Level 100.")
                           
                           
           
            elseif getPlayerLevel(cid) >= 150 and getPlayerStorageValue(cid, 99970) ~= 1 then
                            doPlayerAddItem(cid, 5942)
                            setPlayerStorageValue(cid, 99970, 1)
                            doPlayerSendTextMessage(cid, 19, "You have received one blessed wooden stake because you reached level 150.")

                   

elseif getPlayerLevel(cid) >= 200 and getPlayerStorageValue(cid, 99971) ~= 1 then
                            doPlayerAddItem(cid, 2195)
                            setPlayerStorageValue(cid, 99971, 1)
                            doPlayerSendTextMessage(cid, 19, "You have been awarded with 1 boots of haste for reaching level 200.")

                                               
                            end
            return TRUE
end
 
Top