func Clean(args ...string) (err error) {
db, err := eqdb.Load()
if err != nil {
return
}
config, err := eqconfig.Load()
if err != nil {
return
}
//Mobs
ids := []int64{
111050, //Gellrazz Scalerunner
25429, //a dark spirit of nektulos
59438, //coldwind blackfoot
48343, //immug lashtail
13138, //frog invasion
6251,
}
//#checkpoint_ten
spawngroup.RemoveSpawnGroupAndEntryById(db, ids)
//Items
ids = loadIds()
totalChanged, err := item.RemoveAllInstancesOfItems(db, ids)
if err != nil {
return
}
fmt.Println("Removed", totalChanged, " DB entries related to", focus, "in all player-accessible item locations.")
filePaths := []string{
//"befallen/Wraps_McGee.lua",
}
delCount, err := quest.Remove(config, filePaths)
if err != nil {
fmt.Println(err.Error())
}
fmt.Println("Deleted", delCount, focus, "related quest files")
return
}
func Clean(args ...string) (err error) {
db, err := eqdb.Load()
if err != nil {
return
}
totalChanged := int64(0)
fmt.Println("Looking for augment item ids...")
rows, err := db.Query("SELECT id FROM items WHERE augtype > 0")
if err != nil {
return
}
ids := []int64{}
//iterate results
for rows.Next() {
id := int64(0)
err = rows.Scan(&id)
if err != nil {
return
}
ids = append(ids, id)
}
fmt.Println("Found", len(ids), " augments, deleting their entries...")
moreChanged, err := item.RemoveAllInstancesOfItems(db, ids)
if err != nil {
return
}
totalChanged += moreChanged
fmt.Println("Updated", totalChanged, " DB entries related to", focus)
return
}
func Clean(args ...string) (err error) {
db, err := eqdb.Load()
if err != nil {
return
}
config, err := eqconfig.Load()
if err != nil {
return
}
//Mobs
ids := []int64{
19151, //Laryn lycanthrope
202373,
202384, //wicked winnie
202385, //a wizeened hermit
20255,
20255, //booberella
20256,
20256,
20257,
20257,
20258,
20258,
20259,
20259, //Eve_Hallows
20260, //Jack Lanturn
20261,
20261,
20262,
20262,
20263, //tricksy_treetor
20264,
20264,
20265,
20265,
20266,
20266,
20267,
20267,
20268,
20268,
20269,
20269, //an_imp
20270,
20270,
20271,
20271,
20272,
20272, //a_zombie
20273,
20273,
20274,
20274,
20275, //Mippie Digs
20279, //Old man draykey
20281, //Syxa
20285, //Crazy Charlie
20288, //lurgh
20289, //a_jack_o_lantern
25436, //grom shives
38178, //marta stalwart
394263, //aragol gloomflow
48350,
48352,
48353,
48354,
63099,
98641,
98643,
98989, //lurgh
}
//#checkpoint_ten
spawngroup.RemoveSpawnGroupAndEntryById(db, ids)
//Items
ids = []int64{
84084, //Gummie Kobolds
84088, //rock candy
84091, //sand
84092, //chunk of coal
84093, //pocket lint
84094, //Draykey's Codex
84095, //Trick or treat bag
}
totalChanged, err := item.RemoveAllInstancesOfItems(db, ids)
if err != nil {
return
}
fmt.Println("Removed", totalChanged, " DB entries related to", focus, "in all player-accessible item locations.")
filePaths := []string{
"befallen/Wraps_McGee.lua",
"commonlands/Sergeant_Ragus.pl",
"crescent/#Aragol_Gloomflow.pl",
"ecommons/Sergeant_Ragus.pl",
"fieldofbone/Immug_Lashtail.pl",
"iceclad/Nilham_the_Chef.pl",
"kithicor/Old_Man_Draykey.pl",
"mistmoore/Nate.pl",
"quests/nektulos/Grom_Shives.pl",
"quests/netherbian/Poil_Lolp.pl",
"poknowledge/Grand_Librarian_Maelin.pl",
"qey2hh1/Scary_Miller.lua",
"rivervale/Laryen_Lycanthrope.pl",
"tox/Fuzz_Selppa.pl",
"toxxulia/Fuzz_Selppa.pl",
"unrest/Crabby_the_Rotten.pl",
"nektulos/#checkpoint_ten.pl", //trick or treat stop
"unrest/Halloween_Trigger.pl", //trick or treat stop
"unrest/Casper.pl",
"unrest/Candy_Man.pl",
"unrest/Evil_Brain_Eater.pl",
"unrest/Eviler_Brain_Eater.pl",
"unrest/Evilerer_Brain_Eater.pl",
"unrest/Imp-ossible.pl",
"unrest/Jack_o_Lantern.pl",
"unrest/Not_So_Evil_Brain_Eater.pl",
"unrest/Super_Ghoul_of_Unlimited_Power.pl",
"unrest/Werewolf_of_DOOOOOOOM.pl",
}
delCount, err := quest.Remove(config, filePaths)
if err != nil {
fmt.Println(err.Error())
}
fmt.Println("Deleted", delCount, focus, "related quest files")
return
}
func Clean(args ...string) (err error) {
db, err := eqdb.Load()
if err != nil {
return
}
//SpawnGroups
ids := []int64{
6746, //tallik in ec
6747, //palik in ec
728, //rushka in ec
716, //olin in ec
717, //wilno in ec
718, //almon in ec
/*//Neriakc
//cleric
3162, //svlia in Neriakc
3163, //Isshia
3164, //trik
3160, //lyniv
3159, //myrish
3165, //sol
//wizard
3142, //jusar
3141, //misar
5791, //drisi
5792, //ash
//SK
3152,
//Necro
3154,
//Neriakb
//wiz
3127, //riv
3122, //tal
3130,
3129,
3121,
3124,
3125,
3132,
3131,
3133,
3128,
3119,
3123,
//rivervale
7706, //ilscent
5674, //bumpy
//staria
5686, //fralith
5676, //torth
//akanon
48152,
48151,
48150,
48158,
7159,
7160,
7154,
48136,
//gfay
1523,
1522,
//grobb
5581,
3480,
5582,
5558,
5591,
5615,
5628,*/
}
fmt.Println("Getting all spell selling NPCs...")
mids, err := spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Bard Songs")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "General Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Berserker Tomes")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Cleric Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Druid Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Enchanter Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Magician Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Monk Tomes")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Necromancer Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Paladin Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Ranger Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Rogue Tomes")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Shadowknight Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Shaman Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Warrior Tomes")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
mids, err = spawngroup.GetSpawnGroupIdsByLastNameWildcard(db, "Wizard Spells")
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
for _, id := range mids {
ids = append(ids, id)
}
fmt.Println("Got", len(ids), "Npcs")
fmt.Println("Removing spell NPC spawn points, there's a lot, may take a while")
totalChanged, err := spawngroup.RemoveSpawnGroupAndEntryById(db, ids)
if err != nil {
err = fmt.Errorf("Error removing", focus, "entries: %s", err.Error())
return
}
//Find all item IDS
fmt.Println("Now getting all spell item entries, there's a lot here too, expect a while")
rows, err := db.Query("SELECT id FROM items WHERE scrolleffect > 0")
if err != nil {
return
}
//iterate results
for rows.Next() {
id := int64(0)
err = rows.Scan(&id)
if err != nil {
return
}
ids = append(ids, id)
}
fmt.Println("Found", len(ids), " spells, deleting them...")
moreChanged, err := item.RemoveAllInstancesOfItems(db, ids)
if err != nil {
return
}
totalChanged += moreChanged
fmt.Println("Removed", totalChanged, " DB entries related to", focus, "in all player-accessible item locations.")
return
}
