vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Request: Journal (https://vborg.vbsupport.ru/showthread.php?t=38962)

Jeremy W. 05-25-2002 01:42 PM

Okay, got phpmyadmin reinstalled, now the question is what is the SQL for "first you should add a field to your user-table called journal, same options than signature" ?

Jeremy W. 05-25-2002 01:58 PM

Okay, I assumed that to mean, add 3 fields to the user table called journal, options, signature:

ALTER TABLE `ringquest_com`.`user` ADD `journal` TEXT NOT NULL, ADD `options` TEXT NOT NULL, ADD `signature` TEXT NOT NULL

However there is already an options field...

Xenon 05-25-2002 02:11 PM

no, i meant, ALTER TABLE 'user' ADD 'journal' TEXT NOT NULL

just the same options like the signature field: Mediumtext Not Null...

Xenon 05-25-2002 02:33 PM

1 Attachment(s)
here is the journal.php.

i have made some greate optimizations, but think of it, it is not perfect. Right now, it doesn't use the headers, and other things from your board. I think you can make it yourself from here, if not, say a word and i'll try to optimize it more....

Jeremy W. 05-25-2002 08:14 PM

Here is the link: http://www.ringquest.com/forums/journal.php?userid=1019

It isn't live yet, but just to show you how it looks and everything. I'm very new to vb and to php so importing the styles, locations, replacement vars, etc is a bit beyond me right now.

Xenon 05-25-2002 09:38 PM

ok, i can see :)

i have uploaded a ne journal.php so please download again.

then make a new template called "journal" and put in it:
Code:

{htmldoctype}
<html>
<head>
        <!-- no cache headers -->
        <meta http-equiv="Pragma" content="no-cache">
        <meta http-equiv="no-cache">
        <meta http-equiv="Expires" content="-1">
        <meta http-equiv="Cache-Control" content="no-cache">
        <!-- end no cache headers -->
        <meta name="keywords" content="vbulletin,forum,bbs,discussion,jelsoft">
        <meta name="description" content="$bbtitle is a discussion forum powered by vBulletin. To visit the forum, go to $bburl/ . To find out about vBulletin, go to http://www.vbulletin.com/ .">
        <title>$bbtitle - powered by vBulletin</title>
        $headinclude
</head>
<body>
$header
<br>
$navbar


<table bgcolor="{pagebgcolor}" width="{tablewidth}" cellpadding="0" cellspacing="0" border="0"><tr><td width="10"><img width="10" height="1" src="{imagesfolder}/space.gif" alt=""></td><td width="100%"><!-- spacer -->

<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="{contenttablewidth}" align="center"><tr><td>
<table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
<tr>
        <td bgcolor="$post[backcolor]" width="175" valign="top" nowrap>
        <a name="post$post[postid]"></a>
        $post[firstnewinsert]
        <normalfont><b>$post[username]</b></normalfont><br>
        <smallfont>$post[usertitle]</smallfont><br>
        $post[avatar]<p>
        <smallfont>Registered: $post[joindate]<br>
        Location: $post[field2]<br>
        Posts: $post[posts]</smallfont></td>
       
        <td bgcolor="$post[backcolor]" width="100%" valign="top">
        <smallfont>$post[icon] <b>$post[title]</b></smallfont>
        <p><normalfont>$post[message]</normalfont></p>
        $post[attachment]
        <p>$post[signature]</p>
        <p>$post[editedby]</p>
        <p align="right"><smallfont><a href="report.php?s=$session[sessionhash]&postid=$post[postid]">Report this post to a moderator</a> | $post[iplogged]</smallfont></p>
        </td>
</tr>
<tr>
        <td bgcolor="$post[backcolor]" width="175" height="16" nowrap><smallfont>$post[foldericon]
        $post[postdate] <font color="{timecolor}">$post[posttime]</font></smallfont></td>
       
        <td bgcolor="$post[backcolor]" width="100%" valign="middle" height="16">
                <table width="100%" border="0" cellpadding="0" cellspacing="0">
                <tr valign="bottom">
                        <td><smallfont>$onlinestatus
                        $post[profile] $post[pmlink] $post[useremail] $post[homepage] $post[search] $post[buddy]
                        <!-- $ post[icqicon] --> <!-- $ post[aimicon] --> <!-- $ post[yahooicon] -->
                        </smallfont></td>
                        <td align="right" nowrap><smallfont>
                        <a href="editpost.php?s=$session[sessionhash]&action=editpost&postid=$post[postid]"><img src="{imagesfolder}/edit.gif" border="0" alt="Edit/Delete Message"></a>
                        <a href="newreply.php?s=$session[sessionhash]&action=newreply&postid=$post[postid]"><img src="{imagesfolder}/quote.gif" border="0" alt="Reply w/Quote"></a>
                        </smallfont></td>
                </tr>
                </table>
        </td>
</tr>
</table>
</td></tr></table>

<!-- spacer --></td><td width="10"><img width="10" height="1" src="{imagesfolder}/space.gif" alt=""></td></tr></table>


$footer
</body>

enjoy :)

Jeremy W. 05-25-2002 10:09 PM

Awesome, that fixed that issue! The only other one was the fact that apparently Journal entries from Edit Profile aren't being saved.

When I hit submit and go back the field is still blank, and it is equally blank in the journal.php (which functions gorgeously, thanx!) :)

Xenon 05-26-2002 12:46 AM

hmm, i see, but i can't find an error in my codes.

do you have integratet everything right?

if yes, perhaps there is s.o. else, who could help, cause i don't see the fault... :(

rascal 05-29-2002 07:45 AM

This is quite interesting. If I follow this thread correctly, does this mean the journal is some sort of a blog? Would other members be able to view it?

Xenon 05-29-2002 11:32 AM

yes, every member could see the journal from other members.


All times are GMT. The time now is 05:46 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.01081 seconds
  • Memory Usage 1,756KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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