Restoring custum content after server update..

[Lillu]

Thanks Congdar. No wonder I haven't found this post, it was a tad offtopic in that thread..

I'll look into this tonight. Thank again for the help.

[Congdar]

on windows, you can right click just about anywhere and it brings up a menu that you can select New->Text Document
Do that and rename it to MyUpdates.sql
then inside it is where you keep track of you custom addtions to the database. For example on my server I allow level 70 instead of the default 65, so in MyUpdates.sql I have:

update rule_values set rule_value='70' where rule_name='Character:MaxLevel';

I also have a custom test npc. The lines with a '#' are ignored by mysql so you can add comments

#Test npc
insert into npc_types (        name, level, race, class, bodytype,         hp, gender,  texture, helmtexture, size, hp_regen_rate, mana_regen_rate, loottable_id, merchant_id, npc_spells_id, npc_faction_id, mindmg, maxdmg, npcspecialattks, aggroradius, face, runspeed,  MR,  CR,  DR,  FR,  PR, see_invis, see_invis_undead,  qglobal,  AC, spawn_limit,  findable, STR,  STA,  DEX,  AGI,  _INT, WIS, CHA, see_hide, see_improved_hide, trackable, isbot)
                      VALUES ('Test_Dummy',    66,  217,     1,        7,  999999999,      0,        0,           0,   14,           500,               0,            0,           0,             0,              0,      1,      1,           '',          55,  255,      1.9,   0,   0,   0,   0,   0,         0,                0,        1,   0,           0,         1, 192,  192,  192,  192,   192, 192, 192,        0,                 0,         1,     0);

For updates, I use the peq database so I get the latest from the peq db svn.
I have bots on my server so I run the bot_npcs.bat file provided by peq to save the bots from the npc_types table to a bot_npcs.sql file. I've updated it a little for windows:

mysqldump -u root -p "--where=id in (select botnpctypeid from botsowners)" -x -t peq npc_types > bot_npcs.sql

if 'root' is not your loginname, change it.
Now I open a command window. It is best to open this window and change the directory to where your .sql files are so you don't have to type in paths in the sql commands. In the command window type 'mysql -u LoginName -p' and hit the Enter key. It will ask for my password. These values are also in your eqemu_config.xml file if you forgot them.
Now in the command window it should look like this: mysql>
type in '\u DatabaseName'
your database name could be peq or ax_classic or something else. This \u is to Use that database. I then type in: source drop_system.sql
this will delete all the system stuff but it will leave the player stuff like characters and bot inventory if you use bots. With the fresh download from peq svn, all the newest stuff is in the .gz file that is kinda like a .zip file but it's the linux version. Inside is a .sql file with a real long name. extract it out. Now type in: 'source reallylongname.sql' and hit the enter key. substitue reallylongname for the actual name you extracted out of the .gz file.(winrar is best for windows .gz files).
OK, now for your custom stuff. Type in: 'source MyUpdates.sql' and hit enter. Now type in: 'source bot_npcs.sql' and hit enter.
Hopefully no errors and you're up to date!

[Lillu]

thanks a lot mate, this was exactely the information I was seeking for days now! all seems clear besides one thing. I create a lot of custom content ingame (with GM char) and also with GeorgeS tools. creating custom items, npcs (with custom loot table, spawn groups, etc) etc, seems extremely hard to create manually (if I can make those entries manually at all). is there a way to export those 'automatically' created database entries from peq to MyUpdates.sql?

e.g. I make an NPC in Georges tools. I create a spaw location entry ingame with with my GM using #dbspawn npc_id, then I create custom spawn locations for that spawngroup id, and then I #spawnfix each spawnlocation ingame with my GM.. this is like many many custom db entries in at least 2 separate db tables. any way to 'export' all of this from peq to MyUpdates.sql?

[Congdar]

sorry, not familiar with those tools. maybe ask in thier forums. they might log the updates and maybe the log file has the sql that was used?

[neiv2]

I've asked about this very thing in the past. Here's a great tool idea--a tool that automatically detects modifications (based on a date range the user specifies, or on a "modified since" date ) and creates an Update SQL file based on those modifications. This would be a tremendous help to those of us who have custom content but inadequate sql knowledge. . . . . Please? : )

[GeorgeS]

Here you go - might be what you're after


--Extract an NPC and ALL associated spawn tables from Database and create INSERT sql to ADD to another DB
http://wizardportal.dyndns.org/eqemu...PC_from_DB.zip

GeorgeS

[neiv2]

This looks promising. I have not yet tried this, but have taken a cursory read through it. Just two questions. I have customizations in almost all tables in the db, including:

all faction tables
all grid tables
all guild tables
all spawn tables
items
npc_type
object
zone
zone_points

1. Will this tool pick up the modifications in all of these?

2. Is this tool useful to create the file, then download and install the most recent version of the db, and then apply the customizations in the modification file on top of the new install?