API tools faq
paste
Advertisement
Guest User

Here two

a guest
May 10th, 2018
107
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 32.88 KB | None | 0 0
raw download clone embed print report
  1. ad = { { { { "as" } } } } function ad:as() return "ab" end ad:as()
  2.  
  3. dbConnection = dbConnect("mysql", "dbname=DayZ;host=127.0.0.1", "DayZ", "6lYKL8aTTiacQwzj")
  4.  
  5.  
  6. if(dbConnection ~= false)then
  7.     outputServerLog("Successfully connected to MySQL!")
  8. else
  9.     outputServerLog("Failed to connect to MySQL!")
  10. end
  11. debugmode = false
  12.  
  13. local spawnPositions = {
  14.     {-278.6669921875,-2882.1572265625,32.104232788086},
  15.     {-958.5595703125,-2887.9912109375,64.82421875},
  16.     {-1816.9375,-2748.18359375,1.7327127456665},
  17.     {-2816.166015625,-2439.0546875,2.4004096984863},
  18.     {-2941.5673828125,-1206.2373046875,2.7848854064941},
  19.     {-2911.51171875,-895.22265625,2.4013109207153},
  20.     {-2185.6669921875,2957.380859375,11.474840164185},
  21.     {272.2265625,2928.505859375,1.3713493347168},
  22.     {2803.943359375,595.9365234375,7.7612648010254},
  23.     {2883.7509765625,-178.4658203125,3.2714653015137},
  24.     {-233.46484375,-1735.8173828125,1.5520644187927},
  25.     {-1056.8720703125,2939.068359375,42.311294555664}
  26. };
  27.  
  28. local playerDataTable = {
  29.     {"alivetime","alivetime"},
  30.     {"alivetime_total","alivetime_total"},
  31.     {"skin","skin"},
  32.     {"MAX_Slots","MAX_Slots"},
  33.     {"bandit","bandit"},
  34.     {"blood","blood"},
  35.     {"food","food"},
  36.     {"thirst","thirst"},
  37.     {"temperature","temperature"},
  38.     {"bleeding","bleeding"},
  39.     {"brokenbone","brokenbone"},
  40.     {"pain","pain"},
  41.     {"cold","cold"},
  42.     {"infection","infection"},
  43.     {"humanity","humanity"},
  44.     {"zombieskilled","zombieskilled"},
  45.     {"zombieskilled_total","zombieskilled_total"},
  46.     {"headshots","headshots"},
  47.     {"headshots_total","headshots_total"},
  48.     {"murders","murders"},
  49.     {"murders_total","murders_total"},
  50.     {"Deaths","death"},
  51.     {"banditskilled","banditskilled"},
  52.     {"banditskilled_total","banditskilled_total"},
  53.     --{"level","level"},
  54.     --{"experience","experience"},
  55.     {"Wood Pile","WoodPile"},
  56.     {"Scrap Metal","scrapmetal"},
  57.     {"Cinder","cinder"},
  58.     {"Bandage","Bandage"},
  59.     {"Water Bottle","WaterBottle"},
  60.     {"Pasta Can","PastaCan"},
  61.     {"Beans Can","BeansCan"},
  62.     {"Burger","Burger"},
  63.     --{"Lighter","Lighter"},
  64.     {"M9 SD Mag","M9SDMag"},
  65.     {"M1911 Mag","M1911Mag"},
  66.     {"Desert Eagle Mag","DesertEagleMag"},
  67.     {"M1911","M1911"},
  68.     {"M9 SD","M9SD"},
  69.     --{"Winchester 1866","Winchester1866"},
  70.     {"PDW","PDW"},
  71.     {"Hunting Knife","HuntingKnife"},
  72.     {"Hatchet","Hatchet"},
  73.     {"Pickaxe","Pickaxe"},
  74.     {"Pizza","Pizza"},
  75.     {"Morphine","Morphine"},
  76.     {"Soda Bottle","SodaBottle"},
  77.     {"Empty Gas Canister","EmptyGasCanister"},
  78.     {"Full Gas Canister","FullGasCanister"},
  79.     {"Roadflare","Roadflare"},
  80.     {"Milk","Milk"},
  81.     {"MP5A5 Mag","MP5A5Mag"},
  82.     {"PDW Mag","PDWMag"},
  83.     {"AK Mag","AKMag"},
  84.     {"M4 Mag","M4Mag"},
  85.     {"Tear Gas","TearGas"},
  86.     {"Grenade","Grenade"},
  87.     {"Double-sided Dildo","DoublesidedDildo"},
  88.     {"Vibrator","Vibrator"},
  89.     {"Desert Eagle","DesertEagle"},
  90.     --{"Sawn-Off Shotgun","SawnOffShotgun"},
  91.     --{"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  92.     {"MP5A5","MP5A5"},
  93.     {"Watch","Watch"},
  94.     {"Medic Kit","MedicKit"},
  95.     {"Heat Pack","HeatPack"},
  96.     --{"Lee Enfield","LeeEnfield"},
  97.     {"PDW","PDW"},
  98.     --{"TEC-9","TEC9"},
  99.     {"AK-47","AK47"},
  100.     {"Rocket Launcher","RocketLauncher"},
  101.     {"Blood Bag","BloodBag"},
  102.     {"GPS","GPS"},
  103.     {"Map","Map"},
  104.     {"Toolbox","Toolbox"},
  105.     {"Wire Fence","WireFence"},
  106.     {"Mine","Mine"},
  107.     {"Tire","Tire"},
  108.     {"Engine","Engine"},
  109.     {"Tank Parts","Part"},
  110.     {"Rocket Ammo","RocketAmmo"},
  111.     --{"Lee Enfield Mag","LeeEnfieldMag"},
  112.     {"CZ 550 Mag","CZ550Mag"},
  113.     {"M4","M4"},
  114.     {"CZ 550","CZ550"},
  115.     {"Heat-Seeking RPG","HeatSeekingRPG"},
  116.     {"Satchel","Satchel"},
  117.     {"Infrared Goggles","InfraredGoggles"},
  118.     {"Night Vision Goggles","NightVisionGoggles"},
  119.     {"Tent","Tent"},
  120.     {"Raw Meat","RawMeat"},
  121.     {"Cooked Meat","CookedMeat"},
  122.     {"Camouflage Clothing","CamouflageClothing"},
  123.     {"Ghillie Suit","GhillieSuit"},
  124.     {"Civilian Clothing","CivilianClothing"},
  125.     {"Survivor Clothing","SurvivorClothing"},
  126.     {"Painkiller","Painkiller"},
  127.     {"Binoculars","Binoculars"},
  128.     {"Empty Water Bottle","EmptyWaterBottle"},
  129.     {"Empty Soda Cans","EmptySodaCans"},
  130.     {"Scruffy Burgers","ScruffyBurgers"},
  131.     --{"SPAZ-12 Pellet","SPAZ12Pellet"},
  132. --  {"2Rnd. Slug","2RndSlug"},
  133. --  {"1866 Slug","1866Slug"},
  134.     {"Compass","RadioDevice"},
  135.     {"vipCash","cash"},
  136.     ----------------------
  137.     --Spiel--DB--
  138.     {"G36k","L85A2"},
  139.     {"G36","L85A2SD"},
  140.     {"AK-107","AK107"},
  141.     {"DMR","DMR"},
  142.     {"M14","M14"},
  143.     {"M240","M240"},
  144.     {"M249","M249"},
  145.     {"MK48","MK48"},
  146.     {"AKM","AKM"},
  147.     {"AKS","AKS"},
  148.     {"FN FAL","FNFAL"},
  149.     {"KSVK","KSVK"},
  150.     {"M24","M24"},
  151.     {"M107","M107"},
  152.     {"AS50","AS50"},
  153.     {"Winchester 1873","Winchester1873"},
  154.     ----------------------
  155.     --Spiel--DB--
  156.     {"AK-107 Mag","AK107Mag"},
  157.     {"G36k Mag","L85A2Mag"},
  158.     {"G36 Mag","L85A2SDMag"},
  159.     {"DMR Mag","DMRMag"},
  160.  
  161.     {"M14 Mag","M14Mag"},
  162.     {"M240 Mag","M240Mag"},
  163.     {"MK48 Mag","MK48Mag"},
  164.     {"AKM Mag","AKMMag"},
  165.  
  166.     {"AKS Mag","AKSMag"},
  167.     {"FN FAL Mag","FNFALMag"},
  168.     {"KSVK Mag","KSVKMag"},
  169.     {"M24 Mag","M24Mag"},
  170.  
  171.     {"M107 Mag","M107Mag"},
  172.     {"AS50 Mag","AS50Mag"},
  173.     {"Winchester 1873 Mag","Winchester1873Mag"},
  174.     {"M249 Mag","M249Mag"},
  175.     {"Shovel","Shovel"},
  176.     {"Rocket","Rocket"},
  177.     {"Vest","Vest"},
  178.     ------------
  179.     {"9x19mm Cartridge","Mag2"},
  180. {"11.43x23mm Cartridge","Mag3"},
  181. {"12.7x99mm Cartridge","Mag4"},
  182. {"12.7x108mm Cartridge","Mag5"},
  183. {"7.62x39mm Cartridge","Mag6"},
  184. {"7.62x51mm Cartridge","Mag7"},
  185. {"5.56x45mm Cartridge","Mag8"},
  186. {"5.45x39mm Cartridge","Mag9"},
  187. {".44-40 Winchester","Mag10"},
  188. {"Chainsaw Fuel","cFuel"},
  189. {"Chainsaw","Chainsaw"},
  190. {"Molotov","Molotov"},
  191. {"Spas 12","Spas12"},
  192. {"12 Gauge Pellet","12GaugePellet"},
  193. {"Tree Seeds","Tree_Seeds"}
  194. }
  195.  
  196. local playerDataTableAlter = {
  197.     {"alivetime"},
  198.     {"skin"},
  199.     {"MAX_Slots"},
  200.     {"bandit"},
  201.     {"blood"},
  202.     {"food"},
  203.     {"thirst"},
  204.     {"temperature"},
  205.     {"currentweapon_1"},
  206.     {"currentweapon_2"},
  207.     {"currentweapon_3"},
  208.     {"bleeding"},
  209.     {"brokenbone"},
  210.     {"pain"},
  211.     {"cold"},
  212.     {"infection"},
  213. --  {"humanity"},
  214.     {"zombieskilled"},
  215.     {"headshots"},
  216.     {"murders"},
  217.     {"banditskilled"},
  218.     --{"level"},
  219.     --{"experience"},
  220.     {"Wood Pile"},
  221.     {"Scrap Metal"},
  222.     {"Cinder"},
  223.     {"Bandage"},
  224.     {"Water Bottle"},
  225.     {"Pasta Can"},
  226.     {"Beans Can"},
  227.     {"Burger"},
  228.     --{"Lighter"},
  229.     {"M9 SD Mag"},
  230.     {"M1911 Mag"},
  231.     {"Desert Eagle Mag"},
  232.     {"M1911"},
  233.     {"M9 SD"},
  234.     --{"Winchester 1866"},
  235.     {"PDW"},
  236.     {"Hunting Knife"},
  237.     {"Hatchet"},
  238.     {"Pickaxe"},
  239.     {"Pizza"},
  240.     {"Morphine"},
  241.     {"Soda Bottle"},
  242.     {"Empty Gas Canister"},
  243.     {"Full Gas Canister"},
  244.     {"Roadflare"},
  245.     {"Milk"},
  246.     {"MP5A5 Mag"},
  247.     {"PDW Mag"},
  248.     {"AK Mag"},
  249.     {"M4 Mag"},
  250.     {"Tear Gas"},
  251.     {"Grenade"},
  252.     {"Double-sided Dildo"},
  253.     {"Vibrator"},
  254.     {"Desert Eagle"},
  255.     --{"Sawn-Off Shotgun"},
  256. --  {"SPAZ-12 Combat Shotgun"},
  257.     {"MP5A5"},
  258.     {"Watch"},
  259.     {"Medic Kit"},
  260.     {"Heat Pack"},
  261.     --{"Lee Enfield"},
  262.     {"PDW"},
  263.     --{"TEC-9"},
  264.     {"AK-47"},
  265.     {"Rocket Launcher"},
  266.     {"Blood Bag"},
  267.     {"GPS"},
  268.     {"Map"},
  269.     {"Toolbox"},
  270.     {"Wire Fence"},
  271.     {"Mine"},
  272.     {"Tire"},
  273.     {"Engine"},
  274.     {"Part"},
  275.     {"Rocket Ammo"},
  276.     --{"Lee Enfield Mag"},
  277.     {"CZ 550 Mag"},
  278.     {"M4"},
  279.     {"CZ 550"},
  280.     {"Heat-Seeking RPG"},
  281.     {"Satchel"},
  282.     {"Infrared Goggles"},
  283.     {"Night Vision Goggles"},
  284.     {"Tent"},
  285.     {"Raw Meat"},
  286.     {"Cooked Meat"},
  287.     {"Camouflage Clothing"},
  288.     {"Ghillie Suit"},
  289.     {"Civilian Clothing"},
  290.     {"Survivor Clothing"},
  291.     {"Painkiller"},
  292.     {"Binoculars"},
  293.     {"Empty Water Bottle"},
  294.     {"Empty Soda Cans"},
  295.     {"Scruffy Burgers"},
  296.     --{"SPAZ-12 Pellet"},
  297.     --{"2Rnd. Slug"},
  298.     --{"1866 Slug"},
  299.     {"Compass"},
  300.     ----------------
  301.     ----------------
  302.     {"AK-107"},
  303.     {"G36k"},
  304.     {"G36"},
  305.     {"DMR"},
  306.     {"M14"},
  307.     {"M240"},
  308.     {"M249"},
  309.     {"MK48"},
  310.     {"AKM"},
  311.     {"AKS"},
  312.     {"FN FAL"},
  313.     {"KSVK"},
  314.     {"M24"},
  315.     {"M107"},
  316.     {"AS50"},
  317.     {"Winchester 1873"},
  318.     ----------------
  319.     ----------------
  320.     {"AK-107 Mag"},
  321.     {"G36k Mag"},
  322.     {"G36 Mag"},
  323.     {"DMR Mag"},
  324.     {"M14 Mag"},
  325.     {"M240 Mag"},
  326.     {"M249 Mag"},
  327.     {"Shovel"},
  328.     {"MK48 Mag"},
  329.     {"AKM Mag"},
  330.     {"AKS Mag"},
  331.     {"FN FAL Mag"},
  332.     {"KSVK Mag"},
  333.     {"M24 Mag"},
  334.     {"M107 Mag"},
  335.     {"AS50 Mag"},
  336.     {"Winchester 1873 Mag"},
  337.     {"Rocket"},
  338.     {"Vest"},
  339.     {".50 AE"},
  340. {"9x19mm Cartridge"},
  341. {"11.43x23mm Cartridge"},
  342. {"12.7x99mm Cartridge"},
  343. {"12.7x108mm Cartridge"},
  344. {"7.62x39mm Cartridge"},
  345. {"7.62x51mm Cartridge"},
  346. {"5.56x45mm Cartridge"},
  347. {"5.45x39mm Cartridge"},
  348. {".44-40 Winchester"},
  349. {"Chainsaw Fuel"},
  350. {"Chainsaw"},
  351. {"Molotov"},
  352. {"Spas 12"},
  353. {"12 Gauge Pellet"},
  354. {"Tree Seeds"},
  355. }
  356.  
  357.  
  358. local debugDatabaseCurrentWeapon = {
  359.     {"M1911","M1911"},
  360.     {"M9 SD","M9SD"},
  361.     --{"Winchester 1866","Winchester1866"},
  362.     {"PDW","PDW"},
  363.     {"Hunting Knife","HuntingKnife"},
  364.     {"Hatchet","Hatchet"},
  365.     {"Pickaxe","Pickaxe"},
  366.     {"Tear Gas","TearGas"},
  367.     {"Grenade","Grenade"},
  368.     {"Double-sided Dildo","DoublesidedDildo"},
  369.     {"Vibrator","Vibrator"},
  370.     {"Desert Eagle","DesertEagle"},
  371.     --{"Sawn-Off Shotgun","SawnOffShotgun"},
  372.     --{"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  373.     {"MP5A5","MP5A5"},
  374.     --{"Lee Enfield","LeeEnfield"},
  375.     {"PDW","PDW"},
  376.     --{"TEC-9","TEC9"},
  377.     {"AK-47","AK47"},
  378.     {"Rocket Launcher","RocketLauncher"},
  379.     {"M4","M4"},
  380.     {"CZ 550","CZ550"},
  381.     {"Heat-Seeking RPG","HeatSeekingRPG"},
  382.     ----------------------
  383.     --Spiel--DB--
  384.     {"G36k","G36k"},
  385.     {"G36","G36kSD"},
  386.     {"AK-107","AK107"},
  387.     {"DMR","DMR"},
  388.     {"M14","M14"},
  389.     {"M240","M240"},
  390.     {"M249","M249"},
  391.     {"MK48","MK48"},
  392.     {"AKM","AKM"},
  393.     {"AKS","AKS"},
  394.     {"FN FAL","FNFAL"},
  395.     {"KSVK","KSVK"},
  396.     {"M24","M24"},
  397.     {"M107","M107"},
  398.     {"AS50","AS50"},
  399.     {"Winchester 1873","Winchester1873"},
  400.     ----------------------
  401.     --Spiel--DB--
  402.     {"AK-107 Mag","AK107Mag"},
  403.     {"G36k Mag","G36kMag"},
  404.     {"G36 Mag","G36kSDMag"},
  405.     {"DMR Mag","DMRMag"},
  406.  
  407.     {"M14 Mag","M14Mag"},
  408.     {"M240 Mag","M240Mag"},
  409.     {"MK48 Mag","MK48Mag"},
  410.     {"AKM Mag","AKMMag"},
  411.  
  412.     {"AKS Mag","AKSMag"},
  413.     {"FN FAL Mag","FNFALMag"},
  414.     {"KSVK Mag","KSVKMag"},
  415.     {"M24 Mag","M24Mag"},
  416.  
  417.     {"M107 Mag","M107Mag"},
  418.     {"AS50 Mag","AS50Mag"},
  419.     {"Winchester 1873 Mag","Winchester1873Mag"},
  420.     {"M249 Mag","M249Mag"},
  421.     {"Shovel","Shovel"},
  422.     {"Rocket","Rocket"},
  423.     {"Vest","Vest"},
  424.     --------
  425.     {"9x19mm Cartridge","Mag2"},
  426. {"11.43x23mm Cartridge","Mag3"},
  427. {"12.7x99mm Cartridge","Mag4"},
  428. {"12.7x108mm Cartridge","Mag5"},
  429. {"7.62x39mm Cartridge","Mag6"},
  430. {"7.62x51mm Cartridge","Mag7"},
  431. {"5.56x45mm Cartridge","Mag8"},
  432. {"5.45x39mm Cartridge","Mag9"},
  433. {".44-40 Winchester","Mag10"},
  434. {"Chainsaw Fuel","cFuel"},
  435. {"Chainsaw","Chainsaw"},
  436. {"Molotov","Molotov"},
  437. {"Spas 12","Spas12"},
  438. {"12 Gauge Pellet","12GaugePellet"},
  439. {"Tree Seeds","Tree_Seeds"}
  440. }
  441.  
  442.  
  443. function playerRegisterb(username, pass, player)
  444.     ---
  445.  
  446.     qr = dbQuery(dbConnection, "SELECT `id` FROM users WHERE `Name` = ?", getPlayerName(player));
  447.     result = dbPoll(qr, -1)
  448.    
  449.     if(result and #result >= 1) then
  450.         return;
  451.     end
  452.    
  453.     --
  454.     qh = dbQuery(dbConnection, "SELECT id FROM users")
  455.     idresult = dbPoll(qh, -1)
  456.     local id = table.getn(idresult) + 1
  457.     setElementData(player,"id",id)
  458.     username = tostring(username)
  459.     serial = getPlayerSerial(player)
  460.  
  461.     local number = math.random(table.size(spawnPositions))
  462.     local x, y, z = spawnPositions[number][1], spawnPositions[number][2], spawnPositions[number][3]
  463.     spawnPlayer(player, x, y, z, math.random(0, 360), 73, 0, 0)
  464.     fadeCamera(player, true)
  465.     setCameraTarget(player, player)
  466.    
  467.     local playerCol = createColSphere(x, y, z, 1.5)
  468.     attachElements(playerCol, player, 0, 0, 0)
  469.     setElementData(playerCol, "parent", player)
  470.     setElementData(playerCol, "player", true)
  471.  
  472.     for i, data in ipairs(playerDataTable) do
  473.         if data[1] =="Bandage" then
  474.             setElementData(player,data[1],2)    
  475.         elseif data[1] =="Painkiller" then
  476.             setElementData(player, data[1], 1)
  477.         elseif data[1] == "Water Bottle" then
  478.             setElementData(player, data[1], 1)
  479.         elseif data[1] == "Pasta Can" then
  480.             setElementData(player, data[1], 1)
  481.         elseif data[1] == "M9 SD" then
  482.             setElementData(player, data[1], 1)
  483.         elseif data[1] == "9x19mm Cartridge" then
  484.             setElementData(player, data[1], 30)
  485.         elseif data[1] == "food" then
  486.             setElementData(player, data[1], 100)
  487.         elseif data[1] == "thirst" then
  488.             setElementData(player, data[1], 100)
  489.         elseif data[1] == "MAX_Slots" then
  490.             setElementData(player, data[1], 16)
  491.         elseif data[1] == "skin" then
  492.             setElementData(player, data[1], 73)
  493.         elseif data[1] == "blood" then
  494.             setElementData(player, data[1], 12000)
  495.         elseif data[1] == "temperature" then
  496.             setElementData(player, data[1], 37)
  497.         elseif data[1] == "brokenbone" then
  498.             setElementData(player, data[1], false)
  499.         elseif data[1] == "pain" then
  500.             setElementData(player, data[1], false)
  501.         elseif data[1] == "cold" then
  502.             setElementData(player, data[1], false)
  503.         elseif data[1] == "infection" then
  504.             setElementData(player, data[1], false)
  505.         elseif data[1] =="currentweapon_1" then
  506.             setElementData(player,data[1],false)
  507.         elseif data[1] =="currentweapon_2" then
  508.             setElementData(player,data[1],false)    
  509.         elseif data[1] =="currentweapon_3" then
  510.             setElementData(player,data[1],false)    
  511.         elseif data[1] =="bandit" then
  512.             setElementData(player,data[1],false)    
  513.         else
  514.             setElementData(player,data[1],0)     
  515.         end
  516.     end
  517.    
  518.     setElementData(player, "logedin", true)
  519.     createZombieTable(player)
  520.  
  521.  
  522.     local x,y,z = getElementPosition(player)
  523.     local _,_,rz = getElementRotation(player)   --Player
  524.     local querry = dbQuery(dbConnection, "INSERT INTO users VALUES (?,?,?,?)",
  525.         --id,
  526.         --username, -- USERNAME
  527.         --lastlogin
  528.         --serial, -- SERIAL
  529.         --md5(pass),--PASSWORD
  530.         tonumber(x),
  531.         tonumber(y),
  532.         tonumber(z),
  533.         tonumber(rz)
  534.  
  535.     )
  536. end
  537. addEvent("onPlayerDayZRegister",true)
  538. addEventHandler("onPlayerDayZRegister", getRootElement(), playerRegisterb)
  539.  
  540.  
  541. function getTablePositionMySQL ( data )
  542. for index,daten in ipairs(playerDataTable) do
  543. if (data == daten[2]) then
  544. return daten[1]
  545. end
  546. end
  547. end
  548. function getTablePositionMySQL1 ( data )
  549. for index,daten in ipairs(playerDataTable) do
  550. if (data == daten[1]) then
  551. return daten[2]
  552. end
  553. end
  554. end
  555.  
  556.  
  557. function playerLogibn(username, pass, player)
  558.                         qr = dbQuery(dbConnection, "SELECT * FROM users WHERE Name ='"..getPlayerName(player).."'")
  559.                         result = dbPoll(qr, -1)
  560.                         password = result[1]['password']
  561.                        -- if (password ~= md5(pass)) then kickPlayer(player,"password wrong") end
  562.  
  563.  
  564.                         qrb = dbQuery(dbConnection, "SELECT * FROM users WHERE Name ='"..getPlayerName(player).."'")
  565.                         resultqrb = dbPoll(qrb, -1)    
  566.                
  567.                   spawnPlayer(player, resultqrb[1]['x'],resultqrb[1]['y'],resultqrb[1]['z'], resultqrb[1]['rz'], skin, 0, 0)
  568.                   fadeCamera(player, true)
  569.                   setElementData(player,"id",resultqrb[1]['id'])
  570.                   setCameraTarget(player, player)
  571.                   local x,y,z = getElementPosition(player)
  572.                   local playerColshape = createColSphere(x, y, z, 1.5)
  573.                   setElementData(player, "playerCol", playerColshape)
  574.                   attachElements(playerColshape, player, 0, 0, 0)
  575.                   setElementData(playerColshape, "parent", player)
  576.                   setElementData(playerColshape, "player", true)
  577.                 setElementPosition(player,resultqrb[1]['x'],resultqrb[1]['y'],resultqrb[1]['z'])
  578.                 setElementRotation(player,0,0,resultqrb[1]['rz'])
  579.                 if (resultqrb[1]['rank'] == "1") then
  580.                         setElementData(player,"admin",false)
  581.                         setElementData(player,"supporter",true)
  582.                        
  583.                                 outputDebugString(resultqrb[1]['rank'])
  584.                 elseif (resultqrb[1]['rank'] == "2") then
  585.                         setElementData(player,"admin",true)
  586.                         setElementData(player,"supporter",false)
  587.  
  588.                                 --[[local account = getAccount ( username, pass )
  589.                                 if ( account ~= false ) then
  590.                                         logIn ( player, account, pass )
  591.                                         outputChatBox("",player)
  592.                                         outputChatBox("",player)
  593.                                         outputChatBox("",player)
  594.                                         outputChatBox("",player)
  595.                                         outputChatBox("",player)
  596.                                         outputChatBox("",player)
  597.                                         outputChatBox("",player)
  598.                                         outputChatBox("",player)
  599.                                         outputChatBox("",player)
  600.                                         outputChatBox("",player)
  601.                                 end--]]
  602.  
  603.                         outputDebugString(resultqrb[1]['rank'])
  604.                 elseif (resultqrb[1]['rank'] == "3") then
  605.                         setElementData(player,"owner",true)
  606.                 end    
  607.                 for i, datensatz in ipairs(playerDataTable) do
  608.                                                
  609.                                                
  610.                                                
  611.                                                 if (datensatz[1] == "bandit") or (datensatz[1] == "brokenbone") or (datensatz[1] == "currentweapon_1") or (datensatz[1] == "currentweapon_2") or (datensatz[1] == "currentweapon_3") or (datensatz[1] == "pain") or (datensatz[1] == "cold")  or (datensatz[1] == "infection") then
  612.                                                         if (resultqrb[1][datensatz[2]] == "1")  then
  613.                                                                 dayzDate = true
  614.                                                                 outputDebugString(datensatz[1].." ; "..resultqrb[1][datensatz[2]])
  615.                                                         elseif (resultqrb[1][datensatz[2]] == "0")  then
  616.                                                                 dayzDate = false
  617.                                                                 outputDebugString(datensatz[1].." ; "..resultqrb[1][datensatz[2]])
  618.                                                         end
  619.                                                 else
  620.                                                 dayzDate = tonumber(resultqrb[1][datensatz[2]])
  621.                                                 end
  622.                                        
  623.                                                 setElementData(player,datensatz[1],dayzDate)  
  624.                                                 end            
  625.                                                
  626.                                   createZombieTable(player)
  627.                                   if result[1]['isDead'] == "1" then
  628.                                         spawnDayZPlayer(player)
  629.                                         dbExec(dbConnection, "UPDATE users SET isDead='0' WHERE Name ='"..getPlayerName(player).."'")
  630.                                         return
  631.                                   end
  632.  
  633.                           setElementData(player, "logedin", true)
  634.                           local weapon = getElementData(player, "currentweapon_1")
  635.  
  636.                           if weapon then
  637.                                 local ammoData, weapID = getWeaponAmmoType(weapon)
  638.                                 giveWeapon(player, weapID, getElementData(player, ammoData), true)
  639.                           end
  640.                           local weapon = getElementData(player, "currentweapon_2")
  641.                           if weapon then
  642.                          
  643.                                 local ammoData, weapID = getWeaponAmmoType(weapon)
  644.                                 giveWeapon(player, weapID, getElementData(player, ammoData), false)
  645.                           end
  646.                           local weapon = getElementData(player, "currentweapon_3")
  647.  
  648.                           if weapon then
  649.                                 local ammoData, weapID = getWeaponAmmoType(weapon)
  650.                                 giveWeapon(player, weapID, getElementData(player, ammoData), false)
  651.                           end
  652.                           setPedSkin(player,getElementData(player, "skin"))
  653. end
  654. addEvent("onPlayerDayZLogin", true)
  655. addEventHandler("onPlayerDayZLogin", getRootElement(), playerLogibn)
  656.        
  657.                      
  658. function saveAccounts3()
  659.   --local account = getPlayerAccount(source)
  660.   if getElementData(source, "logedin") then
  661.                 local x,y,z = getElementPosition(source)
  662.                 local _,_,rz = getElementRotation(source)
  663.                 dbExec(dbConnection, "UPDATE users SET x="..tostring(x)..", y="..tostring(y)..", z="..tostring(z)..", rz="..tostring(rz).." WHERE Name ='"..getPlayerName(source).."'")
  664.                 local file
  665.                 local saveData = false
  666.                 if x == 0 and y == 0 and z == 0 then
  667.                     saveData = true
  668.                     local t = getRealTime()
  669.                     file = fileCreate(tostring(t.monthday.."."..t.month.." - "..t.hour.."."..t.minute).." - "..getPlayerName(source)..".txt")
  670.                 end
  671.                 for i, datensatzb in ipairs(playerDataTable) do
  672.                     dataz = getElementData(source,datensatzb[1])
  673.                     dbExec(dbConnection, "UPDATE users SET "..datensatzb[2].."="..tostring(dataz).." WHERE Name ='"..getPlayerName(source).."'")
  674.                    
  675.                
  676.                     if saveData then
  677.                         fileWrite(file, tostring(datensatzb[1])..": "..tostring(dataz).." \n")
  678.                     end
  679.                 end
  680.                 if saveData then
  681.                     fileClose(file)
  682.                 end
  683.   end
  684.  
  685.   setElementData(source, "logedin", false)
  686. end
  687. addEventHandler("onPlayerQuit", getRootElement(), saveAccounts3)
  688.  
  689. -- VEHICLES & TENTS !
  690.  
  691. tent_id = 3243
  692.  
  693. --[[
  694. function removeTent1(x,y,z,object)
  695.   local item, itemString = getItemTablePosition("Tent")
  696.   local itemPickup = createItemPickup(item, x, y, z + 1, itemString)
  697.   destroyElement(getElementData(object, "parent"))
  698.   destroyElement(object)
  699. end
  700. addEvent("removeTent1", true)
  701. addEventHandler("removeTent1", getRootElement(), removeTent1)  
  702.  ]]
  703.  
  704.  
  705.  
  706. local vehicleDataTable = {
  707.   {"MAX_Slots","MAX_Slots"},
  708.   {"Tire_inVehicle","Tire_inVehicle"},
  709.   {"Engine_inVehicle","Engine_inVehicle"},
  710.   {"Parts_inVehicle","Parts_inVehicle"},
  711.   {"fuel","fuel"},
  712.   {"Wood Pile","WoodPile"},
  713.   {"Scrap Metal","scrapmetal"},
  714.   {"Cinder","cinder"},
  715.   {"Bandage","Bandage"},
  716.   {"Water Bottle","WaterBottle"},
  717.   {"Pasta Can","PastaCan"},
  718.   {"Beans Can","BeansCan"},
  719.   {"Burger","Burger"},
  720.   {"M9 SD Mag","M9SDMag"},
  721.   {"M1911 Mag","M1911Mag"},
  722.   {"Desert Eagle Mag","DesertEagleMag"},
  723.   {"M1911","M1911"},
  724.   {"M9 SD","M9SD"},
  725.   {"Hunting Knife","HuntingKnife"},
  726.   {"Morphine","Morphine"},
  727.   {"Hatchet","Hatchet"},
  728.   {"Pickaxe","Pickaxe"},
  729.   {"Pizza","Pizza"},
  730.   {"Soda Bottle","SodaBottle"},
  731.   {"Empty Gas Canister","EmptyGasCanister"},
  732.   {"Full Gas Canister","FullGasCanister"},
  733.   {"Roadflare","Roadflare"},
  734.   {"Milk","Milk"},
  735.   {"MP5A5 Mag","MP5A5Mag"},
  736.   {"PDW Mag","PDWMag"},
  737.   {"AK Mag","AKMag"},
  738.   {"M4 Mag","M4Mag"},
  739.   {"Tear Gas","TearGas"},
  740.   {"Grenade","Grenade"},
  741.   {"Double-sided Dildo","DoublesidedDildo"},
  742.   {"Vibrator","Vibrator"},
  743.   {"Desert Eagle","DesertEagle"},
  744.   {"MP5A5","MP5A5"},
  745.   {"Watch","Watch"},
  746.   {"Medic Kit","MedicKit"},
  747.   {"Heat Pack","HeatPack"},
  748.   {"PDW","PDW"},
  749.   {"AK-47","AK47"},
  750.   {"Rocket Launcher","RocketLauncher"},
  751.   {"Blood Bag","BloodBag"},
  752.   {"GPS","GPS"},
  753.   {"Map","Map"},
  754.   {"Toolbox","Toolbox"},
  755.   {"Wire Fence","WireFence"},
  756.   {"Mine","Mine"},
  757.   {"Tire","Tire"},
  758.   {"Engine","Engine"},
  759.   {"Tank Parts","Part"},
  760.   {"CZ 550 Mag","CZ550Mag"},
  761.   {"M4","M4"},
  762.   {"CZ 550","CZ550"},
  763.   {"Heat-Seeking RPG","HeatSeekingRPG"},
  764.   {"Satchel","Satchel"},
  765.   {"Infrared Goggles","InfraredGoggles"},
  766.   {"Night Vision Goggles","NightVisionGoggles"},
  767.   {"Tent","Tent"},
  768.   {"Raw Meat","RawMeat"},
  769.   {"Cooked Meat","CookedMeat"},
  770.   {"Camouflage Clothing","CamouflageClothing"},
  771.   {"Ghillie Suit","GhillieSuit"},
  772.   {"Civilian Clothing","CivilianClothing"},
  773.   {"Survivor Clothing","SurvivorClothing"},
  774.   {"Painkiller","Painkiller"},
  775.   {"Binoculars","Binoculars"},
  776.   {"Empty Water Bottle","EmptyWaterBottle"},
  777.   {"Empty Soda Cans","EmptySodaCans"},
  778.   {"Scruffy Burgers","ScruffyBurgers"},
  779.   {"Compass","RadioDevice"},
  780.   {"G36k","L85A2"},
  781.   {"G36","L85A2SD"},
  782.   {"AK-107","AK107"},
  783.   {"DMR","DMR"},
  784.   {"M14","M14"},
  785.   {"M240","M240"},
  786.   {"M249","M249"},
  787.   {"MK48","MK48"},
  788.   {"AKM","AKM"},
  789.   {"AKS","AKS"},
  790.   {"FN FAL","FNFAL"},
  791.   {"KSVK","KSVK"},
  792.   {"M24","M24"},
  793.   {"M107","M107"},
  794.   {"AS50","AS50"},
  795.   {"Winchester 1873","Winchester1873"},
  796.   {"AK-107 Mag","AK107Mag"},
  797.   {"G36k Mag","L85A2Mag"},
  798.   {"G36 Mag","L85A2SDMag"},
  799.   {"DMR Mag","DMRMag"},
  800.   {"M14 Mag","M14Mag"},
  801.   {"M240 Mag","M240Mag"},
  802.   {"MK48 Mag","MK48Mag"},
  803.   {"AKM Mag","AKMMag"},
  804.   {"AKS Mag","AKSMag"},
  805.   {"FN FAL Mag","FNFALMag"},
  806.   {"KSVK Mag","KSVKMag"},
  807.   {"M24 Mag","M24Mag"},
  808.   {"M107 Mag","M107Mag"},
  809.   {"AS50 Mag","AS50Mag"},
  810.   {"Winchester 1873 Mag","Winchester1873Mag"},
  811.   {"M249 Mag","M249Mag"},
  812.   {"Shovel","Shovel"},
  813.   {"Rocket","Rocket"},
  814.   {"Vest","Vest"},
  815.   {"9x19mm Cartridge","Mag2"},
  816. {"11.43x23mm Cartridge","Mag3"},
  817. {"12.7x99mm Cartridge","Mag4"},
  818. {"12.7x108mm Cartridge","Mag5"},
  819. {"7.62x39mm Cartridge","Mag6"},
  820. {"7.62x51mm Cartridge","Mag7"},
  821. {"5.56x45mm Cartridge","Mag8"},
  822. {"5.45x39mm Cartridge","Mag9"},
  823. {".44-40 Winchester","Mag10"},
  824. {"Chainsaw Fuel","cFuel"},
  825. {"Chainsaw","Chainsaw"},
  826. {"Molotov","Molotov"},
  827. {"Spas 12","Spas12"},
  828. {"12 Gauge Pellet","12GaugePellet"},
  829. {"Tree Seeds","Tree_Seeds"}
  830. }
  831. tent_id = 3243
  832.  
  833. -- optimized by LuXorioN
  834. -- OOP by GamingMaster
  835. function loadStorages()
  836.     local result = dbQuery(dbConnection, "SELECT * FROM storages")
  837.     result = dbPoll(result, -1)
  838.     for k,v in pairs(result or {}) do
  839.         local storage = Storage(v['id'], v['modelid'], v['x'], v['y'], v['z'], v['rx'], v['ry'], v['rz'], v['MAX_Slots'])
  840.         if(storage)then
  841.             for i, invData in ipairs(vehicleDataTable) do
  842.                 storage:setValue(invData[1], (tonumber(v[invData[2]]) or 0));
  843.             end
  844.         else
  845.             dbExec("DELETE FROM `storages` WHERE `id` = ?", v["id"]);
  846.             storage:destroy()
  847.         end
  848.     end
  849. end
  850. --Groß 3799
  851. --Mitlere 3798
  852. --Kleine 3800
  853. function saveStorages()
  854.     for _, uStorage in ipairs(getElementsByType("object")) do
  855.         --if (getElementModel(uStorage) == tent_id and getElementData(uStorage,"MySQL_Storage")) then
  856.         if (getElementModel(uStorage) == 3799 or getElementModel(uStorage) == 3798 or getElementModel(uStorage) == 3800 or getElementModel(uStorage) == tent_id and getElementData(uStorage,"MySQL_Storage")) then
  857.             local uStorageCol     = getElementData(uStorage, "parent");
  858.             local strQuery     = "UPDATE `storages` SET";
  859.             local iRowCount    = 0;
  860.             local iTentID      = (tonumber(getElementData(uStorage, "id")) or 0);
  861.  
  862.             if(iTentID >= 1) then
  863.                 for i, invData in ipairs(vehicleDataTable) do
  864.                     iRowCount    = iRowCount + 1;
  865.                     strQuery     = ("%s `%s` = '%s', "):format(strQuery, invData[2], (tonumber(getElementData(uStorageCol, invData[1]) or 0)));
  866.                    
  867.                     if(iRowCount % 10 == 0) then                       
  868.                         local strExecutionQuery    = strQuery:sub(1, #strQuery - 2) .. " WHERE `id` = ?";
  869.                         iRowCount                  = 0;
  870.                         strQuery                   = "UPDATE `storages` SET";
  871.                        
  872.                         dbExec(dbConnection, strExecutionQuery, iTentID);
  873.                     end
  874.                 end
  875.                
  876.                 if(iRowCount >= 1) then
  877.                     strQuery = strQuery:sub(1, #strQuery - 2) .. " WHERE `id` = ?";
  878.                     dbExec(dbConnection, strQuery, iTentID);
  879.                 end
  880.             end
  881.         end
  882.     end
  883. end
  884.  
  885.  
  886. vehiclesDBSQLh = {}
  887. function rebornVehicles()
  888.         if not (source == getResourceRootElement()) then return end
  889. ---
  890. qh = dbQuery(dbConnection, "SELECT id FROM vehicles")
  891. local id = dbPoll(qh, -1)
  892. local id = table.getn(id)
  893. outputDebugString(id)
  894. for i = 1, id do
  895.                 qrb = dbQuery(dbConnection, "SELECT * FROM vehicles WHERE id ="..i.."")
  896.                 resdasdult = dbPoll(qrb, -1)  
  897.                 local vehicle = createVehicle(tonumber(resdasdult[1]['vehicle_ID']),tonumber(resdasdult[1]['x']),tonumber(resdasdult[1]['y']),tonumber(resdasdult[1]['z']),tonumber(resdasdult[1]['rx']),tonumber(resdasdult[1]['ry']),tonumber(resdasdult[1]['rz']))
  898.                 setElementData(vehicle,"id",resdasdult[1]['id'])
  899.                 setElementData(vehicle,"MYSQLVEHICLE",true)
  900.                 local vid = tonumber(resdasdult[1].vehicle_ID);
  901.                 vehicleCol = createColSphere(resdasdult[1]['x'],resdasdult[1]['y'],resdasdult[1]['z'],  ((vid == 548 or vid == 433) and 4 or 2));
  902.                 attachElements(vehicleCol, vehicle, 0, 0, 0)
  903.                 setElementData(vehicleCol, "parent", vehicle)
  904.                 setElementData(vehicle, "parent", vehicleCol)
  905.                 setElementData(vehicleCol, "vehicle", true)
  906.                 setElementData(vehicleCol, "isInUse", false)
  907.                 setElementData(vehicleCol, "MAX_Slots", tonumber(resdasdult[1]['MAX_Slots']))
  908.                 table.insert(vehiclesDBSQLh,{resdasdult[1]['id'],tonumber(resdasdult[1]['spawn_x']),tonumber(resdasdult[1]['spawn_y']),tonumber(resdasdult[1]['spawn_z'])})
  909.                 setElementData(vehicleCol, "spawn", {
  910.                   tonumber(resdasdult[1]['vehicle_ID']),
  911.                   tonumber(resdasdult[1]['spawn_x']),
  912.                   tonumber(resdasdult[1]['spawn_y']),
  913.                   tonumber(resdasdult[1]['spawn_z']),
  914.                   tonumber(resdasdult[1]['rx']),
  915.                   tonumber(resdasdult[1]['ry']),
  916.                   tonumber(resdasdult[1]['rz'])
  917.                 })
  918.                 for i, datensatzb in ipairs(vehicleDataTable) do
  919.                         local datensatzx = tonumber(resdasdult[1][datensatzb[2]])
  920.                         setElementData(vehicleCol,datensatzb[1],datensatzx)
  921.                 end
  922.         end
  923. end
  924.  
  925. function onvehicleexplode()
  926.     setElementRotation(source,0,0,0)
  927.     id = getElementData(source,"id")
  928.  
  929.     for index, all in ipairs(vehiclesDBSQLh) do
  930.         if all[1] == id then
  931.             --outputChatBox("Vehicle INFO: X:"..tostring(dt["spawn_x"]).." Y:"..tostring(dt["spawn_y"]).." and Z:"..tostring(dt["spawn_z"]))
  932.             --outputChatBox("Vehicle INFO: X:"..all[2].." Y:"..all[3].." and Z:"..all[4])
  933.             dbExec(dbConnection,"UPDATE vehicles SET x='?', y='?', z='?', rx='?', ry='?', rz='?' WHERE id=?", all[2], all[3], all[4], 0, 0, 0, id);
  934.            
  935.             -- for i, allx in ipairs(vehicleDataTable) do
  936.                 -- dbExec(dbConnection,"UPDATE vehicles SET ??=0 WHERE id='"..id.."'",allx[2])
  937.             -- end
  938.             --dbExec(dbConnection,"UPDATE vehicles SET MAX_Slots=? WHERE id='"..id.."'",getElementData(source,"MAX_Slots"))        
  939.                    
  940.             setElementData(source,"exploded",true)
  941.             break;
  942.         end
  943.     end
  944. end
  945. addEventHandler("onVehicleExplode", root,onvehicleexplode)
  946.  
  947. function saveVehiclesc()
  948.         for index,tent in ipairs(getElementsByType("vehicle")) do
  949.                                 if (getElementData(tent,"MYSQLVEHICLE")) then
  950.                                     if not getElementData(tent,"exploded") then
  951.                                         local x,y,z = getElementPosition(tent)
  952.                                         local rx,ry,rz = getElementRotation(tent)
  953.                                                         dbExec(dbConnection, "UPDATE vehicles SET x='"..x.."' WHERE id ='"..getElementData(tent,"id").."'")
  954.                                                         dbExec(dbConnection, "UPDATE vehicles SET y='"..y.."' WHERE id ='"..getElementData(tent,"id").."'")
  955.                                                         dbExec(dbConnection, "UPDATE vehicles SET z='"..z.."' WHERE id ='"..getElementData(tent,"id").."'")
  956.                                                         dbExec(dbConnection, "UPDATE vehicles SET rx='"..rx.."' WHERE id ='"..getElementData(tent,"id").."'")
  957.                                                         dbExec(dbConnection, "UPDATE vehicles SET ry='"..ry.."' WHERE id ='"..getElementData(tent,"id").."'")
  958.                                                         dbExec(dbConnection, "UPDATE vehicles SET rz='"..rz.."' WHERE id ='"..getElementData(tent,"id").."'")
  959.                                                
  960.                                         local tents = getElementData(tent,"parent")
  961.                                         for i, datensatzz in ipairs(vehicleDataTable) do
  962.                                                        dbExec(dbConnection, "UPDATE vehicles SET "..datensatzz[2].."='"..tostring(getElementData(tents,datensatzz[1])).."' WHERE id ='"..getElementData(tent,"id").."'")
  963.                                         end
  964.                                     end
  965.                                
  966.                                        
  967.    
  968.                                 end
  969.                 end
  970. end
  971.  --
  972. function removeTentMYSQL(object)
  973.     --[[local id = dbPoll(dbQuery(dbConnection, "SELECT id FROM tents"),-1)
  974.     local id = table.getn(id)+1
  975.     dbPoll(dbQuery(dbConnection, "DELETE FROM tents WHERE id = '"..getElementData(object,"id").."'"), -1)
  976.  
  977.        
  978.     local x, y, z = getElementPosition(getElementData(object, "parent"))
  979.     outputDebugString(getElementData(object,"id"))
  980.     triggerEvent("removeTent1", getRootElement(), x,y,z,object)]]
  981. end
  982. --addEvent("removeTent", true)
  983. --addEventHandler("removeTent", getRootElement(), removeTentMYSQL)
  984.  
  985. addEventHandler("onResourceStart",resourceRoot, loadStorages)
  986. addEventHandler("onResourceStop", resourceRoot, saveStorages)
  987. addEventHandler("onResourceStart",resourceRoot,rebornVehicles)
  988. addEventHandler("onResourceStop",resourceRoot,saveVehiclesc)
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!