|  |  | 
 
  |  |  |  |  
  |  |  |  |  
  |  |  |  |  
  |  |  |  |  
  |  | 
	
		
   
   
      | EQEmu Operations Center Web development tools |  
	
	
		
	
	
	| 
			
			 
			
				12-07-2015, 05:37 PM
			
			
			
		 |  
	| 
		
			
			| Fire Beetle |  | 
					Join Date: Jul 2015 
						Posts: 28
					      |  |  
	| 
 Just a quick FYI powersource and ammo slot seem to be mixed as i just created a throwing weapon that goes in powersource according to PEQ but in EOC it says its ammo... 
 
 Thanks for all your great work!
 Crucial One
 |  
	
		
	
	
	| 
			
			 
			
				12-07-2015, 05:53 PM
			
			
			
		 |  
	| 
		
			|  | Developer |  | 
					Join Date: Apr 2012 Location: North Carolina 
						Posts: 2,815
					      |  |  
	| 
 The current inventory system is based on the Titanium client, which is pre-PowerSource. 
A work-around was implemented when the SoF client came along:
https://github.com/EQEmu/Server/blob...nstants.h#L890 
This also means that the slots bitmask in the items table are backwards. Some fancy bit-shifting occurs in the client translators to correct this:
https://github.com/EQEmu/Server/blob.../sof.cpp#L2953 
This issue will eventually be corrected..but, the whole inventory system has to be reworked and that will probably occur with the rework.
				__________________Uleat of Bertoxxulous
 
 Compilin' Dirty
 |  
	
		
	
	
	| 
			
			 
			
				01-05-2016, 07:49 PM
			
			
			
		 |  
	| 
		
			|  | Sarnak |  | 
					Join Date: Jul 2009 Location: USA 
						Posts: 89
					      |  |  
	| 
 I'm logged into the tool but I can't actually seem to make edits to my db. I'm trying to update the MOTD via the PEQ Editor, I change the text, click submit and when it reloads the text is the same. The user I created for the tool has full privileges. 
 Any ideas?
 |  
	
		
	
	
	| 
			
			 
			
				07-05-2017, 09:01 PM
			
			
			
		 |  
	| 
		
			|  | Hill Giant |  | 
					Join Date: Jan 2008 Location: VA 
						Posts: 181
					      |  |  
	| 
 Yo $20 PayPal whoever wants to use TeamViewer and make this work for me.
 Lmk
 
				__________________"From the deepest desires often come the deadliest hate.”
 |  
	
		
	
	
	| 
			
			 
			
				07-05-2017, 09:14 PM
			
			
			
		 |  
	| 
		
			
			| Hill Giant |  | 
					Join Date: Jun 2010 
						Posts: 105
					      |  |  
	| 
 Its quite simple, forward port 3306, run the sql query with the proper db user/password inserted and thats about it.  Log in with the correct credentials after you run the query and your set. |  
	
		
	
	
	| 
			
			 
			
				07-05-2017, 09:30 PM
			
			
			
		 |  
	| 
		
			|  | Hill Giant |  | 
					Join Date: Jan 2008 Location: VA 
						Posts: 181
					      |  |  
	| 
 
	Quote: 
	
		| 
					Originally Posted by atrayas  Its quite simple, forward port 3306, run the sql query with the proper db user/password inserted and thats about it.  Log in with the correct credentials after you run the query and your set. |  It should be a fast $20 lmk bro lol I sat here for like 3 hours.
				__________________"From the deepest desires often come the deadliest hate.”
 |  
	
		
	
	
	| 
			
			 
			
				07-07-2017, 12:27 PM
			
			
			
		 |  
	| 
		
			|  | Hill Giant |  | 
					Join Date: Jan 2008 Location: VA 
						Posts: 181
					      |  |  
	| 
 Sooo anyone want to do this team viewer style for me ??$$$$$$$
 
				__________________"From the deepest desires often come the deadliest hate.”
 |  
	
		
	
	
	| 
			
			 
			
				07-07-2017, 09:52 PM
			
			
			
		 |  
	| 
		
			
			| Sarnak |  | 
					Join Date: Dec 2006 
						Posts: 45
					      |  |  
	| 
 It isnt hard set up and i never used team viewer i only used VNC |  
	
		
	
	
	| 
			
			 
			
				07-24-2017, 10:32 PM
			
			
			
		 |  
	| 
		
			
			| Discordant |  | 
					Join Date: Apr 2013 
						Posts: 419
					      |  |  
	| 
 If you still need this done dude, I'll do it for you, hit me up. 
				__________________ I am the All Mighty Mittens! |  
	
		
	
	
	| 
			
			 
			
				10-12-2017, 12:18 AM
			
			
			
		 |  
	| 
		
			|  | Sarnak |  | 
					Join Date: Jul 2005 
						Posts: 38
					      |  |  
	| 
 
	Quote: 
	
		| Does anyone know why port 3306 is still closed after all my attempts to open it? 
 I've manually went to my router's IP address and gone to the port forwarding section and added 3306, protocol set to BOTH, but when using a port checker it says closed. The address is the IPv4 address of my computer. I've tried it using my IPv4 address, my ip from whatismyip and also the default gateway, but nothing works.
 
 
  
   |  Problem solved. Apparently my firewall didn't save the rule I had implemented earlier and I just didn't double check.
				__________________In my defens, God me defend
 			 Last edited by sklead; 10-12-2017 at 12:42 AM..
				Reason: Problem solved
 |  
	
		
	
	
 
  |  |  |  |  
	| 
			
			 
			
				01-03-2018, 10:28 PM
			
			
			
		 |  
	| 
		
			|  | Demi-God |  | 
					Join Date: Mar 2009 Location: Umm 
						Posts: 1,492
					      |  |  
	| 
 
	Quote: 
	
		| 
					Originally Posted by Akkadius  Creating a MySQL user: (By JSR)If using Navicat;
 - Click 'User' on the main ribbon
 - Right click 'root@localhost'
 - Choose 'duplicate user'
 - In the username field, change it to something preferable to root_Copy (or keep it if you think it has a nice ring to it)
 - In the host field, replace 'localhost' with '69.168.254.244'
 - In the password/confirm password fields, enter a secure password.  Note: A long password (e.g. dogsandcatslikerawfishfordinner) is exponentially more secure than one with uppercase, lowercase, numbers, and symbols while also being much easier to remember
 - Under the advanced tab, change 'max user connections' to 1
 - Under the server privileges tab, uncheck the privileges 'File', 'Process', 'Drop', 'Shutdown', 'Super', and 'Create user' (there may be others worth disabling)
 - Click Save
 |  
