phpwebsite-developers

[Phpwebsite-developers] current page id

[Ton O. <ton...@he...>]

I am trying to change the functionality of the menumanager a little and need
to detect the page to be displayed. Anyone knows how to do this?

I can detect the requested modules, but how to get the curently displayed
page from this?

I tried a lot of things. The best I got is the id of the previous page. So
the id is only correct if I refresh the page.

Please help.

Re: [Phpwebsite-developers] current page id

[Shaun M. <sh...@ae...>]

On 13 Oct 2004, at 15:59, Ton Oosterhoff wrote:

> I am trying to change the functionality of the menumanager a little 
> and need to detect the page to be displayed. Anyone knows how to do 
> this?
>

To detect the pagemaster page?

Have a look at the phpwsRSSfeeds module which has both a method of 
specifying the page and detecting it.

Shaun
aegis design - http://www.aegisdesign.co.uk

[Phpwebsite-developers] Wierd problem with install.sql INSERT

[Tony M. <to...@ht...>]

I have kind of a strange one, and I'm wondering if it's a bug, or if I'm 
just doing something stupid.

I am deep into the Cigar Diary conversion, and it's going quite well.  I 
think I'm going to be REALLY pleased when it's finished, but I've come to 
a little speed bump.

I create the cigar table and then I insert one line into it.  This is 
supposed to be the "cigar not designated" entry, but install will not 
create this record properly.  Here is my install.sql code for this:

##
CREATE TABLE mod_cigardiary_cigar (
  id int NOT NULL default '0',
  owner varchar(20) default NULL,
  editor varchar(20) default NULL,
  ip text,
  label text NOT NULL,
  created int NOT NULL default '0',
  updated int NOT NULL default '0',
  hidden smallint NOT NULL default '1',
  approved smallint NOT NULL DEFAULT '0',
  active smallint NOT NULL DEFAULT '0',
  brand varchar(30) NOT NULL,
  style varchar(30) NOT NULL,
  shape varchar(30),
  origin smallint(5) unsigned,
  wrapper int(10) unsigned,
  binder int(10) unsigned,
  filler int(10) unsigned,
  color smallint(5) unsigned,
  ring smallint(5) unsigned,
  length smallint(5) unsigned,
  PRIMARY KEY (id)
);

INSERT INTO mod_cigardiary_cigar
VALUES (0, 'Install', 'Install', '0.0.0.0', 'Not Designated',
        UNIX_TIMESTAMP(),UNIX_TIMESTAMP(), 0, 1, 1, 'Not Designated',
        'Not Designated', 'Not Designated', 0, 0, 0, 0, 0, 0, 0);
##

This looks to me, ok.  When I issue the install, I get the following 
listing:

##
List of Cigars 
  ID  Label  Owner  Editor  Created  Updated  Hidden  Approved  
  1 0.0.0.0 0 Install 12/31/1969 07:00 12/31/1969 07:00 Hidden Approved 
##

Everything appears to be shifted one to the right, and the dates are all 
wrong.

When I check the actual table contents, I get this:

##
mysql> select * from cd_mod_cigardiary_cigar;
+----+-------+---------+---------+---------+---------+---------+--------+----------+--------+----------------+----------------+-------+--------+---------+--------+--------+-------+------+--------+
| id | owner | editor  | ip      | label   | created | updated | hidden | 
approved | active | brand          | style          | shape | origin | 
wrapper | binder | filler | color | ring | length |
+----+-------+---------+---------+---------+---------+---------+--------+----------+--------+----------------+----------------+-------+--------+---------+--------+--------+-------+------+--------+
|  1 | NULL  | Install | Install | 0.0.0.0 |       0 |       0 |      1 |        
1 |      0 | Not Designated | Not Designated | 0     |      0 |       0 |      
0 |      0 |     0 |    0 |   NULL |
+----+-------+---------+---------+---------+---------+---------+--------+----------+--------+----------------+----------------+-------+--------+---------+--------+--------+-------+------+--------+
1 row in set (0.00 sec)
##

This is NOT what I asked for.  When I cut and paste the line into MySQL 
(adding the cd_ to the table name) it works perfectly.

This is not a major issue, since I can create the record easily by hand, 
but I don't think I should have to.  Did I do something wrong, and if so, 
what is it?

