vb.org Archive
Page 23 of 27 « First 132122 23 2425 Last »
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)
-   -   Improved PM Folderview (https://vborg.vbsupport.ru/showthread.php?t=36764)

Asterik 08-18-2003 11:15 AM
Code:
<!-- Database error in vBulletin 2.3.2:

Invalid SQL: DELETE FROM privatemessage WHERE privatemessageid=20' AND folderid!='-2'
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 '' AND folderid!='-2'' at line 1

mysql error number: 1064

Date: Monday 18th of August 2003 08:06:07 AM
Script: http://www.plugspark.com/forums/forums/private.php
Referer: http://www.plugspark.com/forums/private.php?folderid=-2
 -->
I get this when i try to delete a message :sleep:

kreftt 08-18-2003 08:13 PM
so there is some error in your deletion-code in private.php, most likely a missing ' after privatemessageid=

the hack didnt change a thing at that place, you made that mistake somewhere else.

please post the sections "start do stuff (move, etc) " and "start delete" from your private.php and we'll see what we can do

greetz

kreftt

Asterik 08-18-2003 10:17 PM
Code:
// ############################### start delete ###############################
if ($HTTP_POST_VARS['action']=="dodelete") {
  if (!$delete) {
    eval("standarderror(\"".gettemplate("error_pmnotchecked")."\");");
    exit;
  }

  $privatemessageid=verifyid("privatemessage",$privatemessageid);
  $DB_site->query("DELETE FROM privatemessage WHERE privatemessageid=$privatemessageid AND userid=$bbuserinfo[userid]");

  eval("standardredirect(\"".gettemplate("redirect_pmdelete")."\",\"private.php?s=$session[sessionhash]&folderid=".intval($folderid)."\");");
} #end dodelete

Asterik 08-18-2003 10:19 PM
^-- Start Delete

v-- Start Do Stuff
Code:
if ($HTTP_POST_VARS['action']=="dostuff") {
  $what = '';
  if ($delete!="") {
    $what="delete";
  }
  if ($move!="") {
    $what="move";
  }
  if ($what=="mark") {
    // ************************
    // mark as (un)read
  }
  if ($what=="move") {
    if (is_array($privatemessage)) {
      while(list($key,$val)=each($privatemessage)) {
        $DB_site->query("UPDATE privatemessage SET folderid=".intval($folderid)." WHERE privatemessageid=".intval($key)." AND userid=$bbuserinfo[userid]");
      } //end while
    } else {
      eval("standarderror(\"".gettemplate("error_pmnoselected")."\");");
      exit;
    }
    eval("standardredirect(\"".gettemplate("redirect_pmmove")."\",\"private.php?s=$session[sessionhash]&folderid=".intval($folderid)."\");");
  }
  if ($what=="delete") {
    if (is_array($privatemessage)) {
      while(list($key,$val)=each($privatemessage)) {
        $DB_site->query("DELETE FROM privatemessage WHERE privatemessageid=".intval($key)."' AND folderid!='-2'");
      } //end while
    } else {
      eval("standarderror(\"".gettemplate("error_pmnoselected")."\");");
      exit;
    }
    eval("standardredirect(\"".gettemplate("redirect_pmdelete")."\",\"private.php?s=$session[sessionhash]&folderid=".intval($thisfolder)."\");");
  }

}

kreftt 08-19-2003 02:35 PM
ok, your dostuff-section looks wrong, there is a mistake in the delete-query leading to the error.

there are two more diefferences to how this section should look in 2.3.2, so if you update your dostuff-section to look like this:

Code:
if ($HTTP_POST_VARS['action']=="dostuff") {
  $what = '';
  if ($delete!="") {
    $what="delete";
  }
  if ($move!="") {
    $what="move";
  }
  if ($what=="mark") {
    // ************************
    // mark as (un)read
  }
  if ($what=="move") {
    if (is_array($privatemessage)) {
      while(list($key,$val)=each($privatemessage)) {
        $DB_site->query("UPDATE privatemessage SET folderid=".intval($folderid)." WHERE privatemessageid=".intval($key)." AND userid=$bbuserinfo[userid]");
      } //end while
    } else {
      eval("standarderror(\"".gettemplate("error_pmnoselected")."\");");
      exit;
    }
    eval("standardredirect(\"".gettemplate("redirect_pmmove")."\",\"private.php?s=$session[sessionhash]&amp;folderid=".intval($folderid)."\");");
  }
  if ($what=="delete") {
    if (is_array($privatemessage)) {
      while(list($key,$val)=each($privatemessage)) {
        $DB_site->query("DELETE FROM privatemessage WHERE privatemessageid=".intval($key)." AND userid=$bbuserinfo[userid]");
      } //end while
    } else {
      eval("standarderror(\"".gettemplate("error_pmnoselected")."\");");
      exit;
    }
    eval("standardredirect(\"".gettemplate("redirect_pmdelete")."\",\"private.php?s=$session[sessionhash]&amp;folderid=".intval($thisfolder)."\");");
  }

}
you should be set

and no, this isnt because of my hack ;)

greetz

kreftt

Pseudomizer 08-20-2003 01:26 AM
Hi @LL,

works fine with 2.3.0 and backup PN hack. Good job. *thumbup*

Cheers,

Pseudomizer

PixelFx 09-01-2003 12:48 AM
Great hack, also matts on worked great, just got this installed on my personal site. using vb 2.3.2

question:

you have a ADD FOLDERS section,

how would add a Remove Folders section?

Rob

kreftt 09-01-2003 02:39 AM
you would have to code it yourself, i dont know enough php to do it :(

sorry

kreftt

MaDCaT75 09-01-2003 04:30 AM
Oy..... can someone install this for me? I'm afraid I'll screw it up. :ermm:

Red Blaze 10-15-2003 03:56 PM
Just alittle thing. I installed this, and it looks very good. Only thing is that the gauge won't work. It won't say how much I'm using, nor will the images show up. I installed everything correctly. I'm useing 2.3.2. Any Ideas?


All times are GMT. The time now is 10:00 AM.
Page 23 of 27 « First 132122 23 2425 Last »
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.01455 seconds
  • Memory Usage 1,751KB
  • 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
  • (4)bbcode_code_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