You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
PROBLEM:
When using the Seed Market tab in Evemu Control Panel, no matter what you do to generate a SQL query for whatever items from the database you want to seed, the query will never include raceID = '0', which covers quite a few important items such as charges, modules, blueprints and over 13,000 item types in total.
STEPS TO REPRODUCE:
Open EVEmu Control Panel
Connect to your database
Switch to Seed Market tab
Select any number of raceIDs, select solar system(s) or region(s), select Categories, and select one or more Groups
Select Market Saturation more than 0%, uncheck Apply to Database, set your quantity and hit the Seed Market button
View the SQL query text in the window below to see that raceID is checked against every raceID you selected, but '0' was not automatically inserted for you.
WORKAROUND:
The only way to do this is to manually insert '0' into the area of the SQL query where it says raceID in (...) where there is a comma separated list of numbers in single quotes. Insert the '0' into that list, adding a comma for itself, then save that query to a file and run it on your database. You will then get item types of raceID = 0 seeded to your market.
PROPOSED SOLUTION:
I propose the simple solution of just modifying the ECP code where it makes the seed market query to insert the '0' automatically for you so that every query you make, even when you select NO raceID, it should at least have raceID = ('0') in the SQL query text.
The text was updated successfully, but these errors were encountered:
…matter which raceIDs are chosen, even if none are selected. This will fix Issue #17: Seed Market Tab does not create a SQL query for use on a database for raceID of '0'
PROBLEM:
When using the Seed Market tab in Evemu Control Panel, no matter what you do to generate a SQL query for whatever items from the database you want to seed, the query will never include raceID = '0', which covers quite a few important items such as charges, modules, blueprints and over 13,000 item types in total.
STEPS TO REPRODUCE:
WORKAROUND:
The only way to do this is to manually insert '0' into the area of the SQL query where it says raceID in (...) where there is a comma separated list of numbers in single quotes. Insert the '0' into that list, adding a comma for itself, then save that query to a file and run it on your database. You will then get item types of raceID = 0 seeded to your market.
PROPOSED SOLUTION:
I propose the simple solution of just modifying the ECP code where it makes the seed market query to insert the '0' automatically for you so that every query you make, even when you select NO raceID, it should at least have raceID = ('0') in the SQL query text.
The text was updated successfully, but these errors were encountered: