Distributing items through phpMyAdmin

Hello everyone! ^^

I have the upgraded version of the shop mod installed, and I was wondering how I would go about if I want to give out a specific item to all the users on my forum though phpMyAdmin.

Say I have an item named 'kitty' that I'd like to give out to all my forum members, but handing it out manually to more than 10k accounts would be quite a task for a single human being. ^^; So my question is if there is a way to make this automatically instead? I don't really need any fancy script or anything, a simple query I can manually run through the database is plenty enough for me. Just something crude and dirty that makes the item 'kitty' automagically appear in every user's inventory.

I'd also like to express my gratitude for the upgraded effect shop. I have had it on my board for quite a while now, and it's working great without any problems.
Thanks for reading this, and keep up the good work everyone!

Unfortunately this can't be done with a simple query due to the way items are stored in the new shop. You have to select the user ids and item details, and then build an insert query for each user. With 10k users, you're looking at 10k queries at least.

I will make a script to give everyone an item though. I know I'm going to need that eventually myself, so I'm glad you brought the subject up. It may take me a few days to get it done, as I have some other stuff I need to get out of the way first.

Thank you so much for your quick reply Thoul, I sincerely appreciate it.

I should have figured distributing items wouldn't be that simple, but a girl can wish, right? Thank you for looking into this request, and good luck with your other projects.

Happy holidays!

I have this done now, except for a little bit of documentation. I'll try to get it all together and upload it this weekend.

That was quick! Thank you so much for working on this. You're saving my butt here as I have spoiled my forum members with a present in previous editions of my annual advent calendar, and now they are all expecting an item for Christmas, and I was sure I'd be chased by an angry mob armed with pitchforks this year for not distributing one ^^;
So really, thank you for doing this!

No problem. I know how it is, we gave out a Christmas present at a forum I help out with last year, so I expect everyone there will be looking forward to getting one this year, too.

I've put the script up for download, you can find it here:
http://www.phpbbsmith.com/hacks/item-giver.php

Just wanted to let you know that I have tested this script, and it worked perfectly. I especially liked the option of being able to give items to activated accounts only, since the distribution of items to unactivated accounts has actually been a concern for several users on my forum. So again, thank you so much for your fast and fantastic work!

No problem, I'm glad you like it. I tried to include a couple of features that I thought might be useful, I'm glad that came in handy for you.