ays297 Posted November 17, 2012 Posted November 17, 2012 Is it possible for an npc to give a random item that is a headgear? I'm thinking of doing an query_sql but it's not really that good. Quote
Ajjwidjdneidjenw Posted November 17, 2012 Posted November 17, 2012 Could you be a little bit more specific? Quote
Emistry Posted November 17, 2012 Posted November 17, 2012 like this ? http://pastebin.com/raw.php?i=RXRhUSqt Quote
ays297 Posted November 17, 2012 Author Posted November 17, 2012 Something like Emistry made. @Emistry, because of the 'else' part, i'll just ask if there are times that this npc won't give an item? Quote
Emistry Posted November 17, 2012 Posted November 17, 2012 if( query_sql( "SELECT `id` FROM `item_db` WHERE `type`='5' AND `equip_locations`='256' ORDER BY RAND() LIMIT 1",.@ItemID ) ){ this line... used to return an item ID from the item_db sql .... and it will only select headgear... for the else part... it will only run this part if above statement failed to return any result from the query... it will only happen if the query failed...or your dont have item_db table in your SQL machine....or you dont have database for headgear in item_db Quote
ays297 Posted November 17, 2012 Author Posted November 17, 2012 I see. I'll test this tomorrow. Thanks Emistry! Quote
Question
ays297
Is it possible for an npc to give a random item that is a headgear? I'm thinking of doing an query_sql but it's not really that good.
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.