Item.sdata

[Antharix]

Ist es eigentlich möglich das level eines Lapis der erst ab 31 sockelbar ist auf Level 1 zu setzen und ihn dann in den Clienten einzufügen, sodass man in ein 15er Rüstungsteil sockeln kann OHNE das man die Item.sql in die DB einfügt?

[TeddyBear94]

im grunde über den weg den du beschrieben hast nicht! wenn es in der db geändert ist funktioniert das nicht. es sei denn du benutz den packet editor dieser erlaubt dir lvl 31+ lapis auch in 15ner rüssis zu linken.

[Philipp_]

Ja, du öffnest die Item.SData im shStudio und suchst den Lapis den du linken willst. Dann änderst du das Level auf 1, speicherst die Datei und fügst sie dann wieder in den Client ein
siehe

[TeddyBear94]

aba das sorsgt nich dafür ( wenn es inner db geändert ist) das du es linken kannst dann ö.ö

[Philipp_]

Es soll doch garnicht in der Datenbank geändert werden? Wenn man es so macht wie ich es gesagt habe, kann man einen Lapis der z.B. das Mindestlevel 31 hat, in eine 15er Rüstung linken.

[TeddyBear94]

ich bin der meinung er hat gefragt um es auf einem anderen server zu machen wenn er es jedoch auf seinem macht dann ja.

[[Dev]Blue]

Das funktioniert leider auf (fast) allen Servern, denn beim linken eines Lapis wird die DB nicht abgefragt. Ist der Lapis im Client mit Level 1 hinterlegt und in der DB mit Level 31 kann man ihn in eine zB 15er Rüstung sockeln.

[Antharix]

Gibt es eine Möglichkeit so was zu verhindern bzw zu kontrollieren?

[Shaiya-Raze]

Es git meine ich eine SQL Query womit du solche leute finden kannst, Bin mir aber nicht ganz sicher.

[Antharix]

Wenn es dieses Script geben soll wäre ich sehr daran interessiert^^

[TeddyBear94]

try this one and change the id´s of the lapis for which it should search. then just copy the results into excel and run a search function for the name of the gears

 Spoiler

* Clookup script for how a ppl link with special lapis. change it so it works for your db */
SELECT *
into #SpecLapis
FROM [PS_GameDefs].[dbo].[Items]
where [Type] = 30 and TypeID >= 233 and TypeID <= 250 and TypeID not in (240,241,242,243)

