vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   4images Gallery 1.7 (https://vborg.vbsupport.ru/showthread.php?t=62020)

mtha 06-16-2004 09:03 PM

Quote:

Originally Posted by vBFreak
hmmm yes, worked without any problems :D

hmmm couldn't the problem with the email-field be, that the user is hiding his mailadress?

I wanted to test this, but it seems that in vB3 the mailaddress is hidden by default, I couldn't find an option in my profile settings like it was in vB 2 for this...

This option is combined in value "options" in vB's userfield table. You need to de-compile the value, in order to get this showemail value.
I'm not interested in showing email nor showing useronline in album, so I cant help you right now.


Quote:

That's my code now, I had to change the paths a bit, because my forums are in /, is there an error now?
is this a question of an answer?

mtha 06-16-2004 09:05 PM

FIX to SHOW MEMBERS who are browsing album to show in forum's whoisonline page

in album's sessions.php

FIND

PHP Code:

 $sql "UPDATE ".SESSIONS_TABLE.
SET lastactivity = 
$this->current_time 
WHERE sessionhash = '
$this->session_id
AND host = '
$this->user_ip'"


REPLACE BY

PHP Code:

    $sql "UPDATE ".SESSIONS_TABLE.
            SET lastactivity = 
$this->current_time, location = '$this->user_location'
            WHERE sessionhash = '
$this->session_id
            AND host = '
$this->user_ip'"


vBFreak 06-17-2004 05:43 PM

where can I add this then to my Who's online list? It shows only that the user is on the forums-index...

mtha 06-17-2004 10:07 PM

Quote:

Originally Posted by vBFreak
where can I add this then to my Who's online list? It shows only that the user is on the forums-index...

add in album's sessions.php

it should show in your FORUM's who's online list. open your who'sonline list, then open another windows, browse to your album to test.


btw, check your sessions.php and see if you have this part correct

function Session() {
global $cookietimeout;
$this->session_timeout = $cookietimeout;
$this->user_ip = $this->get_user_ip();
$this->user_location = '/album/'.$this->get_user_location();
$this->current_time = time();
$this->demand_session();


change /album/ to what it should be in your case

CreedFeed 06-20-2004 03:27 AM

For those of you having problems with this script, download the zip file here:

https://vborg.vbsupport.ru/showpost....&postcount=161

and follow the instructions one by one. It is very easy and works perfectly with vb3.0.1 and 4Images 1.7

I've run into ZERO bugs with this. Everything works perfectly.

mtha 06-20-2004 07:56 PM

Well, after the whole bunch of changes and fixes, I decided to re-release this integration, which would work for vB 3.0.1, giving as much support as I can.
Hope MatrixGL wouldnt mind. (if you do, then update your first post, and let me know, I will delete the other :D )

https://vborg.vbsupport.ru/showthread.php?t=66335

BlackxRam 06-24-2004 01:45 AM

Check that, its nto working now, whenever i close my browser i am logged off 4images. Anything?

mtha 06-24-2004 03:38 AM

Here's the UPDATED version. I CANNOT support an out_of_date version.

https://vborg.vbsupport.ru/showthread.php?t=66335

mrcancel 11-14-2004 09:26 PM

When i integration 4images with vbulletin , i have a error :
Code:

DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM user WHERE user_id <> 0
Unknown column 'user_id' in 'where clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM music_images i, music_categories c LEFT JOIN user u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY DESC LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 1' at line 5


mtha 11-15-2004 05:47 AM

Quote:

Originally Posted by mrcancel
When i integration 4images with vbulletin , i have a error :
Code:

DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM user WHERE user_id <> 0
Unknown column 'user_id' in 'where clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.username FROM music_images i, music_categories c LEFT JOIN user u ON (u.userid = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY DESC LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 1' at line 5


from the error, you DID NOT setup field names for user table right. You may have installed an OUT OF DATE version of this integration.

Here is my post right above yours, I hope you dont mind reading it again:

Quote:

Here's the UPDATED version. I CANNOT support an out_of_date version.

https://vborg.vbsupport.ru/showthread.php?t=66335


All times are GMT. The time now is 06:49 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01244 seconds
  • Memory Usage 1,751KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete