API tools faq
paste
Guest User

fhz2357367z377

a guest
Aug 5th, 2013
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 33.93 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. 1,
  435.  0, --alivetime
  436.  73, --skin
  437.  10, --MAX_Slots
  438.  "false", --bandit
  439.  12000, --blood
  440.  100, --food
  441.  100, --thirst
  442.  37, --temperature
  443. "false", --currentweapon_1
  444.  "false", --currentweapon_2
  445.  "false", --currentweapon_2
  446.  0, --bleeding
  447.  "false", --brokenbone
  448.  "false", --pain
  449.  "false", --cold
  450. "false", --infection
  451.  0, --humanity
  452.  0, --zombieskilled
  453.  0, --headshots
  454.  0, --murders
  455.  0, --banditskilled
  456.  0, --Wood
  457.  2, --Bandage
  458.  0, --Water Bottle
  459.  0, --Pasta Can
  460.  0, --Beans Can
  461.  0, --Burger
  462.  0, --Lighter
  463.  0, --Pistol Ammo
  464.  0, --Pistol
  465.  0, --Silenced Pistol
  466.  0, --Shotgun
  467.  0, --Uzi
  468.  0, --Knife
  469.  0, --Katana
  470.  0, --Pizza
  471.  0, --Morphine
  472.  0, --Soda Bottle
  473.  0, --Empty Patrol Canister
  474.  0, --Full Patrol Canister
  475.  0, --Roadflare
  476.  0, --Milk
  477.  0, --Smg Ammo
  478.  0, --Assault Ammo
  479.  0, --Tear Gas
  480.  0, --Grenade
  481.  0, --Desert Eagle
  482.  0, --Sawn-Off Shotgun
  483.  0, --SPAZ-12 Combat Shotgun
  484.  0, --MP5
  485.  0, --Watch
  486.  0, --Medic Kit
  487.  0, --Heat Pack
  488.  0, --Country Rifle
  489.  0, --TEC-9
  490.  0, --AK-47
  491.  0, --Rocket Launcher
  492.  0, --Blood Bag
  493.  0, --GPS
  494.  0, --Map
  495.  0, --Toolbox
  496.  0, --Wire Fence
  497.  0, --Tire
  498.  0, --Engine
  499.  0, --Rocket Ammo
  500.  0, --Sniper Ammo
  501.  0, --M4
  502.  0, --Sniper Rifle
  503.  0, --Heat-Seeking RPG
  504.  0, --Satchel
  505.  0, --Infrared Goggles
  506.  0, --Night Vision Goggles
  507.  0, --Tent
  508.  0, --Raw Meat
  509.  0, --Cooked Meat
  510.  0, --Army Skin
  511.  0, --Sniper Skin
  512.  0, --Civilian Skin
  513.  0, --Standart Skin
  514.  1, --Painkiller
  515.  0, --Binocular
  516.  0, --Empty Water Bottle
  517.  0, --Empty Soda Cans
  518.  0, --Scruffy Burgers
  519.  0, --Shotgun Ammo
  520.  0 --Radio Device
  521.  )
  522. local result = dbPoll( querry, 10 )    
  523. end
  524. addEvent("onPlayerDayZRegister",true)
  525. addEventHandler("onPlayerDayZRegister", getRootElement(), playerRegisterb)
  526.  
  527.  
  528. function getTablePositionMySQL ( data )
  529. for index,daten in ipairs(playerDataTable) do
  530. if (data == daten[2]) then
  531. return daten[1]
  532. end
  533. end
  534. end
  535. function getTablePositionMySQL1 ( data )
  536. for index,daten in ipairs(playerDataTable) do
  537. if (data == daten[1]) then
  538. return daten[2]
  539. end
  540. end
  541. end
  542.  
  543.  
  544. function playerLogibn(username, pass, player)
  545.             qr = dbQuery(dbConnection, "SELECT * FROM users WHERE Name ='"..getPlayerName(player).."'")
  546.             result = dbPoll(qr, -1)
  547.             password = result[1]['password']
  548.             if (password ~= md5(pass)) then kickPlayer(player,"password wrong") end
  549.  
  550.  
  551.             qrb = dbQuery(dbConnection, "SELECT * FROM users WHERE Name ='"..getPlayerName(player).."'")
  552.             resultqrb = dbPoll(qrb, -1)
  553.        
  554.           spawnPlayer(player, resultqrb[1]['x'],resultqrb[1]['y'],resultqrb[1]['z'], resultqrb[1]['rz'], skin, 0, 0)
  555.           fadeCamera(player, true)
  556.           setElementData(player,"id",resultqrb[1]['id'])
  557.           setCameraTarget(player, player)
  558.           local x,y,z = getElementPosition(player)
  559.           local playerColshape = createColSphere(x, y, z, 1.5)
  560.           setElementData(player, "playerCol", playerColshape)
  561.           attachElements(playerColshape, player, 0, 0, 0)
  562.           setElementData(playerColshape, "parent", player)
  563.           setElementData(playerColshape, "player", true)
  564.         setElementPosition(player,resultqrb[1]['x'],resultqrb[1]['y'],resultqrb[1]['z'])
  565.         setElementRotation(player,0,0,resultqrb[1]['rz'])
  566.         if (resultqrb[1]['rank'] == "1") then
  567.             setElementData(player,"admin",false)
  568.             setElementData(player,"supporter",true)
  569.            
  570.                 outputDebugString(resultqrb[1]['rank'])
  571.         elseif (resultqrb[1]['rank'] == "2") then
  572.             setElementData(player,"admin",true)
  573.             setElementData(player,"supporter",false)
  574.  
  575.                 local account = getAccount ( username, pass )
  576.                 if ( account ~= false ) then
  577.                     logIn ( player, account, pass )
  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.                     outputChatBox("",player)
  588.                 end
  589.  
  590.             outputDebugString(resultqrb[1]['rank'])
  591.         elseif (resultqrb[1]['rank'] == "3") then
  592.             setElementData(player,"owner",true)
  593.         end
  594.         for i, datensatz in ipairs(playerDataTable) do
  595.                        
  596.                        
  597.                        
  598.                         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
  599.                             if (resultqrb[1][datensatz[2]] == "1")  then
  600.                                 dayzDate = true
  601.                                 outputDebugString(datensatz[1].." ; "..resultqrb[1][datensatz[2]])
  602.                             elseif (resultqrb[1][datensatz[2]] == "0")  then
  603.                                 dayzDate = false
  604.                                 outputDebugString(datensatz[1].." ; "..resultqrb[1][datensatz[2]])
  605.                             end
  606.                         else
  607.                         dayzDate = tonumber(resultqrb[1][datensatz[2]])
  608.                         end
  609.                    
  610.                         setElementData(player,datensatz[1],dayzDate)   
  611.                         end    
  612.                        
  613.                   createZombieTable(player)
  614.                   if result[1]['isDead'] == "1" then
  615.                     spawnDayZPlayer(player)
  616.                     dbPoll(dbQuery(dbConnection, "UPDATE users SET isDead='0' WHERE Name ='"..getPlayerName(player).."'"), -1)
  617.                     return
  618.                   end
  619.  
  620.               setElementData(player, "logedin", true)
  621.               local weapon = getElementData(player, "currentweapon_1")
  622.  
  623.               if weapon then
  624.                 local ammoData, weapID = getWeaponAmmoType(weapon)
  625.                 giveWeapon(player, weapID, getElementData(player, ammoData), true)
  626.               end
  627.               local weapon = getElementData(player, "currentweapon_2")
  628.               if weapon then
  629.              
  630.                 local ammoData, weapID = getWeaponAmmoType(weapon)
  631.                 giveWeapon(player, weapID, getElementData(player, ammoData), false)
  632.               end
  633.               local weapon = getElementData(player, "currentweapon_3")
  634.  
  635.               if weapon then
  636.                 local ammoData, weapID = getWeaponAmmoType(weapon)
  637.                 giveWeapon(player, weapID, getElementData(player, ammoData), false)
  638.               end
  639.               setPedSkin(player,getElementData(player, "skin"))
  640. end
  641. addEvent("onPlayerDayZLogin", true)
  642. addEventHandler("onPlayerDayZLogin", getRootElement(), playerLogibn)
  643.    
  644.            
  645. function saveAccounts3()
  646.   local account = getPlayerAccount(source)
  647.   if account then
  648.         local x,y,z = getElementPosition(source)
  649.         local _,_,rz = getElementRotation(source)
  650.         qh = dbQuery(dbConnection, "UPDATE users SET x="..tostring(x)..", y="..tostring(y)..", z="..tostring(z)..", rz="..tostring(rz).." WHERE Name ='"..getPlayerName(source).."'")
  651.         resultb = dbPoll(qh, -1)
  652.  
  653.         for i, datensatzb in ipairs(playerDataTable) do
  654.                 dataz = getElementData(source,datensatzb[1])
  655.                 qh = dbQuery(dbConnection, "UPDATE users SET "..datensatzb[2].."="..tostring(dataz).." WHERE Name ='"..getPlayerName(source).."'")
  656.                 resultb = dbPoll(qh, -1)
  657.         end
  658.        
  659.   end
  660.  
  661.   setElementData(source, "logedin", false)
  662. end
  663. addEventHandler("onPlayerQuit", getRootElement(), saveAccounts3)
  664.  
  665. -- VEHICLES & TENTS !
  666.  
  667.  
  668. local vehicleDataTable = {
  669.   {"MAX_Slots","MAX_Slots"},
  670.   {"Tire_inVehicle","Tire_inVehicle"},
  671.   {"Engine_inVehicle","Engine_inVehicle"},
  672.   {"fuel","fuel"},
  673.   {"Wood","Wood"},
  674.   {"Bandage","Bandage"},
  675.   {"Water Bottle","WaterBottle"},
  676.   {"Pasta Can","PastaCan"},
  677.   {"Beans Can","BeansCan"},
  678.   {"Burger","Burger"},
  679.   {"Lighter","Lighter"},
  680.   {"Pistol Ammo","PistolAmmo"},
  681.   {"Pistol","Pistol"},
  682.   {"Silenced Pistol","SilencedPistol"},
  683.   {"Shotgun","Shotgun"},
  684.   {"Knife","Knife"},
  685.   {"Morphine","Morphine"},
  686.   {"Katana","Katana"},
  687.   {"Pizza","Pizza"},
  688.   {"Soda Bottle","SodaBottle"},
  689.   {"Empty Patrol Canister","EmptyPatrolCanister"},
  690.   {"Full Patrol Canister","FullPatrolCanister"},
  691.   {"Roadflare","Roadflare"},
  692.   {"Milk","Milk"},
  693.   {"Smg Ammo","SmgAmmo"},
  694.   {"Assault Ammo","AssaultAmmo"},
  695.   {"Tear Gas","TearGas"},
  696.   {"Grenade","Grenade"},
  697.   {"Desert Eagle","DesertEagle"},
  698.   {"Sawn-Off Shotgun","SawnOffShotgun"},
  699.   {"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  700.   {"MP5","MP5"},
  701.   {"Watch","Watch"},
  702.   {"Medic Kit","MedicKit"},
  703.   {"Heat Pack","HeatPack"},
  704.   {"Country Rifle","CountryRifle"},
  705.   {"Uzi","Uzi"},
  706.   {"TEC-9","TEC9"},
  707.   {"AK-47","AK47"},
  708.   {"Rocket Launcher","RocketLauncher"},
  709.   {"Blood Bag","BloodBag"},
  710.   {"GPS","GPS"},
  711.   {"Map","Map"},
  712.   {"Toolbox","Toolbox"},
  713.   {"Wire Fence","WireFence"},
  714.   {"Tire","Tire"},
  715.   {"Engine","Engine"},
  716.   {"Rocket Ammo","RocketAmmo"},
  717.   {"Sniper Ammo","SniperAmmo"},
  718.   {"M4","M4"},
  719.   {"Sniper Rifle","SniperRifle"},
  720.   {"Heat-Seeking RPG","HeatSeekingRPG"},
  721.   {"Satchel","Satchel"},
  722.   {"Infrared Goggles","InfraredGoggles"},
  723.   {"Night Vision Goggles","NightVisionGoggles"},
  724.   {"Tent","Tent"},
  725.   {"Raw Meat","RawMeat"},
  726.   {"Cooked Meat","CookedMeat"},
  727.   {"Army Skin","ArmySkin"},
  728.   {"Sniper Skin","SniperSkin"},
  729.   {"Civilian Skin","CivilianSkin"},
  730.   {"Standart Skin","StandartSkin"},
  731.   {"Painkiller","Painkiller"},
  732.   {"Binocular","Binocular"},
  733.   {"Empty Water Bottle","EmptyWaterBottle"},
  734.   {"Empty Soda Cans","EmptySodaCans"},
  735.   {"Scruffy Burgers","ScruffyBurgers"},
  736.   {"Shotgun Ammo","ShotgunAmmo"},
  737.   {"Small Backpack","SmallBackpack"},
  738.   {"Alice Backpack","AliceBackpack"},
  739.   {"Radio Device","RadioDevice"},
  740.   {"Coyote Backpack","CoyoteBackpack"}
  741. }
  742. tent_id = 3243
  743.  
  744.  
  745. function removeTent1(x,y,z,object)
  746.   local item, itemString = getItemTablePosition("Tent")
  747.   local itemPickup = createItemPickup(item, x, y, z + 1, itemString)
  748.   destroyElement(getElementData(object, "parent"))
  749.   destroyElement(object)
  750. end
  751. addEvent("removeTent1", true)
  752. removeEventHandler("removeTent", getRootElement(), removeTent) 
  753. addEventHandler("removeTent1", getRootElement(), removeTent1)  
  754.  
  755.  
  756.  
  757. local vehicleDataTable = {
  758.   {"MAX_Slots","MAX_Slots"},
  759.   {"Tire_inVehicle","Tire_inVehicle"},
  760.   {"Engine_inVehicle","Engine_inVehicle"},
  761.   {"fuel","fuel"},
  762.   {"Wood","Wood"},
  763.   {"Bandage","Bandage"},
  764.   {"Water Bottle","WaterBottle"},
  765.   {"Pasta Can","PastaCan"},
  766.   {"Beans Can","BeansCan"},
  767.   {"Burger","Burger"},
  768.   {"Lighter","Lighter"},
  769.   {"Pistol Ammo","PistolAmmo"},
  770.   {"Pistol","Pistol"},
  771.   {"Silenced Pistol","SilencedPistol"},
  772.   {"Shotgun","Shotgun"},
  773.   {"Knife","Knife"},
  774.   {"Morphine","Morphine"},
  775.   {"Katana","Katana"},
  776.   {"Pizza","Pizza"},
  777.   {"Soda Bottle","SodaBottle"},
  778.   {"Empty Patrol Canister","EmptyPatrolCanister"},
  779.   {"Full Patrol Canister","FullPatrolCanister"},
  780.   {"Roadflare","Roadflare"},
  781.   {"Milk","Milk"},
  782.   {"Smg Ammo","SmgAmmo"},
  783.   {"Assault Ammo","AssaultAmmo"},
  784.   {"Tear Gas","TearGas"},
  785.   {"Grenade","Grenade"},
  786.   {"Desert Eagle","DesertEagle"},
  787.   {"Sawn-Off Shotgun","SawnOffShotgun"},
  788.   {"SPAZ-12 Combat Shotgun","SPAZ12CombatShotgun"},
  789.   {"MP5","MP5"},
  790.   {"Watch","Watch"},
  791.   {"Medic Kit","MedicKit"},
  792.   {"Heat Pack","HeatPack"},
  793.   {"Country Rifle","CountryRifle"},
  794.   {"Uzi","Uzi"},
  795.   {"TEC-9","TEC9"},
  796.   {"AK-47","AK47"},
  797.   {"Rocket Launcher","RocketLauncher"},
  798.   {"Blood Bag","BloodBag"},
  799.   {"GPS","GPS"},
  800.   {"Map","Map"},
  801.   {"Toolbox","Toolbox"},
  802.   {"Wire Fence","WireFence"},
  803.   {"Tire","Tire"},
  804.   {"Engine","Engine"},
  805.   {"Rocket Ammo","RocketAmmo"},
  806.   {"Sniper Ammo","SniperAmmo"},
  807.   {"M4","M4"},
  808.   {"Sniper Rifle","SniperRifle"},
  809.   {"Heat-Seeking RPG","HeatSeekingRPG"},
  810.   {"Satchel","Satchel"},
  811.   {"Infrared Goggles","InfraredGoggles"},
  812.   {"Night Vision Goggles","NightVisionGoggles"},
  813.   {"Tent","Tent"},
  814.   {"Raw Meat","RawMeat"},
  815.   {"Cooked Meat","CookedMeat"},
  816.   {"Army Skin","ArmySkin"},
  817.   {"Sniper Skin","SniperSkin"},
  818.   {"Civilian Skin","CivilianSkin"},
  819.   {"Standart Skin","StandartSkin"},
  820.   {"Painkiller","Painkiller"},
  821.   {"Binocular","Binocular"},
  822.   {"Empty Water Bottle","EmptyWaterBottle"},
  823.   {"Empty Soda Cans","EmptySodaCans"},
  824.   {"Scruffy Burgers","ScruffyBurgers"},
  825.   {"Shotgun Ammo","ShotgunAmmo"},
  826.   {"Radio Device","RadioDevice"},
  827. }
  828. tent_id = 3243
  829.  
  830.  
  831. function rebornTents()
  832.     if not (source == getResourceRootElement()) then return end
  833. ---
  834. qh = dbQuery(dbConnection, "SELECT id FROM tents")
  835. local id = dbPoll(qh, -1)
  836. for k,v in pairs(id) do
  837.         qrb = dbQuery(dbConnection, "SELECT * FROM tents WHERE id ="..v['id'].."")
  838.         resdasdult = dbPoll(qrb, -1)   
  839.         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']))
  840.         setElementData(tent,"id",resdasdult[1]['id'])
  841.         setElementData(tent,"MySQLTENT",true)
  842.          setObjectScale(tent, 1.3)
  843.         tentCol = createColSphere(resdasdult[1]['x'],resdasdult[1]['y'],resdasdult[1]['z'], 4)
  844.         attachElements(tentCol, tent, 0, 0, 0)
  845.         setElementData(tentCol, "parent", tent)
  846.         setElementData(tent, "parent", tentCol)
  847.         setElementData(tentCol, "tent", true)
  848.         setElementData(tentCol, "vehicle", true)
  849.         setElementData(tentCol, "MAX_Slots", 100)
  850.         for i, datensatzb in ipairs(vehicleDataTable) do
  851.             local datensatzx = tonumber(resdasdult[1][datensatzb[2]])
  852.             setElementData(tentCol,datensatzb[1],datensatzx)
  853.         end
  854.     end
  855. local id = table.getn(id)
  856. outputDebugString(id)
  857. end
  858.  
  859. function saveTentsc()
  860.     if not (source == getResourceRootElement()) then return end
  861.     for index,tents in ipairs(getElementsByType("object")) do
  862.         if (getElementModel(tents) == 3243) then
  863.        
  864.                 if (getElementData(tents,"MySQLTENT")) then
  865.                 outputDebugString("MYSQL TENT")
  866.                     local x,y,z = getElementPosition(tents)
  867.                     local _,_,rz = getElementRotation(tents)
  868.                     local tent = getElementData(tents,"parent")
  869.                     for i, datensatzz in ipairs(vehicleDataTable) do
  870.                         qh = dbQuery(dbConnection, "UPDATE tents SET "..datensatzz[2].."='"..tostring(getElementData(tent,datensatzz[1])).."' WHERE id ='"..getElementData(tents,"id").."'")
  871.                         resultb = dbPoll(qh, -1)
  872.                     end
  873.                 else       
  874.                     outputDebugString("NON MYSQL TENT")
  875.                     qh = dbQuery(dbConnection, "SELECT id FROM tents")
  876.                     idresult = dbPoll(qh, -1)
  877.                     local id = table.getn(idresult)+1
  878.                     outputDebugString(id)
  879.                     local x,y,z = getElementPosition(tents)
  880.                     local rx,ry,rz = getElementRotation(tents)
  881.                     local tents = getElementData(tents,"parent")
  882.                     local querry = dbQuery(dbConnection, "INSERT INTO tents VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
  883.                     math.random(99999999),
  884.                     x,
  885.                     y,
  886.                     z,
  887.                     rx,
  888.                     ry,
  889.                     rz,
  890.                     100,
  891.                       getElementData(tents,"Tire_inVehicle"),
  892.                       getElementData(tents,"Engine_inVehicle"),
  893.                       getElementData(tents,"Fuel"),
  894.                       getElementData(tents,"Wood"),
  895.                       getElementData(tents,"Bandage"),
  896.                       getElementData(tents,"Water Bottle"),
  897.                       getElementData(tents,"Pasta Can"),
  898.                       getElementData(tents,"Beans Can"),
  899.                       getElementData(tents,"Burger"),
  900.                       getElementData(tents,"Lighter"),
  901.                       getElementData(tents,"Pistol Ammo"),
  902.                       getElementData(tents,"Pistol"),
  903.                       getElementData(tents,"Silenced Pistol"),
  904.                       getElementData(tents,"Shotgun"),
  905.                       getElementData(tents,"Knife"),
  906.                       getElementData(tents,"Morphine"),
  907.                       getElementData(tents,"Katana"),
  908.                       getElementData(tents,"Pizza"),
  909.                       getElementData(tents,"Soda Bottle"),
  910.                       getElementData(tents,"Empty Patrol Canister"),
  911.                       getElementData(tents,"Full Patrol Canister"),
  912.                       getElementData(tents,"Roadflare"),
  913.                       getElementData(tents,"Milk"),
  914.                       getElementData(tents,"Smg Ammo"),
  915.                       getElementData(tents,"Assault Ammo"),
  916.                       getElementData(tents,"Tear Gas,"),
  917.                       getElementData(tents,"Grenade"),
  918.                       getElementData(tents,"Desert Eagle"),
  919.                       getElementData(tents,"Sawn-Off Shotgun"),
  920.                       getElementData(tents,"SPAZ-12 Combat Shotgun"),
  921.                       getElementData(tents,"MP5"),
  922.                       getElementData(tents,"Watch"),
  923.                       getElementData(tents,"Medic Kit"),
  924.                       getElementData(tents,"Heat Pack"),
  925.                       getElementData(tents,"Country Rifle"),
  926.                       getElementData(tents,"Uzi"),
  927.                       getElementData(tents,"TEC-9"),
  928.                       getElementData(tents,"AK-47"),
  929.                       getElementData(tents,"Rocket Launcher"),
  930.                       getElementData(tents,"Blood Bag"),
  931.                       getElementData(tents,"GPs,"),
  932.                       getElementData(tents,"Map"),
  933.                       getElementData(tents,"Toolbox"),
  934.                       getElementData(tents,"Wire Fence"),
  935.                       getElementData(tents,"Tire"),
  936.                       getElementData(tents,"Engine"),
  937.                       getElementData(tents,"Rocket Ammo"),
  938.                       getElementData(tents,"Sniper Ammo"),
  939.                       getElementData(tents,"M4"),
  940.                       getElementData(tents,"Sniper Rifle"),
  941.                       getElementData(tents,"Heat-Seeking RPG"),
  942.                       getElementData(tents,"Satchel"),
  943.                       getElementData(tents,"Infrared Goggles,"),
  944.                       getElementData(tents,"Night Vision Goggles,"),
  945.                       getElementData(tents,"Tent"),
  946.                       getElementData(tents,"Raw Meat"),
  947.                       getElementData(tents,"Cooked Meat"),
  948.                       getElementData(tents,"Army Skin"),
  949.                       getElementData(tents,"Sniper Skin"),  
  950.                       getElementData(tents,"Civilian Skin"),
  951.                       getElementData(tents,"Standart Skin"),
  952.                       getElementData(tents,"Painkiller"),
  953.                       getElementData(tents,"Binocular"),
  954.                       getElementData(tents,"Empty Water Bottle"),
  955.                       getElementData(tents,"Empty Soda Cans,"),
  956.                       getElementData(tents,"Scruffy Burgers,"),
  957.                       getElementData(tents,"Shotgun Ammo"),
  958.                       getElementData(tents,"Radio Device")
  959.                      )
  960.                        
  961.                     local result = dbPoll( querry, 10 )  
  962.            
  963.            
  964.                 end
  965.                 destroyElement(tents)
  966.         end
  967.     end
  968. end
  969.  
  970. function rebornVehicles()
  971.     if not (source == getResourceRootElement()) then return end
  972. ---
  973. qh = dbQuery(dbConnection, "SELECT id FROM vehicles")
  974. local id = dbPoll(qh, -1)
  975. local id = table.getn(id)
  976. outputDebugString(id)
  977. for i = 1, id do
  978.         qrb = dbQuery(dbConnection, "SELECT * FROM vehicles WHERE id ="..i.."")
  979.         resdasdult = dbPoll(qrb, -1)   
  980.         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']))
  981.         setElementData(vehicle,"id",resdasdult[1]['id'])
  982.         setElementData(vehicle,"MYSQLVEHICLE",true)
  983.         vehicleCol = createColSphere(resdasdult[1]['x'],resdasdult[1]['y'],resdasdult[1]['z'], 2)
  984.         attachElements(vehicleCol, vehicle, 0, 0, 0)
  985.         setElementData(vehicleCol, "parent", vehicle)
  986.         setElementData(vehicle, "parent", vehicleCol)
  987.         setElementData(vehicleCol, "vehicle", true)
  988.         setElementData(vehicleCol, "MAX_Slots", tonumber(resdasdult[1]['MAX_Slots']))
  989.         setElementData(vehicleCol, "spawn", {
  990.           tonumber(resdasdult[1]['vehicle_ID']),
  991.           tonumber(resdasdult[1]['spawn_x']),
  992.           tonumber(resdasdult[1]['spawn_y']),
  993.           tonumber(resdasdult[1]['spawn_z'])
  994.         })
  995.         for i, datensatzb in ipairs(vehicleDataTable) do
  996.             local datensatzx = tonumber(resdasdult[1][datensatzb[2]])
  997.             setElementData(vehicleCol,datensatzb[1],datensatzx)
  998.         end
  999.     end
  1000. end
  1001.  
  1002. function saveVehiclesc()
  1003.     if not (source == getResourceRootElement()) then return end
  1004.     for index,tent in ipairs(getElementsByType("vehicle")) do
  1005.                 if (getElementData(tent,"MYSQLVEHICLE")) then
  1006.                     local x,y,z = getElementPosition(tent)
  1007.                     local rx,ry,rz = getElementRotation(tent)
  1008.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET x='"..x.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1009.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET y='"..y.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1010.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET z='"..z.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1011.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET rx='"..rx.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1012.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET ry='"..ry.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1013.                             dbPoll(dbQuery(dbConnection, "UPDATE vehicles SET rz='"..rz.."' WHERE id ='"..getElementData(tent,"id").."'"), -1)
  1014.                        
  1015.                     local tents = getElementData(tent,"parent")
  1016.                     for i, datensatzz in ipairs(vehicleDataTable) do
  1017.                             qh = dbQuery(dbConnection, "UPDATE vehicles SET "..datensatzz[2].."='"..tostring(getElementData(tents,datensatzz[1])).."' WHERE id ='"..getElementData(tent,"id").."'")
  1018.                             resultb = dbPoll(qh, -1)
  1019.                     end
  1020.                 else
  1021.                     if (getElementData(tent,"spawnedViaPanel") == true) then return end    
  1022.                     qh = dbQuery(dbConnection, "SELECT id FROM vehicles")
  1023.                     idresult = dbPoll(qh, -1)
  1024.                     local id = table.getn(idresult)+1
  1025.                     local x,y,z = getElementPosition(tent)
  1026.                     local rx,ry,rz = getElementRotation(tent)
  1027.                     local tents = getElementData(tent,"parent")
  1028.                     if (getElementModel(tent) ~= 548) then
  1029.                     local querry = dbQuery(dbConnection, "INSERT INTO vehicles VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
  1030.                     id,
  1031.                     x,
  1032.                     y,
  1033.                     z,
  1034.                     rx,
  1035.                     ry,
  1036.                     rz,
  1037.                   getElementData(tents, "spawn")[2],
  1038.                     getElementData(tents, "spawn")[3],
  1039.                       getElementData(tents, "spawn")[4],
  1040.                     getElementModel(tent),
  1041.                     getElementData(tents,"MAX_Slots"),
  1042.                       getElementData(tents,"Tire_inVehicle"),
  1043.                       getElementData(tents,"Engine_inVehicle"),
  1044.                       getElementData(tents,"fuel"),
  1045.                       getElementData(tents,"Wood"),
  1046.                       getElementData(tents,"Bandage"),
  1047.                       getElementData(tents,"Water Bottle"),
  1048.                       getElementData(tents,"Pasta Can"),
  1049.                       getElementData(tents,"Beans Can"),
  1050.                       getElementData(tents,"Burger"),
  1051.                       getElementData(tents,"Lighter"),
  1052.                       getElementData(tents,"Pistol Ammo"),
  1053.                       getElementData(tents,"Pistol"),
  1054.                       getElementData(tents,"Silenced Pistol"),
  1055.                       getElementData(tents,"Shotgun"),
  1056.                       getElementData(tents,"Knife"),
  1057.                       getElementData(tents,"Morphine"),
  1058.                       getElementData(tents,"Katana"),
  1059.                       getElementData(tents,"Pizza"),
  1060.                       getElementData(tents,"Soda Bottle"),
  1061.                       getElementData(tents,"Empty Patrol Canister"),
  1062.                       getElementData(tents,"Full Patrol Canister"),
  1063.                       getElementData(tents,"Roadflare"),
  1064.                       getElementData(tents,"Milk"),
  1065.                       getElementData(tents,"Smg Ammo"),
  1066.                       getElementData(tents,"Assault Ammo"),
  1067.                       getElementData(tents,"Tear Gas,"),
  1068.                       getElementData(tents,"Grenade"),
  1069.                       getElementData(tents,"Desert Eagle"),
  1070.                       getElementData(tents,"Sawn-Off Shotgun"),
  1071.                       getElementData(tents,"SPAZ-12 Combat Shotgun"),
  1072.                       getElementData(tents,"MP5"),
  1073.                       getElementData(tents,"Watch"),
  1074.                       getElementData(tents,"Medic Kit"),
  1075.                       getElementData(tents,"Heat Pack"),
  1076.                       getElementData(tents,"Country Rifle"),
  1077.                       getElementData(tents,"Uzi"),
  1078.                       getElementData(tents,"TEC-9"),
  1079.                       getElementData(tents,"AK-47"),
  1080.                       getElementData(tents,"Rocket Launcher"),
  1081.                       getElementData(tents,"Blood Bag"),
  1082.                       getElementData(tents,"GPs,"),
  1083.                       getElementData(tents,"Map"),
  1084.                       getElementData(tents,"Toolbox"),
  1085.                       getElementData(tents,"Wire Fence"),
  1086.                       getElementData(tents,"Tire"),
  1087.                       getElementData(tents,"Engine"),
  1088.                       getElementData(tents,"Rocket Ammo"),
  1089.                       getElementData(tents,"Sniper Ammo"),
  1090.                       getElementData(tents,"M4"),
  1091.                       getElementData(tents,"Sniper Rifle"),
  1092.                       getElementData(tents,"Heat-Seeking RPG"),
  1093.                       getElementData(tents,"Satchel"),
  1094.                       getElementData(tents,"Infrared Goggles,"),
  1095.                       getElementData(tents,"Night Vision Goggles,"),
  1096.                       getElementData(tents,"Tent"),
  1097.                       getElementData(tents,"Raw Meat"),
  1098.                       getElementData(tents,"Cooked Meat"),
  1099.                       getElementData(tents,"Army Skin"),
  1100.                       getElementData(tents,"Sniper Skin"),  
  1101.                       getElementData(tents,"Civilian Skin"),
  1102.                       getElementData(tents,"Standart Skin"),
  1103.                       getElementData(tents,"Painkiller"),
  1104.                       getElementData(tents,"Binocular"),
  1105.                       getElementData(tents,"Empty Water Bottle"),
  1106.                       getElementData(tents,"Empty Soda Cans,"),
  1107.                       getElementData(tents,"Scruffy Burgers,"),
  1108.                       getElementData(tents,"Shotgun Ammo"),
  1109.                       getElementData(tents,"Radio Device")  
  1110.                      )
  1111.                        
  1112.                     local result = dbPoll( querry, 10 )  
  1113.            
  1114.                     end
  1115.                 end
  1116.         end
  1117. end
  1118.  
  1119. function removeTentMYSQL(object)
  1120. local id = dbPoll(dbQuery(dbConnection, "SELECT id FROM tents"),-1)
  1121. local id = table.getn(id)+1
  1122. dbPoll(dbQuery(dbConnection, "DELETE FROM tents WHERE id = '"..getElementData(object,"id").."'"), -1)
  1123.  
  1124.   local x, y, z = getElementPosition(getElementData(object, "parent"))
  1125. outputDebugString(getElementData(object,"id"))
  1126. triggerEvent("removeTent1", getRootElement(), x,y,z,object)
  1127. end
  1128. addEvent("removeTent", true)
  1129. addEventHandler("removeTent", getRootElement(), removeTentMYSQL)
  1130.  
  1131. addEventHandler("onResourceStart",getRootElement(),rebornTents)
  1132. addEventHandler("onResourceStop",getRootElement(),saveTentsc)
  1133. addEventHandler("onResourceStart",getRootElement(),rebornVehicles)
  1134. 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!