phpBB Garage

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
77
76%
Very Good
13
13%
Good
9
9%
Fair
1
1%
Poor
1
1%
 
Total votes: 101

mosport
Registered User
Posts: 232
Joined: Wed Sep 01, 2004 8:41 am
Location: Australia
Contact:

Post by mosport » Wed May 03, 2006 11:33 am

garage_quartermile_table.tpl

Code: Select all

JAVASCRIPT
garage_vehicle_select_javascript.tpl

Code: Select all

<script type="text/javascript" language="javascript">
<!--
// Auto-generated make/model combinations
var cars = new Array();

{VEHICLE_ARRAY}

	function sortFuncAsc(record1, record2) {
	    var value1 = record1.optText.toLowerCase();
	    var value2 = record2.optText.toLowerCase();
	    if (value1 > value2) return(1);
	    if (value1 < value2) return(-1);
	    return(0);
	}
	
	function sortSelect(selectToSort,curItem) {
	
	    // copy options into an array
	    var myOptions = [];
	    for (var loop=0; loop<selectToSort.options.length; loop++) {
	        myOptions[loop] = { optText:selectToSort.options[loop].text, optValue:selectToSort.options[loop].value };
	    }

	    // sort array
	    myOptions.sort(sortFuncAsc);

	    // copy sorted options from array back to select box
	    selectToSort.options.length = 0;
	    for (var loop=0; loop<myOptions.length; loop++) {
	        var optObj = document.createElement('option');
	        optObj.text = myOptions[loop].optText;
	        optObj.value = myOptions[loop].optValue;
	        selectToSort.options.add(optObj);
	        if (optObj.text == curItem) {
	            optObj.selected = true;
	        }
	    }
	}

	// Generate the Make Dropdown option list.
	function updateMakeSelect(makeSel, curMake) {
		with (makeSel) {
			options.length = 0;	// Clear the option list.

			// Add a header row.
			options[0] = new Option("-- Select Make --", "");

			if (! curMake) {
				options[0].selected = true;
			}

			// Add options for all makes.
			var make;
			for (make in cars) {
	            var make_id = cars[make][0];
				options[options.length] = new Option(make, make_id);
				if (curMake == make) {
					options[options.length-1].selected = true;
				}
			}

	        sortSelect(makeSel,curMake);
		}

		// Netscape does not refresh the dropdown lists automatically.
		if (!curMake) {
			return;
		}
	}

	// Update the Model Dropdown to reflect the selected make. 
	function updateModelSelect(modelSel, curMake, curModel) {
		// which model field should we update?
		with (modelSel) {
			options.length = 0;	// Clear the option list.

			// Add a header row.
			options[0] = new Option("-- Select Model --", "");

			if (! curModel) {
				options[0].selected = true;
			}

			// No models w/o a make.
			if (! curMake) {
				return;
			}

			// Add options for all this makes models.
			var num;
			for (num in cars[curMake][1]) {
				var model = cars[curMake][1][num];
	            var model_id = cars[curMake][2][num];
				options[options.length] = new Option(model, model_id);
				if (curModel == model) {
					options[options.length-1].selected = true;
				}
			}

	        sortSelect(modelSel,curModel);
		}
	}

-->
</script>
both from SUBSILVER TEMPLATE.

Thanks Jeff

phpbbtester
Registered User
Posts: 9
Joined: Tue Apr 25, 2006 10:18 pm

Post by phpbbtester » Wed May 03, 2006 11:35 am

Uploading an image to the garage I get an error (SQL Error : 1366 Incorrect integer value: '' for column 'attach_thumb_width' at row 1).

This is what I found in functions_garage.php...

sql = "INSERT INTO ". GARAGE_IMAGES_TABLE ." (attach_location, attach_hits, attach_ext, attach_file, attach_thumb_location, attach_thumb_width, attach_thumb_height, attach_is_image, attach_date, attach_filesize)
VALUES ('$url_image', '0', '$url_image_ext', '$url_image_name', '$thumb_file_name', '$thumb_width', '$thumb_height', '$attach_is_image', '$url_image_date', '0')";

This is what I get...

INSERT INTO phpbb_garage_images (attach_location, attach_hits, attach_ext, attach_file, attach_thumb_location, attach_thumb_width, attach_thumb_height, attach_is_image, attach_date, attach_filesize) VALUES ('garage_gallery-3-1146408517.jpg', '0', '.jpg', 'impreza.jpg', 'garage_gallery-3-1146408517_thumb.jpg', '', '', '1', '1146408517', '188568')

