phpwebsite-developers — For our development team.

Re: [Phpwebsite-developers] Form Class

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

> The form class has a lot of great stuff for generating a form real
> quick however I feel it is very limited.

We are trying to phase out the current core class to the more flexible
EZform class. Please take a look and let us know if there are options you
would like to see in it.

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

Re: [Phpwebsite-developers] Poor IE

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

Holly shit! That is just sooo rude!

But anyways, how does Microsoft plan to rule the world if they keep  
crashing?


On Saturday, May 3, 2003, at 08:37  AM, Steven Levin wrote:

> Hello all,
>
>   Check out this article running on /.  Seems as though you can wreck  
> shop
> for IE with just a little HTML.  I was able to view it just fine in
> Phoenix :)
>
> http://slashdot.org/articles/03/05/02/ 
> 1845241.shtml?tid=126&tid=95&tid=128&tid=113
>
>
> -- 
> Steven Levin
> Electronic Student Services
> Appalachian State University
> Phone: 828.262.2431
> PhpWebsite Development Team
> URL: http://phpwebsite.appstate.edu
> Email: st...@NO...
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>

[Phpwebsite-developers] Form Class

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

The form class has a lot of great stuff for generating a form real 
quick however I feel it is very limited. My personal concern in it is 
that it does not have a parameter to disabled a form element but that's 
just one out of many possible problems that can be upcoming. Maybe it 
would be better if we add one more parameters to each one of the form 
elements called 'misc' or something that lets us add our own code to 
the form element rather than having too many parameters in the function 
itself for each possible piece of code that can be typed inside a tag 
so they wont be very limited? That will prove to be really helpful!

Best Regards,
Richard Sumilang

[Phpwebsite-developers] Poor IE

[Steven L. <st...@tu...>]

Hello all,

  Check out this article running on /.  Seems as though you can wreck shop
for IE with just a little HTML.  I was able to view it just fine in
Phoenix :)

http://slashdot.org/articles/03/05/02/1845241.shtml?tid=126&tid=95&tid=128&tid=113


-- 
Steven Levin
Electronic Student Services
Appalachian State University
Phone: 828.262.2431
PhpWebsite Development Team
URL: http://phpwebsite.appstate.edu
Email: st...@NO...

Re: [Phpwebsite-developers] Reloading cached module manager after upgrade

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

Just to follow up, I was able to set the session manager to NULL and 
unset() it in the update.php, and then core reloaded it afterwards for me, 
so that was the trick.

Thanks to the krew in #phpwebsite.

Don.

On Wed, 23 Apr 2003, Don Seiler wrote:

> Wondering how I can force my module's "Manager" class to reload itself, or 
> at least make calls the various load functions after the module is 
> upgraded to the latest version.
> 
> For now I just print a message asking the admin to log out and back in.
> 
> Basically I've tried making calls to $_SESSION["SES_LISTINGS_MANAGER"] or 
> redefining it.  I do that from my update.php script but it doesn't seem to 
> want to work, as I get errors about not being able to find the item class 
> definition.
> 
> Just wondering what you guys recommend.
> 
> Don.
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> 

Re: [Phpwebsite-developers] Re: Bulletin Board Module

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

I saw that someone made a wrapper module for phpBB.  I'd like to do the 
same for phorum, which is a more lightweight BB than phpBB.  Does anyone 
have any docs on doing this "wrapper" modules?

Don.

On Thu, 17 Apr 2003, Patrick Naubert wrote:

> Eloi had a  BB module for 0.9.x almost completed.
> 
> I would like to Beta test or help finish it off.  I need it immediatly for a
> new installation of 0.9.1
> 
> Thanks
> 
> Pat
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> 

Re: [Phpwebsite-developers] Payroll

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

> That sounds like a it would be a nice mod?

matt == moron

I mistakenly send to this list to often.

Matt

Re: [Phpwebsite-developers] It's not the Classes, it's the Queries

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

Wow.  You got on that immediately.  Every day you find more ways to impress
me!

> Some of the reasons you are seeing all these extra SQL calls is that we
> received another warning a few months ago.
>
> That warning was that we were using far too much memory. So we reduced the
> dependance on the GLOBALS array.

Yes, but I thought the warning was more about -duplicate- information being
stored.

> So the question is, which is it? Do we want to depend upon the database
> each time to get our information? Or do you want offload some of the work
> by storing results in GLOBALS?

I personally feel that the DB always needs to be treated as a bottleneck by
encapsulating the work to be done in each - the DB should handle ordering &
filtering and the accesses should be as gross or greedy as possible.  All
other manipulation should be done on the front end.  All data retrieved
should be freed from memory as soon as it's not needed - if I query data and
fetch_ it into an array and then pass it by value to another function to
write to other variables, then there's probably 3 or four copies of the data
hanging around before the PHP compiler starts garbage collection.

Others may feel different, so I agree with your choice to let us select our
method in the cache config.

> Now that we know that classes eat up most of the memory, we may decide to
> place some data back and reduce DB calls.

That'd be great!

-Eloi-

Re: [Phpwebsite-developers] Payroll

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

That sounds like a it would be a nice mod?


On Thursday, May 1, 2003, at 09:05  AM, Matthew McNaney wrote:

> Need your time sheets by Friday at 11:00am. If I am not in, put them 
> in my
> box.
>
> Matt
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>

[Phpwebsite-developers] Payroll

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

Need your time sheets by Friday at 11:00am. If I am not in, put them in my
box.

Matt

Re: [Phpwebsite-developers] Transparent PNG's and Interent Explorer

[Mike W. <wi...@ce...>]

Here is more on the subject if you want to make your own code.
http://msdn.microsoft.com/workshop/author/filter/reference/filters/alphaimag
eloader.asp


Mike Windsor



----- Original Message -----
From: "Matthew McNaney" <ma...@tu...>
To: <php...@li...>
Sent: Thursday, May 01, 2003 9:24 AM
Subject: Re: [Phpwebsite-developers] Transparent PNG's and Interent Explorer


> > Hey remember that IE doesn't support transparent png's using alpha
channel
> > transparency?  Well someone has written a php script that will detect
the
> > browser and add a specific filter and make it work.  Here is the link
> > http://www.artisfaction.com/transparent_png/  or you can download it
> > directly at http://www.artisfaction.com/transparent_png/Trans_PNG.zip
> >
> > I haven't looked at it yet but the samples work.  I think theme
developers
> > could include it if I'm not mistaken.
> >
>
> Cool. We could have it work with imageTag.
>
> Matt
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>

Re: [Phpwebsite-developers] Transparent PNG's and Interent Explorer

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

> Hey remember that IE doesn't support transparent png's using alpha channel
> transparency?  Well someone has written a php script that will detect the
> browser and add a specific filter and make it work.  Here is the link
> http://www.artisfaction.com/transparent_png/  or you can download it
> directly at http://www.artisfaction.com/transparent_png/Trans_PNG.zip
>
> I haven't looked at it yet but the samples work.  I think theme developers
> could include it if I'm not mistaken.
>

Cool. We could have it work with imageTag.

Matt

[Phpwebsite-developers] Transparent PNG's and Interent Explorer

[Mike W. <wi...@ce...>]

Hey remember that IE doesn't support transparent png's using alpha channel
transparency?  Well someone has written a php script that will detect the
browser and add a specific filter and make it work.  Here is the link
http://www.artisfaction.com/transparent_png/  or you can download it
directly at http://www.artisfaction.com/transparent_png/Trans_PNG.zip

I haven't looked at it yet but the samples work.  I think theme developers
could include it if I'm not mistaken.

winzor

Re: [Phpwebsite-developers] It's not the Classes, it's the Queries

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

Update:

Found some repeaters. Some old code that need fixin'.

Matt

Re: [Phpwebsite-developers] It's not the Classes, it's the Queries

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

Update:

I have added another variable to the cache config file. Setting
GLOBAL_CACHE to TRUE will create a global variable that will store that
page's cache calls. Information in that array will be returned instead of
accessing the database.

If you prefer to always use the database, setting this to FALSE will allow
it.

