openfc-tech Mailing List for Frequency Clock

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

database has a few changes so make sure its updated (sql is up todatye in
/sql/create.php) okey doke?

:-)

adam

beta 01 in the cvs....

:-)

adam

new table added (design)

i think this will be a  temp addition as i wanna get rid oif it and just
use fields in the timetable table for design...stilll for now we need
it...all details in the sql page

adam
"free, as in 'radio'"

add timezones.php to your conf file

got the timezone bastard...on the server now but not in cvs yet, i will
test it a bit first

man thats was nuts...it was so simple but so HARD!!!!

i hope i grow up to be a real programmer one day (a real one that still
knows how to have a life ;-)  )

adam

ok...so i think taht list of priorities are:
1. fix overlapping bug for scheduling progs
2. fix timetable layout bug
3. get timezones happening....all scheduling,displaying of timetables,
displaying program guides should be as local time...but all storage of
times in the db should be in GMT
4. get player finished

javascript can identify the number of minutes your machine is +/- GMT...

so in the head of the head() function I have put the following:
<script language=\"JavaScript\">
function timezones() {
it=new Date();
tzvar=it.getTimezoneOffset();
document.cookie=\"tz=\"+tzvar;
}
</script>

this means that anywhere in the fc you can now access the timezzone by
using the variable $tz

$tz is in minutes, if the value is negative it will read as a negative
(eg. '-60') else it just displays as an integer

the timezone also accounts for summertime etc....cool!

so...this can be easily converted to use with unix timestamps of
course...

adam

dont include escalendar.php, i just put the same function in mag.php where
it should be
i have deleted it( escalendar.php) from the cvs

adam

be sure to add escalendar to the libs

new file 'playlist.php' added to top dir

archives.php
mag.php

delete magazine.php (replaced by mag.php)

CREATE TABLE playlists (
  ID bigint(20) NOT NULL auto_increment,
  name varchar(10),
  ownerID int(11),
  pArray varchar(100),
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE = MYISAM;

Adam Hyde
XS4ALL Internet B.V.
mobile : + (31) 06 2903 6248

Eekholt 42
1112 XH
Diemen
Amsterdam

"free, as in 'radio'"

adam wrote:
> check out the multiple program add...it works! (on montevideo server)

AMAZING!

and overlap-check is already in! superb.

> i found out how we need to do cvs...make sure BEFORE you commit a file you
> first UPDATE it from the server, it then merges your changes with whatever
> changes that have been committed toi cvs already THEN commit your file
> (you might need to check it first for possible conflicts)

ok. seems logical indeed. we can stick to that :)

t'morrow.
ll.

-- 
-
- luka nova at skylined dot org -

_
_

_

check out the multiple program add...it works! (on montevideo server)

i found out how we need to do cvs...make sure BEFORE you commit a file you
first UPDATE it from the server, it then merges your changes with whatever
changes that have been committed toi cvs already THEN commit your file
(you might need to check it first for possible conflicts)

adam

Adam Hyde
XS4ALL Internet B.V.
mobile : + (31) 06 2903 6248

Eekholt 42
1112 XH
Diemen
Amsterdam

"free, as in 'radio'"

hey luka

i am putting a list of all the functions in an include file at the top of
the include file like this:
# progr.php
#CONTAINS:
	#programForm
	#listProgram
	#listAllPrograms
	#listUserPrograms
	#addProgram
	#editProgram
	#deleteProgram
	#dropCategories

Also, I have put programForm in the progr.php file not the html.php as
this makes more sense i think...html.php should purely be for html
elements like drop downs etc that get re-used in may places

adam

Hi,

I just put up the first beta of the Frequency Clock server at :
http://frequencyclock.montevideo.nl/index.php

For those that don't know, there are 2 primary developers - me (adam), and
Luka Princic.

For the purpose of the testing its best we dont tell you anything at first
about how to use the Frequency Clock. However you might want to imagine
that you have an archive of streaming media files of different types and
you want to make a continuous program out of these files. Note: the player
side of this application is not yet ready for testing, so its just the
backend that you need to test. Also, please note that no graphic design
has been applied to the interface yet.

