Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → [EN] Tech Support → [Solved] convert users from plain to mysql?

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 11

1

Topic: [Solved] convert users from plain to mysql?

i have pvpgn 1.99 SVN with database plain
i wanna make database in mysql ?
how to make like this ?

don't say use pvpgn from harpy war...
because i already have pvpgn 1.99 SVN, and i have compiled myself

what settings for pvpgn can connect to database ?



sorry for my bad english

2

Re: [Solved] convert users from plain to mysql?

There is a Perl script to convert plain users to mysql dump.

Usage example:

perl.exe plain2sql.pl "c:\pvpgn\var\users" > users.sql

(then you will get a file users.sql that can be executed into mysql database)

Do not ask for support in PM.

3

Re: [Solved] convert users from plain to mysql?

could you show me the tutorial ?
i have not understand yet

thx

4

Re: [Solved] convert users from plain to mysql?

1) If you have never used perl then download and install ActivePerl for Windows www.activestate.com/activeperl/downloads

2) Run command starting with "perl.exe ..." from Start > Run > cmd or create .bat file.

3) Search in Google "how to import mysql dump into database".

Do not ask for support in PM.

5

Re: [Solved] convert users from plain to mysql?

could you make a video tutorial please ?

i still don't understand, haha

Thank you ya~

6

Re: [Solved] convert users from plain to mysql?

Mate, try to do something first and then ask specific questions (after googling it).

But this is a forum for admins of PvPGN. It means that you have the basic skills of management in OS that you use for it, including the ability to work with command line and all needed programs.

Do not ask for support in PM.

7

Re: [Solved] convert users from plain to mysql?

when i am trying to import users.sql
it says : #1146 - Table 'pvpgn.bnet' doesn't exist

what should i do ?
i upload users.sql via phpmyadmin
right ?

how to make table pvpgn.bnet ?

8

Re: [Solved] convert users from plain to mysql?

PvPGN will create all tables on first start.
pvpgn.bnet = [database name].[table name]

If the tables named with prefix just replace "bnet" to your table name (like "pvpgn_bnet") in users.sql.

Do not ask for support in PM.

9

Re: [Solved] convert users from plain to mysql?

DONE !!

this thread can be closed..

thank you very much harpywar

10

Re: [Solved] convert users from plain to mysql?

Jimmy_Aquarius wrote:

DONE !!

this thread can be closed..

thank you very much harpywar

Can you post how to make a change?

I would like to perform too!

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

11

Re: [Solved] convert users from plain to mysql?

Done! I also made the change.

Note: I had to make some modifications to the syntax in order to import the dump, for exemple removing the 'single quotes' in tables. I'll post a tutorial soon.

Diablo 2 Online

Itens - Armory - Market - Clans - Builds - Chat

Posts: 11

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 0 guests, 0 registered users

forums.pvpgn.pro → [EN] Tech Support → [Solved] convert users from plain to mysql?