[RC] phpBB Gallery 1.0.4 (including TS Gallery converter)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Anti-Spam Guide
Locked
User avatar
Leinad4Mind
Translator
Posts: 853
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

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

Post 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?? :?
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
User avatar
Leinad4Mind
Translator
Posts: 853
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

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

Post by Leinad4Mind »

how can i install without problems??
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
User avatar
Leinad4Mind
Translator
Posts: 853
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

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

Post 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;
}
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
slidewayz88
Registered User
Posts: 15
Joined: Mon Mar 24, 2008 7:26 am

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

Post 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
User avatar
gara
Registered User
Posts: 40
Joined: Wed Mar 12, 2008 4:10 am
Location: Colombia
Contact:

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

Post 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
Nueva Comunidad

PaginaLatinos.Com Aqui
PaginaLatinos.Com Aqui
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

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

Post by nickvergessen »

I'm getting them:
Board index » Gallery » Test-Album
No Support via PM
SharpShot.gif
Registered User
Posts: 18
Joined: Tue Jul 10, 2007 5:56 pm

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

Post by SharpShot.gif »

why is it looking for the database tables in all caps but when installed into the database they in lower case?
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

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

Post by nickvergessen »

you forgot to edit the includes/constants.php
No Support via PM
SharpShot.gif
Registered User
Posts: 18
Joined: Tue Jul 10, 2007 5:56 pm

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

Post 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?
monkey gun
Registered User
Posts: 39
Joined: Sun Aug 12, 2007 8:47 am

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

Post by monkey gun »

hi, is it possible to resize photos with this mod
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

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

Post 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
No Support via PM
AnonaBlue
Registered User
Posts: 3
Joined: Thu Jul 17, 2008 8:07 pm

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

Post 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.
User avatar
Leinad4Mind
Translator
Posts: 853
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

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

Post 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...
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
User avatar
nickvergessen
Former Team Member
Posts: 4397
Joined: Mon Apr 30, 2007 5:33 pm
Location: Stuttgart, Germany
Name: Joas Schilling
Contact:

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

Post by nickvergessen »

shoudl be a language problem
did you edit styles/yours/imageset/xy/imageset.cfg correctly?
No Support via PM
User avatar
Leinad4Mind
Translator
Posts: 853
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

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

Post 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 ^^'
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
Locked

Return to “[3.0.x] MODs in Development”