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)

kelekian 09-06-2006 07:48 PM

I can create more then 1 journal for one single user?!

regards,

Kelekian

maidos 09-07-2006 06:24 PM

hey when will the journal be released for 3.6.0?

Cyn 09-08-2006 05:34 PM

Oblivion Knight's signature:
"vBJournal for 3.6.0: Delayed due to personal problems. C'est la vie.. =\"

Jei 09-10-2006 03:02 AM

Quote:

Originally Posted by Oblivion Knight
I'm hoping to have some time during the next few days to finish working on this and get something released. It should be worth noting however, that support will be extremely limited for the time being, upgrade instructions may be somewhat sketchy in places and I cannot confirm that it will work with the vBulletin 3.5.x series..

Thank you for your patience.

Patience is a virtue. :D And stop asking it'll arrive when it arrives. We should be happy that Oblivion Knight took his time to do this ^^

cerbdawg 09-10-2006 08:26 PM

I installed this hack on vBulletin 3.6.0, PHP 4.3, Apache 1.3.33, MySQL 4.0.24 with success. It appears to function normally and other than fixing the link in the Members List I've had no problems with it thus far.

Great hack :)

Gaia 09-11-2006 10:35 PM

That's good to know cerbdawg, i'll also try it on my 3.6.0 forum and see how it goes ( going to back up first of course lol ).

reficul010 09-13-2006 08:05 AM

I also did not have any problems so far on 3.6.0.

I do have a question...Should i see the journalentry when i add a comment to it?
if not, is it possible to show the journalentry when adding a comment?

redlabour 09-13-2006 08:40 AM

What about german Icons ?

bigtime 09-14-2006 04:23 AM

working for me on 3.61

www.defend.net/deluxeforums/

Snake 09-14-2006 03:30 PM

Good to hear. :)

Chadi 09-15-2006 02:43 AM

Upgraded to 3.6.1 and now I get this when I click the link in user control panel..

Code:

Database error in vBulletin 3.6.1:

Invalid SQL:
 
                SELECT journal_entries.entry_id, journal_entries.entrytitle,
                journal_entries.entrytext, journal_entries.mood, journal_entries.np, journal_entries.allowbuddies,journal_entries.entrydate,
              journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image, journal_entries.entry_totalrating,
                journal_entries.private, journal_entries.whocanview,
                COUNT(journal_comments.comment_text) AS comments
                FROM journal_entries AS journal_entries
                LEFT JOIN journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_id)
            LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
            WHERE journal_entries.journal_id=72
                    AND entry_active='1'     
                   
              GROUP BY journal_entries.entry_id
            ORDER BY entrydate DESC
            LIMIT 0,;

MySQL Error  : 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 '' at line 14 Error Number : 1064

Also, in the instructions it says this:

In Template modifylist
FIND
----------------------------------------------------------------------------------------------------------------------------------
<form action="profile.php" method="post">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="updatelist" />
<input type="hidden" name="userlist" value="ignore" />
<fieldset class="fieldset">
<legend>$vbphrase[ignore_list]</legend>
<div style="padding:$stylevar[formspacer]px">
$ignore_listbits
<div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
<div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
</div>
<div align="center"><input type="submit" class="button" value="$vbphrase[update_ignore_list]" accesskey="s" /></div>
</fieldset>
</form>
</td>
</tr>
----------------------------------------------------------------------------------------------------------------------------------


I cannot find this ...see attached template

abrecher 09-15-2006 09:51 PM

I also upgraded to the latest version. Users get the following when they visit the journal page:

Database error in vBulletin 3.6.1:

Invalid SQL:

### 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 journals AS journals
LEFT JOIN usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
WHERE journals.active=1
AND (journals.journalist_id=1 OR journals.private != 1 OR FIND_IN_SET('1', journals.allowedusers))
ORDER BY lastentry_date DESC
LIMIT 0,;

MySQL Error : 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 '' at line 12
Error Number : 1064
Date : Friday, September 15th 2006 @ 06:22:43 PM
Script : http://www.XXXXX.com/journal.php
Referrer :
IP Address : XXXXX
Username : XXXXX
Classname : XXXXX


HELP!!! ;-)

Renmiri 09-15-2006 11:40 PM

Quote:

Originally Posted by kelekian
I can create more then 1 journal for one single user?!

regards,

Kelekian

I solved that with a new user name and the "Quick account switch" hack :D

Lionel 09-16-2006 02:06 AM

What seems to be the problem with 3.60? What should I be looking for?
I installed and everything seems to be working....

thumbsucker 09-16-2006 10:11 AM

