need help DB

[barakuda21]

im not sure where i get rong? this is DB i try to make any one can help

ts2_db

 Spoiler

-- phpMyAdmin SQL Dump
-- version 4.9.2
--
--
-- Host: 127.0.0.1
-- Generation Time: Jan 25, 2020 at 10:17 AM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ts2_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `avatarinfo`
--

CREATE TABLE `avatarinfo` (
`aInsertTime` datetime DEFAULT NULL,
`uID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`aVisibleState` int(11) DEFAULT 1,
`aSpecialState` int(11) DEFAULT 0,
`aPlayTime1` int(11) DEFAULT 0,
`aPlayTime2` int(11) DEFAULT 0,
`aKillOtherTribe` int(11) DEFAULT 0,
`aName` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
`aTribe` int(11) DEFAULT 0,
`aPreviousTribe` int(11) DEFAULT 0,
`aGender` int(11) DEFAULT 0,
`aHeadType` int(11) DEFAULT 0,
`aFaceType` int(11) DEFAULT 0,
`aLevel1` int(11) DEFAULT 1,
`aLevel2` int(11) DEFAULT 0,
`aGeneralExperience1` int(11) DEFAULT 0,
`aGeneralExperience2` int(11) DEFAULT 0,
`aVit` int(11) DEFAULT 1,
`aStr` int(11) DEFAULT 1,
`aInt` int(11) DEFAULT 1,
`aDex` int(11) DEFAULT 1,
`aEquip` varchar(325) COLLATE utf8_unicode_ci DEFAULT '',
`aLogoutInfo01` int(11) DEFAULT 0,
`aLogoutInfo02` int(11) DEFAULT 0,
`aLogoutInfo03` int(11) DEFAULT 0,
`aLogoutInfo04` int(11) DEFAULT 0,
`aLogoutInfo05` int(11) DEFAULT 0,
`aLogoutInfo06` int(11) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bonusinfo`
--

CREATE TABLE `bonusinfo` (
`uID` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`aName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`aLevel` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `definemaxusernum`
--

CREATE TABLE `definemaxusernum` (
`mMaxUserNum` int(11) DEFAULT NULL,
`mAddPlayerNum` int(11) DEFAULT NULL,
`mGageUserNum` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `definemaxusernum`
--

INSERT INTO `definemaxusernum` (`mMaxUserNum`, `mAddPlayerNum`, `mGageUserNum`) VALUES
(1000, 1, 50);

-- --------------------------------------------------------

--
-- Table structure for table `guildeventinfo`
--

CREATE TABLE `guildeventinfo` (
`gName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`Gscore` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `masterinfo`
--

CREATE TABLE `masterinfo` (
`uLoginState` int(1) DEFAULT 0,
`uIP` varchar(15) COLLATE utf8_unicode_ci DEFAULT '',
`uID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`uSaveMoney` int(11) NOT NULL DEFAULT 0,
`uSaveMoney2` int(11) NOT NULL DEFAULT 0,
`uSaveItem` varchar(700) COLLATE utf8_unicode_ci DEFAULT '',
`aName01` varchar(12) COLLATE utf8_unicode_ci DEFAULT '',
`aName02` varchar(12) COLLATE utf8_unicode_ci DEFAULT '',
`aName03` varchar(12) COLLATE utf8_unicode_ci DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `masterinfo`
--

INSERT INTO `masterinfo` (`uLoginState`, `uIP`, `uID`, `uSaveMoney`, `uSaveMoney2`, `uSaveItem`, `aName01`, `aName02`, `aName03`) VALUES
(0, '127.0.0.1', 'test1', 0, 0, '0000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `memberinfo`
--

CREATE TABLE `memberinfo` (
`uID` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`uPassword` varchar(30) COLLATE utf8_unicode_ci DEFAULT '',
`uMousePassword` varchar(4) COLLATE utf8_unicode_ci DEFAULT '',
`uBlockInfo` int(11) DEFAULT 0,
`uUserSort` int(1) DEFAULT 0,
`uTraceState` int(1) DEFAULT 0,
`uCash` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `memberinfo`
--

INSERT INTO `memberinfo` (`uID`, `uPassword`, `uMousePassword`, `uBlockInfo`, `uUserSort`, `uTraceState`, `uCash`) VALUES
('test1', '1234', '0000', 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `rank`
--

CREATE TABLE `rank` (
`uUpdateTime` date NOT NULL,
`uID` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`aName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`aTribe` int(11) NOT NULL,
`aLevel` int(11) NOT NULL,
`aGeneralExperience` int(11) NOT NULL,
`aGuildName` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`aKillOtherTribe` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `worldinfo`
--

CREATE TABLE `worldinfo` (
`mZone38WinTribeDate` datetime NOT NULL,
`nZone38WinTribe` int(11) NOT NULL,
`mTribe1SymbolDate` datetime NOT NULL,
`mTribe1Symbol` int(11) NOT NULL,
`mTribe2SymbolDate` datetime NOT NULL,
`mTribe2Symbol` int(11) NOT NULL,
`mTribe3SymbolDate` datetime NOT NULL,
`mTribe3Symbol` int(11) NOT NULL,
`mMonsterSymbolDate` datetime NOT NULL,
`mMonsterSymbol` int(11) NOT NULL,
`mTribe1Point` int(11) NOT NULL,
`mTribe2Point` int(11) NOT NULL,
`mTribe3Point` int(11) NOT NULL,
`mCloseTime` int(11) NOT NULL,
`mCloseTribe` int(11) NOT NULL,
`mFormationCount` varchar(96) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mGetStoneCount` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mLostStoneCount` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mYongokCount` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe01Master` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe01SubMaster` varchar(144) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe2Master` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe2SubMaster` varchar(144) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe3Master` varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mTribe3SubMaster` varchar(144) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`tNotice01` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`tNotice02` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`tNotoce03` varchar(2000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `avatarinfo`
--
ALTER TABLE `avatarinfo`
ADD PRIMARY KEY (`aName`);

--
-- Indexes for table `masterinfo`
--
ALTER TABLE `masterinfo`
ADD PRIMARY KEY (`uID`);

--
-- Indexes for table `memberinfo`
--
ALTER TABLE `memberinfo`
ADD PRIMARY KEY (`uID`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT @CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS @CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION @COLLATION_CONNECTION */;

i still cant fix this param of each server.exe ( im still noob ^_^ )

[AmazingFord]

discord ?

[barakuda21]

i dont have discord!
while search i found this and i dont know how to DL the file looks like already files ready to use!

[Conor23]

Originally Posted by barakuda21

i dont have discord!
while search i found this and i dont know how to DL the file looks like already files ready to use!

That files is trash! DB also si trash!
You need clean db

[barakuda21]

searching game files and i try to find 12sky2 files

[barakuda21]

i found server file 48.89MB not sure if this link is active because it's linked in raysource if you are interested and know how to use raysource downloader here is the link (fs2you://Y2FjaGVmaWxlMTgucmF5ZmlsZS5jb20vemgtY24vZG93bmxvYW QvZjMwODRjZTJmMWNmOWZiMDhiYTQxNmM1YzBhYzIyMmIvMTJT a3lfc2VydmVyLnJhcnw1MTI2NjM3M3wlRTUlOEQlODElRTQlQk ElOEMlRTQlQjklOEIlRTUlQTQlQTklRTYlOUMlOEQlRTUlOEEl QTElRTUlOTklQTglRTclQUIlQUYucmFy) you only need is raysource downloader and paste it there! the compatible client version is TwelveSky20812 that's he/she say! i found it in chinese forum