Read the earlier posts. It was pretty much handed to you.do you guys have a file from the market that i can use?
Using this marks the server as closed, any help?
My server is a fresh install following a tutorial that was using devilspeak's.I've tampered extensively with the two mongo tables this script changes. In the process of getting the script to work, I've put bad data in, incomplete data in, and dropped the tables entirely.
The python script literally only touches those two tables, and if you drop them (itemMarket, and itemMarketMaster), the server can still start fine, it just recreates them as needed. If dropping those tables doesn't fix your server and those tables are literally the only thing the script touches then it looks like the problem is elsewhere.
Whatever has gone wrong for you, and sorry if it seems like I'm just dodging, but I don't see how my script could have caused it. It could be that starting the server without creating the user first caused it to enter this new error state but it would be atypical of the issues I have seen, so I kind of doubt it.
If you have done anything else with your server recently, I would focus on that.
My server is a fresh install following a tutorial that was using devilspeak's.
Could it have something to do with those two tables not existing originally?
Dropping the 2 tables does fix the server closed, and yes I was able to play priorJust to confirm, you were able to play and login prior to running my script right? Your server worked, you shut it off, you left mongodb running, you ran my script, then you restarted loginserver and gameserver with no other configuration changes, and when you hit play from the main menu you got "Server Closed" message. If all of that is true that it certainly appears my script caused the issue but I still don't see how.
The only time I've seen the server closed message was when I tried to login before the gameserver had fully completed it's initialization. Take a look at gameserver's console output and see if it reaches the point of successfully connecting to the loginserver at the end.
Have you tried dropping the two tables I mentioned? It's a long shot imo but should be ruled out.
-Boss Gears, Steel Taritas, Taritas, Zereth, Agerian, Hercules', Grunil, Fortuna, Rocaba, Heve, Talis and their Ultimate versions
-AP Bonus to helmets (Enchant x3, so +60 AP at PEN
UPDATE `2_Blunt` SET
AddedDDD = (Enchant * 3) + AddedDDD,
AddedRDD = (Enchant * 3) + AddedRDD,
AddedMDD = (Enchant * 3) + AddedMDD
WHERE `Index` IN (11013, 10813, 10821, 10809, 11005, 11001, 11009, 10817, 10933, 10937, 10421, 10853, 10869, 10837, 11030, 11062, 10985, 11046, 10885);
-Damage reduction bonus to chest pieces, 60 DR at PEN
UPDATE `2_Blunt` SET
DPV = (Enchant * 3) + DPV,
RPV = (Enchant * 3) + RPV,
MPV = (Enchant * 3) + MPV,
HDPV = (Enchant * 3) + HDPV,
HRPV = (Enchant * 3) + HRPV,
HMPV = (Enchant * 3) + HMPV
WHERE `Index` IN (11017, 11014, 10814, 10822, 10810, 11006, 11002, 11010, 10818, 10934, 10938, 14122, 10854, 10870, 10838, 11031, 10962, 11063, 10986, 11047, 10886);
-Accuracy bonus to gloves, 60 accuracy at PEN
UPDATE `2_Blunt` SET
DHit = (Enchant * 3) + DHit,
MHit = (Enchant * 3) + MHit,
RHit = (Enchant * 3) + RHit
WHERE `Index` IN (11015, 10815, 10823, 10811, 11007, 11003, 11011, 10819, 10935, 10939, 14123, 10855, 10871, 10839, 11032, 10963, 11064, 10987, 11048, 10887);
-Evasion bonus to shoes, 60 evasion at PEN
UPDATE `2_Blunt` SET
DDV = (Enchant * 3) + DDV,
RDV = (Enchant * 3) + RDV,
MDV = (Enchant * 3) + MDV
WHERE `Index` IN (11016, 10816, 10824, 10812, 11008, 11004, 11012, 10820, 10936, 10940, 14124, 10856, 10872, 10840, 10964, 11065, 10988, 11033, 11049, 10888);
--2 HP/MP regen on all binder accessories
UPDATE `3_TwoHandSword` SET VariedRecovHP = 2, VariedRecovMP = 2 WHERE `Index` IN (11608, 11809, 12009, 12209);
--Sometimes regen doesn't work until you use a potion, but then it starts working as normal
--Mark of Shadow: - Crit+2,HPRegen+5
UPDATE `3_TwoHandSword` SET Itemname='Mark of Shadow', VariedCriticalRate=2, VariedRecovHP=5 WHERE `Index`=12007;
--Shrine Guardian's Token: MPRegen+10,Attack/Cast speed+2
UPDATE `3_TwoHandSword` SET Itemname='Shrine Guardian Token', VariedRecovMP=10, VariedAttackSpeedRate=2,VariedCastingSpeedRate=2 WHERE `Index`=12008;
--Ancient Guardian's Seal: Gathering+3,Luck+3,HPRegen+20
UPDATE `3_TwoHandSword` SET Itemname='Ancient Guardian Seal', VariedRecovHP=20, VariedCollectionSpeedRate=2, VariedFishingSpeedRate=2, VariedDropItemRate=2 WHERE `Index`=11613;
-- Jarette Necklace: Ultimate Damage
UPDATE `3_TwoHandSword` SET Itemname='Jarette Necklace', AddedDDD=8000, AddedRDD=8000, AddedMDD=8000, DHIT=8000, RHIT=8000, MHIT=8000, VariedCriticalRate=5, VariedAttackSpeedRate=5, VariedCastingSpeedRate=5, VariedCollectionSpeedRate=5, VariedFishingSpeedRate=5, VariedDropItemRate=5, VariedMaxMP=8000, VariedMaxMP=8000, VariedRecovMP=500 WHERE `Index`=11626;
-- Jarette Ring More Ultimate Damage
UPDATE `3_TwoHandSword` SET Itemname='Jarette Ring', AddedDDD=32000, AddedRDD=32000, AddedMDD=32000 WHERE `Index`=12035;
-- Jarette Earring Even More Ultimate Damage
UPDATE `3_TwoHandSword` SET Itemname='Jarette Earring', AddedDDD=64000, AddedRDD=64000, AddedMDD=64000 WHERE `Index`=11829;
-- Jarette Belt: Ultimate Tank
UPDATE `3_TwoHandSword` SET Itemname='Jarette Belt', DPV=2000, RPV=2000, MPV=2000, HDPV=2000, HRPV=2000, HMPV=2000, VariedRecovHP=2000, VariedMaxHP=8000 WHERE `Index`=12231;
- ## Crafting ##
- [ 50000, 44195 ], # Memory Fragment
- [ 100000, 4911, 4910 ], # grade 3 reform stones
- [ 100000, 16001, 16002 ], # Black stones
- [ 10000000, 16004, 16005 ], # Concentrated Black stones
- [ 100000, 9999, 16001, 16002 ], # Black stones
- [ 10000000, 999, 16004, 16005 ], # Concentrated Black stones
Hello @fullhawk,
Hoping I won't bother you witht he following question: I'm trying to understand your script in order to add items.
My question is: in the specific case of Black Stone, why are you putting them 2 times...
Here:
And here:
Why not only leave the code with the quantity ?
Thanks.