SELECT
UserID
,CharName
,i.ItemName
,l1.ItemName as 'Lapis1'
,L2.ItemName as 'Lapis2'
,L3.ItemName as 'Lapis3'
,L4.ItemName as 'Lapis4'
,L5.ItemName as 'Lapis5'
,L6.ItemName as 'Lapis6'
,SUBSTRING(Craftname,1,2) as 'Str'
,SUBSTRING(Craftname,3,2) as 'Dex'
,SUBSTRING(Craftname,5,2) as 'Rec'
,SUBSTRING(Craftname,7,2) as 'Int'
,SUBSTRING(Craftname,9,2) as 'Wis'
,SUBSTRING(Craftname,11,2) as 'Luc'
,SUBSTRING(Craftname,13,2)+'00' as 'HP'
,SUBSTRING(Craftname,15,2)+'00' as 'MP'
,SUBSTRING(Craftname,17,2)+'00' as 'SP'
,case when cast(SUBSTRING(Craftname,19,2) as int) >= 50
then cast(SUBSTRING(Craftname,19,2) as int) - 50
else cast(SUBSTRING(Craftname,19,2) as int)
end as 'Enchant'
-- ,ci.* ,i.* ,c.*
FROM [PS_GameData].[dbo].[CharItems] ci with (nolock)
inner join [PS_GameDefs].[dbo].[Items] i with (nolock)
on i.ItemID = ci.ItemID
inner join [PS_GameData].[dbo].[Chars] c with (nolock)
on c.CharID = ci.CharID
left join [PS_GameDefs].[dbo].[Items] L1 with (nolock)
on L1.TypeID = ci.Gem1
and L1.Type = 30
left join [PS_GameDefs].[dbo].[Items] L2 with (nolock)
on L2.TypeID = ci.Gem2
and L2.Type = 30
left join [PS_GameDefs].[dbo].[Items] L3 with (nolock)
on L3.TypeID = ci.Gem3
and L3.Type = 30
left join [PS_GameDefs].[dbo].[Items] L4 with (nolock)
on L4.TypeID = ci.Gem4
and L4.Type = 30
left join [PS_GameDefs].[dbo].[Items] L5 with (nolock)
on L5.TypeID = ci.Gem5
and L5.Type = 30
left join [PS_GameDefs].[dbo].[Items] L6 with (nolock)
on L6.TypeID = ci.Gem6
and L6.Type = 30
where
Gem1 in ( select TypeID from #SpecLapis )
or Gem2 in ( select TypeID from #SpecLapis )
or Gem3 in ( select TypeID from #SpecLapis )
or Gem4 in ( select TypeID from #SpecLapis )
or Gem5 in ( select TypeID from #SpecLapis )
or Gem6 in ( select TypeID from #SpecLapis )
order by
UserID, CharName


drop table #SpecLapis

not sure who posted that script or from who it is but credits to that person it isnt from me so.

[Sh1nra]

Hier ich habe auch noch ein Script es heißt einfach:

Check illegal linking of item.. kein plan wo ich es her ab

/* All Items with same lapis linked */
SELECT 
 CharName
 ,i.ItemName 
 ,l1.ItemName as 'Lapis1'
 ,L2.ItemName as 'Lapis2'
 ,L3.ItemName as 'Lapis3'
 ,L4.ItemName as 'Lapis4'
 ,L5.ItemName as 'Lapis5'
 ,L6.ItemName as 'Lapis6'
 ,SUBSTRING(Craftname,1,2) as 'Str'
 ,SUBSTRING(Craftname,3,2) as 'Dex'
 ,SUBSTRING(Craftname,5,2) as 'Rec'
 ,SUBSTRING(Craftname,7,2) as 'Int'
 ,SUBSTRING(Craftname,9,2) as 'Wis'
 ,SUBSTRING(Craftname,11,2) as 'Luc'
 ,SUBSTRING(Craftname,13,2)+'00' as 'HP'
 ,SUBSTRING(Craftname,15,2)+'00' as 'SP'
 ,SUBSTRING(Craftname,17,2)+'00' as 'MP'
 ,case when cast(SUBSTRING(Craftname,19,2) as int) >= 50
   then cast(SUBSTRING(Craftname,19,2) as int) - 50
   else cast(SUBSTRING(Craftname,19,2) as int)
   end as 'Enchant'
 ,*
FROM [PS_GameData].[dbo].[CharItems] ci with (nolock)
 inner join [PS_GameDefs].[dbo].[Items] i with (nolock)
  on i.ItemID = ci.ItemID
 inner join [PS_GameData].[dbo].[Chars] c with (nolock)
  on c.CharID = ci.CharID
 left join [PS_GameDefs].[dbo].[Items] L1 with (nolock)
  on L1.TypeID = ci.Gem1
  and L1.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L2 with (nolock)
  on L2.TypeID = ci.Gem2
  and L2.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L3 with (nolock)
  on L3.TypeID = ci.Gem3
  and L3.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L4 with (nolock)
  on L4.TypeID = ci.Gem4
  and L4.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L5 with (nolock)
  on L5.TypeID = ci.Gem5
  and L5.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L6 with (nolock)
  on L6.TypeID = ci.Gem6
  and L6.Type = 30

where 
	(	Gem1 = Gem2
	or	Gem1 = Gem3
	or	Gem1 = Gem4
	or	Gem1 = Gem5
	or	Gem1 = Gem6
	or	Gem2 = Gem3
	or	Gem2 = Gem4
	or	Gem2 = Gem5
	or	Gem2 = Gem6
	or	Gem3 = Gem4
	or	Gem3 = Gem5
	or	Gem3 = Gem6
	or	Gem4 = Gem5
	or	Gem4 = Gem6
	or	Gem5 = Gem6
	)
	and Gem6 <> 0
	
	
	
/* All Items with same lapis linked */
SELECT 
 CharName
 ,i.ItemName 
 ,l1.ItemName as 'Lapis1'
 ,L2.ItemName as 'Lapis2'
 ,L3.ItemName as 'Lapis3'
 ,L4.ItemName as 'Lapis4'
 ,L5.ItemName as 'Lapis5'
 ,L6.ItemName as 'Lapis6'
 ,SUBSTRING(Craftname,1,2) as 'Str'
 ,SUBSTRING(Craftname,3,2) as 'Dex'
 ,SUBSTRING(Craftname,5,2) as 'Rec'
 ,SUBSTRING(Craftname,7,2) as 'Int'
 ,SUBSTRING(Craftname,9,2) as 'Wis'
 ,SUBSTRING(Craftname,11,2) as 'Luc'
 ,SUBSTRING(Craftname,13,2)+'00' as 'HP'
 ,SUBSTRING(Craftname,15,2)+'00' as 'SP'
 ,SUBSTRING(Craftname,17,2)+'00' as 'MP'
 ,case when cast(SUBSTRING(Craftname,19,2) as int) >= 50
   then cast(SUBSTRING(Craftname,19,2) as int) - 50
   else cast(SUBSTRING(Craftname,19,2) as int)
   end as 'Enchant'
 ,*
FROM [PS_GameData].[dbo].[CharItems] ci with (nolock)
 inner join [PS_GameDefs].[dbo].[Items] i with (nolock)
  on i.ItemID = ci.ItemID
 inner join [PS_GameData].[dbo].[Chars] c with (nolock)
  on c.CharID = ci.CharID
 left join [PS_GameDefs].[dbo].[Items] L1 with (nolock)
  on L1.TypeID = ci.Gem1
  and L1.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L2 with (nolock)
  on L2.TypeID = ci.Gem2
  and L2.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L3 with (nolock)
  on L3.TypeID = ci.Gem3
  and L3.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L4 with (nolock)
  on L4.TypeID = ci.Gem4
  and L4.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L5 with (nolock)
  on L5.TypeID = ci.Gem5
  and L5.Type = 30
 left join [PS_GameDefs].[dbo].[Items] L6 with (nolock)
  on L6.TypeID = ci.Gem6
  and L6.Type = 30

where 
	(	Gem1 <> 0
	or	Gem2 <> 0
	or	Gem3 <> 0
	or	Gem4 <> 0
	or	Gem5 <> 0
	or	Gem6 <> 0
	)
	And i.ItemName = 'xxx' -- Item name here

[Antharix]

Das Script hab ich auch aber kann man da nur nach Lapis suchen oder auch nach Rüstungen und Waffen?

[TeddyBear94]

bei meinem script geht beides

[Antharix]

TeddyBear bei deinem Script bekomme ich die Fehlermeldung:

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'FROM'.

Will ehrlich gesagt auch nicht wahr los irgendwas löschen, desweiteren ahb ich auch nichts gefunden wo ich ein Item eintragen kann?