[HELP]Question

Hanibal · 01/16/2010, 00:38

Is there any way of setting the 5165 source to a MySQL database and if so how?

.Ryu · 01/16/2010, 00:44

Quote:

Originally Posted by Hanibal

Is there any way of setting the 5165 source to a MySQL database and if so how?

#Reported wrong section
#Request Move

And you gotta take the connections out of a LOTF source working on MySql and put it in the 5165

spare2 · 01/16/2010, 01:21

You would need to download

. Which basically is the MySql dll.
Here's a TUT on how to use connect to MYSQL using C#.

Before you start coding, you should install MYSQL. (

)
Then you can either create tables manually or code something that would create tables for you. After creating tables, you can insert in values from your old database in the new MYSQL database. After your MYSQL DB is ready, redirect your server to read from that DB instead of reading flatfiles.

Sorry for not being specific, but it is a long process.

Korvacs · 01/16/2010, 01:39

Quote:

Originally Posted by .Ryu

#Reported wrong section
#Request Move

And you gotta take the connections out of a LOTF source working on MySql and put it in the 5165

Moved.

.Ryu · 01/16/2010, 01:40

Quote:

Originally Posted by spare2

You would need to download . Which basically is the MySql dll.
Here's a TUT on how to use connect to MYSQL using C#.

Before you start coding, you should install MYSQL. ()
Then you can either create tables manually or code something that would create tables for you. After creating tables, you can insert in values from your old database in the new MYSQL database. After your MYSQL DB is ready, redirect your server to read from that DB instead of reading flatfiles.

Sorry for not being specific, but it is a long process.

He still needs the MySql connections..

Quote:

Originally Posted by Korvacs

Moved.

Thanks Korvacs

~~PeTe Ninja~~ · 01/16/2010, 01:41

Quote:

Originally Posted by .Ryu

#Reported wrong section
#Request Move

And you gotta take the connections out of a LOTF source working on MySql and put it in the 5165

no you don't..

.Ryu · 01/16/2010, 01:44

Quote:

Originally Posted by PeTe Ninja

no you don't..

But dont you need the MySql connection in order for it to work?

spare2 · 01/16/2010, 01:46

Quote:

Originally Posted by .Ryu

He still needs the MySql connections..

It's inside the TUT?

.Ryu · 01/16/2010, 01:48

Quote:

Originally Posted by spare2

It's inside the TUT?

Idk you put it there lol you should know...?

spare2 · 01/16/2010, 01:50

Quote:

Originally Posted by .Ryu

Idk you put it there lol you should know...?

That was a rhetorical question.

~~PeTe Ninja~~ · 01/16/2010, 01:59

Quote:

Originally Posted by .Ryu

But dont you need the MySql connection in order for it to work?

yes but you dont need to copy...

I mean you would need the Mysql.data DLL or you could actually find one on google. but other than that..

.Ryu · 01/16/2010, 02:19

Quote:

Originally Posted by PeTe Ninja

yes but you dont need to copy...

I mean you would need the Mysql.data DLL or you could actually find one on google. but other than that..

This is very interesting pete thank you

spare2 · 01/16/2010, 02:23

MYSQL .Net Connector(link in the first page) is the driver which contains the DLL.

.Ryu · 01/16/2010, 02:36

Quote:

Originally Posted by spare2

MYSQL .Net Connector(link in the first page) is the driver which contains the DLL.

Mhm i see thanks

Hanibal · 01/16/2010, 13:23

I thank you all for your very helpful responses, it looks like the guy who wrote this source already started to make it run this way but for whatever reason went another way.

I'm not that pro to actually figure out how or where to start from where he left off so if I can figure out a way to implement so the server picks up and logs a persons i.p. so they can at least be banned that way I'm all set, really this isn't a bad source to build from being a lot of the things players want are already in there, it's just that right now it's too easy to dupe silver, cps and items so I was looking at another way to control this when there is probably an easier solution by just tracking/logging i.p. numbers.

I don't know if any of you know where I could find a code or where I'd even put this in the 5165 source so ya this may fix some of the issues i was having.

I really want to go another way with this source and client and make a hybrid game that is totally different in respect to classes, skills and items and like I said I'm not near pro enough to code a source from scratch and this one has everything I need to start from anyway and pretty much seems 100% customizable.

So ya if any of you know how to add a i.p. tracking system let me know.

Thanks.