Same DB errors the others are getting with the 3.6.1 upgrade.

:cross-eyed: :confused:

thumbsucker 09-17-2006 12:33 AM

Man someone help fix this please!

abrecher 09-17-2006 02:10 AM

Quote:

Originally Posted by abrecher
I also upgraded to the latest version. Users get the following when they visit the journal page:

Database error in vBulletin 3.6.1:

Invalid SQL:

### 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 journals AS journals
LEFT JOIN usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
WHERE journals.active=1
AND (journals.journalist_id=1 OR journals.private != 1 OR FIND_IN_SET('1', journals.allowedusers))
ORDER BY lastentry_date DESC
LIMIT 0,;

MySQL Error : 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 '' at line 12
Error Number : 1064
Date : Friday, September 15th 2006 @ 06:22:43 PM
Script : http://www.XX.X.com/journal.php
Referrer :
IP Address : XXXXX
Username : XXXXX
Classname : XXXXX


HELP!!! ;-)


Please please someone help me!!

Adrian Schneider 09-17-2006 02:12 AM

Quote:

Originally Posted by abrecher
Please please someone help me!!

Just a side note - that's a porn site LOL.

abrecher 09-17-2006 02:50 AM

Quote:

Originally Posted by SirAdrian
Just a side note - that's a porn site LOL.

LOL, I changed the URL...thanks.

Can you help me ??

Adrian Schneider 09-17-2006 03:18 AM

I would personally search for every occurance of "$start,$perpage" and replace $perpage with the number you want. I'm not sure how the settings work - and that would bypass the (not working) settings and use the value you enter.

Once a valid fix is released you can just download a fresh copy of the file.

Snake 09-17-2006 07:36 AM

What are you talking about? This works just fine on 3.6.x.

grundybin 09-17-2006 06:43 PM

It is not recommended to use mySQL 4.1+
kurs HTML
They are probably all using MySQL 5 :rolleyes:

soletrader 09-18-2006 06:17 AM

This hack works great for 3.6.0 but with just one problem.

I no longer see the attachment function on the reply box. Is this supposed to happen?

agiacosa 09-19-2006 03:23 PM

So, is this working with 3.6.1?

Chadi 09-19-2006 03:25 PM

Quote:

Originally Posted by agiacosa
So, is this working with 3.6.1?

No, not for me nor many others.

Apparently we're not getting an update/fix from the coder.

voteforbird 09-19-2006 11:53 PM

It's working on 3.6.1 for me! Question: how can I change it so that in Who's Online it displays everyone on the forums as well, and not just the blogs?

voteforbird 09-20-2006 12:22 AM

Also, when I uncomment the report button, it goes to a blank page. Is there a fix for this?

Chadi 09-20-2006 01:51 AM

Quote:

Originally Posted by chadi
Upgraded to 3.6.1 and now I get this when I click the link in user control panel..

Code:

Database error in vBulletin 3.6.1:

Invalid SQL:
 
                SELECT journal_entries.entry_id, journal_entries.entrytitle,
                journal_entries.entrytext, journal_entries.mood, journal_entries.np, journal_entries.allowbuddies,journal_entries.entrydate,
              journal_entries.entry_totalvotes, journal_moods.mood_name, journal_entries.ipaddress,journal_moods.mood_image, journal_entries.entry_totalrating,
                journal_entries.private, journal_entries.whocanview,
                COUNT(journal_comments.comment_text) AS comments
                FROM journal_entries AS journal_entries
                LEFT JOIN journal_comments AS journal_comments ON (journal_entries.entry_id=journal_comments.entry_id)
            LEFT JOIN journal_moods AS journal_moods ON (journal_moods.mood_id=journal_entries.mood)
            WHERE journal_entries.journal_id=72
                    AND entry_active='1'     
                   
              GROUP BY journal_entries.entry_id
            ORDER BY entrydate DESC
            LIMIT 0,;

MySQL Error  : 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 '' at line 14 Error Number : 1064

Also, in the instructions it says this:

In Template modifylist
FIND
----------------------------------------------------------------------------------------------------------------------------------
<form action="profile.php" method="post">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="updatelist" />
<input type="hidden" name="userlist" value="ignore" />
<fieldset class="fieldset">
<legend>$vbphrase[ignore_list]</legend>
<div style="padding:$stylevar[formspacer]px">
$ignore_listbits
<div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
<div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
</div>
<div align="center"><input type="submit" class="button" value="$vbphrase[update_ignore_list]" accesskey="s" /></div>
</fieldset>
</form>
</td>
</tr>
----------------------------------------------------------------------------------------------------------------------------------


