Freesn: Unterschied zwischen den Versionen

Aus Vosp.info
Wechseln zu:Navigation, Suche
(Fix Search)
 
(6 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 17: Zeile 17:
  
 
=== Mysql einspielen===
 
=== Mysql einspielen===
 +
cd /var/www/freeSN/include/System/sql
 +
 +
 +
==== Vorbereiten ====
 +
create database ncfreesn_nc
 +
 +
GRANT ALL PRIVILEGES ON ncfreesn_nc.* TO nc IDENTIFIED BY 'xxxxxxxxxx';
 +
 +
UPDATE `mysql`.`db` SET `Host` = 'localhost', `Select_priv` = 'Y', `Insert_priv` = 'Y', `Update_priv` = 'Y', `Delete_priv` = 'Y', `Create_priv` = 'Y', `Drop_priv` = 'Y', `Create_view_priv` = 'Y', `Show_view_priv` = 'Y', `Create_routine_priv` = 'Y', `Alter_routine_priv` = 'Y', `Execute_priv` = 'Y' WHERE CONVERT( `Db` USING utf8 ) = 'ncfreesn_nc' AND `User`= 'nc' LIMIT 1 ;
 +
 +
UPDATE `mysql`.`db` SET `Host` = 'localhost', `Select_priv` = 'Y', `Insert_priv` = 'Y', `Update_priv` = 'Y', `Delete_priv` = 'Y', `Create_priv` = 'Y' WHERE CONVERT( `Db` USING utf8 ) = 'ncfreesn_sn_srequest' AND `User`= 'nc' LIMIT 1 ;
 +
  update mysql.user set Host='localhost' where User='nc';
 +
 +
FLUSH PRIVILEGES;
 
====Falls Datenbank erst gelöscht werden muss ====
 
====Falls Datenbank erst gelöscht werden muss ====
 
  SET FOREIGN_KEY_CHECKS=0;  
 
  SET FOREIGN_KEY_CHECKS=0;  
Zeile 23: Zeile 37:
 
  create database ncfreesn_nc;
 
  create database ncfreesn_nc;
 
  \. MySql_InsertExampleFreesn.sql
 
  \. MySql_InsertExampleFreesn.sql
 
  
 
===Design ===
 
===Design ===
Zeile 37: Zeile 50:
  
 
  cp ./include/System/xsl/$OLDDESGNDIR ./include/System/xsl/$NEWDESGNDIR
 
  cp ./include/System/xsl/$OLDDESGNDIR ./include/System/xsl/$NEWDESGNDIR
 +
 +
 +
=== Fix Search ===
 +
freeSN/include/System/jscripts/mc_XMLChoose.inc.js:
 +
 +
function fnc_search(){
 +
...
 +
fnc_xmlChooserShowBC(10, window.document.getElementById("searchAim").value, "search", "in",  obj_lang["search"+window.document.getElementById("searchAim").value], window.document.getElementById("searchValue").value);
 +
}
 +
 +
Die ID:10 muss angepasst werden zum Such BasisElement

Aktuelle Version vom 16. Oktober 2015, 12:45 Uhr

freeSN

Software

unter Debian Jessie
apt-get install apache2 php5 mysql-server-5.5 php5-mysql php5-gd php-pear php5-xsl git phpunit php5-curl

pear install --alldeps XML_Parser
pear install --alldeps XML_RSS
pear install --alldeps channel://pear.php.net/HTML_Common2
ln -s /usr/share/php /var/www
ln -s /usr/share/php/XML/ /usr/share/php5/
ln -s /usr/share/php/PEAR /usr/share/php5/
ln -s /usr/share/php/PEAR5.php /usr/share/php5/
ln -s /usr/share/php/PEAR.php /usr/share/php5/


Mysql einspielen

cd /var/www/freeSN/include/System/sql


Vorbereiten

create database ncfreesn_nc
GRANT ALL PRIVILEGES ON ncfreesn_nc.* TO nc IDENTIFIED BY 'xxxxxxxxxx';
UPDATE `mysql`.`db` SET `Host` = 'localhost', `Select_priv` = 'Y', `Insert_priv` = 'Y', `Update_priv` = 'Y', `Delete_priv` = 'Y', `Create_priv` = 'Y', `Drop_priv` = 'Y', `Create_view_priv` = 'Y', `Show_view_priv` = 'Y', `Create_routine_priv` = 'Y', `Alter_routine_priv` = 'Y', `Execute_priv` = 'Y' WHERE CONVERT( `Db` USING utf8 ) = 'ncfreesn_nc' AND `User`= 'nc' LIMIT 1 ;
UPDATE `mysql`.`db` SET `Host` = 'localhost', `Select_priv` = 'Y', `Insert_priv` = 'Y', `Update_priv` = 'Y', `Delete_priv` = 'Y', `Create_priv` = 'Y' WHERE CONVERT( `Db` USING utf8 ) = 'ncfreesn_sn_srequest' AND `User`= 'nc' LIMIT 1 ;
 update mysql.user set Host='localhost' where User='nc';
FLUSH PRIVILEGES;

Falls Datenbank erst gelöscht werden muss

SET FOREIGN_KEY_CHECKS=0; 
drop database ncfreesn_nc;

Beispieldaten

create database ncfreesn_nc;
\. MySql_InsertExampleFreesn.sql

Design

zB.:
$OLDDESGNDIR=mensch.coop
$NEWDESGNDIR=netz.coop
Neues Design:
cp ./include/Forest/$OLDDESGNDIR ./include/Forest/$NEWDESGNDIR 
Find/Replace $OLDDESGNDIR with $NEWDESGNDIR in all Files under $NEWDESGNDIR
cp ./include/System/xsl/$OLDDESGNDIR ./include/System/xsl/$NEWDESGNDIR


Fix Search

freeSN/include/System/jscripts/mc_XMLChoose.inc.js:
function fnc_search(){
...
		fnc_xmlChooserShowBC(10, window.document.getElementById("searchAim").value, "search", "in",   obj_lang["search"+window.document.getElementById("searchAim").value], window.document.getElementById("searchValue").value);
}
Die ID:10 muss angepasst werden zum Such BasisElement