Offline |
|
|
Csatlakozott:2019.08.20. 18:19 Hozzászólások:501 Megköszönt másnak: 244 alkalommal Megköszönték neki: 45 alkalommal
|
Vagy így egyszerübb a modelleket bővíteni. Itt az egész sql táblád. -- phpMyAdmin SQL Dump -- version 5.1.0 -- https://www.phpmyadmin.net/ -- -- Host: mysql.srkhost.eu -- Generation Time: Feb 10, 2022 at 06:46 PM -- Server version: 5.7.34 -- PHP Version: 7.3.27-1~deb10u1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `s12381_darkkinght` -- -- -------------------------------------------------------- -- -- Table structure for table `WeaponKills` -- CREATE TABLE `WeaponKills` ( `Id` INT(11) NOT NULL, `name` VARCHAR(32) NOT NULL, `m4a1_0` INT(11) NOT NULL, `m4a1_1` INT(11) NOT NULL, `m4a1_2` INT(11) NOT NULL, `m4a1_3` INT(11) NOT NULL, `m4a1_4` INT(11) NOT NULL, `m4a1_5` INT(11) NOT NULL, `m4a1_6` INT(11) NOT NULL, `m4a1_7` INT(11) NOT NULL, `m4a1_8` INT(11) NOT NULL, `m4a1_9` INT(11) NOT NULL, `m4a1_10` INT(11) NOT NULL, `m4a1_11` INT(11) NOT NULL, `m4a1_12` INT(11) NOT NULL, `m4a1_13` INT(11) NOT NULL, `m4a1_14` INT(11) NOT NULL, `m4a1_15` INT(11) NOT NULL, `m4a1_16` INT(11) NOT NULL, `m4a1_17` INT(11) NOT NULL, `m4a1_18` INT(11) NOT NULL, `m4a1_19` INT(11) NOT NULL, `m4a1_20` INT(11) NOT NULL, `m4a1_21` INT(11) NOT NULL, `m4a1_22` INT(11) NOT NULL, `ak_0` INT(11) NOT NULL, `ak_1` INT(11) NOT NULL, `ak_2` INT(11) NOT NULL, `ak_3` INT(11) NOT NULL, `ak_4` INT(11) NOT NULL, `ak_5` INT(11) NOT NULL, `ak_6` INT(11) NOT NULL, `ak_7` INT(11) NOT NULL, `ak_8` INT(11) NOT NULL, `ak_9` INT(11) NOT NULL, `ak_10` INT(11) NOT NULL, `ak_11` INT(11) NOT NULL, `ak_12` INT(11) NOT NULL, `ak_13` INT(11) NOT NULL, `ak_14` INT(11) NOT NULL, `ak_15` INT(11) NOT NULL, `ak_16` INT(11) NOT NULL, `ak_17` INT(11) NOT NULL, `ak_18` INT(11) NOT NULL, `ak_19` INT(11) NOT NULL, `ak_20` INT(11) NOT NULL, `ak_21` INT(11) NOT NULL, `ak_22` INT(11) NOT NULL, `awp_0` INT(11) NOT NULL, `awp_1` INT(11) NOT NULL, `awp_2` INT(11) NOT NULL, `awp_3` INT(11) NOT NULL, `awp_4` INT(11) NOT NULL, `awp_5` INT(11) NOT NULL, `awp_6` INT(11) NOT NULL, `awp_7` INT(11) NOT NULL, `awp_8` INT(11) NOT NULL, `awp_9` INT(11) NOT NULL, `awp_10` INT(11) NOT NULL, `awp_11` INT(11) NOT NULL, `awp_12` INT(11) NOT NULL, `awp_13` INT(11) NOT NULL, `awp_14` INT(11) NOT NULL, `deagle_0` INT(11) NOT NULL, `deagle_1` INT(11) NOT NULL, `deagle_2` INT(11) NOT NULL, `deagle_3` INT(11) NOT NULL, `deagle_4` INT(11) NOT NULL, `deagle_5` INT(11) NOT NULL, `deagle_6` INT(11) NOT NULL, `deagle_7` INT(11) NOT NULL, `deagle_8` INT(11) NOT NULL, `deagle_9` INT(11) NOT NULL, `deagle_10` INT(11) NOT NULL, `knife_0` INT(11) NOT NULL, `steamid` VARCHAR(32) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `WeaponKills` -- INSERT INTO `WeaponKills` (`Id`, `name`, `m4a1_0`, `m4a1_1`, `m4a1_2`, `m4a1_3`, `m4a1_4`, `m4a1_5`, `m4a1_6`, `m4a1_7`, `m4a1_8`, `m4a1_9`, `m4a1_10`, `m4a1_11`, `m4a1_12`, `m4a1_13`, `m4a1_14`, `m4a1_15`, `m4a1_16`, `m4a1_17`, `m4a1_18`, `m4a1_19`, `m4a1_20`, `m4a1_21`, `m4a1_22`, `ak_0`, `ak_1`, `ak_2`, `ak_3`, `ak_4`, `ak_5`, `ak_6`, `ak_7`, `ak_8`, `ak_9`, `ak_10`, `ak_11`, `ak_12`, `ak_13`, `ak_14`, `ak_15`, `ak_16`, `ak_17`, `ak_18`, `ak_19`, `ak_20`, `ak_21`, `ak_22`, `awp_0`, `awp_1`, `awp_2`, `awp_3`, `awp_4`, `awp_5`, `awp_6`, `awp_7`, `awp_8`, `awp_9`, `awp_10`, `awp_11`, `awp_12`, `awp_13`, `awp_14`, `deagle_0`, `deagle_1`, `deagle_2`, `deagle_3`, `deagle_4`, `deagle_5`, `deagle_6`, `deagle_7`, `deagle_8`, `deagle_9`, `deagle_10`, `knife_0`, `steamid`) VALUES (1, 'ChaoS*', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'STEAM_0:1:153030796'), (2, 'Airoz', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'STEAM_0:0:492651965'); -- -- Indexes for dumped tables -- -- -- Indexes for table `WeaponKills` -- ALTER TABLE `WeaponKills` ADD PRIMARY KEY (`Id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `WeaponKills` -- ALTER TABLE `WeaponKills` MODIFY `Id` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
írtam mindenhez +1 skint. CREATE TABLE `WeaponKills` ( `Id` int(11) NOT NULL, `name` varchar(32) NOT NULL, `m4a1_0` int(11) NOT NULL, `m4a1_1` int(11) NOT NULL, `m4a1_2` int(11) NOT NULL, `m4a1_3` int(11) NOT NULL, `m4a1_4` int(11) NOT NULL, `m4a1_5` int(11) NOT NULL, `m4a1_6` int(11) NOT NULL, `m4a1_7` int(11) NOT NULL, `m4a1_8` int(11) NOT NULL, `m4a1_9` int(11) NOT NULL, `m4a1_10` int(11) NOT NULL, `m4a1_11` int(11) NOT NULL, `m4a1_12` int(11) NOT NULL, `m4a1_13` int(11) NOT NULL, `m4a1_14` int(11) NOT NULL, `m4a1_15` int(11) NOT NULL, `m4a1_16` int(11) NOT NULL, `m4a1_17` int(11) NOT NULL, `m4a1_18` int(11) NOT NULL, `m4a1_19` int(11) NOT NULL, `m4a1_20` int(11) NOT NULL, `m4a1_21` int(11) NOT NULL, `m4a1_22` int(11) NOT NULL, `m4a1_23` int(11) NOT NULL, `ak_0` int(11) NOT NULL, `ak_1` int(11) NOT NULL, `ak_2` int(11) NOT NULL, `ak_3` int(11) NOT NULL, `ak_4` int(11) NOT NULL, `ak_5` int(11) NOT NULL, `ak_6` int(11) NOT NULL, `ak_7` int(11) NOT NULL, `ak_8` int(11) NOT NULL, `ak_9` int(11) NOT NULL, `ak_10` int(11) NOT NULL, `ak_11` int(11) NOT NULL, `ak_12` int(11) NOT NULL, `ak_13` int(11) NOT NULL, `ak_14` int(11) NOT NULL, `ak_15` int(11) NOT NULL, `ak_16` int(11) NOT NULL, `ak_17` int(11) NOT NULL, `ak_18` int(11) NOT NULL, `ak_19` int(11) NOT NULL, `ak_20` int(11) NOT NULL, `ak_21` int(11) NOT NULL, `ak_22` int(11) NOT NULL, `ak_23` int(11) NOT NULL, `awp_0` int(11) NOT NULL, `awp_1` int(11) NOT NULL, `awp_2` int(11) NOT NULL, `awp_3` int(11) NOT NULL, `awp_4` int(11) NOT NULL, `awp_5` int(11) NOT NULL, `awp_6` int(11) NOT NULL, `awp_7` int(11) NOT NULL, `awp_8` int(11) NOT NULL, `awp_9` int(11) NOT NULL, `awp_10` int(11) NOT NULL, `awp_11` int(11) NOT NULL, `awp_12` int(11) NOT NULL, `awp_13` int(11) NOT NULL, `awp_14` int(11) NOT NULL, `awp_15` int(11) NOT NULL, `deagle_0` int(11) NOT NULL, `deagle_1` int(11) NOT NULL, `deagle_2` int(11) NOT NULL, `deagle_3` int(11) NOT NULL, `deagle_4` int(11) NOT NULL, `deagle_5` int(11) NOT NULL, `deagle_6` int(11) NOT NULL, `deagle_7` int(11) NOT NULL, `deagle_8` int(11) NOT NULL, `deagle_9` int(11) NOT NULL, `deagle_10` int(11) NOT NULL, `deagle_11` int(11) NOT NULL, `knife_0` int(11) NOT NULL, `steamid` varchar(32) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
amit úgy tudsz csinálni hogy `deagle_0` int(11) NOT NULL, `deagle_1` int(11) NOT NULL, `deagle_2` int(11) NOT NULL, //EZ MÁR PLUSZ SKIN
És ebben a táblában is ugyan így bővíted annyival emennyi skint hozzá adsz és amilyen skint hozzá adtál. számozva vannak a skineid 1,2,3,4 és stb ha van mindenből 4 db és írsz mindegyikhez +1 et akkor nyílván mindegyik m4 dezi ak hoz ezt írod ak_5 (model_szám) és stb INSERT INTO `WeaponKills` (`Id`, `name`, `m4a1_0`, `m4a1_1`, `m4a1_2`, `m4a1_3`, `m4a1_4`, `m4a1_5`, `m4a1_6`, `m4a1_7`, `m4a1_8`, `m4a1_9`, `m4a1_10`, `m4a1_11`, `m4a1_12`, `m4a1_13`, `m4a1_14`, `m4a1_15`, `m4a1_16`, `m4a1_17`, `m4a1_18`, `m4a1_19`, `m4a1_20`, `m4a1_21`, `m4a1_22`, `ak_0`, `ak_1`, `ak_2`, `ak_3`, `ak_4`, `ak_5`, `ak_6`, `ak_7`, `ak_8`, `ak_9`, `ak_10`, `ak_11`, `ak_12`, `ak_13`, `ak_14`, `ak_15`, `ak_16`, `ak_17`, `ak_18`, `ak_19`, `ak_20`, `ak_21`, `ak_22`, `awp_0`, `awp_1`, `awp_2`, `awp_3`, `awp_4`, `awp_5`, `awp_6`, `awp_7`, `awp_8`, `awp_9`, `awp_10`, `awp_11`, `awp_12`, `awp_13`, `awp_14`, `deagle_0`, `deagle_1`, `deagle_2`, `deagle_3`, `deagle_4`, `deagle_5`, `deagle_6`, `deagle_7`, `deagle_8`, `deagle_9`, `deagle_10`, `knife_0`, `steamid`) VALUES (1, 'ChaoS*', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'STEAM_0:1:153030796'), (2, 'Airoz', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'STEAM_0:0:492651965');
majd ha ezt meg csináltad az sql táblában a régi sql táblát törlöd az adatbázisből és fel töltöd az újjat. _________________ Hamarosan új pluginok lesznek ki terjesztve! :)
A hozzászólást 1 alkalommal szerkesztették, utoljára 8mTNNe 2022.02.10. 18:56-kor.
|
|