| 
   | 
   | 
  
 
    | 
    | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
   | 
  
	
		
   
   
      | Archive::Tools Archive area for Tools's posts that were moved here after an inactivity period of 90 days. | 
    
    
   
   
   
   
   
   
   
   
		 
	 
 
	
	
		
	
	
 
    | 
   | 
    | 
  
 
	
		
		
		
			
			 
			
				05-04-2003, 01:20 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jan 2003 
					
					
					
						Posts: 30
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Adding loot to NPC's  Program <--- Look
			 
			 
			
		
		
		
		hey all, 
I got sick of manually adding loot tables to NPC's etc and decided to write a program which does it all for me, hence my program "looter"
 
its simple to use, fast. From within it you can add loot to NPC's, change the amount of coin they drop, chance anything in the loot tables. Even if a NPC doesnt have it own custom loot table. this will create it.
 http://users.quickfox.tk/~froglok/looter.zip
if there are any issues post back here and ill try to help each one. be warned pretty much the only testing this has gone threw is my own and a little from killspree. so if it dies or kills your db, dont blame me =) just post what happened and how you got the error and ill fix it.
 
Thanks
 
Froglok.
 
P.S btw iv also released another add (at the same time) called SafeMover. allows your to move chars from zones, set loging/password names for people who cant remembe them, etc, Check it out!!!!  
		
	
		
		
		
		
		
		
			
				__________________ 
				Froglokkkkkkkkkkkkkkk
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
 
    | 
   | 
    | 
  
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-04-2003, 01:24 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jan 2003 
					
					
					
						Posts: 30
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				SafeMover - Easy fixing the stuch chats in between zones
			 
			 
			
		
		
		
		hey all again 
This is my other progam, with it you can change which zone the char is in, the x,y,z, usename and password for the char. check it out.. 
 http://users.quickfox.tk/~froglok/safemove.zip
also this is really only beta so just be warned (if it dies, kills your db or anything, dont blame me, post it here and ill try to fix the error in the program.
 
Thanks
 
Froglok  
		
	
		
		
		
		
		
		
			
				__________________ 
				Froglokkkkkkkkkkkkkkk
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-04-2003, 05:51 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Hill Giant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2002 
					Location: the little voice in the back of your head 
					
					
						Posts: 239
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Nice work froglok these are great tools, the loot editor espeically, much faster than adding w/ FQAdmin. =) 
		
	
		
		
		
		
		
		
			
				__________________ 
				Please remain seated while the room is in motion
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-06-2003, 03:43 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Items Master 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					
					
					
						Posts: 293
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		froglok sent me his looter program when he was testing it.  i cant say enough about it.  It loads everything instantly, npcs are in alphabetical order     and it is incredibly simple to use.  I recommend this to anyone looking to get their named to drop loot.  Good work froglok.  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-07-2003, 02:28 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Mar 2003 
					Location: Rogers Arkansas 
					
					
						Posts: 4
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				No libmysql.dll found error
			 
			 
			
		
		
		
		I made all the changes to the ini file to match my computer and database but I get the message that no libmysql.dll is found. I have the mysql admin program running and my other client apps work fine.  
Any hints or ideas? I am excited about taking a look at your program.
 
Thanks, 
Griston    
		
	
		
		
		
		
		
		
			
				__________________ 
				Griston
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-07-2003, 03:46 AM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2002 
					
					
					
						Posts: 354
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		i got my file from EQAdmin :p 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-07-2003, 04:48 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Mar 2003 
					Location: Rogers Arkansas 
					
					
						Posts: 4
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Thanks!
			 
			 
			
		
		
		
		That worked great! 
 
