vb.org Archive
Page 4 of 4 « First 23 4
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Quick Edit! -Edit posts directly from within the thread itself (https://vborg.vbsupport.ru/showthread.php?t=54851)

EvilLS1 01-18-2004 09:36 PM
Quote:
Originally Posted by David Bott
It does not like this line it seems...

Code:
$subscribed=$DB_site->query_first("SELECT subscribethreadid FROM subscribethread WHERE threadid='$pthreadid' AND userid='$subuserid' LIMIT 1");
Which is line 274.
Try using this query instead:

Code:
$subscribed=$DB_site->query_first("SELECT subscribethreadid FROM subscribethread WHERE userid='$subuserid' LIMIT 1");

David Bott 01-18-2004 09:46 PM
Same issue. It is something in the query for if I // that out, no error.

David Bott 01-18-2004 09:55 PM
Ok, did the fresh functions.php and got the same thing. Even if I made the query something like...
Code:
$subscribed=$DB_site->query_first("SELECT subscribethreadid FROM subscribethread WHERE threadid='353631' AND userid='1' LIMIT 1");
...with hard coded numbers, I receive the error.

If I test the query in PHPMyAdmin it runs without issue.

So, do I need to do something with $subscribed first to set it to work or something. Weird all the same.

David Bott 01-19-2004 03:35 PM
It was missing "global $DB_site;" right about the query call. All good now.

EvilLS1 01-19-2004 03:44 PM
Glad ya got it working.

David Bott 01-19-2004 03:45 PM
To wrap this up, for those that would like to have the hack 1) So that the QuickEdit shows for Admins, Mods, and Super mods on all posts, and 2) To have it check for the status of the thread to see if it is subscribed to or not...here is the code for the template and the /admin/functions.php to use...

Template code...

Code:
<form enctype="multipart/form-data" name="vbulletinform" style="display:inline;" action="editpost.php" method="post" onSubmit="return validate(this)">
<input name="r2" type="radio"  value="" onClick="toggleT('e$post[postid]','s')"><smallfont>QuickEdit</smallfont><br>
 <div id="e$post[postid]" style="VISIBILITY: hidden; POSITION: absolute">
<input type="hidden" name="s" value="$session[sessionhash]">
<input type="hidden" name="action" value="updatepost">
<input type="hidden" name="postid" value="$post[postid]">
<input type="hidden" name="parseurl" value="yes">
<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="1" bgcolor="{tablebordercolor}" {tableouterextra} width="55" align="center"><tr><td>
<table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
<tr>
        <td bgcolor="{tableheadbgcolor}" colspan="2"><normalfont color="{tableheadtextcolor}"><b>Quick Edit</b></normalfont></td>
</tr>
<tr>
        <td bgcolor="{secondaltcolor}" nowrap><normalfont><b>Subject:</b></normalfont></td>
        <td bgcolor="{secondaltcolor}"><normalfont><input type="text" class="bginput" name="title" value="$post[title]" size="55" maxlength="85" tabindex="1"></normalfont></td>
</tr>
<tr>
        <td bgcolor="{secondaltcolor}" valign="top" nowrap><normalfont><b>Message:</b></normalfont>
        <p>
        </td>
        <td bgcolor="{secondaltcolor}">
        <table cellpadding="0" cellspacing="0" border="0">
        <tr valign="top">
                <td><textarea name="message" rows="9" cols="80" wrap="virtual" tabindex="2">$edittext</textarea><br>
<normalfont>
        <input type="submit" class="bginput" name="submit" accesskey="s" value="Save Changes" tabindex="3">
        <input type="reset" class="bginput" value="Reset" tabindex="4">
        </normalfont>
<input type="checkbox" name="signature" value="yes" checked><smallfont>Show Signature?</smallfont>
<input type="checkbox" name="email" value="yes" $emailchecked><smallfont>Subscribe to Thread?</smallfont>
<input name="r2" type="radio" checked value="" onClick="toggleT('e$post[postid]','h')"><smallfont>Close</smallfont>

                </td>
        </tr>
        </table>
        </td>
</tr>
</table>
</td></tr></table>
<br>
</form>
</div>

/admin/functions.php code to use...

Code:
if (($bbuserinfo[usergroupid] ==5) || ($bbuserinfo[usergroupid] ==6) || ($bbuserinfo[usergroupid] ==7) or ($post[username] == $bbuserinfo[username])) {
    $edittext = htmlspecialchars($post[pagetext]);
$subuserid=$post[userid];
$pthreadid=$post[threadid];
if ($subuserid!=0) {
global $DB_site;
$subscribed=$DB_site->query_first("SELECT subscribethreadid FROM subscribethread WHERE threadid='$pthreadid' AND userid='$subuserid' LIMIT 1");
$poop=$subscribed[subscribethreadid];
if ($poop > 0){
$emailchecked="CHECKED";
}else{
$emailchecked="";
}
}

eval("\$quickedit = \"".gettemplate('showthread_quickedit')."\";");
} else {
$edittext="";
$quickedit="";
}

jaliam 01-30-2004 05:01 AM
Excellent hack! I'm loving it!


All times are GMT. The time now is 12:51 AM.
Page 4 of 4 « First 23 4
Show 40 post(s) from this thread on one page

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.01112 seconds
  • Memory Usage 1,740KB
  • 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
  • (5)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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