Bootleg Listings v1.0

This is a multipurpose hack for listing bands and there concerts and what arena's they will be playing.

if you like it please click the install button for updates and support

i need your input for the features of the next version v2.0 givemeideasand descriptions of what they will be used for and i will tryandaddthem all to the next version

all ideas welcome

[oldfan]

awesome!
I'll get back to you on this one
Thanks

[TurboTwoLiter]

this would be nice if you could make it where someone could list "car shows" rather than bands! nice hack though!

[wolfe]

Originally Posted by TurboTwoLiter

this would be nice if you could make it where someone could list "car shows" rather than bands! nice hack though!

m8 you could just edit the install file and alter the definitions of the phrases and it will be changed to car shows

[ericgtr]

I ran the fix but am still getting a lot of db errors.

[wolfe]

Originally Posted by ericgtr

I ran the fix but am still getting a lot of db errors.

m8 i used it it work fine ?? because it add the 2 new templates and a few phrases

run the uninstall script then run the install one again this should fix the problems

[Lizard King]

I have couple questions.
Is this hack working together with calendar ? When you add a concert can the hack directly add this concert as an event ? I think it might be a usefull feature.
Can we add categories as Rock - Jazz - Metal and put the band names under these categories ?
Can we add multiple entries under a band's name ? If not is it possible ?

Will give it a try soon.

[wolfe]

Originally Posted by Lizard King

I have couple questions.
Is this hack working together with calendar ? When you add a concert can the hack directly add this concert as an event ? I think it might be a usefull feature.
Can we add categories as Rock - Jazz - Metal and put the band names under these categories ?
Can we add multiple entries under a band's name ? If not is it possible ?

Will give it a try soon.

at the moment no its not working with the calendar but could be a good addon for next version.

categories will be in the next version.

you already can add multiple events for a band.

[oldfan]

I just installed it, added the first show and all was good.
As soon as I added the second show I got this error

Invalid SQL:
##### INSERT CONCERT #####
INSERT INTO vb3_concert
(tourname, idband, city, state, venue, act, notes, audiov, videov, audior, videor, date, songs)
VALUES
('', '1', 'Los Angeles',
'CA', 'Whiskey A Go-Go',
'SAXON', '',
'', '',
'', '',
'03/27/82', 'Hit The Lights, Jump In The Fire, Helpless, Let It Loose, The Prince, Metal Militia,
')

mysql error: Duplicate entry '0' for key 1

mysql error number: 1062

[wolfe]

right m8

to fix this go here

./forums/aphid/queries.php?do=modify

and run this


dont forget to add your database prefix infront of the `concert`

PHP Code:

ALTER TABLE `concert` CHANGE `concertid` `concertid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT 


that should fix it

[oldfan]

that did it thanks
Another problem discovered, when I try to upload/attach the artwork IE: cover, front , back, etc.
When I submit it works, but when I goto look at it via the "more info" there's nothing.

2 features I'd like/need to see would be..

the dates are listed oldest to newest, not the order they were submitted
and thumbnails for "cover, front , back, etc" instead of links