[HELP] How to host multiple PK tournament?

[Saraiyu]

is there a script and/or trick required with navicat to make more than one pkt? i am really interested in finding out how!

[King_Arthur]

Check out this thread:

Specifically, my post:

Originally Posted by King_Arthur

The easiest way to do this would be to make several maintenance scripts to change the time of your pk tournament. One for every day you want to do your pk tournament. (So if you want to do mon &fri you would have 2 scripts). You would use your task manager to run the script pktourmon.bat on sunday night and pktourfri on thursday night. It's important to know that the script has to be run before the msg server loads.

[Saraiyu]

i appreciate the help.... how would i go about writing these scripts? for example, what goes into them, and do i use Notepad to write them?

[King_Arthur]

Your maintenance scripts would be like any other queries. So you would use your favorite text editor and make something like update cq_config set data1... blah blah as if you were changing the legion time normally, saving it as a .sql file. Then you write a batch file that calls the mysql command line and opens that sql file. Lastly, you use the task manager to run the bat file the day before you want the pk tournament.

Some helpful pages: