Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Poptard

Pages: [1]
1
Plugins / [Plugin] Batch Import
« on: November 07, 2002, 01:52:47 AM »
set it to where your images or folders of images you want to add are located.

2
Mods & Plugins (Releases & Support) / Integration 4images 1.7 / phpBB
« on: October 09, 2002, 06:35:27 AM »
just in case this comes up for anyone else, I had a similar problem with deleting groups from my database.. the error I was receiving was:

Code: [Select]
DB Error: Bad SQL Query: DELETE FROM 4images_groups WHERE group_id =
You have an error in your SQL syntax near '' at line 2

DB Error: Bad SQL Query: DELETE FROM 4images_groupaccess WHERE group_id =
You have an error in your SQL syntax near '' at line 2

DB Error: Bad SQL Query: DELETE FROM 4images_groupmatch WHERE group_id =
You have an error in your SQL syntax near '' at line 2
Error while deleting User Group


once again for whatever reason the program was not reading the $group_id variable so it was attempting to insert it as a blank, which resulted in an SQL error.

my resolution was to look for:
Code: [Select]
if ($action == "deletegroup") {


and add this on the next line:
Code: [Select]

$group_id = intval($HTTP_POST_VARS['group_id']);


just a heads up..

3
Plugins / [Plugin] Batch Import
« on: October 09, 2002, 03:37:17 AM »
had a few problems with this mod, but got them worked out on my side with a few changes.. first error that came up was:

Code: [Select]
Parse error: parse error, unexpected T_STRING in /home/httpd/html/4images/admin/plugins/batch_import.php on line 70


i believe that was  because of the missing " on line 67:

Code: [Select]
// Default description for each image, can be left blank
$default_image_description = ";


which I changed to:

Code: [Select]
// Default description for each image, can be left blank
$default_image_description = "";


I then ran into a new error:

Code: [Select]
Fatal error: Failed opening required './../admin/admin_global.php' (include_path='.:/usr/lib/php') in /home/httpd/html/4images/admin/plugins/batch_import.php on line 29


which threw me off for a while, but I realized that for whatever reason, my system was not properly reading the root_path using this line:

Code: [Select]
$root_path = (eregi("\/plugins\/", $PHP_SELF)) ? "./../../" : "./../";

the only way I could get it to work with my limited knowledge of PHP was just to customize it specifically to my system which turned out to be:

Code: [Select]
$root_path = (/home/httpd/html/4images/");

after making these two changes the plugin worked flawlessly!

btw, great addition, this was a major feature I was looking forward to, thanks!  :D

4
Mods & Plugins (Releases & Support) / Integration 4images 1.7 / phpBB
« on: October 05, 2002, 07:00:57 PM »
that works, thanks!

5
Mods & Plugins (Releases & Support) / problem
« on: October 04, 2002, 07:39:52 PM »
the integration is working well for me, 4images detects all of my phpbb users and the sessions are working properly. My problem is when I goto do group management.. I attempt to add ANY of my 98 users to a 4images group and I get these errors:

Code: [Select]

DB Error: Bad SQL Query: DELETE FROM 4images_groupmatch WHERE user_id = AND group_id IN (1, 2, 3, 6)
You have an error in your SQL syntax near 'AND group_id IN (1, 2, 3, 6)' at line 2

DB Error: Bad SQL Query: INSERT INTO 4images_groupmatch (group_id, user_id, groupmatch_startdate, groupmatch_enddate) VALUES (1, , UNIX_TIMESTAMP('2002-10-04 10:43:05'), 0)
You have an error in your SQL syntax near ' UNIX_TIMESTAMP('2002-10-04 10:43:05'), 0)' at line 4

DB Error: Bad SQL Query: INSERT INTO 4images_groupmatch (group_id, user_id, groupmatch_startdate, groupmatch_enddate) VALUES (2, , UNIX_TIMESTAMP('2002-10-04 12:38:36'), 0)
You have an error in your SQL syntax near ' UNIX_TIMESTAMP('2002-10-04 12:38:36'), 0)' at line 4
User edited


for whatever reason it's not seeing my user_id's and is just trying to insert them into the database as a blank.

in my includes/constants.php I have defined:

Code: [Select]
define('USERS_TABLE', 'phpbb_users');

to point to my users directory, and it seems to work for everything but group management. Thanks for any input!

Pages: [1]