Drop groups

02/12/2012 06:26 akindain#1

Hello all i am having trouble getting all the #'s in the drop group to show up as actual item names so i can get rid of the crappy basic stones and the card drops and change a few other things. I am using this to search trough it,

Code:

SELECT ITEM.drop_item_id_00, STRING.value
FROM Arcadia.dbo.DropGroupResource ITEM, Arcadia.dbo.StringResource STRING
WHERE item.drop_item_id_00 = string.code
-- replace the 00 with #'s 00 through 05
ORDER BY value ASC

and it ONLY brings up 1749 items of the total 4264 and from what i can tell so far from id_00 to id_05 its same items in sets of 10 and all seem to be armor and weapons.

Looking for any comments or help on this issue or a easier search option.

Thanks in advance and thanks for your time reading this.

02/12/2012 07:26 Xijezu#2

Code:

SELECT DropGroupResource.drop_item_id_00, StringResource.value 
FROM DropGroupResource LEFT JOIN StringResource 
ON DropGroupResource.drop_item_id_00 + 100000 = StringResource.code
-- WHERE StringResource.value LIKE '%Your Search Here%'

Item-ID is not the Name-ID. Thats something different. ;)

02/12/2012 08:23 akindain#3

i fully admit that im still learning to use SQL but i tried mixing the two

Code:

SELECT drop_item_id_00, STRING.value
FROM Arcadia.dbo.DropGroupResource, Arcadia.dbo.StringResource STRING
ON DropGroupResource.drop_item_id_00 + 100000 = StringResource.code
WHERE StringResource.value LIKE cards

and the ON is the only thing underlines and it gives me this error

Code:

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

Am i screwing this up and sounding very noobish or or just over thinking and its easier then im making it out to be ?

02/12/2012 08:34 TheOnlyOneRaskim#4

Im not sure, but this should work.

SELECT drop_item_id_00, value
FROM Arcadia.dbo.DropGroupResource
LEFT JOIN Arcadia.dbo.StringResource STRING
ON DropGroupResource.drop_item_id_00 + 100000 = code
WHERE value LIKE '%cards%'

02/12/2012 08:37 Xijezu#5

Quote:

Originally Posted by Xijezu

Code:

SELECT DropGroupResource.drop_item_id_00, StringResource.value 
FROM DropGroupResource LEFT JOIN StringResource 
ON DropGroupResource.drop_item_id_00 + 100000 = StringResource.code
-- WHERE StringResource.value LIKE '%Your Search Here%'

This is the only working Syntax for that.

02/12/2012 08:48 akindain#6

@ TheOnlyOneRaskim - well that gave me no errors and seems to work when i look for main wearable items not anything im actually looking for

@ Xijezu - i get this for an error and all of it shows up red underline for error

Msg 208, Level 16, State 1, Line 1
Invalid object name 'DropGroupResource'.