$thumb_width and $thumb_height return nothing (not 0 but '') and these fields are set NULL not allowed in table definition.

Is this a problem with gdv2?
How can I solve?

User avatar
poyntesm
Registered User
Posts: 1671
Joined: Tue Jan 18, 2005 11:19 am
Location: Dublin, Ireland
Contact:

Post by poyntesm » Wed May 03, 2006 11:46 am

mosport -> That appears correct but the page is defo giving two of them. I will need to have a think where it could be going wrong.

phpbbtester -> As a temp solution add

Code: Select all

$thumb_width = '0';
$thumb_height = '0';
Just above the $sql= line in functions_garage.php

phpbbtester
Registered User
Posts: 9
Joined: Tue Apr 25, 2006 10:18 pm

Post by phpbbtester » Wed May 03, 2006 12:02 pm

poyntesm wrote: phpbbtester -> As a temp solution add

Code: Select all

$thumb_width = '0';
$thumb_height = '0';
Just above the $sql= line in functions_garage.php

Ok, now I can upload image but, believe it or not, I get the following error trying to remove the image I just uploaded...

SQL Error : 1264 Out of range value adjusted for column 'image_id' at row 1
UPDATE phpbb_garage SET image_id = 'NULL' WHERE image_id = '1'
Line : 2696
File : functions_garage.php

I'm using MySQL 5; is this a possible problem or I was wrong installing the MOD?

User avatar
poyntesm
Registered User
Posts: 1671
Joined: Tue Jan 18, 2005 11:19 am
Location: Dublin, Ireland
Contact:

Post by poyntesm » Wed May 03, 2006 12:48 pm

phpbbtester -> No this part should be OK on MySQL5. Best way to sort this would be to give me FTP access. Seems to all be image related.

G07
Registered User
Posts: 3
Joined: Wed May 03, 2006 1:55 pm

Install not working on latest version?

Post by G07 » Wed May 03, 2006 4:15 pm

I have installed the first step of this mod and where you have to run the install_garage.php file in your browser i have already a big problem over there, take a loot at the image below;

Image

Also DEBUG message !

Could not query Garage config information

DEBUG MODE

SQL Error : 1146 Table 'pascalrs.boards_garage_rollingroad' doesn't exist

Array

Line : 576
File : install_garage.php


This is a complete NEW install, anyone any idee what is wrong maybe ?

kawascream
Registered User
Posts: 19
Joined: Mon May 01, 2006 7:53 am

Post by kawascream » Sat May 06, 2006 10:25 am

Great mod :) - am using it here - http://www.emp-jap-oc.co.uk

I'm changing my emails to html and wanted to the featured car to included in a table of the html email - have included what I thought was the currect code, but it doesn't work! :lol:

Code: Select all

Subject: New Private Message has arrived
Charset: iso-8859-1


<BODY BGCOLOR="#707070"> 


<table width="860" align="center" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td><img src="http://www.emp-jap-oc.co.uk/phpBB/templates/obsk/images/top.jpg"></td>
	</tr>
</table>


<table width="860" background="http://www.emp-jap-oc.co.uk/phpBB/templates/obsk/images/center.jpg" align="center" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td>
			<table width="800" align="center" border="0" cellpadding="0" cellspacing="0">
				<tr>
					<td width="33%" class="row1" align="center">
						<table cellpadding="3" cellspacing="1" border="0" class="forumline">
							<tr>
								<th class="thHead" height="25" align="center" colspan="2">{L_FEATURED_VEHICLE}</th>
							</tr>
							<tr>
								<td class="row1" nowrap align="center"><span align="center" class="genmed">{FEATURED_DESCRIPTION}<br />{FEATURED_IMAGE}<br /><a href="{U_VIEW_VEHICLE}">{VEHICLE}</a> {L_OWNER}:<a href="{U_VIEW_PROFILE}">{USERNAME}</a></span></td>
							</tr>
						</table>
					</td>
					<td>
						<font color="white">
						<font face="Arial"

						<p>Hello {USERNAME},</p>
						<p>You have received a new private message to your account on "{SITENAME}". You can view your new message by clicking on the following link:</p>
						<p><a href={U_INBOX}>{U_INBOX}</a></p>
						<p>{EMAIL_SIG}</p>
					</td>
				</tr>
			</table>
		</td>
	</tr>
