Page 5 of 5

Posted: Sun Jan 14, 2007 7:45 pm
by hardjowikr
Mhhm...

Oke, i can start doing stuff in my free time (wich is like 2 hours a day at the moment :lol: )

So i know:
- It needs to be written in PHP.

DOn't know:
- Wich PHP version
- Wich database and how is its structure

Posted: Mon Jan 15, 2007 10:13 am
by exp
hardjowikr wrote:Mhhm...

Oke, i can start doing stuff in my free time (wich is like 2 hours a day at the moment :lol: )

So i know:
- It needs to be written in PHP.

DOn't know:
- Wich PHP version
- Wich database and how is its structure
You should be able to get most information out of this thread.

Right now it's PHP4, PHP5 could probably also be installed, but PHP4 would just run out of the box, which would be kinda nice :o)

In terms of database, do take note that you DO NOT have access to the anidb database. You can use a database for your own stuff though, like user preferences, caching data, ...
As such you're free to use whatever database structure you want.
Please write the DB code in a way which makes it database independend though. It should at least run on PostgreSQL and MySQL. PostgreSQL is the the most likely database your code will see.

You get the actual data from anidb via XML HTTP requests, see other posts in this thread.

BYe!
EXP

Posted: Tue Jan 16, 2007 5:57 pm
by EvoGT
here are my codes so far: http://manga-network.de/sig/sig_sql.rar

the sql:

Code: Select all

CREATE TABLE `user_config` (
  `USER-ID` int(10) NOT NULL auto_increment,
  `design` char(1) NOT NULL default '1',
  `number_series` int(1) NOT NULL default '3',
  `last_update` tinyint(1) NOT NULL default '1',
  `show_line_1` tinyint(1) NOT NULL default '1',
  `show_line_2` tinyint(1) NOT NULL default '1',
  `show_line_3` tinyint(1) NOT NULL default '1',
  `text_line_1` varchar(70) NOT NULL default '',
  `text_line_2` varchar(70) NOT NULL default '',
  `text_line_3` varchar(70) NOT NULL default '',
  UNIQUE KEY `USER-ID` (`USER-ID`)
) TYPE=MyISAM AUTO_INCREMENT=33 ;

-- 
-- Daten für Tabelle `user_config`
-- 

INSERT INTO `user_config` VALUES (32, '1', 3, 1, 1, 1, 1, 'test', 'me', 'please');
and to open the picture: http://url/sig.php?user_ID=32

no UI so far that i want to publish, also the DB is a kinda easy one with
less options.

Posted: Tue Jan 16, 2007 7:35 pm
by exp
Whatever you (or anyone else for the matter) want to show us, you should put it on some website where we can look at it in operation.

Please also note that your database handling has to be database independent and should at least run under postgresql and mysql. That's of course not important during early development, so your SQL being mysql-only isn't a problem yet. Just keep in mind that you shouldn't use any mysql-only features or methods/libraries in your code.

BYe!
EXP

Posted: Wed Jan 17, 2007 9:51 am
by EvoGT
exp wrote:Whatever you (or anyone else for the matter) want to show us, you should put it on some website where we can look at it in operation.

Please also note that your database handling has to be database independent and should at least run under postgresql and mysql. That's of course not important during early development, so your SQL being mysql-only isn't a problem yet. Just keep in mind that you shouldn't use any mysql-only features or methods/libraries in your code.

BYe!
EXP
i have showed it a couple of times...just remember *lol*
and the sql i have posted is mysql-syntax without something special

Posted: Wed Jan 17, 2007 9:07 pm
by exp
EvoGT wrote:i have showed it a couple of times...just remember *lol*
and the sql i have posted is mysql-syntax without something special
also the latest version? or are you no longer working on this?

BYe!
EXP

Posted: Mon Feb 05, 2007 6:24 pm
by exp
i've collected some of the information in this thread under:
http://wiki.anidb.info/w/SigServer_DEV

feel free to extend that page.

BYe!
EXP

Posted: Sat Mar 03, 2007 9:20 am
by exp
is anyone still working on this?

BYe!
EXP

Posted: Wed Mar 21, 2007 10:35 pm
by antennen
Since this project seems pretty dead I'm interested in giving you a helping hand. Send me a PM or something if you're interested.

antennen

Posted: Thu Mar 22, 2007 9:27 am
by exp
just give it a shot :o)

btw. droping by in #anidb-dev on irc.chatsociety.net might be a good idea.

BYe!
EXP