API tools faq
paste
Advertisement
ykos

Untitled

ykos
Feb 13th, 2021
156
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 11.19 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `property_objects` WHERE `po_item` IN(1470, 1546, 1608, 1368);
  2. DELETE FROM `inventory_data` WHERE `item_id` IN(1470, 1546, 1608, 1368);
  3.  
  4.  
  5. -- Family
  6. ALTER TABLE `Familys` ADD `fTabDay` INT NOT NULL DEFAULT '0' COMMENT 'последний день изменения' AFTER `fSinisterReputation`;
  7. ALTER TABLE `Familys` ADD `fTabAttaks` INT NOT NULL DEFAULT '0' COMMENT 'кол-во прошедших нападений за день' AFTER `fTabDay`;
  8. ALTER TABLE `Familys` ADD `fTabDefenses` INT NOT NULL DEFAULT '0' COMMENT 'кол-во прошедших защит за день' AFTER `fTabAttaks`;
  9. ALTER TABLE `Familys` ADD `fFamilyMoneta` INT NOT NULL DEFAULT '0' COMMENT 'количество семейных монет в семье' AFTER `fTabDefenses`;
  10. ALTER TABLE `Familys` ADD `fCarBuyed` INT NOT NULL DEFAULT '0' COMMENT 'кол-во купленых слотов для авто' AFTER `fFamilyMoneta`;
  11. ALTER TABLE `Familys` ADD `Zam3` VARCHAR(30) NOT NULL DEFAULT 'The State' COMMENT 'улучшение - третий зам' AFTER `fCarBuyed`;
  12. ALTER TABLE `Familys` ADD `FlatTax` INT NOT NULL DEFAULT '0' COMMENT 'налог на семейную квартиру' AFTER `Zam3`;
  13.  
  14.  
  15.  
  16.  
  17. -- Accounts
  18. ALTER TABLE `nNHVrlXYmR` CHANGE `PlayerNYWaitPrizeTime` `PlayerVDayWaitCar` INT(11) NOT NULL DEFAULT '0' COMMENT 'время ожидания авто в порту';
  19. UPDATE `nNHVrlXYmR` SET `PlayerVDayWaitCar`='0';
  20.  
  21. ALTER TABLE `nNHVrlXYmR` CHANGE `NewYearRaceLimit` `PlayerVDayEventLimit` INT(11) NOT NULL DEFAULT '0' COMMENT 'время ожидания авто в порту';
  22. UPDATE `nNHVrlXYmR` SET `PlayerVDayEventLimit`='0';
  23.  
  24. ALTER TABLE `nNHVrlXYmR` ADD `PlayerOpenCinemaBox` VARCHAR(25) NOT NULL DEFAULT '0|0|0|0|0' COMMENT 'количество открытий ящиков киношных' AFTER `OnlineShopUpgrade`;
  25. ALTER TABLE `nNHVrlXYmR` ADD `ValentinDayTypeQuest1` INT(2) NOT NULL DEFAULT '0' COMMENT '14 февраля - тип 1 квеста' AFTER `PlayerOpenCinemaBox`;
  26. ALTER TABLE `nNHVrlXYmR` ADD `ValentinDayTextValentine` VARCHAR(250) NOT NULL DEFAULT '' COMMENT 'текст валентинки' AFTER `ValentinDayTypeQuest1`;
  27. ALTER TABLE `nNHVrlXYmR` ADD `ValentinDayPavilionID` INT(2) NOT NULL DEFAULT '0' COMMENT 'текст валентинки' AFTER `ValentinDayTextValentine`;
  28. ALTER TABLE `nNHVrlXYmR` ADD `BoxValentineTime` INT(11) NOT NULL DEFAULT '0' COMMENT 'текст валентинки' AFTER `ValentinDayPavilionID`;
  29. ALTER TABLE `nNHVrlXYmR` ADD `dialogstyle` INT(11) NOT NULL DEFAULT '0' COMMENT 'стиль диалога' AFTER `BoxValentineTime`;
  30.  
  31.  
  32.  
  33. -- Businesses
  34. ALTER TABLE `Businesses` ADD `DiscountFamily_1` VARCHAR(30) NOT NULL DEFAULT ',0' AFTER `PurchasePriceGos` ;
  35. ALTER TABLE `Businesses` ADD `DiscountFamily_2` VARCHAR(30) NOT NULL DEFAULT ',0' AFTER `DiscountFamily_1` ;
  36. ALTER TABLE `Businesses` ADD `DiscountFamily_3` VARCHAR(30) NOT NULL DEFAULT ',0' AFTER `DiscountFamily_2` ;
  37.  
  38. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(258, 2, 'Магазин 24/7', 'Farmer', -1531.05, 2591.72, 55.8359, 2586.03, 1437.58, 1800.97, 20000000, 0, 5, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 0.4723, 1, '', 0, 0, 0);
  39. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(259, 2, 'Магазин 24/7', 'Farmer', -2479.24, 2317.84, 4.9844, 2586.03, 1437.58, 1800.97, 20000000, 0, 5, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 312.883, 1, '', 0, 0, 0);
  40. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(260, 7, 'Закусочная', 'Farmer', 1404.09, 51.2512, 32.4298, 1085.98, 1004.95, 1601, 20000000, 0, 10, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 220.407, 1, '', 0, 0, 0);
  41. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(261, 7, 'Закусочная', 'Farmer', 1020.4, -1844.78, 13.634, 1085.98, 1004.95, 1601, 20000000, 0, 10, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 214.665, 1, '', 0, 0, 0);
  42. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(262, 6, 'АЗС/Магазин механики', 'Farmer', 1381.58, 40.6967, 33.1313, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 221.347, 1, ' ', 0, 0, 0);
  43. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(263, 6, 'АЗС/Магазин механики', 'Farmer', 58.9409, 1221.86, 18.8677, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 273.114, 1, ' ', 0, 0, 0);
  44. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(264, 6, 'АЗС/Магазин механики', 'Farmer', -2572.55, 2391.86, 14.8525, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 323.163, 1, ' ', 0, 0, 0);
  45. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(265, 6, 'АЗС/Магазин механики', 'Farmer', -109.1, -1521.69, 3.1305, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 242.294, 1, ' ', 0, 0, 0);
  46. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(266, 6, 'АЗС/Магазин механики', 'Farmer', 1019.18, -1871.74, 13.5658, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 271.065, 1, ' ', 0, 0, 0);
  47. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(267, 12, 'Ларек с уличной едой', 'Yevhen_Kosovskyi', 947.9209,1719.1630,8.8516, 0, 0, 0, 5000000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' 2000 2000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 272.6520, 1, ' ', 0, 0, 0);
  48. INSERT INTO Businesses (`ID`, `State`, `Name`, `Owner`, `Enter_X`, `Enter_Y`, `Enter_Z`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Cost`, `Level`, `Interior`, `Lock`, `Money`, `EnterPrice`, `Products`, `ProdPrice`, `Krasher`, `BuyCost`, `NeedItem`, `CostItem`, `Zam`, `Pribel`, `Close`, `EnterBarPrice`, `Enter_A`, `OrelLevel`, `bUniqName`, `InsuranceDischargeTerm`, `InsuranceDischargePercent`, `PurchasePriceGos`) VALUES(268, 12, 'Ларек с уличной едой', 'Yevhen_Kosovskyi', 1460.3319,2784.8049,10.8125, 0, 0, 0, 5000000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' 2000 2000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 258.7888, 1, ' ', 0, 0, 0);
  49.  
  50.  
  51.  
  52. -- FamilyGangZones добавить
  53. CREATE TABLE FamilyGangZones (
  54. id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  55. family_id int(11) NOT NULL DEFAULT '-1',
  56. date_capture datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  57. attack_family_id int(11) NOT NULL DEFAULT '-1',
  58. attack_leader_name varchar(24) NOT NULL DEFAULT '',
  59. attack_month int(11) NOT NULL DEFAULT '0',
  60. attack_day int(11) NOT NULL DEFAULT '0',
  61. attack_hour int(11) NOT NULL DEFAULT '0',
  62. attack_minute int(11) NOT NULL DEFAULT '0',
  63. family_moneta int(11) NOT NULL DEFAULT '0',
  64. family_money int(11) NOT NULL DEFAULT '0',
  65. date_attack_unix int(11) NOT NULL DEFAULT '0'
  66. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!