I cannot find this ...see attached template


Please help on this. I've been w/o the journal for 5 days now. Its critical on my site. I really would appreciate some help.

:Judge: 09-20-2006 07:17 AM

I am also getting an error now after the 3.6.1 upgrade?
Code:

Database error in vBulletin 3.6.1:

Invalid SQL:

                ### 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 journals AS journals
                LEFT JOIN usertextfield AS usertextfield ON (journals.journalist_id=usertextfield.userid)
                WHERE journals.active=1 
                AND (journals.journalist_id=1 OR journals.private != 1 OR FIND_IN_SET('1', journals.allowedusers))
                ORDER BY lastentry_date DESC
                LIMIT 0,;

MySQL Error  : 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 '' at line 12
Error Number : 1064
Date        : Wednesday, September 20th 2006 @ 01:14:39 AM
Script      : http://www.cecilcountyx.com/forums/journal.php
Referrer    : http://www.cecilcountyx.com/
IP Address  :
Username    :
Classname    : vb_database


DS MrSinister 09-20-2006 01:50 PM

Template modifylist edit what I use For 3.6.1 seems to work so far

Find

Code:

<tr valign="top">
                                                <td id="ignorelist1">$ignorelistbits1</td>
                                                <td id="ignorelist2">$ignorelistbits2</td>
                                        </tr>
                                          <tr>
  <td>

Add Below

Code:

  <tr>
  <td>
  <form action="profile.php" method="post">
  <input type="hidden" name="s" value="$session[sessionhash]" />
  <input type="hidden" name="do" value="updatelist" />
  <input type="hidden" name="userlist" value="jbuddy" />                                       
  <fieldset class="fieldset">
          <legend>$vbphrase[journal_buddy_list]</legend>
        <div style="padding:$stylevar[formspacer]px">
                $jbuddy_listbits
                <div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
                <div><input type="text" class="bginput" name="listbits[]" size="25" /></div>
        </div>
        <div align="center"><input type="submit" class="button" value="$vbphrase[update_journal_buddies]" accesskey="s" /></div>
  </fieldset>                                       
  </form>                               
  </td>
  </tr>

Also download the file find here for 3.6+

https://vborg.vbsupport.ru/showpost....postcount=1323

voteforbird 09-20-2006 05:49 PM

What does this do?
Quote:

Also download the file find here for 3.6+

https://vborg.vbsupport.ru/showpost....postcount=1323

voteforbird 09-20-2006 08:05 PM

How can I add the journal entry to the top of the comments page? Thanks.

Chadi 09-21-2006 12:55 AM

Quote:

Originally Posted by Firestar.chkn
Hi Everyone,

It's been fixed by one of my Admins. He made some changes to the journal.php file and commented his hack (search for "sn hack" without the quotes) of the code. Feel free to replace your journal.php file with this one. It should work. To the author of this hack, feel free to make use of the code changes, although you may be able to clean it up (not sure. This was done rather quickly, so it could be a quick and nasty).

I make NO guarantees, though. Please make backups of your DB and whatnot. I accept no responsibility for the changed file and offer no support whatsoever.

It enabled me to get in, but look at the screen shot now

DS MrSinister 09-21-2006 01:06 AM

Quote:

Originally Posted by chadi
It enabled me to get in, but look at the screen shot now


login to the admincp goto the vbjournal setting and click save the setting should work again..

Chadi 09-21-2006 01:14 AM

That did not fix the width problem in the first column

Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
 <title>$vboptions[bbtitle] - $vbphrase[journals]</title>
