|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
11-18-2004, 09:16 PM
|
|
Fire Beetle
|
|
Join Date: Oct 2004
Posts: 18
|
|
Well technically I didn't create a new merchant, but i created a new merchant type. Made the type sell only potions i want ppl to buy, and then took an existing merchant and changed her merchantID to the new merchant type. All that works fine, except the pricing is off.
Any one have any suggestions as to the pricing issue I'm having? Also, I followed the sticky merchant guide that explains how to create adventure merchants and how to change item's ldon points, etc.
|
11-18-2004, 11:35 PM
|
|
Sarnak
|
|
Join Date: Aug 2003
Location: NY
Posts: 78
|
|
no non of the items are no drop i though of that to so looked into that
|
11-19-2004, 01:47 AM
|
|
Fire Beetle
|
|
Join Date: Nov 2004
Location: The Emerald City, Oz
Posts: 20
|
|
Quote:
|
Originally Posted by Cisyouc
1 = Not No Drop
255 = No Drop
|
Being lazy, I originally assumed 0 would equal not no drop (turn a flag to 0 and it's typically turned off, right?). Unfortunately, it made everything no drop. Does any non-1 value mean no drop? I understand, of course, that "by the book" only 255 should likely be used. |
11-19-2004, 11:33 AM
|
|
Dragon
|
|
Join Date: Dec 2003
Location: Earth
Posts: 818
|
|
Re: cant buy from merchants
Code:
Sorry this item is for display purposes only
all my merchants serverwide starting doing then when i upgraded to augments hmmm.. dunno what theproblem is. |
11-19-2004, 11:39 AM
|
|
Dragon
|
|
Join Date: Dec 2003
Location: Earth
Posts: 818
|
|
Re: cant buy from merchants
Quote:
|
Originally Posted by sdabbs65
Code:
Sorry this item is for display purposes only
all my merchants serverwide starting doing then when i upgraded to augments hmmm.. dunno what theproblem is. |
I did all the commands here
http://www.eqemulator.net/forums/viewtopic.php?t=18572
so thats not the issue its something else than no drop no rent etc. |
11-20-2004, 12:39 AM
|
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 52
|
|
All mine do the same server-wide, too. I also went augment. Oh and sdabbs65 - check your logs. I logged my char in on your server and his inventory was gone. If you check your logs, you'll find additional SQL statements to run. People might have trouble logging in after that - when I did it after logging in a char first, I had to dump that character because something seemed corrupt.
|
11-20-2004, 12:40 AM
|
|
Sarnak
|
|
Join Date: Nov 2004
Posts: 52
|
|
255 != NODROP. Tried it, the flag was removed.
I'm confused. Why make this field 11 wide in the DB when it only needs to be a boolean value? 1 = True/NODROP 0 = Fallse/Non-NODROP? Same for LORE, NORENT, ect.
|
11-20-2004, 04:41 AM
|
|
Fire Beetle
|
|
Join Date: Nov 2004
Location: The Emerald City, Oz
Posts: 20
|
|
Realized today that I was having the same problem. Downgraded from the 11-16 compile to the 11-11 compile and merchants again function correctly.
|
11-20-2004, 01:08 PM
|
|
Sarnak
|
|
Join Date: Aug 2003
Location: NY
Posts: 78
|
|
kewl well i just figured it was something with the database thats why i started it here , and yes i hope this issue can get fixed hehe
i have still been messing around with it and still haveing no luck
later
|
11-20-2004, 05:05 PM
|
 |
Developer
|
|
Join Date: Aug 2003
Posts: 246
|
|
|
11-20-2004, 05:08 PM
|
|
Fire Beetle
|
|
Join Date: Nov 2004
Location: The Emerald City, Oz
Posts: 20
|
|
Quote:
|
Originally Posted by Doodman
Fixed
|
Nice  . Thanks! |
11-21-2004, 05:04 AM
|
|
Sarnak
|
|
Join Date: Aug 2003
Location: NY
Posts: 78
|
|
Woot thank you
|
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:43 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
