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 !