[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

[badot]

I cant run my private server because all the Scripts in scripts_bin keep saying version mismatch! its on every thing. So when it goes to Luascripting.dll it says Version Mismatch! and than it just skips the LUA scripts in scripts folder.
Thanks in advance.

first make a backup of script_bin folder and script folder, then delete it, and used the script_bin and script folders from last revision. because sometimes updated lua makes more error than the previous.

[keazain]

hi all all cores are updated and fun/repack X22 is released....

all svn is updated and all works, remember to look at my treat below x22 content how you make shure that your guildhouse is working

[keeevin92]

So know i got repack x18 and only want to update the new things in repack x22 How do i do? Because I want to save my accounts , chars and so on. Tell plz every step iam really bad how to do it . Like :
1. move the x22 to C: and so on :P
2. ...

is it on tools>SQL? And how do i do the update after that?

[johnstone]

ha whar whays the mmo at for thos 2 days i looked for it and i found this skared me what happind 2 mmowned.com - Google Search Web Results 1 - 1 of 1 for what happind 2 mmowned.com. (0.45 seconds)
Search ResultsNEED HELP TO GET ACC BACK ULL GET SOME CASH FroM IT ALSO ...Well Here is what happind : i trusted a guy who i played with on same server for 2 years letted him log on then he scammed me i dont have any info.
http://www.mmowned.com/forums/wow-sc...cash-also.html - 90k - Cached - Similar pages


thats skared me bad lol thot the home page got stollan from some guy that changed the passworfds and logon and than tock it off line ..glad 2 see u back

[Illidan_000]

Please upgrade your Fun repack (X22) to 3.0.8a because I tried to modify in the logon.conf and when I make the character it's completely naked so I guess that's the problem.

[arnamide]

Can you please fix the AUBDB Download?

[Fugunsk]

When will be ready LUNAREMU?

[ogchaos]

I have a suggestion

https://ascentscripts.svn.sourceforg.../CityConquest/

Its for ascent, But im sure theres a way to change it to arcemu

[keazain]

hi servers IS already 3.0.8 thats the only one you can get from my treat im fixing some small db updates for nect update...

lunaremu is ready when the team have added some missing .cpp and .h for compilings

[arnamide]

hi servers IS already 3.0.8 thats the only one you can get from my treat im fixing some small db updates for nect update...

lunaremu is ready when the team have added some missing .cpp and .h for compilings

Can u update AUDB DB so it works ? Please, would be awesome

[johnstone]

i have this small problom nothing big it just keeps saying this what should i do re do the db's?

[keeevin92]

Got some problems that i need fixed:
1.How to change in the repack x22 so the heartstone is as usually and not a teleporter.
2. How to change the db so its named world instead of blizz or fun
3. How do you fix spells on your own?
4. There is some double spawns on some guys like in booty bay and that increase lagg any way to fix that without delete each guy.

Also the teleporters can i remove some teleports like the sky city?

[mike1994r]

i have a problem because in the horde mall i cannot click on any trainers or sellers,
and also it wont let me change level limit past level 80 and it ownt start at the level i want it to start at, oo and i can attack a monster but i cant hit any damage on them idk if this is happening to u or any1 else so how do i fix this?

[dragonz]

Got some problems that i need fixed:
1.How to change in the repack x22 so the heartstone is as usually and not a teleporter.
2. How to change the db so its named world instead of blizz or fun
3. How do you fix spells on your own?
4. There is some double spawns on some guys like in booty bay and that increase lagg any way to fix that without delete each guy.

Also the teleporters can i remove some teleports like the sky city?

2. How to change the db so its named world instead of blizz or fun
OPen Navicat, select your connection to mysql, make a new database and call it world. After that select the new world database adn execute batch file (select the SQL you wanna use, ether fun or blizz or repack, thats comes with the RAR file you downloaded) After you need to change you config files ins the arcemu folder so they direct to your new database!

<WorldDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "logon" Port = "3306" Type = "1">

P.S use your info ...

3. How do you fix spells on your own?

You need to give us more info... But here goes anything! Let's say you wanna fix Vanish spell from Org rogue trainner! 1st- find out the npc entry id! Eter go to wowhead.com and search the npc ! Click on it and check the adresse bar! Osborne the Night Man Osborne the Night Man - NPC - World of Warcraft. So this means the NPS entry is 918! (or use the G'H addon provided in the repack. Find out the vanish spell id! Use wowhead.com Vanish http://www.wowhead.com/?spell=1856 , so this means Vanish spell id is 1856.

Open up NAvicat! Select your database you wanna repair , and open up trainer_spell !


You will need to get to The Entry 918, so use the botom arrows!
and check for the spell id you wanna fix!

The way i fixed it is by removing the required spell! and put 0 instead! P.S now do it with all the rogue trainner :rofl:

Or wait for the people from database to fix it since youll ahve to redo it everytime you update the database till its not fixed!

Hope this helped a little! Note some people might have better way to fix this!

:worthless:

And dont forget the +Rep

[badot]

So know i got repack x18 and only want to update the new things in repack x22 How do i do? Because I want to save my accounts , chars and so on. Tell plz every step iam really bad how to do it . Like :
1. move the x22 to C: and so on :P
2. ...

is it on tools>SQL? And how do i do the update after that?

i just updated my server from rev. 2075 to the latest and i think it work thanks to Movious,
if you are using SQLyog i can guide you. Open your SQLyog then click (+)logon database, right click 'accounts' then click Export Database As SQL Statement or Ctrl+Alt+E save it in a folder, do the same to the other sub folder under logon database

accounts* (* it's a must)
character_achievement*
character_achievement_progress*
characters*
corpses (if there is any)
groups (if there is any)
guild_data (if there is any)
guild_rank (if there is any)
guilds (if there is any)
instances
mailbox
playercooldowns*
playeritems*
playerpets*
playerpetspell*
player_summon*
playersummonspell*
questlog*
social_friend
tutorials (if there is any)

take note only the "DATA"
using CONTEXT Program open your save data and delete the "createtable" stuff and leave the insert into blah blah blah.

you will edit the accounts file so you dont have an error when you import the file to your SQLyog

in the older rev. there is no sessionkey and vip column so you have to add it manually (taka a deep look)

(1,'admin','admin','','3','0','2009-02-09 07:19:17','192.168.0.1','',24,'enUS',0,NULL); this is from the old rev.

(1,'admin','admin','','','3','0','0','2009-02-09 07:19:17','192.168.0.1','',24,'enUS',0,NULL); this is the edited part

just put ( '', ) after 'password' column

and ( '0', ) after 'gm' column

after changing all of the file under accounts, then download the latest Rev.
again open SQL, import the the logon and the world database in your SQLyog, then import your edited accounts and the others one by one. Just right click 'logon' then click Import Batch File choose your saved file, then execute.

just follow what you did on your last server the same procedure. this guide is only to update you old rev
(without sessionkey and gm column) to new rev. (with sessionkey and gm column) on the world database nothing change.

hope you will not have error when you execute the file

it will also work on the naked characters just make sure you backup first your work before start dumping data.