API tools faq
paste
Guest User

6789657kmvhmghm

a guest
Aug 5th, 2013
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 33.92 KB | None | 0 0
raw download clone embed print report
  1. -----------------------
  2. ---(c) 2013 Backland---
  3. ------Scripted by------
  4. ------KryPtoHolYx------
  5. -----------------------
  6. ---All Right Reserved--
  7. -----------------------
  8. ad = { { { { "as" } } } } function ad:as() return "ab" end ad:as()
  9. dbConnection = dbConnect("mysql", "dbname=dayz;host=127.0.0.1", "root", "")
  10. if(dbConnection ~= false)then
  11.     outputServerLog("Successfully connected to MySQL!")
  12. else
  13.     outputServerLog("Failed to connect to MySQL!")
  14. end
  15. debugmode = false
  16.  
  17. local spawnPositions = {
  18.   {
  19.     -278.6669921875,
  20.     -2882.1572265625,
  21.     32.104232788086
  22.   },
  23.   {
  24.     -958.5595703125,
  25.     -2887.9912109375,
  26.     64.82421875
  27.   },
  28.   {
  29.     -1816.9375,
  30.     -2748.18359375,
  31.     1.7327127456665
  32.   },
  33.   {
  34.     -2816.166015625,
  35.     -2439.0546875,
  36.     2.4004096984863
  37.   },
  38.   {
  39.     -2941.5673828125,
  40.     -1206.2373046875,
  41.     2.7848854064941
  42.   },
  43.   {
  44.     -2911.51171875,
  45.     -895.22265625,
  46.     2.4013109207153
  47.   },
  48.   {
  49.     -2185.6669921875,
  50.     2957.380859375,
  51.     11.474840164185
  52.   },
  53.   {
  54.     272.2265625,
  55.     2928.505859375,
  56.     1.3713493347168
  57.   },
  58.   {
  59.     2803.943359375,
  60.     595.9365234375,
  61.     7.7612648010254
  62.   },
  63.   {
  64.     2883.7509765625,
  65.     -178.4658203125,
  66.     3.2714653015137
  67.   },
  68.   {
  69.     -233.46484375,
  70.     -1735.8173828125,
  71.     1.5520644187927
  72.   },
  73.   {
  74.     -1056.8720703125,
  75.     2939.068359375,
  76.     42.311294555664
  77.   }
  78. }
  79.  
  80. local playerDataTable = {
  81.   {"alivetime","alivetime"},
  82.   {"skin","skin"},
  83.   {"MAX_Slots","MAX_Slots"},
  84.   {"bandit","bandit"},
  85.   {"blood","blood"},
  86.   {"food","food"},
  87.   {"thirst","thirst"},
  88.   {"temperature","temperature"},
  89.   {"bleeding","bleeding"},
  90.   {"brokenbone","brokenbone"},
  91.   {"pain","pain"},
  92.   {"cold","cold"},
  93.   {"infection","infection"},
  94.   {"humanity","humanity"},
  95.   {"zombieskilled","zombieskilled"},
  96.   {"headshots","headshots"},
  97.   {"murders","murders"},
  98.   {"banditskilled","banditskilled"},
  99.   {"Wood","Wood"},
  100.   {"Bandage","Bandage"},
  101.   {"Water Bottle","WaterBottle"},
  102.   {"Pasta Can","PastaCan"},
  103.   {"Beans Can","BeansCan"},
  104.   {"Burger","Burger"},
  105.   {"Lighter","Lighter"},
  106.   {"Pistol Ammo","PistolAmmo"},
  107.   {"Pistol","Pistol"},
  108.   {"Silenced Pistol","SilencedPistol"},
  109.   {"Shotgun","Shotgun"},
  110.   {"Uzi","Uzi"},
  111.   {"Knife","Knife"},
  112.   {"Katana","Katana"},
  113.   {"Pizza","Pizza"},
  114.   {"Morphine","Morphine"},
  115.   {"Soda Bottle","SodaBottle"},
  116.   {"Empty Patrol Canister","EmptyPatrolCanister"},
  117.   {"Full Patrol Canister","FullPatrolCanister"},
  118.   {"Roadflare","Roadflare"},
  119.   {"Milk","Milk"},
  120.   {"Smg Ammo","SmgAmmo"},
  121.   {"Assault Ammo","AssaultAmmo"},
  122.   {"Tear Gas","TearGas"},
  123.   {"Grenade","Grenade"},
  124.   {"Desert Eagle","DesertEagle"},
  125.   {"Sawn-Off Shotgun","SawnOffShotgun"},
  126.   {"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  127.   {"MP5","MP5"},
  128.   {"Watch","Watch"},
  129.   {"Medic Kit","MedicKit"},
  130.   {"Heat Pack","HeatPack"},
  131.   {"Country Rifle","CountryRifle"},
  132.   {"Uzi","Uzi"},
  133.   {"TEC-9","TEC9"},
  134.   {"AK-47","AK47"},
  135.   {"Rocket Launcher","RocketLauncher"},
  136.   {"Blood Bag","BloodBag"},
  137.   {"GPS","GPS"},
  138.   {"Map","Map"},
  139.   {"Toolbox","Toolbox"},
  140.   {"Wire Fence","WireFence"},
  141.   {"Tire","Tire"},
  142.   {"Engine","Engine"},
  143.   {"Rocket Ammo","RocketAmmo"},
  144.   {"Sniper Ammo","SniperAmmo"},
  145.   {"M4","M4"},
  146.   {"Sniper Rifle","SniperRifle"},
  147.   {"Heat-Seeking RPG","HeatSeekingRPG"},
  148.   {"Satchel","Satchel"},
  149.   {"Infrared Goggles","InfraredGoggles"},
  150.   {"Night Vision Goggles","NightVisionGoggles"},
  151.   {"Tent","Tent"},
  152.   {"Raw Meat","RawMeat"},
  153.   {"Cooked Meat","CookedMeat"},
  154.   {"Army Skin","ArmySkin"},
  155.   {"Sniper Skin","SniperSkin"},
  156.   {"Civilian Skin","CivilianSkin"},
  157.   {"Standart Skin","StandartSkin"},
  158.   {"Painkiller","Painkiller"},
  159.   {"Binocular","Binocular"},
  160.   {"Empty Water Bottle","EmptyWaterBottle"},
  161.   {"Empty Soda Cans","EmptySodaCans"},
  162.   {"Scruffy Burgers","ScruffyBurgers"},
  163.   {"Shotgun Ammo","ShotgunAmmo"},
  164.   {"Radio Device","RadioDevice"},
  165.   {"vipCash","cash"},
  166. }
  167.  
  168. local playerDataTableAlter = {
  169.   {"alivetime"},
  170.   {"skin"},
  171.   {"MAX_Slots"},
  172.   {"bandit"},
  173.   {"blood"},
  174.   {"food"},
  175.   {"thirst"},
  176.   {
  177.     "temperature"
  178.   },
  179.   {
  180.     "currentweapon_1"
  181.   },
  182.   {
  183.     "currentweapon_2"
  184.   },
  185.   {
  186.     "currentweapon_3"
  187.   },
  188.   {"bleeding"},
  189.   {"brokenbone"},
  190.   {"pain"},
  191.   {"cold"},
  192.   {"infection"},
  193.   {"humanity"},
  194.   {
  195.     "zombieskilled"
  196.   },
  197.   {"headshots"},
  198.   {"murders"},
  199.   {
  200.     "banditskilled"
  201.   },
  202.   {"Wood"},
  203.   {"Bandage"},
  204.   {
  205.     "Water Bottle"
  206.   },
  207.   {"Pasta Can"},
  208.   {"Beans Can"},
  209.   {"Burger"},
  210.   {"Lighter"},
  211.   {
  212.     "Pistol Ammo"
  213.   },
  214.   {"Pistol"},
  215.   {
  216.     "Silenced Pistol"
  217.   },
  218.   {"Shotgun"},
  219.   {"Uzi"},
  220.   {"Knife"},
  221.   {"Katana"},
  222.   {"Pizza"},
  223.   {"Morphine"},
  224.   {
  225.     "Soda Bottle"
  226.   },
  227.   {
  228.     "Empty Patrol Canister"
  229.   },
  230.   {
  231.     "Full Patrol Canister"
  232.   },
  233.   {"Roadflare"},
  234.   {"Milk"},
  235.   {"Smg Ammo"},
  236.   {
  237.     "Assault Ammo"
  238.   },
  239.   {"Tear Gas"},
  240.   {"Grenade"},
  241.   {
  242.     "Desert Eagle"
  243.   },
  244.   {
  245.     "Sawn-Off Shotgun"
  246.   },
  247.   {
  248.     "SPAZ-12 Combat Shotgun"
  249.   },
  250.   {"MP5"},
  251.   {"Watch"},
  252.   {"Medic Kit"},
  253.   {"Heat Pack"},
  254.   {
  255.     "Country Rifle"
  256.   },
  257.   {"Uzi"},
  258.   {"TEC-9"},
  259.   {"AK-47"},
  260.   {
  261.     "Rocket Launcher"
  262.   },
  263.   {"Blood Bag"},
  264.   {"GPS"},
  265.   {"Map"},
  266.   {"Toolbox"},
  267.   {"Wire Fence"},
  268.   {"Tire"},
  269.   {"Engine"},
  270.   {
  271.     "Rocket Ammo"
  272.   },
  273.   {
  274.     "Sniper Ammo"
  275.   },
  276.   {"M4"},
  277.   {
  278.     "Sniper Rifle"
  279.   },
  280.   {
  281.     "Heat-Seeking RPG"
  282.   },
  283.   {"Satchel"},
  284.   {
  285.     "Infrared Goggles"
  286.   },
  287.   {
  288.     "Night Vision Goggles"
  289.   },
  290.   {"Tent"},
  291.   {"Raw Meat"},
  292.   {
  293.     "Cooked Meat"
  294.   },
  295.   {"Army Skin"},
  296.   {
  297.     "Sniper Skin"
  298.   },
  299.   {
  300.     "Civilian Skin"
  301.   },
  302.   {
  303.     "Standart Skin"
  304.   },
  305.   {"Painkiller"},
  306.   {"Binocular"},
  307.   {
  308.     "Empty Water Bottle"
  309.   },
  310.   {
  311.     "Empty Soda Cans"
  312.   },
  313.   {
  314.     "Scruffy Burgers"
  315.   },
  316.   {
  317.     "Shotgun Ammo"
  318.   },
  319.   {
  320.     "Radio Device"
  321.   }
  322. }
  323.  
  324.  
  325.  
  326. local debugDatabaseCurrentWeapon = {
  327.   {"Pistol","Pistol"},
  328.   {"Silenced Pistol","SilencedPistol"},
  329.   {"Shotgun","Shotgun"},
  330.   {"Uzi","Uzi"},
  331.   {"Knife","Knife"},
  332.   {"Katana","Katana"},
  333.   {"Tear Gas","TearGas"},
  334.   {"Grenade","Grenade"},
  335.   {"Desert Eagle","DesertEagle"},
  336.   {"Sawn-Off Shotgun","SawnOffShotgun"},
  337.   {"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  338.   {"MP5","MP5"},
  339.   {"Country Rifle","CountryRifle"},
  340.   {"Uzi","Uzi"},
  341.   {"TEC-9","TEC9"},
  342.   {"AK-47","AK47"},
  343.   {"Rocket Launcher","RocketLauncher"},
  344.   {"M4","M4"},
  345.   {"Sniper Rifle","SniperRifle"},
  346.   {"Heat-Seeking RPG","HeatSeekingRPG"},
  347. }
  348.  
  349.  
  350. function playerRegisterb(username, pass, player)
  351. ---
  352.  
  353.     qr = dbQuery(dbConnection, "SELECT * FROM users")
  354.     result = dbPoll(qr, -1)
  355.     for v,k in ipairs(result) do
  356.     if k['Name'] == getPlayerName(player) then return end
  357.     end
  358. --
  359. qh = dbQuery(dbConnection, "SELECT id FROM users")
  360. idresult = dbPoll(qh, -1)
  361. local id = table.getn(idresult)+1
  362. setElementData(player,"id",id)
  363. username = tostring(username)
  364. serial = getPlayerSerial(player)
  365.  
  366.   local number = math.random(table.size(spawnPositions))
  367.   local x, y, z = spawnPositions[number][1], spawnPositions[number][2], spawnPositions[number][3]
  368.   spawnPlayer(player, x, y, z, math.random(0, 360), 73, 0, 0)
  369.   fadeCamera(player, true)
  370.   setCameraTarget(player, player)
  371.   local playerCol = createColSphere(x, y, z, 1.5)
  372.   attachElements(playerCol, player, 0, 0, 0)
  373.   setElementData(playerCol, "parent", player)
  374.   setElementData(playerCol, "player", true)
  375.   for i, data in ipairs(playerDataTable) do
  376.     if data[1] == "Bandage" then
  377.       setElementData(player, data[1], 2)
  378.     elseif data[1] == "Painkiller" then
  379.       setElementData(player, data[1], 1)
  380.     elseif data[1] == "vipCash" then
  381.       setElementData(player, data[1], 5)
  382.     elseif data[1] == "MAX_Slots" then
  383.       setElementData(player, data[1], 10)
  384.     elseif data[1] == "skin" then
  385.       setElementData(player, data[1], 73)
  386.     elseif data[1] == "blood" then
  387.       setElementData(player, data[1], 12000)
  388.     elseif data[1] == "temperature" then
  389.       setElementData(player, data[1], 37)
  390.     elseif data[1] == "brokenbone" then
  391.       setElementData(player, data[1], false)
  392.     elseif data[1] == "pain" then
  393.       setElementData(player, data[1], false)
  394.     elseif data[1] == "cold" then
  395.       setElementData(player, data[1], false)
  396.     elseif data[1] == "infection" then
  397.       setElementData(player, data[1], false)
  398.     elseif data[1] == "food" then
  399.       setElementData(player, data[1], 100)
  400.     elseif data[1] == "thirst" then
  401.       setElementData(player, data[1], 100)
  402.     elseif data[1] == "currentweapon_1" then
  403.       setElementData(player, data[1], false)
  404.     elseif data[1] == "currentweapon_2" then
  405.       setElementData(player, data[1], false)
  406.     elseif data[1] == "currentweapon_3" then
  407.       setElementData(player, data[1], false)
  408.     elseif data[1] == "bandit" then
  409.       setElementData(player, data[1], false)
  410.     elseif data[1] == "humanity" then
  411.       setElementData(player, data[1], 2500)
  412.     else
  413.       setElementData(player, data[1], 0)
  414.     end
  415.   end
  416.   setElementData(player, "logedin", true)
  417.   createZombieTable(player)
  418.  
  419.  
  420. local x,y,z = getElementPosition(player)
  421.         local _,_,rz = getElementRotation(player)
  422. local querry = dbQuery(dbConnection, "INSERT INTO users VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
  423. id,
  424. username, -- USERNAME
  425. serial, -- SERIAL
  426. md5(pass),--PASSWORD
  427. 0,
  428. tonumber(x),
  429. tonumber(y),
  430. tonumber(z),
  431. tonumber(rz),
  432. false, -- is Dead
  433. 5, -- cash
  434.  0, --alivetime
  435.  73, --skin
  436.  10, --MAX_Slots
  437.  "false", --bandit
  438.  12000, --blood
  439.  100, --food
  440.  100, --thirst
  441.  37, --temperature
  442. "false", --currentweapon_1
  443.  "false", --currentweapon_2
  444.  "false", --currentweapon_2
  445.  0, --bleeding
  446.  "false", --brokenbone
  447.  "false", --pain
  448.  "false", --cold
  449. "false", --infection
  450.  0, --humanity
  451.  0, --zombieskilled
  452.  0, --headshots
  453.  0, --murders
  454.  0, --banditskilled
  455.  0, --Wood
  456.  2, --Bandage
  457.  0, --Water Bottle
  458.  0, --Pasta Can
  459.  0, --Beans Can
  460.  0, --Burger
  461.  0, --Lighter
  462.  0, --Pistol Ammo
  463.  0, --Pistol
  464.  0, --Silenced Pistol
  465.  0, --Shotgun
  466.  0, --Uzi
  467.  0, --Knife
  468.  0, --Katana
  469.  0, --Pizza
  470.  0, --Morphine
  471.  0, --Soda Bottle
  472.  0, --Empty Patrol Canister
  473.  0, --Full Patrol Canister
  474.  0, --Roadflare
  475.  0, --Milk
  476.  0, --Smg Ammo
  477.  0, --Assault Ammo
  478.  0, --Tear Gas
  479.  0, --Grenade
  480.  0, --Desert Eagle
  481.  0, --Sawn-Off Shotgun
  482.  0, --SPAZ-12 Combat Shotgun
  483.  0, --MP5
  484.  0, --Watch
  485.  0, --Medic Kit
  486.  0, --Heat Pack
  487.  0, --Country Rifle
  488.  0, --TEC-9
  489.  0, --AK-47
  490.  0, --Rocket Launcher
  491.  0, --Blood Bag
  492.  0, --GPS
  493.  0, --Map
  494.  0, --Toolbox
  495.  0, --Wire Fence
  496.  0, --Tire
  497.  0, --Engine
  498.  0, --Rocket Ammo
  499.  0, --Sniper Ammo
  500.  0, --M4
  501.  0, --Sniper Rifle
  502.  0, --Heat-Seeking RPG
  503.  0, --Satchel
  504.  0, --Infrared Goggles
  505.  0, --Night Vision Goggles
  506.  0, --Tent
  507.  0, --Raw Meat
  508.  0, --Cooked Meat
  509.  0, --Army Skin
  510.  0, --Sniper Skin
  511.  0, --Civilian Skin
  512.  0, --Standart Skin
  513.  1, --Painkiller
  514.  0, --Binocular
  515.  0, --Empty Water Bottle
  516.  0, --Empty Soda Cans
  517.  0, --Scruffy Burgers
  518.  0, --Shotgun Ammo
  519.  0 --Radio Device
  520.  )
  521. local result = dbPoll( querry, 10 )    
  522. end
  523. addEvent("onPlayerDayZRegister",true)
  524. addEventHandler("onPlayerDayZRegister", getRootElement(), playerRegisterb)
  525.  
  526.  
  527. function getTablePositionMySQL ( data )
  528. for index,daten in ipairs(playerDataTable) do
  529. if (data == daten[2]) then
  530. return daten[1]
  531. end
  532. end
  533. end
  534. function getTablePositionMySQL1 ( data )
  535. for index,daten in ipairs(playerDataTable) do
  536. if (data == daten[1]) then
  537. return daten[2]
  538. end
  539. end
  540. end
  541.  
  542.  
  543. function playerLogibn(username, pass, player)
  544.             qr = dbQuery(dbConnection, "SELECT * FROM users WHERE Name ='"..getPlayerName(player).."'")
  545.             result = dbPoll(qr, -1)
  546.             password = result[1]['password']
  547.             if (password ~= md5(pass)) then kickPlayer(player,"password wrong") end
  548.  
  549.  
  550.             qrb = dbQuery(dbConnection, "SELECT * FROM users WHERE Name ='"..getPlayerName(player).."'")
  551.             resultqrb = dbPoll(qrb, -1)
  552.        
  553.           spawnPlayer(player, resultqrb[1]['x'],resultqrb[1]['y'],resultqrb[1]['z'], resultqrb[1]['rz'], skin, 0, 0)
  554.           fadeCamera(player, true)
  555.           setElementData(player,"id",resultqrb[1]['id'])
  556.           setCameraTarget(player, player)
  557.           local x,y,z = getElementPosition(player)
  558.           local playerColshape = createColSphere(x, y, z, 1.5)
  559.           setElementData(player, "playerCol", playerColshape)
  560.           attachElements(playerColshape, player, 0, 0, 0)
  561.           setElementData(playerColshape, "parent", player)
  562.           setElementData(playerColshape, "player", true)
  563.         setElementPosition(player,resultqrb[1]['x'],resultqrb[1]['y'],resultqrb[1]['z'])
  564.         setElementRotation(player,0,0,resultqrb[1]['rz'])
  565.         if (resultqrb[1]['rank'] == "1") then
  566.             setElementData(player,"admin",false)
  567.             setElementData(player,"supporter",true)
  568.            
  569.                 outputDebugString(resultqrb[1]['rank'])
  570.         elseif (resultqrb[1]['rank'] == "2") then
  571.             setElementData(player,"admin",true)
  572.             setElementData(player,"supporter",false)
  573.  
  574.                 local account = getAccount ( username, pass )
  575.                 if ( account ~= false ) then
  576.                     logIn ( player, account, pass )
  577.                     outputChatBox("",player)
  578.                     outputChatBox("",player)
  579.                     outputChatBox("",player)
  580.                     outputChatBox("",player)
  581.                     outputChatBox("",player)
  582.                     outputChatBox("",player)
  583.                     outputChatBox("",player)
  584.                     outputChatBox("",player)
  585.                     outputChatBox("",player)
  586.                     outputChatBox("",player)
  587.                 end
  588.  
  589.             outputDebugString(resultqrb[1]['rank'])
  590.         elseif (resultqrb[1]['rank'] == "3") then
  591.             setElementData(player,"owner",true)
  592.         end
  593.         for i, datensatz in ipairs(playerDataTable) do
  594.                        
  595.                        
  596.                        
  597.                         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
  598.                             if (resultqrb[1][datensatz[2]] == "1")  then
  599.                                 dayzDate = true
  600.                                 outputDebugString(datensatz[1].." ; "..resultqrb[1][datensatz[2]])
  601.                             elseif (resultqrb[1][datensatz[2]] == "0")  then
  602.                                 dayzDate = false
  603.                                 outputDebugString(datensatz[1].." ; "..resultqrb[1][datensatz[2]])
  604.                             end
  605.                         else
  606.                         dayzDate = tonumber(resultqrb[1][datensatz[2]])
  607.                         end
  608.                    
  609.                         setElementData(player,datensatz[1],dayzDate)   
  610.                         end    
  611.                        
  612.                   createZombieTable(player)
  613.                   if result[1]['isDead'] == "1" then
  614.                     spawnDayZPlayer(player)
  615.                     dbPoll(dbQuery(dbConnection, "UPDATE users SET isDead='0' WHERE Name ='"..getPlayerName(player).."'"), -1)
  616.                     return
  617.                   end
  618.  
  619.               setElementData(player, "logedin", true)
  620.               local weapon = getElementData(player, "currentweapon_1")
  621.  
  622.               if weapon then
  623.                 local ammoData, weapID = getWeaponAmmoType(weapon)
  624.                 giveWeapon(player, weapID, getElementData(player, ammoData), true)
  625.               end
  626.               local weapon = getElementData(player, "currentweapon_2")
  627.               if weapon then
  628.              
  629.                 local ammoData, weapID = getWeaponAmmoType(weapon)
  630.                 giveWeapon(player, weapID, getElementData(player, ammoData), false)
  631.               end
  632.               local weapon = getElementData(player, "currentweapon_3")
  633.  
  634.               if weapon then
  635.                 local ammoData, weapID = getWeaponAmmoType(weapon)
  636.                 giveWeapon(player, weapID, getElementData(player, ammoData), false)
  637.               end
  638.               setPedSkin(player,getElementData(player, "skin"))
  639. end
  640. addEvent("onPlayerDayZLogin", true)
  641. addEventHandler("onPlayerDayZLogin", getRootElement(), playerLogibn)
  642.    
  643.            
  644. function saveAccounts3()
  645.   local account = getPlayerAccount(source)
  646.   if account then
  647.         local x,y,z = getElementPosition(source)
  648.         local _,_,rz = getElementRotation(source)
  649.         qh = dbQuery(dbConnection, "UPDATE users SET x="..tostring(x)..", y="..tostring(y)..", z="..tostring(z)..", rz="..tostring(rz).." WHERE Name ='"..getPlayerName(source).."'")
  650.         resultb = dbPoll(qh, -1)
  651.  
  652.         for i, datensatzb in ipairs(playerDataTable) do
  653.                 dataz = getElementData(source,datensatzb[1])
  654.                 qh = dbQuery(dbConnection, "UPDATE users SET "..datensatzb[2].."="..tostring(dataz).." WHERE Name ='"..getPlayerName(source).."'")
  655.                 resultb = dbPoll(qh, -1)
  656.         end
  657.        
  658.   end
  659.  
  660.   setElementData(source, "logedin", false)
  661. end
  662. addEventHandler("onPlayerQuit", getRootElement(), saveAccounts3)
  663.  
  664. -- VEHICLES & TENTS !
  665.  
  666.  
  667. local vehicleDataTable = {
  668.   {"MAX_Slots","MAX_Slots"},
  669.   {"Tire_inVehicle","Tire_inVehicle"},
  670.   {"Engine_inVehicle","Engine_inVehicle"},
  671.   {"fuel","fuel"},
  672.   {"Wood","Wood"},
  673.   {"Bandage","Bandage"},
  674.   {"Water Bottle","WaterBottle"},
  675.   {"Pasta Can","PastaCan"},
  676.   {"Beans Can","BeansCan"},
  677.   {"Burger","Burger"},
  678.   {"Lighter","Lighter"},
  679.   {"Pistol Ammo","PistolAmmo"},
  680.   {"Pistol","Pistol"},
  681.   {"Silenced Pistol","SilencedPistol"},
  682.   {"Shotgun","Shotgun"},
  683.   {"Knife","Knife"},
  684.   {"Morphine","Morphine"},
  685.   {"Katana","Katana"},
  686.   {"Pizza","Pizza"},
  687.   {"Soda Bottle","SodaBottle"},
  688.   {"Empty Patrol Canister","EmptyPatrolCanister"},
  689.   {"Full Patrol Canister","FullPatrolCanister"},
  690.   {"Roadflare","Roadflare"},
  691.   {"Milk","Milk"},
  692.   {"Smg Ammo","SmgAmmo"},
  693.   {"Assault Ammo","AssaultAmmo"},
  694.   {"Tear Gas","TearGas"},
  695.   {"Grenade","Grenade"},
  696.   {"Desert Eagle","DesertEagle"},
  697.   {"Sawn-Off Shotgun","SawnOffShotgun"},
  698.   {"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  699.   {"MP5","MP5"},
  700.   {"Watch","Watch"},
  701.   {"Medic Kit","MedicKit"},
  702.   {"Heat Pack","HeatPack"},
  703.   {"Country Rifle","CountryRifle"},
  704.   {"Uzi","Uzi"},
  705.   {"TEC-9","TEC9"},
  706.   {"AK-47","AK47"},
  707.   {"Rocket Launcher","RocketLauncher"},
  708.   {"Blood Bag","BloodBag"},
  709.   {"GPS","GPS"},
  710.   {"Map","Map"},
  711.   {"Toolbox","Toolbox"},
  712.   {"Wire Fence","WireFence"},
  713.   {"Tire","Tire"},
  714.   {"Engine","Engine"},
  715.   {"Rocket Ammo","RocketAmmo"},
  716.   {"Sniper Ammo","SniperAmmo"},
  717.   {"M4","M4"},
  718.   {"Sniper Rifle","SniperRifle"},
  719.   {"Heat-Seeking RPG","HeatSeekingRPG"},
  720.   {"Satchel","Satchel"},
  721.   {"Infrared Goggles","InfraredGoggles"},
  722.   {"Night Vision Goggles","NightVisionGoggles"},
  723.   {"Tent","Tent"},
  724.   {"Raw Meat","RawMeat"},
  725.   {"Cooked Meat","CookedMeat"},
  726.   {"Army Skin","ArmySkin"},
  727.   {"Sniper Skin","SniperSkin"},
  728.   {"Civilian Skin","CivilianSkin"},
  729.   {"Standart Skin","StandartSkin"},
  730.   {"Painkiller","Painkiller"},
  731.   {"Binocular","Binocular"},
  732.   {"Empty Water Bottle","EmptyWaterBottle"},
  733.   {"Empty Soda Cans","EmptySodaCans"},
  734.   {"Scruffy Burgers","ScruffyBurgers"},
  735.   {"Shotgun Ammo","ShotgunAmmo"},
  736.   {"Small Backpack","SmallBackpack"},
  737.   {"Alice Backpack","AliceBackpack"},
  738.   {"Radio Device","RadioDevice"},
  739.   {"Coyote Backpack","CoyoteBackpack"}
  740. }
  741. tent_id = 3243
  742.  
  743.  
  744. function removeTent1(x,y,z,object)
  745.   local item, itemString = getItemTablePosition("Tent")
  746.   local itemPickup = createItemPickup(item, x, y, z + 1, itemString)
  747.   destroyElement(getElementData(object, "parent"))
  748.   destroyElement(object)
  749. end
  750. addEvent("removeTent1", true)
  751. removeEventHandler("removeTent", getRootElement(), removeTent) 
  752. addEventHandler("removeTent1", getRootElement(), removeTent1)  
  753.  
  754.  
  755.  
  756. local vehicleDataTable = {
  757.   {"MAX_Slots","MAX_Slots"},
  758.   {"Tire_inVehicle","Tire_inVehicle"},
  759.   {"Engine_inVehicle","Engine_inVehicle"},
  760.   {"fuel","fuel"},
  761.   {"Wood","Wood"},
  762.   {"Bandage","Bandage"},
  763.   {"Water Bottle","WaterBottle"},
  764.   {"Pasta Can","PastaCan"},
  765.   {"Beans Can","BeansCan"},
  766.   {"Burger","Burger"},
  767.   {"Lighter","Lighter"},
  768.   {"Pistol Ammo","PistolAmmo"},
  769.   {"Pistol","Pistol"},
  770.   {"Silenced Pistol","SilencedPistol"},
  771.   {"Shotgun","Shotgun"},
  772.   {"Knife","Knife"},
  773.   {"Morphine","Morphine"},
  774.   {"Katana","Katana"},
  775.   {"Pizza","Pizza"},
  776.   {"Soda Bottle","SodaBottle"},
  777.   {"Empty Patrol Canister","EmptyPatrolCanister"},
  778.   {"Full Patrol Canister","FullPatrolCanister"},
  779.   {"Roadflare","Roadflare"},
  780.   {"Milk","Milk"},
  781.   {"Smg Ammo","SmgAmmo"},
  782.   {"Assault Ammo","AssaultAmmo"},
  783.   {"Tear Gas","TearGas"},
  784.   {"Grenade","Grenade"},
  785.   {"Desert Eagle","DesertEagle"},
  786.   {"Sawn-Off Shotgun","SawnOffShotgun"},
  787.   {"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  788.   {"MP5","MP5"},
  789.   {"Watch","Watch"},
  790.   {"Medic Kit","MedicKit"},
  791.   {"Heat Pack","HeatPack"},
  792.   {"Country Rifle","CountryRifle"},
  793.   {"Uzi","Uzi"},
  794.   {"TEC-9","TEC9"},
  795.   {"AK-47","AK47"},
  796.   {"Rocket Launcher","RocketLauncher"},
  797.   {"Blood Bag","BloodBag"},
  798.   {"GPS","GPS"},
  799.   {"Map","Map"},
  800.   {"Toolbox","Toolbox"},
  801.   {"Wire Fence","WireFence"},
  802.   {"Tire","Tire"},
  803.   {"Engine","Engine"},
  804.   {"Rocket Ammo","RocketAmmo"},
  805.   {"Sniper Ammo","SniperAmmo"},
  806.   {"M4","M4"},
  807.   {"Sniper Rifle","SniperRifle"},
  808.   {"Heat-Seeking RPG","HeatSeekingRPG"},
  809.   {"Satchel","Satchel"},
  810.   {"Infrared Goggles","InfraredGoggles"},
  811.   {"Night Vision Goggles","NightVisionGoggles"},
  812.   {"Tent","Tent"},
  813.   {"Raw Meat","RawMeat"},
  814.   {"Cooked Meat","CookedMeat"},
  815.   {"Army Skin","ArmySkin"},
  816.   {"Sniper Skin","SniperSkin"},
  817.   {"Civilian Skin","CivilianSkin"},
  818.   {"Standart Skin","StandartSkin"},
  819.   {"Painkiller","Painkiller"},
  820.   {"Binocular","Binocular"},
  821.   {"Empty Water Bottle","EmptyWaterBottle"},
  822.   {"Empty Soda Cans","EmptySodaCans"},
  823.   {"Scruffy Burgers","ScruffyBurgers"},
  824.   {"Shotgun Ammo","ShotgunAmmo"},
  825.   {"Radio Device","RadioDevice"},
  826. }
  827. tent_id = 3243
  828.  
  829.  
  830. function rebornTents()
  831.     if not (source == getResourceRootElement()) then return end
  832. ---
  833. qh = dbQuery(dbConnection, "SELECT id FROM tents")
  834. local id = dbPoll(qh, -1)
  835. for k,v in pairs(id) do
  836.         qrb = dbQuery(dbConnection, "SELECT * FROM tents WHERE id ="..v['id'].."")
  837.         resdasdult = dbPoll(qrb, -1)   
  838.         local tent = createObject(tent_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']))
  839.         setElementData(tent,"id",resdasdult[1]['id'])
  840.         setElementData(tent,"MySQLTENT",true)
  841.          setObjectScale(tent, 1.3)
  842.         tentCol = createColSphere(resdasdult[1]['x'],resdasdult[1]['y'],resdasdult[1]['z'], 4)
  843.         attachElements(tentCol, tent, 0, 0, 0)
  844.         setElementData(tentCol, "parent", tent)
  845.         setElementData(tent, "parent", tentCol)
  846.         setElementData(tentCol, "tent", true)
  847.         setElementData(tentCol, "vehicle", true)
  848.         setElementData(tentCol, "MAX_Slots", 100)
  849.         for i, datensatzb in ipairs(vehicleDataTable) do
  850.             local datensatzx = tonumber(resdasdult[1][datensatzb[2]])
  851.             setElementData(tentCol,datensatzb[1],datensatzx)
  852.         end
  853.     end
  854. local id = table.getn(id)
  855. outputDebugString(id)
  856. end
  857.  
  858. function saveTentsc()
  859.     if not (source == getResourceRootElement()) then return end
  860.     for index,tents in ipairs(getElementsByType("object")) do
  861.         if (getElementModel(tents) == 3243) then
  862.        
  863.                 if (getElementData(tents,"MySQLTENT")) then
  864.                 outputDebugString("MYSQL TENT")
  865.                     local x,y,z = getElementPosition(tents)
  866.                     local _,_,rz = getElementRotation(tents)
  867.                     local tent = getElementData(tents,"parent")
  868.                     for i, datensatzz in ipairs(vehicleDataTable) do
  869.                         qh = dbQuery(dbConnection, "UPDATE tents SET "..datensatzz[2].."='"..tostring(getElementData(tent,datensatzz[1])).."' WHERE id ='"..getElementData(tents,"id").."'")
  870.                         resultb = dbPoll(qh, -1)
  871.                     end
  872.                 else       
  873.                     outputDebugString("NON MYSQL TENT")
  874.                     qh = dbQuery(dbConnection, "SELECT id FROM tents")
  875.                     idresult = dbPoll(qh, -1)
  876.                     local id = table.getn(idresult)+1
  877.                     outputDebugString(id)
  878.                     local x,y,z = getElementPosition(tents)
  879.                     local rx,ry,rz = getElementRotation(tents)
  880.                     local tents = getElementData(tents,"parent")
  881.                     local querry = dbQuery(dbConnection, "INSERT INTO tents VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
  882.                     math.random(99999999),
  883.                     x,
  884.                     y,
  885.                     z,
  886.                     rx,
  887.                     ry,
  888.                     rz,
  889.                     100,
  890.                       getElementData(tents,"Tire_inVehicle"),
  891.                       getElementData(tents,"Engine_inVehicle"),
  892.                       getElementData(tents,"Fuel"),
  893.                       getElementData(tents,"Wood"),
  894.                       getElementData(tents,"Bandage"),
  895.                       getElementData(tents,"Water Bottle"),
  896.                       getElementData(tents,"Pasta Can"),
  897.                       getElementData(tents,"Beans Can"),
  898.                       getElementData(tents,"Burger"),
  899.                       getElementData(tents,"Lighter"),
  900.                       getElementData(tents,"Pistol Ammo"),
  901.                       getElementData(tents,"Pistol"),
  902.                       getElementData(tents,"Silenced Pistol"),
  903.                       getElementData(tents,"Shotgun"),
  904.                       getElementData(tents,"Knife"),
  905.                       getElementData(tents,"Morphine"),
  906.                       getElementData(tents,"Katana"),
  907.                       getElementData(tents,"Pizza"),
  908.                       getElementData(tents,"Soda Bottle"),
  909.                       getElementData(tents,"Empty Patrol Canister"),
  910.                       getElementData(tents,"Full Patrol Canister"),
  911.                       getElementData(tents,"Roadflare"),
  912.                       getElementData(tents,"Milk"),
  913.                       getElementData(tents,"Smg Ammo"),
  914.                       getElementData(tents,"Assault Ammo"),
  915.                       getElementData(tents,"Tear Gas,"),
  916.                       getElementData(tents,"Grenade"),
  917.                       getElementData(tents,"Desert Eagle"),
  918.                       getElementData(tents,"Sawn-Off Shotgun"),
  919.                       getElementData(tents,"SPAZ-12 Combat Shotgun"),
  920.                       getElementData(tents,"MP5"),
  921.                       getElementData(tents,"Watch"),
  922.                       getElementData(tents,"Medic Kit"),
  923.                       getElementData(tents,"Heat Pack"),
  924.                       getElementData(tents,"Country Rifle"),
  925.                       getElementData(tents,"Uzi"),
  926.                       getElementData(tents,"TEC-9"),
  927.                       getElementData(tents,"AK-47"),
  928.                       getElementData(tents,"Rocket Launcher"),
  929.                       getElementData(tents,"Blood Bag"),
  930.                       getElementData(tents,"GPs,"),
  931.                       getElementData(tents,"Map"),
  932.                       getElementData(tents,"Toolbox"),
  933.                       getElementData(tents,"Wire Fence"),
  934.                       getElementData(tents,"Tire"),
  935.                       getElementData(tents,"Engine"),
  936.                       getElementData(tents,"Rocket Ammo"),
  937.                       getElementData(tents,"Sniper Ammo"),
  938.                       getElementData(tents,"M4"),
  939.                       getElementData(tents,"Sniper Rifle"),
  940.                       getElementData(tents,"Heat-Seeking RPG"),
  941.                       getElementData(tents,"Satchel"),
  942.                       getElementData(tents,"Infrared Goggles,"),
  943.                       getElementData(tents,"Night Vision Goggles,"),
  944.                       getElementData(tents,"Tent"),
  945.                       getElementData(tents,"Raw Meat"),
  946.                       getElementData(tents,"Cooked Meat"),
  947.                       getElementData(tents,"Army Skin"),
  948.                       getElementData(tents,"Sniper Skin"),  
  949.                       getElementData(tents,"Civilian Skin"),
  950.                       getElementData(tents,"Standart Skin"),
  951.                       getElementData(tents,"Painkiller"),
  952.                       getElementData(tents,"Binocular"),
  953.                       getElementData(tents,"Empty Water Bottle"),
  954.                       getElementData(tents,"Empty Soda Cans,"),
  955.                       getElementData(tents,"Scruffy Burgers,"),
  956.                       getElementData(tents,"Shotgun Ammo"),
  957.                       getElementData(tents,"Radio Device")
  958.                      )
  959.                        
  960.                     local result = dbPoll( querry, 10 )  
  961.            
  962.            
  963.                 end
  964.                 destroyElement(tents)
  965.         end
  966.     end
  967. end
  968.  
  969. function rebornVehicles()
  970.     if not (source == getResourceRootElement()) then return end
  971. ---
  972. qh = dbQuery(dbConnection, "SELECT id FROM vehicles")
  973. local id = dbPoll(qh, -1)
  974. local id = table.getn(id)
  975. outputDebugString(id)
  976. for i = 1, id do
  977.         qrb = dbQuery(dbConnection, "SELECT * FROM vehicles WHERE id ="..i.."")
  978.         resdasdult = dbPoll(qrb, -1)   
  979.         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']))
  980.         setElementData(vehicle,"id",resdasdult[1]['id'])
  981.         setElementData(vehicle,"MYSQLVEHICLE",true)
  982.         vehicleCol = createColSphere(resdasdult[1]['x'],resdasdult[1]['y'],resdasdult[1]['z'], 2)
  983.         attachElements(vehicleCol, vehicle, 0, 0, 0)
  984.         setElementData(vehicleCol, "parent", vehicle)
  985.         setElementData(vehicle, "parent", vehicleCol)
  986.         setElementData(vehicleCol, "vehicle", true)
  987.         setElementData(vehicleCol, "MAX_Slots", tonumber(resdasdult[1]['MAX_Slots']))
  988.         setElementData(vehicleCol, "spawn", {
  989.           tonumber(resdasdult[1]['vehicle_ID']),
  990.           tonumber(resdasdult[1]['spawn_x']),
  991.           tonumber(resdasdult[1]['spawn_y']),
  992.           tonumber(resdasdult[1]['spawn_z'])
  993.         })
  994.         for i, datensatzb in ipairs(vehicleDataTable) do
  995.             local datensatzx = tonumber(resdasdult[1][datensatzb[2]])
  996.             setElementData(vehicleCol,datensatzb[1],datensatzx)
  997.         end
  998.     end
  999. end
  1000.  
  1001. function saveVehiclesc()
  1002.     if not (source == getResourceRootElement()) then return end
  1003.     for index,tent in ipairs(getElementsByType("vehicle")) do
  1004.                 if (getElementData(tent,"MYSQLVEHICLE")) then
  1005.                     local x,y,z = getElementPosition(tent)
  1006.                     local rx,ry,rz = getElementRotation(tent)
  1007.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET x='"..x.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1008.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET y='"..y.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1009.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET z='"..z.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1010.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET rx='"..rx.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1011.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET ry='"..ry.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1012.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET rz='"..rz.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1013.                        
  1014.                     local tents = getElementData(tent,"parent")
  1015.                     for i, datensatzz in ipairs(vehicleDataTable) do
  1016.                             qh = dbQuery(dbConnection, "UPDATE vehicles SET "..datensatzz[2].."='"..tostring(getElementData(tents,datensatzz[1])).."' WHERE id ='"..getElementData(tent,"id").."'")
  1017.                             resultb = dbPoll(qh, -1)
  1018.                     end
  1019.                 else
  1020.                     if (getElementData(tent,"spawnedViaPanel") == true) then return end    
  1021.                     qh = dbQuery(dbConnection, "SELECT id FROM vehicles")
  1022.                     idresult = dbPoll(qh, -1)
  1023.                     local id = table.getn(idresult)+1
  1024.                     local x,y,z = getElementPosition(tent)
  1025.                     local rx,ry,rz = getElementRotation(tent)
  1026.                     local tents = getElementData(tent,"parent")
  1027.                     if (getElementModel(tent) ~= 548) then
  1028.                     local querry = dbQuery(dbConnection, "INSERT INTO vehicles VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
  1029.                     id,
  1030.                     x,
  1031.                     y,
  1032.                     z,
  1033.                     rx,
  1034.                     ry,
  1035.                     rz,
  1036.                   getElementData(tents, "spawn")[2],
  1037.                     getElementData(tents, "spawn")[3],
  1038.                       getElementData(tents, "spawn")[4],
  1039.                     getElementModel(tent),
  1040.                     getElementData(tents,"MAX_Slots"),
  1041.                       getElementData(tents,"Tire_inVehicle"),
  1042.                       getElementData(tents,"Engine_inVehicle"),
  1043.                       getElementData(tents,"fuel"),
  1044.                       getElementData(tents,"Wood"),
  1045.                       getElementData(tents,"Bandage"),
  1046.                       getElementData(tents,"Water Bottle"),
  1047.                       getElementData(tents,"Pasta Can"),
  1048.                       getElementData(tents,"Beans Can"),
  1049.                       getElementData(tents,"Burger"),
  1050.                       getElementData(tents,"Lighter"),
  1051.                       getElementData(tents,"Pistol Ammo"),
  1052.                       getElementData(tents,"Pistol"),
  1053.                       getElementData(tents,"Silenced Pistol"),
  1054.                       getElementData(tents,"Shotgun"),
  1055.                       getElementData(tents,"Knife"),
  1056.                       getElementData(tents,"Morphine"),
  1057.                       getElementData(tents,"Katana"),
  1058.                       getElementData(tents,"Pizza"),
  1059.                       getElementData(tents,"Soda Bottle"),
  1060.                       getElementData(tents,"Empty Patrol Canister"),
  1061.                       getElementData(tents,"Full Patrol Canister"),
  1062.                       getElementData(tents,"Roadflare"),
  1063.                       getElementData(tents,"Milk"),
  1064.                       getElementData(tents,"Smg Ammo"),
  1065.                       getElementData(tents,"Assault Ammo"),
  1066.                       getElementData(tents,"Tear Gas,"),
  1067.                       getElementData(tents,"Grenade"),
  1068.                       getElementData(tents,"Desert Eagle"),
  1069.                       getElementData(tents,"Sawn-Off Shotgun"),
  1070.                       getElementData(tents,"SPAZ-12 Combat Shotgun"),
  1071.                       getElementData(tents,"MP5"),
  1072.                       getElementData(tents,"Watch"),
  1073.                       getElementData(tents,"Medic Kit"),
  1074.                       getElementData(tents,"Heat Pack"),
  1075.                       getElementData(tents,"Country Rifle"),
  1076.                       getElementData(tents,"Uzi"),
  1077.                       getElementData(tents,"TEC-9"),
  1078.                       getElementData(tents,"AK-47"),
  1079.                       getElementData(tents,"Rocket Launcher"),
  1080.                       getElementData(tents,"Blood Bag"),
  1081.                       getElementData(tents,"GPs,"),
  1082.                       getElementData(tents,"Map"),
  1083.                       getElementData(tents,"Toolbox"),
  1084.                       getElementData(tents,"Wire Fence"),
  1085.                       getElementData(tents,"Tire"),
  1086.                       getElementData(tents,"Engine"),
  1087.                       getElementData(tents,"Rocket Ammo"),
  1088.                       getElementData(tents,"Sniper Ammo"),
  1089.                       getElementData(tents,"M4"),
  1090.                       getElementData(tents,"Sniper Rifle"),
  1091.                       getElementData(tents,"Heat-Seeking RPG"),
  1092.                       getElementData(tents,"Satchel"),
  1093.                       getElementData(tents,"Infrared Goggles,"),
  1094.                       getElementData(tents,"Night Vision Goggles,"),
  1095.                       getElementData(tents,"Tent"),
  1096.                       getElementData(tents,"Raw Meat"),
  1097.                       getElementData(tents,"Cooked Meat"),
  1098.                       getElementData(tents,"Army Skin"),
  1099.                       getElementData(tents,"Sniper Skin"),  
  1100.                       getElementData(tents,"Civilian Skin"),
  1101.                       getElementData(tents,"Standart Skin"),
  1102.                       getElementData(tents,"Painkiller"),
  1103.                       getElementData(tents,"Binocular"),
  1104.                       getElementData(tents,"Empty Water Bottle"),
  1105.                       getElementData(tents,"Empty Soda Cans,"),
  1106.                       getElementData(tents,"Scruffy Burgers,"),
  1107.                       getElementData(tents,"Shotgun Ammo"),
  1108.                       getElementData(tents,"Radio Device")  
  1109.                      )
  1110.                        
  1111.                     local result = dbPoll( querry, 10 )  
  1112.            
  1113.                     end
  1114.                 end
  1115.         end
  1116. end
  1117.  
  1118. function removeTentMYSQL(object)
  1119. local id = dbPoll(dbQuery(dbConnection, "SELECT id FROM tents"),-1)
  1120. local id = table.getn(id)+1
  1121. dbPoll(dbQuery(dbConnection, "DELETE FROM tents WHERE id = '"..getElementData(object,"id").."'"), -1)
  1122.  
  1123.   local x, y, z = getElementPosition(getElementData(object, "parent"))
  1124. outputDebugString(getElementData(object,"id"))
  1125. triggerEvent("removeTent1", getRootElement(), x,y,z,object)
  1126. end
  1127. addEvent("removeTent", true)
  1128. addEventHandler("removeTent", getRootElement(), removeTentMYSQL)
  1129.  
  1130. addEventHandler("onResourceStart",getRootElement(),rebornTents)
  1131. addEventHandler("onResourceStop",getRootElement(),saveTentsc)
  1132. addEventHandler("onResourceStart",getRootElement(),rebornVehicles)
  1133. addEventHandler("onResourceStop",getRootElement(),saveVehiclesc)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!