Thanks,

-Tony

-- 
Hometown Enterprises Internet Services
Professional, affordable web design and hosting.
http://www.hteis.com/

Re: [Phpwebsite-developers] Wierd problem with install.sql INSERT

[Ulf H. <U1...@ul...>]

Tony,

uhm -- am i mistaken or is this a column order issue?
On a first look, I believe you got what you asked for.

Possible solution:
Re-order the values in the insert statement, or add the designated 
columns names to the insert statement.

I apologize if this answer too simple b/c I did not undertand your 
problem. ;)

Ulf

PS:
I wonder why this list keeps telling me that my mails have a suspicious 
header.
Is this because I am asking dumb questions or because I am writing 
stupid answers.....?


 Miller wrote:

>I have kind of a strange one, and I'm wondering if it's a bug, or if I'm 
>just doing something stupid.
>
>I am deep into the Cigar Diary conversion, and it's going quite well.  I 
>think I'm going to be REALLY pleased when it's finished, but I've come to 
>a little speed bump.
>
>I create the cigar table and then I insert one line into it.  This is 
>supposed to be the "cigar not designated" entry, but install will not 
>create this record properly.  Here is my install.sql code for this:
>
>##
>CREATE TABLE mod_cigardiary_cigar (
>  id int NOT NULL default '0',
>  owner varchar(20) default NULL,
>  editor varchar(20) default NULL,
>  ip text,
>  label text NOT NULL,
>  created int NOT NULL default '0',
>  updated int NOT NULL default '0',
>  hidden smallint NOT NULL default '1',
>  approved smallint NOT NULL DEFAULT '0',
>  active smallint NOT NULL DEFAULT '0',
>  brand varchar(30) NOT NULL,
>  style varchar(30) NOT NULL,
>  shape varchar(30),
>  origin smallint(5) unsigned,
>  wrapper int(10) unsigned,
>  binder int(10) unsigned,
>  filler int(10) unsigned,
>  color smallint(5) unsigned,
>  ring smallint(5) unsigned,
>  length smallint(5) unsigned,
>  PRIMARY KEY (id)
>);
>
>INSERT INTO mod_cigardiary_cigar
>VALUES (0, 'Install', 'Install', '0.0.0.0', 'Not Designated',
>        UNIX_TIMESTAMP(),UNIX_TIMESTAMP(), 0, 1, 1, 'Not Designated',
>        'Not Designated', 'Not Designated', 0, 0, 0, 0, 0, 0, 0);
>##
>
>This looks to me, ok.  When I issue the install, I get the following 
>listing:
>
>##
>List of Cigars 
>  ID  Label  Owner  Editor  Created  Updated  Hidden  Approved  
>  1 0.0.0.0 0 Install 12/31/1969 07:00 12/31/1969 07:00 Hidden Approved 
>##
>
>Everything appears to be shifted one to the right, and the dates are all 
>wrong.
>
>When I check the actual table contents, I get this:
>
>##
>mysql> select * from cd_mod_cigardiary_cigar;
>+----+-------+---------+---------+---------+---------+---------+--------+----------+--------+----------------+----------------+-------+--------+---------+--------+--------+-------+------+--------+
>| id | owner | editor  | ip      | label   | created | updated | hidden | 
>approved | active | brand          | style          | shape | origin | 
>wrapper | binder | filler | color | ring | length |
>+----+-------+---------+---------+---------+---------+---------+--------+----------+--------+----------------+----------------+-------+--------+---------+--------+--------+-------+------+--------+
>|  1 | NULL  | Install | Install | 0.0.0.0 |       0 |       0 |      1 |        
>1 |      0 | Not Designated | Not Designated | 0     |      0 |       0 |      
>0 |      0 |     0 |    0 |   NULL |
>+----+-------+---------+---------+---------+---------+---------+--------+----------+--------+----------------+----------------+-------+--------+---------+--------+--------+-------+------+--------+
>1 row in set (0.00 sec)
>##
>
>This is NOT what I asked for.  When I cut and paste the line into MySQL 
>(adding the cd_ to the table name) it works perfectly.
>
>This is not a major issue, since I can create the record easily by hand, 
>but I don't think I should have to.  Did I do something wrong, and if so, 
>what is it?
>
>Thanks,
>
>-Tony
>
>  
>