482
sorry but you should install a standard theme for the demonstration without any snowflakes and a 500px high banner. what are the standard templates and how do they look like?
A shop for xoops is very interessting and you should present it seriously.
A shop for xoops is very interessting and you should present it seriously.
485
that's strange. I am not sure why is it not working.
maybe it has something to do with your import of user tables or simply with your php version
maybe it has something to do with your import of user tables or simply with your php version
486
yes you can
go to "preferences -> system options -> general settings"
there is a option: "Turn your site off?"
In the field below "Reason for turning off the site" you can set your message
go to "preferences -> system options -> general settings"
there is a option: "Turn your site off?"
In the field below "Reason for turning off the site" you can set your message
490
Ok here are some SQL queries which will help you to export xnews articles to publisher
IMPORTANT:
YOU NEED A FRESH PUBLISHER INSTALL
PLEASE MAKE A BACKUP OF YOUR DATABASE
This export do NOT take care of documents in the xnews articles, only images are transferred
In the SQL queries you need to replace <prefix> with prefix of your tables!
1) First we export the xnews categories and import them to the publisher module
2) --> !! Go to Administration of the Publisher module and SET the PERMISSIONS! !! <--
3) Go to IMAGE MANAGER and create a category with the name publisher
4) Publisher uses the image manager to manager the article images
-> Copy all images from "uploads/xnews/topics/" to "uploads/"
5) INSERT all images in the image manager -> CATEGORY publisher
6) Export all xnews articles to publisher
That's it! I have tested it with a fresh install and it works very well
IMPORTANT:
YOU NEED A FRESH PUBLISHER INSTALL
PLEASE MAKE A BACKUP OF YOUR DATABASE
This export do NOT take care of documents in the xnews articles, only images are transferred
In the SQL queries you need to replace <prefix> with prefix of your tables!
1) First we export the xnews categories and import them to the publisher module
INSERT INTO `<prefix>_publisher_categories`
(`categoryid`,`parentid`,`image`,`name`,`description`,`weight`,`moderator`)
SELECT Topic_id, topic_pid, topic_imgurl, topic_title, topic_description, topic_weight, 1 AS moderator
FROM `<prefix>_nw_topics`
2) --> !! Go to Administration of the Publisher module and SET the PERMISSIONS! !! <--
3) Go to IMAGE MANAGER and create a category with the name publisher
4) Publisher uses the image manager to manager the article images
-> Copy all images from "uploads/xnews/topics/" to "uploads/"
5) INSERT all images in the image manager -> CATEGORY publisher
INSERT INTO `<prefix>_image`(`image_name`, `image_nicename`, `image_mimetype`, `image_display`, `image_weight`, `imgcat_id`)
SELECT
s.picture,
RIGHT(s.picture,13) AS nicename,
CONCAT('image/', RIGHT(s.picture,3)) AS `mimetype`,
1 AS image_display,
0 AS image_weight,
c.imgcat_id
FROM <prefix>_nw_stories s, <prefix>_imagecategory c
WHERE s.picture <> ''
AND c.imgcat_name = 'publisher'
6) Export all xnews articles to publisher
INSERT INTO `<prefix>_publisher_items`(
`itemid`, `uid`, `title`, `datesub`, `status`, `dohtml`, `dosmiley`, `summary`, `body`, `counter`, `categoryid`, `comments`, `rating`, `votes`, `image`, `images`, `dobr`
)
SELECT
st.storyid,
st.uid,
st.title,
st.published,
2 AS Status,
CASE st.nohtml
WHEN 0 THEN 1
WHEN 1 THEN 0
END AS nohtml,
CASE st.nosmiley
WHEN 0 THEN 1
WHEN 1 THEN 0
END AS nosmiley,
st.hometext,
st.bodytext,
st.counter,
st.topicid,
st.comments,
st.rating,
st.votes,
im.image_id,
im.image_id AS pictures,
st.dobr
FROM <prefix>_nw_stories st
LEFT OUTER JOIN <prefix>_image im
ON st.picture = im.image_name
That's it! I have tested it with a fresh install and it works very well
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | May 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|