SQL QUERY !!!

Use this forum for all questions related to the source code of OpenEMM

Moderator: moderator

by_smith
Posts: 12
Joined: Wed Mar 31, 2010 12:14 pm
Contact:

SQL QUERY !!!

Post by by_smith » Wed Apr 07, 2010 12:19 pm

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

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Wed Apr 07, 2010 10:06 pm

@1.
insert into admin_tbl ([columns],...) values ([values for columns],...);

@2.
go to the frontpage and try to login

by_smith
Posts: 12
Joined: Wed Mar 31, 2010 12:14 pm
Contact:

Post by by_smith » Thu Apr 08, 2010 1:49 am

thanks , but my question is :

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

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Thu Apr 08, 2010 7:39 am

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.

by_smith
Posts: 12
Joined: Wed Mar 31, 2010 12:14 pm
Contact:

Post by by_smith » Thu Apr 08, 2010 10:43 am

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.

pheelix
Posts: 101
Joined: Thu Nov 20, 2008 4:34 pm
Location: Dresden, Germany
Contact:

Post by pheelix » Thu Apr 08, 2010 11:39 am

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.

by_smith
Posts: 12
Joined: Wed Mar 31, 2010 12:14 pm
Contact:

Post by by_smith » Thu Apr 08, 2010 12:42 pm

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 !

Post Reply