MTA + MySQL

[Feche1320]

Now, to use MySQL, do I have to use a plugin, or dbConnect, dbExec, dbQuery, etc is the same?

Thanks.

[Castillo]

As far as I know, the built-on MySQL functions are better than Ryden's module.

[Cadu12]

Agree with Solidsnake14. Im still moving get/setAccountData to MySQL, I have made my own site with login, statistics, and profile

[Feche1320]

Agree with Solidsnake14. Im still moving get/setAccountData to MySQL, I have made my own site with login, statistics, and profile

Currently I have SQLite, is it worth to move it to MySQL?

[Castillo]

I would say it is, as MySQL is able to connect with your website, live statistics and so on.

[Cadu12]

SQLite uses get/setAccountData, you can move to MySQL, but still harder.

Edit: My server is still using get/setAccountData and im working on it moving to MySQL

[Castillo]

SQLite doesn't use get/setAccountData? that's the MTA account system, which is now SQLite.

[Feche1320]

SQLite uses get/setAccountData, you can move to MySQL, but still harder.

Edit: My server is still using get/setAccountData and im working on it moving to MySQL

It won't be so hard, it's almost the same as SQLite, but just using queries.

[Cadu12]

@Solidsnake14:

http://code.google.com/codesearch#KdIew ... .cpp&l=786

http://code.google.com/codesearch#KdIew ... .cpp&l=820

@Feche1320 If you are lua skilled, it be easy for you.

[Castillo]

That's account data, there's also the normal SQLite functions:

executeSQLCreateTable 
executeSQLDelete 
executeSQLDropTable 
executeSQLInsert 
executeSQLQuery 
executeSQLSelect 
executeSQLUpdate