Page 45 of 212

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Fri Jul 11, 2008 3:52 pm
by Leinad4Mind
I have try to install this gallery and after put all the files and edited all files. when i have run the install an error have occored:

Code: Select all

SQL ERROR [ mysqli ]

Field 'bbcode_order' doesn't have a default value [1364]

SQL

INSERT INTO maf_bbcodes (bbcode_tag, bbcode_match, bbcode_tpl, display_on_posting, bbcode_helpline, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace, bbcode_id) VALUES ('album', '[album]{NUMBER}[/album]', '<a href=\"http://forum.manganime.biz/forum/gallery/image_page.php?image_id={NUMBER}\"><img src=\"http://forum.manganime.biz/forum/gallery/thumbnail.php?image_id={NUMBER}\" alt=\"image_id: {NUMBER}\" /></a>', 1, '', '!\\[album\\]([0-9]+)\\[/album\\]!i', '[album:$uid]${1}[/album:$uid]', '!\\[album:$uid\\]([0-9]+)\\[/album:$uid\\]!s', '<a href=\"http://forum.manganime.biz/forum/gallery/image_page.php?image_id=${1}\"><img src=\"http://forum.manganime.biz/forum/gallery/thumbnail.php?image_id=${1}\" alt=\"image_id: ${1}\" /></a>', 69)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: install_gallery/install.php
LINE: 139
CALL: dbal_mysqli->sql_query()

FILE: install_gallery/install.php
LINE: 412
CALL: add_bbcode()
What is it?? :?

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Sat Jul 12, 2008 3:24 pm
by Leinad4Mind
how can i install without problems??

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Sat Jul 12, 2008 4:37 pm
by Leinad4Mind
Every one with ABBC3 MOD install will need to change the install. Like i did [replace all function add_bbcode($album_bbcode)]

Problem Solve :mrgreen:

i have put with the order like the phpmyadmin and it works:

I have edit install.php

Code: Select all

function add_bbcode($album_bbcode)
{
	global $db, $config;

	$sql = 'SELECT * FROM ' . BBCODES_TABLE . " WHERE bbcode_tag = '$album_bbcode'";
	$result = $db->sql_query($sql);
	$row = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);

	
		$sql = 'SELECT MAX(bbcode_id) as max_bbcode_id
			FROM ' . BBCODES_TABLE;
		$result = $db->sql_query($sql);
		$row = $db->sql_fetchrow($result);
		$db->sql_freeresult($result);

		if ($row)
		{
			$bbcode_id = $row['max_bbcode_id'] + 1;

			// Make sure it is greater than the core bbcode ids...
			if ($bbcode_id <= NUM_CORE_BBCODES)
			{
				$bbcode_id = NUM_CORE_BBCODES + 1;
			}
		}
		else
		{
			$bbcode_id = NUM_CORE_BBCODES + 1;
		}
		$sql_ary['bbcode_id'] = (int) $bbcode_id;

if (!$row)
	{
		$sql_ary = array(
			'bbcode_tag'				=> $album_bbcode,
			'bbcode_helpline'			=> '',
			'display_on_posting'		=> true,
			'bbcode_match'				=> '[' . $album_bbcode . ']{NUMBER}[/' . $album_bbcode . ']',
			'bbcode_tpl'				=> '<a href="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/image_page.php?image_id={NUMBER}"><img src="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/thumbnail.php?image_id={NUMBER}" alt="image_id: {NUMBER}" /></a>',


			'first_pass_match'			=> '!\[' . $album_bbcode . '\]([0-9]+)\[/' . $album_bbcode . '\]!i',
			'first_pass_replace'		=> '[' . $album_bbcode . ':$uid]${1}[/' . $album_bbcode . ':$uid]',
			'second_pass_match'			=> '!\[' . $album_bbcode . ':$uid\]([0-9]+)\[/' . $album_bbcode . ':$uid\]!s',
			'second_pass_replace'		=> '<a href="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/image_page.php?image_id=${1}"><img src="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/thumbnail.php?image_id=${1}" alt="image_id: ${1}" /></a>',
		);

		$db->sql_query('INSERT INTO ' . BBCODES_TABLE . $db->sql_build_array('INSERT', $sql_ary));
	}
	else
	{
		$sql_ary = array(
			'bbcode_tpl'				=> '<a href="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/image_page.php?image_id={NUMBER}"><img src="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/thumbnail.php?image_id={NUMBER}" alt="image_id: {NUMBER}" /></a>',
			'second_pass_replace'		=> '<a href="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/image_page.php?image_id=${1}"><img src="' . $config['server_protocol'] . $config['server_name'] . $config['script_path'] . '/gallery/thumbnail.php?image_id=${1}" alt="image_id: ${1}" /></a>',
		);
		$db->sql_query('UPDATE ' . BBCODES_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE bbcode_id = ' . (int) $row['bbcode_id']);
	}
}
// What sql_layer should we use?
switch ($db->sql_layer)
{
	case 'mysql':
		$db_schema = 'mysql_40';
		$delimiter = ';';
	break;

	case 'mysql4':
		if (version_compare($db->mysql_version, '4.1.3', '>='))
		{
			$db_schema = 'mysql_41';
		}
		else
		{
			$db_schema = 'mysql_40';
		}
		$delimiter = ';';
	break;

	case 'mysqli':
		$db_schema = 'mysql_41';
		$delimiter = ';';
	break;

	case 'mssql':
	case 'mssql_odbc':
		$db_schema = 'mssql';
		$delimiter = 'GO';
	break;

	case 'postgres':
		$db_schema = 'postgres';
		$delimiter = ';';
	break;

	case 'sqlite':
		$db_schema = 'sqlite';
		$delimiter = ';';
	break;

	case 'firebird':
		$db_schema = 'firebird';
		$delimiter = ';;';
	break;

	case 'oracle':
		$db_schema = 'oracle';
		$delimiter = '/';
	break;

	default:
		trigger_error('Sorry, unsupportet Databases found.');
	break;
}

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Sun Jul 13, 2008 12:54 am
by slidewayz88
I have done everything and once I go to install it i get this message. Can anyone help???
Fatal error: Call to undefined function adm_back_link() in /home/spart12/public_html/includes/acp/acp_modules.php on line 768

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Thu Jul 17, 2008 3:58 pm
by gara
Where is the "breadcrumbs" of this mod for subsilver2...