</table>

<table width="860" align="center" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td><img src="http://www.emp-jap-oc.co.uk/phpBB/templates/obsk/images/bottom.jpg"></td>
	</tr>
</table>

Would also we great to to have the featured car on the index page??

slayer1011
Registered User
Posts: 129
Joined: Sun Jul 03, 2005 11:02 pm
Location: Hamilton, Ontario Canada
Contact:

Post by slayer1011 » Sat May 06, 2006 2:59 pm

kawascream wrote: Would also we great to to have the featured car on the index page??


for featured inage on the index (or any other page) click this link

http://forums.phpbbgarage.com/viewtopic.php?t=24


as for the Email one, its not going to work no matter what you do there ;) you need the php Code to be called, before it can display that information.

from what it sounds like your trying to have that featured image in a newsletter or something?

read up on the ilnk above and you'll see what you need for the index featured vehicle..

i wrote a nice little how to to put the featured image in the bottom where the Who is online is displayed

check it out here
http://forums.phpbbgarage.com/viewtopic.php?p=436#436

kawascream
Registered User
Posts: 19
Joined: Mon May 01, 2006 7:53 am

Post by kawascream » Sat May 06, 2006 3:47 pm

slayer1011 wrote: from what it sounds like your trying to have that featured image in a newsletter or something?


Thats it exactly! :)

If emailer.php adds in things like {SITENAME}, a href={U_INBOX}, and {EMAIL_SIG} am sure we can get it to add Img {FEATURED VEHICLE} etc.

Not fully read the emailer.php yet, so not even sure this the correct file to be looking at yet! :lol: Thanks for the links :) , I'll do a little reading, hoping to add featured vehicle into Nav Menu's.

slayer1011
Registered User
Posts: 129
Joined: Sun Jul 03, 2005 11:02 pm
Location: Hamilton, Ontario Canada
Contact:

Post by slayer1011 » Sat May 06, 2006 10:37 pm

Ok, if there is a file that adds all that info, then yes its possible, read that link i posted, you'll have to add a few lines of code to it (an include, and a line to call all the data from the garage) and it should go nicley for you

www.phpbbgarage.com is a great place to learn some tips and tricks, were always playing with the mod there to get it to do new and interesting things, and we all share our finds

kawascream
Registered User
Posts: 19
Joined: Mon May 01, 2006 7:53 am

Post by kawascream » Sat May 06, 2006 11:00 pm

Registered there earlier today :)

Think I'll leave the newsletter for a bit, bit to deep for me at the moment! :oops: :)

wassup1
Registered User
Posts: 65
Joined: Sun May 07, 2006 7:01 am
Contact:

Post by wassup1 » Sun May 07, 2006 7:05 am

hey guys another great mod i love it but one problem im having in the decription boxs or comments inside the box is white i cant see what im typing only in those its weird but when i highlight it i can see it fine can someone tell me if there is another backround for the comment boxes or decription or is there a another arial color like black lol thx guys

kawascream
Registered User
Posts: 19
Joined: Mon May 01, 2006 7:53 am

Post by kawascream » Sun May 07, 2006 8:04 am

wassup1 wrote: hey guys another great mod i love it but one problem im having in the decription boxs or comments inside the box is white i cant see what im typing only in those its weird but when i highlight it i can see it fine can someone tell me if there is another backround for the comment boxes or decription or is there a another arial color like black lol thx guys


My experience with garage is quite limited, but I though it got all of it's colour from the style css?

wassup1
Registered User
Posts: 65
Joined: Sun May 07, 2006 7:01 am
Contact:

Post by wassup1 » Sun May 07, 2006 9:11 am

hey well ya i thought so too its weird in all of my comment boxes and dicriptions i have white in there but everything else is black hmm laso when i make a new model it saves it fine but then if i create a car with it it doesnt show why?

kawascream
Registered User
Posts: 19
Joined: Mon May 01, 2006 7:53 am

Post by kawascream » Sun May 07, 2006 9:22 am

Sorry dude, can't help you :( , My style is black with white writing and everything displays ok. The text input boxes are white with black writing and they are ok also.

Have a look through you garage_????.tlp files in your style folder and work backwards from there. As said i'm still new to garage (and phpbb) but am picking it up slowly. :)

Post Reply

Return to “[2.0.x] MOD Database Releases”