| Index
» Projects
» phpMyEdit
» Forum
» Hack for PME (user management,tab browsing,fulltext search) |
 |
madie
Joined: 04 Mar 2008
Posts: 5
Posted: 2008-03-04 14:12
Back to top
Reply with quote
|
I have wrote a little hack for my PME project.
The version is very alpha. May be that someone can use it. Cooperation in the development is requested.
An example can be found at: http://diedernet.com/pmeproject/ (user and pw: "pme")
The source code can be found at: http://diedernet.com/pmeproject/source.zip
The hack extended PME to
- user and rights management: allows the assignment of writing and/or reading rights, as well as filters for each user and each table
- tabbed browsing with several tables: allows editing multiple tables using a layout which resembles filecards
- fulltext search over several tables: allows fulltext searches of all tables with appropriate rights
- show/hide helptext for fields with css/js, hide elements in printing layout with css
Currently, the Hack in the mysql database requires tables following:
- PME_tables - table structure of the database with texts for tabs and description of the tables
- PME_users - user administration with detailed information on the users
- PME_userfunctions - functions for the user rights management for use in various tables (not required)
- PME_rights - User and table rights management
- PME_history - cache of variables for the tabbed browsing
(Details can taken from file pme.sql in the source)
Other requirements:
- User management requires the acceptance of cookies.
- Tables for PME are so involved that in the directory tables a file with the file name "tablename.inc" is stored in which only the PME settings for $opts contained, an example can be found in tables/files_pme.inc in the source.
- The fulltext search requires the creation of a fulltext index in mysql for all fields of the type "varchar, char or text".
|
madie
Joined: 04 Mar 2008
Posts: 5
Posted: 2008-03-11 21:21
Back to top
Reply with quote
|
I have rewritten the hack into an extension class. May be it is easier to use.
The tables for PME now you have to set as $prefs['tables']['tablename']['opts'].
For the other settings have a look in the index.php file in the source.
|
madie
Joined: 04 Mar 2008
Posts: 5
Posted: 2008-03-13 17:11
Back to top
Reply with quote
|
I have revised and simplified the extension again: the table history is not longer necessary, now the session area is used as a cache.
|
madie
Joined: 04 Mar 2008
Posts: 5
Posted: 2008-03-17 13:01
Back to top
Reply with quote
|
I have further revised the extension, the table PME_tables is no longer needed, version is now 0.8.8.
|
colinsp
Joined: 13 May 2008
Posts: 1
Posted: 2008-05-13 15:35
Back to top
Reply with quote
|
Hi, Thanks for posting this. It will probably do what I need BUT I can't get it to run against my database. I have edited the database section around line 75 still without success. I am a noob at PHP and struggling here a bit. Do you have any instructions on how to use this with my own db?
TIA
|
madie
Joined: 04 Mar 2008
Posts: 5
Posted: 2008-05-14 11:42
Back to top
Reply with quote
|
| colinsp wrote: |
| I have edited the database section around line 75 still without success. |
Hi,
What is the error message?
Do you have the class installed like the source (same directories)? And do you have the tables PME_rights und PME_users in the database with at least one user (see /pmeProject/doc/SQL with examples)?
Greetings
Madie
|
paulalt
Joined: 16 Jun 2008
Posts: 9
Posted: 2008-07-06 05:16
Back to top
Reply with quote
|
Would you mind posting the username and password. The ones you have posted don't let me log in.
Thanks,
|
paulalt
Joined: 16 Jun 2008
Posts: 9
Posted: 2008-07-06 05:19
Back to top
Reply with quote
|
I got it right this time.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
