PEQ Merchant List Revised

[GeorgeS]

Items in list which have >=100 or more on list

select item,COUNT(item) as numbers_of_replicates from merchantlist  group by item

  itemid , replicates
16598,297
13006,295
13009,247
13008,245
13005,211
13007,202
16580,195
13002,193
13032,168
10028,166
17005,166
13003,165
7001,161
13087,146
13018,138
13004,137
13040,134
13039,133
5019,130
13100,128
10024,126
13101,123
5013,123
16599,122
10019,119
6011,119
10020,118
6018,117
13068,117
10029,114
17908,114
13031,114
10026,113
5021,111
5020,111
13033,110
17001,110
13085,109
13030,106
13034,104
13015,104
10022,103
13014,102
1001,102
6012,102
5016,102
10015,101

GeorgeS

[cavedude]

I started cleaning up merchants a couple of days ago as well. Basically, my method is to use the PEQ Editor and only show the merchants in PoK. Then, I compare their lists to EQTraders/my own knowledge and find any item that don't belong on that list. I then use Allah to identify any item on that list that doesn't belong on ANY vendor. Finally, I add those ids to a growing .sql query to remove them. Since PEQ is still down, I haven't been cleaning up individual lists (I'd rather do that directly to the Live database) but after I am done, each merchant won't have any item that shouldn't be vendor sold, which imho is a HUGE improvement. Many will still have extra items, but the benefit is no legit item will be removed and the extra items are vendor sold anyway.

[renoofturks1]

I already have PoK cleaned out on my system.

[eq4me]

I still have that list of all allowed vendor item id's I compiled from allakhazam and eqtraders on my harddisk. If someone is interested give me a call.
Of course it can not check of an old world merchant has Velious merchant stuff in his inventory but applied with a small script it wipes all excess items from the merchant table.

[janusd]

Just to let you guys know, I hate all of you. I haaaaaate farming things (spider silk) for that one elusive skill-up. Oh well. I guess it'll help jump-start that economy...

/ooc WTB tradeskill garbage...

And not to sound like a mean person, but how're we gonna reconcile the merchant table wipes with daily reboots on PEQ? Might wanna have a rule (da evil word) to set a number of days minimum to retain the temp stuff before the next reboot wipes the table. Or even an option to just turn it completely off. Or perhaps an option that counts down days to the next wipe so a server admin could randomize the wipes (to mimic how Live rebooted sporadically)... something along those lines. Point being it's not really an issue of customization or mimicing Live (cause reboots were sporadic on Live) but rather an issue of retaining the Live-likeness of seeing a merchant full of random junk.

I'd just hate to have a merchant wipe each time a server, ANY server, reboots.

[eq4me]

Originally Posted by janusd

Just to let you guys know, I hate all of you. I haaaaaate farming things (spider silk) for that one elusive skill-up. Oh well. I guess it'll help jump-start that economy...

/ooc WTB tradeskill garbage...

From the old thread I linked above:

Originally Posted by John Adams

While I can agree that making things harder for people might cause them to lose interest, at the same time, we're talking about the base, core Emulator data here - not custom, low-pop servers. I personally believe it should be as live-like as possible - at the core - then each server op can add bots or merchants that provide anything lacking (like buff bots, or spell vendors).

Why even bother with Researching skill, then? Just put the Researchable spells on a vendor...

[cavedude]

Originally Posted by janusd

And not to sound like a mean person, but how're we gonna reconcile the merchant table wipes with daily reboots on PEQ?

Soon I will remove the code that cleans the temp tables during a reboot. I'll add a script to cron that will clean the temp stuff up every 30 days. Except for the stuff on the 3 buffbots near MB, I believe I am going to make them permanent until Bazaar is in, that is (now that they actually work)

eq4me: I am very interested in that list! That will save me a ton of time to finish this off.

[janusd]

COOL! Checking the merchants a couple days after a wipe is like opening a magic box... never know what'll be inside.