Griston 
		
	
		
		
		
		
		
		
			
				__________________ 
				Griston
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-08-2003, 07:46 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Senior Member Former EQEmu Developer Current EQ2Emu Lead Developer 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2002 
					
					
					
						Posts: 1,065
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Hmm thats pretty cool froglok, the link is pretty slow though, if you want I can host them for you.  I'm making an offline version of my character editor that I might release eventually, unless you release one before I do :P 
		
	
		
		
		
		
		
		
			
				__________________ 
				Lethal Encounter
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-08-2003, 04:55 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jan 2003 
					
					
					
						Posts: 30
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		thanks everyone who likes them, makes my day hearing it, sure id love to get hosting, my nick on eqemu (irc server) is froglok if you want to get in contact. im also looking at allowing the looter add to list itrems by id/number but dont have the time or the effet (or could be beother) to sift the thought blob in the mysql db, if anyone has any info about it it would me much appreicated (sorry cant spell). 
 
hehe and for all you out there, iv got some more programs, just little ones long the same lines, nothing major, just makes life alittle easier for dealing with eqemu and he db 
		
	
		
		
		
		
		
		
			
				__________________ 
				Froglokkkkkkkkkkkkkkk
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-11-2003, 07:33 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jan 2003 
					Location: Grand Rapids, MI 
					
					
						Posts: 90
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Thx for the software
			 
			 
			
		
		
		
		Hi Frogloc 
 
One problem i have found.  The code dosent seem to work in a linux enviroment.  Errors out on connect. From what i can tell the table name is in UPPER case and linux systems are case sensitive.  If you could check that and if thats the problem, pls compile a linux version...  
 
Thx for a the hard work.. 
 
Krusher 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-17-2003, 09:47 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Mar 2003 
					
					
					
						Posts: 5
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				really nice little script
			 
			 
			
		
		
		
		Nicly done but i did notice i seem to have a problem with any mob that has a multiple drop lootdrop_id. 
 
IE 122 drops rubicite one randome piece but this doesnt show on your prog when i click on the mob i set it to. any ideas what im doing wrong.... btw mob does drop the rubi for me 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-18-2003, 09:53 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2003 
					
					
					
						Posts: 16
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				ATTN GRISTON
			 
			 
			
		
		
		
		It has to be in your EQEmu dir where libmysql.dll is located : ) 
 
I got that workin but i'm having another problem...When adding loot i get the error message...Duplicate Entry for key 2.  Any ideas? 
 
Botboy 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				05-21-2003, 07:14 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jan 2003 
					Location: Oregon/Standing in the RAin 
					
					
						Posts: 38
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Hey theis are nice
			 
			 
			
		
		
		
		Hay froglok, Could you possably make a tool that could modife what an merchant has for sale and for what price?? that would help me a ton!  
(ok why do merchants in the bazaar sell fungi tunics for 7pp)    
		
	
		
		
		
		
		
		
			
				__________________ 
				In time you will be Rewarded, as fate follows, you will fear, as time stops, so does life. (izagod)  Valudus - GM - Endless Time Server
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				06-03-2003, 03:23 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					
					
					
						Posts: 36
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Just a note, links aren't working.  Maybe it's just down right now, but wanted to let ya know. 
		
	
		
		
		
		
		
		
			
				__________________ 
				Hmm DB error. . . ok fixed, hmm can't login. . .ok fixed, hmmm 1017 error. . .ok fixed, hmmmm crashed to desktop. . .ok fixed, hmmmmm UI Error. . .ok fixed, HardDrive Failure all Data is Lost. . .GAWD F$#$ DAMMIT PEACE OF S@#$ FU#@$#ING LIFE OF MINE#@$#@$!!!!
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				06-04-2003, 03:34 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2003 
					
					
					
						Posts: 37
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Same here, links are dead. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
 
	
		
	
	
	
	
	
		
	
		 
		Posting Rules
	 | 
 
	
		
		You may not post new threads 
		You may not post replies 
		You may not post attachments 
		You may not edit your posts 
		 
		
		
		
		
		HTML code is Off 
		 
		
	  | 
 
 
	 | 
	
		
	 | 
 
 
All times are GMT -4. The time now is 09:20 AM. 
 
		 
	 
 
 
     | 
     | 
    
   
      | 
     | 
      | 
    
   
     | 
      | 
     | 
    
   
       | 
      | 
       | 
     
    
    
  | 
   |