New Signature Pic feature [FEEDBACK]

Want to help out? Need help accessing the AniDB API? This is the place to ask questions.

Moderator: AniDB

User avatar
hardjowikr
Posts: 16
Joined: Mon Jan 08, 2007 9:55 pm

Post by hardjowikr » Sun Jan 14, 2007 7:45 pm

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

User avatar
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp » Mon Jan 15, 2007 10:13 am

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

User avatar
EvoGT
Posts: 8
Joined: Fri Sep 29, 2006 10:57 pm
Contact:

Post by EvoGT » Tue Jan 16, 2007 5:57 pm

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.

User avatar
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp » Tue Jan 16, 2007 7:35 pm

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

User avatar
EvoGT
Posts: 8
Joined: Fri Sep 29, 2006 10:57 pm
Contact:

Post by EvoGT » Wed Jan 17, 2007 9:51 am

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

User avatar
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp » Wed Jan 17, 2007 9:07 pm

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

User avatar
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp » Mon Feb 05, 2007 6:24 pm

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

User avatar
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp » Sat Mar 03, 2007 9:20 am

is anyone still working on this?

BYe!
EXP

User avatar
antennen
Posts: 7
Joined: Sat Jul 15, 2006 11:27 pm
Contact:

Post by antennen » Wed Mar 21, 2007 10:35 pm

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

User avatar
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp » Thu Mar 22, 2007 9:27 am

just give it a shot :o)

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

BYe!
EXP

Locked