</head>
<body>
$header
$navbar
<!-- Journal Welcome Panel -->
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
<tbody>
<tr>
<td class="tcat" colspan="3" align="center">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('welcome_vbjournal')"><img id="collapseimg_welcome_vbjournal" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_welcome_vbjournal].gif" alt="" border="0" /></a>
$vbphrase[welcome_to_vbjournal]</td>
</tr>
</tbody>
<tbody id="collapseobj_welcome_vbjournal" style="$vbcollapse[collapsetobj_welcome_vbjournal]">
<tr>
<td class="thead" nowrap="nowrap" align="center">$vbphrase[latest_entries]</td>
<td class="thead" nowrap="nowrap" align="center">$vbphrase[latest_journals]</td>
</tr>
$latestbits
</tbody>
<tbody>
<tr>
</tr>
</tbody>
</table>
<!-- /Journal Welcome Panel -->
<br />
<table border="0" align="center" width="100%" cellpadding="0" cellspacing="0">
<tr valign="bottom">
<td align="$stylevar[left]" style="padding-bottom:3px;">
<if condition="$canhave[journal] AND !$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=startjournal"><img src="$stylevar[imgdir_button]/newjournal.gif" border="0" alt="$vbphrase[start_your_journal_now]" /></a>
<else />
<if condition="$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=gotomyjournal"><img src="$stylevar[imgdir_button]/myjournal.gif" border="0" alt="$vbphrase[go_to_your_journal]" /></a>
</if>
</if>
</td>
<td class="$stylevar[right]" style="padding-bottom:3px;">$pgnav</td>
</tr>
<tr>
<td colspan="2">
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%" style="border-bottom-width:0px">
<tbody>
<tr>
<td class="tcat" align="$stylevar[left]" width="100%">$vbphrase[journals]</td>
<td id="jlinks" class="vbmenu_control"><a href="#jlinks">$vbphrase[journal_links]</a> <script type="text/javascript"> vbmenu_register("jlinks"); </script></td>
<td id="journalsearch" class="vbmenu_control"><a href="#journalsearch">$vbphrase[search_journals]</a> <script type="text/javascript"> vbmenu_register("journalsearch"); </script></td>
</tr>
</table>
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
<tr>
<td class="thead" width="15%"></td>
<td class="thead" width="70%" nowrap="nowrap">$vbphrase[journal] / $vbphrase[journal_description]</td>
<td class="thead" width="208" nowrap="nowrap" align="center">$vbphrase[last_entry]</td>
<td class="thead" width="69" nowrap="nowrap" align="center">$vbphrase[entries]</td>
<td class="thead" width="69" nowrap="nowrap" align="center">$vbphrase[comments]</td>
</tr>
</tbody>
<tbody id="collapseobj_index_journals" style="$vbcollapse[collapsetobj_index_journals]">
$journalbits
</tbody>
<if condition="$pgnav">
<tr><td class="tfoot" colspan="5" align="$stylevar[right]">
<phrase 1="$journalsstart" 2="$journalsend" 3="$journalount">$vbphrase[showing_results_x_to_y_of_z]</phrase>
</td></tr>
</if>
</table>
</td>
</tr>
<tr valign="top">
<td align="$stylevar[left]" style="padding-top:3px;">
<if condition="$canhave[journal] AND !$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=startjournal"><img src="$stylevar[imgdir_button]/newjournal.gif" border="0" alt="$vbphrase[start_your_journal_now]" /></a>
<else />
<if condition="$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=gotomyjournal"><img src="$stylevar[imgdir_button]/myjournal.gif" border="0" alt="$vbphrase[go_to_your_journal]" /></a>
</if>
</if>
</td>
<td class="$stylevar[right]" style="padding-top:3px;">$pgnav
<br />
</td>
</tr>
<tr>
<td colspan="2">
<br />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" align="$stylevar[left]">$vbphrase[display_options]</td>
</tr>
<tr>
<td class="thead" align="$stylevar[left]">$vbphrase[options]</td>
</tr>
<tr>
<td class="alt1" align="center">
<form action="journal.php" method="get">
<table cellpadding="0" cellspacing="1" border="0" width="auto">
<tr>
<td class="smallfont">
$vbphrase[sort_by]: <select name="sort">
<option value="journalist"<if condition="$sort=='journalist'"> select="selected"</if>>$vbphrase[journalist]</option>
<option value="journalname"<if condition="$sort=='journalname'"> selected="selected"</if>>$vbphrase[journal_name]</option>
<option value="journaldate"<if condition="$sort=='journaldate'"> selected="selected"</if>>$vbphrase[journal_start_date]</option>
<option value="journaldesc"<if condition="$sort=='journaldesc'"> selected="selected"</if>>$vbphrase[journal_description]</option>
<option value="entrycount"<if condition="$sort=='entrycount'"> selected="selected"</if>>$vbphrase[entry_count]</option>
<option value="lastentry_date"<if condition="$sort=='lastentry_date'"> selected="selected"</if>>$vbphrase[last_entry_date]</option>
<option value="lastentry"<if condition="$sort=='lastentry'"> selected="selected"</if>>$vbphrase[last_entry_title]</option>
</select>
</td>
<td class="smallfont" style="padding-left:20px">
$vbphrase[sort_order]: <select name="order">
<option value="ASC" <if condition="$order=='ASC'"> selected="selected"</if>>$vbphrase[ascending]</option>
<option value="DESC"<if condition="$order=='DESC'"> selected="selected"</if>>$vbphrase[descending]</option>
</select>
</td>
<td align="$stylevar[right]" style="padding-left:20px"><input type="submit" value="$vbphrase[show_journals]" class="button" /></td>
</tr>
</table>
</form>
</td>
</tr>
</tbody>
</table>
<div class="vbmenu_popup" id="journalsearch_menu" style="display:none">
<form action="journal.php" method="get">
<input type="hidden" name="do" value="searchresults" />
<input type="hidden" name="st" value="3" />
  <table cellpadding="4" cellspacing="1" border="0">
  <tr><td class="thead">$vbphrase[search_journals]</td></tr>
  <tr><td class="vbmenu_option" title="nohilite"><input type="text" name="sk" value="" size="20" maxlength="50" /> $gobutton<!--input type="submit" value="Go" class="button" /--></td></tr>
