[Antrix] .SQL Installing, Weaponless NPCs, and Weather (Questions)
Hey there, RageZone peoples. Anyway, my question is this: Provided here in this section of the site are many .SQL files that fix things such as scaling, items, little bugs, etcetera. My question is, I've dropped the .SQL files into my SQL folder, but is that all I have to do?
On a side note, after using the Antrix Setup Guide for Dummies(http://forum.ragezone.com/f114/guide-running-antrix-server-step-step-guide-dummies-lot-images-267136/), which worked out wonderfully for me, there's one minor problem that jumped out at me, and that is all the NPCs are weaponless. I immediatly know there's a fix for it around here somewhere, but without really knowing how to install SQL files, and update the Antrix database, I'm kind of at a loss as to what I need to do.
Lastly, weather. Me and a friend have been testing it for sometime, and figured out that .debug weather 2 0 0 0 causes a light rain. 3-5 are varying intensities of rain, 6-8 are varying intensities of snowfall, and that 22 is the sandstorm weather. If anyone here knows more, or simply has more information to provide on the weather command, I'm sure myself and others would love to know! http://i19.photobucket.com/albums/b1...-ImGrant-P.gif
Thanks for taking a look at this, whatever may be.
Re: [Antrix] .SQL Installing, Weaponless NPCs, and Weather (Questions)
Step by step for adding hotfix sqls:
Before you begin, Export your antrix database as "Antrix_DB_Backup.sql" and then place it in a RAR file to keep its size down (WinRAR can compress them an incredible amount). Keep this file safe, you may need it later.
1. Open SQLyog
2. Connect to your database
3. Right-Click "root@localhost" and select "Create Database..."
4. Call the database whatever you want and click "Create"
5. Right click on the new database and select "Restore From SQL Dump..."
6. Browse for the SQL file you wish to add, select it and press "Done".
7. Right-Click the new directory and click on "'Copy Database To Different Host/DB"
8. Check the box that says "Drop table if exists in target" and click "Import".
9. This process may take a while depending on how big the hotfix is. Small hotfixes may be instant where as a new Core Update may take up to an hour or more.
10. When complete, right click on your new database and click "Drop Database" and click OK.
If you have an active server it may be wise to schedule an exported backup of the Antrix database every 24 hours, maybe less. This will create a Rollback in case of a server malfunction or bad patch and means players will loose only a maximum of a day's playtime.
Re: [Antrix] .SQL Installing, Weaponless NPCs, and Weather (Questions)
