phpwebsite-developers — For our development team.

Re: [Phpwebsite-developers] Gallery Module?

[Don S. <do...@se...>]

photoalbum

On Tue, 17 Jun 2003, Eloi George wrote:

> Does anyone have a finished Gallery Module for 0.9x?  All the 0.8x ones just
> seem to deadend there.
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: INetU
> Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> 

Re: [Phpwebsite-developers] Gallery Module?

[Matthew M. <ma...@tu...>]

> Does anyone have a finished Gallery Module for 0.9x?  All the 0.8x ones
> just
> seem to deadend there.

Have you tried photoalbum?

Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
phpwebsite.appstate.edu
ess.appstate.edu

[Phpwebsite-developers] Gallery Module?

[Eloi G. <el...@re...>]

Does anyone have a finished Gallery Module for 0.9x?  All the 0.8x ones just
seem to deadend there.

RE: [Phpwebsite-developers] Pagemaster & Categorizer

[Matthew M. <ma...@tu...>]

> Though I'm still
> not quite sure what the 'Sticky' thing is.

Checking something as Sticky gives it top priority. It will _always_
appear on the What's Related list no matter what.

> In fact, it looks like a single element can not
> only have multiple children, but possily multiple parents(?)
> [getParents()].

No, they can only have one parent (although their parent may have a
parent). This is just a misleading function name.

> This leads me to suggest that maybe fatcat could have
> some predefined categories (Images, Links, etc), then a module can create
> its own children of those

Interesting thought. We will talk more about this.

> In this setup, an important function would be the
> 'getAllElements(category)'
> One question about this.  When returning elements belonging to a category,
> do you return elements belonging to a parent of that cagtegory? (Perhaps a
> parameter switch [getAllElements(category,returnParentElements)]). This
> way if I want to add an image to a Pagemaster page, I get not only
> Image>Pagemaster elements, but generic Image elements as well.

Originally I was going to do this but it seemed like a lot of data that
not many people would use. We can look at allowing this through better
interface however.


> Another important function is the 'deleteCategory(category)'
> ... However,
> one possible alternative is that if the category being deleted has a
> parent, to change all elements off the category being deleted to be
> elements of its parent category

I can do this.

> Pagemaster can be handled in two ways. Currently, pages are treated like a
> collection of sections (similar to announcement module).  I'm not entirely
> sure what the reason for the multiple sections functionality was (or is),
> but I'm not sure they don't unnecissarily add to the complexity of the
> module.

PageMaster was written with our university users in mind. Because few of
them know HTML, it was easier to split the material into sections to make
its appearance more pleasing. What I would suggest is the option to have
an expert mode.

> A single image for a section seems limiting.

Again, it was easier to do it that way than to show them how to to create
image tags.

> And what is the necessity for a subtitle that just takes
> up a field in the database

Same reasons as the above.
> 4) Expand the size of the input window and allow a page to be a single
> entity (ie no sections).

Not sure how Adam will wish to treat this. It would be nice however if the
user could set their window size to increase the width of the text area.


> 6) When editing a page, clicking on the image button will bring up a small
> window (similar to the help windows) with the 'Add Image' interface.
> Perhaps a button "Add Internal Image" and "Add External Image".

Possible, but would require some javascript programming (which I am not
great at). Also there would need to be an alternate interface for those
who don't run javascript.

> 8) The uploading of the images could be handled by the document manager.

Depending on the module, that could be kind of a pain switching in and out
of modules.

Thanks for your feedback,
Matthew McNaney
Internet Systems Architect
Electronic Student Services
Appalachian State University
Phone: 828-262-6493
phpwebsite.appstate.edu
ess.appstate.edu

RE: [Phpwebsite-developers] Pagemaster & Categorizer

[Roland, R. M <rmr...@in...>]

As I said, I've spent a bit of time thinking about the Pagemaster module =
so I apologize for the lengthy narrative.  In describing my thoughts on =
this, the Fatcat module came up.  Before I wrote on that module, I =
wanted a better understanding of its internal functionality.  =
Suprisingly, when I looked into it, I saw that 1) there exists an =
heirarchy system (parent/child) for categories and 2) that the deletion =
of both elements and categories are already taken care of quite nicely.  =
Though I'm still not quite sure what the 'Sticky' thing is.

-----

Notes on FatCat

As I said, there appears to already be an heirarchial system build into =
Fatcat where a Pagemaster_Image (or better Image>Pagemaster) can be a =
child of a generic Image. In fact, it looks like a single element can =
not only have multiple children, but possily multiple parents(?) =
[getParents()].  This leads me to suggest that maybe fatcat could have =
some predefined categories (Images, Links, etc), then a module can =
create its own children of those (Image>Pagemaster, Image>Menu, etc).  =
And for modules whose category has no generic parent, then their =
category would be a standalone.

In this setup, an important function would be the =
'getAllElements(category)'
One question about this.  When returning elements belonging to a =
category, do you return elements belonging to a parent of that =
cagtegory? (Perhaps a parameter switch =
[getAllElements(category,returnParentElements)]). This way if I want to =
add an image to a Pagemaster page, I get not only Image>Pagemaster =
elements, but generic Image elements as well.


Another important function is the 'deleteCategory(category)'
The way this currently works is actually pretty good.  If you delete a =
category, any children that belong to it are deleted as well.  In =
addition, all elements of the categories you delete get deleted.  =
However, one possible alternative is that if the category being deleted =
has a parent, to change all elements off the category being deleted to =
be elements of its parent category (ie a Image>Pagemaster element would =
become just an Image element if you deleted the Image>Pagemaster =
category).=20

Other than that, I don't see alot of change being necessary with the =
FatCat module.  It's more about HOW it is used by other modules. =20

-----

Notes on Pagemaster  (keep in mind that I have no clue what Adam's =
Pagemaster rewrites consist of)

Pagemaster can be handled in two ways. Currently, pages are treated like =
a collection of sections (similar to announcement module).  I'm not =
entirely sure what the reason for the multiple sections functionality =
was (or is), but I'm not sure they don't unnecissarily add to the =
complexity of the module. =20

The second way to handle Pages is to treat each as a single entity. And =
unless there's a reason for sections that I don't see (which is =
probable), I think this way is simpler for the module coder (for =
numerous reasons) and easier for novice users to understand (as my =
informal usability testing has shown).  The rest of my thoughts =
concerning this module reflect this manner.

When creating a new page, the Page options are good.  I'd like to see =
implemented a similar feature as in Announcements where you can set =
'Post On' (or 'Activate On') and 'Expire' dates which shouldn't be too =
difficult.

