[Account]Sql

[[KoG]Rouche]

I recently added a script "userpanel" wich save account and stats in sql !!!

How can i acced this sql to edit account or remove it ?

[Castillo]

I recently added a script "userpanel" wich save account and stats in sql !!!

How can i acced this sql to edit account or remove it ?

you must get "sqliteberowser" program and open settings.db

[50p]

...

you must get "sqliteberowser" program and open settings.db

What settings.db are you talking about? Since 1.0.4 all accounts are saved in interval.db and all SQLite data (saved with SQL functions) is saved in registry.db.

[Castillo]

...

you must get "sqliteberowser" program and open settings.db

What settings.db are you talking about? Since 1.0.4 all accounts are saved in interval.db and all SQLite data (saved with SQL functions) is saved in registry.db.

sorry, i missunderstood the name

[[KoG]Rouche]

Thak for your answers

[[KoG]Rouche]

Ok i've open the registry.db ! I would like to renew all account with 0$ ans 0 points !! How can i do that ?

Thanks

[dzek (varez)]

sqlite browser can do that..

or do:

UPDATE table_name SET column_name=0

replace table_name with the name of your table

and column_name with the name of money column

[The_Ex]

Sqlitebrowser can execute SQL queries and you should use default values for fields.

[[KoG]Rouche]

Thaks for replies, i'll try it now

[[KoG]Rouche]

sqlite browser can do that..

or do:

UPDATE table_name SET column_name=0

replace table_name with the name of your table

and column_name with the name of money column

I don't understant what i have to do ... I never used sqlbroswer before

I would like that all account have 0$ and 0 points.

[[KoG]Rouche]

ok it's done I put the number in column to 0 (for the ponts)

But the money is not in de Sqlite ... don't know where is it.

How can i remove Admin rights to a member ?

[50p]

You can remove admin rights the same way you add them

[[KoG]Rouche]

In admin panel there is only the button "Give admin Rights"

I don't use acl. Acount aren't save into acl but in sqlite.

[50p]

Accounts are saved in database but ACL is not. You can't say "I don't use acl" because you do! You have to delete the player from acl.xml or I'm pretty sure there is a button "Revoke admin rights" or something like that...

[[KoG]Rouche]

Oh Sorry !

Accounts aren't saved in accounts.xml but in sqlite ... in sqlite i don't see the money (Only race win, race lost and points)

I've just see all account in acl (admins ...)

Thanks