Getting Started
Rules
Character Mover
Optimization Guide
EZ Wiki
EZ Guide
Magelo
Zone List
Spell Recipes
T10.5 Spell Recipes
Crafting Recipes
Donate
EZ Player Discord
EZ Server Files
EZ Client Downloads
Custom UF MiniMap
Custom UF Inventory
EQEmulator Home
Allakhazam Home
UFMissingFilesList
TwitchTV
############################################################################ Script: RoA.pl# Purpose: Add mana regeneration to RoA, using the $increment field# Author: Hateborne# Notes: To adjust the script, simply input correct username,# password, db, and correctly set the $increment field.###########################################################################use DBI; sub go{ my ($db) = "peq"; # database name my ($user) = "root"; # database username my ($pass) = "password"; # database password my ($dbh, $sth, @arr, $query); # handles and the array variable my ($dsn) = "DBI:mysql:$db:host=127.0.0.1" || die "Can't access database - $DBI::errstr\n"; # data source name # build database handle $dbh = DBI->connect($dsn, $user, $pass, { RaiseError => 1}); #printf "dbh is $dbh\n"; ## DEBUG #################################################### my $increment = 5; # amount of regen per rank #################################################### # build an array of queries for ($i = 1; $i <= 100; $i++) { my $regenVal = $i * $increment; $statement = "UPDATE items SET manaregen = $regenVal WHERE name = 'Ring of the Ages $i'"; #printf "$statement\n"; ## DEBUG @arr[$i-1] = $statement; } # pass that array of queries # (separated from above for efficiency) foreach (@arr) { $dbh->do($_) || die "Couldn't update item - $DBI::err\n"; #printf "$_\n"; ## DEBUG } # close out $dbh->disconnect();}go();
switch(item->BardType) { case 51: /* All (e.g. Singing Short Sword) */ { if(item->BardValue > newbon->singingMod) newbon->singingMod = item->BardValue; if(item->BardValue > newbon->brassMod) newbon->brassMod = item->BardValue; if(item->BardValue > newbon->stringedMod) newbon->stringedMod = item->BardValue; if(item->BardValue > newbon->percussionMod) newbon->percussionMod = item->BardValue; if(item->BardValue > newbon->windMod) newbon->windMod = item->BardValue; break; }
Class Thurgadin Armour(Item IDs) Kael Armour(Item IDs) Skyshrine Armour(Item IDs)Warrior Champion's(31084-31090) Warlord's(25433-25439) Armour of the Myrmidon(31182-31188)Monk Grand Master's(31091-31097) Golden Star(25440-25446) White Lotus(31189-31195)Rogue Brigand's(31028-31034) Deceiver's(25377-25383) Shadow(31126-31132)Bard Resonant(31035-31041) Troubadour's(25384-25390) Twilight(31133-31139)Paladin Runed Protector(31021-31027) Shining(25371-25376) Scaled Knight's(31119-31125)Shadow Knight Dark Runed(31000-31006) Malevolent(25349-25354) Blood Lord's(31098-31104)Ranger Runed Scouts(31014-31020) Forest Stalkers(25363-25369) Golden Leaf(31112-31118)Shaman Rune Crafters(31007-31013) Spirit Callers(25356-25362) Wolf Caller's(31105-31111)Cleric Forbidden Rites(31042-31048) Templars(25391-25397) Risen(31140-31145)Druid Rowyl's Armour of Nature(31049-31055) Nature Walker's(25398-25404) Woven Grass(31147-31153)Enchanter Beguiler's(31077-31083) Dazzling(25426-25432) Illusionist's(31175-31181)Magician Arch Mage's(31070-31076) Summoner's(25419-25425) Prestidigitator's(31168-31174)Wizard Sage's(31056-31062) Invoker(25405-25411) Icicle(31154-31160)Necromancer Warlock's(31063-31069) Plague Bearer's(25412-25418) Rotting(31161-31167)