PDA

View Full Version : Add-On Releases - VBNotes


Jafo232
05-01-2008, 10:00 PM
This is meant to emulate the old VBPad (https://vborg.vbsupport.ru/showthread.php?t=29760) which seems to no longer be in production and died out in version 2.x. A client who is upgrading needed this for their 3.7 site so I wrote it up.

It allows your users to have up to X notepads in their user CP for just themselves. Can set user group permissions.

I will support this as I can but don't expect miracles. Sure, there are many other functions that could be added, but my job was to keep it as close to VBPad as possible so as to not upset the applecart too much. I wrote it completely from scratch and this will NOT upgrade anyones current installation of the old VBPad. The database is completely different as the last version was put together rather poorly.

Enjoy and don't forget to:

Click Install

BlackLord2008
05-02-2008, 06:20 PM
Screen Shots?

Jafo232
05-02-2008, 06:24 PM
Screen Shots?

Hmm figured I would beat the first screenshot request, but alas, everyone is on it too quick.. :)

cafenetland
05-02-2008, 06:38 PM
installed on 3.6.8

thanks alot

Jafo232
05-02-2008, 06:51 PM
Ok, I should mention I have only tested this on 3.7.. Should work on 3.6.x but you never know.

projectego
05-02-2008, 06:59 PM
/me clicks install. Thanks!

Hornstar
05-04-2008, 03:43 AM
Well what would be great is the ability to have a drop down menu of canned messages aka notepad entries from within the postbit and the private messages.

That way it can be very easy to select a notepad entry and post it in the post/thread/private message :)

That would be amazing! Something ive long wanted.

Boofo
05-04-2008, 04:20 AM
Dies this have a list of canned entries or does a box show up for each one? If you had enough entries the page could get very long with just boxes.

tehtide
05-05-2008, 12:11 AM
Got an error:

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'nobody'@'localhost' (using password: NO) in [path]/vbnotes.php on line 45

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in [path]/vbnotes.php on line 45

We are using mysqli to connect to database and this seems to be related to that.

SwollenCranium
05-05-2008, 02:03 AM
Indeed.

I also get a mysql error.

Un installed.

ePrOmD
05-12-2008, 05:54 PM
Hello Jafo232

Thank you for the hack. I´ve it install in vb 3.7 without any problem

I have a query, it is possible that when you click at the notes, ther are opened within the main table. Preserving in this way the control panel side navigation table?

Jafo232
05-12-2008, 06:11 PM
Feel free to edit the template any way you wish to accomplish just that.

Fabsboards
05-15-2008, 07:58 PM
Nice! Thanks!

smooth-c
05-15-2008, 08:19 PM
I've installed it and everything went smoothly but when I try to use the notepad within my control panel - I am confronted with this message..

smooth-c, you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Even though, in my usergroup permissions the vbnote option;

Permission to use VBNotes

Is set to Yes.

Any help?

Jafo232
05-16-2008, 01:54 PM
Do you belong to any other user groups? Make sure they too have permission..

Subah
05-25-2008, 10:51 AM
Great hack but i have 3 suggestions
1- each group have diffrent number of notes can set from group permission
2- the note is shown in the usercp note another page
3- when you set the permissions for a number (ex. 2) the 3rd note apper and when you try to write in it is write after that if the user update the note every thing gone !! and this is not good for important notes :) , hope you can fine some way that is you set the namber no new note place apper :)

King Justice
05-27-2008, 03:58 PM
Questions I have before installing:
- Any SQL/XSS injection vulnerabilities associated?

Dark_Sirius
05-27-2008, 06:41 PM
Nice, installed. :)

Jafo232
05-27-2008, 06:55 PM
Questions I have before installing:
- Any SQL/XSS injection vulnerabilities associated?

None know of at this time.

redlabour
05-29-2008, 06:16 PM
Can we have it as a Tab in our Userprofile and not on a own vB-Site?

Any maybe a Link at the QuickLinks.

:)

Sakai Ray
06-01-2008, 08:35 PM
Thank you very much

joeycano
06-02-2008, 02:42 AM
Did not work for me on 3.7.1. I was not able to see the content after I entered text and pressed "Update Notes"

I just got another blank box appearing.

Also was not able to erase the box as well.

FYI: I'm using: PHP 5.2.3

Boofo
06-02-2008, 02:58 AM
I just noticed the line in the first post that says "the last version was put together rather poorly". I hope you weren't referring to Chen's version.

Jafo232
06-02-2008, 03:53 PM
I just noticed the line in the first post that says "the last version was put together rather poorly". I hope you weren't referring to Chen's version.

I was..

The last version as I recall was set up where each user had a row in the vbnotes table. All of the users messages were in ONE row, parsed by something like |||. In otherwords:

$usernotes = preg_split("/\|\|\|/",$row);

I cannot remember the exact delimiter but that was basically how it went. Sorry, but I think that is a poor design. Each note should have its own row. That is pretty much the point of using SQL. Chen was using the row as if it were a flat file.

It has been a bit since I worked on it, but I recall there were other issues as well.

Boofo
06-02-2008, 05:52 PM
His also had a list where you could choose the note and not a separate box for each one, if I recall. If Chen did it that way, then he had to have a good reason. His code is excellent. ;)

Jafo232
06-02-2008, 06:26 PM
His also had a list where you could choose the note and not a separate box for each one, if I recall. If Chen did it that way, then he had to have a good reason. His code is excellent. ;)

Well, hopefully you do not consider this excellent:

$DB_site->query_first("SELECT lastupdated FROM usernotepad WHERE userid='$bbuserinfo[userid]'")) {
$note=$DB_site->query_first("SELECT * FROM usernotepad WHERE userid='$bbuserinfo[userid]'");
$splitnotes=explode("|||",$note[notes]);

There is no reason for that whatsoever.

Not to mention he includes global.php numerous times. I have attached the only file I could find left of it (they have been deleted from chens thread). :p

Of course, this code is about 7 years old, and I know if you looked at mine from that long ago, it would probably not be much better.

Boofo
06-02-2008, 06:49 PM
At the time, that was considered top of the line coding. vb has come a long way since then. If ol' Chen was around today I think he would still be able to blow us all away with his knowledge. ;)

Do you have any plans on doing the listing of the notes like he did instead of separate boxes? I might be interested in that.

Jafo232
06-02-2008, 07:35 PM
From the hack I saw, it was already in separate boxes. Like I said originally, I basically was just charged to copy it exactly as it was working.

Boofo
06-02-2008, 07:52 PM
No, he had it as a listing that would bring up a box for the said note when you clicked on the link. The way you are doing it would make for one long page if you have enough notes.

Supramania
06-02-2008, 08:35 PM
Just installed on 3.7.1 - seems to work perfectly. Thanks!