Register for your free account! | Forgot your password?

You last visited: Today at 15:00

  • Please register to post and access all features, it's quick, easy and FREE!

 

Drop groups

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2012
Posts: 32
Received Thanks: 1
Drop groups

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.



akindain is offline  
Old   #2


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
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.


Xijezu is offline  
Old   #3
 
elite*gold: 0
Join Date: Feb 2012
Posts: 32
Received Thanks: 1
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 ******** this up and sounding very noobish or or just over thinking and its easier then im making it out to be ?
akindain is offline  
Old   #4
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
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%'


TheOnlyOneRaskim is offline  
Old   #5


 
elite*gold: 30
Join Date: May 2011
Posts: 4,795
Received Thanks: 3,179
Quote:
Originally Posted by Xijezu View Post
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.
Xijezu is offline  
Old   #6
 
elite*gold: 0
Join Date: Feb 2012
Posts: 32
Received Thanks: 1
@ 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'.


akindain is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Mc Bukkit 733 groups
hay, Gibt es für die neue version von bukkit auf nitrado ein group manager der ganz einfach ist willl einfach nur das z.b in verschieden farben...
4 Replies - Minecraft
[Help]If You Don't Have Any Server Groups!
This is for the "New China Pserver" Or "Tz2moons"! If you cant see any server groups..Go to your Dekaron folder and Open your server.configuration...
9 Replies - Dekaron Private Server
Go Into BG With different lvl groups
If you have a lvl say 15 (or between 10 19) and you signup for e.g. wsg you will be in the waiting list for group of 10 to 19s. If you disconnect...
3 Replies - WoW Exploits, Hacks, Tools & Macros
Bot Groups
If i am correct there are some groups/people here who build a stand alone packet bot there should be 3 if i remember correct maybe more and i...
10 Replies - CO2 Main - Discussions / Questions



All times are GMT +2. The time now is 15:00.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.