Windows {HELP} LOGIN SERVER

[Sharinganja]

I am having trouble getting into ot serv tfs 1.2 if someone can help me thanks!

 

[bayview]

Says it right there at the bottom of the console.

unknown column `prey_stamina_1` in 'field list'

Sorry i don't know the value of prey_stamina_1, wish i could help

 

[bayview]

I just found this. Save this in data\migrations\25.lua and then restart your server.

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.

 

[Sharinganja]

thank u very much

 

[Sharinganja]

So I would like it to be addons and by vocations in place of items could help me ???

​

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