If you decide you would like to read more about the project then please
look at these files:
https://sourceforge.net/docman/?group_id=38535

To report Bugs please user the bug tracker:
https://sourceforge.net/tracker/?group_id=38535&atid=422581

If you report a bug please include as much detailed information as
possible. Screen shots where possible are a huge help (the bug tracker
has a facility for uploading these).

If you have a feature you would like to see, please use this form:
https://sourceforge.net/tracker/?func=add&group_id=38535&atid=422584

Also, please can everyone that will test join this list:
http://lists.sourceforge.net/lists/listinfo/openfc-development

I hope to see some juicy bug reports soon! ;-)

Adam Hyde
XS4ALL Internet B.V.
mobile : + (31) 06 2903 6248

Eekholt 42
1112 XH
Diemen
Amsterdam

"free, as in 'radio'"

I madse 3 changes in total to fields, so here is the correct format of the
db as of sunday June 8, 12:00

-- default mysql.database creation script
-- change localhost if you are using separate
-- sql server, .. change at least mypass

CREATE DATABASE openfc;
GRANT INSERT,DELETE,UPDATE,SELECT ON openfc.* TO openfc@localhost
IDENTIFIED BY 'mypass';
FLUSH PRIVILEGES;
USE openfc
CREATE TABLE events (
  ID bigint(20) NOT NULL auto_increment,
  programID int(11) default NULL,
  timetableID int(11) default NULL,
  datetimebegin varchar(20) default NULL,
  elength varchar(10) default NULL,
  datetimeend varchar(20) default NULL,
  recurring varchar(20) default 'no',
  recurr_end varchar(20) default NULL,
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE genres (
  ID bigint(20) NOT NULL auto_increment,
  genre varchar(50) default NULL,
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE programs (
  ID bigint(20) NOT NULL auto_increment,
  name varchar(80) default NULL,
  url text,
  description text,
  length varchar(50) default NULL,
  ownerID int(11) default NULL,
  genreID int(11) default NULL,
  category varchar(80) default NULL,
  format text,
  codec varchar(20) NOT NULL default 'unknown',
  permissions varchar(10) NOT NULL default 'owner',
  bitrate varchar(15) NOT NULL default '56k',
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE timetables (
  ID bigint(20) NOT NULL auto_increment,
  name varchar(200) default NULL,
  description text,
  owner varchar(20) default NULL,
  pagecolor varchar(10) NOT NULL default '#000000',
  tablecolor varchar(10) NOT NULL default '#808080',
  font varchar(40) NOT NULL default 'Geneva, Arial, Helvetica',
  fontcolor varchar(10) NOT NULL default '#FFFFFF',
  fontsize varchar(5) NOT NULL default '-2',
  users varchar(200) default NULL,
  subscribers varchar(200) default NULL,
  logo varchar(100) default NULL,
  pagetext varchar(200) default NULL,
  days char(2) default '7',
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

CREATE TABLE users (
  ID int(5) NOT NULL auto_increment,
  user varchar(20) default NULL,
  pass varchar(20) default NULL,
  fullname varchar(50) default NULL,
  email varchar(20) default NULL,
  tablez varchar(50) default NULL,
  categories text,
  PRIMARY KEY  (ID),
  KEY ID (ID)
) TYPE=MyISAM;

INSERT INTO users SET
user='adam',pass='adam',fullname='Administrator',email='fc...@yo...';

INSERT INTO genres SET genre='Alternative';
INSERT INTO genres SET genre='Electronica';
INSERT INTO genres SET genre='Rock';
INSERT INTO genres SET genre='Comedy';
INSERT INTO genres SET genre='Abstract';
INSERT INTO genres SET genre='Discussion';
INSERT INTO genres SET genre='Festival';
INSERT INTO genres SET genre='Talk';
INSERT INTO genres SET genre='Pop';

I added two fields :
codec varchar(20) NOT NULL default 'unknown',
and
bitrate varchar(15) NOT NULL default '56k',

the final programs table should look like this:

CREATE TABLE programs (
  ID bigint(20) NOT NULL auto_increment,
  name varchar(80) default NULL,
  url text,
  description text,
  length varchar(50) default NULL,
  ownerID int(11) default NULL,
  genreID int(11) default NULL,
  category varchar(80) default NULL,
  format text,
  codec varchar(20) NOT NULL default 'unknown',
  permissions varchar(10) NOT NULL default 'owner',
  bitrate varchar(15) NOT NULL default '56k',
  PRIMARY KEY  (ID),
  KEY ID_2 (ID)
) TYPE=MyISAM;

adam

I am just about to add 'bitrate' and 'codec' fields to the 'programs'
table

make sure you update your db (I will change this in the sql file too so
you can see the format)

adam

hey luka

i am putting a list of all the functions in an include file at the top of
the include file like this:
# progr.php
#CONTAINS:
	#programForm
	#listProgram
	#listAllPrograms
	#listUserPrograms
	#addProgram
	#editProgram
	#deleteProgram
	#dropCategories

Also, I have put programForm in the progr.php file not the html.php as
this makes more sense i think...html.php should purely be for html
elements like drop downs etc that get re-used in may places

adam

test server has been changed to include new field (elength)

it means that old scheduled events appear with length '0'...thats why the
graph look a bit odd ;-)

hey luka

i have made a change to how the length of an event is
calculated...basically there is a new field (elength) in events (I had to
call it 'elength' rather than 'length' as it was giving me ambiguous
errors in the inner join statement)...

so all event calculatiosn involve the variable elength...calculating
always has the $eLength or $eLengthHours, $eLengthMinutes, $eLengthSeconds

this means that with a few simple alterations it now works with recurring
events etc....

so i will update this on CVS and on the site but be aware that this will
mean I add an extra field to the DB....I will add this to the db conf details too

adam

hey

more probs with cookies

from logincheck

setcookie("fcuID","",time()-3600,$default['path'],$default['domain'],0);

setcookie("fcuName","",time()-3600,$default['path'],$default['domain'],0);

from  Timetable ID

setcookie("fcttID",$nttID,time()+36000,$default[path],$default[domain],0);

doesthe array need single quotations?

unfortraunetly my provider dns is a bit fucked today so cant look at
www.php.net

On Wed, 5 Jun 2002, adam wrote:

> hey luka
> i hope all is well with the installation...
>
> just started work on the code today
>
> i installed fc on my machine and spent an hour trying to work out why
> the cookies dont work....
>
> went through userlog.php and found the path and domain hgave been hard
> coded:
> $default[path] = "/cvs/code/openfcphp/";
> $default[domain] = "openfc.sourceforge.net";
>
> which is ok but now we are both working on the code we need to both amke
> sure we put a lot of comments in there so we can see the changes
>
> i hope all is well
>
> adam
>
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> Openfc-tech mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openfc-tech
>

Adam Hyde
XS4ALL Internet B.V.
mobile : + (31) 06 2903 6248

Eekholt 42
1112 XH
Diemen
Amsterdam

"free, as in 'radio'"

hey luka
i hope all is well with the installation...

just started work on the code today

i installed fc on my machine and spent an hour trying to work out why
the cookies dont work....

went through userlog.php and found the path and domain hgave been hard
coded:
$default[path] = "/cvs/code/openfcphp/";
$default[domain] = "openfc.sourceforge.net";

which is ok but now we are both working on the code we need to both amke
sure we put a lot of comments in there so we can see the changes

i hope all is well

adam

hey luka, did you try sftp?

Robert wrote:
>1: Could you please create a virtual website and
>mysql database on user name frequencyclock, and send this account to:
>ad...@xs... (Adam, use sftp + ssh to access the server, it is pretty
>secure),

openfc-tech Mailing List for Frequency Clock

openfc-tech — The mail list for those interested in developing the Frequency Clock.