vb.org Archive
Page 14 of 16 « First 41213 14 1516
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)
-   -   Private Text Message Hack v1.0 (https://vborg.vbsupport.ru/showthread.php?t=42444)

ExAvIoUr 08-20-2002 08:26 PM
Find in Showthread (Line 69):

Code:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
// +++++++ Private Text Hack [ g-force2k2 ] +++++++
post.dopriv AS dopriv, post.privmsg AS privmsg, post.privuser AS privuser,
// +++++++ Private Text Hack [ g-force2k2 ] +++++++
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
replace with

Code:
        SELECT
        post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
        // +++++++ Private Text Hack [ g-force2k2 ] +++++++
        post.dopriv AS dopriv, post.privmsg AS privmsg, post.privuser AS privuser,
// +++++++ Private Text Hack [ g-force2k2 ] +++++++
        attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
        ".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
        FROM post
        ".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
        LEFT JOIN user ON user.userid=post.userid
        LEFT JOIN userfield ON userfield.userid=user.userid
        ".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                              LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
        LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
If that doesn't work, I don't know :( Just trying to suggest solutions.

Boofo 08-20-2002 11:11 PM
Actually, I think that has to do with Xenon's "Extra Edit Options for Admins" hack, if that helps at all. :)

Quote:
Originally posted by g-force2k2
yeah its the same as you probably had... just means that i have to make Xenon's double post hack compatible with this hack... just give me soemtime and i'll go about doing something of the sort ;)

g-force2k2

g-force2k2 08-21-2002 02:18 AM
empreur76

to solve the sql error simply just remove my coding slashes... for some reason on the second edit of the showthread for that query it will error out...

so just make this coding:

PHP Code:
// +++++++ Private Text Hack [ g-force2k2 ] +++++++
post.dopriv AS dopriv, post.privmsg AS privmsg, post.privuser AS privuser,
// +++++++ Private Text Hack [ g-force2k2 ] +++++++ 
and change it to this:

PHP Code:
post.dopriv AS dopriv, post.privmsg AS privmsg, post.privuser AS privuser, 
hoep that fixes your problem :)

g-force2k2

Odil 08-21-2002 01:29 PM
It's a great hack, I just want to know if it's possible to private message more than one person per message?

Odil

empreur76 08-21-2002 01:50 PM
ok very thanks !!
it's ok for me !!! but i have a question!!

only admin can make private message ! ?
i make change in usergroup for member but this don't work, the member can't make message !!
!?

g-force2k2 08-21-2002 02:44 PM
Quote:
Originally posted by Odil
It's a great hack, I just want to know if it's possible to private message more than one person per message?

Odil
No at the moment its only possible to private text message one person... but maybe in the near future i will make an addon to make this possible :)

empreur76 :: are you sure that everythign is correct? im trying to think of what could be wrong... just make sure that the usergroups are configured correctly... if not then i will do what i can to help ;)

g-force2k2

Odil 08-21-2002 06:32 PM
Hi again

I have noticed that in a few of my forums the private text box doesn't appear. There is no option to turn this on or off on each forum. Any ideas what can be wrong?

Odil

g-force2k2 08-22-2002 01:16 AM
No there isn't an option... but are you sure that you have the correct permissions? And is this for the adding or editing of the private text messages? Regards...

g-force2k2

Tim Wheatley 08-22-2002 06:58 PM
Ok it works, Sorry for the delay but the fixes in post 46 worked for me. Thank you. :)

Xenon 08-22-2002 07:10 PM
g-force: i have had a look at your code, everything seems ok, but may i suggest a optimization? (could perhaps also help with next version alowing more users to view...)

i see your privacy infos depent on the username, that's no problem as long as you don't change someones username because he want....

you should convert the username into the userid and just save the userid of the user a private message is shown, so he can always read the message, no matter if he changes his name somewhere in future.

as said this could help later also with adding more users to view this...

just a suggestion :)


All times are GMT. The time now is 11:35 AM.
Page 14 of 16 « First 41213 14 1516
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.03295 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
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (2)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
  • (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