I made some scripts that import/export templates, forms and css

uHunkler · 2005-06-22 09:30:51

Scott, the situation kept me thinking. I found the reason:

The apostrophe ' in the JS call: onclick="onOff('de'); return false;" hindered your script to place the code in the datafield. When I escape the apostrophe like onclick="onOff(\'de\'); return false;" everything goes well. The line in the code in TXP after the import looks like the first one, the backslash has been deleted during the import.

Can you reproduce the situation? Does it have to do with the MySQL import function? Can you integrate a workaround in your scripts escaping the single quote after having read the files?

I tried a patch of your script, which works for me. One added line replaces the apostrophe with the escaped one:
# update db page table where row name is $template_name
$template_data2 = str_replace("\x27", "\x5c\x27", $template_data);
safe_update("txp_page", "user_html = '$template_data2'", "name = '$template_name [1]'");

I am no PHP programmer, so please look if this patch is ok.

I hope I am on the right way ;-)
Urs

Last edited by uHunkler (2005-06-22 09:37:59)

kemie · 2005-06-22 10:35:05

how did i miss this before???
thank you so much scott, i love being able to edit and back up to my hearts content!

soulship · 2005-06-22 18:50:37

@kemie

Same here kemie. I bookmarked the thread when he made the scripts a year ago and never really needed them until a month ago. I think I spent a hour sifting through my bookmarks to find the damned link. It looks like its geeting good mileage now that its been brought back from the forum boneyard.

The scripts work great and there’s some really great potential here for using this for server migration. export forms/css/pages/image info—>new server—>fresh txp install—>import forms/css/pages/image info NO sql version conflicts! No php version conflicts! It will take a really bad variable out and make it irrelevent. I hope someone jumps in to help him work this into something admin and realize its full potential.

rossharvey · 2005-06-22 22:04:47

Link is down, anyone care to mirror?

soulship · 2005-06-23 01:13:09

It’s up now. here

swf · 2005-06-23 03:21:03

I’m lost when it come to escapeing characters, but at least you figured it out. I don’t really know what your string replace is doing. Is it a fix only for your template or for and single quote?

BTW:
I’m trying to move all my stuff over to a new domain so you can also download here

uHunkler · 2005-06-23 06:23:45

Scott, \x27 is the hex value for the apostrophe (singelquote) ' and \x5c for the backslash. The replacement string \x5c\x27 means \'.

> Is it a fix only for your template or for and single quote?

The line $template_data2 = str_replace("\x27", "\x5c\x27", $template_data); replaces all apostrophes in all files.

I did some research and found the php function addslashes()

“addslashes()
(PHP 3, PHP 4, PHP 5)
addslashes—Quote string with slashes

… An example use of addslashes() is when you’re entering data into a database. For example, to insert the name O’reilly into a database, you will need to escape it. …”

So php has a build in function for the escaping. Before every line starting with “safe_update(…” and “safe_insert(…” you should add the line:

$template_data = addslashes($template_data);

I changed your script and it works as expected. The page part of the file “template-import.php” will look for example:

<pre>
<code>
/* if import==1 and database does not contain entry */
elseif($db_data!=$template_data && $import_new==“1” && $db_data==’‘) { #import into database $template_data = addslashes($template_data); safe_insert(“txp_page”, “name = ‘$template_name¹‘, user_html = ‘$template_data’”); $message = ‘<span class=“notice”>inserted into database</span>’;
}
else { # update db page table where row name is $template_name $template_data = addslashes($template_data); safe_update(“txp_page”, “user_html = ‘$template_data’”, “name = ‘$template_name¹‘”); $message = ‘<span class=“notice”>updated</span>’;
</code>
</pre>

Scott, I think you should update your import script ;-)
And many thanks again for your welthy scripts.
Urs

Last edited by uHunkler (2005-06-23 07:19:18)

swf · 2005-06-23 19:29:13

I’ve updated the plugin to incorporate uHunkler’s suggestion. Seems to work now.

The update is available here

rossharvey · 2005-06-24 08:12:25

Looking forward to trying this when I get home from work, thanks swf.

swf · 2005-06-26 04:03:59

Wonder what ahppened to my semi colin, i know i had one here a minute ago, can ai borrow yours ;)

I’ll fix this right now.

boblet · 2005-08-30 09:22:17

Hey swf,
this looks like exactly what I’ve been wanting – having everything in the db is great and all, but it doesn’t play well with svn. Just a quick question before I fry my site .. er, install this puppy; is it ok for TxP v4?
peace – boblet

boblet · 2005-08-30 09:45:22

ok forget I spoke – this exports and imports successfully in TxP v4. Rockin’!

davidm · 2005-08-30 10:18:21

> boblet wrote:

> ok forget I spoke – this exports and imports successfully in TxP v4. Rockin’!

That’s very cool news I’ll try it !

Thanks for sharing :-)

bizartist · 2005-08-30 17:28:46

I can’t seem to get it to work, I followed the instructions exactly, and the script appears to be running, but the _template folder is empty. I tried it with both 755 and 777 (eek!) permissions on the folder, to no avail. Any ideas?

Textpattern CMS

Textpattern CMS support forum

#31 2005-06-22 09:30:51

Re: I made some scripts that import/export templates, forms and css

#32 2005-06-22 10:35:05

Re: I made some scripts that import/export templates, forms and css

#33 2005-06-22 18:50:37

Re: I made some scripts that import/export templates, forms and css

#34 2005-06-22 22:04:47

Re: I made some scripts that import/export templates, forms and css

#35 2005-06-23 01:13:09

Re: I made some scripts that import/export templates, forms and css

#36 2005-06-23 03:21:03

Re: I made some scripts that import/export templates, forms and css

#37 2005-06-23 06:23:45

Re: I made some scripts that import/export templates, forms and css

#38 2005-06-23 19:29:13

Re: I made some scripts that import/export templates, forms and css

#39 2005-06-24 08:12:25

Re: I made some scripts that import/export templates, forms and css

#40 2005-06-26 04:03:59

Re: I made some scripts that import/export templates, forms and css

#41 2005-08-30 09:22:17

Re: I made some scripts that import/export templates, forms and css

#42 2005-08-30 09:45:22

Re: I made some scripts that import/export templates, forms and css

#43 2005-08-30 10:18:21

Re: I made some scripts that import/export templates, forms and css

#44 2005-08-30 17:28:46

Re: I made some scripts that import/export templates, forms and css

Board footer