Suggest me a CMS

So, my rationale goes as follows: Did NASA choose Drupal or Joomla? Did MTV choose Drupal or Joomla? End of discussion.

And many others chose some other platform so your argument is invalid. If you base your business decisions on that kind of logic instead of investigating the pros and cons of each platform based on your project 's requirements...
 
Drupal has a steeper learning curve but it will take you much further than WordPress. As for SQL in Drupal: use the Views module. Views is a visual query builder.
 
Already wrote comparisons of CMS' so won't bother to do it every time somebody asks this question. I can tell you however that for what you want to do I would suggest 100% custom coded. That way it does exactly what you want, how you want it and 10 to 500 times faster than any CMS.
 
Hire a freelancer or code it yourself. Use PHP frameworks, easy to code and you always code only what you want :)
 
Drupal seems to be a good choice. Joomla is kinda stuck in the early 00s, in terms of ergonomics, from my point of view.
 
Hi Weaxer

Regarding your problem of how to perform different sql queries on the account page: you could do this with blocks! The content of a block can consist of any input filter wich is configured - wich means by enabling the PHP Filter you can write plain PHP within your block - the solution of how to perform different queries per user is to work with the Drupal API:

http://api.drupal.org/api/drupal/modules!user!user.module/function/user_uid_optional_to_arg/7

- Use this function to retrieve the uid of the logged in user and use the uid as a primary key for your sql statement
- Etablish the connection to your DB using PHP's mysql_connect() function (Are you using Mysql?)
- Roll out your query with PHP's mysql_query() function

And here's a list of modules you might deem useful :D
http://drupal.org/project/block_class
http://drupal.org/project/block_class_styles
http://drupal.org/project/block_theme
http://drupal.org/project/userpoints
http://drupal.org/project/spiderslap
http://drupal.org/project/private
http://drupal.org/project/content_access

Provide your users/affiliates/customers with the possibility for refferals (MLM):
http://drupal.org/project/referral
http://drupal.org/project/affiliate_tree

Integrate Drupal with a solid ticketingsystem:
http://drupal.org/project/feedmine

Provide your users/affiliates/customers with a dashboard they can customize:
http://drupal.org/project/user_dashboard
http://drupal.org/project/dashboardify
http://drupal.org/project/homebox

cheers olystyle

P.S good choice going with drupal!!!
 
Joomla's quite wonderful, well supported through extensions and easier to use than Drupal IMO.
 
Last time I tried to use Joomla, I was pretty unhappy. It was not very customizable and most of the features and plugins were paid. However, it was a long time ago, when I hated it. They might have fixed it now.
 
Well, WP for the most basic things, Drupal for the most advanced and complex websites and Joomla is just in between. I've been working with those 3 CMSs for over 5 years now, and I often choose for WP or Drupal.
 
I am using joomla and wordpress for the clients but i think joomla is the best one according to me
 
I think, Volusion is the right solution for you. Have you tried that?
 
Drupal all day long. I manage a 20+ language drupal site with 5K+ pages of content and in excess of 50 custom modules. Its massively scaleable and you can do pretty much anything you can think of with. The White House in the USA was also using it last time I checked. For account balance integration with a (different) Database we simply use web services .. its so easy. Drupal in effect becomes your public front-end skin for the end user, and let the private code controlling the web services sit nice and cozy behind the firewall out of the way.

Word Press great for easy peasy, out-the-box, simple simon websites - do not touch it with someonelsesbargepole re: customer accounts!
Joomla too fiddly with code like a rats nest for my liking.
 
Back
Top