If you prefer not to use caching, turn it off. If you prefer not to use
page caching (caching templates instead of accessing the files) you can
turn this off as well.

Matt

Re: [Phpwebsite-developers] It's not the Classes, it's the Queries

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

Some of the reasons you are seeing all these extra SQL calls is that we
received another warning a few months ago.

That warning was that we were using far too much memory. So we reduced the
dependance on the GLOBALS array.

For example, the Cache used to store the information in the GLOBALS array
so it would not have to be called more than once. This was removed to
reduced the size of the GLOBALS array. Now the DB is called each time.

So the question is, which is it? Do we want to depend upon the database
each time to get our information? Or do you want offload some of the work
by storing results in GLOBALS?

Now that we know that classes eat up most of the memory, we may decide to
place some data back and reduce DB calls.

Matt

Re: [Phpwebsite-developers] It's not the Classes, it's the Queries

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

> Hey all.
>
> I had the weirdest dream...

I will run the same test today and see if I can eliminate some duplicates.

Matt

Re: [Phpwebsite-developers] It's not the Classes, it's the Queries

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

While yes that is disturbing, I thought we were trying to cut down on 
memory usage?  Or do you mean store them in memory just for that page load 
and then destroy them?

Don.

On Thu, 1 May 2003, Eloi George wrote:

> Hey all.
> 
> I had the weirdest dream.  At one point I'm riding a bicycle (badly) through
> the surf & this narrator kept repeating over and over something about every
> time a query is received the mySQL server has to parse, optimise, build
> tables, access, analyze & report data.
> 
> When I woke up, I trundled over to my system & inserted this line in
> database.php @line 92:
> echo $sql.'<br />';
> 
> What I saw next really troubled me.
> 
> My 0.91cvs testbed homepage queried the server 1,061 times!  I next called
> up an Announce article
> (http://www.realvidreams.com/testbed/index.php?module=announce&ANN_user_op=v
> iew&ANN_id=42) and the query count dropped to a still hefty 462 times!
> 
> I could understand if the server was busy pulling up relevant data, but a
> lot of the queries were duplicates!  Take this for instance:
> 
> select * from 4_modules where mod_title = 'calendar'
> 
> Did that really need to be done 63 times to create 1 homepage?  This was
> almost rivalled by:
> 
> select * from 4_cache where mod_title = 'calendar' and id =
> '4124aabad14bfcc1d0d0b8840b98b0b1'
> which showed up 29 times!
> 
> MenuMan was another area of concern.  If we need to build a tree it would be
> better to load all data into memory, assemble the relationships and
> immediately unset() whatever data we don't need.  Especially if your SQL
> server is on a different machine or (Oh God, No!) behind an ODBC driver.
> That method would also cut down significantly on the 206 queries that were
> generated.
> 
> The cache table was queried 717 times.  Of that, stuff was selected 120
> times, inserted 149 times, & deleted 299 times.  My sleep-addled brain
> didn't want to find out what happened on the remaining 149 queries.  Would
> phpWS still work if it wrote to the cache -after- it finished working with
> all the data?
> 
> Menuman & Calendar seem to be the biggest culprits, but I'm also seeing
> duplicates of queries like these:
> select * from 4_modules where mod_title = 'fatcat'
> select * from 4_modules where mod_title = 'comments'
> where just doing a global SELECT and storing the values in memory can reduce
> the query count by 74.
> 
> All this leads me to believe that phpWS's performance problems are more due
> to excessive database usage than classes.
> 
> -Eloi-
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> 

[Phpwebsite-developers] It's not the Classes, it's the Queries

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

Hey all.

I had the weirdest dream.  At one point I'm riding a bicycle (badly) through
the surf & this narrator kept repeating over and over something about every
time a query is received the mySQL server has to parse, optimise, build
tables, access, analyze & report data.

When I woke up, I trundled over to my system & inserted this line in
database.php @line 92:
echo $sql.'<br />';

What I saw next really troubled me.

My 0.91cvs testbed homepage queried the server 1,061 times!  I next called
up an Announce article
(http://www.realvidreams.com/testbed/index.php?module=announce&ANN_user_op=v
iew&ANN_id=42) and the query count dropped to a still hefty 462 times!

