﻿  ______ ________   _______   ______                _____ _____  
 |  ____|  ____\ \ / /_   _| |___  /               |_   _|  __ \ 
 | |__  | |__   \ V /  | |      / / ___  _ __   ___  | | | |__) |
 |  __| |  __|   > <   | |     / / / _ \| '_ \ / _ \ | | |  ___/ 
 | |    | |     / . \ _| |_   / /_| (_) | | | |  __/_| |_| |     
 |_|    |_|    /_/ \_\_____| /_____\___/|_| |_|\___|_____|_|     
                      ___________                             
                     |_s_a_n_o_n_|                  

FFXI_ZoneIP - Generates and updates the zoneip column of the 
zone_settings table within the FFXI MySQL database. *fingerscrossed*
						
You may be entitled to warranties, conditions, and terms that may not be excluded or limited by me under law.
EXCEPT FOR THOSE NON-EXCLUDABLE WARRANTIES, CONDITIONS, AND TERMS, AND THE SOFTWARE ARE MADE AVAILABLE “AS IS.” EXCEPT FOR THOSE NON-EXCLUDABLE 
WARRANTIES, CONDITIONS,AND TERMS, MY JUNK AND ITS SUPPLIERS MAKE NO WARRANTIES, CONDITIONS, REPRESENTATIONS, GUARANTEES, OR TERMS (EXPRESS OR IMPLIED, WHETHER BY STATUTE, COMMON LAW, CUSTOM, USAGE, OR OTHERWISE) AS TO ANY MATTER INCLUDING PERFORMANCE, RESULTS, SECURITY, NONINFRINGEMENT, MERCHANTABILITY, INTEGRATION, QUIET ENJOYMENT, SATISFACTORY QUALITY, AND FITNESS FOR ANY PARTICULAR PURPOSE. THIS DISCLAIMER OF WARRANTY MAY NOT BE VALID IN SOME STATES. YOU MAY HAVE WARRANTY RIGHTS UNDER LAW WHICH MAY NOT BE WAIVED OR DISCLAIMED. MY JUNK DOES NOT SEEK TO LIMIT YOUR WARRANTY RIGHTS TO ANY EXTENT NOT PERMITTED BY LAW. PLUS, DO NOT USE THIS TO MAKE NUCLEAR ICBM'S. NOT COOL...

Okay, folks, the guy in front of you is Tommy. He'll be taking you through my little spiel here. Tommy is a Scorpio, he likes biking, and he's never been laid. Exits, okay, there's one in the upper right, and there's uh, probably one over by the CTRL+ALT+DEL somewhere, usually. And what about the GUI? To update, take and put the ip in the textbox and... hey, know what? If you guys don't know how to use a GUI, just ring your call button, and Tommy will come back there and hit you over the head with a tack hammer because you are a retard.
SRSLY, just put the right info in the right box.

---------------------------------------------------------------------------------------
Command line switches are as follows:
/?			Display this README
--help			Display this README

-sql			MySQL Server Address
-db			MySQL FFXI Database
-u			MySQL UserName
-p			MySQL Password
-ip			Your FFXI Server IP; be it local, public, or otherwise

Command line order doesn't matter, switches, spaces, and values do.

EXAMPLE COMMAND LINE:
---------------------------------------------------------------------------------------
FFXI_ZoneIP.exe -u root -p supersecrets -d dspdb -sql 192.168.2.200 -ip 654.987.123.123
FFXI_ZoneIP.exe -sql 127.0.0.1 -d ffxi_table -ip 127.0.0.1 -u dsp -p dsppass 
---------------------------------------------------------------------------------------

Be aware that no fields are validated before performing an update query, so please put the right information into the right spots.  Unless it is horribly broken to the point that I cannot make sense of it, I DO NOT INTEND TO BUGFIX, INPUT VALIDATE, OR OTHERWISE SUPPORT THIS.

That being said, please let me know if something is wrong.
-sanon
