The Joomla! Forum™

bascherz

Hi Scott, If the tables are interdependent, what field do they have in common? For instance, if they all have a userid field that maps to the one in the first query, you can use a JOIN. In that case you'd have something like this: SELECT `a.fvalue`,`b.surveyls_survey_id`,`c.token` FROM `jos_j...

bascherz

Simple: SELECT * FROM #_document_table WHERE filename in ('filename1', 'filename2', 'filename3') ORDER BY filename; Default ordering is ascending. If you want descending order, append DESC after filename in the query. SELECT * FROM #_document_table WHERE filename in ('filename1', 'filename2', 'filen...

bascherz

I gave up on trying to use Windows as a development or site testing environment earlier this year for the same sorts of reasons. Another one you need to be aware of is file name case sensitivity. Unix systems care about it, Windows does not. I've seen other things that don't work properly in Windows...

bascherz

The syntax used in the include statement doesn't follow URI standards, nor does it follow MS Windows standards (wrong type of slashes). Assuming everything is on your C: drive, try removing the C: and see what happens.

bascherz

Have you seen this thread?
http://forum.joomla.org/index.php/topic ... msg1076487

Perhaps is has something that might help.

bascherz

I believe you first need an account at joomlacode.org. Once you have that, you can write a tracker against those components and attach patch files to your tracker. Patch files can be generated inside Eclipse (there may be other ways, but that's the only one I know). These all sound like viable chang...

bascherz

Until you pointed me to it, I had not seen it. Thanks Amy!

bascherz

So, the bug squashing weekend is over, though I am sure there are still people going at it (hey, good for them!). I am curious what the overall result was. How many priority 1, 2, and 3 bugs got killed? How many new ones were found? Is there going to be some sort of announcement? I remember the star...

bascherz

I assume this is an error that you can't see by setting error reporting to Maximum in the site back end? That won't help with 40x errors, but it works pretty well for coding errors. The error messages are output directly to your browser.

bascherz

I have found from experience that testing in a Windows environment can cause you to miss certain subtle problems. For instance, Windows does not enforce case-sensitivity on file names. You might check that first. Also, your files may be in DOS format and may have to be in Unix format, or even UTF-8 ...

bascherz

Hi Samantha, CB has most of the features you need (lacks the task calendar and there's no buddy rating system), but it's currently only a 1.0.x extension (though it does work in J! 1.5 legacy mode). I suspect that at some point CB will be available as a 1.5 native extension (at least I hope it will)...

bascherz

This topic has been moved to Professional Services.

[iurl]http://forum.joomla.org/index.php?topic=235909.0[/iurl]

bascherz

This topic has been moved to Components.

[iurl]http://forum.joomla.org/index.php?topic=233846.0[/iurl]

bascherz

The short answer is Eclipse with the PHP Eclipse plug-in. The long answer is along the lines of "good luck getting it to work". I have personally spent a lot of time on this and had planned to report my "success story" in these forums somewhere but just haven't had time. In a nutshell, what I've got...

bascherz

There is no way in the back end interface to do what you want to do (at least in 1.0.x). However, with some of my 1.0.x sites I modified the site template to add logic that checks to see if the user is logged in and display one thing if so and another thing if not. If a user is logged in, $my->id wi...

bascherz

I looked for correlations with those tables, but I couldn't see any. Not being a core developer, I am only able to glean information from doing what-if analyses. From all appearances, you should be fine just updating the jos_content table as described earlier. Having said that, I will reiterate that...

bascherz

It really is pretty much that straightforward. However there are some things you need to take into consideration. For instance, each content item is either static or a member of a category and section. You'll need to make sure you get those IDs correct for every one of your articles. Regarding the {...

bascherz

Hi Pieter, It's a non-trivial sequence of operations. You cannot just import the user information into a single table. You need to update several related tables. My recommendation would be to find out (hopefully by a reply to this post) what the tables are and how they are related. Then, model those...

bascherz

If you haven't found one yet, there are a number of open source PHP scripts available to import your CSV file (check phpclasses.org... loaded with pop-up ads, but also loaded with gobs of great and nicely indexed scripts). As for removing the closed items from the table, that can be done by simply d...

bascherz

I understand what you are saying, but the "Latest News" module is not assigned to any menu . It is only assigned to a module position and it only appears on the homepage. The part I boldfaced in the above quote leads me to believe you have not selected the menu items associated with your menu modul...

bascherz

Which modules are visible for which menu-selected content is controlled in the individual module administrator interfaces. I think I may have experienced this problem myself in the past (with J! 1.0.x). If you have "All" selected, try saving the module configuration again. If that doesn't work, try ...

bascherz

In Joomla 1.0.x, $my->usertype returns a string representation. You could alternatively use $my->gid if you prefer the numeric values of each type of user. Values for $my->usertype are as follows (with $my->gid): ⋅ Public Frontend(29) ⋅ Registered(18) ⋅ Author(19) &sdot...

bascherz

No. What you need to do is create a CB checkbox field that is not user-writable but rather is set by the extension that uploads the MP3 file or by a CB plug-in that knows where it is. One way or another, some software needs to write a '1' to this CB checkbox field. The easiest way (without hacking) ...

bascherz

How can I perpetually make every user who has not uploaded an mp3 to their profile, a FAN ONLY. That is, I want to only let those who upload music select a genre, and everyone else is has to default to a FAN ONLY status (or genre) Anyone have any helpful insight? I'm stuck. CB has no built-in...

bascherz

Replacing (or hacking) core components can be done; I've done it myself. But you leave your creation vulnerable to core updates wiping them out (forcing a reinstall or reapply) or another person doing the same as you and your two extensions not being able to coexist. You'll have to weigh that agains...

bascherz

Great job, Amy. Kudos cannot measure your commitment and contributions.

Now, why not go get some sleep?!

bascherz

In the response I ended up deleting, I was trying to write an SQL statement that would set jos_core_acl_groups_aro_map.group_id to 18 for every user whose jos_users.id is > 67 (or whose jos_core_acl_aro.value > 67). I believe that's what is needed, though I am struggling to create a single SQL state...

bascherz

Open (browse) the table named jos_core_acl_aro_groups. It will list the various types of users. Write down the group_id for the user type "Registered". For the sake of example, let's say that number is 18. Next, enter the following SQL command: UPDATE jos_users SET gid=18, usertype='Registered' WHER...

bascherz

The official Overlib documentation is located at http://www.bosrup.com/web/overlib/?Documentation.

bascherz

This topic has been moved to Joombie Think Tank.

[iurl]http://forum.joomla.org/index.php?topic=209163.0[/iurl]

The Joomla! Forum™

Search found 86 matches

Re: Need mysql statement help

Re: php and mysql Order By help

Re: wamp include / require errors

Re: wamp include / require errors

Re: ubuntu xampp and pdt

Re: How can I submit code

Re: How Many Bugs Got Squashed?

How Many Bugs Got Squashed?

Re: how can I display my component errors?

Re: how can I display my component errors?

Re: How would I make a buddy system?

MOVED: Hiring experinced builder

MOVED: Community Builder Help???

Re: what do seasoned Joomla developers use?

Re: Restrict Access Once Members Registers...

Re: what is the sql statment to add a content item?

Re: what is the sql statment to add a content item?

Re: Importing users from MS Access database into Joomla 1.5

Re: How can I update existing records from an uploaded list of records?

Re: How to show side modules (ie. menus) when clicking on a "Latest News" Item ?

Re: How to show side modules (ie. menus) when clicking on a "Latest News" Item ?

Re: User Group

Re: Community Builder & Joomla.. help with code

Re: Community Builder & Joomla.. help with code

Re: Using core components as a basis for new components

Re: Joomla! Member of the Month Award - September 2007

Re: change the permission of all users

Re: change the permission of all users

Re: Overlib Commands

MOVED: ebibleicious extension