SQL files for rev 4329?

[MisterEMU]

Can someone tell me where to get the SQL updates for 4329 or gimme a link +Rep if you can!

[Kurosan]

this has all updates pass 40xx

http://www.mmowned.com/forums/emulat...ems-2-4-a.html

[MisterEMU]

I'm getting errors uploading them like duplicate tables and stuff like that... how can I fix it

[latruwski]

I'm getting errors uploading them like duplicate tables and stuff like that... how can I fix it

if you get errors skip that update... probably means it is applied already....

[MisterEMU]

yeah I skip it but still getting errors about decrypted password or something - I can't even log into the admin acc and it says 0 accounts has loaded in Logonserver.exe

[Kurosan]

delete the table for it and put a new one.

[latruwski]

delete the table for it and put a new one.

DONT DO THAT! it is an update you missed... let me find it^^

here you go:
http://mmoforge.org/svn/ascent/trunk/sql/logon_updates/
login: anonymous
no password

did you run all those updates?

edit: especially these 2:

alter table accounts add column encrypted_password VARCHAR(42) NOT NULL DEFAULT '' AFTER Password;

update accounts set encrypted_password = SHA(CONCAT(UPPER(login),":",UPPER(password)));

[MisterEMU]

DONT DO THAT! it is an update you missed... let me find it^^

here you go:
http://mmoforge.org/svn/ascent/trunk/sql/logon_updates/
login: anonymous
no password

did you run all those updates?

edit: especially these 2:

alter table accounts add column encrypted_password VARCHAR(42) NOT NULL DEFAULT '' AFTER Password;

update accounts set encrypted_password = SHA(CONCAT(UPPER(login),":",UPPER(password)));

that didn't work help me on here
http://www.mmowned.com/forums/emulat...tml#post744900