How to change Copyright (if everything else fails)

Darkcloud4491 posted 10th of August 2009 in Tips & Tricks. 22 comments.




Step 1: Log Into phpMyAdmin (Or The Software You Use to explore MySQL Databases)


Step 2: Confirm The Language Key ID and Language ID:


SELECT * FROM sys_localization_strings WHERE String LIKE '%©%';

Step 3: Update The Copyright for your desired language:


UPDATE sys_localization_strings SET String = 'copy; {0} Сетевые Studios' WHERE IDKey = '1401' AND IDLanguage = '2';


(This has been cleaned up a lot)




Please login to post a comment.
yeah its long but it works (remember to remove the comment line as it might mess up the database) and only do this if nothing else works best to use MSword to edit as notepad don't do it line by line
forgot to say you need to re-compile your lanfguage aswell after
So....... exactly why do we need this?
This is going to confuse the hell out of people, all that is needed to change copyright, is to change in the admin and in the corresponding language file that's it that's all. Very Simple!!!!!
This is how the United States government would change the copyright notice.
And if Boonex were to bust their butts for removing copyright without a valid license, they would blame the terrorists for sure.
But only after appointing a commission to study the issue for 6 months
And the cost would be a taxpayer burden,
Those with a really old copyright notice, could turn it in for a cash credit toward a new copyright notice.
Republicans would just change the language string.
But the Democrats would argue that just changing the language string would do nothing to stimulate the economy and create jobs.
You could, like, possibly, even just maybe, theoretically, just write a single update query that addresses the field concerned with the copyright notice, and that might possibly be a bit shorter and accomplish the same task, and I believe you could also thereby avert clearing out the whole damn earlier table with all of its values with this surgical fix. I appreciate the enthusiasm though!
I suppose that wasn't too helpful now, was it. Sorry for the rowdy feedback, Houston got me going lively! This is what I mean:

UPDATE `sys_localization_strings`
SET String = 'My New Copyright Message'
WHERE IDKey = 3;

Since most folks will log into PHPMyAdmin in any case to apply this, they can also just use the interface to change the contents of this field in the sys_local table.

N.B. If you edit SQL files (or any other code), never use a word processor as they are infamous for changing see more characters and messing up code. Use a real code editor, like Notepad++. It's good to have one installed for the occasional tweak, even if you aren't into code.
yeah CodeSatori has the right idea with software but i used Microsoft word as it puts it line by line. just remember this should only be done if NOTHING ELSE works. And FYI editing the language file dose not work. (tried that aswell)
I can't wait for your next, little fix. Maybe you can knock out a 40 page report on how to change the logo image.
erm no. everyone know all you need is somthing like photoshop or use cooltext logo maker
I edited the copyright using the language file with no problemo!!
This post was entertaining
please be careful taking tutorials from anybody who would use Microsoft word to edit webpages. darkcloud, im sure you meant well with this post, and as codesatori says, that most have phpmyadmin, and there is a UI that would all them to simply edit the field, and hit go after that. im a bit concerned that you would consider microsoft word a good editor for editing anything other than word files.

SOLUTIONS: if you need an editor, one that works well, and will not inject its own garbage see more into your files unknowingly


Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License.

Based on a powerful editing component Scintilla, Notepad++ is written in C++ and uses pure Win32 API and STL which ensures a higher execution speed and smaller program size. By optimizing as many routines as possible without losing user friendliness, Notepad++ is trying to reduce the world carbon dioxide emissions. When using less CPU power, the PC can throttle down and reduce power consumption, resulting in a greener environment.

This project is mature. However, there may be still some bugs and missing features that are being worked on. If you have any questions or suggestions about this project, please post them in the forums. Also, if you wish to make a feature request, you can post it there as well. But there's no guarantee that I'll implement your request.

You're encouraged to translate Notepad++ into your native tongue if there's not already a translation present in the Download Section. And if you want, help translating Notepad++ official site into your native tongue would be greatly appreciated.

I hope you enjoy Notepad++ as much as I enjoy coding it.

Continued: 2000 character Limit
Here are the features of Notepad++ :
Syntax Highlighting and Syntax Folding

Supported languages :
C C++ Java C# XML HTML
PHP CSS makefile ASCII art (.nfo) doxygen ini file
batch file Javascript ASP VB/VBS SQL Objective-C
RC resource file Pascal Perl Python Lua TeX
TCL Assembler Ruby Lisp Scheme Properties
Diff Smalltalk Postscript VHDL Ada Caml
AutoIt KiXtart Matlab Verilog Haskell InnoSetup
CMake YAML COBOL D R PowerShell

If you have a colour printer, print your see more source code (or whatever you want) in colour.
User Defined Syntax Highlighting

It allows user to define his own language : not only the syntax highlighting keywords, but also the syntax folding keywords, comment keywords and the operators. ( screenshot1, screenshot2, screenshot3, screenshot4 ).

For most supported languages, user can make his/her own API list (or download the api files from dowload section). Once the api file is ready, type Ctrl+Space to launch this action (see screenshot). For more information about Auto-completion, please see Auto-completion HOWTO.

You can edit several documents at the same time.
i will have to give you credit on getting past the 2000 word limit on the blog post though. found that to be interesting. maybe the 2000 word limit is only on the comments?

oh well yeah that was an excruciatingly long post you have done here, and wish it would be edited, because its not really necessary to have all that on here as something as that needs to be done that is as simple as changing the copyright on the footer of boonex.
Is there a simple way to to change login Username to Email
I've gone through D7's builder and can't find anything to change to that preference it would be a great help if anyone can help.