I can't see for example this: forum >> gallery >> name album >> image

You can create this?

thanks

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Thu Jul 17, 2008 4:09 pm
by nickvergessen
I'm getting them:
Board index » Gallery » Test-Album

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Thu Jul 17, 2008 5:52 pm
by SharpShot.gif
why is it looking for the database tables in all caps but when installed into the database they in lower case?

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Thu Jul 17, 2008 8:35 pm
by nickvergessen
you forgot to edit the includes/constants.php

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Thu Jul 17, 2008 11:35 pm
by SharpShot.gif
not sure why but after loading the install.xml into my EI7 I got more information than on FF a lot more

any way we can put a Confirmation code or logged in used only to post comments on the gallery to stop bots?

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Fri Jul 18, 2008 9:05 am
by monkey gun
hi, is it possible to resize photos with this mod

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Fri Jul 18, 2008 12:45 pm
by nickvergessen
SharpShot.gif wrote:not sure why but after loading the install.xml into my EI7 I got more information than on FF a lot more
You may have to allow soem scripts for IE so the other languages are not displayed
SharpShot.gif wrote:any way we can put a Confirmation code or logged in used only to post comments on the gallery to stop bots?
it's already in SVN you'll have to wait for next version

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Fri Jul 18, 2008 6:22 pm
by AnonaBlue
Loving the mod. It does its job very well and is very clean. Thank you for putting all the effort into this that I'm sure it takes

Requested featrues:
Ability to embed galleries into the forum lists. So instead of a gallery button at the top, you could have the "General Gallery" as a subforum in the "General Discussion" forum, the "Specific Gallery A" as a subforum in the "Specific Discussion A" forum, etc. etc.

Ability to use Gallery Entries to link to other sites. If someone uses Flikr to host all their photos of Event A, I'd like for them to be able to drop a link into the Event A Gallery so that everyone else can follow that to their Flikr

Option for specific Galleries to be listed (or not) in the Recent uploads. I would like to have a Gallery for my users to be able to upload their NSFW crap, but not if it'll get shown in the Recent uploads.

Again, thank you very much for all your hard work on this.

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Sat Jul 19, 2008 10:29 am
by Leinad4Mind
The button Upload Image, doesn't appear. And i have all files correctly edited and if i go to ACP -> Templates -> Imageset -> Edit (mytemplate) And if i choose in the list, the upload button, the button appears twice below (appear in the ACP) in the fórum it doesn't appear... don't know why...

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Sat Jul 19, 2008 11:06 am
by nickvergessen
shoudl be a language problem
did you edit styles/yours/imageset/xy/imageset.cfg correctly?

Re: [Beta] phpBB Gallery 0.3.1 - keep it up tsr

Posted: Sat Jul 19, 2008 11:14 am
by Leinad4Mind
yes i have:

img_button_topic_reply = button_topic_reply.gif*25*96
img_button_upload_image = button_upload_image.gif*25*119

I have edit the language... Cause i have en and pt

And when i Choose Enlgish, it appear "Upload Image" when i choose Portuguese language in mt control panel, it appears my translation "Carregar Imagem"

EDIT: oohh and the button_gallery, of the personal album, doesn't appear too. (But i know why... cause i don't have the prosilver installation file, it don't come with the .rar of this MOD)
This is the first and olny MOD that i can't fix the image problems ^^'