Database

[nick1995]

Hi,

How can you look in to the database of your server?

Because i have a bank resource, and that used a database, but i want to look in to the database...

Second question,

Where are the users saved of your server?

Also i have a login script, and that used a database to...

[TAPL]

You can use program called 'sqlitebrowser' to view the database.

users? you means accounts? if so the account is saved at file 'internal.db' you can find it in (server\mods\deathmatch)

[nick1995]

That is nice, thank you!

Are there more programs like sqllitebrowser ?

[TAPL]

There an script i find it in community

i don't know if it works in MTA 1.3, i didn't test it.

https://community.multitheftauto.com/ind ... ils&id=495

[nick1995]

Can you edit the ACL file or database in game, or you have to restart the server finaly?

[TAPL]

Yes you can edit ACL in game without needed to restart the server

you can do that from admin panel or using ACL function, if you edit it manually using Notepad before you edit it, your server must be not running.

https://wiki.multitheftauto.com/wiki/Ser ... _functions

and database of course you can edit it in game using SQL function, if you edit it using program you may have to restart the resource that using it or if you editing internal.db file you i'll have to restart the server.

https://wiki.multitheftauto.com/wiki/Ser ... _functions

[nick1995]

Yes you can edit ACL in game without needed to restart the server

you can do that from admin panel or using ACL function, if you edit it manually using Notepad before you edit it, your server must be not running.

https://wiki.multitheftauto.com/wiki/Ser ... _functions

and database of course you can edit it in game using SQL function, if you edit it using program you may have to restart the resource that using it or if you editing internal.db file you i'll have to restart the server.

https://wiki.multitheftauto.com/wiki/Ser ... _functions

Okey thank you!

So if i understand, you can edit the internal.db but you have to restart the server?

I have also 2 questions:

I can't find it, but how are the passwords encrypt? (not MD5 ...)

And is there a alternatif for sqllitebrowser?

The resource doesn't work...

:3

[Cyandie]

To be honest I hate SQLlite storing data I think it's a lot better using the MySQL features SQL is easier to keep things in one place where you can edit them easy with Phpmyadmin.

[Al3grab]

sqllitebrowser is too easy , i don't think you can find easier , and the passwords are encrypted with MD5.

[Cyandie]

the war against SQLLite and MySQL

[nick1995]

To be honest I hate SQLlite storing data I think it's a lot better using the MySQL features SQL is easier to keep things in one place where you can edit them easy with Phpmyadmin.

Yeah i know, for my websites i use also Phpmyadmin...

But "sqllitebrowser" its not a fine programa

Hmm weird about the passwords

[Cyandie]

True the good thing about MySQL is that it can be used for websites and servers if you need any help with any MySQL things PM me.

[myonlake]

Why would you like to find out someone's password, that's retarded to even think about doing such thing.

MySQL is faster than SQLite and I see PhpMyAdmin easier to use than that browser. SQLite can be used for websites and servers too, Montiz.

[Cyandie]

I tried using SQLite with websites never got it working finally got MySQL working a lot easier and faster as you said well it's your choice Nick hope you make the right choice.

[nick1995]

Why would you like to find out someone's password, that's retarded to even think about doing such thing.

MySQL is faster than SQLite and I see PhpMyAdmin easier to use than that browser. SQLite can be used for websites and servers too, Montiz.

Because:

Somebody was lost his password, and we gave him a new password, but that password we have to encrypt to MD5...

You understand? ;3

I tried using SQLite with websites never got it working finally got MySQL working a lot easier and faster as you said well it's your choice Nick hope you make the right choice.

Thanks

Thanks everybody for help!