This guide is supposed to help people who weren´t sucessful at using rings_query I suggested for 99.6xT servers. It simply makes DB create new characters with dropable rings at level 40 and 80 as in Global server. WHENEVER YOU PLAY WITH YOUR DATABASES, MAKE SURE YOU HAVE THEM ALL BACKED UP FIRST. Here we go:
1) Open your Enterprise Manager, all tabs, and choose your MUONLINE database.
2) Select in the upper menu TOOLS > SQL QUERY ANALYZER
3) In this new window, copy and paste the SCRIPT ATTACHED AT THIS POST, and click in on the EXECUTE QUERY button ( F5 for shortcut ) only once ( 2 or more times will cause sql to show an error that script has been already run, but you can proceed steps anyway ). Close the window and return to Enterprise Manager.
4) Now, back to the Enterprise Manager, choose MUONLINE > STORED PROCEDURES and Double Click on the procedure WZ_CreateCharacter. You will have a window like this, maximize it, and follow its instructions carefully.
Ok! If all went well during this guide, the result will be like this when you create a new char.
Reply With Quote
