Hello to all EQEmuers!
I'm wondering if someone could help me out.
I'm working on my "all-in-one" app (
here)
For the character editor, I'm in need of some "real" data. Could someone dump their character & bots tables and either send them to me or make them available for download?
I'm looking for a sample size of 1000+ characters if possible. Preferably mid-high level with AA's etc etc.
If someone could do this I would greatly appreciate it.
PM me if you have any questions. None of the tables listed should have any ip addresses in them, I don't need or want any of that.
To make it easier I'm including the code that would need to be run (windows) to dump the needed tables.
Create an empty folder
Create a .bat file and put this code inside it
Code:
@echo off
cls
set /p LOGIN=MySQL Login:
set /p PASS=MYSQL Pass:
set /p DB=DB Name:
for /F %%g in (list.txt) do mysqldump -u%LOGIN% -p%PASS% %DB% %%g > %%g.sql
save the .bat file in the empty folder
create a text file called 'list.txt' in the same folder as the .bat file and paste the following in it
Code:
aa_timers
account_rewards
adventure_details
adventure_members
adventure_stats
botadventuring
botbuffs
botgroups
botguildmembers
botinventory
botpetstatepersists
bots
bugs
buyer
character_
character_activities
character_alt_currency
character_backup
character_buffs
character_enabledtasks
character_pet_buffs
character_pet_info
character_pet_inventory
character_tasks
char_recipe_list
chatchannels
completed_tasks
discovered_items
eventlog
faction_values
friends
gm_ips
group_id
group_leaders
guilds
guild_bank
guild_members
guild_ranks
guild_relations
hackers
instance_lockout
instance_lockout_player
inventory
keyring
mail
merchantlist_temp
object_contents
petitions
player_corpses
player_corpses_backup
player_titlesets
quest_globals
raid_details
raid_members
reports
respawn_times
sharedbank
spell_globals
timers
trader
trader_audit
zone_flags
save list.txt in the empty folder
run your .bat file, when it's done zip or rar the .sql files created.
Help Request
Linear Mode
