Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[RELEASE] Database creation and management scripts

RZA-PT | KilroyPT
Joined
Aug 27, 2007
Messages
936
Reaction score
85
I've made up some SQL scripts for creating the databases required to run a PT server.

There's a readme in there, read it, (if you're too lazy just understand you need to execute Create_AccountDB.sql first as it creates the login as well that is referenced in each DB created.)

It creates a service account for you to use in the game (if you use SA for the game you're downright stupid :glare:)
It uses a generic password, I recommend changing the password to be unique / harder to crack.

It also has some tools (scripts, procedures and functions) for checking account block status / blocking and unblocking accounts.

Here it is:
Also located on my website (See my signature block)

Credits to me, if you use them / alter them remember to give credit where credits due.

Version 1.0:
View attachment PT_SQL_Scripts_Ver_01.zip
 

Attachments

You must be registered for see attachments list
Back
Top