Mhhm...
Oke, i can start doing stuff in my free time (wich is like 2 hours a day at the moment )
So i know:
- It needs to be written in PHP.
DOn't know:
- Wich PHP version
- Wich database and how is its structure
New Signature Pic feature [FEEDBACK]
Moderator: AniDB
You should be able to get most information out of this thread.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
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
here are my codes so far: http://manga-network.de/sig/sig_sql.rar
the sql:
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.
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');
no UI so far that i want to publish, also the DB is a kinda easy one with
less options.
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
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*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
and the sql i have posted is mysql-syntax without something special
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
http://wiki.anidb.info/w/SigServer_DEV
feel free to extend that page.
BYe!
EXP