[TrinityCore] Stored Procedures for Creating Accounts

[Valkryst]

Deleted - GDPR

[TheMause]

With risk of sounding stupid, how do I use these procedures?

[stoneharry]

With risk of sounding stupid, how do I use these procedures?

If I remember the syntax for MySQL off the top of my head:

exec stored_procedure_name(arguments);

e.g:

exec create_account ("MyUsername", "MyPassword");

Also thanks OP, this is actually useful.

[Valkryst]

To use a procedure you just need to pick the one that works for you, then open up whatever program you use to edit your database (I use HeidiSQL), select the auth database, copy-paste the procedure into the query window, and then execute the query. After that you just need to use another query such as CALL create_account("username", "password"); to create an account.
Edit:
Just noticed stoneharry's comment above after posting this. EXEC may also work as an alternative to CALL, but I've never used it before so I cannot say for sure.

[tmillagegbc]

With risk of sounding stupid

[stoneharry]

Just wanted to say again that this is actually really useful. I like the idea of stored procedures being used more often in WoW emulation. Linked a few people here when they ask how to make a registration script and things like that.

[Valkryst]

Just wanted to say again that this is actually really useful. I like the idea of stored procedures being used more often in WoW emulation. Linked a few people here when they ask how to make a registration script and things like that.

Thanks again, hopefully it helps out a lot of people. ^.^

I couldn't agree more about the use of stored procedures. They can be used nearly anywhere, they speed-up development time, add in a safety net against any angry developers, prevent simple errors by incorrectly-typed SQL, and a variety of other things. It might be a good idea to write up a simple tutorial on how to write some basic stored procedures eventually; I'll look into it when I have some free time.