|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |
 |
|
 |
03-05-2013, 09:00 AM
|
|
Sarnak
|
|
Join Date: Dec 2007
Posts: 57
|
|
SQL Help re: spell merchants & Tradeskill
First - It's a long shot, but I'd like to make merchants which contain spells, instead of using a spell scriber.
is there an SQL command to get a list of castable spells? searching for items with name like '%spell:%' finds 5,000+ rows, and even if I add class restrictions, I still end up with spells I cant use.
Is there a way to pull this data from the castable spell list or from EQZAM?
Or am I stuck finding each spell by hand for each character?
Finally, is there a way to see which spells are NOT in a merchant list already?
Second - I want to add a bunch of tradeskills, using a basic formula: New tradeskill requires smithing skill 200, and there are two items required, a diamond and another item (to create a diamond fused custom obejct)
I've done the grunt work for this using george S' tradeskill editor. I've added about two dozen of these, but have about 550 left to add.
Is there an SQL command to select the next unused # and create an entry with certain rules? (I have all the items laid out nicely in a CSV / xls file and was going to bulk-write the SQL command once I figured it out using the string concat feature in Open office / Excel / etc.)
Finally, with tradeskills, you need the recipe and recipe entry, right? with the recipe being (id,name,tradeskill#,skillneeded,trivial,nofail,re place_container,notes,must_learn,quest)
and
tradeskill recipe being the ingredients used and the output (?)
(id, recipe id, ietm id, sucesscount, failcount, componnentcount,iscontainter)
For my understanding the tradeskill recipe reads from the entry to deterine which items it requires, based on which ones share the same recipe ID, right?
Third - this is possible, right? I mean, george S' tools find the next unused number.... or am I in way over my head?
Any help would be appreciated - the rebirth of tradeskills needs your help 
|
 |
|
 |
03-05-2013, 12:49 PM
|
 |
Dragon
|
|
Join Date: Dec 2009
Posts: 719
|
|
in the spells_new, i believe the fields classes1 through classes16 indicate the level required for that particular spell to be cast by the class number found here:
http://www.eqemulator.net/wiki/wikka...akka=ClassList
example:
Holy Armor, 255, 1, 15, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255, 255
it's castable at level 1 by a cleric (2), and 15 by a paladin (3).
so, yeah... you should be able to construct a query to determine which spells would ever be usable on your server by looking at class/level restrictions.
__________________
I muck about @ The Forge.
say(rand 99>49?'try '.('0x'.join '',map{unpack 'H*',chr rand 256}1..2):'incoherent nonsense')while our $Noport=1;
|
|
|
|
03-05-2013, 01:31 PM
|
|
Dragon
|
|
Join Date: Dec 2009
Posts: 719
|
|
it's not pretty, and it's probably not efficient, but it works.
Code:
select
items.id, items.name
from
items
left outer join
merchantlist
on
items.id = merchantlist.item
inner join
spells_new as spells
on
substr(items.name from 8) = spells.name
where
scrolltype = 7
and
merchantlist.item is null
and
(classes1 < 75 or
classes2 < 75 or
classes3 < 75 or
classes4 < 75 or
classes5 < 75 or
classes6 < 75 or
classes7 < 75 or
classes8 < 75 or
classes9 < 75 or
classes10 < 75 or
classes11 < 75 or
classes12 < 75 or
classes13 < 75 or
classes14 < 75 or
classes15 < 75 or
classes16 < 75)
order by
items.name;
this should show you a list of item ids and scroll names for all spells below level 75 (change the number to whatever you want) that aren't available on merchants. took just over 22 seconds to run on my slow ass laptop with a number of other things open in the background.
__________________
I muck about @ The Forge.
say(rand 99>49?'try '.('0x'.join '',map{unpack 'H*',chr rand 256}1..2):'incoherent nonsense')while our $Noport=1;
|
|
|
|
|
|
|
03-05-2013, 06:31 PM
|
|
Hill Giant
|
|
Join Date: Sep 2008
Location: So. California
Posts: 219
|
|
You can get the next available with this sql if you like, not sure you would want to automate it though...If you did you would end up having to query the db to discover where it put your recipes anyways..
Code:
SELECT t1.id + 1
FROM tradeskill_recipe t1
WHERE NOT EXISTS (
SELECT *
FROM tradeskill_recipe t2
WHERE t2.id = t1.id + 1
)
LIMIT 1
Me personally I put all my customs after the last used id of a table with some cushion...Then I can insert in a given range. I like to have a record of what my sql is doing, and automating takes that away..If you are using excel then you can easily build an sql Insert query from it..
And c0ncrete, nice sql, i went a different route to remove my spells from merchants and loot drops but this is very cool, just add this to get it imported into excel if on windows(prob alread know this)
Code:
INTO OUTFILE 'c:/reneq/non_merchant_spells.csv'
FIELDS TERMINATED BY '\,'
LINES TERMINATED BY '\n';
|
|
|
|
03-05-2013, 07:04 PM
|
|
Dragon
|
|
Join Date: Dec 2009
Posts: 719
|
|
it should also be possible, in theory, to modify your source to use a custom perl event to check arbitrary values (perhaps stored in qglobals) and calculate the success of combines instead of having to use the existing trade-skill system. i fleshed out a framework for just such a thing not too long ago. it still uses the existing recipe tables, but just sends some of the recipe data to perl if the combine is flagged to be processed via quest.
__________________
I muck about @ The Forge.
say(rand 99>49?'try '.('0x'.join '',map{unpack 'H*',chr rand 256}1..2):'incoherent nonsense')while our $Noport=1;
|
03-05-2013, 07:09 PM
|
|
Sarnak
|
|
Join Date: Dec 2007
Posts: 57
|
|
thanks guys, you are a big help.
Rencro, thanks, I did know that, but it's always nice to have in case someone else comes across it. Also, the code to find next available, thank you.
My plan is to have a normal -> fabled transmuter (quest) and have many of the regular items (to turn into fabled) items be craftable. So, to make a ykehsa, You'd take a short sword, and a diamond, combine them in a forge (skill check) and viola, ykesha! Like I said, I have about 600 to do, so any help from you guys is appreciated =)
fake edit: whaaa? perl based tradeskills instead of database - based ones? That sounds neat. I don't know if something like that would be easier than trying to rebuild the wheel here.
|
|
|
|
03-05-2013, 07:40 PM
|
|
Dragon
|
|
Join Date: Dec 2009
Posts: 719
|
|
Code:
zone/embparser.cpp | 13 ++++++++++++-
zone/event_codes.h | 1 +
zone/tradeskills.cpp | 48 +++++++++++++++++++++++++++++++++++++++++++++---
zone/zonedb.h | 1 +
4 files changed, 59 insertions(+), 4 deletions(-)
diff --git a/zone/embparser.cpp b/zone/embparser.cpp
index dc77b4e..c96c465 100644
--- a/zone/embparser.cpp
+++ b/zone/embparser.cpp
@@ -93,7 +93,8 @@ const char *QuestEventSubroutines[_LargestEventID] = {
"EVENT_CLICK_OBJECT",
"EVENT_DISCOVER_ITEM",
"EVENT_DISCONNECT",
- "EVENT_CONNECT"
+ "EVENT_CONNECT",
+ "EVENT_COMBINE"
};
extern Zone* zone;
@@ -768,6 +769,16 @@ void PerlembParser::EventCommon(QuestEventID event, uint32 objid, const char * d
break;
}
//tradeskill events
+ case EVENT_COMBINE:
+ {
+ Seperator *sep = new Seperator(data, '|');
+ ExportVar(packagename.c_str(), "recipe_name", sep->arg[0]);
+ ExportVar(packagename.c_str(), "onsuccess", sep->arg[1]);
+ ExportVar(packagename.c_str(), "onfailure", sep->arg[2]);
+ ExportVar(packagename.c_str(), "recipe_id", extradata);
+ safe_delete(sep);
+ break;
+ }
case EVENT_COMBINE_SUCCESS:
case EVENT_COMBINE_FAILURE:
{
diff --git a/zone/event_codes.h b/zone/event_codes.h
index 3a29756..545390e 100644
--- a/zone/event_codes.h
+++ b/zone/event_codes.h
@@ -58,6 +58,7 @@ typedef enum {
EVENT_DISCOVER_ITEM,
EVENT_DISCONNECT,
EVENT_CONNECT,
+ EVENT_COMBINE,
_LargestEventID
} QuestEventID;
diff --git a/zone/tradeskills.cpp b/zone/tradeskills.cpp
index 48d097d..99defa9 100644
--- a/zone/tradeskills.cpp
+++ b/zone/tradeskills.cpp
@@ -328,6 +328,47 @@ void Object::HandleCombine(Client* user, const NewCombine_Struct* in_combine, Ob
}
container->Clear();
}
+
+ // trade skills flagged as scripted will be handled entirely by perl
+ // data passed as follows:
+ // recipe_name|success_item1 success_count1 success_item2 success_count2|fail_item1 fail_count1
+ if(spec.scripted) {
+
+ _log(TRADESKILLS__TRACE, "Scripted tradeskill '%s' found in Object::HandleCombine.", spec.name.c_str());
+
+ vector<pair<uint32, uint8>>::iterator itr;
+
+ char *data = 0;
+ int32 dsiz = 0, dlen = 0;
+
+ // build data string to pass to event
+ AppendAnyLenString(&data, &dsiz, &dlen, "%s|", spec.name.c_str());
+ if(spec.onsuccess.size()) {
+ itr = spec.onsuccess.begin();
+ while(itr != spec.onsuccess.end()-1) {
+ AppendAnyLenString(&data, &dsiz, &dlen, "%u %u ", itr->first, itr->second);
+ ++itr;
+ }
+ AppendAnyLenString(&data, &dsiz, &dlen, "%u %u", itr->first, itr->second);
+ }
+ AppendAnyLenString(&data, &dsiz, &dlen, "|");
+ if(spec.onfail.size()) {
+ itr = spec.onfail.begin();
+ while(itr != spec.onfail.end()-1) {
+ AppendAnyLenString(&data, &dsiz, &dlen, "%u %u ", itr->first, itr->second);
+ ++itr;
+ }
+ AppendAnyLenString(&data, &dsiz, &dlen, "%u %u", itr->first, itr->second);
+ }
+
+ _log(TRADESKILLS__TRACE, "Passing data to EVENT_COMBINE -- %s", data);
+ parse->EventPlayer(EVENT_COMBINE, user, data, spec.recipe_id);
+
+ safe_delete_array(data);
+
+ return;
+ }
+
//do the check and send results...
bool success = user->TradeskillExecute(&spec);
@@ -1323,7 +1364,7 @@ bool ZoneDatabase::GetTradeRecipe(uint32 recipe_id, uint8 c_type, uint32 some_id
}
qlen = MakeAnyLenString(&query, "SELECT tr.id, tr.tradeskill, tr.skillneeded,"
- " tr.trivial, tr.nofail, tr.replace_container, tr.name, tr.must_learn, tr.quest, crl.madecount"
+ " tr.trivial, tr.nofail, tr.replace_container, tr.name, tr.must_learn, tr.quest, tr.scripted, crl.madecount"
" FROM tradeskill_recipe AS tr inner join tradeskill_recipe_entries as tre"
" ON tr.id = tre.recipe_id"
" LEFT JOIN (SELECT recipe_id, madecount from char_recipe_list WHERE char_id = %u) AS crl "
@@ -1354,12 +1395,13 @@ bool ZoneDatabase::GetTradeRecipe(uint32 recipe_id, uint8 c_type, uint32 some_id
spec->name = row[6];
spec->must_learn = (uint8)atoi(row[7]);
spec->quest = atoi(row[8]) ? true : false;
- if (row[9] == NULL) {
+ spec->quest = atoi(row[9]) ? true : false;
+ if (row[10] == NULL) {
spec->has_learnt = false;
spec->madecount = 0;
} else {
spec->has_learnt = true;
- spec->madecount = (uint32)atoul(row[9]);
+ spec->madecount = (uint32)atoul(row[10]);
}
spec->recipe_id = recipe_id;
mysql_free_result(result);
diff --git a/zone/zonedb.h b/zone/zonedb.h
index 9863d8f..7933a79 100644
--- a/zone/zonedb.h
+++ b/zone/zonedb.h
@@ -52,6 +52,7 @@ struct DBTradeskillRecipe_Struct {
uint32 madecount;
uint32 recipe_id;
bool quest;
+ bool scripted;
};
struct PetRecord {
required SQL:
Code:
ALTER TABLE `tradeskill_recipe` ADD `scripted` TINYINT(1) NOT NULL DEFAULT '0';
if a recipe has the `scripted` flag set to 1 in the database, it parses EVENT_COMBINE in global_player.pl so you can do whatever you want with it. it sends the recipe name, id, and two strings that contain the item ids and counts of the yields on both success and failure. you can break up the strings into a hash like this:
Code:
sub EVENT_COMBINE {
my %success = split ' ', $onsuccess;
my %failure = split ' ', $onfailure;
# full muffin crate
if ( $recipe_id == 12811 ) {
# iterate over success items
while ( my ( $item, $count ) = each %success ) {
$client->Message( 15, "$item => $count" );
}
# iterate over failure items
while ( my ( $item, $count ) = each %failure ) {
$client->Message( 15, "$item => $count" );
}
}
}
it's completely up to you as to how you calculate successes and skill ups and whatnot at that point.
__________________
I muck about @ The Forge.
say(rand 99>49?'try '.('0x'.join '',map{unpack 'H*',chr rand 256}1..2):'incoherent nonsense')while our $Noport=1;
Last edited by c0ncrete; 03-05-2013 at 07:51 PM..
Reason: corrected exported variable name
|
|
|
|
|
|
|
03-05-2013, 08:36 PM
|
|
Sarnak
|
|
Join Date: Dec 2007
Posts: 57
|
|
wow, that's really neat. I will definitely have to do some experimenting on that =) thanks c0nc
in case anyone is curious, my final SQL query looks like this (for merchants + spells)
Code:
insert into merchantlist values (1000038,1,19320,-100,0,0);
insert into merchantlist values (1000038,2,77157,-100,0,0);
insert into merchantlist values (1000038,3,19278,-100,0,0);
insert into merchantlist values (1000038,4,19528,-100,0,0);
insert into merchantlist values (1000038,5,19227,-100,0,0);
insert into merchantlist values (1000038,6,15863,-100,0,0);
insert into merchantlist values (1000038,7,30447,-100,0,0);
insert into merchantlist values (1000038,8,21639,-100,0,0);
insert into merchantlist values (1000038,9,28488,-100,0,0);
insert into merchantlist values (1000038,10,28446,-100,0,0);
insert into merchantlist values (1000038,11,16239,-100,0,0);
insert into merchantlist values (1000038,12,77136,-100,0,0);
insert into merchantlist values (1000038,13,28491,-100,0,0);
insert into merchantlist values (1000038,14,59857,-100,0,0);
insert into merchantlist values (1000038,15,59855,-100,0,0);
insert into merchantlist values (1000038,16,59848,-100,0,0);
insert into merchantlist values (1000038,17,59846,-100,0,0);
insert into merchantlist values (1000038,18,59849,-100,0,0);
insert into merchantlist values (1000038,19,59850,-100,0,0);
insert into merchantlist values (1000038,20,59851,-100,0,0);
insert into merchantlist values (1000038,21,59854,-100,0,0);
insert into merchantlist values (1000038,22,59852,-100,0,0);
insert into merchantlist values (1000038,23,59847,-100,0,0);
insert into merchantlist values (1000038,24,59853,-100,0,0);
insert into merchantlist values (1000038,25,59856,-100,0,0);
insert into merchantlist values (1000038,26,77884,-100,0,0);
insert into merchantlist values (1000038,27,77854,-100,0,0);
insert into merchantlist values (1000038,28,16423,-100,0,0);
insert into merchantlist values (1000038,29,77837,-100,0,0);
insert into merchantlist values (1000038,30,28549,-100,0,0);
insert into merchantlist values (1000038,31,28643,-100,0,0);
insert into merchantlist values (1000038,32,30416,-100,0,0);
insert into merchantlist values (1000038,33,28565,-100,0,0);
insert into merchantlist values (1000038,34,19402,-100,0,0);
insert into merchantlist values (1000038,35,19416,-100,0,0);
insert into merchantlist values (1000038,36,30414,-100,0,0);
insert into merchantlist values (1000038,37,26924,-100,0,0);
insert into merchantlist values (1000038,38,26927,-100,0,0);
insert into merchantlist values (1000038,39,78024,-100,0,0);
insert into merchantlist values (1000038,40,26922,-100,0,0);
insert into merchantlist values (1000038,41,21654,-100,0,0);
insert into merchantlist values (1000038,42,78026,-100,0,0);
insert into merchantlist values (1000038,43,78025,-100,0,0);
insert into merchantlist values (1000038,44,59019,-100,0,0);
insert into merchantlist values (1000038,45,19292,-100,0,0);
insert into merchantlist values (1000038,46,59838,-100,0,0);
insert into merchantlist values (1000038,47,19356,-100,0,0);
insert into merchantlist values (1000038,48,19277,-100,0,0);
insert into merchantlist values (1000038,49,19262,-100,0,0);
insert into merchantlist values (1000038,50,19228,-100,0,0);
insert into merchantlist values (1000038,51,28457,-100,0,0);
insert into merchantlist values (1000038,52,19400,-100,0,0);
insert into merchantlist values (1000038,53,16438,-100,0,0);
insert into merchantlist values (1000038,54,78028,-100,0,0);
insert into merchantlist values (1000038,55,7667,-100,0,0);
insert into merchantlist values (1000038,56,77113,-100,0,0);
insert into merchantlist values (1000038,57,15021,-100,0,0);
insert into merchantlist values (1000038,58,16218,-100,0,0);
insert into merchantlist values (1000038,59,77908,-100,0,0);
insert into merchantlist values (1000038,60,41283,-100,0,0);
insert into merchantlist values (1000037,1,16117,-100,0,0);
insert into merchantlist values (1000037,2,16312,-100,0,0);
insert into merchantlist values (1000037,3,16211,-100,0,0);
insert into merchantlist values (1000037,4,59843,-100,0,0);
insert into merchantlist values (1000037,5,59841,-100,0,0);
insert into merchantlist values (1000037,6,28432,-100,0,0);
insert into merchantlist values (1000037,7,21644,-100,0,0);
insert into merchantlist values (1000037,8,21642,-100,0,0);
insert into merchantlist values (1000037,9,77219,-100,0,0);
insert into merchantlist values (1000037,10,30429,-100,0,0);
insert into merchantlist values (1000037,11,7609,-100,0,0);
insert into merchantlist values (1000037,12,7610,-100,0,0);
insert into merchantlist values (1000037,13,77009,-100,0,0);
insert into merchantlist values (1000037,14,28531,-100,0,0);
insert into merchantlist values (1000037,15,28563,-100,0,0);
insert into merchantlist values (1000037,16,28541,-100,0,0);
insert into merchantlist values (1000037,17,28468,-100,0,0);
insert into merchantlist values (1000037,18,59817,-100,0,0);
insert into merchantlist values (1000037,19,19241,-100,0,0);
insert into merchantlist values (1000037,20,77065,-100,0,0);
insert into merchantlist values (1000037,21,21633,-100,0,0);
insert into merchantlist values (1000037,22,77073,-100,0,0);
insert into merchantlist values (1000037,23,59525,-100,0,0);
insert into merchantlist values (1000037,24,59006,-100,0,0);
insert into merchantlist values (1000037,25,26916,-100,0,0);
insert into merchantlist values (1000037,26,28416,-100,0,0);
insert into merchantlist values (1000037,27,77659,-100,0,0);
insert into merchantlist values (1000037,28,77661,-100,0,0);
insert into merchantlist values (1000037,29,28644,-100,0,0);
insert into merchantlist values (1000037,30,77210,-100,0,0);
insert into merchantlist values (1000037,31,16442,-100,0,0);
insert into merchantlist values (1000037,32,77067,-100,0,0);
insert into merchantlist values (1000037,33,59010,-100,0,0);
insert into merchantlist values (1000037,34,19419,-100,0,0);
insert into merchantlist values (1000037,35,19368,-100,0,0);
insert into merchantlist values (1000037,36,19386,-100,0,0);
insert into merchantlist values (1000037,37,30474,-100,0,0);
insert into merchantlist values (1000037,38,28540,-100,0,0);
insert into merchantlist values (1000037,39,19250,-100,0,0);
insert into merchantlist values (1000037,40,16427,-100,0,0);
insert into merchantlist values (1000037,41,59837,-100,0,0);
insert into merchantlist values (1000037,42,26914,-100,0,0);
insert into merchantlist values (1000037,43,77149,-100,0,0);
insert into merchantlist values (1000037,44,26938,-100,0,0);
insert into merchantlist values (1000037,45,77054,-100,0,0);
insert into merchantlist values (1000037,46,21626,-100,0,0);
insert into merchantlist values (1000037,47,77920,-100,0,0);
insert into merchantlist values (1000037,48,41294,-100,0,0);
insert into merchantlist values (1000037,49,30472,-100,0,0);
insert into merchantlist values (1000037,50,21669,-100,0,0);
insert into merchantlist values (1000037,51,16440,-100,0,0);
insert into merchantlist values (1000037,52,77891,-100,0,0);
insert into merchantlist values (1000037,53,41266,-100,0,0);
insert into merchantlist values (1000037,54,30462,-100,0,0);
insert into merchantlist values (1000037,55,30463,-100,0,0);
insert into merchantlist values (1000037,56,15691,-100,0,0);
insert into merchantlist values (1000037,57,19235,-100,0,0);
insert into merchantlist values (1000037,58,16342,-100,0,0);
insert into merchantlist values (1000037,59,19360,-100,0,0);
insert into merchantlist values (1000037,60,30464,-100,0,0);
insert into merchantlist values (1000036,1,21628,-100,0,0);
insert into merchantlist values (1000036,2,16118,-100,0,0);
insert into merchantlist values (1000036,3,16415,-100,0,0);
insert into merchantlist values (1000036,4,16207,-100,0,0);
insert into merchantlist values (1000036,5,12941,-100,0,0);
insert into merchantlist values (1000036,6,19272,-100,0,0);
insert into merchantlist values (1000036,7,19473,-100,0,0);
insert into merchantlist values (1000036,8,77118,-100,0,0);
insert into merchantlist values (1000036,9,16323,-100,0,0);
insert into merchantlist values (1000036,10,28564,-100,0,0);
insert into merchantlist values (1000036,11,16400,-100,0,0);
insert into merchantlist values (1000036,12,30444,-100,0,0);
insert into merchantlist values (1000036,13,77159,-100,0,0);
insert into merchantlist values (1000036,14,16425,-100,0,0);
insert into merchantlist values (1000036,15,28425,-100,0,0);
insert into merchantlist values (1000036,16,77220,-100,0,0);
insert into merchantlist values (1000036,17,28433,-100,0,0);
insert into merchantlist values (1000036,18,77216,-100,0,0);
insert into merchantlist values (1000036,19,77209,-100,0,0);
insert into merchantlist values (1000036,20,19302,-100,0,0);
insert into merchantlist values (1000036,21,77256,-100,0,0);
insert into merchantlist values (1000036,22,77097,-100,0,0);
insert into merchantlist values (1000036,23,77662,-100,0,0);
insert into merchantlist values (1000036,24,77855,-100,0,0);
insert into merchantlist values (1000036,25,77191,-100,0,0);
insert into merchantlist values (1000036,26,16330,-100,0,0);
insert into merchantlist values (1000036,27,7619,-100,0,0);
insert into merchantlist values (1000036,28,77657,-100,0,0);
insert into merchantlist values (1000036,29,19234,-100,0,0);
insert into merchantlist values (1000036,30,19232,-100,0,0);
insert into merchantlist values (1000036,31,77244,-100,0,0);
insert into merchantlist values (1000036,32,19379,-100,0,0);
insert into merchantlist values (1000036,33,76060,-100,0,0);
insert into merchantlist values (1000036,34,76043,-100,0,0);
insert into merchantlist values (1000036,35,77923,-100,0,0);
insert into merchantlist values (1000036,36,41296,-100,0,0);
insert into merchantlist values (1000036,37,21635,-100,0,0);
insert into merchantlist values (1000036,38,77273,-100,0,0);
insert into merchantlist values (1000036,39,28490,-100,0,0);
insert into merchantlist values (1000036,40,16219,-100,0,0);
insert into merchantlist values (1000036,41,15177,-100,0,0);
insert into merchantlist values (1000036,42,16236,-100,0,0);
insert into merchantlist values (1000036,43,19378,-100,0,0);
insert into merchantlist values (1000036,44,16324,-100,0,0);
insert into merchantlist values (1000036,45,59005,-100,0,0);
insert into merchantlist values (1000036,46,28465,-100,0,0);
insert into merchantlist values (1000036,47,28535,-100,0,0);
insert into merchantlist values (1000036,48,77242,-100,0,0);
insert into merchantlist values (1000036,49,28567,-100,0,0);
insert into merchantlist values (1000036,50,77001,-100,0,0);
insert into merchantlist values (1000036,51,19480,-100,0,0);
insert into merchantlist values (1000036,52,19307,-100,0,0);
insert into merchantlist values (1000036,53,77008,-100,0,0);
insert into merchantlist values (1000036,54,16133,-100,0,0);
insert into merchantlist values (1000036,55,30413,-100,0,0);
insert into merchantlist values (1000036,56,77841,-100,0,0);
insert into merchantlist values (1000036,57,77876,-100,0,0);
insert into merchantlist values (1000036,58,77914,-100,0,0);
insert into merchantlist values (1000036,59,41289,-100,0,0);
insert into merchantlist values (1000036,60,19269,-100,0,0);
insert into merchantlist values (1000035,1,7648,-100,0,0);
insert into merchantlist values (1000035,2,77133,-100,0,0);
insert into merchantlist values (1000035,3,77030,-100,0,0);
insert into merchantlist values (1000035,4,26932,-100,0,0);
insert into merchantlist values (1000035,5,59839,-100,0,0);
insert into merchantlist values (1000035,6,77066,-100,0,0);
insert into merchantlist values (1000035,7,77168,-100,0,0);
insert into merchantlist values (1000035,8,78031,-100,0,0);
insert into merchantlist values (1000035,9,16439,-100,0,0);
insert into merchantlist values (1000035,10,19495,-100,0,0);
insert into merchantlist values (1000035,11,19203,-100,0,0);
insert into merchantlist values (1000035,12,30460,-100,0,0);
insert into merchantlist values (1000035,13,77842,-100,0,0);
insert into merchantlist values (1000035,14,77877,-100,0,0);
insert into merchantlist values (1000035,15,77897,-100,0,0);
insert into merchantlist values (1000035,16,41272,-100,0,0);
insert into merchantlist values (1000035,17,28420,-100,0,0);
insert into merchantlist values (1000035,18,19532,-100,0,0);
insert into merchantlist values (1000035,19,19296,-100,0,0);
insert into merchantlist values (1000035,20,7646,-100,0,0);
insert into merchantlist values (1000035,21,77830,-100,0,0);
insert into merchantlist values (1000035,22,77869,-100,0,0);
insert into merchantlist values (1000035,23,77831,-100,0,0);
insert into merchantlist values (1000035,24,77868,-100,0,0);
insert into merchantlist values (1000035,25,77829,-100,0,0);
insert into merchantlist values (1000035,26,19384,-100,0,0);
insert into merchantlist values (1000035,27,19481,-100,0,0);
insert into merchantlist values (1000035,28,19314,-100,0,0);
insert into merchantlist values (1000035,29,26937,-100,0,0);
insert into merchantlist values (1000035,30,77166,-100,0,0);
insert into merchantlist values (1000035,31,77224,-100,0,0);
insert into merchantlist values (1000035,32,77105,-100,0,0);
insert into merchantlist values (1000035,33,77016,-100,0,0);
insert into merchantlist values (1000035,34,77176,-100,0,0);
insert into merchantlist values (1000035,35,21659,-100,0,0);
insert into merchantlist values (1000035,36,28559,-100,0,0);
insert into merchantlist values (1000035,37,19312,-100,0,0);
insert into merchantlist values (1000035,38,77028,-100,0,0);
insert into merchantlist values (1000035,39,77676,-100,0,0);
insert into merchantlist values (1000035,40,16446,-100,0,0);
insert into merchantlist values (1000035,41,7626,-100,0,0);
insert into merchantlist values (1000035,42,19415,-100,0,0);
insert into merchantlist values (1000035,43,77048,-100,0,0);
insert into merchantlist values (1000035,44,19230,-100,0,0);
insert into merchantlist values (1000035,45,15693,-100,0,0);
insert into merchantlist values (1000035,46,30456,-100,0,0);
insert into merchantlist values (1000035,47,19328,-100,0,0);
insert into merchantlist values (1000035,48,59528,-100,0,0);
insert into merchantlist values (1000035,49,28441,-100,0,0);
insert into merchantlist values (1000035,50,28445,-100,0,0);
insert into merchantlist values (1000035,51,59816,-100,0,0);
insert into merchantlist values (1000035,52,77088,-100,0,0);
insert into merchantlist values (1000035,53,76055,-100,0,0);
insert into merchantlist values (1000035,54,76038,-100,0,0);
insert into merchantlist values (1000035,55,26943,-100,0,0);
insert into merchantlist values (1000035,56,78030,-100,0,0);
insert into merchantlist values (1000035,57,77917,-100,0,0);
insert into merchantlist values (1000035,58,41292,-100,0,0);
insert into merchantlist values (1000035,59,19236,-100,0,0);
insert into merchantlist values (1000035,60,77845,-100,0,0);
insert into merchantlist values (1000034,1,77879,-100,0,0);
insert into merchantlist values (1000034,2,77846,-100,0,0);
insert into merchantlist values (1000034,3,77844,-100,0,0);
insert into merchantlist values (1000034,4,77878,-100,0,0);
insert into merchantlist values (1000034,5,77208,-100,0,0);
insert into merchantlist values (1000034,6,59018,-100,0,0);
insert into merchantlist values (1000034,7,30403,-100,0,0);
insert into merchantlist values (1000034,8,16341,-100,0,0);
insert into merchantlist values (1000034,9,59825,-100,0,0);
insert into merchantlist values (1000034,10,16146,-100,0,0);
insert into merchantlist values (1000034,11,16119,-100,0,0);
insert into merchantlist values (1000034,12,16145,-100,0,0);
insert into merchantlist values (1000034,13,28421,-100,0,0);
insert into merchantlist values (1000034,14,19311,-100,0,0);
insert into merchantlist values (1000034,15,28492,-100,0,0);
insert into merchantlist values (1000034,16,16220,-100,0,0);
insert into merchantlist values (1000034,17,16212,-100,0,0);
insert into merchantlist values (1000034,18,16328,-100,0,0);
insert into merchantlist values (1000034,19,19222,-100,0,0);
insert into merchantlist values (1000034,20,19396,-100,0,0);
insert into merchantlist values (1000034,21,19313,-100,0,0);
insert into merchantlist values (1000034,22,59990,-100,0,0);
insert into merchantlist values (1000034,23,19263,-100,0,0);
insert into merchantlist values (1000034,24,7606,-100,0,0);
insert into merchantlist values (1000034,25,77179,-100,0,0);
insert into merchantlist values (1000034,26,77184,-100,0,0);
insert into merchantlist values (1000034,27,59003,-100,0,0);
insert into merchantlist values (1000034,28,77234,-100,0,0);
insert into merchantlist values (1000034,29,19336,-100,0,0);
insert into merchantlist values (1000034,30,15056,-100,0,0);
insert into merchantlist values (1000034,31,16134,-100,0,0);
insert into merchantlist values (1000034,32,19523,-100,0,0);
insert into merchantlist values (1000034,33,19411,-100,0,0);
insert into merchantlist values (1000034,34,28646,-100,0,0);
insert into merchantlist values (1000034,35,7657,-100,0,0);
insert into merchantlist values (1000034,36,77162,-100,0,0);
insert into merchantlist values (1000034,37,77128,-100,0,0);
insert into merchantlist values (1000034,38,16227,-100,0,0);
insert into merchantlist values (1000034,39,15191,-100,0,0);
insert into merchantlist values (1000034,40,16416,-100,0,0);
insert into merchantlist values (1000034,41,77236,-100,0,0);
insert into merchantlist values (1000034,42,26919,-100,0,0);
insert into merchantlist values (1000034,43,28554,-100,0,0);
insert into merchantlist values (1000034,44,26920,-100,0,0);
insert into merchantlist values (1000034,45,77909,-100,0,0);
insert into merchantlist values (1000034,46,41284,-100,0,0);
insert into merchantlist values (1000034,47,78029,-100,0,0);
insert into merchantlist values (1000034,48,16321,-100,0,0);
insert into merchantlist values (1000034,49,77183,-100,0,0);
insert into merchantlist values (1000034,50,77202,-100,0,0);
insert into merchantlist values (1000034,51,16314,-100,0,0);
insert into merchantlist values (1000034,52,21643,-100,0,0);
insert into merchantlist values (1000034,53,19255,-100,0,0);
insert into merchantlist values (1000034,54,30436,-100,0,0);
insert into merchantlist values (1000034,55,30454,-100,0,0);
insert into merchantlist values (1000034,56,32411,-100,0,0);
insert into merchantlist values (1000034,57,19344,-100,0,0);
insert into merchantlist values (1000034,58,21656,-100,0,0);
insert into merchantlist values (1000034,59,77258,-100,0,0);
insert into merchantlist values (1000034,60,21661,-100,0,0);
insert into merchantlist values (1000033,1,30432,-100,0,0);
insert into merchantlist values (1000033,2,26917,-100,0,0);
insert into merchantlist values (1000033,3,7616,-100,0,0);
insert into merchantlist values (1000033,4,59527,-100,0,0);
insert into merchantlist values (1000033,5,21652,-100,0,0);
insert into merchantlist values (1000033,6,77031,-100,0,0);
insert into merchantlist values (1000033,7,28414,-100,0,0);
insert into merchantlist values (1000033,8,15460,-100,0,0);
insert into merchantlist values (1000033,9,16335,-100,0,0);
insert into merchantlist values (1000033,10,19395,-100,0,0);
insert into merchantlist values (1000033,11,30431,-100,0,0);
insert into merchantlist values (1000033,12,19244,-100,0,0);
insert into merchantlist values (1000033,13,19260,-100,0,0);
insert into merchantlist values (1000033,14,19216,-100,0,0);
insert into merchantlist values (1000033,15,19252,-100,0,0);
insert into merchantlist values (1000033,16,21630,-100,0,0);
insert into merchantlist values (1000033,17,77055,-100,0,0);
insert into merchantlist values (1000033,18,59021,-100,0,0);
insert into merchantlist values (1000033,19,26931,-100,0,0);
insert into merchantlist values (1000033,20,19527,-100,0,0);
insert into merchantlist values (1000033,21,19496,-100,0,0);
insert into merchantlist values (1000033,22,16403,-100,0,0);
insert into merchantlist values (1000033,23,30410,-100,0,0);
insert into merchantlist values (1000033,24,30409,-100,0,0);
insert into merchantlist values (1000033,25,19401,-100,0,0);
insert into merchantlist values (1000033,26,19347,-100,0,0);
insert into merchantlist values (1000033,27,19247,-100,0,0);
insert into merchantlist values (1000033,28,77096,-100,0,0);
insert into merchantlist values (1000033,29,19240,-100,0,0);
insert into merchantlist values (1000033,30,77161,-100,0,0);
insert into merchantlist values (1000033,31,16232,-100,0,0);
insert into merchantlist values (1000033,32,16336,-100,0,0);
insert into merchantlist values (1000033,33,15635,-100,0,0);
insert into merchantlist values (1000033,34,15634,-100,0,0);
insert into merchantlist values (1000033,35,15633,-100,0,0);
insert into merchantlist values (1000033,36,21663,-100,0,0);
insert into merchantlist values (1000033,37,7660,-100,0,0);
insert into merchantlist values (1000033,38,26944,-100,0,0);
insert into merchantlist values (1000033,39,26945,-100,0,0);
insert into merchantlist values (1000033,40,37591,-100,0,0);
insert into merchantlist values (1000033,41,37592,-100,0,0);
insert into merchantlist values (1000033,42,37593,-100,0,0);
insert into merchantlist values (1000033,43,37594,-100,0,0);
insert into merchantlist values (1000033,44,37595,-100,0,0);
insert into merchantlist values (1000033,45,15573,-100,0,0);
insert into merchantlist values (1000033,46,15574,-100,0,0);
insert into merchantlist values (1000033,47,19371,-100,0,0);
insert into merchantlist values (1000033,48,19367,-100,0,0);
insert into merchantlist values (1000033,49,19372,-100,0,0);
insert into merchantlist values (1000033,50,77160,-100,0,0);
insert into merchantlist values (1000033,51,77261,-100,0,0);
insert into merchantlist values (1000033,52,76046,-100,0,0);
insert into merchantlist values (1000033,53,76063,-100,0,0);
insert into merchantlist values (1000033,54,21667,-100,0,0);
insert into merchantlist values (1000033,55,77052,-100,0,0);
insert into merchantlist values (1000033,56,77907,-100,0,0);
insert into merchantlist values (1000033,57,41282,-100,0,0);
insert into merchantlist values (1000033,58,28569,-100,0,0);
insert into merchantlist values (1000033,59,15997,-100,0,0);
insert into merchantlist values (1000033,60,77013,-100,0,0);
insert into merchantlist values (1000032,1,15995,-100,0,0);
insert into merchantlist values (1000032,2,28525,-100,0,0);
insert into merchantlist values (1000032,3,28570,-100,0,0);
insert into merchantlist values (1000032,4,16420,-100,0,0);
insert into merchantlist values (1000032,5,16428,-100,0,0);
insert into merchantlist values (1000032,6,15493,-100,0,0);
insert into merchantlist values (1000032,7,77255,-100,0,0);
insert into merchantlist values (1000032,8,28545,-100,0,0);
insert into merchantlist values (1000032,9,59014,-100,0,0);
insert into merchantlist values (1000032,10,19224,-100,0,0);
insert into merchantlist values (1000032,11,19213,-100,0,0);
insert into merchantlist values (1000032,12,78023,-100,0,0);
insert into merchantlist values (1000032,13,59821,-100,0,0);
insert into merchantlist values (1000032,14,59819,-100,0,0);
insert into merchantlist values (1000032,15,59833,-100,0,0);
insert into merchantlist values (1000032,16,7668,-100,0,0);
insert into merchantlist values (1000032,17,28452,-100,0,0);
insert into merchantlist values (1000032,18,19470,-100,0,0);
insert into merchantlist values (1000032,19,16417,-100,0,0);
insert into merchantlist values (1000032,20,15369,-100,0,0);
insert into merchantlist values (1000032,21,77056,-100,0,0);
insert into merchantlist values (1000032,22,15732,-100,0,0);
insert into merchantlist values (1000032,23,16338,-100,0,0);
insert into merchantlist values (1000032,24,15924,-100,0,0);
insert into merchantlist values (1000032,25,30426,-100,0,0);
insert into merchantlist values (1000032,26,77178,-100,0,0);
insert into merchantlist values (1000032,27,59008,-100,0,0);
insert into merchantlist values (1000032,28,16123,-100,0,0);
insert into merchantlist values (1000032,29,16421,-100,0,0);
insert into merchantlist values (1000032,30,16317,-100,0,0);
insert into merchantlist values (1000032,31,78027,-100,0,0);
insert into merchantlist values (1000032,32,57334,-100,0,0);
insert into merchantlist values (1000032,33,57332,-100,0,0);
insert into merchantlist values (1000032,34,57347,-100,0,0);
insert into merchantlist values (1000032,35,57351,-100,0,0);
insert into merchantlist values (1000032,36,57328,-100,0,0);
insert into merchantlist values (1000032,37,57335,-100,0,0);
insert into merchantlist values (1000032,38,57333,-100,0,0);
insert into merchantlist values (1000032,39,57352,-100,0,0);
insert into merchantlist values (1000032,40,57344,-100,0,0);
insert into merchantlist values (1000032,41,90047,-100,0,0);
insert into merchantlist values (1000032,42,57339,-100,0,0);
insert into merchantlist values (1000032,43,57331,-100,0,0);
insert into merchantlist values (1000032,44,57323,-100,0,0);
insert into merchantlist values (1000032,45,57336,-100,0,0);
insert into merchantlist values (1000032,46,15243,-100,0,0);
insert into merchantlist values (1000032,47,57340,-100,0,0);
insert into merchantlist values (1000032,48,57325,-100,0,0);
insert into merchantlist values (1000032,49,57330,-100,0,0);
insert into merchantlist values (1000032,50,57356,-100,0,0);
insert into merchantlist values (1000032,51,57317,-100,0,0);
insert into merchantlist values (1000032,52,19543,-100,0,0);
insert into merchantlist values (1000032,53,28463,-100,0,0);
insert into merchantlist values (1000032,54,21691,-100,0,0);
insert into merchantlist values (1000032,55,28462,-100,0,0);
insert into merchantlist values (1000032,56,28466,-100,0,0);
insert into merchantlist values (1000032,57,21695,-100,0,0);
insert into merchantlist values (1000032,58,28454,-100,0,0);
insert into merchantlist values (1000032,59,28456,-100,0,0);
insert into merchantlist values (1000032,60,21694,-100,0,0);
insert into merchantlist values (100039,1,21692,-100,0,0);
insert into merchantlist values (100039,2,21693,-100,0,0);
insert into merchantlist values (100039,3,28467,-100,0,0);
insert into merchantlist values (100039,4,16333,-100,0,0);
insert into merchantlist values (100039,5,16233,-100,0,0);
insert into merchantlist values (100039,6,28527,-100,0,0);
insert into merchantlist values (100039,7,77090,-100,0,0);
insert into merchantlist values (100039,8,30406,-100,0,0);
insert into merchantlist values (100039,9,30435,-100,0,0);
insert into merchantlist values (100039,10,66281,-100,0,0);
insert into merchantlist values (100039,11,19479,-100,0,0);
insert into merchantlist values (100039,12,19424,-100,0,0);
insert into merchantlist values (100039,13,28544,-100,0,0);
insert into merchantlist values (100039,14,77069,-100,0,0);
insert into merchantlist values (100039,15,28459,-100,0,0);
insert into merchantlist values (100039,16,19266,-100,0,0);
insert into merchantlist values (100039,17,16228,-100,0,0);
insert into merchantlist values (100039,18,16320,-100,0,0);
insert into merchantlist values (100039,19,16226,-100,0,0);
insert into merchantlist values (100039,20,77882,-100,0,0);
insert into merchantlist values (100039,21,77850,-100,0,0);
insert into merchantlist values (100039,22,77883,-100,0,0);
insert into merchantlist values (100039,23,77851,-100,0,0);
insert into merchantlist values (100039,24,77852,-100,0,0);
insert into merchantlist values (100039,25,15449,-100,0,0);
insert into merchantlist values (100039,26,16426,-100,0,0);
insert into merchantlist values (100039,27,19341,-100,0,0);
insert into merchantlist values (100039,28,30420,-100,0,0);
insert into merchantlist values (100039,29,16441,-100,0,0);
insert into merchantlist values (100039,30,15443,-100,0,0);
insert into merchantlist values (100039,31,16432,-100,0,0);
insert into merchantlist values (100039,32,16434,-100,0,0);
insert into merchantlist values (100039,33,15494,-100,0,0);
insert into merchantlist values (100039,34,77042,-100,0,0);
insert into merchantlist values (100039,35,77873,-100,0,0);
insert into merchantlist values (100039,36,77836,-100,0,0);
insert into merchantlist values (100039,37,7608,-100,0,0);
insert into merchantlist values (100039,38,28528,-100,0,0);
insert into merchantlist values (100039,39,21657,-100,0,0);
insert into merchantlist values (100039,40,21647,-100,0,0);
insert into merchantlist values (100039,41,7630,-100,0,0);
insert into merchantlist values (100039,42,7670,-100,0,0);
insert into merchantlist values (100039,43,77911,-100,0,0);
insert into merchantlist values (100039,44,41286,-100,0,0);
insert into merchantlist values (100039,45,15469,-100,0,0);
insert into merchantlist values (100039,46,16331,-100,0,0);
insert into merchantlist values (100039,47,28645,-100,0,0);
insert into merchantlist values (100039,48,19259,-100,0,0);
insert into merchantlist values (100039,49,28417,-100,0,0);
insert into merchantlist values (100039,50,15624,-100,0,0);
insert into merchantlist values (100039,51,16132,-100,0,0);
insert into merchantlist values (100039,52,16129,-100,0,0);
insert into merchantlist values (100039,53,16131,-100,0,0);
insert into merchantlist values (100039,54,16130,-100,0,0);
insert into merchantlist values (100039,55,19303,-100,0,0);
insert into merchantlist values (100039,56,59015,-100,0,0);
insert into merchantlist values (100039,57,16215,-100,0,0);
insert into merchantlist values (100039,58,16322,-100,0,0);
insert into merchantlist values (100039,59,19534,-100,0,0);
insert into merchantlist values (100039,60,15644,-100,0,0);
insert into merchantlist values (100040,1,16443,-100,0,0);
insert into merchantlist values (100040,2,15692,-100,0,0);
insert into merchantlist values (100040,3,59004,-100,0,0);
insert into merchantlist values (100040,4,26939,-100,0,0);
insert into merchantlist values (100040,5,59832,-100,0,0);
insert into merchantlist values (100040,6,77036,-100,0,0);
insert into merchantlist values (100040,7,16325,-100,0,0);
insert into merchantlist values (100040,8,15467,-100,0,0);
insert into merchantlist values (100040,9,77181,-100,0,0);
insert into merchantlist values (100040,10,77903,-100,0,0);
insert into merchantlist values (100040,11,41278,-100,0,0);
insert into merchantlist values (100040,12,77092,-100,0,0);
insert into merchantlist values (100040,13,77050,-100,0,0);
insert into merchantlist values (100040,14,77167,-100,0,0);
insert into merchantlist values (100040,15,19422,-100,0,0);
insert into merchantlist values (100040,16,28442,-100,0,0);
insert into merchantlist values (100040,17,77111,-100,0,0);
insert into merchantlist values (100040,18,77114,-100,0,0);
insert into merchantlist values (100040,19,59818,-100,0,0);
insert into merchantlist values (100040,20,19497,-100,0,0);
insert into merchantlist values (100040,21,29363,-100,0,0);
insert into merchantlist values (100040,22,28434,-100,0,0);
insert into merchantlist values (100040,23,59009,-100,0,0);
insert into merchantlist values (100040,24,28496,-100,0,0);
insert into merchantlist values (100040,25,16437,-100,0,0);
insert into merchantlist values (100040,26,19291,-100,0,0);
insert into merchantlist values (100040,27,26915,-100,0,0);
insert into merchantlist values (100040,28,28497,-100,0,0);
insert into merchantlist values (100040,29,16230,-100,0,0);
insert into merchantlist values (100040,30,19414,-100,0,0);
insert into merchantlist values (100040,31,19218,-100,0,0);
insert into merchantlist values (100040,32,28560,-100,0,0);
insert into merchantlist values (100040,33,7607,-100,0,0);
insert into merchantlist values (100040,34,28568,-100,0,0);
insert into merchantlist values (100040,35,19533,-100,0,0);
insert into merchantlist values (100040,36,28543,-100,0,0);
insert into merchantlist values (100040,37,19261,-100,0,0);
insert into merchantlist values (100040,38,19529,-100,0,0);
insert into merchantlist values (100040,39,59840,-100,0,0);
insert into merchantlist values (100040,40,15307,-100,0,0);
insert into merchantlist values (100040,41,16217,-100,0,0);
insert into merchantlist values (100040,42,59842,-100,0,0);
insert into merchantlist values (100040,43,16234,-100,0,0);
insert into merchantlist values (100040,44,7649,-100,0,0);
insert into merchantlist values (100040,45,19297,-100,0,0);
insert into merchantlist values (100040,46,15623,-100,0,0);
insert into merchantlist values (100040,47,15622,-100,0,0);
insert into merchantlist values (100040,48,59961,-100,0,0);
insert into merchantlist values (100040,49,16128,-100,0,0);
insert into merchantlist values (100040,50,16125,-100,0,0);
insert into merchantlist values (100040,51,16127,-100,0,0);
insert into merchantlist values (100040,52,16126,-100,0,0);
insert into merchantlist values (100040,53,76056,-100,0,0);
insert into merchantlist values (100040,54,76039,-100,0,0);
insert into merchantlist values (100040,55,30402,-100,0,0);
insert into merchantlist values (100040,56,30404,-100,0,0);
insert into merchantlist values (100040,57,59827,-100,0,0);
insert into merchantlist values (100040,58,19519,-100,0,0);
insert into merchantlist values (100040,59,77257,-100,0,0);
insert into merchantlist values (100040,60,77235,-100,0,0);
insert into merchantlist values (100041,1,19435,-100,0,0);
insert into merchantlist values (100041,2,77047,-100,0,0);
insert into merchantlist values (100041,3,30475,-100,0,0);
insert into merchantlist values (100041,4,28533,-100,0,0);
insert into merchantlist values (100041,5,28529,-100,0,0);
insert into merchantlist values (100041,6,26929,-100,0,0);
insert into merchantlist values (100041,7,7620,-100,0,0);
insert into merchantlist values (100041,8,77089,-100,0,0);
insert into merchantlist values (100041,9,77100,-100,0,0);
insert into merchantlist values (100041,10,77103,-100,0,0);
insert into merchantlist values (100041,11,21640,-100,0,0);
insert into merchantlist values (100041,12,59829,-100,0,0);
insert into merchantlist values (100041,13,59828,-100,0,0);
insert into merchantlist values (100041,14,59830,-100,0,0);
insert into merchantlist values (100041,15,21666,-100,0,0);
insert into merchantlist values (100041,16,16329,-100,0,0);
insert into merchantlist values (100041,17,16138,-100,0,0);
insert into merchantlist values (100041,18,16435,-100,0,0);
insert into merchantlist values (100041,19,16225,-100,0,0);
insert into merchantlist values (100041,20,59964,-100,0,0);
insert into merchantlist values (100041,21,77084,-100,0,0);
insert into merchantlist values (100041,22,59820,-100,0,0);
insert into merchantlist values (100041,23,26947,-100,0,0);
insert into merchantlist values (100041,24,21632,-100,0,0);
insert into merchantlist values (100041,25,77142,-100,0,0);
insert into merchantlist values (100041,26,77012,-100,0,0);
insert into merchantlist values (100041,27,15133,-100,0,0);
insert into merchantlist values (100041,28,16240,-100,0,0);
insert into merchantlist values (100041,29,16340,-100,0,0);
insert into merchantlist values (100041,30,16444,-100,0,0);
insert into merchantlist values (100041,31,26946,-100,0,0);
insert into merchantlist values (100041,32,19521,-100,0,0);
insert into merchantlist values (100041,33,77212,-100,0,0);
insert into merchantlist values (100041,34,77271,-100,0,0);
insert into merchantlist values (100041,35,77872,-100,0,0);
insert into merchantlist values (100041,36,77835,-100,0,0);
insert into merchantlist values (100041,37,16235,-100,0,0);
insert into merchantlist values (100041,38,15386,-100,0,0);
insert into merchantlist values (100041,39,16319,-100,0,0);
insert into merchantlist values (100041,40,19335,-100,0,0);
insert into merchantlist values (100041,41,19318,-100,0,0);
insert into merchantlist values (100041,42,19326,-100,0,0);
insert into merchantlist values (100041,43,77010,-100,0,0);
insert into merchantlist values (100041,44,77035,-100,0,0);
insert into merchantlist values (100041,45,77014,-100,0,0);
insert into merchantlist values (100041,46,26934,-100,0,0);
insert into merchantlist values (100041,47,77002,-100,0,0);
insert into merchantlist values (100041,48,77239,-100,0,0);
insert into merchantlist values (100041,49,77022,-100,0,0);
insert into merchantlist values (100041,50,7627,-100,0,0);
insert into merchantlist values (100041,51,19330,-100,0,0);
insert into merchantlist values (100041,52,21668,-100,0,0);
insert into merchantlist values (100041,53,19469,-100,0,0);
insert into merchantlist values (100041,54,19361,-100,0,0);
insert into merchantlist values (100041,55,19288,-100,0,0);
insert into merchantlist values (100041,56,19491,-100,0,0);
insert into merchantlist values (100041,57,19520,-100,0,0);
insert into merchantlist values (100041,58,59017,-100,0,0);
insert into merchantlist values (100041,59,15385,-100,0,0);
insert into merchantlist values (100041,60,16318,-100,0,0);
insert into merchantlist values (100042,1,28534,-100,0,0);
insert into merchantlist values (100042,2,9722,-100,0,0);
insert into merchantlist values (100042,3,30442,-100,0,0);
insert into merchantlist values (100042,4,21658,-100,0,0);
insert into merchantlist values (100042,5,21655,-100,0,0);
insert into merchantlist values (100042,6,77249,-100,0,0);
insert into merchantlist values (100042,7,77131,-100,0,0);
insert into merchantlist values (100042,8,77226,-100,0,0);
insert into merchantlist values (100042,9,26935,-100,0,0);
insert into merchantlist values (100042,10,26918,-100,0,0);
insert into merchantlist values (100042,11,19354,-100,0,0);
insert into merchantlist values (100042,12,19309,-100,0,0);
insert into merchantlist values (100042,13,16229,-100,0,0);
insert into merchantlist values (100042,14,19417,-100,0,0);
insert into merchantlist values (100042,15,77215,-100,0,0);
insert into merchantlist values (100042,16,28435,-100,0,0);
insert into merchantlist values (100042,17,19381,-100,0,0);
insert into merchantlist values (100042,18,19212,-100,0,0);
insert into merchantlist values (100042,19,7628,-100,0,0);
insert into merchantlist values (100042,20,19256,-100,0,0);
insert into merchantlist values (100042,21,19542,-100,0,0);
insert into merchantlist values (100042,22,19522,-100,0,0);
insert into merchantlist values (100042,23,15444,-100,0,0);
insert into merchantlist values (100042,24,16430,-100,0,0);
insert into merchantlist values (100042,25,77011,-100,0,0);
insert into merchantlist values (100042,26,16231,-100,0,0);
insert into merchantlist values (100042,27,28437,-100,0,0);
insert into merchantlist values (100042,28,16419,-100,0,0);
insert into merchantlist values (100042,29,77843,-100,0,0);
insert into merchantlist values (100042,30,77663,-100,0,0);
insert into merchantlist values (100042,31,77658,-100,0,0);
insert into merchantlist values (100042,32,30437,-100,0,0);
insert into merchantlist values (100042,33,28530,-100,0,0);
insert into merchantlist values (100042,34,7618,-100,0,0);
insert into merchantlist values (100042,35,59826,-100,0,0);
insert into merchantlist values (100042,36,16208,-100,0,0);
insert into merchantlist values (100042,37,16433,-100,0,0);
insert into merchantlist values (100042,38,28418,-100,0,0);
insert into merchantlist values (100042,39,77237,-100,0,0);
insert into merchantlist values (100042,40,76062,-100,0,0);
insert into merchantlist values (100042,41,76045,-100,0,0);
insert into merchantlist values (100042,42,28453,-100,0,0);
insert into merchantlist values (100042,43,19421,-100,0,0);
insert into merchantlist values (100042,44,77238,-100,0,0);
insert into merchantlist values (100042,45,28422,-100,0,0);
insert into merchantlist values (100042,46,28419,-100,0,0);
insert into merchantlist values (100042,47,28537,-100,0,0);
insert into merchantlist values (100042,48,19358,-100,0,0);
insert into merchantlist values (100042,49,77163,-100,0,0);
insert into merchantlist values (100042,50,19408,-100,0,0);
insert into merchantlist values (100042,51,19346,-100,0,0);
insert into merchantlist values (100042,52,21629,-100,0,0);
insert into merchantlist values (100042,53,59016,-100,0,0);
insert into merchantlist values (100042,54,77078,-100,0,0);
insert into merchantlist values (100042,55,28423,-100,0,0);
insert into merchantlist values (100042,56,19410,-100,0,0);
insert into merchantlist values (100042,57,16307,-100,0,0);
insert into merchantlist values (100042,58,77039,-100,0,0);
insert into merchantlist values (100042,59,21690,-100,0,0);
insert into merchantlist values (100042,60,77006,-100,0,0);
insert into merchantlist values (100043,1,16213,-100,0,0);
insert into merchantlist values (100043,2,19305,-100,0,0);
insert into merchantlist values (100043,3,28431,-100,0,0);
insert into merchantlist values (100043,4,28553,-100,0,0);
insert into merchantlist values (100043,5,21653,-100,0,0);
insert into merchantlist values (100043,6,77875,-100,0,0);
insert into merchantlist values (100043,7,77839,-100,0,0);
insert into merchantlist values (100043,8,77158,-100,0,0);
insert into merchantlist values (100043,9,77840,-100,0,0);
insert into merchantlist values (100043,10,77274,-100,0,0);
insert into merchantlist values (100043,11,16424,-100,0,0);
insert into merchantlist values (100043,12,16309,-100,0,0);
insert into merchantlist values (100043,13,77838,-100,0,0);
insert into merchantlist values (100043,14,77874,-100,0,0);
insert into merchantlist values (100043,15,19409,-100,0,0);
insert into merchantlist values (100043,16,28538,-100,0,0);
insert into merchantlist values (100043,17,77049,-100,0,0);
insert into merchantlist values (100043,18,28415,-100,0,0);
insert into merchantlist values (100043,19,28413,-100,0,0);
insert into merchantlist values (100043,20,16237,-100,0,0);
insert into merchantlist values (100043,21,7640,-100,0,0);
insert into merchantlist values (100043,22,26942,-100,0,0);
insert into merchantlist values (100043,23,77005,-100,0,0);
insert into merchantlist values (100043,24,16327,-100,0,0);
insert into merchantlist values (100043,25,15459,-100,0,0);
insert into merchantlist values (100043,26,21651,-100,0,0);
insert into merchantlist values (100043,27,30459,-100,0,0);
insert into merchantlist values (100043,28,77070,-100,0,0);
insert into merchantlist values (100043,29,30458,-100,0,0);
insert into merchantlist values (100043,30,19271,-100,0,0);
insert into merchantlist values (100043,31,19490,-100,0,0);
insert into merchantlist values (100043,32,77032,-100,0,0);
insert into merchantlist values (100043,33,59962,-100,0,0);
insert into merchantlist values (100043,34,77900,-100,0,0);
insert into merchantlist values (100043,35,41275,-100,0,0);
insert into merchantlist values (100043,36,77654,-100,0,0);
insert into merchantlist values (100043,37,77656,-100,0,0);
insert into merchantlist values (100043,38,28464,-100,0,0);
insert into merchantlist values (100043,39,77074,-100,0,0);
insert into merchantlist values (100043,40,76057,-100,0,0);
insert into merchantlist values (100043,41,76040,-100,0,0);
insert into merchantlist values (100043,42,76042,-100,0,0);
insert into merchantlist values (100043,43,76059,-100,0,0);
insert into merchantlist values (100043,44,77880,-100,0,0);
insert into merchantlist values (100043,45,77847,-100,0,0);
insert into merchantlist values (100043,46,77848,-100,0,0);
insert into merchantlist values (100043,47,77881,-100,0,0);
insert into merchantlist values (100043,48,77849,-100,0,0);
insert into merchantlist values (100043,49,77156,-100,0,0);
insert into merchantlist values (100043,50,77015,-100,0,0);
insert into merchantlist values (100043,51,28573,-100,0,0);
insert into merchantlist values (100043,52,77182,-100,0,0);
insert into merchantlist values (100043,53,77188,-100,0,0);
insert into merchantlist values (100043,54,77185,-100,0,0);
insert into merchantlist values (100043,55,21634,-100,0,0);
insert into merchantlist values (100043,56,28489,-100,0,0);
insert into merchantlist values (100043,57,77240,-100,0,0);
insert into merchantlist values (100043,58,19535,-100,0,0);
insert into merchantlist values (100043,59,21665,-100,0,0);
insert into merchantlist values (100043,60,77260,-100,0,0);
insert into merchantlist values (100044,1,28548,-100,0,0);
insert into merchantlist values (100044,2,7617,-100,0,0);
insert into merchantlist values (100044,3,19530,-100,0,0);
insert into merchantlist values (100044,4,77137,-100,0,0);
insert into merchantlist values (100044,5,77262,-100,0,0);
insert into merchantlist values (100044,6,77143,-100,0,0);
insert into merchantlist values (100044,7,19258,-100,0,0);
insert into merchantlist values (100044,8,77132,-100,0,0);
insert into merchantlist values (100044,9,28550,-100,0,0);
insert into merchantlist values (100044,10,19238,-100,0,0);
insert into merchantlist values (100044,11,77129,-100,0,0);
insert into merchantlist values (100044,12,19531,-100,0,0);
insert into merchantlist values (100044,13,28552,-100,0,0);
insert into merchantlist values (100044,14,19275,-100,0,0);
insert into merchantlist values (100044,15,77888,-100,0,0);
insert into merchantlist values (100044,16,77867,-100,0,0);
insert into merchantlist values (100044,17,76058,-100,0,0);
insert into merchantlist values (100044,18,76041,-100,0,0);
insert into merchantlist values (100044,19,26930,-100,0,0);
insert into merchantlist values (100044,20,77866,-100,0,0);
insert into merchantlist values (100044,21,30430,-100,0,0);
insert into merchantlist values (100044,22,77141,-100,0,0);
insert into merchantlist values (100044,23,28551,-100,0,0);
insert into merchantlist values (100044,24,28547,-100,0,0);
insert into merchantlist values (100044,25,77259,-100,0,0);
insert into merchantlist values (100044,26,19294,-100,0,0);
insert into merchantlist values (100044,27,77033,-100,0,0);
insert into merchantlist values (100044,28,77094,-100,0,0);
insert into merchantlist values (100044,29,59013,-100,0,0);
insert into merchantlist values (100044,30,28524,-100,0,0);
insert into merchantlist values (100044,31,77085,-100,0,0);
insert into merchantlist values (100044,32,28455,-100,0,0);
insert into merchantlist values (100044,33,28498,-100,0,0);
insert into merchantlist values (100044,34,77053,-100,0,0);
insert into merchantlist values (100044,35,21627,-100,0,0);
insert into merchantlist values (100044,36,28450,-100,0,0);
insert into merchantlist values (100044,37,15024,-100,0,0);
insert into merchantlist values (100044,38,16221,-100,0,0);
insert into merchantlist values (100044,39,30446,-100,0,0);
insert into merchantlist values (100044,40,19253,-100,0,0);
insert into merchantlist values (100044,41,7647,-100,0,0);
insert into merchantlist values (100044,42,28539,-100,0,0);
insert into merchantlist values (100044,43,77206,-100,0,0);
insert into merchantlist values (100044,44,77204,-100,0,0);
insert into merchantlist values (100044,45,77211,-100,0,0);
insert into merchantlist values (100044,46,77200,-100,0,0);
insert into merchantlist values (100044,47,77205,-100,0,0);
insert into merchantlist values (100044,48,77207,-100,0,0);
insert into merchantlist values (100044,49,15003,-100,0,0);
insert into merchantlist values (100044,50,77223,-100,0,0);
insert into merchantlist values (100044,51,77213,-100,0,0);
insert into merchantlist values (100044,52,16429,-100,0,0);
insert into merchantlist values (100044,53,16102,-100,0,0);
insert into merchantlist values (100044,54,77203,-100,0,0);
insert into merchantlist values (100044,55,16100,-100,0,0);
insert into merchantlist values (100044,56,29361,-100,0,0);
insert into merchantlist values (100044,57,29362,-100,0,0);
insert into merchantlist values (100044,58,19436,-100,0,0);
insert into merchantlist values (100044,59,29357,-100,0,0);
insert into merchantlist values (100044,60,77218,-100,0,0);
insert into merchantlist values (100045,1,29358,-100,0,0);
insert into merchantlist values (100045,2,29359,-100,0,0);
insert into merchantlist values (100045,3,30401,-100,0,0);
insert into merchantlist values (100045,4,77221,-100,0,0);
insert into merchantlist values (100045,5,29360,-100,0,0);
insert into merchantlist values (100045,6,77201,-100,0,0);
insert into merchantlist values (100045,7,59568,-100,0,0);
insert into merchantlist values (100045,8,76061,-100,0,0);
insert into merchantlist values (100045,9,76044,-100,0,0);
insert into merchantlist values (100045,10,15572,-100,0,0);
insert into merchantlist values (100045,11,15571,-100,0,0);
insert into merchantlist values (100045,12,15570,-100,0,0);
insert into merchantlist values (100045,13,77275,-100,0,0);
insert into merchantlist values (100045,14,28430,-100,0,0);
insert into merchantlist values (100045,15,28436,-100,0,0);
insert into merchantlist values (100045,16,77093,-100,0,0);
insert into merchantlist values (100045,17,19420,-100,0,0);
insert into merchantlist values (100045,18,19345,-100,0,0);
insert into merchantlist values (100045,19,21649,-100,0,0);
insert into merchantlist values (100045,20,28566,-100,0,0);
insert into merchantlist values (100045,21,28571,-100,0,0);
insert into merchantlist values (100045,22,15925,-100,0,0);
insert into merchantlist values (100045,23,15733,-100,0,0);
insert into merchantlist values (100045,24,16339,-100,0,0);
insert into merchantlist values (100045,25,16445,-100,0,0);
insert into merchantlist values (100045,26,15455,-100,0,0);
insert into merchantlist values (100045,27,59007,-100,0,0);
insert into merchantlist values (100045,28,28536,-100,0,0);
insert into merchantlist values (100045,29,59835,-100,0,0);
insert into merchantlist values (100045,30,59836,-100,0,0);
insert into merchantlist values (100045,31,59824,-100,0,0);
insert into merchantlist values (100045,32,59823,-100,0,0);
insert into merchantlist values (100045,33,59822,-100,0,0);
insert into merchantlist values (100045,34,59834,-100,0,0);
insert into merchantlist values (100045,35,77051,-100,0,0);
insert into merchantlist values (100045,36,77003,-100,0,0);
insert into merchantlist values (100045,37,77034,-100,0,0);
insert into merchantlist values (100045,38,28557,-100,0,0);
insert into merchantlist values (100045,39,77233,-100,0,0);
insert into merchantlist values (100045,40,26911,-100,0,0);
insert into merchantlist values (100045,41,7629,-100,0,0);
insert into merchantlist values (100045,42,19264,-100,0,0);
insert into merchantlist values (100045,43,21646,-100,0,0);
insert into merchantlist values (100045,44,77138,-100,0,0);
insert into merchantlist values (100045,45,19267,-100,0,0);
insert into merchantlist values (100045,46,28499,-100,0,0);
insert into merchantlist values (100045,47,19281,-100,0,0);
insert into merchantlist values (100045,48,19280,-100,0,0);
insert into merchantlist values (100045,49,26912,-100,0,0);
insert into merchantlist values (100045,50,19289,-100,0,0);
insert into merchantlist values (100045,51,19284,-100,0,0);
insert into merchantlist values (100045,52,19286,-100,0,0);
insert into merchantlist values (100045,53,28494,-100,0,0);
insert into merchantlist values (100045,54,28493,-100,0,0);
insert into merchantlist values (100045,55,59989,-100,0,0);
insert into merchantlist values (100045,56,28572,-100,0,0);
insert into merchantlist values (100045,57,15678,-100,0,0);
insert into merchantlist values (100045,58,26940,-100,0,0);
insert into merchantlist values (100045,59,19319,-100,0,0);
insert into merchantlist values (100045,60,28443,-100,0,0);
insert into merchantlist values (100046,1,19339,-100,0,0);
insert into merchantlist values (100046,2,28438,-100,0,0);
insert into merchantlist values (100046,3,28495,-100,0,0);
insert into merchantlist values (100046,4,19329,-100,0,0);
insert into merchantlist values (100046,5,77180,-100,0,0);
insert into merchantlist values (100046,6,59845,-100,0,0);
insert into merchantlist values (100046,7,28444,-100,0,0);
insert into merchantlist values (100046,8,21662,-100,0,0);
insert into merchantlist values (100046,9,59011,-100,0,0);
insert into merchantlist values (100046,10,77087,-100,0,0);
insert into merchantlist values (100046,11,16222,-100,0,0);
insert into merchantlist values (100046,12,15185,-100,0,0);
insert into merchantlist values (100046,13,77072,-100,0,0);
insert into merchantlist values (100046,14,24542,-100,0,0);
insert into merchantlist values (100046,15,26923,-100,0,0);
insert into merchantlist values (100046,16,28555,-100,0,0);
insert into merchantlist values (100046,17,19225,-100,0,0);
insert into merchantlist values (100046,18,77071,-100,0,0);
insert into merchantlist values (100046,19,19374,-100,0,0);
insert into merchantlist values (100046,20,19299,-100,0,0);
insert into merchantlist values (100046,21,77186,-100,0,0);
insert into merchantlist values (100046,22,19324,-100,0,0);
insert into merchantlist values (100046,23,16332,-100,0,0);
insert into merchantlist values (100046,24,26913,-100,0,0);
insert into merchantlist values (100046,25,21660,-100,0,0);
insert into merchantlist values (100046,26,19391,-100,0,0);
insert into merchantlist values (100046,27,28458,-100,0,0);
insert into merchantlist values (100046,28,19293,-100,0,0);
insert into merchantlist values (100046,29,19274,-100,0,0);
insert into merchantlist values (100046,30,28424,-100,0,0);
insert into merchantlist values (100046,31,26928,-100,0,0);
insert into merchantlist values (100046,32,77068,-100,0,0);
insert into merchantlist values (100046,33,21638,-100,0,0);
insert into merchantlist values (100046,34,21631,-100,0,0);
insert into merchantlist values (100046,35,77029,-100,0,0);
insert into merchantlist values (100046,36,26921,-100,0,0);
insert into merchantlist values (100046,37,28460,-100,0,0);
insert into merchantlist values (100046,38,77677,-100,0,0);
insert into merchantlist values (100046,39,30422,-100,0,0);
insert into merchantlist values (100046,40,77660,-100,0,0);
insert into merchantlist values (100046,41,19474,-100,0,0);
insert into merchantlist values (100046,42,77655,-100,0,0);
insert into merchantlist values (100046,43,19536,-100,0,0);
insert into merchantlist values (100046,44,7639,-100,0,0);
insert into merchantlist values (100046,45,19425,-100,0,0);
insert into merchantlist values (100046,46,16101,-100,0,0);
insert into merchantlist values (100046,47,28487,-100,0,0);
insert into merchantlist values (100046,48,59815,-100,0,0);
insert into merchantlist values (100046,49,59814,-100,0,0);
insert into merchantlist values (100046,50,30428,-100,0,0);
insert into merchantlist values (100046,51,59813,-100,0,0);
insert into merchantlist values (100046,52,30443,-100,0,0);
insert into merchantlist values (100046,53,16224,-100,0,0);
insert into merchantlist values (100046,54,19393,-100,0,0);
insert into merchantlist values (100046,55,77871,-100,0,0);
insert into merchantlist values (100046,56,77833,-100,0,0);
insert into merchantlist values (100046,57,77834,-100,0,0);
insert into merchantlist values (100046,58,77832,-100,0,0);
insert into merchantlist values (100046,59,77870,-100,0,0);
insert into merchantlist values (100046,60,77007,-100,0,0);
insert into merchantlist values (100047,1,19233,-100,0,0);
insert into merchantlist values (100047,2,19205,-100,0,0);
insert into merchantlist values (100047,3,28461,-100,0,0);
insert into merchantlist values (100047,4,21664,-100,0,0);
insert into merchantlist values (100047,5,16431,-100,0,0);
insert into merchantlist values (100047,6,7637,-100,0,0);
insert into merchantlist values (100047,7,26910,-100,0,0);
insert into merchantlist values (100047,8,19348,-100,0,0);
insert into merchantlist values (100047,9,28558,-100,0,0);
insert into merchantlist values (100047,10,59020,-100,0,0);
insert into merchantlist values (100047,11,19407,-100,0,0);
insert into merchantlist values (100047,12,19357,-100,0,0);
insert into merchantlist values (100047,13,19355,-100,0,0);
insert into merchantlist values (100047,14,19362,-100,0,0);
insert into merchantlist values (100047,15,16418,-100,0,0);
insert into merchantlist values (100047,16,28470,-100,0,0);
insert into merchantlist values (100047,17,19290,-100,0,0);
insert into merchantlist values (100047,18,26926,-100,0,0);
insert into merchantlist values (100047,19,77112,-100,0,0);
insert into merchantlist values (100047,20,77120,-100,0,0);
insert into merchantlist values (100047,21,77119,-100,0,0);
insert into merchantlist values (100047,22,19413,-100,0,0);
insert into merchantlist values (100047,23,19215,-100,0,0);
insert into merchantlist values (100047,24,77246,-100,0,0);
insert into merchantlist values (100047,25,30407,-100,0,0);
insert into merchantlist values (100047,26,77117,-100,0,0);
insert into merchantlist values (100047,27,28561,-100,0,0);
insert into merchantlist values (100047,28,26933,-100,0,0);
insert into merchantlist values (100047,29,77865,-100,0,0);
insert into merchantlist values (100047,30,77887,-100,0,0);
insert into merchantlist values (100047,31,77864,-100,0,0);
insert into merchantlist values (100047,32,77004,-100,0,0);
insert into merchantlist values (100047,33,76053,-100,0,0);
insert into merchantlist values (100047,34,76036,-100,0,0);
insert into merchantlist values (100047,35,28428,-100,0,0);
insert into merchantlist values (100047,36,77099,-100,0,0);
insert into merchantlist values (100047,37,30455,-100,0,0);
insert into merchantlist values (100047,38,26936,-100,0,0);
insert into merchantlist values (100047,39,59831,-100,0,0);
insert into merchantlist values (100047,40,59844,-100,0,0);
insert into merchantlist values (100047,41,19387,-100,0,0);
insert into merchantlist values (100047,42,19405,-100,0,0);
insert into merchantlist values (100047,43,19343,-100,0,0);
insert into merchantlist values (100047,44,28542,-100,0,0);
insert into merchantlist values (100047,45,28526,-100,0,0);
insert into merchantlist values (100047,46,28469,-100,0,0);
insert into merchantlist values (100047,47,19229,-100,0,0);
insert into merchantlist values (100047,48,28562,-100,0,0);
insert into merchantlist values (100047,49,19221,-100,0,0);
insert into merchantlist values (100047,50,16422,-100,0,0);
insert into merchantlist values (100047,51,16436,-100,0,0);
insert into merchantlist values (100047,52,28427,-100,0,0);
insert into merchantlist values (100047,53,19206,-100,0,0);
insert into merchantlist values (100047,54,16337,-100,0,0);
insert into merchantlist values (100047,55,15731,-100,0,0);
insert into merchantlist values (100047,56,30405,-100,0,0);
insert into merchantlist values (100047,57,77135,-100,0,0);
insert into merchantlist values (100047,58,21637,-100,0,0);
insert into merchantlist values (100047,59,19209,-100,0,0);
insert into merchantlist values (100047,60,21689,-100,0,0);
insert into merchantlist values (100048,1,77121,-100,0,0);
insert into merchantlist values (100048,2,77134,-100,0,0);
insert into merchantlist values (100048,3,77140,-100,0,0);
insert into merchantlist values (100048,4,77130,-100,0,0);
insert into merchantlist values (100048,5,26925,-100,0,0);
insert into merchantlist values (100048,6,7650,-100,0,0);
insert into merchantlist values (100048,7,77116,-100,0,0);
edit: duplcates removed
|
|
|
|
|
|
|
03-05-2013, 10:10 PM
|
|
Hill Giant
|
|
Join Date: Sep 2008
Location: So. California
Posts: 219
|
|
Looks like you are using excel to join cells via ="("&A2&","&B2&")" ect ect. You could run the next available sql on the recipe table, and set the limit to say 100, and export the results to excel, then use that as your id column (A)for the tradeskill_recipe sql import. Column B is the name field and you can use your premade names if you have them from row1 to row100, next columns are; 63, 200, 250 (trivial), 0, 0, Made by ME, 0, 0
Then highlight cells c1:j1 to auto fill rows 2 -100 with the same info as row 1. Next create the sql compatible cell in cell L1 with
="("&A1&",'"&B1&"',"&C1&","&D1&","&E1&","&F1&","&G 1&",'"&H1&"',"&I1&","J1&"),"
drag bottom right hand corner (crosshair icon) down to row 100. This converts to:
Code:
(82,'Ykesha recipe name',63,200,250,0,0,'Made by ME',0,0),
I have templates made for importing sql that I edit with notepad++, for tradeskill_recipe it looks like this:
Code:
INSERT INTO `tradeskill_recipe` (`id`,`name`,`tradeskill`,`skillneeded`,`trivial`,`nofail`,`replace_container`,`notes`,`must_learn`,`quest`) VALUES
I open this template up in notepad++ and on line 3 or 4 I paste the info in excel column L1:L100. after pasting I scroll to the bottom line and replace the last comma with a semi colon, then I save this file as tradeskill_recipe_1.sql and import to the db...
Of coarse if you added the extra column from c0ncrete's sql then you would add that in to the template and excel as well.
Then run the next available sql to get the next 100 ect ect...This way you have control over where the sql is being inserted, and have reference recipe ids in hand when you build the tradeskill_recipe_entries sql..
|
|
|
|
03-06-2013, 08:17 AM
|
|
Sarnak
|
|
Join Date: Dec 2007
Posts: 57
|
|
Good thinking, rencro - and yes I am using excel's & x & Y & z cell joining to create the lists. (well, libre office, but the same general idea, yes) and auto-filling is the best invention ever.
That was my plan, in a nutshell, to do pretty much exactly what you said, although I still have several hundred combines to finish creating (concept-wise) before I can begin to script them.
Great idea, using the next available sql script like that - I hadn't considered utilizing it in that manner. Thanks.
|
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 04:06 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
