Thread

You pick up one tool (feature,module) and start banging at the rocks. If it breaks rocks…file it under “good for breaking rocks and possibly other hard things” 😊.
One thing I really liked or was impressed quite a bit was a query module.
For example, nowhere did I find a “feature” that will show list of user’s or “my comments” made thought the site.
Here is the code:

<table class="tableHeadingBG" border="0" cellpadding="0" cellspacing="0" width="100%">
            <tbody>
            <tr>
            <td class="tableHeading">Here are Comments you made on the content in this community :</td>
            </tr>
            </tbody></table>
            <table class="tableBorderLeft" border="0" cellpadding="6" cellspacing="0" width="100%">
            <tbody><tr>
            <td class="tableRowHeadingBold">Title</td>
            <td class="tableRowHeadingBold">Your Comment</td>
            <td class="tableRowHeadingBold">Date</td>
            <td class="tableRowHeadingBold">Total Comments</td>
            <td class="tableRowHeadingBold">Recent Comment</td>
            </tr>
            {exp:query sql="SELECT exp_comments.author_id, exp_weblog_titles.title, exp_weblog_titles.url_title, exp_comments.comment, exp_comments.comment_date, exp_weblog_titles.comment_total, exp_weblog_titles.recent_comment_date as comment_recent FROM exp_comments INNER JOIN exp_weblog_titles ON (exp_comments.entry_id = exp_weblog_titles.entry_id) WHERE exp_comments.author_id ='{segment_3}'"}
            <tr>
            <td class="tableCellOne" valign="top" width="30%"><b><a href="http://{path=">{title}</a></b></td>
            <td class="tableCellOne" valign="top" width="30%">{comment}</td>
            <td class="tableCellOne" valign="top" width="10%">{comment_date format='%m/%d/%y'}</td>
            <td class="tableCellOne" valign="top" width="10%">{comment_total}</td>
            <td class="tableCellOne" valign="top" width="10%">{comment_recent format='%m/%d/%y'}</td>
            </tr>{/exp:query}
            </table>

When it comes to presenting, showing…any reporting the query module is just great.
What else can it do? I don’t know but it did what I needed it….point being you don’t know what power you got until asked to create something with it. 😊
If you want to learn query I would suggest star with basic SQL and get some visual tool depending on platform such as SQLyog.
Again…this in only 1 module we are talking about ...imagine what else is lurking inside the EE.
All the best!

Now we talk even better =)
I knew that you can do superb things with that query but i need to read about that first. What’s funny, is that, that i have worked with sites and internet many years but for some reason i havent read about most important parts. Last year has been very good for me and to tell the truth, if i had never bought EE, i never learned things that i now start to understand. CSS is very interesting part and when you get “into” it, learning process gets faster - until you reach the point of “pain” =)

And today i’m so interested about almost everyting from this to that, when it comes to making sites with EE. Not EE itself but all the parts around it too. Because of my present situation i have time to surf around and read read read. Then i can surf and look innovations. I have ordered books about web designs and stuff, that are in english (and thats something…that i never ever thought i would do).

I hope that the documentation section of EE comes someday into PDF that users can download and read and most of all, it is for me, at least, at the moment little fuzzy. Many times i surf around the pages several times trying to find things and dont find them. Then i write here at forums and ask, and boom, the link to documentation comes - i somehow manage to miss them always…