PEQ Database Editor 1.0 (for servers 0.6.4 and up)

[Nagus69]

It appears the Item Editor Portion of the PEQ Editor runs into an issue as it starts out with Item IDs around 119k. Anything beyond 120k will not be loaded from the EQEmu Server.

Can we tune in Items.php

function get_max_id () {
  global $mysql;

  $query = "SELECT max(id) AS iid FROM items"; 
  $result = $mysql->query_assoc($query);
  $newid = $result['iid'] + 1;

to take the next FREE Item ID, like Georges? Alternatively, is there a reason the Server won't load Item IDs > 120k?

[cavedude]

Originally Posted by Nagus69

It appears the Item Editor Portion of the PEQ Editor runs into an issue as it starts out with Item IDs around 119k. Anything beyond 120k will not be loaded from the EQEmu Server.

Can we tune in Items.php

function get_max_id () {
  global $mysql;

  $query = "SELECT max(id) AS iid FROM items"; 
  $result = $mysql->query_assoc($query);
  $newid = $result['iid'] + 1;

to take the next FREE Item ID, like Georges? Alternatively, is there a reason the Server won't load Item IDs > 120k?

It isn't the editor at fault, the EQEmu code has a current limit of 120000, to prevent items from using too much shared memory. If you are able to compile the EQEmu code yourself, you'll need to change #define MMF_EQMAX_ITEMS 120000 in EMuShareMem/Items.h and recompile.

[Hmm]

I finally got it to work using latest xampp.

Unfortunately it then just displays the logo. Nothing else.

I'm stuck at this point now.

[Nagus69]

Originally Posted by cavedude

It isn't the editor at fault, the EQEmu code has a current limit of 120000, to prevent items from using too much shared memory. If you are able to compile the EQEmu code yourself, you'll need to change #define MMF_EQMAX_ITEMS 120000 in EMuShareMem/Items.h and recompile.

Thanks for the answer CD and i agree of course. Would it still be possible that the next Item ID algorithm would behave similar to George? There are so many holes in Item IDs list that using that free space would offer enough without going over the 120k limit and without having to recompile it.

[Nagus69]

Am i being blind again or is the Item Editor Missing the possibility to assign
a proc rate modifier to weapon procs?

[Nagus69]

nm - found the reason for the error.

[Nagus69]

Seems with rev193 and later (just tried 195) i can no longer save edited Items. Neither by clicking submit at the bottom nor hitting Enter in a field which i just edited.

Maybe started even earlier, but that's the first rev i noticed this.