Date: 01/19/06 (PHP Community)    Keywords: cms, mysql, database, sql

I am writing an open source cms called Rade (intended for release), and want to store images in the MySQL database; MediaWiki's upload system sounds suspiciously insecure, and makes storing metadata harder. However, I have read that blobs in SQL databases decrease their performance. Should I store the images in another table? Another database?

Source: http://community.livejournal.com/php/398428.html

Date: 01/09/06 (PHP Community)    Keywords: cms, php, html, database, security, web

Hey all,

I know there's been a couple posts about this recently, so if I'm asking redundant questions, sorry.

A friend of mine has come up with a pretty novel idea for a MySpace-ish site, but for a specific niche market (kind of like those CatSpace and DogSpaces that exist) - users will have profiles, photos, a blog, message boards, send friend requests, yadda yadda yadda, you've seen it all before. I'm going to be developing the initial setup myself (since we have no money), and this is a somewhat long term project that I'll be picking at casually for a little while.

Right now I'm trying to figure out if I should give this a go coding from scratch, or use an existing CMS type solution (like Mambo, Joomla, Drupal, etc). I'd really like to code it myself, as I think it could be a fun project to work on. I'm a pretty solid PHP programmer, but as I have a feeling that this idea could jump in popularity pretty quick, I really want to make sure I keep this thing as efficient as possible for a large user base. For instance, I don't want to go making another MySpace which I think runs horribly as a web app compared to even LiveJournal.

Currently I use PEAR's DB_DataObject or my database interactions and I've just gotten into Smarty for templating, though I'm sure I'm not using either to their fullest potential. I saw mention of a couple of development environments and frameworks in someone's recent post looking for a visual studio-esque PHP environment - http://www.livejournal.com/community/php/388602.html but I've never used any of these.

I'm not really concerned here with using a "rapid development" framework - I don't mind coding, I like it - but what I'm really concerned with is stability, efficiency and security - I know of course that these also rely heavily on how well I code, and using a good coding environment or framework won't do the coding for me, but there have to be some tools/frameworks/etc out there that pros are using that I just haven't moved onto yet, and I wanted to see what you guys (and gals) are using on some of your bigger projects.


- I know this comes up a bunch, but does anyone else think would it be handy at all for us as a community to maybe organize some of the more useful threads and frequently asked (and answered) questions in the php community at a separate location? Doing just a search on the community doesn't necessarily give you anything about the quality of the responses, and it may even be nice to be able to 'browse' solutions/posts by categories or something; maybe we could have some sort of quality ranking on posts, or some way to identify posts that contain questions that get asked all the time. I don't think this would be too tricky to put together, and I'd be willing to work on it, but I don't know if anyone would even use it?

Source: http://community.livejournal.com/php/392457.html

Date: 01/06/06 (Web Development)    Keywords: cms, hosting

bear with me... this is not my realm of expertise.

i've been asked to look into putting a mailing list on a site. i assume there is some kind of cookie cutter way to do this, but i don't know what that is... i'd like to be able to A) have some/complete control over how it looks and b)not have to pay anyone to have a mailing list.

also...

i was told by a friend that i could use modify moveable type stuff to create what is essentially a CMS, but i don't know how to find out if my hosting company (hostony) supports this. actually, i know very little about moveable type in general.

anyone who is feeling very kind who could explain any of this to me would be my best friend forever. thanks.

Source: http://community.livejournal.com/webdev/283679.html

Date: 12/18/05 (MySQL Communtiy)    Keywords: cms, php, sql

How do you make your site searches? I am constructing (yet another) CMS of late and am once again at the issue of searching. I am trying to build an SQL statement that will do a full text search of looking in several fields and then ranks each return so they can then be ordered by that before looping them out in php.

How do other people do this? have you found a particular way of doing this that you find works well. My current solution isn’t the most efficient method out there.

Thanks

X-posted to php

Source: http://community.livejournal.com/mysql/78074.html

Date: 01/25/06 (PHP Community)    Keywords: cms, php, mysql, asp, sql, web

Following up from my last post, are there any good CMSes out there for a really small site?

I mostly use my personal site as a support resource for online roleplaying games that I run, but I'm tired of needing to upload to the site by FTP whenever I want to change one little thing on a page. At the same time, I like have a visual basis for character sheets and so on... (http://www.patchwolf.com/phoenixcrusade/terpsichore.php for an example). I'd also like to give my players the chance to add stuff directly to the site -- kind of like a wiki.

