API tools faq
paste
Advertisement
ErickStorm

xml file update to database phpscript

ErickStorm
Jul 20th, 2023
1,298
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 29.04 KB | None | 0 0
raw download clone embed print report diff
  1. <?php
  2. error_reporting(E_ALL & ~E_NOTICE);
  3.  
  4. require_once('config.php');
  5. $conn = sqlsrv_connect($svName, $conn_info);
  6. if(! $conn)
  7. {
  8.    //echo "Connection could not be established.\n";
  9.    die( print_r( sqlsrv_errors(), true));
  10.    exit();
  11. }
  12.  
  13. $data = simplexml_load_file('./itemsDB.xml');
  14.  
  15. foreach( $data->WeaponsArmory->Weapon as $tmp_data ){
  16.    $sql = "SELECT * FROM [dbo].[Items_Weapons] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  17.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  18.  
  19.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  20.    if(sqlsrv_num_rows($stmt) == 0){
  21.       $sql_cmd = "INSERT INTO [dbo].[Items_Weapons] VALUES (
  22.         ".$tmp_data['itemID']."
  23.         ,N'".($tmp_data['FNAME']?$tmp_data['FNAME']:substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30))."'
  24.         ,".$tmp_data['category']."
  25.         ,N'".$tmp_data->Store['name']."'
  26.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  27.         ,N'".trim($tmp_data->Model['muzzlerOffset.x']." "
  28.             .$tmp_data->Model['muzzlerOffset.y']." "
  29.             .$tmp_data->Model['muzzlerOffset.z'])."'
  30.         ,N'".$tmp_data->MuzzleModel['file']."'
  31.         ,N'".$tmp_data->Animation['type']."'
  32.         ,N'".$tmp_data->PrimaryFire['bullet']."'
  33.         ,N'".$tmp_data->Sound['shoot']."'
  34.         ,N'".$tmp_data->Sound['reload']."'
  35.         ,".(double)$tmp_data->PrimaryFire['damage']."
  36.         ,".($tmp_data->PrimaryFire['immediate'] == 'true'?1:0)."
  37.         ,".(double)$tmp_data->PrimaryFire['mass']."
  38.         ,".(int)$tmp_data->PrimaryFire['speed']."
  39.         ,".(double)$tmp_data->PrimaryFire['decay']."
  40.         ,".(double)$tmp_data->PrimaryFire['area']."
  41.         ,".(double)$tmp_data->PrimaryFire['delay']."
  42.         ,".(double)$tmp_data->PrimaryFire['timeout']."
  43.         ,".(int)$tmp_data->PrimaryFire['numShells']."
  44.         ,".(int)$tmp_data->PrimaryFire['clipSize']."
  45.         ,".(double)$tmp_data->PrimaryFire['reloadTime']."
  46.         ,".(double)$tmp_data->PrimaryFire['activeReloadTick']."
  47.         ,".(double)$tmp_data->PrimaryFire['rateOfFire']."
  48.         ,".(double)$tmp_data->PrimaryFire['spread']."
  49.         ,".(double)$tmp_data->PrimaryFire['recoil']."
  50.         ,".(double)$tmp_data->PrimaryFire['numgrenades']."
  51.         ,N'".$tmp_data->PrimaryFire['grenadename']."'
  52.         ,N'".$tmp_data->PrimaryFire['firemode']."'
  53.         ,30
  54.         ,N'".$tmp_data->PrimaryFire['ScopeType']."'
  55.         ,".(double)$tmp_data->PrimaryFire['ScopeZoom']."
  56.         ,0 ,0 ,0 ,0 ,0
  57.         ,".(double)$tmp_data->Store['LevelRequired']."
  58.         ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0
  59.         ,".(double)$tmp_data['upgrade']."
  60.         ,".(double)$tmp_data->FPS['IsFPS']."
  61.         ,".(double)$tmp_data->FPS['i0']."
  62.         ,".(double)$tmp_data->FPS['i1']."
  63.         ,".(double)$tmp_data->FPS['i2']."
  64.         ,".(double)$tmp_data->FPS['i3']."
  65.         ,".(double)$tmp_data->FPS['i4']."
  66.         ,".(double)$tmp_data->FPS['i5']."
  67.         ,".(double)$tmp_data->FPS['i6']."
  68.         ,".(double)$tmp_data->FPS['i7']."
  69.         ,".(double)$tmp_data->FPS['i8']."
  70.         ,".(double)$tmp_data->FPS['d0']."
  71.         ,".(double)$tmp_data->FPS['d1']."
  72.         ,".(double)$tmp_data->FPS['d2']."
  73.         ,".(double)$tmp_data->FPS['d3']."
  74.         ,".(double)$tmp_data->FPS['d4']."
  75.         ,".(double)$tmp_data->FPS['d5']."
  76.         ,".(double)$tmp_data->FPS['d6']."
  77.         ,".(double)$tmp_data->FPS['d7']."
  78.         ,".(double)$tmp_data->FPS['d8']."
  79.         ,N'".($tmp_data->Model['AnimPrefix']?$tmp_data->Model['AnimPrefix']:$tmp_data['FNAME'])."'
  80.         ,".(int)$tmp_data['Weight']."
  81.         ,".(int)$tmp_data->Dur['u']."
  82.         ,".(int)$tmp_data->Dur['r1']."
  83.         ,".(int)$tmp_data->Dur['r2']."
  84.         ,".(int)$tmp_data->Dur['r3']."
  85.         ,".(int)$tmp_data->Res['r1']."
  86.         ,".(int)$tmp_data->Res['r2']."
  87.         ,".(int)$tmp_data->Res['r3'].")";
  88.       echo " Status: New!<br>";
  89.    }else{
  90.       $sql_cmd = "UPDATE [dbo].[Items_Weapons]
  91.      SET [FNAME] = N'".($tmp_data['FNAME']?$tmp_data['FNAME']:substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30))."'
  92.         ,[Category] = ".$tmp_data['category']."
  93.         ,[Name] = N'".$tmp_data->Store['name']."'
  94.         ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  95.         ,[MuzzleOffset] = N'".trim($tmp_data->Model['muzzlerOffset.x']." ".$tmp_data->Model['muzzlerOffset.y']." ".$tmp_data->Model['muzzlerOffset.z'])."'
  96.         ,[MuzzleParticle] = N'".$tmp_data->MuzzleModel['file']."'
  97.         ,[Animation] = N'".$tmp_data->Animation['type']."'
  98.         ,[BulletID] = N'".$tmp_data->PrimaryFire['bullet']."'
  99.         ,[Sound_Shot] = N'".$tmp_data->Sound['shoot']."'
  100.         ,[Sound_Reload] = N'".$tmp_data->Sound['reload']."'
  101.         ,[Damage] = ".(double)$tmp_data->PrimaryFire['damage']."
  102.         ,[isImmediate] = ".($tmp_data->PrimaryFire['immediate'] == 'true'?1:0)."
  103.         ,[Mass] = ".(double)$tmp_data->PrimaryFire['mass']."
  104.         ,[Speed] = ".(int)$tmp_data->PrimaryFire['speed']."
  105.         ,[DamageDecay] = ".(double)$tmp_data->PrimaryFire['decay']."
  106.         ,[Area] = ".(double)$tmp_data->PrimaryFire['area']."
  107.         ,[Delay] = ".(double)$tmp_data->PrimaryFire['delay']."
  108.         ,[Timeout] = ".(double)$tmp_data->PrimaryFire['timeout']."
  109.         ,[NumClips] = ".(int)$tmp_data->PrimaryFire['numShells']."
  110.         ,[Clipsize] = ".(int)$tmp_data->PrimaryFire['clipSize']."
  111.         ,[ReloadTime] = ".(double)$tmp_data->PrimaryFire['reloadTime']."
  112.         ,[ActiveReloadTick] = ".(double)$tmp_data->PrimaryFire['activeReloadTick']."
  113.         ,[RateOfFire] = ".(double)$tmp_data->PrimaryFire['rateOfFire']."
  114.         ,[Spread] = ".(double)$tmp_data->PrimaryFire['spread']."
  115.         ,[Recoil] = ".(double)$tmp_data->PrimaryFire['recoil']."
  116.         ,[NumGrenades] = ".(double)$tmp_data->PrimaryFire['numgrenades']."
  117.         ,[GrenadeName] = N'".$tmp_data->PrimaryFire['grenadename']."'
  118.         ,[Firemode] = N'".$tmp_data->PrimaryFire['firemode']."'
  119.         ,[ScopeType] = N'".$tmp_data->PrimaryFire['ScopeType']."'
  120.         ,[ScopeZoom] = ".(double)$tmp_data->PrimaryFire['ScopeZoom']."
  121.         ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  122.         ,[IsUpgradeable] = ".(double)$tmp_data['upgrade']."
  123.         ,[IsFPS] = ".(double)$tmp_data->FPS['IsFPS']."
  124.         ,[FPSSpec0] = ".(double)$tmp_data->FPS['i0']."
  125.         ,[FPSSpec1] = ".(double)$tmp_data->FPS['i1']."
  126.         ,[FPSSpec2] = ".(double)$tmp_data->FPS['i2']."
  127.         ,[FPSSpec3] = ".(double)$tmp_data->FPS['i3']."
  128.         ,[FPSSpec4] = ".(double)$tmp_data->FPS['i4']."
  129.         ,[FPSSpec5] = ".(double)$tmp_data->FPS['i5']."
  130.         ,[FPSSpec6] = ".(double)$tmp_data->FPS['i6']."
  131.         ,[FPSSpec7] = ".(double)$tmp_data->FPS['i7']."
  132.         ,[FPSSpec8] = ".(double)$tmp_data->FPS['i8']."
  133.         ,[FPSAttach0] = ".(double)$tmp_data->FPS['d0']."
  134.         ,[FPSAttach1] = ".(double)$tmp_data->FPS['d1']."
  135.         ,[FPSAttach2] = ".(double)$tmp_data->FPS['d2']."
  136.         ,[FPSAttach3] = ".(double)$tmp_data->FPS['d3']."
  137.         ,[FPSAttach4] = ".(double)$tmp_data->FPS['d4']."
  138.         ,[FPSAttach5] = ".(double)$tmp_data->FPS['d5']."
  139.         ,[FPSAttach6] = ".(double)$tmp_data->FPS['d6']."
  140.         ,[FPSAttach7] = ".(double)$tmp_data->FPS['d7']."
  141.         ,[FPSAttach8] = ".(double)$tmp_data->FPS['d8']."
  142.         ,[AnimPrefix] = N'".($tmp_data->Model['AnimPrefix']?$tmp_data->Model['AnimPrefix']:$tmp_data['FNAME'])."'
  143.         ,[Weight] = ".(int)$tmp_data['Weight']."
  144.         ,[DurabilityUse] = ".(double)$tmp_data->Dur['u']."
  145.         ,[RepairAmount] = ".(double)$tmp_data->Dur['r1']."
  146.         ,[PremRepairAmount] = ".(double)$tmp_data->Dur['r2']."
  147.         ,[RepairPriceGD] = ".(double)$tmp_data->Dur['r3']."
  148.         ,[ResWood] = ".(int)$tmp_data->Res['r1']."
  149.         ,[ResStone] = ".(int)$tmp_data->Res['r2']."
  150.         ,[ResMetal] = ".(int)$tmp_data->Res['r3']."
  151.   WHERE [ItemID] = '".$tmp_data['itemID']."'";
  152.    echo " Status: Update<br>";
  153.    }
  154.    $stmt = sqlsrv_query($conn, $sql_cmd); }
  155.  
  156. foreach( $data->FoodArmory->Item as $tmp_data ){
  157.    $sql = "SELECT * FROM [dbo].[Items_Weapons] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  158.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  159.  
  160.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  161.    if(sqlsrv_num_rows($stmt) == 0){
  162.       $sql_cmd = "INSERT INTO [dbo].[Items_Weapons] VALUES (
  163.         ".$tmp_data['itemID']."
  164.         ,N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  165.         ,".$tmp_data['category']."
  166.         ,N'".$tmp_data->Store['name']."'
  167.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  168.         ,N'' ,N'' ,N'' ,N'' ,N'' ,N'' ,0 ,0 ,0 ,0 ,0
  169.         ,".(double)$tmp_data->Property['stamina']."
  170.         ,0 ,0 ,0
  171.         ,".(int)$tmp_data->Property['shopSS']."
  172.         ,".(double)$tmp_data->Property['health']."
  173.         ,0
  174.         ,".(double)$tmp_data->Property['toxicity']."
  175.         ,".(double)$tmp_data->Property['water']."
  176.         ,".(double)$tmp_data->Property['food']."
  177.         ,0 ,N'' ,N'' ,30 ,N'' ,0 ,0 ,0 ,0 ,0 ,0
  178.         ,".(double)$tmp_data->Store['LevelRequired']."
  179.         ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,N''
  180.         ,".(int)$tmp_data['Weight']."
  181.         ,0 ,0 ,0 ,0 ,0 ,0 ,0)";
  182.       echo " Status: New!<br>";
  183.    }else{
  184.       $sql_cmd = "UPDATE [dbo].[Items_Weapons]
  185.       SET [FNAME] = N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  186.         ,[Category] = ".$tmp_data['category']."
  187.         ,[Name] = N'".$tmp_data->Store['name']."'
  188.         ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  189.         ,[Area] = ".(double)$tmp_data->Property['stamina']."
  190.         ,[Clipsize] = ".(int)$tmp_data->Property['shopSS']."
  191.         ,[ReloadTime] = ".(double)$tmp_data->Property['health']."
  192.         ,[RateOfFire] = ".(double)$tmp_data->Property['toxicity']."
  193.         ,[Spread] = ".(double)$tmp_data->Property['water']."
  194.         ,[Recoil] = ".(double)$tmp_data->Property['food']."
  195.         ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."      
  196.         ,[Weight] = ".(int)$tmp_data['Weight']."
  197.      WHERE [ItemID] = ".$tmp_data['itemID'];
  198.    echo " Status: Update<br>";
  199.    }
  200.    $stmt = sqlsrv_query($conn, $sql_cmd);
  201. }
  202.  
  203. foreach( $data->VehicleArmory->Item as $tmp_data ){
  204.    $sql = "SELECT * FROM [dbo].[Items_Weapons] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  205.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  206.  
  207.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  208.    if(sqlsrv_num_rows($stmt) == 0){
  209.       $sql_cmd = "INSERT INTO [dbo].[Items_Weapons] VALUES (
  210.         ".$tmp_data['itemID']."
  211.         ,N'".$tmp_data->Property['fname']."'
  212.         ,".$tmp_data['category']."
  213.         ,N'".$tmp_data->Store['name']."'
  214.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  215.         ,N'' ,N'' ,N'' ,N'' ,N'' ,N'' ,0 ,0 ,0 ,0 ,0
  216.         ,".(double)$tmp_data->Property['fuel']."
  217.         ,0 ,0 ,0 ,0
  218.         ,".(double)$tmp_data->Property['durability']."
  219.         ,".(double)$tmp_data->Property['armor']."
  220.         ,0
  221.         ,".(double)$tmp_data->Property['torque']."
  222.         ,".(double)$tmp_data->Property['omega']."
  223.         ,0 ,N'' ,N'' ,30 ,N'' ,0 ,0 ,0 ,0 ,0 ,0 ,0
  224.         ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,N''
  225.         ,".(int)$tmp_data['Weight']."
  226.         ,0 ,0 ,0 ,0 ,0 ,0 ,0)";
  227.       echo " Status: New!<br>";
  228.    }else{
  229.       $sql_cmd = "UPDATE [dbo].[Items_Weapons]
  230.      SET [FNAME] = N'".$tmp_data->Property['fname']."'
  231.         ,[Category] = ".$tmp_data['category']."
  232.        ,[Name] = N'".$tmp_data->Store['name']."'
  233.        ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  234.        ,[Area] = ".(double)$tmp_data->Property['fuel']."
  235.        ,[ReloadTime] = ".(double)$tmp_data->Property['durability']."
  236.        ,[ActiveReloadTick] = ".(double)$tmp_data->Property['armor']."
  237.        ,[Spread] = ".(double)$tmp_data->Property['torque']."
  238.        ,[Recoil] = ".(double)$tmp_data->Property['omega']."
  239.      WHERE [ItemID] = ".$tmp_data['itemID'];
  240.       echo " Status: Update<br>";
  241.    }
  242.    $stmt = sqlsrv_query($conn, $sql_cmd);
  243. }
  244.  
  245. foreach( $data->CraftComponentsArmory->Item as $tmp_data ){
  246.    $sql = "SELECT * FROM [dbo].[Items_Generic] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  247.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  248.  
  249.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  250.    if(sqlsrv_num_rows($stmt) == 0){
  251.       $sql_cmd = "INSERT INTO [dbo].[Items_Generic] VALUES (
  252.         ".$tmp_data['itemID']."
  253.         ,N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  254.         ,".$tmp_data['category']."
  255.         ,N'".$tmp_data->Store['name']."'
  256.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  257.         ,0 ,0 ,0 ,0 ,0
  258.         ,".(double)$tmp_data->Store['LevelRequired']."
  259.         ,0 ,0 ,0 ,0
  260.         ,".(int)$tmp_data['Weight']."
  261.         ,0 ,0 ,0)";
  262.       echo " Status: New!<br>";
  263.    }else{
  264.       $sql_cmd = "UPDATE [dbo].[Items_Generic]
  265.       SET [FNAME] = N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  266.         ,[Category] = ".$tmp_data['category']."
  267.         ,[Name] = N'".$tmp_data->Store['name']."'
  268.         ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  269.         ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  270.         ,[Weight] = ".(int)$tmp_data['Weight']."
  271.      WHERE [ItemID] = ".$tmp_data['itemID'];
  272.       echo " Status: Update<br>";
  273.    }
  274.    $stmt = sqlsrv_query($conn, $sql_cmd);
  275. }
  276.  
  277. foreach( $data->CraftRecipeArmory->Item as $tmp_data ){
  278.    $sql = "SELECT * FROM [dbo].[Items_Generic] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  279.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  280.  
  281.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  282.    if(sqlsrv_num_rows($stmt) == 0){
  283.       $sql_cmd = "INSERT INTO [dbo].[Items_Generic] VALUES (
  284.         ".$tmp_data['itemID']."
  285.         ,N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  286.         ,".$tmp_data['category']."
  287.         ,N'".$tmp_data->Store['name']."'
  288.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  289.         ,0 ,0 ,0 ,0 ,0
  290.         ,".(double)$tmp_data->Store['LevelRequired']."
  291.         ,0 ,0 ,0 ,0
  292.         ,".(int)$tmp_data['Weight']."
  293.         ,0 ,0 ,0)";
  294.       echo " Status: New!<br>";
  295.    }else{
  296.       $sql_cmd = "UPDATE [dbo].[Items_Generic]
  297.         SET [FNAME] = N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  298.            ,[Category] = ".$tmp_data['category']."
  299.            ,[Name] = N'".$tmp_data->Store['name']."'
  300.            ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  301.            ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  302.            ,[Weight] = ".(int)$tmp_data['Weight']."
  303.         WHERE [ItemID] = ".$tmp_data['itemID'];
  304.       echo " Status: Update<br>";
  305.    }
  306.    $stmt = sqlsrv_query($conn, $sql_cmd);
  307. }
  308.  
  309. foreach( $data->GearArmory->Gear as $tmp_data ){
  310.    $sql = "SELECT * FROM [dbo].[Items_Gear] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  311.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  312.  
  313.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  314.    if(sqlsrv_num_rows($stmt) == 0){
  315.       $sql_cmd = "INSERT INTO [dbo].[Items_Gear] VALUES (
  316.         ".$tmp_data['itemID']."
  317.         ,N'".substr($tmp_data->Model['file'],29,strlen($tmp_data->Model['file'])-33)."'
  318.         ,N'".str_replace("'","''",$tmp_data->Store['name'])."'
  319.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  320.         ,".$tmp_data['category']."
  321.         ,".(int)$tmp_data['Weight']."
  322.         ,".(int)$tmp_data->Armor['damagePerc']."
  323.         ,".(int)$tmp_data->Armor['damageMax']."
  324.         ,".(int)$tmp_data->Armor['bulkiness']."
  325.         ,".(int)$tmp_data->Armor['inaccuracy']."
  326.         ,".(int)$tmp_data->Armor['stealth']."
  327.         ,0 ,0 ,0 ,0 ,0
  328.         ,".(int)$tmp_data->Armor['ProtectionLevel']."
  329.         ,".(double)$tmp_data->Store['LevelRequired']."
  330.         ,0 ,0 ,0 ,0
  331.         ,".(int)$tmp_data->Dur['u']."
  332.         ,".(int)$tmp_data->Dur['r1']."
  333.         ,".(int)$tmp_data->Dur['r2']."
  334.         ,".(int)$tmp_data->Dur['r3']."
  335.         ,0 ,0 ,0)";
  336.       echo " Status: New!<br>";
  337.    }else{
  338.       $sql_cmd = "UPDATE [dbo].[Items_Gear]
  339.         SET [FNAME] = N'".substr($tmp_data->Model['file'],29,strlen($tmp_data->Model['file'])-33)."'
  340.            ,[Name] = N'".str_replace("'","''",$tmp_data->Store['name'])."'
  341.            ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  342.            ,[Category] = ".$tmp_data['category']."
  343.            ,[Weight] = ".(int)$tmp_data['Weight']."
  344.            ,[DamagePerc] = ".(int)$tmp_data->Armor['damagePerc']."
  345.            ,[DamageMax] = ".(int)$tmp_data->Armor['damageMax']."
  346.            ,[Bulkiness] = ".(int)$tmp_data->Armor['bulkiness']."
  347.            ,[Inaccuracy] = ".(int)$tmp_data->Armor['inaccuracy']."
  348.            ,[Stealth] = ".(int)$tmp_data->Armor['stealth']."
  349.            ,[ProtectionLevel] = ".(int)$tmp_data->Armor['ProtectionLevel']."
  350.            ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  351.            ,[DurabilityUse] = ".(int)$tmp_data->Dur['u']."
  352.            ,[RepairAmount] = ".(int)$tmp_data->Dur['r1']."
  353.            ,[PremRepairAmount] = ".(int)$tmp_data->Dur['r2']."
  354.            ,[RepairPriceGD] = ".(int)$tmp_data->Dur['r3']."
  355.         WHERE [ItemID] = ".$tmp_data['itemID'];
  356.       echo " Status: Update<br>";
  357.    }
  358.    $stmt = sqlsrv_query($conn, $sql_cmd);
  359. }
  360.  
  361. foreach( $data->HeroArmory->Hero as $tmp_data ){
  362.    $sql = "SELECT * FROM [dbo].[Items_Gear] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  363.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  364.  
  365.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  366.    if(sqlsrv_num_rows($stmt) == 0){
  367.       $sql_cmd = "INSERT INTO [dbo].[Items_Gear] VALUES (
  368.         ".$tmp_data['itemID']."
  369.         ,N'".substr($tmp_data->Model['file'],29,strlen($tmp_data->Model['file'])-29)."'
  370.         ,N'".str_replace("'","''",$tmp_data->Store['name'])."'
  371.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  372.         ,".$tmp_data['category']."
  373.         ,".(int)$tmp_data['Weight']."
  374.         ,".(int)$tmp_data->HeroDesc['damagePerc']."
  375.         ,".(int)$tmp_data->HeroDesc['damageMax']."
  376.         ,".(int)$tmp_data->HeroDesc['maxHeads']."
  377.         ,".(int)$tmp_data->HeroDesc['maxBodys']."
  378.         ,".(int)$tmp_data->HeroDesc['maxLegs']."
  379.         ,0 ,0 ,0 ,0 ,0
  380.         ,".(int)$tmp_data->HeroDesc['ProtectionLevel']."
  381.         ,".(double)$tmp_data->Store['LevelRequired']."
  382.         ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0)";
  383.       echo " Status: New!<br>";
  384.    }else{
  385.          $sql_cmd = "UPDATE [dbo].[Items_Gear]
  386.         SET [FNAME] = N'".substr($tmp_data->Model['file'],29,strlen($tmp_data->Model['file'])-29)."'
  387.            ,[Name] = N'".str_replace("'","''",$tmp_data->Store['name'])."'
  388.            ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  389.            ,[Category] = ".$tmp_data['category']."
  390.            ,[Weight] = ".(int)$tmp_data['Weight']."
  391.            ,[DamagePerc] = ".(int)$tmp_data->HeroDesc['damagePerc']."
  392.            ,[DamageMax] = ".(int)$tmp_data->HeroDesc['damageMax']."
  393.            ,[Bulkiness] = ".(int)$tmp_data->HeroDesc['maxHeads']."
  394.            ,[Inaccuracy] = ".(int)$tmp_data->HeroDesc['maxBodys']."
  395.            ,[Stealth] = ".(int)$tmp_data->HeroDesc['maxLegs']."
  396.            ,[ProtectionLevel] = ".(int)$tmp_data->HeroDesc['ProtectionLevel']."
  397.            ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  398.            ,[DurabilityUse] = ".(int)$tmp_data->Dur['u']."
  399.            ,[RepairAmount] = ".(int)$tmp_data->Dur['r1']."
  400.            ,[PremRepairAmount] = ".(int)$tmp_data->Dur['r2']."
  401.            ,[RepairPriceGD] = ".(int)$tmp_data->Dur['r3']."
  402.         WHERE [ItemID] = ".$tmp_data['itemID'];
  403.       echo " Status: Update<br>";
  404.    }
  405.    $stmt = sqlsrv_query($conn, $sql_cmd);
  406. }
  407.  
  408. foreach( $data->BackpackArmory->Backpack as $tmp_data ){
  409.    $sql = "SELECT * FROM [dbo].[Items_Gear] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  410.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  411.  
  412.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  413.    if(sqlsrv_num_rows($stmt) == 0){
  414.       $sql_cmd = "INSERT INTO [dbo].[Items_Gear] VALUES (
  415.         ".$tmp_data['itemID']."
  416.         ,N'".substr($tmp_data->Model['file'],29,strlen($tmp_data->Model['file'])-33)."'
  417.         ,N'".str_replace("'","''",$tmp_data->Store['name'])."'
  418.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  419.         ,".$tmp_data['category']."
  420.         ,".(int)$tmp_data['Weight']."
  421.         ,0 ,0
  422.         ,".(int)$tmp_data->Desc['maxSlots']."
  423.         ,".(int)$tmp_data->Desc['maxWeight']."
  424.         ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0)";
  425.       echo " Status: New!<br>";
  426.    }else{
  427.       $sql_cmd = "UPDATE [dbo].[Items_Gear]
  428.         SET [FNAME] = N'".substr($tmp_data->Model['file'],29,strlen($tmp_data->Model['file'])-33)."'
  429.            ,[Name] = N'".str_replace("'","''",$tmp_data->Store['name'])."'
  430.            ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  431.            ,[Category] = ".$tmp_data['category']."
  432.            ,[Weight] = ".(int)$tmp_data['Weight']."
  433.            ,[Bulkiness] = ".(int)$tmp_data->Desc['maxSlots']."
  434.            ,[Inaccuracy] = ".(int)$tmp_data->Desc['maxWeight']."
  435.         WHERE [ItemID] = ".$tmp_data['itemID'];
  436.       echo " Status: Update<br>";
  437.    }
  438.    $stmt = sqlsrv_query($conn, $sql_cmd);
  439. }
  440.  
  441. foreach( $data->ItemsDB->Item as $tmp_data ){
  442.    $sql = "SELECT * FROM [dbo].[Items_Generic] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  443.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  444.  
  445.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  446.    if(sqlsrv_num_rows($stmt) == 0){
  447.       $sql_cmd = "INSERT INTO [dbo].[Items_Generic] VALUES (
  448.         ".$tmp_data['itemID']."
  449.         ,N'".substr($tmp_data->Store['icon'],25,strlen($tmp_data->Store['icon'])-29)."'
  450.         ,".$tmp_data['category']."
  451.         ,N'".$tmp_data->Store['name']."'
  452.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  453.         ,0 ,0 ,0 ,0 ,0
  454.         ,".(double)$tmp_data->Store['LevelRequired']."
  455.         ,0 ,0 ,0 ,0
  456.         ,".(int)$tmp_data['Weight']."
  457.         ,0 ,0 ,0)";
  458.       echo " Status: New!<br>";
  459.    }else{
  460.       $sql_cmd = "UPDATE [dbo].[Items_Generic]
  461.         SET [FNAME] = N'".substr($tmp_data->Store['icon'],25,strlen($tmp_data->Store['icon'])-29)."'
  462.            ,[Category] = ".$tmp_data['category']."
  463.            ,[Name] = N'".$tmp_data->Store['name']."'
  464.            ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  465.            ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  466.            ,[Weight] = ".(int)$tmp_data['Weight']."
  467.         WHERE [ItemID] = ".$tmp_data['itemID'];
  468.       echo " Status: Update<br>";
  469.    }
  470.    $stmt = sqlsrv_query($conn, $sql_cmd);
  471. }
  472.  
  473. foreach( $data->AttachmentArmory->Attachment as $tmp_data ){
  474.    $sql = "SELECT * FROM [dbo].[Items_Attachments] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  475.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  476.  
  477.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  478.    if(sqlsrv_num_rows($stmt) == 0){
  479.       $sql_cmd = "INSERT INTO [dbo].[Items_Attachments] VALUES (
  480.         ".$tmp_data['itemID']."
  481.         ,N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  482.         ,".(int)$tmp_data['type']."
  483.         ,N'".$tmp_data->Store['name']."'
  484.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  485.         ,N'".$tmp_data->Model['MuzzleParticle']."'
  486.         ,N'".$tmp_data->Model['FireSound']."'
  487.         ,".(double)$tmp_data->Upgrade['damage']."
  488.         ,".(double)$tmp_data->Upgrade['range']."
  489.         ,".(double)$tmp_data->Upgrade['firerate']."
  490.         ,".(double)$tmp_data->Upgrade['recoil']."
  491.         ,".(double)$tmp_data->Upgrade['spread']."
  492.         ,".(double)$tmp_data->Upgrade['clipsize']."
  493.         ,".(double)$tmp_data->Upgrade['ScopeMag']."
  494.         ,N'".$tmp_data->Upgrade['ScopeType']."'
  495.         ,N'".$tmp_data->Model['ScopeAnim']."'
  496.         ,".(int)$tmp_data['SpecID']."
  497.         ,".($tmp_data['category']?$tmp_data['category']:19)."
  498.         ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0
  499.         ,".(double)$tmp_data->Store['LevelRequired']."
  500.         ,".(int)$tmp_data['Weight']."
  501.         ,".(int)$tmp_data->Dur['u']."
  502.         ,".(int)$tmp_data->Dur['r1']."
  503.         ,".(int)$tmp_data->Dur['r2']."
  504.         ,".(int)$tmp_data->Dur['r3']."
  505.         ,0 ,0 ,0)";
  506.       echo " Status: New!<br>";
  507.    }else{
  508.       $sql_cmd = "UPDATE [dbo].[Items_Attachments]
  509.         SET [FNAME] = N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  510.            ,[Type] = ".(int)$tmp_data['type']."
  511.            ,[Name] = N'".$tmp_data->Store['name']."'
  512.            ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  513.            ,[MuzzleParticle] = N'".$tmp_data->Model['MuzzleParticle']."'
  514.            ,[FireSound] = N'".$tmp_data->Model['FireSound']."'
  515.            ,[Damage] = ".(double)$tmp_data->Upgrade['damage']."
  516.            ,[Range] = ".(double)$tmp_data->Upgrade['range']."
  517.            ,[Firerate] = ".(double)$tmp_data->Upgrade['firerate']."
  518.            ,[Recoil] = ".(double)$tmp_data->Upgrade['recoil']."
  519.            ,[Spread] = ".(double)$tmp_data->Upgrade['spread']."
  520.            ,[Clipsize] = ".(double)$tmp_data->Upgrade['clipsize']."
  521.            ,[ScopeMag] = ".(double)$tmp_data->Upgrade['ScopeMag']."
  522.            ,[ScopeType] = N'".$tmp_data->Upgrade['ScopeType']."'
  523.            ,[AnimPrefix] = N'".$tmp_data->Model['ScopeAnim']."'
  524.            ,[SpecID] = ".(int)$tmp_data['SpecID']."
  525.            ,[Category] = ".($tmp_data['category']?$tmp_data['category']:19)."
  526.            ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  527.            ,[Weight] = ".(int)$tmp_data['Weight']."
  528.            ,[DurabilityUse] = ".(int)$tmp_data->Dur['u']."
  529.            ,[RepairAmount] = ".(int)$tmp_data->Dur['r1']."
  530.            ,[PremRepairAmount] = ".(int)$tmp_data->Dur['r2']."
  531.            ,[RepairPriceGD] = ".(int)$tmp_data->Dur['r3']."
  532.         WHERE [ItemID] = ".$tmp_data['itemID'];
  533.       echo " Status: Update<br>";
  534.    }
  535.    $stmt = sqlsrv_query($conn, $sql_cmd);
  536. }
  537.  
  538. foreach( $data->LootBoxDB->LootBox as $tmp_data ){
  539.    $sql = "SELECT * FROM [dbo].[Items_Generic] WHERE [ItemID] = '".$tmp_data['itemID']."'";
  540.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  541.  
  542.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  543.    if(sqlsrv_num_rows($stmt) == 0){
  544.       $sql_cmd = "INSERT INTO [dbo].[Items_Generic] VALUES (
  545.         ".$tmp_data['itemID']."
  546.         ,N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  547.         ,".$tmp_data['category']."
  548.         ,N'".$tmp_data->Store['name']."'
  549.         ,N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  550.         ,0 ,0 ,0 ,0 ,0
  551.         ,".(double)$tmp_data->Store['LevelRequired']."
  552.         ,0 ,0 ,0 ,0
  553.         ,".(int)$tmp_data['Weight']."
  554.         ,0 ,0 ,0)";
  555.       echo " Status: New!<br>";
  556.    }else{
  557.       $sql_cmd = "UPDATE [dbo].[Items_Generic]
  558.         SET [FNAME] = N'".substr($tmp_data->Model['file'],26,strlen($tmp_data->Model['file'])-30)."'
  559.            ,[Category] = ".$tmp_data['category']."
  560.            ,[Name] = N'".$tmp_data->Store['name']."'
  561.            ,[Description] = N'".str_replace("'","''",$tmp_data->Store['desc'])."'
  562.            ,[LevelRequired] = ".(double)$tmp_data->Store['LevelRequired']."
  563.            ,[Weight] = ".(int)$tmp_data['Weight']."
  564.         WHERE [ItemID] = ".$tmp_data['itemID'];
  565.       echo " Status: Update<br>";
  566.    }
  567.    $stmt = sqlsrv_query($conn, $sql_cmd);
  568. }
  569.  
  570. foreach( $data->LootBoxDB->LootBox as $tmp_data ){
  571.    $sql = "SELECT * FROM [dbo].[Items_LootSrvModifiers] WHERE [LootID] = '".$tmp_data['itemID']."'";
  572.    $stmt = sqlsrv_query($conn, $sql , array(), array("Scrollable"=>"buffered"));
  573.  
  574.    echo "ItemID: ".$tmp_data['itemID']." Name: ".$tmp_data->Store['name'];
  575.    if(sqlsrv_num_rows($stmt) == 0){
  576.       $sql_cmd = "INSERT INTO [dbo].[Items_LootSrvModifiers] VALUES (
  577.         ".$tmp_data['itemID']."
  578.         ,100 ,100 ,200)";
  579.    }else{
  580.       $sql_cmd = "UPDATE [dbo].[Items_LootSrvModifiers]
  581.         SET [SrvNormal] = 100
  582.            ,[SrvTrial] = 100
  583.            ,[SrvPremium] = 200
  584.         WHERE [LootID] = ".$tmp_data['itemID'];
  585.       echo " Status: Update<br>";
  586.    }
  587.    $stmt = sqlsrv_query($conn, $sql_cmd);
  588. }
  589. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!