I also think that the section editing page has too much extraneous info. =
 This causes more confusion for novice users.  A single image for a =
section seems limiting.  And what is the necessity for a subtitle that =
just takes up a field in the database when I can just as easily do =
'<h3>Subtitle</h3>'  Also, in my usability testing, there =
were alot of users confused by the concept of multiple sections for a =
page (especially when they seem to look like just another paragraph).


Summing up My Considerations (no particular order):

1) When asking for all elements of a FatCat category, allow for the =
return of elements that belong to the parent of that category.

2) Consider (just consider) having FatCat elements, when their category =
is deleted, to change their category to the parent of their now deleted =
category.

3) Add 'Activate On' and 'Expire On' dates to a Pagemaster page.  =
Because this is already in use in the Announcements module, and could be =
useful in other modules (MenuManager, etc), consider perhaps in a later =
implementation, a small internal scheduler module that can be used to =
activate/deactivate items and even mail reminders or system messages.

4) Expand the size of the input window and allow a page to be a single =
entity (ie no sections).=20

5) Remove the subtitle, image, and short image description fields from =
what was the section editor. =20

6) When editing a page, clicking on the image button will bring up a =
small window (similar to the help windows) with the 'Add Image' =
interface.  Perhaps a button "Add Internal Image" and "Add External =
Image".  External image will bring up a page that will allow you to =
enter the url and some settings (border, etc).  Internal will bring up a =
page with maybe thumbs of the existing images in the Image>Pagemaster =
and possily the generic Image categories (ahh.. my FatCat ramblings =
finally have a point).

7) Similarly, links could be handled the same way.  Internal (list of =
pagemaster pages, calendar events, FAQs, etc, and of course Link Manager =
links) and external (obvious).

8) The uploading of the images could be handled by the document manager. =
 And there would need to be a mechanism (toggle switch) to differentiate =