Of particular concern are the character sheets, where I'd like to still be able to change one detail (like the current form aspect on the example sheet -- currently controlled by an in-page variable), which then affects several other aspects (strength, stamina, health, etc....)

A good mate of mine uses Qwikiwiki (http://www.qwikiwiki.com), which uses a flat-file system -- but if I want to have a hope of maintaining a visual basis on any part of the site, Qwikiwiki's not going to cut it. While I have PHP and MySQL on my web host, I don't actually
run the server myself, so that's also something to take into consideration.

Any ideas?

Source: http://community.livejournal.com/php/401978.html

Date: 01/25/06 (PHP Community)    Keywords: cms

Has anyone used the TYPO3 (http://typo3.com) CMS?

I'm considering something like this for my site, and I wondered if anyone had some experience with it or some stories to share that would give me some more info?

Source: http://community.livejournal.com/php/401835.html

Date: 01/31/06 (PHP Community)    Keywords: cms, php

i've inherieted a project that isn't well-documented, and am having trouble figuring out what it's doing. the user will click through something like http://www.cms.net/manage.php?reset_id=900. manage.php makes no mention of reset_id, but there are several include files. those include files include other files, and all of them are big and messy. i need to change what's happening when the reset_id flag is sent, but i can't find where that's being handled. is there any way to trace this so i can figure out what file is actually doing the work?

Source: http://community.livejournal.com/php/404591.html

Date: 02/16/06 (Microsoft Windows)    Keywords: cms, php, software, html, java, virus, microsoft, google, ebay

Yesterday, my roomy's 'puter kept freezing up. AVG found 2 viruses but it closed out and she didn't know what they were or where they went.

I attempted to run Ad-Aware but everytime it starts running, the computer restarts. So, I deleted all of the programs in the Control Panel that she didn't need, deleted the cookies, deleted all of the internet files she didn't need, restarted, and the computer seemed to work fine.

However, today she said "Win32reg.exe" keeps popping up a screen. I had already installed Google's Toolbar and so that is the same pop up blocker she uses. I ran Hijack This and got this:



Logfile of HijackThis v1.99.1
Scan saved at 9:22:51 AM, on 2/16/2006
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\system32\LEXBCES.EXE
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\system32\LEXPPS.EXE
C:\PROGRA~1\Grisoft\AVGFRE~1\avgcc.exe
C:\PROGRA~1\Grisoft\AVGFRE~1\avgemc.exe
C:\Program Files\AIM\aim.exe
C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe
C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe
C:\Program Files\Netscape Internet Service\ncupdatesvc.exe
C:\WINDOWS\system32\nvsvc32.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\DOCUME~1\Owner\LOCALS~1\Temp\Temporary Directory 1 for hijackthis[1].zip\HijackThis.exe

R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = http://portal.jellyneo.net/index.php
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.emachines.com
O2 - BHO: AcroIEHlprObj Class - {06849E9F-C8D7-4D59-B87D-784B7D6BE0B3} - C:\Program Files\Adobe\Acrobat 7.0\ActiveX\AcroIEHelper.dll
O2 - BHO: PBlockHelper Class - {4115122B-85FF-4DD3-9515-F075BEDE5EB5} - C:\PROGRA~1\NETSCA~1\NETSCA~1\pbhelper.dll
O2 - BHO: (no name) - {549B5CA7-4A86-11D7-A4DF-000874180BB3} - (no file)
O2 - BHO: ATLDistrib Object - {83A5F7B7-DC75-44CE-9195-264F41709FA9} - C:\WINDOWS\system32\mllml.dll
O2 - BHO: Google Toolbar Helper - {AA58ED58-01DD-4d91-8333-CF10577473F7} - c:\program files\google\googletoolbar1.dll
O2 - BHO: (no name) - {FDD3B846-8D59-4ffb-8758-209B6AD74ACC} - (no file)
O3 - Toolbar: &Google - {2318C2B1-4965-11d4-9B18-009027A5CD4F} - c:\program files\google\googletoolbar1.dll
O4 - HKLM\..\Run: [AVG7_CC] C:\PROGRA~1\Grisoft\AVGFRE~1\avgcc.exe /STARTUP
O4 - HKLM\..\Run: [AVG7_EMC] C:\PROGRA~1\Grisoft\AVGFRE~1\avgemc.exe
O4 - HKLM\..\Run: [NvCplDaemon] RUNDLL32.EXE C:\WINDOWS\system32\NvCpl.dll,NvStartup
O4 - HKLM\..\Run: [AdwareAlert] C:\Program Files\AdwareAlert\AdwareAlert.Exe -boot
O4 - HKCU\..\Run: [AIM] C:\Program Files\AIM\aim.exe -cnetwait.odl
O8 - Extra context menu item: &AOL Toolbar search - res://C:\Program Files\AOL Toolbar\toolbar.dll/SEARCH.HTML
O8 - Extra context menu item: &Google Search - res://C:\Program Files\Google\GoogleToolbar1.dll/cmsearch.html
O8 - Extra context menu item: &Translate English Word - res://C:\Program Files\Google\GoogleToolbar1.dll/cmwordtrans.html
O8 - Extra context menu item: Backward Links - res://C:\Program Files\Google\GoogleToolbar1.dll/cmbacklinks.html
O8 - Extra context menu item: Cached Snapshot of Page - res://C:\Program Files\Google\GoogleToolbar1.dll/cmcache.html
O8 - Extra context menu item: Similar Pages - res://C:\Program Files\Google\GoogleToolbar1.dll/cmsimilar.html
O8 - Extra context menu item: Translate Page into English - res://C:\Program Files\Google\GoogleToolbar1.dll/cmtrans.html
O9 - Extra button: (no name) - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\j2re1.4.2\bin\npjpi142.dll
O9 - Extra 'Tools' menuitem: Sun Java Console - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\j2re1.4.2\bin\npjpi142.dll
O9 - Extra button: AIM - {AC9E2541-2814-11d5-BC6D-00B0D0A1DE45} - C:\Program Files\AIM\aim.exe
O9 - Extra button: Real.com - {CD67F990-D8E9-11d2-98FE-00C0F0318AFE} - C:\WINDOWS\System32\Shdocvw.dll
O9 - Extra button: eBay - Homepage - {EF79EAC5-3452-4E02-B8BD-BA4C89F1AC7A} - C:\Program Files\IrfanView\Ebay\Ebay.htm
O9 - Extra button: Messenger - {FB5F1910-F110-11d2-BB9E-00C04F795683} - C:\Program Files\Messenger\msmsgs.exe
O9 - Extra 'Tools' menuitem: Windows Messenger - {FB5F1910-F110-11d2-BB9E-00C04F795683} - C:\Program Files\Messenger\msmsgs.exe
O14 - IERESET.INF: START_PAGE_URL=http://www.emachines.com
O16 - DPF: {4F1E5B1A-2A80-42CA-8532-2D05CB959537} (MSN Photo Upload Tool) - http://by13fd.bay13.hotmail.msn.com/resources/MsnPUpld.cab
O16 - DPF: {A90A5822-F108-45AD-8482-9BC8B12DD539} (Crucial cpcScan) - http://www.crucial.com/controls/cpcScanner.cab
O16 - DPF: {B38870E4-7ECB-40DA-8C6A-595F0A5519FF} (MsnMessengerSetupDownloadControl Class) - http://messenger.msn.com/download/MsnMessengerSetupDownloader.cab
O16 - DPF: {CC05BC12-2AA2-4AC7-AC81-0E40F83B1ADF} (Live365Player Class) - http://www.live365.com/players/play365.cab
O20 - Winlogon Notify: igfxcui - C:\WINDOWS\SYSTEM32\igfxsrvc.dll
O20 - Winlogon Notify: mllml - C:\WINDOWS\system32\mllml.dll
O23 - Service: AVG7 Alert Manager Server (Avg7Alrt) - GRISOFT, s.r.o. - C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe
O23 - Service: AVG7 Update Service (Avg7UpdSvc) - GRISOFT, s.r.o. - C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe
O23 - Service: LexBce Server (LexBceS) - Lexmark International, Inc. - C:\WINDOWS\system32\LEXBCES.EXE
O23 - Service: Netscape Update Service (NCUpdateSvc) - Netscape Communications Corporation - C:\Program Files\Netscape Internet Service\ncupdatesvc.exe
O23 - Service: Intel NCS NetService (NetSvc) - Intel(R) Corporation - c:\Program Files\Intel\NCS\Sync\NetSvc.exe
O23 - Service: NVIDIA Display Driver Service (NVSvc) - NVIDIA Corporation - C:\WINDOWS\system32\nvsvc32.exe



What should my next step be? I deleted the files that were obviously crap but win32reg.exe wasn't even there.

Anyone know of how to remove this piece of crap?

Source: http://community.livejournal.com/ms_windows/58646.html

Date: 02/26/06 (PHP Community)    Keywords: cms, php, mysql, database, sql, hosting

I programmed a CMS for one of my client and put it up on my own site in a test directory while it was in development. It was working just fine. They finally got their own hosting set up with Network Solutions so I uploaded all my files, set up the database and changed the username, password and db name in my scripts. Now I'm getting the following error: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I've double checked that I have the right username and the right password.

I'm using the following code to connect: $link = mysql_connect('localhost', $user, $pass) or die("Could not connect : " . mysql_error());

When I log into phpMyAdmin I see the following: MySQL 4.1.16-log running on localhost as eclipse@localhost so I'm assuming that 'localhost' is right. What else could be wrong? I've tried emailing tech support at Network Solutions but I doubt anyone there will get back to me. It's a pretty basic error but i can't figure out what else I would've needed to change when switching the site from my server to theirs.

Source: http://community.livejournal.com/php/418712.html

Date: 02/26/06 (MySQL Communtiy)    Keywords: cms, php, mysql, database, sql, hosting

I programmed a CMS for one of my client and put it up on my own site in a test directory while it was in development. It was working just fine. They finally got their own hosting set up with Network Solutions so I uploaded all my files, set up the database and changed the username, password and db name in my scripts. Now I'm getting the following error: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I've double checked that I have the right username and the right password.

I'm using the following code to connect: $link = mysql_connect('localhost', $user, $pass) or die("Could not connect : " . mysql_error());

When I log into phpMyAdmin I see the following: MySQL 4.1.16-log running on localhost as eclipse@localhost so I'm assuming that 'localhost' is right. What else could be wrong? I've tried emailing tech support at Network Solutions but I doubt anyone there will get back to me. It's a pretty basic error but i can't figure out what else I would've needed to change when switching the site from my server to theirs.

Source: http://community.livejournal.com/mysql/86856.html

Date: 05/31/06 (Web Development)    Keywords: cms, php, mysql, database, asp, sql, security, web

Hi all, a quick question.

I use PHP mostly because it's the only web language I know well enough to do what I need to do on a daily basis, but my place of employment is considering redesigning the web site - and letting me have control over how it's developed and in what languages, etc. Is there any advantage of using ASP over PHP, or any other language over another? I integrate a lot with a database (MySQL) (calendars, event listings, internship databases, video archive, etc) and currently run on a Sun box, but I also need to integrate (in the future) with a SQL database on an IIS server, which required me to develop in ASP. I didn't know ASP so we had to contract it out, and I'd rather avoid doing that again in the future - unless there's an added security benefit to asp or something like that. Opinions anyone, on what language to use vs another, or any opinions on a sort of "dream set up" (including CMS - I've never used a third party so recommendations would be interesting) I might be able to go after?

Thanks everyone!

Source: http://community.livejournal.com/webdev/325474.html

Date: 06/02/06 (Web Development)    Keywords: cms, asp, web

Dear all,

I need some info.

This is our company website. It is a big old mess structure wise. There is no CMS or anything useful like that and the architechture/navigation is terrifying. It's a serious nightmare to update (especially for me trying to navigate asp!!) and it needs to be more user friendly.

I am trying to recommend a course of action that is going to be cost effective (ie. the lower cost, the better) going forward. I think that it would be great to get a content management system in place since we're hoping to use the website a lot more extensively in the future. This would not be difficult since it's barely been touched since it's creation.

My questions are:

- A good, basic, cheap CMS - can someone recommend one?
- Having a quick look at the site, would we benefit having an Information Architecht help?
- Any other suggestions

Thankee!
Dominique

Source: http://community.livejournal.com/webdev/326249.html

Date: 06/02/06 (WebDesign)    Keywords: cms, asp, web

Dear all,

I need some info.

This is our company website. It is a big old mess structure wise. There is no CMS or anything useful like that and the architechture/navigation is terrifying. It's a serious nightmare to update (especially for me trying to navigate asp!!) and it needs to be more user friendly.

I am trying to recommend a course of action that is going to be cost effective (ie. the lower cost, the better) going forward. I think that it would be great to get a content management system in place since we're hoping to use the website a lot more extensively in the future. This would not be difficult since it's barely been touched since it's creation.

My questions are:

- A good, basic, cheap CMS - can someone recommend one?
- Having a quick look at the site, would we benefit having an Information Architecht help?
- Any other suggestions

Thankee!
Dominique

Source: http://community.livejournal.com/webdesign/1119664.html

Date: 06/21/06 (Java Web)    Keywords: cms, web

“Magnolia 3.0 is a commercial open-source Enterprise Content Management System that integrates web content management (CMS) and document management (DMS) through one web-based, AJAX-powered user interface. It is used around the world to maintain web sites, intranets and extranets by companies, governments and NGO’s of any size.” In my experience it is very user friendly [...]

Source: http://blog.taragana.com/index.php/archive/magnolia-cms-30-released-feature-rich-enterprise-cms-java/

Date: 06/21/06 (Java Web)    Keywords: cms, php

Archit3ct and IR4DEX GROUP have discovered a vulnerability in SmartSiteCMS, which can be exploited by malicious people to compromise a vulnerable system. Input passed to the “root” parameter in include/inc_foot.php is not properly verified before being used to include files. This can be exploited to execute arbitrary PHP code by including files from local or external [...]

Source: http://blog.taragana.com/index.php/archive/bandsite-cms-and-smartsite-cms-php-based-root-file-inclusion-vulnerability-discovered/

Date: 06/29/06 (Java Web)    Keywords: cms, php

Kw3[R]Ln has discovered a vulnerability in the MOD_CBSMS module for Mambo, which can be exploited to compromise a machine serving Mambo CMS. Input passed to the “mosConfig_absolute_path” parameter in mod_cbsms_messages.php isn’t properly verified, before it is used to include files. This can be exploited to include arbitrary files from external and local resources. Successful exploitation requires that [...]

Source: http://blog.taragana.com/index.php/archive/mambo-cms-suffers-from-file-inclusion-vulnerability/

Date: 07/07/06 (WebDesign)    Keywords: cms

If you run CMS on a Windows platform, which do you use and why? Pros and cons?

I've tried one for a client last year that caused a lot of headaches when it came to using my site design and their editing the site with the CMS. Their pictures and text would appear at the top of the page, overlaying the graphics I put in place.

Thanks for the input in advance!
Chris

Source: http://community.livejournal.com/webdesign/1136304.html

Date: 07/14/06 (Java Web)    Keywords: cms

Joomla Content Management System was forked off Mambo CMS after most of the core Mambo developers disagreed with Mambo Management. The current stable release is 1.0.10. I migrated from Mambo to Joomla to deter hacking efforts on my site. Note: I could have as well migrated to the latest version of Mambo but I just felt [...]

Source: http://blog.taragana.com/index.php/archive/how-to-migrate-from-mambo-to-joomla-cms/

Date: 08/05/06 (WebDesign)    Keywords: cms, php, mysql, database, sql, web, hosting, shopping

Sooo, I am 98% sure I'm taking on a client where I need to implement a CMS for him to make changes to the site if necessary. When I first wrote the quote a few months ago, I suggested Drupal as the CMS because it was free, looked rather customizable and somewhat easy to use. I have limited experience writing PHP and dealing with MySQL databases but understand the mechanics of it.

This particular client is offering subscriptions to a database of business industry contacts. There will be about 500 contacts on the pay list (including name, office, affiliation, etc) and he will add to the list about every three months or so. What he will change on a regular monthly basis will be the articles he writes. The subscription concept then requires a shopping cart/check out system as well as a password/username management system for each user.

Would Drupal be a good way to go for both my client and for me? Also, I'm switching web hosts and am considering becoming a reseller. Is there a web host that has it installed already? Door Host ( http://www.doorhost.net/ ) used to have it, but I don't think they do anymore. I'm considering going with Total Choice Hosting buying either their basic reseller plan or the regular Deluxe Plan.

Nonetheless, who has used this or other comparable CMSs and which do you prefer and why?

Drupal: http://www.drupal.org/

Sites built with Drupal:
http://www.terminus1525.ca
http://urlgreyhot.com/personal/
http://www.spreadfirefox.com/
http://www.theonion.com/
http://www.echoditto.com/

Oh, I just found this Drupal web hosting company called Site Ground that has all of the major CMSs installed already and gives you 24,000 MB of space. Anyone heard of them? I also found these guys: Canaca.com.

Source: http://community.livejournal.com/webdesign/1146967.html

Date: 08/14/06 (WebDesign)    Keywords: cms, html

Anyone have recommendations for a CMS that'd be suitable for an online magazine? I need something that's easily skinnable (got everything done in static html, just need to translate that into a dynamic site); has a mailform, search engine, and content syndication; and has a content approval workflow and (ideally) some way of auditing who is making what changes.

Currently looking into Drupal, Mambo, TYPO3, and Xoops. Anyone have any experiences with these or any other CMS's?

Source: http://community.livejournal.com/webdesign/1150602.html