• 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!

RevScripts Error distro Query and Colune

VitorElias12

New Member
Joined
Jul 30, 2017
Messages
17
Reaction score
1
Hello good night I'm having a problem when the player logs into the otserver this error in the distro probably need to add a query in the database but I don't know which code to put in the database

1598398994288.png


I don't know if I'm in the right area to ask for help the first time using this forum anything can move to the correct area
thank you.
 
TFS version? Client version? This error related to prey system, Do you have prey system in your server?
Anyways this is the query to fix it
SQL:
CREATE TABLE `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=utf8;
 
TFS version? Client version? This error related to prey system, Do you have prey system in your server?

OTX
The OTX Server Global - Version: (3.10)
Compiled with: Microsoft Visual C++ version 14.0
Versão Version Cliente 10 and 11:90


yes I have this system but this is giving this error in the distro I'm sorry there I'm kind of lost I'm from Brazil I can't handle the forum kkk
 
I updated my reply, Just insert the query to your database and it should work.
 
Solution
TFS version? Client version? This error related to prey system, Do you have prey system in your server?
Anyways this is the query to fix it
SQL:
CREATE TABLE `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=utf8;

thank you very much it worked
 
Back
Top