2.4.1 - SectorSeven's blizzlike Repack Tutorial

[Handil]

I never saw this answered in this thread...

The repack I downloaded today has no .sql file for a logon databse. Where can I get one, or how can I make it if the repack is lacking the files?

[Herleybob]

The logon database is included in the world DB. Just run tool.bat (Set it up first) Then type 'W' and it will install the logon and world.

[bcar1ton]

Anybody know how to get mobs in the Sunwell area and instances, and put the new patch's items into the database? They won't spawn in game...

Also, how can I put this server online so my friends can connect? Ty!

[Handil]

The logon database is included in the world DB. Just run tool.bat (Set it up first) Then type 'W' and it will install the logon and world.

ok, so I just need to point all references to any database in my config files to point to world. gotcha.

[Herleybob]

No, the logon database and the world database are in eachother.

Bcar1ton - Im working on Magisters' Terrace. Almost no one has the full instance.

Im having trouble on the LUA scripts.

[bcar1ton]

oh ok ty, I was afraid I did the database wrong in some way....

Is the LUA what you do to put it online? If not has anybody put it up online so others can use it? And if so, lol, can you tell me how? thanks

[ᴋᴉᴎפּ ᴋᴋᴙᴏᴎ]

Hello Forums, I tested your repack v2. and a little disappointed, I haven't been anywhere but those vendors and trainers weren't working, they did in gadgetzan, but I didn't find anywhere else, so those who are wanting trainers will have to fix it yourself or wait for someone to post and updated script for it.

Anyway, like I said, I have finished T6 yesterday, and haven't had any problems, full stats and everything working.

Press here to download on rapidshare

Press here to download on megashares

Instructions are pretty simple; right click on 'items' under tables, select 'import'.
Now I made this using Excel 2007, so click in the circle next to 'Excel 2007 file (*.xlsx)' and press next, using the '...' button with import from, load where you extracted the download, it will be called 'Items.xlsx' and press 'select all' button and continue to next. Now, the first row is row 2, because the field names are row 1, and the last row is 52, so;

First row: 2
Last row: 52
Field name row:1

Continue with next again, skip this part and continue with next, make sure that all 'source fields' match up with thier counterpart 'target fields', you shouldn't have a problem, however let me know if you do, continue with next, now, the easiest way is to use 'Append' this will add all the information directly into your items table, it will not overwrite any existing information, nor will it remove any (which is what some of the other options can be allowed to do. Now this is an important step not to miss, or you items will get alot of garbled information in them, press on 'Advanced' and put a tick in the spot next to 'Use empty string as NULL', this will make sure that where I have not added anything, that it will not put anything there automatically. Press next for the last time and then press start to start the process. It should say;

Tables: 1
Processsed: 51
Errors: 0
Added: 51
Updated: 0
Deleted: 0
Time: x.xx seconds

Underneath in the window, the last line should read;

[Msg] [Imp] Finished - Successfully
--------------------------------------------------

Now you are all done, use the .additemset <setid> command to load your new T6 sets, or load each one individually using the .lookupitem <name> and .additem <itemid> commands. Have fun!

Note: Just to add, you should execute this in both your 'logon' and 'world' databases.

[mastertheif4]

No, the logon database and the world database are in eachother.

Bcar1ton - Im working on Magisters' Terrace. Almost no one has the full instance.

Im having trouble on the LUA scripts.

Any news on the Vendors and Trainers? Have they been fixed yet?

[hellswrath]

Any way you can send me the files so i can fix things myself? Maybe help you fix some things i find as well.

Nice guid by the way. +Rep

[apollo2006]

Ok on the 8 piece t6 file the .xslx its telling me Cannot open file. Why would that be happening when i am doing exactly as he said.

[ᴋᴉᴎפּ ᴋᴋᴙᴏᴎ]

Any news on the Vendors and Trainers? Have they been fixed yet?

Vendors are working, in every town and city i've been in using the default repack, however the only trainers which are working are professions trainers, eg. Mining, Blacksmithing, Jewelcrafting etc. Mine is far from complete, as I don't know what is actually wrong, I just made a new table, and got 1 working for now, so it's should be better to wait for the repack people to tell us what is wrong and how to fix it.

Ok on the 8 piece t6 file the .xslx its telling me Cannot open file

I'll run this into a new empty database, and make an SQL for it, that should let you simply run the batch file into you items table, will update the post when I do. I think the problem is, but it shouldn't make any difference, is you don't have office installed.

Here is the SQL for the T6 items,

Press here to download on rapidshare

Press here to download on megashares

Instructions are just the same as how you done your database, just right click on 'logon' (and repeat the process for 'world'), and select 'execute batch file'. Use the '...' button next to file, and browse to the 't6-updated-items.sql', and press start, again, you should get what I said before in my previous post;

Tables: 1
Processsed: 51
Errors: 0
Added: 51
Updated: 0
Deleted: 0
Time: x.xx seconds

Underneath in the window, the last line should read;

[Msg] [Imp] Finished - Successfully
--------------------------------------------------

There shouldn't be any problems doing it this way, but if you encounter any i'll try and work out whats wrong.

Note: I just noticed, I had updated my displayid's and now they won't show in-game, this just means that when you equip parts 6-8 of a T6 set, you won't see the icons on your characters display page. I have used the correct id's but i'm not sure what going on so i'll need to have another look at it.

[apollo2006]

Ok I have been working on integrating Jargs and Sector Seven repacks to make one with working vendors, trainers and containing the new 2.4 items I am waiting on Loto Sqaures guy to post a .sql version of his t6 items and was wondering if anyone could help me get the new island info x-frered from one db to another.

[project anthrax]

wait so do i extract the db in the repack to my world db in navicat cause when i did i got 2 errors but continued any way

[ᴋᴉᴎפּ ᴋᴋᴙᴏᴎ]

was wondering if anyone could help me get the new island info x-frered from one db to another.

I believe all you should need to do is add a racall script for the new instance/island, there was one posted earlier in this thread, I haven' t tested it so can't say it's works, but it should. If you want to transfer information from one database to the other, just extract what parts you need, and run the script into the other, i'm presuming this will cause alot of errors however, an easier way would be to remove the current table, eg. if you are trying to update trainers, remove the trainers tables from your current, extract them from the working one, and import them into the current. That way you shouldn't encounter errors for the database saying that the tables already exist and it may not update properly, best to back everything up and just test out different things.

I also just noted, how wrong the character scaling is, using an undead, I walk into Thunder Bluff and i'm not even hip-high against a Tauren, however in undercity I am slightly taller than most NPC's except the guards before the lift into the city itself, they are almost triple my size, it seems compared to other races, Trolls are around 1.5x the size as well as humans are 1.5x the size of me. Any idea as to why the scaling seems to be very wrong?

[Herleybob]

Yes the code works. I posted it, and have tested it.