4images Forum & Community
4images Modifications / Modifikationen => Mods & Plugins (Releases & Support) => Plugins => Topic started by: uksoreeyes on June 08, 2003, 06:53:32 AM
-
A simple notepad for your admin control panel. Use it to write yourself reminders or maybe the names of users who you are keeping an eye on. Notes are stored on your MYSQL database so they are always to hand.
--------------------------------------------------------------------
Installation:
- Run MYSQL query
CREATE TABLE admin_notes (
notes text NOT NULL,
width char(3) NOT NULL default '',
height char(3) NOT NULL default '',
FULLTEXT KEY notes (notes)
) TYPE=MyISAM;
INSERT INTO admin_notes VALUES ('Your notes', '100', '10');
- Create a new directory called plugins in your admin folder
- Extract the zip and copy the file notepad.php to the new plugins directory
- Log in to your Control Panel, a new link should appear in the left navigation frame
- Click it to view your notepad
--------------------------------------------------------------------
I hope everyone finds this mod useful.
Carl
-
Can I add to backup list ??
:lol:
-
thanx 8)
-
Thx it work.....
....but i have no use at time....
-
Also ich finde das schon brauchbar!
Ich schreib mir Kleinigkeiten bzw. TODO's hinein.
Auch schreibe ich mir hinein, welche MOD's ich mir installiert habe. Einfach damit ich den Überblick behalte.
Danke /THX for this nixy MOD! :lol:
-
Well, I get an error when trying to execute the SQL... please help...
Failed to execute SQL : SQL CREATE TABLE admin_notes
( notes text NOT NULL, width char(3) NOT NULL default '',
height char(3) NOT NULL default '', FULLTEXT KEY notes (notes) )
TYPE=MyISAM; INSERT INTO admin_notes VALUES
('Your notes', '100', '10'); failed : You have an error in your SQL
syntax near '; INSERT INTO admin_notes VALUES ('Your notes', '100', '10')'
at line 1
And when doing it manually, mysql tells me that "notes" can not have a default value.
So, it is not possible to insert the data as needed...
-
maybe you should try, insert table first then insert data.
that's what i have to do
-
no problems installing/using this MOD - thx!
[BTW - I use it to keep notes to myself of things that need doing every time I run an image challenge - stuff like which files to update, which images to move, what templates to change.
I also use it to keep general notes about MODs I want to try, what things i need to change, snippets of code I want to keep, some IPs and/or users to watch, etc. -
Very handy, since I forget things a lot!]
-
Worked a treat after changing route path.
using as i have 2 admin on board.
Thank you
-
Sorted by removing white space between these 2 rows
<?php // PLUGIN_TITLE: Notepad
$nozip = 1;
to
<?php // PLUGIN_TITLE: Notepad
$nozip = 1;
Working great now
thanks again
-
I just installed the notepad.. works fine so far, But saving results in this error:
DB Error: Bad SQL Query: UPDATE admin_notes SET notes='', width=, height=
You have an error in your SQL syntax near ' height=' at line 1
The refering action in the code looks like this:
$action = $_GET["action"];
if ($action == "update") {
global $site_db;
$sql = "UPDATE admin_notes SET notes='$notes', width=$width, height=$height";
$result = $site_db->query($sql);
printf ("Notepad Updated<br>");
}
-
This plugin does not seems to work on servers with registry_globals turned off...:(
-
Turning register_globals on didn't help either....
-
I just installed the notepad.. works fine so far, But saving results in this error:
DB Error: Bad SQL Query: UPDATE admin_notes SET notes='', width=, height=
You have an error in your SQL syntax near ' height=' at line 1
The refering action in the code looks like this:
$action = $_GET["action"];
if ($action == "update") {
global $site_db;
$sql = "UPDATE admin_notes SET notes='$notes', width=$width, height=$height";
$result = $site_db->query($sql);
printf ("Notepad Updated<br>");
}
That was the error i got untill i did the correction i posted, worked fine after that.
-
no, didn't help either. :(
Can you maybe attach your notpad.php as a zip to this thread?
-
try this works for me
-
Nop... not working. Guess I have to remove it from the plugins again. :(
-
I just installed the notepad.. works fine so far, But saving results in this error:
DB Error: Bad SQL Query: UPDATE admin_notes SET notes='', width=, height=
You have an error in your SQL syntax near ' height=' at line 1
Hi,
i have the same problem too!
DB Error: Bad SQL Query: UPDATE admin_notes SET notes='', width=, height=
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 ' height=' at line 1
Notepad Updated
my 4images version is 1.7.4!
Best Regards
m.a
-
I've just installed it and it works perfectly fine!
Its even great to leave a message for another admin...
Thanx a lot!
-
I've just installed it and it works perfectly fine!
Its even great to leave a message for another admin...
Thanx a lot!
Hi FunnyUser,
is your 4images version 1.7.4?
m.a
-
Hi FunnyUser,
is your 4images version 1.7.4?
Sorry I forgot to post that: Yes, I'm using Version: 1.7.4 too.
enjoy yourself!
-
hi,
it is not working for me too.
i use version 1.7.4
Error:
Warning: require(./../admin/admin_global.php) [function.require]: failed to open stream: No such file or directory in ...4images/admin/plugins/notepad.php on line 7
Fatal error: require() [function.require]: Failed opening required './../admin/admin_global.php' (include_path='.:/usr/.../usr/share/pear') in .../4images/admin/plugins/notepad.php on line 7
-
Warning: require(./../admin/admin_global.php) [function.require]: failed to open stream: No such file or directory in ...4images/admin/plugins/notepad.php on line 7
$root_path = (!eregi("\/plugins\/", $_SERVER['PHP_SELF'])) ? "../" : "../../";
DB Error: Bad SQL Query: UPDATE admin_notes SET notes='', width=, height=
You have an error in your SQL syntax near ' height=' at line 1
if ($action == "update") {
global $site_db;
// extra code to fill the $var
$notes = $_POST["notes"];
$width = $_POST["width"];
$height = $_POST["height"];
//
$sql = "UPDATE admin_notes SET notes='$notes', width=$width, height=$height";
$result = $site_db->query($sql);
printf ("Notepad Updated<br>");
}
-
perfect!
-
perfect!
Hi all
i have the same problem too!
DB Error: Bad SQL Query: UPDATE admin_notes SET notes='', width=, height=
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 ' height=' at line 1
Notepad Updated
what can i do?
-
Version 1.7.4 > 1.7.6
Error, Fehler
DB Error: Bad SQL Query: UPDATE admin_notes SET notes='', width=, height=
:flag-en: search
:flag-de: suche
if ($action == "update") {
global $site_db;
$sql = "UPDATE admin_notes SET notes='$notes', width=$width, height=$height";
$result = $site_db->query($sql);
printf ("Notepad Updated<br>");
}
:flag-en: replace
:flag-de: ersetze
if ($action == "update") {
global $site_db;
// extra code to fill the $var
$notes = $_POST["notes"];
$width = $_POST["width"];
$height = $_POST["height"];
//
$sql = "UPDATE admin_notes SET notes='$notes', width=$width, height=$height";
$result = $site_db->query($sql);
printf ("Notepad Updated<br>");
}
-
Warning: require(./../admin/admin_global.php) [function.require]: failed to open stream: No such file or directory in /home/pixie76/public_html/gallery/admin/plugins/notepad.php on line 7
Fatal error: require() [function.require]: Failed opening required './../admin/admin_global.php' (include_path='.:/x10hosting/php1/pear') in /home/pixie76/public_html/gallery/admin/plugins/notepad.php on line 7
-
Worked very well with 4images 1.7.9 till my Webhoster changed register_globals to off this morning. Now I get the same error as in posting above.
Too bad, I've used it very often. :(