Menu
▾
▴
mydynaweb-cvs-commits
|
From: mdw c. <myd...@li...> - 2001-08-28 13:55:05
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql/upgrades
Modified Files:
core_text.sql
Log Message:
Just added translation stuff for the login box...
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -3 -r1.19 -r1.20
--- core_text.sql 2001/08/02 22:55:57 1.19
+++ core_text.sql 2001/08/28 13:55:04 1.20
@@ -1,5 +1,15 @@
DELETE FROM core_text;
+INSERT INTO core_text VALUES ('LOGOUT', 'EN', 'Log Out');
+INSERT INTO core_text VALUES ('LOGOUT', 'FR', 'Sortie');
+INSERT INTO core_text VALUES ('LOGOUT', 'ES', 'Log Out');
+INSERT INTO core_text VALUES ('LOGOUT', 'DE', 'Log Out');
+
+INSERT INTO core_text VALUES ('LOGGED_IN_AS', 'EN', 'Logged : ');
+INSERT INTO core_text VALUES ('LOGGED_IN_AS', 'FR', 'Connecté : ');
+INSERT INTO core_text VALUES ('LOGGED_IN_AS', 'ES', 'Logged : ');
+INSERT INTO core_text VALUES ('LOGGED_IN_AS', 'DE', 'Logged : ');
+
INSERT INTO core_text VALUES ('THIS_SITE_IS_RUNNING', 'EN', 'This site is running');
INSERT INTO core_text VALUES ('THIS_SITE_IS_RUNNING', 'FR', 'Ce site tourne sous');
INSERT INTO core_text VALUES ('THIS_SITE_IS_RUNNING', 'DE', 'This site is running');
|
|
From: mdw c. <myd...@li...> - 2001-09-20 21:20:20
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Log Message: Directory /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 added to the repository |
|
From: mdw c. <myd...@li...> - 2001-09-20 21:23:48
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Added Files: alter-comment.sql Log Message: Adding a new little feature whiwh is asking guest for name and email when posting a comment on a news. MDW then store the values (name & email) into a cookie and use them for next submission. When displaying the comment, guest's name is displayed whith a link on his email. BE CARREFUL : There is a DB upgrade to do, on the comments table : we must add the field user_mail. Launch sql/db_upgrade/from-0.3.5__to-0.3.6/alter-comments.sql on your db after cvs updating... enjoy:) Alexis. |
|
From: mdw c. <myd...@li...> - 2001-10-04 21:28:21
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql/upgrades
Modified Files:
core_text.sql
Log Message:
byte
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -3 -r1.20 -r1.21
--- core_text.sql 2001/08/28 13:55:04 1.20
+++ core_text.sql 2001/10/04 21:28:20 1.21
@@ -1,5 +1,10 @@
DELETE FROM core_text;
+INSERT INTO core_text VALUES ('BYTES', 'EN', 'bytes');
+INSERT INTO core_text VALUES ('BYTES', 'FR', 'octets');
+INSERT INTO core_text VALUES ('BYTES', 'EN', 'bytes');
+INSERT INTO core_text VALUES ('BYTES', 'EN', 'bytes');
+
INSERT INTO core_text VALUES ('LOGOUT', 'EN', 'Log Out');
INSERT INTO core_text VALUES ('LOGOUT', 'FR', 'Sortie');
INSERT INTO core_text VALUES ('LOGOUT', 'ES', 'Log Out');
|
|
From: mdw c. <myd...@li...> - 2001-10-04 21:29:01
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql/upgrades
Modified Files:
core_text.sql
Log Message:
byte
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -3 -r1.21 -r1.22
--- core_text.sql 2001/10/04 21:28:20 1.21
+++ core_text.sql 2001/10/04 21:29:01 1.22
@@ -2,8 +2,8 @@
INSERT INTO core_text VALUES ('BYTES', 'EN', 'bytes');
INSERT INTO core_text VALUES ('BYTES', 'FR', 'octets');
-INSERT INTO core_text VALUES ('BYTES', 'EN', 'bytes');
-INSERT INTO core_text VALUES ('BYTES', 'EN', 'bytes');
+INSERT INTO core_text VALUES ('BYTES', 'DE', 'bytes');
+INSERT INTO core_text VALUES ('BYTES', 'ES', 'bytes');
INSERT INTO core_text VALUES ('LOGOUT', 'EN', 'Log Out');
INSERT INTO core_text VALUES ('LOGOUT', 'FR', 'Sortie');
|
|
From: mdw c. <myd...@li...> - 2001-10-09 14:21:40
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql/upgrades
Modified Files:
core_text.sql
Log Message:
Adding ...
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.24
retrieving revision 1.25
diff -u -3 -r1.24 -r1.25
--- core_text.sql 2001/10/09 11:00:35 1.24
+++ core_text.sql 2001/10/09 14:21:39 1.25
@@ -1,5 +1,16 @@
DELETE FROM core_text;
+INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'EN', 'Here are the last 5 news sorted by categories.');
+INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'FR', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
+INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'DE', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
+INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'ES', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
+
+INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'EN', 'News Contents');
+INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'FR', 'Sommaire des nouvelles');
+INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'DE', 'News Contents');
+INSERT INTO core_text VALUES ('ACCUEIL_GENERAL', 'ES', 'News Contents');
+
+
INSERT INTO core_text VALUES ('BYTES', 'EN', 'bytes');
INSERT INTO core_text VALUES ('BYTES', 'FR', 'octets');
INSERT INTO core_text VALUES ('BYTES', 'DE', 'bytes');
|
|
From: mdw c. <myd...@li...> - 2001-10-09 14:22:11
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.3 Modified Files: alter-news.sql Log Message: Adding ... =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.3/alter-news.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -3 -r1.1 -r1.2 --- alter-news.sql 2001/07/09 14:07:29 1.1 +++ alter-news.sql 2001/10/09 14:21:39 1.2 @@ -1,8 +1,4 @@ -ALTER TABLE news ADD family int not null default 1; -UPDATE NEWS SET family = 1; -ALTER TABLE news ADD is_online int not null default 0; -UPDATE NEWS SET is_online = 1; ALTER TABLE news CHANGE user user_name varchar(30) not null default ''; |
|
From: mdw c. <myd...@li...> - 2001-10-29 14:30:45
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Added Files: alter-news.sql Log Message: *** DB UPGRADE *** Table : news (the news table) Field : titre (the titl of the news) Comment : Now the title field of the table "news" is set to 50 chars instead of 35 which was a little bit restrictive. |
|
From: mdw c. <myd...@li...> - 2001-11-02 16:02:18
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql/upgrades
Modified Files:
core_text.sql
Log Message:
Adding the what's up box.
To use it add in main.html :
~WHATSUP_BOX~
it shows the last news posted and the last comment posted
enjoy !
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.25
retrieving revision 1.26
diff -u -3 -r1.25 -r1.26
--- core_text.sql 2001/10/09 14:21:39 1.25
+++ core_text.sql 2001/11/02 16:02:17 1.26
@@ -1,5 +1,20 @@
DELETE FROM core_text;
+INSERT INTO core_text VALUES ('WHAZAA', 'EN', 'What''s Up ?');
+INSERT INTO core_text VALUES ('WHAZAA', 'FR', 'Quoi de neuf ?');
+INSERT INTO core_text VALUES ('WHAZAA', 'ES', 'What''s Up ?');
+INSERT INTO core_text VALUES ('WHAZAA', 'DE', 'What''s Up ?');
+
+INSERT INTO core_text VALUES ('DERNIER_COMMENTAIRE', 'EN', 'Last comment');
+INSERT INTO core_text VALUES ('DERNIER_COMMENTAIRE', 'FR', 'Dernier commentaire');
+INSERT INTO core_text VALUES ('DERNIER_COMMENTAIRE', 'DE', 'Last comment');
+INSERT INTO core_text VALUES ('DERNIER_COMMENTAIRE', 'ES', 'Last comment');
+
+INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'EN', 'Last piece of news');
+INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'FR', 'Dernière nouvelle');
+INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'DE', 'Dernière nouvelle');
+INSERT INTO core_text VALUES ('DERNIERE_NEWS', 'ES', 'Dernière nouvelle');
+
INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'EN', 'Here are the last 5 news sorted by categories.');
INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'FR', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
INSERT INTO core_text VALUES ('DERNIERES_NEWS', 'DE', 'Voici les 5 dernière nouvelles pour chaque catégorie.');
|
|
From: mdw c. <myd...@li...> - 2001-11-11 23:39:59
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql/upgrades
Modified Files:
core_text.sql
Log Message:
Thanks to Branko DEFAR, MyDynaWeb speaks now "Slovenian" !
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/upgrades/core_text.sql,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -3 -r1.26 -r1.27
--- core_text.sql 2001/11/02 16:02:17 1.26
+++ core_text.sql 2001/11/11 23:39:58 1.27
@@ -1,5 +1,8 @@
DELETE FROM core_text;
+
+
+
INSERT INTO core_text VALUES ('WHAZAA', 'EN', 'What''s Up ?');
INSERT INTO core_text VALUES ('WHAZAA', 'FR', 'Quoi de neuf ?');
INSERT INTO core_text VALUES ('WHAZAA', 'ES', 'What''s Up ?');
@@ -771,4 +774,126 @@
INSERT INTO core_text VALUES ('ANONYMOUS','FR','Anonyme');
INSERT INTO core_text VALUES ('ANONYMOUS','ES','\\Anonymous');
INSERT INTO core_text VALUES ('ANONYMOUS','DE','\\Anonymous');
+
+
+
+
+INSERT INTO core_text VALUES ('THIS_SITE_IS_RUNNING','SI','To stran
+poganja');
+INSERT INTO core_text VALUES ('ABOUT_THIS_WEBSITE','SI','Predstavitev web
+strani');
+INSERT INTO core_text VALUES ('SHOW_REFERERS','SI','Prika_i reference');
+INSERT INTO core_text VALUES ('THEME','SI','Teme');
+INSERT INTO core_text VALUES ('ACTIVE_THIS_THEME','SI','Omogo_i');
+INSERT INTO core_text VALUES ('ACTION','SI','Izberi akcijo');
+INSERT INTO core_text VALUES ('THEME_NAME','SI','Ime teme');
+INSERT INTO core_text VALUES ('SEARCH_RESULTS','SI','Rezultat poizvedbe');
+INSERT INTO core_text VALUES ('NO_NEWS_MATCH_YOUR_CRITERIA','SI','V bazi ni novic, ki bi ustrezale va_emu kriteriju.');
+INSERT INTO core_text VALUES ('WE_LOOK_FOR_THE_KEYWORD','SI','Novice, katere vsebujejo string : ');
+INSERT INTO core_text VALUES ('WE_LOOK_FOR_NEWS_POSTED_BY','SI','Novice, katerih avtor je : ');
+INSERT INTO core_text VALUES
+('WE_LOOK_FOR_NEWS_BOUND_TO_CATEGORY','SI','Novice, katere spadajo v kategorijo : ');
+INSERT INTO core_text VALUES
+('WE_LOOK_FOR_NEWS_BOUND_TO_TOPIC','SI','Novice, katerih predmet je : ');
+INSERT INTO core_text VALUES ('FROM_THE_CATEGORY','SI','Iz kategorije : ');
+INSERT INTO core_text VALUES ('ADVANCED_SEARCH','SI','Napredno iskanje');
+INSERT INTO core_text VALUES ('ALL_THOSE_OPTIONS_ARE_OPTIONAL','SI','Note that all options below are optionnal. You can choose at least one of them or more if you like to. If you choose to ask the search engine with mixed criterias, not that it will be much restrictive.');
+INSERT INTO core_text VALUES ('CHOOSE_USER','SI','Izberite uporabnika');
+INSERT INTO core_text VALUES ('CHOOSE_CATEGORY','SI','Izberite kategorijo');
+INSERT INTO core_text VALUES ('CHOOSE_TOPICS','SI','Izberite predmet pogovora');
+INSERT INTO core_text VALUES ('CHOOSE_KEYWORD','SI','Vnesite besedo');
+INSERT INTO core_text VALUES ('HITS','SI','Zadetkov');
+INSERT INTO core_text VALUES ('CATEGORY','SI','Kategorija');
+INSERT INTO core_text VALUES ('TOPIC','SI','Predmet pogovora');
+INSERT INTO core_text VALUES ('COMMENT','SI','Komentar');
+INSERT INTO core_text VALUES ('EMAIL_FRIEND','SI','Forward');
+INSERT INTO core_text VALUES ('POST_NEWS','SI','Pošlji novico');
+INSERT INTO core_text VALUES ('CH_PASSWD','SI','Spremeni geslo');
+INSERT INTO core_text VALUES ('LOGIN_HAS_FAILED','SI','Nepravilna kombinacija Uporabnik/Geslo !');
+INSERT INTO core_text VALUES ('YOUR_SESSION_HAS_EXPIRED','SI','Va_ pi_kotek je potekel !');
+INSERT INTO core_text VALUES ('COMMENT_HEADER_TEXT','SI','You can here post a comment. <br>Be aware that HTTP and FTP URL will be detected. <br> Do not put the <A HREF=\"...\"> tag.');
+INSERT INTO core_text VALUES ('Y_C_SEND_EMAIL','SI','You can send this news item to the following email addresses :');
+INSERT INTO core_text VALUES ('NEWS_HEAD','SI','Vnesite glavo novih novic');
+INSERT INTO core_text VALUES ('NEWS_BODY','SI','Vnesite telo novih novic');
+INSERT INTO core_text VALUES ('FORWARD_TITLE','SI','News Forwarder');
+INSERT INTO core_text VALUES ('TITLE','SI','Predmet');
+INSERT INTO core_text VALUES ('CHOOSE_REPLY','SI','Odgovori : ');
+INSERT INTO core_text VALUES ('COMMENT_HEAD','SI','Enter here the content of your comment <br>(HTML tags allowed : <B> <I> <LI> )');
+INSERT INTO core_text VALUES ('SUBMIT','SI','That\'s OK !');
+INSERT INTO core_text VALUES ('PAGE_VIEW','SI','Page view');
+INSERT INTO core_text VALUES ('VISIT','SI','Visit');
+INSERT INTO core_text VALUES ('USER','SI','Uporabnik');
+INSERT INTO core_text VALUES ('STATS_CONTENT','SI','Here are the stats for the ');
+INSERT INTO core_text VALUES ('STATS_SORRY_CONTENT','SI','You don\'t have permission to see the stats.');
+INSERT INTO core_text VALUES ('STATS_TITLE','SI','Traffic Stats');
+INSERT INTO core_text VALUES ('STATS_SORRY_TITLE','SI','Private Stats');
+INSERT INTO core_text VALUES ('NEWS_LETTER_REGISTRATION','SI','Welcome to the News Letter registration');
+INSERT INTO core_text VALUES ('NEWS_LETTER_THANKS','SI','Thank you for submitting your email !');
+INSERT INTO core_text VALUES ('NEWS_LETTER_SAVE_OK','SI','We have successfully saved your email. You will recieve the next news letter of our site. Thanks a lot for your interest !');
+INSERT INTO core_text VALUES ('NEWS_LETTER','SI','News Letter');
+INSERT INTO core_text VALUES ('ENTER_EMAIL','SI','Vnesite svoj<br>email');
+INSERT INTO core_text VALUES ('NEWS','SI','NOVICE');
+INSERT INTO core_text VALUES ('OLD_NEWS','SI','Tukaj so moje stare novice.');
+INSERT INTO core_text VALUES ('NEW_NEWS','SI','Tukaj so moje nove novice.');
+INSERT INTO core_text VALUES ('TODAY','SI','danes');
+INSERT INTO core_text VALUES ('TIME','SI','ura');
+INSERT INTO core_text VALUES ('LANGUAGE','SI','jezik');
+INSERT INTO core_text VALUES ('SEARCH','SI','i__i');
+INSERT INTO core_text VALUES ('MEMBERS','SI','_lani');
+INSERT INTO core_text VALUES ('USERNAME','SI','uporabnik');
+INSERT INTO core_text VALUES ('CONTROL_PANEL','SI','Nadzorna plošča');
+INSERT INTO core_text VALUES ('LOGIN','SI','Prijava');
+INSERT INTO core_text VALUES ('BECOME_MEMBER','SI','Postani _lan');
+INSERT INTO core_text VALUES ('LANG_CHOOSE','SI','Izberite jezik');
+INSERT INTO core_text VALUES ('TOPICS','SI','Predmeti');
+INSERT INTO core_text VALUES ('TOP_TEXT','SI','Here you will find all the topics that my news are related to.');
+INSERT INTO core_text VALUES ('ABOUT','SI','O PORTALU');
+INSERT INTO core_text VALUES ('CONTACT','SI','WEBADMIN');
+INSERT INTO core_text VALUES ('CUSTOMIZE','SI','OBLIKA');
+INSERT INTO core_text VALUES ('LANG_CHOOSER','SI','Izberite jezik');
+INSERT INTO core_text VALUES ('LANG_CHO_CHAP','SI','Tukaj boste našlivse jezike, ki so na razpolago za mojo stran. Da bi lahko gledali strani vizbranem jeziku, vam bom poslal piškotek. Če ne boste sprejeli piškotka, ne boste mogli gledati strani v izbranem jeziku.');
+INSERT INTO core_text VALUES ('LANG_LIST','SI','Tukaj je izpis jezikov, ki so vam na razpolago');
+INSERT INTO core_text VALUES ('LANG_ENABLE','SI','Omogoči jezik');
+INSERT INTO core_text VALUES ('THEME_CHOOSER','SI','Izberite temo');
+INSERT INTO core_text VALUES ('THEME_CHAPEAU','SI','This is the theme page. You can choose a theme to change the look of the site. A cookie will be set into your browser so that you can keep the theme you choose.');
+INSERT INTO core_text VALUES ('THEME_LIST','SI','Here is the list of the avalaible themes :');
+INSERT INTO core_text VALUES ('THEME_CLICK','SI','Click here to enlarge this theme');
+INSERT INTO core_text VALUES ('THEME_ENABLE','SI','Enable this theme');
+INSERT INTO core_text VALUES ('POWERED_BY','SI','MYDYNAWEB POWERED');
+INSERT INTO core_text VALUES ('NOT_FINISHED','SI','[ Ni dokončano ]');
+INSERT INTO core_text VALUES ('NOT_WRITTEN','SI','Ta stran še ni dokončana. Prosim, pridite kasneje, da bi jo lahko videli. Hvala.');
+INSERT INTO core_text VALUES ('SEARCH_ENG','SI','Rezultat poizvedbe');
+INSERT INTO core_text VALUES ('SEARCH_NEWS','SI','Rezultat iskanja v grupi Novic :');
+INSERT INTO core_text VALUES ('SEARCH_NO_NEWS','SI','Ni zadetkov med novicami');
+INSERT INTO core_text VALUES ('SEARCH_PAGES','SI','Rezultat iskanja v grupi Strani :');
+INSERT INTO core_text VALUES ('SEARCH_NO_PAGES','SI','Ni zadetkov med stranmi');
+INSERT INTO core_text VALUES ('POSTED_BY','SI','poslano od');
+INSERT INTO core_text VALUES ('ON','SI','on');
+INSERT INTO core_text VALUES ('COMMENT_NEWS','SI','Comment on this piece of news');
+INSERT INTO core_text VALUES ('COMMENT_RELATED','SI','Comments related to');
+INSERT INTO core_text VALUES ('THERE_ARE','SI','There are');
+INSERT INTO core_text VALUES ('COMMENTS_REC','SI','Comments recorded');
+INSERT INTO core_text VALUES ('COMMENTS','SI','comments');
+INSERT INTO core_text VALUES ('READ_MORE','SI','Read More');
+INSERT INTO core_text VALUES ('YOU_MUST_BE_MEMBER','SI','Sorry,<P> you must be a member to do that !');
+INSERT INTO core_text VALUES ('NEWS_BY_TOPICS_LIST_TITLE','SI','News by Topics');
+INSERT INTO core_text VALUES ('NEWS_BY_TOPICS_LIST_HEADER','SI','News in the selected topic');
+INSERT INTO core_text VALUES ('OLD_NEWS_LIST_TITLE','SI','Old News are good news ?');
+INSERT INTO core_text VALUES ('OLD_NEWS_LIST_HEADER','SI','Here are the old news');
+INSERT INTO core_text VALUES ('CACHE_GENERATED','SI','Generated by the MyDynaWeb Cache Manager');
+INSERT INTO core_text VALUES ('Announces','SI','Objava');
+INSERT INTO core_text VALUES ('Bug','SI','Hrošč');
+INSERT INTO core_text VALUES ('Docs','SI','Dokumentacija');
+INSERT INTO core_text VALUES ('Humor','SI','Humor');
+INSERT INTO core_text VALUES ('Linux Business','SI','Linux biznis');
+INSERT INTO core_text VALUES ('Code Stuff','SI','Code Stuff');
+INSERT INTO core_text VALUES ('HighTc','SI','High Tc');
+INSERT INTO core_text VALUES ('Main','SI','Main');
+INSERT INTO core_text VALUES ('Geeks Only !','SI','Geeks Only !');
+INSERT INTO core_text VALUES ('Update !','SI','Update !');
+INSERT INTO core_text VALUES ('FORBIDEN ACCESS','SI','Prepovedan dostop !');
+INSERT INTO core_text VALUES ('NON_AUTHORISED_FILE_ACCESS','SI','Nimate pravic za dostop do te datoteke !');
+INSERT INTO core_text VALUES ('URL UNREACHABLE','SI','URL unreachable');
+INSERT INTO core_text VALUES ('IMPOSSIBLE TO OPEN','SI','Impossible to open');
+INSERT INTO core_text VALUES ('Fresh News','SI','Sveže novice');
|
|
From: mdw c. <myd...@li...> - 2001-11-23 10:47:14
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Added Files: create-referer.sql create-remote-addr.sql create-stats.sql Log Message: The tables for the new stats counter. ... in stage of development... |
|
From: mdw c. <myd...@li...> - 2001-11-23 11:02:33
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: create-referer.sql Log Message: Fixing the SQL bug in creation of the table REF_DAY. (Thanx Ben ;) =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-referer.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -3 -r1.1 -r1.2 --- create-referer.sql 2001/11/23 10:47:13 1.1 +++ create-referer.sql 2001/11/23 11:02:33 1.2 @@ -1,3 +1,5 @@ +DROP TABLE REFERERS; + CREATE TABLE REFERERS ( REF_ID int not null auto_increment, REF_URL varchar(255) not null default '', @@ -6,8 +8,8 @@ CREATE TABLE REF_DAY ( REF_ID int not null default 0, - DAY date, - NB int not null default 0, + DAY date not null default '', + NB int not null default '0000-00-00', PRIMARY KEY(REF_ID, DAY) ); |
|
From: mdw c. <myd...@li...> - 2001-11-23 11:03:43
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: create-remote-addr.sql Log Message: Fixing the same bug as the table REF_DAY =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-remote-addr.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -3 -r1.1 -r1.2 --- create-remote-addr.sql 2001/11/23 10:47:13 1.1 +++ create-remote-addr.sql 2001/11/23 11:03:43 1.2 @@ -6,7 +6,7 @@ CREATE TABLE IP_DAY ( IP_ID int not null default 0, - DAY date, + DAY date not null default '0000-00-00', NB int not null default 0, PRIMARY KEY(IP_ID, DAY) ); |
|
From: mdw c. <myd...@li...> - 2001-11-23 11:05:08
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: create-referer.sql Log Message: oups !! =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-referer.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -3 -r1.2 -r1.3 --- create-referer.sql 2001/11/23 11:02:33 1.2 +++ create-referer.sql 2001/11/23 11:05:08 1.3 @@ -8,8 +8,8 @@ CREATE TABLE REF_DAY ( REF_ID int not null default 0, - DAY date not null default '', - NB int not null default '0000-00-00', + DAY date not null default '0000-00-00', + NB int not null default 0, PRIMARY KEY(REF_ID, DAY) ); |
|
From: mdw c. <myd...@li...> - 2001-11-26 22:57:48
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: create-referer.sql create-stats.sql Removed Files: create-remote-addr.sql Log Message: The db changes for the count system =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-referer.sql,v retrieving revision 1.3 retrieving revision 1.4 diff -u -3 -r1.3 -r1.4 --- create-referer.sql 2001/11/23 11:05:08 1.3 +++ create-referer.sql 2001/11/26 22:57:47 1.4 @@ -1,4 +1,3 @@ -DROP TABLE REFERERS; CREATE TABLE REFERERS ( REF_ID int not null auto_increment, =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-stats.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -3 -r1.1 -r1.2 --- create-stats.sql 2001/11/23 10:47:13 1.1 +++ create-stats.sql 2001/11/26 22:57:47 1.2 @@ -1,4 +1,3 @@ -DROP TABLE STATS; CREATE TABLE STATS ( |
|
From: mdw c. <myd...@li...> - 2001-11-27 13:11:15
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6
Modified Files:
create_fill_dynasettings.sql
Log Message:
** The Road to 0.3.6 **
***********************
First updates of the SQL files.
The goal is to merge each of the sql content of db_upgrades/from_0.3.5_to_0.3.6 in
MYSQL_create.sql and SQL_fill.sql
To do :
- add the create_users.sql file
- update Postgres file
- make the perl updater that can do the upgrade automatically
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create_fill_dynasettings.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -3 -r1.3 -r1.4
--- create_fill_dynasettings.sql 2001/11/20 11:12:42 1.3
+++ create_fill_dynasettings.sql 2001/11/27 13:11:14 1.4
@@ -18,12 +18,10 @@
# Dumping data for table 'dyna_settings'
#
-INSERT INTO dyna_settings VALUES
-('SITE_ROOT','http://be.carefull.when.changing.this/');
-INSERT INTO dyna_settings VALUES ('WEBMASTER_EMAIL','your@email');
+INSERT INTO dyna_settings VALUES ('SITE_ROOT','http://localhost/');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_EMAIL','you@localhost');
INSERT INTO dyna_settings VALUES ('HEADLINES','local,mydynaweb,slashdot');
-INSERT INTO dyna_settings VALUES
-('WEBMASTER_HOMEPAGE','http://www.your.server./%7Eyour.home.page/');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_HOMEPAGE','http://www.your.site/');
INSERT INTO dyna_settings VALUES ('WEBMASTER_NAME','Your Name');
INSERT INTO dyna_settings VALUES ('WEBMASTER_LOGIN','Gandalf');
INSERT INTO dyna_settings VALUES ('DYNACACHE','no');
@@ -33,13 +31,14 @@
INSERT INTO dyna_settings VALUES ('TOP_BAR_MYDYNAWEB','1');
INSERT INTO dyna_settings VALUES ('CP_TIME','1');
INSERT INTO dyna_settings VALUES ('CP_LANG','1');
-INSERT INTO dyna_settings VALUES ('CP_SEEK','0.0');
+INSERT INTO dyna_settings VALUES ('CP_SEEK','1');
INSERT INTO dyna_settings VALUES ('CP_DATE','1');
INSERT INTO dyna_settings VALUES ('CP_LOGIN','1');
INSERT INTO dyna_settings VALUES ('DEFAULT_FAMILY','1');
-INSERT INTO dyna_settings VALUES ('DEFAULT_LANG','FR');
+INSERT INTO dyna_settings VALUES ('DEFAULT_LANG','EN');
INSERT INTO dyna_settings VALUES ('SITE_TITLE','yoursite.net');
INSERT INTO dyna_settings VALUES ('THEMES_BEHAVIOR','CHOOSE');
INSERT INTO dyna_settings VALUES ('THEME_LIST','smarty,default,basic,enlightened,gnome,dynadot');
INSERT INTO dyna_settings VALUES ('THEME_PATH','/smarty');
INSERT INTO dyna_settings VALUES ('THEME_ROOT','/templates');
+
|
|
From: mdw c. <myd...@li...> - 2001-11-27 13:11:45
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql
Modified Files:
MYSQL_create.sql SQL_fill.sql
Log Message:
** The Road to 0.3.6 **
***********************
First updates of the SQL files.
The goal is to merge each of the sql content of db_upgrades/from_0.3.5_to_0.3.6 in
MYSQL_create.sql and SQL_fill.sql
To do :
- add the create_users.sql file
- update Postgres file
- make the perl updater that can do the upgrade automatically
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -3 -r1.11 -r1.12
--- MYSQL_create.sql 2001/07/13 09:53:03 1.11
+++ MYSQL_create.sql 2001/11/27 13:11:14 1.12
@@ -107,6 +107,7 @@
content text DEFAULT '' NOT NULL,
_num_news int(11) DEFAULT '0' NOT NULL,
user_name varchar(15) DEFAULT 'sukria',
+ user_mail varchar(100) not null default '',
PRIMARY KEY (num_cmt)
);
@@ -179,11 +180,46 @@
primary key(num_topic)
);
-CREATE TABLE counter (
- num_counter tinyint not null auto_increment,
- nbvisites int not null default 0,
- nom varchar(20),
- PRIMARY KEY(num_counter)
+
+CREATE TABLE REFERERS (
+ REF_ID int not null auto_increment,
+ REF_URL varchar(255) not null default '',
+ PRIMARY KEY(REF_ID)
+);
+
+CREATE TABLE REF_DAY (
+ REF_ID int not null default 0,
+ DAY date not null default '0000-00-00',
+ NB int not null default 0,
+ PRIMARY KEY(REF_ID, DAY)
+);
+
+
+CREATE TABLE STATS
+(
+ DAY date not null ,
+ PAGEVIEWS int unsigned not null default 0,
+ VISITS int unsigned not null default 0,
+ PEOPLE int unsigned not null default 0,
+ REFERER VARCHAR(255) not null default '',
+ PRIMARY KEY (DAY)
+);
+
+CREATE TABLE calendar_messages (
+ id int(11) NOT NULL auto_increment,
+ date date NOT NULL default '0000-00-00',
+ title tinytext NOT NULL,
+ text text NOT NULL,
+ msg_poster_id int(11) NOT NULL default '0',
+ ocurence tinytext,
+ active int(1) NOT NULL default '0',
+ PRIMARY KEY (id)
+);
+
+CREATE TABLE dyna_settings (
+ varname varchar(125) NOT NULL default '',
+ varvalue varchar(255) default '',
+ PRIMARY KEY (varname)
);
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/SQL_fill.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -3 -r1.11 -r1.12
--- SQL_fill.sql 2001/08/02 22:22:55 1.11
+++ SQL_fill.sql 2001/11/27 13:11:14 1.12
@@ -1,3 +1,27 @@
+INSERT INTO dyna_settings VALUES ('SITE_ROOT','http://localhost/');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_EMAIL','you@localhost');
+INSERT INTO dyna_settings VALUES ('HEADLINES','local,mydynaweb,slashdot');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_HOMEPAGE','http://www.your.site/');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_NAME','Your Name');
+INSERT INTO dyna_settings VALUES ('WEBMASTER_LOGIN','Gandalf');
+INSERT INTO dyna_settings VALUES ('DYNACACHE','no');
+INSERT INTO dyna_settings VALUES ('CACHE_DELAY','1000');
+INSERT INTO dyna_settings VALUES ('TOP_BAR_IN_OTHER_LANG','1');
+INSERT INTO dyna_settings VALUES ('TOP_BAR_DEFAULT','1');
+INSERT INTO dyna_settings VALUES ('TOP_BAR_MYDYNAWEB','1');
+INSERT INTO dyna_settings VALUES ('CP_TIME','1');
+INSERT INTO dyna_settings VALUES ('CP_LANG','1');
+INSERT INTO dyna_settings VALUES ('CP_SEEK','1');
+INSERT INTO dyna_settings VALUES ('CP_DATE','1');
+INSERT INTO dyna_settings VALUES ('CP_LOGIN','1');
+INSERT INTO dyna_settings VALUES ('DEFAULT_FAMILY','1');
+INSERT INTO dyna_settings VALUES ('DEFAULT_LANG','EN');
+INSERT INTO dyna_settings VALUES ('SITE_TITLE','yoursite.net');
+INSERT INTO dyna_settings VALUES ('THEMES_BEHAVIOR','CHOOSE');
+INSERT INTO dyna_settings VALUES ('THEME_LIST','smarty,default,basic,enlightened,gnome,dynadot');
+INSERT INTO dyna_settings VALUES ('THEME_PATH','/smarty');
+INSERT INTO dyna_settings VALUES ('THEME_ROOT','/templates');
+
insert into languages (id_lang, name, flag) values ('EN', 'English', 'images/flags/en.gif');
insert into languages (id_lang, name, flag) values ('FR', 'Français', 'images/flags/fr.gif');
insert into languages (id_lang, name, flag) values ('DE', 'Deutsch', 'images/flags/de.gif');
|
|
From: mdw c. <myd...@li...> - 2001-11-27 22:01:44
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Added Files: create-users.sql Log Message: ** the road to 0.3.6 ** *********************** The last SQL file for the stats system |
|
From: mdw c. <myd...@li...> - 2001-11-27 22:42:58
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : sql
Dir : mydynaweb/sql
Modified Files:
MYSQL_create.sql SQL_fill.sql
Log Message:
** the road to 0.3.6 **
***********************
Some SQL updates...
we are near the 0.3.6 release...
TO DO to publish the release :
- the stats viewer
- testing an install from scratch
- testing an upgrade from 0.3.5
- translate the remaining untranslated stuff
- destroy the nugs you find ;)
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/MYSQL_create.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -3 -r1.12 -r1.13
--- MYSQL_create.sql 2001/11/27 13:11:14 1.12
+++ MYSQL_create.sql 2001/11/27 22:42:58 1.13
@@ -180,6 +180,18 @@
primary key(num_topic)
);
+CREATE TABLE USERS (
+ USER_ID int not null auto_increment,
+ USER_COOKIE varchar(255) not null default '',
+ PRIMARY KEY(USER_ID)
+);
+
+CREATE TABLE USERS_DAY (
+ USER_ID int not null default 0,
+ DAY date not null default '0000-00-00',
+ NB int not null default 0,
+ PRIMARY KEY(USER_ID, DAY)
+);
CREATE TABLE REFERERS (
REF_ID int not null auto_increment,
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/sql/SQL_fill.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -3 -r1.12 -r1.13
--- SQL_fill.sql 2001/11/27 13:11:14 1.12
+++ SQL_fill.sql 2001/11/27 22:42:58 1.13
@@ -49,16 +49,28 @@
insert into topic (titre, icone, lang_id) values ('Code Stuff', 'images/topics/programming.gif','EN');
insert into news (titre, date, texte, _num_topic, lang, user_name)
- values ('Congratulations !', '2001-08-02', 'You have successfully installed MyDynaWeb.<br>
+ values ('Félicitations !', '2001-11-27', 'Vous avez installé MyDynaWeb avec succès ! <br> Toute l''équipe de MyDynaWeb vous remercie de lui faire confiance et épsère vous voire très bientôt sur <a href="http://mydynaweb.sf.net">mydynaweb.sourceforge.net</a> :)', 1, 'FR', 'DynaCrew');
+
+insert into news (titre, date, texte, _num_topic, lang, user_name)
+ values ('Congratulations !', '2001-11-27', 'You have successfully installed MyDynaWeb.<br>
If you can see this piece of news, it means that your installation process has been successfull. <br>
- Don''t forget to check the <a href="http://mydynaweb.sf.net">mydynaweb site</a> for fresh news :)', 1, 'EN', 'MyDynaWeb');
+ Don''t forget to check the <a href="http://mydynaweb.sf.net">mydynaweb site</a> for fresh news :)', 1, 'EN', 'DynaCrew');
insert into item_box_titles values (1, 'News', 'images/news.jpg', 'EN');
-insert into item_box_content values (1, 'Fresh News', 'news.php3', '_self', 1);
-insert into item_box_content values (2, 'Old News', 'news.php3?old=yes', '_self', 1);
-insert into item_box_content values (3, 'Topics', 'show_da_topics.php3', '_self', 1);
+insert into item_box_content values (1, 'Fresh News', 'news.php', '_self', 1);
+insert into item_box_content values (2, 'Old News', 'news.php?old=yes', '_self', 1);
+insert into item_box_content values (3, 'Topics', 'topics.php', '_self', 1);
insert into item_box_titles values (2, 'Overview', 'images/overview.jpg', 'EN');
insert into item_box_content values (4, 'Stats', 'show_stats.php', '_self', 2);
-insert into item_box_content values (5, 'Search', 'seek.php3', '_self', 2);
+insert into item_box_content values (5, 'Search', 'seek.php', '_self', 2);
+
+insert into item_box_titles values (3, 'Accueil', 'images/news.jpg', 'FR');
+insert into item_box_content values (6, 'Nouvelles', 'news.php', '_self', 3);
+insert into item_box_content values (7, 'Vieilleries', 'news.php?old=yes', '_self', 3);
+insert into item_box_content values (8, 'Rubriques', 'topics.php', '_self', 3);
+
+insert into item_box_titles values (4, 'Survol', 'images/overview.jpg', 'FR');
+insert into item_box_content values (9, 'Stats', 'show_stats.php', '_self', 4);
+insert into item_box_content values (10, 'Recherche', 'seek.php', '_self', 4);
|
|
From: mdw c. <myd...@li...> - 2001-12-06 16:21:15
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: alter-news.sql Log Message: fixing alternews to be postgres compliant =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/alter-news.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -3 -r1.1 -r1.2 --- alter-news.sql 2001/10/29 14:30:44 1.1 +++ alter-news.sql 2001/12/06 16:21:12 1.2 @@ -1,2 +1,2 @@ -alter table news modify titre VARCHAR(50) not null default ''; - +ALTER TABLE news +ALTER COLUMN titre SET VARCHAR(50) DEFAULT ''; |
|
From: mdw c. <myd...@li...> - 2001-12-06 16:29:48
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: create-referer.sql Log Message: referer set to REFERRER =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-referer.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -u -3 -r1.4 -r1.5 --- create-referer.sql 2001/11/26 22:57:47 1.4 +++ create-referer.sql 2001/12/06 16:29:47 1.5 @@ -1,5 +1,5 @@ -CREATE TABLE REFERERS ( +CREATE TABLE REFERRERS ( REF_ID int not null auto_increment, REF_URL varchar(255) not null default '', PRIMARY KEY(REF_ID) @@ -7,7 +7,7 @@ CREATE TABLE REF_DAY ( REF_ID int not null default 0, - DAY date not null default '0000-00-00', + DAY date, NB int not null default 0, PRIMARY KEY(REF_ID, DAY) ); |
|
From: mdw c. <myd...@li...> - 2001-12-06 16:32:46
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Added Files: create-referer.pgsql Log Message: create referrer for PostgresDB |
|
From: mdw c. <myd...@li...> - 2001-12-06 16:35:16
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: create-stats.sql Log Message: removing the unsigned flag of int fields =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/create-stats.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -u -3 -r1.2 -r1.3 --- create-stats.sql 2001/11/26 22:57:47 1.2 +++ create-stats.sql 2001/12/06 16:35:15 1.3 @@ -1,10 +1,9 @@ - CREATE TABLE STATS ( - DAY date not null , - PAGEVIEWS int unsigned not null default 0, - VISITS int unsigned not null default 0, - PEOPLE int unsigned not null default 0, - REFERER VARCHAR(255) not null default '', - PRIMARY KEY (DAY) +DAY date not null , +PAGEVIEWS int not null default 0, +VISITS int not null default 0, +PEOPLE int not null default 0, +REFERER VARCHAR(255) not null default '', +PRIMARY KEY (DAY) ); |
|
From: mdw c. <myd...@li...> - 2001-12-06 16:38:40
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Added Files: create-users.pgsql Log Message: Sequences added for auto_increment field (postgres compliant) |
|
From: mdw c. <myd...@li...> - 2001-12-06 16:45:47
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Added Files: create_calendar_messages.pgsql Log Message: postgres file |
Thanks for helping keep SourceForge clean.
X