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?
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.
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
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.
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.
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
* 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.
Hier ich habe auch noch ein Script es heißt einfach:
Check illegal linking of item.. kein plan wo ich es her ab
Code:
/* 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
[HELP]Item.SData 10/28/2011 - Shaiya Private Server - 1 Replies can someone please make a video tutoral or tell me how to put items into the Item.SData? because i have ep5 server and i cant figure out how to put the items in the Item.SData.
:rtfm: >:D
[Help] item.sdata 06/29/2011 - Shaiya Private Server - 2 Replies Hello friends ^ ^
I have a big problem, have a 4.5 client on shaiya. There have also been extracted with Shaiya Data File Tool, we therefore also access to the item.sdata. However, when I see it with the Shstudio open, then he shows me the weapons are no free slots more. I tested the weapons in the? . line who has and would make it available for download? plssss
RaZoR
RaZoR elite*gold spenden
Item.sdata Problem 06/22/2011 - Shaiya Private Server - 2 Replies In Deutsch:
Hallo Leute,
ich hab da mal ein Problem :) Und zwar, habe ich mir einen kleinen Test Server aus Spaß gemacht und nun hänge ich beim Editieren der Dropps fest.
Habe mit dem Shaiya Data File Tool von Lilprohacker die Item.SData extrahiert,
einen Namen eines Droppes geändert ( mit HxD Hex Editor ) und sie anschließend wieder importiert. Hoffe soweit war das alles richtig *.*
So nun habe ich die game.exe gestartet, wollte auf den Server connecten... dann habe ich den Error :...
[HELP]Item.SData & NPCQuest.SData 02/28/2011 - Shaiya Private Server - 2 Replies Ok there is 2 parts to where I need help so let me try and explain this as clearly as I can so that someone can understand and hopefully come up with a solution.
I have been trying to create an NPC of my own, and I have followed tutorials to the exact steps, and every time I make it and throw in my patch the NPC is always a cow *Note* that was editing it via in CSV format using a Open Office Table. Now I have even tried to modify an existing NPC through Hex (including the name, items, etc)...
Connection between *.itm and Item.SData 02/05/2011 - Shaiya Private Server - 4 Replies I spent a lot of time to find the conection between *.itm and Item.sdata but i still can't find down.
Any opinions or ideas will be appreciated.
Thanks a lot
wenn er es jedoch auf seinem macht dann ja.
