Need help with SVN (how to use it)

[Corpseshred]

Hello...

I'm new to SVN and i was wondering how to actually use it (with arcemu)
I already have TortoiseSVN but i dont know what to do now >.<
All im trying to do is keep my db updated with the current version lol
6):6):6):

[stoneharry]

You would create a new folder, right click on it, and press SVN checkout.

Type in the address of the SVN, and at the bottom where it says Head Revision, it means the latest version. You can checkout a different version by typing a differing version into the box. Then hit ok.

ArcEmu do not support databases, I would recommend using WhyDB which is 3rd party content for the database found here: WhyDB 2010

[Corpseshred]

You would create a new folder, right click on it, and press SVN checkout.

Type in the address of the SVN, and at the bottom where it says Head Revision, it means the latest version. You can checkout a different version by typing a differing version into the box. Then hit ok.

ArcEmu do not support databases, I would recommend using WhyDB which is 3rd party content for the database found here: WhyDB 2010

thanks for the response, but what do i do after i download all those files? btw i have ArcEmu OneClick which i believe already supports WhyDB... or are you saying that i need an SVN for both arcemu an whydb?

[stoneharry]

thanks for the response, but what do i do after i download all those files? btw i have ArcEmu OneClick which i believe already supports WhyDB... or are you saying that i need an SVN for both arcemu an whydb?

To be honest, I've only heard bad things about 'ArcEmu OneClick' (which is not the official ArcEmu people). It's not setup correctly.

But if you were compiling your own ArcEmu server, you checkout ArcEmu and WhyDB, WhyDB is for the database whereas ArcEmu is for the emulator. You can find guides on how to work these in the guides section.

[Corpseshred]

To be honest, I've only heard bad things about 'ArcEmu OneClick' (which is not the official ArcEmu people). It's not setup correctly.

But if you were compiling your own ArcEmu server, you checkout ArcEmu and WhyDB, WhyDB is for the database whereas ArcEmu is for the emulator. You can find guides on how to work these in the guides section.

o_O... Well I havent had many issues with OneClick (other than some config and db errors) but I was thinking about switching cores anyway (to something thats more of a funserver). I WAS thinking of Prydev but I think they have some hosting issues currently.
Jw, in your opinion, what is the best fun server repack available?
And do i also have to compile each SVN for every rev update?
Thx for all ur help and +Rep if "New User"s are able to (idk)

[stoneharry]

Imo, there are no good repacks. I don't use repacks either, so I don't know what the best one to date is.

If your using a repack, there is no need to use a SVN.

If you compile your own, each time a update comes out you update the SVN then recompile.

Also I believe you have a rep power of 0 till you get 10 posts and 5 rep, meaning you can't give any rep (it's just a comment).

[Corpseshred]

Oh lol well apparently im a "Lazy Leecher" now for some reason, but i tried to give u rep idk if it worked lmao
11 posts ftw

[Talrain]

I've updated my core from 3.3.2 to 3.3.5a and am now attempting to do the same for my WhyDB. I created a folder called WhyDB in my Arcemu folder and the SVN checkout went fine. Do I now use the import.bat file inside my new WhyDB folder?

I have quite a bit of custom content I am afraid of losing or overwriting so I'd like to make sure that using import.bat won't wipe out my content or if there is another way that it's supposed to be done that doesn't wipe it.

Thanks

[stoneharry]

I've updated my core from 3.3.2 to 3.3.5a and am now attempting to do the same for my WhyDB. I created a folder called WhyDB in my Arcemu folder and the SVN checkout went fine. Do I now use the import.bat file inside my new WhyDB folder?

I have quite a bit of custom content I am afraid of losing or overwriting so I'd like to make sure that using import.bat won't wipe out my content or if there is another way that it's supposed to be done that doesn't wipe it.

Thanks

Stop what your doing, or your going to end up wiping all your data!

In your uncompiled server folder, there is a folder called SQL. In there is a world folder. You need to apply all those updates (some might error but keep going) because those are the SQL updates for each revision. If you know what revision you were on originally then you can only apply the ones above that revision, otherwise your going to need to apply most of them to make sure you get them all. Do the same with the character SQL's for your character database.

If you want 3.3.5 data for in game, such as ICC or anything else that was affected, in whyDB there are changesets. You need to apply the changesets, as each one of these are what is added in each major revision.

I hope this makes sense to you.

[Talrain]

Awesome. Yeah everything makes sense and I'm almost done.

However, I'm running into two errors that I don't think I should be running into.
On changesets 95 and 96 (so far) I get this:

/* SQL Error: Table 'world.spelltargetconstraints' doesn't exist */

I've gone through every line of text in Changeset 96 and there is not a thing that mentions 'world.spelltargetconstraints' just spelltargetconstraints which is indeed a table. Judging by what the box at the bottom of HeidiSQL is telling me in regards to what it's doing before it errors, the problem is happening mid-way through so I'm losing parts of the updates. But I can't find anything referring to world.spelltargetconstraints! Argh!

Any suggestions?

And thanks for the help. Everything else is working just as you said it would. I probably would have given up on this server a long time ago if it wasn't for your help, Stoneharry.

EDIT: I worked around said errors via SQLYog instead of HeidiSQL. Error log however gave me a lot of "database was not selected" which concerns me. I hope this is somewhat normal and the errors that were made won't drastically affect performance.

EDIT: Speak of the devil.. My world database stops loading at

 18:16 N [Arcemu] Storage: 36435 entries loaded from table items

Seems something in the items table from the changelogs is causing an error or such because it freezes at that point.
Fortunately, I have all my custom content backed up separately and can "back track" my database and start clean if need be. Is this fixable or do I need to start it clean?
And regardless, is having so many errors on the changelogs normal?

[stoneharry]

SpellTargetConstraints is something that has been changed lots recently, ArcEmu provides the data in it's updates in the SQL folder so don't worry about that.

Database not selected means that you did not click on a database before executing the SQL, it doesn't know what it's executing into.

Anyway, if the changsets error you keep on going.. SQLyog will continue even though there are errors as you found out. Now that your content is mostly up to date, you need to get your core to load it... And the only way to do that is to apply the SQL updates in the world folder.

It is tedious, but you need to get the database perfectly correct so that the core can load the data. As your items table is playing up, you should be able to just look for item table updates and apply them.

[Talrain]

I had to do the thing last night where I "backtracked" the database back to 3.3.2. It seems I thought I was on a revision that I wasn't actually on and loaded things out of order.
I went back to 3.3.2 on the database then loaded the custom parts of my tables then went back up to 3.3.5 and followed your instructions with SQLYog and got it up and working. Everything is 110%. Now I have some new GM commands/syntax to get used to it seems.
Thanks for the help! And to anyone who reads this, SAVE all your custom SQLs! Better yet, keep all the IDs high up so it's easy to export them all together like I did. I would be royally screwed had I not done that.