<tr><td class="vbmenu_option"><a href="journal.php?do=search" title="$vbphrase[advanced_journal_search]">$vbphrase[advanced_search]</a></td></tr>
</table>
</form>
</div>
<div class="vbmenu_popup" id="jlinks_menu" style="display:none">
 <table cellpadding="4" cellspacing="1" border="0">
 <tr><td class="thead">$vbphrase[journal_links]</td></tr>
 <if condition="$canhave[journal]"><tr><td class="vbmenu_option"><a href="journal.php?do=gotomyjournal">$vbphrase[my_journal]</a></td></tr>
 <tr><td class="vbmenu_option"><a href="journal.php?do=gotomyjournal&amp;action=addentry">$vbphrase[new_entry]</a></td></tr></if>
 <tr><td class="vbmenu_option"><a href="journal.php?do=topjournals">$vbphrase[top_journals_list]</a></td></tr>
  </table>
</div>
<!-- / NAVBAR POPUP MENUS -->
<br />
<br />
</td>
</tr>
<tr>
<td colspan="2">
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
<tr>
<td class="tcat" colspan="2">$vbphrase[whats_going_on]</td>
</tr>
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('index_wov')">
<img id="collapseimg_index_wov" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_index_wov].gif" alt="" border="0"></a>
<a href="online.php">$vbphrase[currently_active_users]</a>: $totalviewing (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)</td>
</tr>
</tbody>
<tbody id="collapseobj_index_wov" style="$vbcollapse[collapsetobj_index_wov]">
<tr>
<td class="alt2" align="center"><a href="online.php"><img src="$stylevar[imgdir_misc]/whos_online.gif" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$activeusers</div></td>
</tr>
</tbody>
<tbody>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('index_statistics')">
<img id="collapseimg_index_statistics" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_index_statistics].gif" alt="" border="0"></a><phrase 1="$vboptions[bbtitle]">$vbphrase[x_journal_statistics]</phrase></td>
</tr>
</tbody>
<tbody id="collapseobj_index_statistics" style="$vbcollapse[collapsetobj_index_statistics]">
<tr>
<td class="alt2" align="center"><img src="$stylevar[imgdir_misc]/stats.gif" /></td>
<td class="alt1"><div class="smallfont">$vbphrase[journals]: $totaljournals, $vbphrase[entries]: $total[entries], $vbphrase[comments]: $total[comments], $vbphrase[views]: $total[views]</div>
<div class="smallfont"><phrase 1="$session[sessionurl]" 2="$getlatestj[journal_id]" 3="$getlatestj[journalist]">$vbphrase[welcome_to_our_newest_journalist_x]</phrase></div>
<div class="smallfont">$vbphrase[your_current_journal_status_is]: <if condition="$bbuserinfo[private]=='1'"><b><font color="red">$vbphrase[private]</font></b><else /><if condition="$bbuserinfo[private]==''"><b><font color="orange">$vbphrase[non_existent]</font></b><else /><b><font color="green">$vbphrase[public]</font></b></if></if></div></td>
</tr>
</tbody>
<tbody>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('index_buddies')"><img id="collapseimg_index_buddies" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_index_buddies].gif" alt="" border="0"></a><a href="profile.php?$session[sessionurl]do=editlist">$vbphrase[buddy_journals]</a>: $buddycount</td>
</tr>
</tbody>
<tbody id="collapseobj_index_buddies" style="$vbcollapse[collapsetobj_index_buddies]">
<tr>
<td class="alt2" align="center"><a href="profile.php?$session[sessionurl]do=editlist"><img src="$stylevar[imgdir_misc]/buddy_journals.gif" border="0" alt="" /></a></td>
<td class="alt1"><div class="smallfont">$jbuddy_listbits</div></td>
</tr>
</tbody>
<tr>
<td class="tfoot" colspan="2" align="center"><div class="smallfont"><strong><if condition="$bbuserinfo[userid]!=0"><a href="journal.php?do=markjournalsread">$vbphrase[mark_journals_read]</a><else />&nbsp;</if></strong></div></td>
</tr></td>
</tr>
</table>
</td>
</tr>
</table>
$footer
</body>
</html>

