[looking for]New Items ID's

[Denis9518]

Anybody got new item's ID's including dura equips/Master equips and skill card + all pets id's ?
Or tell me how do i check it in DB
Thanks in advance

[Xijezu]

Use the fckng Search.......

[bwr_62]

SQL -> Arcadia -> ItemResource.

Good search

[Modamer9]

use brain
go
select Idea from brain

[ptifou78]

Error Dbo.Brain Not found... \o/

[Strange2010]

Originally Posted by ptifou78

Error Dbo.Brain Not found... \o/

XD

[₡ĦŘǾ₥£]

try to search brain.exe in google

[sdone]

would be to easy to give him an answer? just everbody spam **** in the topic.

[c1ph3r]

SELECT ITEM.id, STRING.value
FROM ARCADIA.dbo.ItemResource ITEM, ARCADIA.dbo.StringResource STRING
WHERE STRING.code=ITEM.name_id and STRING.value like '%Searchterm%'

[ismokedrow]

USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
WITH (NOLOCK) INNER JOIN dbo.StringResource S
WITH (NOLOCK) ON I.name_text_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_text_id ASC

[Xijezu]

Originally Posted by ismokedrow

USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
WITH (NOLOCK) INNER JOIN dbo.StringResource S
WITH (NOLOCK) ON I.name_text_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_text_id ASC

ehhh, wtf?
Whats the sence on the nolock thingly? o.0
also ItemResource has the column name_id, not name_text_id....

[ismokedrow]

Well then why don't you just correct it? Oh that's right because you have this whole superiority thing going on. Forgot, here we go with you and your minion's huh?

CORRECTED BY XIJEZU (So he can have his fame, you know how girls act when they want to be the prettiest)

USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
INNER JOIN dbo.StringResource S
ON I.name_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_id ASC

[haxti]

NOLOCK is pretty handy but not needed for a "small" query like this i'd say. It just reduces the overhead for a query but on the other hand you can't be 100% sure about the data you get, cause it could be under update the same moment.

[pavilion82]

Originally Posted by ismokedrow

Well then why don't you just correct it? Oh that's right because you have this whole superiority thing going on. Forgot, here we go with you and your minion's huh?

CORRECTED BY XIJEZU (So he can have his fame, you know how girls act when they want to be the prettiest)

USE Arcadia
SELECT I.id, S.value
FROM dbo.ItemResource I
INNER JOIN dbo.StringResource S
ON I.name_id = S.Code AND S.name LIKE '%name_item_%'
ORDER BY name_id ASC

[ismokedrow]

Originally Posted by pavilion82

You still can't be original?