Adding Admin functionality???

Hello,

I would like to somehow add the ability to insert, update and delete information from my DB via the admin area. These are tables I created and store all of my content. I need to be able to add new companies and their information to these DB tables and update information that changes over time.

The actual queries are no big deal, but I need to know where or what to look for to get this to be another ’option’ or page in the backend - probably under a new menu item like ’Raw Company Data’ or something. I think this needs to be a component or a module but am not sure where to start.

Any help is greatly appreciated

Hi danpkraus,
maybe this thread will get you started
http://modxcms.com/forums/index.php/topic,44426.msg266285.html#msg266285

http://www.sottwell.com/create-module.html

These look like exactly what I need Looks like I have a bit of work to do.

Thanx for the info,
Daniel

I have everything installed but I noticed that in the threads the module looks for modx_ prefix. My DB tables use danielk_modx as that is teh way my server provider has it set up. Username_prefix.

But my tables within that DB that I wish to access have NO prefix. I am new to MySQL and prgramming in general so I may be missing something.

Can I change the prefix dbedit looks for? Like adding danielk_ before the $prefix varible in the php file? (line 210)

Like this


Thanx,
Daniel

not sure...i was just playing around with it. made those changes which lets me select whatever table is in my db:

http://modxcms.com/forums/index.php/topic,32720.msg216325.html#msg216325
http://modxcms.com/forums/index.php/topic,32720.msg216386.html#msg216386

i recommend posting questions in the dbedit thread

I made those changes as well, and dbedit still shows no tables. Tried re-installing, deleting, resetting everything I could think of and to no result. I am still working on it

Thanx,
Daniel

EDIT ########################

I was confused Everything is A OK

Now I get this error in the backedn:

"You don’t have permission to access /directorysexy/manager/index.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."
I changed the permisisons on the files but still no luck. Any ideas???

Thanx,
Daniel

The path is incorrect. It is trying to start from the root of your server’s file system (the leading / means that in a path) when what it needs is the root of your web space (which is what the leading / means in a URL).

My Modx installation is in this URL -- http://projects.danielkraus-appserver.com/directorysexy/

So, if I understand you, sottwell, I need to change the path (/directorysexy/manager/index.php) somewhere in the files of the dbedit? I looked throught the files and could not find a designation for a ’path’ to this particular file. Or am I looking in the wrong place?


Thanx,
Daniel