Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Tools

Archive::Tools Archive area for Tools's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-11-2004, 02:09 PM
Cheerios
Fire Beetle
 
Join Date: Feb 2004
Posts: 9
Default

Spankin new merchant inventory command line tool I wrote today because I was annoyed with having to spend so much time seeing mysql>. It's just a short little perl script requiring only DBI and DBD::mysql modules. If you don't have them fire up ppm or cpan and install DBI and DBD::mysql, there's a good chance they could come in handy regardless since you've got a mysql server running. There aren't alot of bells and whistles to it, I'm too much a unix guy to write bloatware, so feel free to improve on it if you want. Since it's nothing but a perl script anyone worried about a virus/worm/trojan is free to read the code and see for themselves the complete lack of such among other things.

Snag it here

Quote:
/home/bob$ ./merchantinv.pl --help
merchantinv.pl by Cheerios
syntax: merchantinv.pl [-d] [-n] [-a] [-r] <merchantid> <item>

merchantid and item are both numbers, it's too easy to find the
id of an existing merchant or item to bother putting a conversion
bit in here. Oh and don't try mixing and matching switches, bad things
could happen. In all cases, merchantid is required.

-d Dump inventory of <merchantid> to stdout.
-n Nuke the entire inventory of <merchantid>.
-a Add item(s) to <merchantid>.
eg. merchantinv.pl -a <merchantid> item1 item2 item3 ...
-r Remove item(s) from <merchantid>.
eg. merchantinv.pl -r <merchantid> item1 item2 item3 ...

Bugs, questions, comments to ashbentiel~at~punkass~dawt~com

This script subscribes to the GIGO principle. Unexpected
and strangely formed arguments can, and probably will,
hose something in your db, your computer in general,
your relationship, possibly even your mind. But you're
the one who saw fit to do things the wrong way so it is
assumed that you meant for whatever consequences come of it
to happen.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:51 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3