I could understand if the server was busy pulling up relevant data, but a
lot of the queries were duplicates!  Take this for instance:

select * from 4_modules where mod_title = 'calendar'

Did that really need to be done 63 times to create 1 homepage?  This was
almost rivalled by:

select * from 4_cache where mod_title = 'calendar' and id =
'4124aabad14bfcc1d0d0b8840b98b0b1'
which showed up 29 times!

MenuMan was another area of concern.  If we need to build a tree it would be
better to load all data into memory, assemble the relationships and
immediately unset() whatever data we don't need.  Especially if your SQL
server is on a different machine or (Oh God, No!) behind an ODBC driver.
That method would also cut down significantly on the 206 queries that were
generated.

The cache table was queried 717 times.  Of that, stuff was selected 120
times, inserted 149 times, & deleted 299 times.  My sleep-addled brain
didn't want to find out what happened on the remaining 149 queries.  Would
phpWS still work if it wrote to the cache -after- it finished working with
all the data?

Menuman & Calendar seem to be the biggest culprits, but I'm also seeing
duplicates of queries like these:
select * from 4_modules where mod_title = 'fatcat'
select * from 4_modules where mod_title = 'comments'
where just doing a global SELECT and storing the values in memory can reduce
the query count by 74.

All this leads me to believe that phpWS's performance problems are more due
to excessive database usage than classes.

-Eloi-

[Phpwebsite-developers] phpwsListings 0.2.0 Released

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

phpwsListings is a PHPWebSite (>= 0.9.1) module that allows a site admin
to run a listings site for virtually any type of item, from houses to cars
to books. Admins can set the fields and field types, and all fields are
searchable.

phpwsListings 0.2.0 includes many bug fixes. Notable feature additions
include the listing class which allows the site to list more than one type
of item. Price field is now optional as well.

It is STRONGLY recommended that you read the INSTALL instruction in the
docs directory if you are upgrading from 0.2.0. The upgrade itself is
painless, but the note about the default class is important to know.

phpwsListings can be downloaded from the Files section of
http://phpwslistings.sourceforge.net.

Re: [Phpwebsite-developers] Conversion

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

This should be correct. I have run conversion on our sites under the same
conditions.  You should be able to upgrade straight from 0.8.2 to 0.9.x
also.  I just can not say this with 100% certainty, but it should work.

Just a little note on conversion.  If you get odd errors first look at the
old DB. Sometimes a bad record will make it in and this will cause
trouble.  Removing the problem(bad record) and reconverting will fix it.

> Just writing to confirm that I can upgrade an 0.8.3 site to 0.9.1
> directly, and that I don't have to first upgrade to 0.9.0.
>
> Holla back.
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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

[Phpwebsite-developers] Conversion

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

Just writing to confirm that I can upgrade an 0.8.3 site to 0.9.1 
directly, and that I don't have to first upgrade to 0.9.0.

Holla back.

[Phpwebsite-developers] phpwsListings 0.2.0 RC 2

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

Just an FYI to anyone interested that last night we released phpwsListings 
0.2.0 RC 2.  Fixed some bugs found since RC1, as well as cleaned up the 
update process.

Feel free to download and install (requires phpWebSite 0.9.1) and let us 
know what you think.

http://phpwslistings.sf.net

Don.

[Phpwebsite-developers] Reloading cached module manager after upgrade

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

Wondering how I can force my module's "Manager" class to reload itself, or 
at least make calls the various load functions after the module is 
upgraded to the latest version.

For now I just print a message asking the admin to log out and back in.

Basically I've tried making calls to $_SESSION["SES_LISTINGS_MANAGER"] or 
redefining it.  I do that from my update.php script but it doesn't seem to 
want to work, as I get errors about not being able to find the item class 
definition.

Just wondering what you guys recommend.

Don.

[Phpwebsite-developers] using links to submit forms

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

Is there a way to use a normal href tag to submit a form without using 
javascript?  Or is using javascript such a bad thing?

I want to have a form in a menu block but the submit buttons are so hugh 
it's ugly.

Don.