1.12.x To 2.0.12 Converter For Characters And Items

[skC]

Directly taken from mangosforum

1.12.x To 2.0.12 Converter For Characters And Items, Keep existing data when migrating to 2.0.12

Hello all,

Since I was part of the team that did the 2.0.12 switch, I wrote a 1.12.x to 2.0.12 character converter with talent reset and money re-credited.

http://rapidshare.com/files/26676802....0.12_v1.2.rar
Version 1.2 with some more check to prevent errors from stopping the conversion and Bank slots corrected thanks to Greenseed and KweenOfWar

I did these tools 1 month and half ago, but it's now time to release them

This contains 3 files:

- Mangos1.12.xto2.0.12.py: this is the main converter that generate a file named GoTo2.0.12.sql.
Configure the tool and run it, then apply the resulting sql file. No modification done on database at runtime.
- Talents_112.py: This file is a dependency to Mangos1.12.xto2.0.12.py containing information to reset the talent and credit the money back to characters, do not run it.

- Reset Auras.py: Use this file after you migrated to 2.0.12 and checked that it was working fine to remove all aura from all characters. I saw there is often a lot of Auras on characters that comes from old ages and it's time with 2.0.12 release to clean them. This tool also generate a file named DeleteAuras.sql and does no modification to the database at runtime.

Requirements for Windows:
Python : http://www.python.org/ftp/python/2.4.3/python-2.4.3.msi
MySQLdb : http://prdownloads.sourceforge.net/m...4.exe?download

Backup you database before applying the sql files.

Have fun with 2.0.12

Neo2003

To Vladimir or TheLuda or other moderator, please move if necessary or tell me if I have to stop putting that here. This is dealing with db content but without data.

vladimir: I personally not see any problems with this thread. Tool work in generic way with DB content like some other tools that have threads at mangosproject.org

[skC]

still want to reset dbs?

[keparatizim]

yap admin gmna tanggapan na ????
kita tunggu tanggapan dari GM

[gaptekbet]

itu buat win kan?
yg dipake disini kan Linux, db nya tuh custom, make silver db/sdb
nah kalo mo pake caranya oom brarti itu db di back up dulu supaya jadi *.sql trus di copy kan ke windows, trus di convert make tools tsb abis di convert kalo ext nya bukan *.sql kudu di convert lagi jadi *.sql trus di copy kan lagi ke linuxnya trus di ubah lagi ke bentuk asal?
bener ga? waw panjang sekali jalan nya

[skC]

ya gimana lagi .. semua tergantung admin

[skC]

oya .. ini AMPM pake linux lupa T_T

[keparatizim]

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\user>ping 122.144.2.10

Pinging 122.144.2.10 with 32 bytes of data:

Request timed out.
Request timed out.
Request timed out.
Reply from 122.144.0.58: Destination host unreachable.

Ping statistics for 122.144.2.10:
Packets: Sent = 4, Received = 1, Lost = 3 (75% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\user>
server d mampus kan ada apakah ?

[PuttyTat]

dalam ekonomi..ada istilah " Kepuasan Pelanggan "
bisakah ampm begitu?

[gaptekbet]

huahuahua gpp oom, kayaknya juga ga ambil pusing GM na, cara paling gampang emang reset ahahaha sama kayak kalo windows lo ketularan virus, males dl anti virusnya yah format bleh, install ulang :P

[Wheel]

ya ga gitu juga lah om... AMPM juga ada banyak programmer top kok... pasti mereka pake jalan terbaik buat user

dan admin lah... jadi berharap aja orang2 jago nya pada turun tangan =p

[gaptekbet]

ya ga gitu juga lah om... AMPM juga ada banyak programmer top kok... pasti mereka pake jalan terbaik buat user

dan admin lah... jadi berharap aja orang2 jago nya pada turun tangan =p

Only one word ..... AMEN

[cyruss]

Amien bgt jg dah.. seenggak2nya char g kaga RIP.. cape boo..

[cadz.-]

ahaahaha..
kita juga mao bilang apa soal kepuasan pelanggan..
kita kan ga bayar..

[PuttyTat]

hic hic hic..iya juga si....ga bayar secara langsung, tapi klu kk ngerti siklusnya..pasti ketahuan juga..
klu sebenarnya kita bayar..hic hic hic

[indianicrasta]

Directly taken from mangosforum

dah di tes lom skc?? plg males soalnya pake python,, dan kenapa harus python...lol
klo dah di tes confirmnya pls....::rolling::