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
Or tell me how do i check it in DB
Thanks in advance
[looking for]New Items ID's
04/29/2012 12:18
Denis9518#1
04/29/2012 12:29
Xijezu#2
Use the fckng Search.......
04/29/2012 13:00
bwr_62#3
SQL -> Arcadia -> ItemResource.
Good search :)
Good search :)
04/29/2012 13:28
Modamer9#4
use brain
go
select Idea from brain
go
select Idea from brain
04/29/2012 14:00
ptifou78#5
Error Dbo.Brain Not found... \o/
04/29/2012 19:05
Strange2010#6
XDQuote:
Error Dbo.Brain Not found... \o/
04/29/2012 21:16
₡ĦŘǾ₥£#7
try to search brain.exe in google
04/29/2012 21:24
sdone#8
would be to easy to give him an answer? just everbody spam shit in the topic.
04/29/2012 22:07
c1ph3r#9
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%'
FROM ARCADIA.dbo.ItemResource ITEM, ARCADIA.dbo.StringResource STRING
WHERE STRING.code=ITEM.name_id and STRING.value like '%Searchterm%'
04/29/2012 23:50
ismokedrow#10
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
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
04/30/2012 01:22
Xijezu#11
ehhh, wtf?Quote:
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
Whats the sence on the nolock thingly? o.0
also ItemResource has the column name_id, not name_text_id....
04/30/2012 01:23
ismokedrow#12
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
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
04/30/2012 02:06
haxti#13
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.
04/30/2012 02:06
pavilion82#14
[Only registered and activated users can see links. Click Here To Register...]Quote:
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
04/30/2012 02:12
ismokedrow#15
You still can't be original?Quote: