Player's nicks database

['LinKin]

Hello,

I've seen some scripts that stores a player's nicks based on their serial.

I've seen they use something with SQL. But I don't have much experience on this.

Also, I took a look at this "epic" resource:

https://community.multitheftauto.com/in ... ls&id=2764

But found out it doesn't work..

I want to make my own one.

Also, if it is possible to 'backup' this information.. So that if I download the resource from the server, and upload it to another server, the information from the 1st server is shown in the 2nd one.

[PaiN^]

Well to make a resource like that, you'll require more knowledge in SQLite data base saving method.

And I don't think it's possible to move the data stored by SQLite from one server to another just by moving the resource folder .

[TAPL]

This resource use MySQL and the server that host the MySQL database is dead, that's why it not work anymore.

[Sasu]

@PaiN^, if you use executeSQLQuery then you can move the file "internal.db", where all the data are stored with the funcion that I said.

[Baseplate]

Wrong, it stores the data at registry.db.

You can use account data, MySQL or SQLite.

I'll use SQLite for this as it isn't real big data.

[Sasu]

Oh, yes. A little error of typing e.e

['LinKin]

Can someone provide an example?

[PaiN^]

@ Sasuke : I know that, read what i've said .

I don't think it's possible to move the data stored by SQLite from one server to another just by moving the resource folder .

@ |GMC|LinKin : An example of what ?

Use SQLite database saving function ( executeSQLQuery ).

[Grafu]

Use a serverside xml file. Works perfectly for me

['LinKin]

Yeah, I was thinking about using .xml

I think it's easier, however, I need to begin from zero, learn how to store this data in a .xml file etc..

Also, I think that by using .xml I will be able to move the data from a server to another.