New Signature Pic feature [FEEDBACK]

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

Moderator: AniDB

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

Post 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
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post 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
EvoGT
Posts: 8
Joined: Fri Sep 29, 2006 10:57 pm
Contact:

Post 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.
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post 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
EvoGT
Posts: 8
Joined: Fri Sep 29, 2006 10:57 pm
Contact:

Post 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
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post 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
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post 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
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post by exp »

is anyone still working on this?

BYe!
EXP
antennen
Posts: 7
Joined: Sat Jul 15, 2006 11:27 pm
Contact:

Post 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
exp
Site Admin
Posts: 2438
Joined: Tue Oct 01, 2002 9:42 pm
Location: Nowhere

Post 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
Locked