I got a question about this part - how do you do it with HeidiSQl that now comes with server automatic install?
 
Thank You   |  
 
  |  |  |  |  
	
		
	
	
	| 
			
			 
			
				04-16-2018, 03:37 PM
			
			
			
		 |  
	| 
		
			|  | Sarnak |  | 
					Join Date: Jan 2013 
						Posts: 61
					      |  |  
	| 
 Hello,
 The EOC suite of tools are all functional for my recent install, but PEQ Rev 501 & 460 are only partially functional...
 
 I can see correct data under 'Players' and 'Accounts', but anything referencing a zones in a drop-down menu shows the Zone's short zone name along with (0).
 
 Any chance this can be fixed? Perhaps some sort of header issue, or missing reference with the latest Windows Server Repack?
 
 Thank you!
 |  
	
		
	
	
	| 
			
			 
			
				04-16-2018, 11:44 PM
			
			
			
		 |  
	| 
		
			
			| Discordant |  | 
					Join Date: Oct 2016 
						Posts: 445
					      |  |  
	| 
 
	Quote: 
	
		| 
					Originally Posted by Nydosa  PEQ Rev 501 & 460 are only partially functional... |  Are you talking about old, obsolete and outdated versions of the database ? |  
	
		
	
	
	| 
			
			 
			
				04-17-2018, 01:24 PM
			
			
			
		 |  
	| 
		
			|  | Sarnak |  | 
					Join Date: Jan 2013 
						Posts: 61
					      |  |  
	| 
 PEQ Editor Rev 501 in the EoC suite of tools. It looks like it was last updated in May 2016. Some of the functionality still works, but it looks like there is a disconnect in its ability to read Zones correctly.
 I got GeorgeS's zone editor tool working, so that'll suffice, I just like the fact that i don't have to install anything to use Akkadius' tool on other laptops.
 |  
	
		
	
	
	| 
			
			 
			
				04-17-2018, 01:28 PM
			
			
			
		 |  
	| 
		
			
			| Discordant |  | 
					Join Date: Oct 2016 
						Posts: 445
					      |  |  
	| 
 Oh ok, sorry, I only logged onto that EOC once in the past and discovered I didn't need it, but useGeorge's tools as well, along with an item editor tool, etc. Does the trick for me.
 |  
	
		
	
	
	
	
	| 
	|  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 08:06 PM.
 
 |  |  
    |  |  |  |  
    |  |  |  |  
     |  |  |  |  
 |  |