It looks normal in 1600x1200 with the above modified JOURNAL template. However, moving down smaller resolutions crushes the fist column again. I tried 150 (pixel) and tried 15%, 12%, same problem. Why?

sross 09-21-2006 06:55 AM

Hi, my queries did not run so i was going to run them in phpmyadmin but i am unsure what syntax to use> currently it is for example:

Code:

$db->query_write("
        CREATE TABLE " . TABLE_PREFIX . "journal_comments (
        comment_id int(10) NOT NULL auto_increment,
        journal_id int(10) NOT NULL,
        entry_id int(10) NOT NULL,
        commenter varchar(50) NOT NULL,
        commenter_id int(10) NOT NULL,
        comment_title varchar(100) NOT NULL,
        comment_text text NOT NULL,
        comment_date int(10) NOT NULL,
        ipaddress varchar(15) NOT NULL,
        PRIMARY KEY (comment_id))
");

But i do not think that is right for manually running the query. If someone could supply what the above should be i can mimic it to the rest. Total mysql noob.

Thanks!

Chadi 09-21-2006 10:32 AM

Anyone know how to fix that width problem in first column, or perhaps replace it with icons instead?

DS MrSinister 09-21-2006 12:47 PM

Quote:

Originally Posted by chadi
Anyone know how to fix that width problem in first column, or perhaps replace it with icons instead?


try this - The Original temp

Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
        <title>$vboptions[bbtitle] - $vbphrase[journals]</title>
</head>
<body>
$header
$navbar
<!-- Journal Welcome Panel -->
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
<tbody>
<tr>
<td class="tcat" colspan="3" align="center">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('welcome_vbjournal')"><img id="collapseimg_welcome_vbjournal" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_welcome_vbjournal].gif" alt="" border="0" /></a>
$vbphrase[welcome_to_vbjournal]</td>
</tr>
</tbody>
<tbody id="collapseobj_welcome_vbjournal" style="$vbcollapse[collapsetobj_welcome_vbjournal]">
<tr>
<td class="thead" nowrap="nowrap" align="center">$vbphrase[latest_entries]</td>
<td class="thead" nowrap="nowrap" align="center">$vbphrase[latest_journals]</td>
</tr>
$latestbits
</tbody>
<tbody>
<tr>
</tr>
</tbody>
</table>
<!-- /Journal Welcome Panel -->
<br />

<table border="0" align="center" width="100%" cellpadding="0" cellspacing="0">
<tr valign="bottom">
<td align="$stylevar[left]" style="padding-bottom:3px;">
<if condition="$canhave[journal] AND !$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=startjournal"><img src="$stylevar[imgdir_button]/newjournal.gif" border="0" alt="$vbphrase[start_your_journal_now]" /></a>
<else />
<if condition="$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=gotomyjournal"><img src="$stylevar[imgdir_button]/myjournal.gif" border="0" alt="$vbphrase[go_to_your_journal]" /></a>
</if>
</if>
</td>
<td class="$stylevar[right]" style="padding-bottom:3px;">$pgnav</td>
</tr>
<tr>
<td colspan="2">
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%" style="border-bottom-width:0px">
<tbody>
<tr>
<td class="tcat" align="$stylevar[left]" width="100%">$vbphrase[journals]</td>
<td id="jlinks" class="vbmenu_control"><a href="#jlinks">$vbphrase[journal_links]</a> <script type="text/javascript"> vbmenu_register("jlinks"); </script></td>
<td id="journalsearch" class="vbmenu_control"><a href="#journalsearch">$vbphrase[search_journals]</a> <script type="text/javascript"> vbmenu_register("journalsearch"); </script></td>
</tr>
</table>
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
<tr>
<td class="thead">&nbsp;</td>
<td class="thead" nowrap="nowrap">$vbphrase[journal] / $vbphrase[journal_description]</td>
<td class="thead" width="208" nowrap="nowrap" align="center">$vbphrase[last_entry]</td>
<td class="thead" width="69" nowrap="nowrap" align="center">$vbphrase[entries]</td>
<td class="thead" width="69" nowrap="nowrap" align="center">$vbphrase[comments]</td>
</tr>
</tbody>
<tbody id="collapseobj_index_journals" style="$vbcollapse[collapsetobj_index_journals]">
$journalbits
</tbody>
<if condition="$pgnav">
<tr><td class="tfoot" colspan="5" align="$stylevar[right]">
<phrase 1="$journalsstart" 2="$journalsend" 3="$journalount">$vbphrase[showing_results_x_to_y_of_z]</phrase>
</td></tr>
</if>
</table>
</td>
</tr>
<tr valign="top">
<td align="$stylevar[left]" style="padding-top:3px;">
<if condition="$canhave[journal] AND !$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=startjournal"><img src="$stylevar[imgdir_button]/newjournal.gif" border="0" alt="$vbphrase[start_your_journal_now]" /></a>
<else />
<if condition="$bbuserinfo['journal_id']">
<a href="journal.php?$session[sessionurl]do=gotomyjournal"><img src="$stylevar[imgdir_button]/myjournal.gif" border="0" alt="$vbphrase[go_to_your_journal]" /></a>
</if>
</if>
</td>
<td class="$stylevar[right]" style="padding-top:3px;">$pgnav
<br />
</td>
</tr>
<tr>
<td colspan="2">
<br />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat" align="$stylevar[left]">$vbphrase[display_options]</td>
</tr>
<tr>
<td class="thead" align="$stylevar[left]">$vbphrase[options]</td>
</tr>
<tr>
<td class="alt1" align="center">
<form action="journal.php" method="get">
<table cellpadding="0" cellspacing="1" border="0" width="auto">
<tr>
<td class="smallfont">
$vbphrase[sort_by]: <select name="sort">
<option value="journalist"<if condition="$sort=='journalist'"> select="selected"</if>>$vbphrase[journalist]</option>
<option value="journalname"<if condition="$sort=='journalname'"> selected="selected"</if>>$vbphrase[journal_name]</option>
<option value="journaldate"<if condition="$sort=='journaldate'"> selected="selected"</if>>$vbphrase[journal_start_date]</option>
<option value="journaldesc"<if condition="$sort=='journaldesc'"> selected="selected"</if>>$vbphrase[journal_description]</option>
<option value="entrycount"<if condition="$sort=='entrycount'"> selected="selected"</if>>$vbphrase[entry_count]</option>
<option value="lastentry_date"<if condition="$sort=='lastentry_date'"> selected="selected"</if>>$vbphrase[last_entry_date]</option>
<option value="lastentry"<if condition="$sort=='lastentry'"> selected="selected"</if>>$vbphrase[last_entry_title]</option>
</select>
</td>
<td class="smallfont" style="padding-left:20px">
$vbphrase[sort_order]: <select name="order">
<option value="ASC" <if condition="$order=='ASC'"> selected="selected"</if>>$vbphrase[ascending]</option>
<option value="DESC"<if condition="$order=='DESC'"> selected="selected"</if>>$vbphrase[descending]</option>
</select>
</td>
<td align="$stylevar[right]" style="padding-left:20px"><input type="submit" value="$vbphrase[show_journals]" class="button" /></td>
</tr>
</table>
</form>
</td>
</tr>
</tbody>
</table>
<div class="vbmenu_popup" id="journalsearch_menu" style="display:none">
<form action="journal.php" method="get">
<input type="hidden" name="do" value="searchresults" />
<input type="hidden" name="st" value="3" />
                <table cellpadding="4" cellspacing="1" border="0">

                <tr><td class="thead">$vbphrase[search_journals]</td></tr>
                <tr><td class="vbmenu_option" title="nohilite"><input type="text" name="sk" value="" size="20" maxlength="50" /> $gobutton<!--input type="submit" value="Go" class="button" /--></td></tr>
<tr><td class="vbmenu_option"><a href="journal.php?do=search" title="$vbphrase[advanced_journal_search]">$vbphrase[advanced_search]</a></td></tr>
</table>
</form>
</div>
<div class="vbmenu_popup" id="jlinks_menu" style="display:none">
        <table cellpadding="4" cellspacing="1" border="0">
        <tr><td class="thead">$vbphrase[journal_links]</td></tr>
        <if condition="$canhave[journal]"><tr><td class="vbmenu_option"><a href="journal.php?do=gotomyjournal">$vbphrase[my_journal]</a></td></tr>
        <tr><td class="vbmenu_option"><a href="journal.php?do=gotomyjournal&amp;action=addentry">$vbphrase[new_entry]</a></td></tr></if>
        <tr><td class="vbmenu_option"><a href="journal.php?do=topjournals">$vbphrase[top_journals_list]</a></td></tr>
                </table>
</div>

<!-- / NAVBAR POPUP MENUS -->
<br />
<br />
</td>
</tr>
<tr>
<td colspan="2">
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
<tr>
<td class="tcat" colspan="2">$vbphrase[whats_going_on]</td>
</tr>
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('index_wov')">
<img id="collapseimg_index_wov" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_index_wov].gif" alt="" border="0"></a>
<a href="online.php">$vbphrase[currently_active_users]</a>: $totalviewing (<phrase 1="$numberregistered" 2="$numberguest">$vbphrase[x_members_and_y_guests]</phrase>)</td>
</tr>
</tbody>
<tbody id="collapseobj_index_wov" style="$vbcollapse[collapsetobj_index_wov]">
<tr>
<td class="alt2" align="center"><a href="online.php"><img src="$stylevar[imgdir_misc]/whos_online.gif" border="0" /></a></td>
<td class="alt1" width="100%"><div class="smallfont">$activeusers</div></td>
</tr>
</tbody>
<tbody>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('index_statistics')">
<img id="collapseimg_index_statistics" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_index_statistics].gif" alt="" border="0"></a><phrase 1="$vboptions[bbtitle]">$vbphrase[x_journal_statistics]</phrase></td>
</tr>
</tbody>
<tbody id="collapseobj_index_statistics" style="$vbcollapse[collapsetobj_index_statistics]">
<tr>
<td class="alt2" align="center"><img src="$stylevar[imgdir_misc]/stats.gif" /></td>
<td class="alt1"><div class="smallfont">$vbphrase[journals]: $totaljournals, $vbphrase[entries]: $total[entries], $vbphrase[comments]: $total[comments], $vbphrase[views]: $total[views]</div>
<div class="smallfont"><phrase 1="$session[sessionurl]" 2="$getlatestj[journal_id]" 3="$getlatestj[journalist]">$vbphrase[welcome_to_our_newest_journalist_x]</phrase></div>
<div class="smallfont">$vbphrase[your_current_journal_status_is]: <if condition="$bbuserinfo[private]=='1'"><b><font color="red">$vbphrase[private]</font></b><else /><if condition="$bbuserinfo[private]==''"><b><font color="orange">$vbphrase[non_existent]</font></b><else /><b><font color="green">$vbphrase[public]</font></b></if></if></div></td>
</tr>
</tbody>
<tbody>
<tr>
<td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('index_buddies')"><img id="collapseimg_index_buddies" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_index_buddies].gif" alt="" border="0"></a><a href="profile.php?$session[sessionurl]do=editlist">$vbphrase[buddy_journals]</a>: $buddycount</td>
</tr>
</tbody>
<tbody id="collapseobj_index_buddies" style="$vbcollapse[collapsetobj_index_buddies]">
<tr>
<td class="alt2" align="center"><a href="profile.php?$session[sessionurl]do=editlist"><img src="$stylevar[imgdir_misc]/buddy_journals.gif" border="0" alt="" /></a></td>
<td class="alt1"><div class="smallfont">$jbuddy_listbits</div></td>
</tr>
</tbody>
<tr>
<td class="tfoot" colspan="2" align="center"><div class="smallfont"><strong><if condition="$bbuserinfo[userid]!=0"><a href="journal.php?do=markjournalsread">$vbphrase[mark_journals_read]</a><else />&nbsp;</if></strong></div></td>
</tr></td>
</tr>
</table>
</td>
</tr>
</table>
$footer
</body>
</html>


mikeclarke 09-24-2006 03:36 PM

Quote:

Originally Posted by Firestar.chkn
Hi Everyone,

It's been fixed by one of my Admins. He made some changes to the journal.php file and commented his hack (search for "sn hack" without the quotes) of the code. Feel free to replace your journal.php file with this one. It should work. To the author of this hack, feel free to make use of the code changes, although you may be able to clean it up (not sure. This was done rather quickly, so it could be a quick and nasty).

I make NO guarantees, though. Please make backups of your DB and whatnot. I accept no responsibility for the changed file and offer no support whatsoever.

Thank you very much for the fix.

Firestar.chkn 09-24-2006 07:22 PM

Pleasure Guys.

I'm now getting another error:
Quote:

Parse error: syntax error, unexpected T_PRIVATE, expecting ']' in /var/www/forums.prophecy.co.za/journal.php(567) : eval()'d code on line 188
Can anyone help with this error? If not, I'll get someone to try and look at it and post the fix here. I'm not getting SQL errors... yet :(


All times are GMT. The time now is 10:32 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.03566 seconds
  • Memory Usage 1,985KB
  • 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
  • (8)bbcode_code_printable
  • (13)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
  • (40)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