Page 1 of 1

SQL QUERY !!!

Posted: Wed Apr 07, 2010 12:19 pm
by by_smith
Hello,

I ask whether you can help me where to find the 2 following query:

1) the query sql which makes it possible to add an account

2) the query sql which makes it possible to test the login and the password

Thanks

Posted: Wed Apr 07, 2010 10:06 pm
by pheelix
@1.
insert into admin_tbl ([columns],...) values ([values for columns],...);

@2.
go to the frontpage and try to login

Posted: Thu Apr 08, 2010 1:49 am
by by_smith
thanks , but my question is :

where i can find this query inside the folder openemm ??

Posted: Thu Apr 08, 2010 7:39 am
by pheelix
what do you mean with "inside the folder openemm" ?

maybe you could find them in the /usr/share/doc/OpenEMM folder, if you created it.

Posted: Thu Apr 08, 2010 10:43 am
by by_smith
hye, I well will clarify my question:

OpenEMM uses a whole of query SQL for ask and modify the database: openemm, among these query SQL there is the query which makes it possible to the administrtator to add a new account, which I seek it is the file containing this query so that I can modify it according to my needs.

Posted: Thu Apr 08, 2010 11:39 am
by pheelix
i'm not sure whether there is such a file.

you only need basic mysql-knowledge and openemm-db-structure-knowledge to accomplish what you want.

or it could be easier for you to use a tool like phpmyadmin to add new users. but you have to proof that the passwords for new users are saved as hashs, not as plain text.

Posted: Thu Apr 08, 2010 12:42 pm
by by_smith
Yes I inderstund, but I want to only know there or one will be able to find these query among these files?

Because, inevitably there must be a file containing the query for the handling of the database !