vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vBJournal for vBulletin 3.5 (https://vborg.vbsupport.ru/showthread.php?t=96462)

Andreas 09-18-2005 12:59 AM

Well, I thought it was obvious that one has to turn on appropriate Permissions ;)

Omega Prime 09-18-2005 01:36 AM

Quote:

Originally Posted by Omega Prime
Well, that worked :)

Just a side question, but how can you have it so that it shows journals on the index in descending order by the last entry date? I know I can set it myself, but there doesn't seem to be a way to have it set like that for all members (the same goes with journal entries) :ermm:

Just thought I'd quote myself since it was on the bottom of the 2nd page and Kirby might've not noticed :)

Paul M 09-18-2005 01:52 AM

Quote:

Originally Posted by KirbyDE
@Paul M
There are ALTER Statements?

Well yes, there are now, since you've now added them. They wern't there when I downloaded it earlier - I can only report on what I have - esp if you change it without saying anything. :)

FYI, I also had to manually rebuild the bitfields before I could use it (or edit usergroups).

Daniel 09-18-2005 02:29 AM

Set the proper usergroup settings, uploaded everything, but I get it's deactivated when it's not...

Andreas 09-18-2005 06:07 AM

@Paul M
Yeah, in the first ZIP they were missing, but they were already added when you posted that they are not there :)
Hmm, the Bitfields should be rebuilt automatically.
Gonna test why they are not.
Edit: Tested and gets rebuilt for me.

@Danieldude
If it tells you that it is deactivated then it is deactivated.

@Omega Prime
Not possible (yet)

ged 09-18-2005 06:16 AM

I had vbjournal on my 3.0.7, does this hack upgrade it? I don't want to loose my users' journal data.

Andreas 09-18-2005 06:19 AM

It should, unless you uninstall it.
To be 100% safe, I'd suggest to backup your journals, journal_entries, journal_comments, journal_moods and journal_settings tables first.

hydrostatic 09-18-2005 06:47 AM

Quote:

Originally Posted by KirbyDE
It should, unless you uninstall it.
To be 100% safe, I'd suggest to backup your journals, journal_entries, journal_comments, journal_moods and journal_settings tables first.

When trying to edit moods, there comes an SQL error.
Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
DELETE FROM journal_moods WHERE mood_id=1;

MySQL Error  : Table 'blootix_forums.journal_moods' doesn't exist
Error Number : 1146
Date        : Sunday, September 18th 2005 @ 02:45:26 AM
Script      : http://www.blootix.com/forums/admincp/journaladmin.php?do=killmood&mid=1
Referrer    : http://www.blootix.com/forums/admincp/journaladmin.php?do=moderatemoods
IP Address  : ***********
Username    : Blootix
Classname    : vb_database

I think you mistyped something about a TABLE PREFIX. I'll try to find it.

EDIT: Found it. You forgot to do that .TABLE PREFIX. thing with this code:

PHP Code:

$mid $vbulletin->input->clean_gpc('r''mid'TYPE_INT);
        
$db->query("DELETE FROM journal_moods WHERE mood_id=".$mid."");
        
define('CP_REDIRECT''journaladmin.php?do=moderatemoods');
        
print_stop_message('journal_mood_deleted_successfully'); 

it should be:
PHP Code:

$mid $vbulletin->input->clean_gpc('r''mid'TYPE_INT);
        
$db->query("DELETE FROM ".TABLE_PREFIX."journal_moods WHERE mood_id=".$mid."");
         
define('CP_REDIRECT''journaladmin.php?do=moderatemoods');
         
print_stop_message('journal_mood_deleted_successfully'); 

Am I right?

Andreas 09-18-2005 06:54 AM

Yes.
People should not use Table-Prefixes ;)
But: Bugs should not be reported here.
That just gets too messy :(

hydrostatic 09-18-2005 06:57 AM

Ops I didn't see that link in the first post. I'll do that next time.


All times are GMT. The time now is 03:30 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.02036 seconds
  • Memory Usage 1,749KB
  • 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
  • (1)bbcode_code_printable
  • (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
  • (3)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