# How to add all items to a penguin, and how to change someone's password in HeidSQL

**URL:** <https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477>\
**Category:** Requests\
**Created:** [January 8, 2022, 7:23pm UTC](https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477 "2022-01-08T19:23:23Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alkz7](https://solero.me/letter_avatar_proxy/v4/letter/a/cc9497/32.png) [@Alkz7](https://solero.me/u/Alkz7)\
**Post date:** [January 8, 2022, 7:23pm UTC](https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477/1 "2022-01-08T19:23:24Z")

</div>

Hi, I would like to know if someone could teach me how to add all items to a particular penguin and also how to change a player’s password. I use HeidSQL! Thanks for listening 🙂

---

<div class="post-metadata">

**Author:** ![hangardonell](https://solero.me/user_avatar/solero.me/hangardonell/32/646_2.png) [@hangardonell](https://solero.me/u/hangardonell)\
**Post date:** [January 10, 2022, 8:37pm UTC](https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477/2 "2022-01-10T20:37:23Z")

</div>

You probably have to do a query. I don’t know heidisql so you should see how to go to the “query” button

Assuming you are using houdini asyincio:

For create a new password, generate a new has here: [Houdini Password Hash Generator](https://toolbox.solero.me/houdini-hash-gen/)

Next, get the id of your penguin using this query:

```auto
SELECT "id" FROM "penguin" WHERE "username" = lower('YOUR_PENGUIN');

```

Now, change the penguin password by id

```auto
UPDATE "penguin"
SET password = 'your_hash_here'
WHERE id = YOUR_ID; --Without quotes

```

that is enough for change your penguin password

Now, for add ALL Items you can use a houdini plugin, but in SQL, the easiest way to do that is:

```auto
DELETE from "penguin_item" WHERE penguin_id = YOUR_ID_HERE ;
INSERT INTO "penguin_item" 
SELECT YOUR_PENGUIN_ID_HERE, i.id FROM item i;

```

---

<div class="post-metadata">

**Author:** ![Alkz7](https://solero.me/letter_avatar_proxy/v4/letter/a/cc9497/32.png) [@Alkz7](https://solero.me/u/Alkz7)\
**Post date:** [January 11, 2022, 3:42am UTC](https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477/3 "2022-01-11T03:42:14Z")

</div>

Thanks for the tip, if it’s not too much to ask can you tell me how I can use the example commands. !ai !transform !tp !ac these commands don’t work it looks like they are disabled or not working.

---

<div class="post-metadata">

**Author:** ![hangardonell](https://solero.me/user_avatar/solero.me/hangardonell/32/646_2.png) [@hangardonell](https://solero.me/u/hangardonell)\
**Post date:** [January 11, 2022, 4:33pm UTC](https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477/4 "2022-01-11T16:33:10Z")

</div>

Sure, you can use the [essentials plugin](https://github.com/solero/essentials)

---

<div class="post-metadata">

**Author:** ![Alkz7](https://solero.me/letter_avatar_proxy/v4/letter/a/cc9497/32.png) [@Alkz7](https://solero.me/u/Alkz7)\
**Post date:** [January 13, 2022, 2:08am UTC](https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477/5 "2022-01-13T02:08:11Z")

</div>

Thanks again but I have no idea how to use this plugin and it is very difficult to find a tutorial.

---

<div class="post-metadata">

**Author:** ![hangardonell](https://solero.me/user_avatar/solero.me/hangardonell/32/646_2.png) [@hangardonell](https://solero.me/u/hangardonell)\
**Post date:** [January 13, 2022, 11:43pm UTC](https://solero.me/t/how-to-add-all-items-to-a-penguin-and-how-to-change-someones-password-in-heidsql/477/6 "2022-01-13T23:43:39Z")

</div>

Simply add the plugin folder into the “plugins” folder in houdini/houdini/plugins folder :))