Get started with PHP-Fusion

Start a New Thread

Users Participated

  • Ryan Stewart
    Post made: 2
  • MarcusG
    Post made: 2
  • Gillette
    Post made: 2
  • zizub
    Post made: 2
  • KasteR
    Post made: 2

  1. PHP-Fusion Support Forums
  2. General Addon and Modification Support
  3. Modifications and Requests

Help with infusion creation

Post your modification and request questions here

9 Replies 2,020 Views Last Updated on 2 years ago

Ryan Stewart


Junior Member

#1

Posted 4 years ago

I'm deprived of sleep right now, so I am not quite sure what i've done wrong here. It creates the first table fine, but that's about it. Any help?

Code Gist: Download source  
$inf_newtable[1] = ARTISTS." (

artist_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,

artist_name VARCHAR(70) DEFAULT '' NOT NULL,

artist_bio TEXT DEFAULT '' NOT NULL,

artist_record_company VARCHAR(150) DEFAULT '' NOT NULL,

PRIMARY KEY (artist_id)

) TYPE=MyISAM;";

$inf_newtable[2] = ALBUMS." (
artist_id INT(11) DEFAULT '' NOT NULL,
album_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
album_name VARCHAR(70) DEFAULT '' NOT NULL,
album_tracks SMALLINT(5) NOT NULL,
PRIMARY KEY (album_id)
) TYPE=MyISAM;";

$inf_newtable[3] = PLAYLISTS." (
playlist_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT(8) DEFAULT '' NOT NULL,
playlist_name VARCHAR(70) DEFAULT '' NOT NULL,
playlist_date INT(10) DEFAULT '' NOT NULL,
playlist_modified INT(10) DEFAULT '' NOT NULL,
PRIMARY KEY (playlist_id)
) TYPE=MyISAM;";

$inf_newtable[4] = PLAYLISTS_ITEMS." (
playlist_id INT(11) DEFAULT '' NOT NULL,
track_id INT(11) DEFAULT '' NOT NULL
) TYPE=MyISAM;";

$inf_newtable[5] = TRACKS." (
track_id INT(11) DEFAULT '' NOT NULL AUTO_INCREMENT,
artist_id INT(11) DEFAULT '' NOT NULL,
track_name VARCHAR(70) DEFAULT '' NOT NULL,
track_url VARCHAR(150) DEFAULT '' NOT NULL,
PRIMARY KEY (track_id)
) TYPE=MyISAM;";


Merged on Jun 06 2011 at 09:58:13:
Seriously? Does no one have any idea? I lost a whole day of development work yesterday due to this...
Edited by Ryan Stewart on 06-06-2011 10:58
img682.imageshack.us/img682/7469/logo2vod.png
Expect stuff from me soon (:

Posts: 43

Joined: 09/04/2010

MarcusG


Member

#2

Posted 4 years ago

Any errors in the error log?
Ex Senior Dev.

Posts: 182

Joined: 13/08/2010

Ryan Stewart


Junior Member

#3

Posted 4 years ago

No, no errors are returned. As i've said it runs the first one fine, and creates the artists table.
img682.imageshack.us/img682/7469/logo2vod.png
Expect stuff from me soon (:

Posts: 43

Joined: 09/04/2010

MarcusG


Member

#4

Posted 4 years ago

Code Gist: Download source  
artist_id INT(11) DEFAULT '' NOT NULL,


Numeral fields need numbers as default values, not a string.

Code Gist: Download source  
artist_id INT(11) DEFAULT '0' NOT NULL,

Ex Senior Dev.

Posts: 182

Joined: 13/08/2010

zizub


Junior Member

#5

Posted 2 years ago

I'm looking for an article or a guide how to create your Infusions plugin. There is a instruction or not ? I need to know what files are to be created. I looked ready plugins but there a lot of unnecessary files to me and I can not figure out which I need the is required to use and which to ignore. Where to read about it ?

Posts: 41

Joined: 02/05/2012

Gillette


Senior Member

#6

Posted 2 years ago

here:

PHP-Fusion 7 Infusion SDK v1.00

With this small package of software, you can start building your own infusions, the right way. From small one-liners to entire systems, it all starts here.

located at skpacman.com>
http://www.skpacm...nload_id=3

Posts: 338

Joined: 09/04/2012

KasteR


Senior Member

#7

Posted 2 years ago

If you're using MySQL 5.5.8, then you should change TYPE=MyISAM to ENGINE=MyISAM. Perhaps that may have something to do with it as well..

Posts: 267

Joined: 14/07/2012

Gillette


Senior Member

#8

Posted 2 years ago

KasteR wrote:

If you're using MySQL 5.5.8, then you should change TYPE=MyISAM to ENGINE=MyISAM. Perhaps that may have something to do with it as well..


Good point,thanks for mentioning that Kaster

Posts: 338

Joined: 09/04/2012

KasteR


Senior Member

#9

Posted 2 years ago

No problem, by the way, didn't realize this thread was hijacked lol. Oh well, good stuff here. Grin

Posts: 267

Joined: 14/07/2012

zizub


Junior Member

#10

Posted 2 years ago

Thanks for the help

Posts: 41

Joined: 02/05/2012

Jump to Forum:
6 users are online
0 member and 6 guests