ays297 Posted November 17, 2012 Group: Members Topic Count: 24 Topics Per Day: 0.00 Content Count: 49 Reputation: 0 Joined: 11/30/11 Last Seen: November 2, 2014 Share 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 Link to comment Share on other sites More sharing options...
Ajjwidjdneidjenw Posted November 17, 2012 Group: Members Topic Count: 15 Topics Per Day: 0.00 Content Count: 161 Reputation: 31 Joined: 12/06/11 Last Seen: December 25, 2022 Share Posted November 17, 2012 Could you be a little bit more specific? Quote Link to comment Share on other sites More sharing options...
Emistry Posted November 17, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: 5 hours ago Share Posted November 17, 2012 like this ? http://pastebin.com/raw.php?i=RXRhUSqt Quote Link to comment Share on other sites More sharing options...
ays297 Posted November 17, 2012 Group: Members Topic Count: 24 Topics Per Day: 0.00 Content Count: 49 Reputation: 0 Joined: 11/30/11 Last Seen: November 2, 2014 Author Share 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 Link to comment Share on other sites More sharing options...
Emistry Posted November 17, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: 5 hours ago Share 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 Link to comment Share on other sites More sharing options...
ays297 Posted November 17, 2012 Group: Members Topic Count: 24 Topics Per Day: 0.00 Content Count: 49 Reputation: 0 Joined: 11/30/11 Last Seen: November 2, 2014 Author Share Posted November 17, 2012 I see. I'll test this tomorrow. Thanks Emistry! Quote Link to comment Share on other sites More sharing options...
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.
Link to comment
Share on other sites
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.