• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

Windows {HELP} LOGIN SERVER

S

Sharinganja

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

27785201_2047493471933264_1731300382_o.jpg
 
Sort by date Sort by votes
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 :(
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Back
Top