Mcfarlin Posted December 25, 2015 Share Posted December 25, 2015 When making a new item, would it be of any help to have this page to compare your new item to items already in your game? Not having to go back and look up info in the Db to see where a new item will fit into the game You can use this to look at all items and decide what values your new item should have so it fits in with the others already added. Simple little addon, not so sure i would even call it a mod. But hey its free. Call the file whatever you would like, and add link in your game where ever you would like it to go. You can add a user level restriction if you do not want members to see the page. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Obviously you can edit to fit your item types. I am sure there is an easier way to do this, but . . . . this is how i have done it. Screenshot http://postimg.org/image/w9gaprjm1/ Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted December 25, 2015 Share Posted December 25, 2015 Not a bad idea, I've done something similar for my clients. It may not be as clean (visually), but using 1 query can also be ok You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. NOTE: This is untested and it ain't pretty either Quote Link to comment Share on other sites More sharing options...
Mcfarlin Posted December 25, 2015 Author Share Posted December 25, 2015 I knew it could be dones a lot easier than my way. And yes it comes in handy once you have a few hundred items in a game to be able to just pull up this list and see where a gap may be, or where you want to add your new item to fit in with all the others. thx for adding that. I tested and it works fine, better actually with your additions. Quote Link to comment Share on other sites More sharing options...
Veramys Posted December 25, 2015 Share Posted December 25, 2015 For people that have hundreds of items you could just let someone search by item type and then display all by that item type id. Quote Link to comment Share on other sites More sharing options...
Mcfarlin Posted December 25, 2015 Author Share Posted December 25, 2015 I made it more for me, not so much for the users. Wanted to be able to see a full list of items so that when adding a new item i could make sure to fit it into the game properly. Quote Link to comment Share on other sites More sharing options...
Veramys Posted December 25, 2015 Share Posted December 25, 2015 I know what you made it for, I meant like games that have 100s of items. My game has over 200 items. Quote Link to comment Share on other sites More sharing options...
Mcfarlin Posted December 25, 2015 Author Share Posted December 25, 2015 Like the hall of fame in mccodes. I like the idea, will have to give it a try. Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted December 26, 2015 Share Posted December 26, 2015 I made it more for me, not so much for the users. Wanted to be able to see a full list of items so that when adding a new item i could make sure to fit it into the game properly. Added search by item type and item name You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
Mcfarlin Posted December 26, 2015 Author Share Posted December 26, 2015 (edited) Looks amazing after that. PHP notice: Undefined Index : itmbuyable (8) on line 62 with error reporting on but it doesn't stop the page from working. tested and works great as is. Edited December 26, 2015 by Mcfarlin Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted December 26, 2015 Share Posted December 26, 2015 Looks amazing after that. PHP notice: Undefined Index : itEmbuyable (8) <-- its the extra e in there that is not needed. on line 62 with error reporting on but it doesn't stop the page from working. tested and works great as is. That doesn't exist in my code, no idea why you're getting that error O.o Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted December 26, 2015 Share Posted December 26, 2015 I made it more for me, not so much for the users. Wanted to be able to see a full list of items so that when adding a new item i could make sure to fit it into the game properly. I can't find the articles now since the upgrade to the forum but a_b created an article about storing your items inside an excel or equivalent spreadsheet. I created one (still needs work) for the NWE engine but you can use it to get a general idea of how to maybe convert it over to use for MCC. The only hard part is trying to serialize your data. Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted December 26, 2015 Share Posted December 26, 2015 I can't find the articles now since the upgrade to the forum but a_b created an article about storing your items inside an excel or equivalent spreadsheet. I created one (still needs work) for the NWE engine but you can use it to get a general idea of how to maybe convert it over to use for MCC. The only hard part is trying to serialize your data. Shoot me a link! If nothing else, I'm curious Quote Link to comment Share on other sites More sharing options...
Mcfarlin Posted December 26, 2015 Author Share Posted December 26, 2015 That doesn't exist in my code, no idea why you're getting that error O.o yeah i added the E when typing it out, its not in the code but that is the error given. its non critical and the page runs fine. Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted December 26, 2015 Share Posted December 26, 2015 Don't add an E then :P Quote Link to comment Share on other sites More sharing options...
Mcfarlin Posted December 26, 2015 Author Share Posted December 26, 2015 lol I only added it in the post. It is not in the code, but the error persists. Its nothing really other than an annoyance to know its there. Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted December 26, 2015 Share Posted December 26, 2015 Shoot me a link! If nothing else, I'm curious Oops, I meant to add the link haha https://docs.google.com/spreadsheets/d/1DOS2Ds6smJCTOcBUHt2QQKQkc0hr_Av6YLvI7X3aVrc/edit?usp=docslist_api Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted December 30, 2015 Share Posted December 30, 2015 (edited) Oops, I meant to add the link haha https://docs.google.com/spreadsheets...p=docslist_api That list is incomplete. But I believe I can run a pretty easy conversion - CSV -> SQL :) Edited December 30, 2015 by Magictallguy Minor typo Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted December 30, 2015 Share Posted December 30, 2015 That list is incomplete. But I believe I can run a pretty easy conversion - CSV -> SQL :) I never finished it so yeah it's incomplete. The only problem is getting serialize to work in excel. Currently it's not very dynamic Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted December 31, 2015 Share Posted December 31, 2015 I never finished it so yeah it's incomplete. The only problem is getting serialize to work in excel. Currently it's not very dynamic Put the to-be-serialized data into separate columns. Make the PHP do the rest ;) Quote Link to comment Share on other sites More sharing options...
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.