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

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 :slightly_smiling_face:

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

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

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

Now, change the penguin password by id

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:

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

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.

Sure, you can use the essentials plugin

1 Like

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

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

1 Like