Needs a Script for Adding Items name in my SQL 2008 (EP6 Item)

[Dotzie]

Hey, Thx again for all the help i got on the way Setup my Server.

Now the server are running perfect, But im looking into the SQL to find the EP6 item (ID)

Problem are there is NO names on any of the Armor/Weap/Lapis or Item at all.
Just ID and TypeID etc.

Then i setup my SQL last time (2 Years ago) I hade to add a script into the Query If i do remmember.

If this is true, Could anyone Send me the Query "Or" Link to a place i can get it.
An guide to refreash my memmory hade not been wrong to tho.

And thanks ALOT again for the help on last Topics (:

[zokylove]

EP6 Item.sql

[Dotzie]

Ty alot (:

Originally Posted by zokylove

EP6 Item.sql

I did Excute the file and it succesed. But its only showing Weapon.

I know you may need to do a Change in the options of the SQL server. But I cant remmember were. Any ide? and Thx again

[zokylove]

Try this script and tell me if u get any result

Use [PS_GameDefs]
SELECT *FROM Items WHERE Type = 32

It will show you the top gear codes for UoF.
and in SQL Database manager right click on table and click on select top 1000 or some ting like that because i don't have a data manager installed right now so i don't know if it is "select top 1000" but i am 90% sure of it.

[Dotzie]

Originally Posted by zokylove

Try this script and tell me if u get any result

Use [PS_GameDefs]
SELECT *FROM Items WHERE Type = 32

It will show you the top gear codes for UoF.
and in SQL Database manager right click on table and click on select top 1000 or some ting like that because i don't have a data manager installed right now so i don't know if it is "select top 1000" but i am 90% sure of it.

Yes its "select top 1000 Rows" But then im looking thru all the Rows its only Weapons in the list.

[zokylove]

are u sure ? because its strange .u don't see the codes over item type 15 ?if u use the query i given u in above reply do you get any query rows ?

[Dotzie]

Btw, Those EP6 Gear/Items are the Tenations and Rytia sets (Old 5.6 armor) I wanted the New Armor sets the once i think but not sure is for EP6.3 The O/P sets got Wings on the Back :P Got any script for them or they are in this script but not Named yet?

Originally Posted by zokylove

are u sure ? because its strange .u don't see the codes over item type 15 ?if u use the query i given u in above reply do you get any query rows ?

It worked tho, Thx. Just reliced it. But its still only showing the names of old 70 gear. Idk if the newer EP6 Gear sets are Hided in this script without Names atm tho.

[zokylove]

its the ep 6 gear

Use [PS_GameDefs]
SELECT *FROM Items Where Reqlevel > 70

Ep 6 Gear is not in Type 32 its in 88 and above.
Use the query and you will find them