between files for internal use and files for download by visitors.  I'm =
not sure that the hidden/visible toggle would work since if it's an =
image, it would need to be visible through a URL (ie when viewed through =
a pagemaster page), just not downloadable through the document manager. =
(Not sure if I'm making myself clear on this or not).


Again, sorry this is so long, but as I've said, the Pagemaster module =
has alot of importance in the public face of our website and I've put =
alot of thought and time into it.  I've avoided putting much of this =
into code before getting info regarding Adam's direction and input from =
other developers.  So if anyone can find problems with what I've =
suggested, or elaboration, or improvement, by all means, please do so.=20

Thanks for your feedback,


Ryan Roland

Application Developer
Information Technology Department
Division of Recreational Sports
Indiana University

rmr...@in...
Office: 812.855.9617
Cell: 812.320.0032


-----Original Message-----
From: ad...@tu... [mailto:ad...@tu...]
Sent: Thursday, June 12, 2003 11 02
To: php...@li...
Subject: RE: [Phpwebsite-developers] Pagemaster & Categorizer



>> During this re-write would be the best time to try and implement
>> something
>> like this.
>
> I agree, but my fear is writing something at the same time that your =
team
> does (what sounds like) a major rewrite on reliant (if not the same)
> modules.  I've worked on too many projects where a lack of cooperation =
led
> to two versions of a function or class which led to having to rehash =
it
> together anyway and I want to avoid that.
>

Agreed I will try to be more clear.

>> FatCat would need a module to specify which categories it should =
create,
>> easy part.
>
> Not sure what you mean by 'module'...  It would need some kind of
> interface (function) that other modules could ask for categories to be
> created (which it should already have).  Maybe you used the wrong word =
or
> maybe I'm misunderstanding.
>

When I say module I mean it as a noun.  A module would need to specify
which categories it would create and yes fatcat would need to provide an
interface for accomplishing this if it does not already exist.

>> You would then need a method for selecting items from the
>> category without creating confusion to the user, a little harder.
>
> When you say the user, are talking about module developers or system
> users?  I agree that when users are placing items in a category, there
> needs to be a help link that explains well the use of categories.
>

Example:  selecting an image when creating a section in pagemaster.  Do
you send the user to a different screen with all the images in the
pagemaster->images category shown and the user can select it there.  Do
you show a dropdown with all the names of images contained in the
pagemaster->images category.  Or is there some easier method for =
selecting
those types of items.  The interface decided on would need to work for =
all
modules for consistancy purposes.

>> Then, once the item has been selected, you must make the page, event,
>> or link aware of the categorized item it uses, again not too bad just
>> tricky.
>
> This, I agree will be tricky, but my larger concern is whether to =
allow an
> item to be in more than one category.  Can an image be a =
Pagemaster_Image
> and a Menu_Image or should you just categorize it as just an Image, =
etc.
>

This is also a good question.  Should we just create some default
categories that modules could call upon like Images, Links, etc?

>> Then, you would need to take into account a categorized item that =
gets
>> deleted.
>> This could be the worse of it.  You would have to traverse the
>> items using the deleted categorized item and either remove it or set =
it
>> to
>> hidden or something.
>
> I agree, but that doesn't worry me as much as what happens if a =
category
> itself gets deleted.
>

Aye the inverse is probably more tricky then deleting an item.

>
> I will soon be posting a rough idea of what I'm thinking with regards =
to
> this modification, but I'd like some idea of what your team seems to
> already have planned for this and other mods to make sure that =
anything I
> write isn't in conflict with yours.
>

I look forward to hearing your thoughts on this.

>
> Thanks,
>
>
> Ryan Roland
>
> Application Developer
> Information Technology Department
> Division of Recreational Sports
> Indiana University
>
> rmroland@in...
> Office: 812.855.9617
> Cell: 812.320.0032
>
>
> -----Original Message-----
> From: adam@tu...
> Sent: Wednesday, June 11, 2003 08 48
> To: php...@li...
> Subject: Re: [Phpwebsite-developers] Pagemaster & Categorizer
>
>
> Ryan,
>
> I see your logic here.  We are going to be doing re-writes of several
> modules for the 0.9.3 release so they use the Item/Manager classes.
> During this re-write would be the best time to try and implement =
something
> like this.  It would require working out several issues before any
> implementation could happen.  Here's a few I can think of off the top =
of
> my head:
>
> FatCat would need a module to specify which categories it should =
create,
> easy part.  You would then need a method for selecting items from the
> category without creating confusion to the user, a little harder.  =
Then,
> once the item has been selected,  you must make the page, event, or =
link
> aware of the categorized item it uses, again not too bad just tricky.
> Then, you would need to take into account a categorized item that gets
> deleted.  This could be the worse of it.  You would have to traverse =
the
> items using the deleted categorized item and either remove it or set =
it to
> hidden or something.
>
>> Since my group has a great deal of interest in the Pagemaster module =
due
>> to its importance in our use of the system, I have put considerable
>> thought into it.
>>
>> One of the thoughts that I had was in regard to the Categorizer.
>> Firstly,
>> I am considering expanding Pagemaster's ability to add images to a =
page.
>> Obviously if people are allowed to upload their own images each time
>> they
>> want to add one to a page, it could lead to severe file duplication =
on
>> the
>> server.  My thought is to use the document manager to upload the =
images
>> and handle them.  Here's where my thought regarding the Categorizer
>> comes
>> into play.
>>
>> Say that the categorizer comes with some specific categories (i.e.
>> Pagemaster->Images, Pagemaster->Links, etc), to which administrators,
>> wishing to create a portfolio of images for use in the Pagemaster
>> module,
>> could add their images.  Then in the pagemaster module, when a page
>> creator is trying to add an image to their page, they get a portfolio =
of
>> images made up of all the images in Pagemaster->Images.
>>
>> This would work for other modules as well: Menuman->Links,
>> Calendar->Images, etc.
>>
>> It seems to me, and please correct me if I'm wrong, that so far the
>> categorizer module has been used to group items together within a =
module
>> for relevance.  All sports related pages/announcements are distinct =
from
>> all science related pages/announcements/etc.  The reason I think this
>> would be most beneficial is that it would take that distinction and
>> allow
>> it to be of use in the functionality of other modules (which is
>> something
>> that I don't see it being used for yet).  Plus I don't see it as =
being
>> too
>> much of a change in code as much as a change in the way other modules
>> use
>> the categorizer.
>>
>>
>> These are just my meandorings, but I was curious what the developer
>> comm.
>> thought about it.  Let me know if I jumped around too much and need =
to
>> explain anything better... I tend to ramble :)
>>
>>
>> Thanks,
>>
>>
>> Ryan Roland
>>
>> Application Developer
>> Information Technology Department
>> Division of Recreational Sports
>> Indiana University
>>
>> rmroland@in...
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by:  Etnus, makers of TotalView, The =
best
>> thread debugger on the planet. Designed with thread debugging =
features
>> you've never dreamed of, try TotalView 6 free at www.etnus.com.
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>
>
> --
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - Appalachian Linux Users Group
> http://alug.appstate.edu
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The =
best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


--=20
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu



-------------------------------------------------------
This SF.NET email is sponsored by: eBay
Great deals on office technology -- on eBay now! Click here:
http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
_______________________________________________
Phpwebsite-developers mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers

[Phpwebsite-developers] Theme Variables

[Richard S. <ri...@ri...>]

Where can I go to find a list of all the predefined theme variables 
that I can call from my theme?

Re: [Phpwebsite-developers] Boost error?

[Richard S. <ri...@ri...>]

Heh, you might be right. I was deleting a whole bunch of the mods that 
come with the system to clean it up a bit and I guess I accedently 
deleted one of the core ones. I feel like an idiot for asking lol....


On Saturday, June 14, 2003, at 01:12  PM, Don Seiler wrote:

> Do you not have the Approval module boosted?
>
> Don.
>
> On Sat, 14 Jun 2003, Richard Sumilang wrote:
>
>> For some reason when I try to uninstall one of my modules I keep
>> getting this error
>>
>> Fatal error: Undefined class name 'phpws_approval' in
>> /www/webevents/mod/boost/class/Boost.php on line 451
>>
>> Anyone know why?
>>
>>
>>
>> -------------------------------------------------------
>> This SF.NET email is sponsored by: eBay
>> Great deals on office technology -- on eBay now! Click here:
>> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>>
>>
>
>

Re: [Phpwebsite-developers] Boost error?

[Don S. <do...@se...>]

Do you not have the Approval module boosted?

Don.

On Sat, 14 Jun 2003, Richard Sumilang wrote:

> For some reason when I try to uninstall one of my modules I keep 
> getting this error
> 
> Fatal error: Undefined class name 'phpws_approval' in 
> /www/webevents/mod/boost/class/Boost.php on line 451
> 
> Anyone know why?
> 
> 
> 
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> 

[Phpwebsite-developers] Boost error?

[Richard S. <ri...@ri...>]

For some reason when I try to uninstall one of my modules I keep 
getting this error

Fatal error: Undefined class name 'phpws_approval' in 
/www/webevents/mod/boost/class/Boost.php on line 451

Anyone know why?

Re: [Phpwebsite-developers] DB: Number of rows affected? ------Code-------

[Richard S. <ri...@ri...>]

This should actually work. I added a variable to the DB class called=20
affectedRows and set it in the query function. I think you might need a=20=

newer version of PEAR to call a function called raiseerror or something=20=

if this doesn't work for your PHP_WS system.


	/**
	 *	Number of orows affected by query
	 *
	 *	@access	public
	 */
	var $affectedRows;
=09
=09

   /**
    * Queries the SQL db with supplied command
    *
    * The most basic method for dealing with the database.
    * Read the PEAR documentation for information on what
    * methods to apply to the resultant object to retrieve
    * its data.
    *
    * @author	Matthew McNaney	 <ma...@NO...>
    * @modified	Richard Sumilang <ri...@ri...>
    * @param		string  $sql            The SQL command query to =
execute
    * @param		boolean $addTablePrefix If TRUE, add table =
prefix to SQL=20
statement
    * @param		boolean $error_pass     If TRUE, don't echo =
errors
    * @return	object  $sql_result     DB Result object of the query
    * @access	public
    */
   function query($sql, $addTablePrefix=3DFALSE, $error_pass=3DFALSE){
     if (method_exists($this->db, "query")) {
       if ($addTablePrefix)
	$sql =3D $this->addTablePrefix($sql);

       if (DB::iserror($sql_result =3D $this->db->query($sql))) {
	if ($error_pass) return FALSE;
	else exit($sql_result->getMessage() . "<br />" .=20
$sql_result->userinfo);
       } else{
	  	$this->affectedRows=3DDB_Common::affectedRows();
	   return $sql_result;
	   }
     }
     else return FALSE;
   }// END FUNC query()
=00=00


If you guys can get this a working and a part of the system that would=20=

be great

Best Regards,
Richard S.













On Wednesday, June 11, 2003, at 12:46  PM, ad...@tu... wrote:

>
> Those particular functions only work for specific databases.  There is=20=

> a
> pear function in the DB class that does the same thing but abstracts=20=

> it.
> I will look into adding a function that phpwebsite developers can call
> that will return the affected rows from the last query for any =
database
> supported by phpwebsite.
>
> Adam
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>>
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> On 11-Jun-2003, Richard Sumilang wrote message "Re:
>> [Phpwebsite-developers] DB:
>> Number of rows affected?"
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> Where is that method at?
>>>
>>
>>
>> http://si.php.net/manual-lookup.php?pattern=3Daffected_rows&lang=3Den
>>
>> ~~
>> Andy Harrison
>> ah##@httpsite.com
>> ICQ: 123472  AIM/Y!: AHinMaine
>> [full headers for details]
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: PGP 6.5.8
>>
>> iQCVAwUBPueFV1PEkLgodAWVAQE+SQP/YYZ8Rn0WTCNzX+klffNGu6HYeCH+AfRl
>> ysULUMZrkxU8oUNAqscG/Bk/uFDJuiBaLvCW9wdkrH09VbpDkoQeZPfJ/HOg8fP3
>> Q9I0EcNZylUf7Yx6DY6l9GlKG1vhJlIDlo+QCl/3xhQ72OxxqL3HvDCtdPbOTrpu
>> 6Ez7jRrn8ds=3D
>> =3DYw9K
>> -----END PGP SIGNATURE-----
>>
>>
>> -------------------------------------------------------
>> This SF.NET email is sponsored by: eBay
>> Great deals on office technology -- on eBay now! Click here:
>> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>
>
> --=20
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - Appalachian Linux Users Group
> http://alug.appstate.edu
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>

Re: [Phpwebsite-developers] DB: Number of rows affected?

[Richard S. <ri...@ri...>]

Great. If you can keep the mailing list posted when that happens that 
will be awesome.

Regards,
Richard S.

On Wednesday, June 11, 2003, at 12:46  PM, ad...@tu... wrote:

>
> Those particular functions only work for specific databases.  There is 
> a
> pear function in the DB class that does the same thing but abstracts 
> it.
> I will look into adding a function that phpwebsite developers can call
> that will return the affected rows from the last query for any database
> supported by phpwebsite.
>
> Adam
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>>
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> On 11-Jun-2003, Richard Sumilang wrote message "Re:
>> [Phpwebsite-developers] DB:
>> Number of rows affected?"
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> Where is that method at?
>>>
>>
>>
>> http://si.php.net/manual-lookup.php?pattern=affected_rows&lang=en
>>
>> ~~
>> Andy Harrison
>> ah##@httpsite.com
>> ICQ: 123472  AIM/Y!: AHinMaine
>> [full headers for details]
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: PGP 6.5.8
>>
>> iQCVAwUBPueFV1PEkLgodAWVAQE+SQP/YYZ8Rn0WTCNzX+klffNGu6HYeCH+AfRl
>> ysULUMZrkxU8oUNAqscG/Bk/uFDJuiBaLvCW9wdkrH09VbpDkoQeZPfJ/HOg8fP3
>> Q9I0EcNZylUf7Yx6DY6l9GlKG1vhJlIDlo+QCl/3xhQ72OxxqL3HvDCtdPbOTrpu
>> 6Ez7jRrn8ds=
>> =Yw9K
>> -----END PGP SIGNATURE-----
>>
>>
>> -------------------------------------------------------
>> This SF.NET email is sponsored by: eBay
>> Great deals on office technology -- on eBay now! Click here:
>> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>
>
> -- 
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - Appalachian Linux Users Group
> http://alug.appstate.edu
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>

Re: [Phpwebsite-developers] Bug in php_net & php_net_greeen themes

[Jeremy A. <ja...@tu...>]

I forgot to update the cvs copy after i fixed it for
phpwebsite.appstate.edu.  Ill update the php_net one in cvs today.
>> > Don.
>> >
>> > On Thu, 12 Jun 2003, R. Scott Baer wrote:
>> >
>> >> Looks like it was corrected on:  phpwebsite.appstate.edu, but not in
>> the
>> >> CVS
>> >>
>> >> /themes/php_net/theme.tpl                 v 1.3
>> >> /themes/ php_net_green/theme.tpl      v 1.4
>> >>
>> >>
>> >> 43  <intput type="hidden" name="module" value="search" />
>> >> 44  <intput type="hidden" name="SEA_search_op" value="search" />
>> >>
>> >> both should be input
>> >>
>> >>
>> >> -------------------------------------------------------
>> >> This SF.NET email is sponsored by: eBay
>> >> Great deals on office technology -- on eBay now! Click here:
>> >> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>> >> _______________________________________________
>> >> Phpwebsite-developers mailing list
>> >> Php...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>> >>
>> >>
>> >>
>> >
>> >
>> > -------------------------------------------------------
>> > This SF.NET email is sponsored by: eBay
>> > Great deals on office technology -- on eBay now! Click here:
>> > http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>> > _______________________________________________
>> > Phpwebsite-developers mailing list
>> > Php...@li...
>> > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>> >
>>
>>
>>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


-- 
Jeremy Agee
phpWebSite Development Team (http://phpwebsite.appstate.edu)
Appalachian State University
SF.net id: jagee or 94756

Re: [Phpwebsite-developers] Bug in php_net & php_net_greeen themes

[Don S. <do...@se...>]

Yes all good ideas.  Let me know when you hear back from them.  I have a 
funny feeling that they might not take too well to it, but one never 
knows.

We need a kind soul who is graphically and stylistically inclined to churn 
out endless great-looking themes for us.

Don.

On Thu, 12 Jun 2003 ad...@tu... wrote:

> Due to copyright information on the php.net site we've decided to stop
> releasing the php_net and php_net_green themes with major releases:
> 
> http://www.php.net/copyright.php
> 
> We will continue to host them in our cvs repository until we can contact
> the php team and verify that it is ok to redistribute this theme to our
> users.  We are also changing the file structure of our downloads directory
> at phpwebsite.appstate.edu and we can make the theme available there. Don,
> I would suggest adding some disclaimer to those themes to help protect
> yourself and let us know if you want the theme to be made downloadable.  I
> will post to the list as soon as we get in touch with the php team and
> hear back from them concerning this.
> 
> Adam
> 
> > Yeah I don't know if those searches work at all.  Also those themes are no
> > longer valid according to the W3C validator since I recopied them from
> > php.net.  Mike Windsor had them valid but I stuck my nose in and re-did
> > them.
> >
> > If I can find some time I'll clean them up a bit.
> >
> > Don.
> >
> > On Thu, 12 Jun 2003, R. Scott Baer wrote:
> >
> >> Looks like it was corrected on:  phpwebsite.appstate.edu, but not in the
> >> CVS
> >>
> >> /themes/php_net/theme.tpl                 v 1.3
> >> /themes/ php_net_green/theme.tpl      v 1.4
> >>
> >>
> >> 43  <intput type="hidden" name="module" value="search" />
> >> 44  <intput type="hidden" name="SEA_search_op" value="search" />
> >>
> >> both should be input
> >>
> >>
> >> -------------------------------------------------------
> >> This SF.NET email is sponsored by: eBay
> >> Great deals on office technology -- on eBay now! Click here:
> >> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> >> _______________________________________________
> >> Phpwebsite-developers mailing list
> >> Php...@li...
> >> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> >>
> >>
> >>
> >
> >
> > -------------------------------------------------------
> > This SF.NET email is sponsored by: eBay
> > Great deals on office technology -- on eBay now! Click here:
> > http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> > _______________________________________________
> > Phpwebsite-developers mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> >
> 
> 
> 

Re: [Phpwebsite-developers] Bug in php_net & php_net_greeen themes

[<ad...@tu...>]

Due to copyright information on the php.net site we've decided to stop
releasing the php_net and php_net_green themes with major releases:

http://www.php.net/copyright.php

We will continue to host them in our cvs repository until we can contact
the php team and verify that it is ok to redistribute this theme to our
users.  We are also changing the file structure of our downloads directory
at phpwebsite.appstate.edu and we can make the theme available there. Don,
I would suggest adding some disclaimer to those themes to help protect
yourself and let us know if you want the theme to be made downloadable.  I
will post to the list as soon as we get in touch with the php team and
hear back from them concerning this.

Adam

> Yeah I don't know if those searches work at all.  Also those themes are no
> longer valid according to the W3C validator since I recopied them from
> php.net.  Mike Windsor had them valid but I stuck my nose in and re-did
> them.
>
> If I can find some time I'll clean them up a bit.
>
> Don.
>
> On Thu, 12 Jun 2003, R. Scott Baer wrote:
>
>> Looks like it was corrected on:  phpwebsite.appstate.edu, but not in the
>> CVS
>>
>> /themes/php_net/theme.tpl                 v 1.3
>> /themes/ php_net_green/theme.tpl      v 1.4
>>
>>
>> 43  <intput type="hidden" name="module" value="search" />
>> 44  <intput type="hidden" name="SEA_search_op" value="search" />
>>
>> both should be input
>>
>>
>> -------------------------------------------------------
>> This SF.NET email is sponsored by: eBay
>> Great deals on office technology -- on eBay now! Click here:
>> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>>
>>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


-- 
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu

Re: [Phpwebsite-developers] Bug in php_net & php_net_greeen themes

[Don S. <do...@se...>]

Yeah I don't know if those searches work at all.  Also those themes are no 
longer valid according to the W3C validator since I recopied them from 
php.net.  Mike Windsor had them valid but I stuck my nose in and re-did 
them.

If I can find some time I'll clean them up a bit.

Don.

On Thu, 12 Jun 2003, R. Scott Baer wrote:

> Looks like it was corrected on:  phpwebsite.appstate.edu, but not in the CVS
> 
> /themes/php_net/theme.tpl                 v 1.3
> /themes/ php_net_green/theme.tpl      v 1.4
>  
> 
> 43  <intput type="hidden" name="module" value="search" />
> 44  <intput type="hidden" name="SEA_search_op" value="search" />
> 
> both should be input
> 
> 
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> 

RE: [Phpwebsite-developers] Refactor of Pagemaster Search

[<ad...@tu...>]

Ryan,

Sorry for the name confusion earlier.  I'm really bad with names :) 
Anyway, I'm finishing up some updates to pagemaster right now that will
implement a simplified search with only 2 queries.  I added in a page_id
column to the mod_pagemaster_sections table.  I also implemented a method
for adding a URL to uploaded images in sections.  I've written an update
script the can be used by boost to update current v1.32 to the new v1.4. 
I will release all this with a patch release we have planned for today or
tomorrow.

Adam

> Adam,
>
> First off, as much as I respect Richard, I'm not him. :)  But I
> understand, those 'R' names just start to run together.  Secondly, that
> search function I sent you for pagemaster should only use 2 queries.
> However, because I tried to avoid changing anything other than that
> function, I had to do alot of array jumping and searching to determine
> what page a section belonged to.  It's not pretty, but adding that field
> to the sections table would greatly simplify the process.
>
> Actually, I wrote this post to the mailing list a good three weeks ago,
> but it seemed it took awhile to get moderated to the list.  Not sure how
> to get around this though.
>
>
>
> Thanks,
>
>
> Ryan Roland
>
> Application Developer
> Information Technology Department
> Division of Recreational Sports
> Indiana University
>
> rmroland@in...
> Office: 812.855.9617
> Cell: 812.320.0032
>
>
> -----Original Message-----
> From: adam@tu...
> Sent: Wednesday, June 11, 2003 08 31
> To: php...@li...
> Subject: Re: [Phpwebsite-developers] Refactor of Pagemaster Search
>
>
> Richard,
>
> You've got me looking closer at the search function in pagemaster now. :)
> I think I will add a page_id column to the section table so the section
> will know it's parent.  Then it should be possible to pull all search
> results using only 2 queries as opposed to N+1 queries.  I will make sure
> there is an update in the update.php file for pagemaster and release it
> with a patch release we have planned for sometime this week.  I hope this
> will help you out as well as all our users who rely on heavy searching of
> pages.
>
> Adam
>
>> I was looking at the search module, (specifically with regard to the
>> Pagemaster module) and I noticed that the search performed in Pagemaster
>> loops through all pages and sections (with a query PER section).  That
>> means if you have N sections in your entire site, that the search
>> performs
>> exactly N+1 individual queries to the database.
>>
>> I'm working on a possible replacement for the current pagemaster search
>> function, and the only stumbling block is that I get sections, but can't
>> easily determine their parent pages from them.  I'm sure this difficulty
>> is why the current scheme was used, but I'm trying to get to where there
>> are AT MOST N+2 queries issued to the DB (and that's only if every
>> single
>> section has a match to the search criteria).
>>
>> Currently I'm looking at trying to use the 'section_order' field in the
>> pages table to determine if a given section is in a page, so I ask if
>> anyone can tell me now if that is a dead end or not.
>>
>> Any recommendations would be appreciated.
>>
>>
>> Thanks,
>>
>>
>> Ryan Roland
>>
>> Application Developer
>> Information Technology Department
>> Division of Recreational Sports
>> Indiana University
>>
>> rmroland@ind...
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
>> thread debugger on the planet. Designed with thread debugging features
>> you've never dreamed of, try TotalView 6 free at www.etnus.com.
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>
>
> --
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - Appalachian Linux Users Group
> http://alug.appstate.edu
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


-- 
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu

RE: [Phpwebsite-developers] Pagemaster & Categorizer

[<ad...@tu...>]

>> During this re-write would be the best time to try and implement
>> something
>> like this.
>
> I agree, but my fear is writing something at the same time that your team
> does (what sounds like) a major rewrite on reliant (if not the same)
> modules.  I've worked on too many projects where a lack of cooperation led
> to two versions of a function or class which led to having to rehash it
> together anyway and I want to avoid that.
>

Agreed I will try to be more clear.

>> FatCat would need a module to specify which categories it should create,
>> easy part.
>
> Not sure what you mean by 'module'...  It would need some kind of
> interface (function) that other modules could ask for categories to be
> created (which it should already have).  Maybe you used the wrong word or
> maybe I'm misunderstanding.
>

When I say module I mean it as a noun.  A module would need to specify
which categories it would create and yes fatcat would need to provide an
interface for accomplishing this if it does not already exist.

>> You would then need a method for selecting items from the
>> category without creating confusion to the user, a little harder.
>
> When you say the user, are talking about module developers or system
> users?  I agree that when users are placing items in a category, there
> needs to be a help link that explains well the use of categories.
>

Example:  selecting an image when creating a section in pagemaster.  Do
you send the user to a different screen with all the images in the
pagemaster->images category shown and the user can select it there.  Do
you show a dropdown with all the names of images contained in the
pagemaster->images category.  Or is there some easier method for selecting
those types of items.  The interface decided on would need to work for all
modules for consistancy purposes.

>> Then, once the item has been selected, you must make the page, event,
>> or link aware of the categorized item it uses, again not too bad just
>> tricky.
>
> This, I agree will be tricky, but my larger concern is whether to allow an
> item to be in more than one category.  Can an image be a Pagemaster_Image
> and a Menu_Image or should you just categorize it as just an Image, etc.
>

This is also a good question.  Should we just create some default
categories that modules could call upon like Images, Links, etc?

>> Then, you would need to take into account a categorized item that gets
>> deleted.
>> This could be the worse of it.  You would have to traverse the
>> items using the deleted categorized item and either remove it or set it
>> to
>> hidden or something.
>
> I agree, but that doesn't worry me as much as what happens if a category
> itself gets deleted.
>

Aye the inverse is probably more tricky then deleting an item.

>
> I will soon be posting a rough idea of what I'm thinking with regards to
> this modification, but I'd like some idea of what your team seems to
> already have planned for this and other mods to make sure that anything I
> write isn't in conflict with yours.
>

I look forward to hearing your thoughts on this.

>
> Thanks,
>
>
> Ryan Roland
>
> Application Developer
> Information Technology Department
> Division of Recreational Sports
> Indiana University
>
> rmroland@in...
> Office: 812.855.9617
> Cell: 812.320.0032
>
>
> -----Original Message-----
> From: adam@tu...
> Sent: Wednesday, June 11, 2003 08 48
> To: php...@li...
> Subject: Re: [Phpwebsite-developers] Pagemaster & Categorizer
>
>
> Ryan,
>
> I see your logic here.  We are going to be doing re-writes of several
> modules for the 0.9.3 release so they use the Item/Manager classes.
> During this re-write would be the best time to try and implement something
> like this.  It would require working out several issues before any
> implementation could happen.  Here's a few I can think of off the top of
> my head:
>
> FatCat would need a module to specify which categories it should create,
> easy part.  You would then need a method for selecting items from the
> category without creating confusion to the user, a little harder.  Then,
> once the item has been selected,  you must make the page, event, or link
> aware of the categorized item it uses, again not too bad just tricky.
> Then, you would need to take into account a categorized item that gets
> deleted.  This could be the worse of it.  You would have to traverse the
> items using the deleted categorized item and either remove it or set it to
> hidden or something.
>
>> Since my group has a great deal of interest in the Pagemaster module due
>> to its importance in our use of the system, I have put considerable
>> thought into it.
>>
>> One of the thoughts that I had was in regard to the Categorizer.
>> Firstly,
>> I am considering expanding Pagemaster's ability to add images to a page.
>> Obviously if people are allowed to upload their own images each time
>> they
>> want to add one to a page, it could lead to severe file duplication on
>> the
>> server.  My thought is to use the document manager to upload the images
>> and handle them.  Here's where my thought regarding the Categorizer
>> comes
>> into play.
>>
>> Say that the categorizer comes with some specific categories (i.e.
>> Pagemaster->Images, Pagemaster->Links, etc), to which administrators,
>> wishing to create a portfolio of images for use in the Pagemaster
>> module,
>> could add their images.  Then in the pagemaster module, when a page
>> creator is trying to add an image to their page, they get a portfolio of
>> images made up of all the images in Pagemaster->Images.
>>
>> This would work for other modules as well: Menuman->Links,
>> Calendar->Images, etc.
>>
>> It seems to me, and please correct me if I'm wrong, that so far the
>> categorizer module has been used to group items together within a module
>> for relevance.  All sports related pages/announcements are distinct from
>> all science related pages/announcements/etc.  The reason I think this
>> would be most beneficial is that it would take that distinction and
>> allow
>> it to be of use in the functionality of other modules (which is
>> something
>> that I don't see it being used for yet).  Plus I don't see it as being
>> too
>> much of a change in code as much as a change in the way other modules
>> use
>> the categorizer.
>>
>>
>> These are just my meandorings, but I was curious what the developer
>> comm.
>> thought about it.  Let me know if I jumped around too much and need to
>> explain anything better... I tend to ramble :)
>>
>>
>> Thanks,
>>
>>
>> Ryan Roland
>>
>> Application Developer
>> Information Technology Department
>> Division of Recreational Sports
>> Indiana University
>>
>> rmroland@in...
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
>> thread debugger on the planet. Designed with thread debugging features
>> you've never dreamed of, try TotalView 6 free at www.etnus.com.
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>
>
> --
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - Appalachian Linux Users Group
> http://alug.appstate.edu
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


-- 
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu

[Phpwebsite-developers] Bug in php_net & php_net_greeen themes

[R. S. B. <Ba...@Ba...>]

Looks like it was corrected on:  phpwebsite.appstate.edu, but not in the CVS

/themes/php_net/theme.tpl                 v 1.3
/themes/ php_net_green/theme.tpl      v 1.4
 

43  <intput type="hidden" name="module" value="search" />
44  <intput type="hidden" name="SEA_search_op" value="search" />

both should be input

Re: [Phpwebsite-developers] DB: Number of rows affected?

[<ad...@tu...>]

Those particular functions only work for specific databases.  There is a
pear function in the DB class that does the same thing but abstracts it. 
I will look into adding a function that phpwebsite developers can call
that will return the affected rows from the last query for any database
supported by phpwebsite.

Adam

> -----BEGIN PGP SIGNED MESSAGE-----
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> On 11-Jun-2003, Richard Sumilang wrote message "Re:
> [Phpwebsite-developers] DB:
> Number of rows affected?"
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Where is that method at?
>>
>
>
> http://si.php.net/manual-lookup.php?pattern=affected_rows&lang=en
>
> ~~
> Andy Harrison
> ah##@httpsite.com
> ICQ: 123472  AIM/Y!: AHinMaine
> [full headers for details]
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.8
>
> iQCVAwUBPueFV1PEkLgodAWVAQE+SQP/YYZ8Rn0WTCNzX+klffNGu6HYeCH+AfRl
> ysULUMZrkxU8oUNAqscG/Bk/uFDJuiBaLvCW9wdkrH09VbpDkoQeZPfJ/HOg8fP3
> Q9I0EcNZylUf7Yx6DY6l9GlKG1vhJlIDlo+QCl/3xhQ72OxxqL3HvDCtdPbOTrpu
> 6Ez7jRrn8ds=
> =Yw9K
> -----END PGP SIGNATURE-----
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


-- 
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu

Re: [Phpwebsite-developers] DB: Number of rows affected?

[Andy H. <ah...@ht...>]

-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 11-Jun-2003, Richard Sumilang wrote message "Re: [Phpwebsite-developers] DB:
Number of rows affected?"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Where is that method at?
> 


http://si.php.net/manual-lookup.php?pattern=affected_rows&lang=en

~~ 
Andy Harrison
ah##@httpsite.com
ICQ: 123472  AIM/Y!: AHinMaine
[full headers for details]

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPueFV1PEkLgodAWVAQE+SQP/YYZ8Rn0WTCNzX+klffNGu6HYeCH+AfRl
ysULUMZrkxU8oUNAqscG/Bk/uFDJuiBaLvCW9wdkrH09VbpDkoQeZPfJ/HOg8fP3
Q9I0EcNZylUf7Yx6DY6l9GlKG1vhJlIDlo+QCl/3xhQ72OxxqL3HvDCtdPbOTrpu
6Ez7jRrn8ds=
=Yw9K
-----END PGP SIGNATURE-----

Re: [Phpwebsite-developers] DB: Number of rows affected?

[Richard S. <ri...@ri...>]

Where is that method at?


On Wednesday, June 11, 2003, at 10:46  AM, Andy Harrison wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> On 11-Jun-2003, Richard Sumilang wrote message 
> "[Phpwebsite-developers] DB:
> Number of rows affected?"
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Is there a way to return back the number of rows affected by a query? 
>> I
>> looked in the Database class and didn't see it ???
>
>
> affected_rows (iirc).
>
> ~~
> Andy Harrison
> ah##@httpsite.com
> ICQ: 123472  AIM/Y!: AHinMaine
> [full headers for details]
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.8
>
> iQCVAwUBPudq9VPEkLgodAWVAQHgCwQAl46n8kNLgxpH2n7pgcOzN5lJhe0kclOs
> PpCptF2oTlUHpF28+FTEi9OLj09iXQCnxh8mKjpCZbVI86ttvVFm6WKI8C9FsUB2
> 3k8K9T3bBNbCRTqnZN5A29SVYtMKxXleVr+Dn4I6v8iF8IPu+snqNravrmEi4UR9
> QHFrgqa7Nmo=
> =R8x/
> -----END PGP SIGNATURE-----
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>

Re: [Phpwebsite-developers] DB: Number of rows affected?

[Andy H. <ah...@ht...>]

-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 11-Jun-2003, Richard Sumilang wrote message "[Phpwebsite-developers] DB:
Number of rows affected?"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Is there a way to return back the number of rows affected by a query? I 
> looked in the Database class and didn't see it ???


affected_rows (iirc). 

~~ 
Andy Harrison
ah##@httpsite.com
ICQ: 123472  AIM/Y!: AHinMaine
[full headers for details]

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPudq9VPEkLgodAWVAQHgCwQAl46n8kNLgxpH2n7pgcOzN5lJhe0kclOs
PpCptF2oTlUHpF28+FTEi9OLj09iXQCnxh8mKjpCZbVI86ttvVFm6WKI8C9FsUB2
3k8K9T3bBNbCRTqnZN5A29SVYtMKxXleVr+Dn4I6v8iF8IPu+snqNravrmEi4UR9
QHFrgqa7Nmo=
=R8x/
-----END PGP SIGNATURE-----

[Phpwebsite-developers] DB: Number of rows affected?

[Richard S. <ri...@ri...>]

Is there a way to return back the number of rows affected by a query? I 
looked in the Database class and didn't see it ???

RE: [Phpwebsite-developers] Pagemaster & Categorizer

[Roland, R. M <rmr...@in...>]

> During this re-write would be the best time to try and implement =
something
> like this.

I agree, but my fear is writing something at the same time that your =
team does (what sounds like) a major rewrite on reliant (if not the =
same) modules.  I've worked on too many projects where a lack of =
cooperation led to two versions of a function or class which led to =
having to rehash it together anyway and I want to avoid that.

> FatCat would need a module to specify which categories it should =
create,
> easy part.

Not sure what you mean by 'module'...  It would need some kind of =
interface (function) that other modules could ask for categories to be =
created (which it should already have).  Maybe you used the wrong word =
or maybe I'm misunderstanding.

> You would then need a method for selecting items from the
> category without creating confusion to the user, a little harder.

When you say the user, are talking about module developers or system =
users?  I agree that when users are placing items in a category, there =
needs to be a help link that explains well the use of categories.

> Then, once the item has been selected, you must make the page, event,
> or link aware of the categorized item it uses, again not too bad just =
tricky.

This, I agree will be tricky, but my larger concern is whether to allow =
an item to be in more than one category.  Can an image be a =
Pagemaster_Image and a Menu_Image or should you just categorize it as =
just an Image, etc.

> Then, you would need to take into account a categorized item that gets =
deleted.
> This could be the worse of it.  You would have to traverse the
> items using the deleted categorized item and either remove it or set =
it to
> hidden or something.

I agree, but that doesn't worry me as much as what happens if a category =
itself gets deleted.


I will soon be posting a rough idea of what I'm thinking with regards to =
this modification, but I'd like some idea of what your team seems to =
already have planned for this and other mods to make sure that anything =
I write isn't in conflict with yours.


Thanks,


Ryan Roland

Application Developer
Information Technology Department
Division of Recreational Sports
Indiana University

rmroland@in...
Office: 812.855.9617
Cell: 812.320.0032


-----Original Message-----
From: adam@tu...
Sent: Wednesday, June 11, 2003 08 48
To: php...@li...
Subject: Re: [Phpwebsite-developers] Pagemaster & Categorizer


Ryan,

I see your logic here.  We are going to be doing re-writes of several
modules for the 0.9.3 release so they use the Item/Manager classes.=20
During this re-write would be the best time to try and implement =
something
like this.  It would require working out several issues before any
implementation could happen.  Here's a few I can think of off the top of
my head:

FatCat would need a module to specify which categories it should create,
easy part.  You would then need a method for selecting items from the
category without creating confusion to the user, a little harder.  Then,
once the item has been selected,  you must make the page, event, or link
aware of the categorized item it uses, again not too bad just tricky.=20
Then, you would need to take into account a categorized item that gets
deleted.  This could be the worse of it.  You would have to traverse the
items using the deleted categorized item and either remove it or set it =
to
hidden or something.

> Since my group has a great deal of interest in the Pagemaster module =
due
> to its importance in our use of the system, I have put considerable
> thought into it.
>
> One of the thoughts that I had was in regard to the Categorizer.  =
Firstly,
> I am considering expanding Pagemaster's ability to add images to a =
page.
> Obviously if people are allowed to upload their own images each time =
they
> want to add one to a page, it could lead to severe file duplication on =
the
> server.  My thought is to use the document manager to upload the =
images
> and handle them.  Here's where my thought regarding the Categorizer =
comes
> into play.
>
> Say that the categorizer comes with some specific categories (i.e.
> Pagemaster->Images, Pagemaster->Links, etc), to which administrators,
> wishing to create a portfolio of images for use in the Pagemaster =
module,
> could add their images.  Then in the pagemaster module, when a page
> creator is trying to add an image to their page, they get a portfolio =
of
> images made up of all the images in Pagemaster->Images.
>
> This would work for other modules as well: Menuman->Links,
> Calendar->Images, etc.
>
> It seems to me, and please correct me if I'm wrong, that so far the
> categorizer module has been used to group items together within a =
module
> for relevance.  All sports related pages/announcements are distinct =
from
> all science related pages/announcements/etc.  The reason I think this
> would be most beneficial is that it would take that distinction and =
allow
> it to be of use in the functionality of other modules (which is =
something
> that I don't see it being used for yet).  Plus I don't see it as being =
too
> much of a change in code as much as a change in the way other modules =
use
> the categorizer.
>
>
> These are just my meandorings, but I was curious what the developer =
comm.
> thought about it.  Let me know if I jumped around too much and need to
> explain anything better... I tend to ramble :)
>
>
> Thanks,
>
>
> Ryan Roland
>
> Application Developer
> Information Technology Department
> Division of Recreational Sports
> Indiana University
>
> rmroland@in...
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The =
best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


--=20
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu



-------------------------------------------------------
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.
_______________________________________________
Phpwebsite-developers mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers

RE: [Phpwebsite-developers] Refactor of Pagemaster Search

[Roland, R. M <rmr...@in...>]

Adam,

First off, as much as I respect Richard, I'm not him. :)  But I =
understand, those 'R' names just start to run together.  Secondly, that =
search function I sent you for pagemaster should only use 2 queries.  =
However, because I tried to avoid changing anything other than that =
function, I had to do alot of array jumping and searching to determine =
what page a section belonged to.  It's not pretty, but adding that field =
to the sections table would greatly simplify the process. =20

Actually, I wrote this post to the mailing list a good three weeks ago, =
but it seemed it took awhile to get moderated to the list.  Not sure how =
to get around this though.=20



Thanks,


Ryan Roland

Application Developer
Information Technology Department
Division of Recreational Sports
Indiana University

rmroland@in...
Office: 812.855.9617
Cell: 812.320.0032


-----Original Message-----
From: adam@tu...
Sent: Wednesday, June 11, 2003 08 31
To: php...@li...
Subject: Re: [Phpwebsite-developers] Refactor of Pagemaster Search


Richard,

You've got me looking closer at the search function in pagemaster now. =
:)
I think I will add a page_id column to the section table so the section
will know it's parent.  Then it should be possible to pull all search
results using only 2 queries as opposed to N+1 queries.  I will make =
sure
there is an update in the update.php file for pagemaster and release it
with a patch release we have planned for sometime this week.  I hope =
this
will help you out as well as all our users who rely on heavy searching =
of
pages.

Adam

> I was looking at the search module, (specifically with regard to the
> Pagemaster module) and I noticed that the search performed in =
Pagemaster
> loops through all pages and sections (with a query PER section).  That
> means if you have N sections in your entire site, that the search =
performs
> exactly N+1 individual queries to the database.
>
> I'm working on a possible replacement for the current pagemaster =
search
> function, and the only stumbling block is that I get sections, but =
can't
> easily determine their parent pages from them.  I'm sure this =
difficulty
> is why the current scheme was used, but I'm trying to get to where =
there
> are AT MOST N+2 queries issued to the DB (and that's only if every =
single
> section has a match to the search criteria).
>
> Currently I'm looking at trying to use the 'section_order' field in =
the
> pages table to determine if a given section is in a page, so I ask if
> anyone can tell me now if that is a dead end or not.
>
> Any recommendations would be appreciated.
>
>
> Thanks,
>
>
> Ryan Roland
>
> Application Developer
> Information Technology Department
> Division of Recreational Sports
> Indiana University
>
> rmroland@ind...
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The =
best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


--=20
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu



-------------------------------------------------------
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.
_______________________________________________
Phpwebsite-developers mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers