vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - vbJournal (https://vborg.vbsupport.ru/showthread.php?t=155853)

MaryTheG(r)eek 09-27-2007 02:32 PM

Quote:

Originally Posted by PimvanJ (Post 1348233)
Thank you Maria for sharing your great hack!

Any vbadvanced modules in progress?

Thanks for mentioning it. I've forgotten it:D I'll develope them during weekend and I'll post them on Sunday.

Heath 09-29-2007 01:03 AM

wow, this looks like a incredible mod.

I'm going to install it now and check it out. Great job though Mary.

chickadee 09-30-2007 07:29 AM

Hi Mary, still loving this hack, but when someone uploads a photo article, the thumbnail doesn't seem to be created automatically. Is it supposed to be?

MaryTheG(r)eek 09-30-2007 08:41 AM

Quote:

Originally Posted by chickadee (Post 1350071)
Hi Mary, still loving this hack, but when someone uploads a photo article, the thumbnail doesn't seem to be created automatically. Is it supposed to be?

No, that's not normal. Thumb must be created automatically. Are you sure that you've cmod 777 /thumbs directory inside /vbjournal/photos ?

shabab-on-line 09-30-2007 09:45 PM

Hi Maria,

Do you expect any solution for the edit box problem?
Maybe if you make the script support the tools which are using on "Quick Replay Box" as an extra choice!

Regards.

Ba$im 10-01-2007 02:10 PM

hello
thanks for great work
I have a problem when I ho to any usergroup to give permission to see vbjournal
and click update I have this error
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Guest',
`description` = '',
`usertitle` = 'Guest',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '655363',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`genericpermissions` = '1',
`genericoptions` = '40',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '139263',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '10000',
`sigmaxchars` = '5000',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '65535',
`mgccustomusergroupperms` = '0',
`nbmsgshowchatbox` = '',
`vbjournal` = '1',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_daily` = '0',
`credit_active` = '10',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reppos` = '10',
`credit_repneg` = '-15',
`credit_thread` = '20',
`credit_threadrate` = '5',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.1',
`credit_pollmake` = '10',
`credit_pollvote` = '3',
`credit_unthread` = '-20',
`credit_unpost` = '-5',
`creditpermissions` = '0',
`adminpermissions` = '0'
WHERE usergroupid=1;

MySQL Error : Unknown column 'mgccustomusergroupperms' in 'field list'
Error Number : 1054
Date : Monday, October 1st 2007 @ 06:01:07 PM
Script : ********/admincp/usergroup.php?do=update
Referrer : ********/admincp/usergroup.php?do=edit&usergroupid=1
IP Address : ********
Username : ******
Classname : vb_database

thanks in advance

chickadee 10-02-2007 05:18 AM

Quote:

Originally Posted by MicroHellas (Post 1350096)
No, that's not normal. Thumb must be created automatically. Are you sure that you've cmod 777 /thumbs directory inside /vbjournal/photos ?

The thumbs directory is definitely cmod 777, I'm going to upload a test article and see if it still does it.

Just had 2 questions, are there any vbadvanced mods for this? Also, can users post comments on the articles?
Thanks so much!!!

Jay-MOB 10-02-2007 09:26 PM

is there going to be anything for cmps soon?

MP3 10-04-2007 05:04 AM

In the main page for the journal; we can see:
1- Journal / Journal Description
2- Last Entry
3- Entries
4- Comments

I want to add one column for the last comment in each journal and to join the Entries and Comments columns in one column. I edit the following code in the journal.php form:

PHP Code:

$fjournals $db->query_read("
                ### Journal Listing ###
                SELECT
                 journals.lastentry_uids, journals.journal_id, journals.journalname, journals.journaldesc,
                journals.journalist, journals.journalist_id, entrycount, commentcount, usertextfield.jbuddylist, ipaddress, journals.lastentry,
                journals.lastentry_date, journals.private, journals.whocanview, journals.lastentry_id, journals.status, journals.allowbuddies, journals.journalviews,
                journals.journal_totalrating AS totalrating, journals.journal_totalvotes AS totalvotes
                FROM " 
TABLE_PREFIX "journals AS journals
                LEFT JOIN " 
TABLE_PREFIX "usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
                WHERE journals.active=1
                AND (journals.journalist_id=" 
$vbulletin->userinfo['userid'] . " OR journals.private != 1 OR FIND_IN_SET('" $vbulletin->userinfo['userid'] . "', journals.allowedusers))
                ORDER BY 
$sort $order
                LIMIT 
$start,$perpage
        "
); 


To:

PHP Code:

        $fjournals $db->query_read("
                ### Journal Listing ###
                SELECT
                journals.lastentry_uids, journals.journal_id, journals.journalname, journals.journaldesc,
                journals.journalist, journals.journalist_id, entrycount, commentcount, usertextfield.jbuddylist, journals.ipaddress, journals.lastentry,
                journals.lastentry_date, journals.private, journals.whocanview, journals.lastentry_id, journals.status, journals.allowbuddies, journals.journalviews,
                journals.journal_totalrating AS totalrating, journals.journal_totalvotes AS totalvotes,
                journal_comments.comment_id, journal_comments.journal_id, journal_comments.entry_id,
                journal_comments.commenter, journal_comments.commenter_id, journal_comments.comment_title,
                journal_comments.comment_date
                FROM " 
TABLE_PREFIX "journals AS journals
                LEFT JOIN " 
TABLE_PREFIX "usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
                LEFT JOIN " 
TABLE_PREFIX "journal_comments AS journal_comments ON (journal_comments.journal_id=journals.journal_id)
                WHERE journals.active=1
                AND (journals.journalist_id=" 
$vbulletin->userinfo['userid'] . " OR journals.private != 1 OR FIND_IN_SET('" $vbulletin->userinfo['userid'] . "', journals.allowedusers))
                ORDER BY 
$sort $order
                LIMIT 
$start,$perpage
        "
); 

but there is something wrong! Can someone please guide me how to edit the code and the templates?

chickadee 10-04-2007 12:29 PM

Also Mary, the thumbnails are definitely not working, and I've definitely chmod 777 the directory. Any ideas?


All times are GMT. The time now is 04:52 AM.

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.01273 seconds
  • Memory Usage 1,767KB
  • 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_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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