bookmarksync-cvs Mailing List for BookmarkSync

Status: Beta

Brought to you by: captbunzo, hbroek, jdean67, mberneis, and 3 others

bookmarksync-cvs — BookmarkSync CVS Commits Publication List

You can subscribe to this list here.

Flat | Threaded

1 2 3 4 > >> (Page 1 of 4)

[BMSYNC-CVS] good vixe

From: Shikoba R. <anw...@ba...> - 2007-02-25 20:56:42

Hi,

Chaepest CALIS and VAGRA online.

http://parkerokay+now.com

Remove "+" from the link.


Nearly six,  said Ron, checking his watch and then staring down the
drive that led to the front gates. How dyou reckon theyre coming? The
train?

Re: [BMSYNC-CVS] my EDquadrisyllabl

From: Pietro B. <ang...@sa...> - 2007-01-25 13:46:38

Good day,

VlAG_GRA  $1, 80
ClAL_LIS  $3, 00
LEVl_ITRA $3, 35

http://www.rabietichb*com
( Important! Replace * with . )

--
I have gone temporarily deaf and havent any idea what you said.
Harry,  said Dumbledore, twiddling his thumbs and staring at the ceiling.
Er-right,  said Harry sheepishly. I just meant-Hagrid, how could you

Re: [BMSYNC-CVS] your plic

From: Delroy W. <el...@sa...> - 2006-12-25 19:08:17

Hi
=20
AM_MBlEN $ 2. 90
VA_ALlUM $ 1. 25
Vl_lAGRA $ 3. 30
Cl_lALlS $ 3. 75
XA_ANAX $ 1. 50
=20
http://www.deruikintungandesunlion.com
=20
=20
=20
grace at the Ministry.
Moody says Crouch is obsessed with catching Dark wizards, Harry told
Sirius.

Re: [BMSYNC-CVS] pickax bobbi

From: Mehmud U. <egg...@di...> - 2006-12-02 02:21:48

Hi,

CHEEAP FHARMACY

http://www.xaserinkiongundhefundas.com
=20
I poked out a casual finger- towards. the glowing lights and found

Re: [BMSYNC-CVS] news

From: Emin M. <der...@in...> - 2006-11-18 18:19:45

VlAiiGRA $3.35 http://www.easedrunkiondehunfans.com

Where the discussion would have gone from here would never be known

Re: [BMSYNC-CVS] news 435

From: Ayelet J. <jed...@as...> - 2006-11-14 11:23:59

Hi,
=20
VImAGRA VAmLIUM CImALIS http://www.vasedinkionmasedaxas.com
=20
,

hear that the artifact has been found. Now, if you please, an

[BMSYNC-CVS] ..help keeping SyncIt alive!!

From: Frank J. A. <fra...@kr...> - 2006-02-19 20:57:08

Hi,

for your information SyncIt is currently continued by Jack Dean at 
Sync2It.com.

Jack has made some improvements - amongst other things - making a Mac 
version, and including Firefox support.

But help is needed to keep up with browser development, and fighting 
bugs... So why not join the effort ?? Contact Jack (ad...@sy...) - 
and get involved!!

...I'm sorry I can't code myself - but I help out moderating the forums...


best wishes

Frank J. Andersen

[BMSYNC-CVS] CVS: client-windows CHANGES.txt,1.2,1.3

From: Jack D. <jd...@us...> - 2005-12-23 17:17:16

Update of /cvsroot/bookmarksync/client-windows
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23934

Modified Files:
	CHANGES.txt 
Log Message:
no message

Index: CHANGES.txt
===================================================================
RCS file: /cvsroot/bookmarksync/client-windows/CHANGES.txt,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -w -r1.2 -r1.3
--- CHANGES.txt	24 Oct 2003 14:12:34 -0000	1.2
+++ CHANGES.txt	23 Dec 2005 17:17:01 -0000	1.3
@@ -1,8 +1,38 @@
 ###############################################################################
 # BookmarkSync (client-windows)                (c) 1998-200x SyncIT.com, Inc. #
 # CHANGELOG                 http://www.sourceforge.net/projects/bookmarksync/ #
+#									      #
+# Sync2It.com                                                                 #
+# Jack Dean - 12/23/2005                                                      #
 ###############################################################################
 
+
+1.8.1 (Released December, 2005)
+   - added Updated support for Firefox 1.5
+   - added automatic browser detection to browsers dialog
+   - modified Firefox initialization for better detection
+   - added trap for loss of network connectivity
+
+
+1.8.0 (Released November, 2005)
+   - added Updated support for Opera 8.5
+   - added support for Firefox 1.0.7
+   - added Firefox-specific bookmarks.html I/O class
+   - enabled automatic client software upgrading and installation
+   - added License & Subscription information display to settings window
+   - added server bookmark count to settings window
+   - added support links for the Toolbar and Subscription options
+   - added support link for Bookmark Clustering
+   - added support links for locating deleted, dead and duplicate links from the server
+   - added new and modified existing client communications commands *A (alerts), *U (allowing software updates) 
+
+
+1.7.0 (Released December, 2004
+  - added several new state icons to better indicate state machine status.
+  - implemented server-side timeouts for autosync and retry intervals (less server loading)
+  - 
+
+
 1.6.4 (released October 24th, 2003)
   - added support for Netscape 6 and later, Mozilla and Mozilla Firebird
   - detecting changed bookmarks file location using "browser.bookmarks.file" in user.js and prefs.js

[BMSYNC-CVS] CVS: server-php-minimal view_deleted.php,NONE,1.1

From: Steffen S. <si...@us...> - 2004-02-04 20:29:22

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6521

Added Files:
	view_deleted.php 
Log Message:
NEW: A new button for the bookmark treeview toggles between the
current and the deleted booksmarks for the user. The deleted bookmarks
view includes a undelete link for each bookmark.


--- NEW FILE ---
<?php
// ----------------------------------------------------------------------------
// view_deleted.php
// Copyright (C) 2003  SyncIT.com, Inc.
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software Foundation,
// Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
// ----------------------------------------------------------------------------
// This library is GPL'd.  If you distribute this program or a derivative of
// this program publicly you must include the source code.  It is easy
// enough to drop us an email requesting a different license, if necessary.
//
// Description: Tree folder deleted bookmark view.
// Created:     July 1998, SyncIT.com, Inc.
// Modified:    $Date: 2004/02/04 20:26:57 $, $Author: siebert $
// ----------------------------------------------------------------------------
session_start();

$pid = (isset($_SESSION["pid"]))?$_SESSION["pid"]:"";
if ($pid == "") {
        header("Location: index.php");
}
?>
<html>
<head>
<title>Your deleted Bookmarks</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
a {
	font: normal 0.9em Verdana;
	color: black;
}

ul.aqtree3clickable {
	margin-left: 0;
	padding-left: 0;
	font: normal 0.9em Verdana;
}

/* Turn off list bullets */
ul.aqtree3clickable li { list-style: none; }

ul { padding-left: 0; margin-left: 25px; }
/* Provide space for our own "bullet" inside the link */
ul.aqtree3clickable li { padding-left: 20px; }

/* Show "bullets" in the links, depending on the class of the
   LI that the link's in */
ul.aqtree3clickable li.aq3open {
    background: url(images/o.gif) top left no-repeat;
	text-decoration: none;
	color: black;
}
ul.aqtree3clickable li.aq3closed {
    background: url(images/f.gif) top left no-repeat;
	text-decoration: none;
	color: black;
}
ul.aqtree3clickable li.aq3bullet {
    background: url(images/a.gif) top left no-repeat;
	text-decoration: underline;
	color: #009;
}

/* Actually show and hide sublists */
ul.aqtree3clickable li.aq3open ul { display: block; }
ul.aqtree3clickable li.aq3closed ul { display: none; }
</style>

<script type="text/javascript">
<!--
/*
aqtree3clickable

Converts an unordered list to an explorer-style tree, with clickable
icons

http://www.kryogenix.org/code/browser/aqlists/

Stuart Langridge, November 2002
si...@kr...
*/

addEvent(window, "load", makeTreesC);

function makeTreesC() {
    // We don't actually need createElement, but we do
    // need good DOM support, so this is a good check.
    if (!document.createElement) return;

    uls = document.getElementsByTagName("ul");
    for (uli=0;uli<uls.length;uli++) {
        ul = uls[uli];
        if (ul.nodeName == "UL" && ul.className == "aqtree3clickable") {
            processULELC(ul);
        }
    }
}

function processULELC(ul) {
    if (!ul.childNodes || ul.childNodes.length == 0) return;
    // Iterate LIs
    for (var itemi=0;itemi<ul.childNodes.length;itemi++) {
        var item = ul.childNodes[itemi];
        if (item.nodeName == "LI") {
            // Iterate things in this LI
            var a;
            var subul;
        subul = "";
            for (var sitemi=0;sitemi<item.childNodes.length;sitemi++) {
                var sitem = item.childNodes[sitemi];
                switch (sitem.nodeName) {
                    case "A": a = sitem; break;
                    case "UL": subul = sitem;
                               processULELC(subul);
                               break;
                }
            }
            if (subul) {
                associateELC(a,subul);
            } else {
                a.parentNode.className = "aq3bullet";
            }
        }
    }
}

function associateELC(a,ul) {
    a.parentNode.className = 'aq3closed';
    a.onclick = function () {
        this.parentNode.className = (this.parentNode.className=='aq3open') ? "aq3closed" : "aq3open";
        return false;
    }
}

/*              Utility functions                    */

function addEvent(obj, evType, fn){
  /* adds an eventListener for browsers which support it
     Written by Scott Andrew: nice one, Scott */
  if (obj.addEventListener){
    obj.addEventListener(evType, fn, true);
    return true;
  } else if (obj.attachEvent){
    var r = obj.attachEvent("on"+evType, fn);
    return r;
  } else {
    return false;
  }
}
//-->
</script>

</head>

<body>

<h1>Your deleted Bookmarks</h1>

<form method='post' action='view.php'>
<input type='submit' value='Show Bookmarks'>
</form>

<ul class="aqtree3clickable">
<?php
include 'db.php';

if (!db_connect()) {
	die("Cannot connect database in view.php");
}

$debug = false;

$res  = mysql_query("select value from syncit_config where param='debug'");
$data = mysql_fetch_assoc($res);
if (!$data) {
    my_mysql_query("insert into syncit_config (param, value) values ('debug', 'false')");
} else {
    if ($data["value"] == 'true') {
      $debug = true;
    }
}

if ($debug) {
        $debug_fh = @fopen("debug.log", "a");
}

{
	$myurl = array();
	$url_idx = 0;
	$last_line = array();
	$last_items = 1;
	$items = 0;
	$level = 1;

	$ID = $pid;

	$target = $_SESSION['target'];

	if ($target == "") {
		$target = "_blank";
        }

	$sql = "select syncit_link.path,syncit_bookmarks.url,syncit_link.book_id from syncit_bookmarks right join syncit_link on syncit_bookmarks.bookid = syncit_link.book_id where syncit_link.person_id=" . $ID . " and syncit_link.expiration is not null order by syncit_link.path";

	$res = mysql_query($sql);

	if (!$res) {
		die("$sql<hr>Cannot retrieve data in view.php");
        }

	while ($data = mysql_fetch_assoc($res)) {

		if (!isset($data['url'])) {
			$is_folder = true;
                } else {
        		$is_folder = false;
                }

		$line = explode("\\",substr($data['path'],1));
		$items = count($line);

                debug("l: ". $data['path']);
                debug("items: ".$items." last_items: ".$last_items." is_folder: ".$is_folder);

                $level = $last_items - 1;

                debug("level = ".$level." last_line[level-1] = >".$last_line[$level-1]."< line[level-1] = >".$line[$level-1]."<");

                while ($level > 0 && $last_line[$level-1] != $line[$level-1]) {
                        echo "</ul>\r\n";
                        $level = $level - 1;
                }

                while ($level < $items-1) {
			echo "<li><a href=\"#\">" . $line[$level] . "</a>\r\n";
			echo "<ul>\r\n";
                        $level = $level + 1;
                }

		if ($is_folder == false){
			if ($items > 1){
				echo "<li><a target='" . $target . "' href=\"" . $data['url'] . "\">" . $line[$items-1] . "</a> (<a href=\"undelete.php?id=" . $data['book_id'] . "\">Undelete</a>)</li>\r\n";
			}
			else {
				$myurl[$url_idx++] = "<li><a target='" . $target . "' href=\"" . $data['url'] . "\">" . $line[0] . "</a> (<a href=\"undelete.php?id=" . $data['book_id'] . "\">Undelete</a>)</li>\r\n";
			}
		}

        	$last_line = $line;
		$last_items = $items;
	}

        $level = $last_items - 1;
        while ($level > 0) {
                echo "</ul>\r\n";
                $level = $level - 1;
        }

	if ($url_idx > 0){
		for ($idx = 0; $idx < $url_idx; $idx++)
			echo $myurl[$idx];
	}
}

function debug($str) {
    global $debug, $debug_fh;
    if (!$debug) { return; }
    $date = date("D M j G:i:s T Y");
    fputs($debug_fh,  "[$date] $str\r\n");
}

?>
</ul>
</body>
</html>

[BMSYNC-CVS] CVS: server-php-minimal view.php,1.6,1.7

From: Steffen S. <si...@us...> - 2004-02-04 20:29:06

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6444

Modified Files:
	view.php 
Log Message:
NEW: A new button for the bookmark treeview toggles between the
current and the deleted booksmarks for the user. The deleted bookmarks
view includes a undelete link for each bookmark.


Index: view.php
===================================================================
RCS file: /cvsroot/bookmarksync/server-php-minimal/view.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -w -r1.6 -r1.7
--- view.php	17 Nov 2003 09:15:58 -0000	1.6
+++ view.php	4 Feb 2004 20:26:37 -0000	1.7
@@ -167,6 +167,12 @@
 
 <body>
 
+<h1>Your Bookmarks</h1>
+
+<form method='post' action='view_deleted.php'>
+<input type='submit' value='Show deleted Bookmarks'>
+</form>
+
 <ul class="aqtree3clickable">
 <?php
 include 'db.php';

[BMSYNC-CVS] CVS: server-php-minimal undelete.php,NONE,1.1

From: Steffen S. <si...@us...> - 2004-02-04 20:28:49

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6375

Added Files:
	undelete.php 
Log Message:
NEW: A new button for the bookmark treeview toggles between the
current and the deleted booksmarks for the user. The deleted bookmarks
view includes a undelete link for each bookmark.


--- NEW FILE ---
<?php
// ----------------------------------------------------------------------------
// undelete.php
// Copyright (C) 2004 Steffen Siebert
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software Foundation,
// Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
// ----------------------------------------------------------------------------
// This library is GPL'd.  If you distribute this program or a derivative of
// this program publicly you must include the source code.  It is easy
// enough to drop us an email requesting a different license, if necessary.
//
// Description: Undelete a bookmark.
// Modified:    $Date: 2004/02/04 20:26:21 $, $Author: siebert $
// ----------------------------------------------------------------------------
session_start();

$pid = (isset($_SESSION["pid"]))?$_SESSION["pid"]:"";
if ($pid == "") {
        header("Location: index.php");
}

$bookmark_id = trim($_GET["id"]);
include 'db.php';

if (!db_connect()) {
	die("Cannot connect database in undelete.php");
}

$debug = false;

$res  = mysql_query("select value from syncit_config where param='debug'");
$data = mysql_fetch_assoc($res);
if (!$data) {
    my_mysql_query("insert into syncit_config (param, value) values ('debug', 'false')");
} else {
    if ($data["value"] == 'true') {
      $debug = true;
    }
}

if ($debug) {
        $debug_fh = @fopen("debug.log", "a");
}

$sql = "update syncit_link set syncit_link.expiration = null where syncit_link.person_id=" . $pid . " and syncit_link.book_id=" . $bookmark_id . " and syncit_link.expiration is not null";

my_mysql_query($sql);

my_mysql_query("update syncit_person set token = token+1, lastchanged = now() where personid='$pid'");

header("Location: view_deleted.php");

function debug($str) {
    global $debug, $debug_fh;
    if (!$debug) { return; }
    $date = date("D M j G:i:s T Y");
    fputs($debug_fh,  "[$date] $str\r\n");
}

// merely a wrapper around all our SQL queries so that
// we can handle whether a line to our debug should happen.
function my_mysql_query($str) {
    debug($str); // fun!
    $res = mysql_query($str);
    if (!$res) {
        debug("SQL Error: " . mysql_error());
    } else {
        debug("Result: " . $res);
    }
    return $res;
}
?>
</ul>
</body>
</html>

[BMSYNC-CVS] CVS: client-windows/BookmarkLib BookmarkEditor.cxx,1.3.2.1,1.3.2.2

From: Daniel G. <dge...@us...> - 2004-01-13 11:35:48

Update of /cvsroot/bookmarksync/client-windows/BookmarkLib
In directory sc8-pr-cvs1:/tmp/cvs-serv16942/BookmarkLib

Modified Files:
      Tag: CLIENT_1_7_DEV
	BookmarkEditor.cxx 
Log Message:
* fixed crash when synchronizg

Index: BookmarkEditor.cxx
===================================================================
RCS file: /cvsroot/bookmarksync/client-windows/BookmarkLib/BookmarkEditor.cxx,v
retrieving revision 1.3.2.1
retrieving revision 1.3.2.2
diff -u -w -r1.3.2.1 -r1.3.2.2
--- BookmarkEditor.cxx	27 Oct 2003 12:28:12 -0000	1.3.2.1
+++ BookmarkEditor.cxx	13 Jan 2004 11:35:44 -0000	1.3.2.2
@@ -124,8 +124,11 @@
 
    assert(pbf != NULL);
 
+   if (pbf)
+   {
    pbf->add(NEW BookmarkFolder(*pfNew));
 }
+}
 
 /* virtual */
 void BookmarkMerger::addBookmark(const Bookmark *pNew) {
@@ -133,8 +136,11 @@
 
    assert(pbf != NULL);
 
+   if (pbf)
+   {
    pbf->add((BookmarkObject *) pNew->attach());
 }
+}
 
 /* virtual */
 void BookmarkMerger::delBookmark(const Bookmark *pOld) {

[BMSYNC-CVS] CVS: client-windows/SyncLib SyncLib.vcproj,1.2,1.2.2.1

From: Daniel G. <dge...@us...> - 2004-01-13 08:44:54

Update of /cvsroot/bookmarksync/client-windows/SyncLib
In directory sc8-pr-cvs1:/tmp/cvs-serv14070/SyncLib

Modified Files:
      Tag: CLIENT_1_7_DEV
	SyncLib.vcproj 
Log Message:
* added PDB debugging files to release version

Index: SyncLib.vcproj
===================================================================
RCS file: /cvsroot/bookmarksync/client-windows/SyncLib/SyncLib.vcproj,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -w -r1.2 -r1.2.2.1
--- SyncLib.vcproj	24 Oct 2003 14:12:36 -0000	1.2
+++ SyncLib.vcproj	13 Jan 2004 08:44:51 -0000	1.2.2.1
@@ -35,6 +35,7 @@
 				ProgramDataBaseFileName=".\Release/"
 				WarningLevel="3"
 				SuppressStartupBanner="TRUE"
+				DebugInformationFormat="3"
 				CompileAs="0"/>
 			<Tool
 				Name="VCCustomBuildTool"/>

[BMSYNC-CVS] CVS: client-windows/md5 md5.vcproj,1.2.2.1,1.2.2.2

From: Daniel G. <dge...@us...> - 2004-01-13 08:44:54

Update of /cvsroot/bookmarksync/client-windows/md5
In directory sc8-pr-cvs1:/tmp/cvs-serv14070/md5

Modified Files:
      Tag: CLIENT_1_7_DEV
	md5.vcproj 
Log Message:
* added PDB debugging files to release version

Index: md5.vcproj
===================================================================
RCS file: /cvsroot/bookmarksync/client-windows/md5/md5.vcproj,v
retrieving revision 1.2.2.1
retrieving revision 1.2.2.2
diff -u -w -r1.2.2.1 -r1.2.2.2
--- md5.vcproj	27 Oct 2003 12:28:13 -0000	1.2.2.1
+++ md5.vcproj	13 Jan 2004 08:44:51 -0000	1.2.2.2
@@ -82,7 +82,8 @@
 				ObjectFile=".\Release/"
 				ProgramDataBaseFileName=".\Release/"
 				WarningLevel="3"
-				SuppressStartupBanner="TRUE"/>
+				SuppressStartupBanner="TRUE"
+				DebugInformationFormat="3"/>
 			<Tool
 				Name="VCCustomBuildTool"/>
 			<Tool

[BMSYNC-CVS] CVS: client-windows/BookmarkLib BookmarkLib.vcproj,1.2,1.2.2.1

From: Daniel G. <dge...@us...> - 2004-01-13 08:44:54

Update of /cvsroot/bookmarksync/client-windows/BookmarkLib
In directory sc8-pr-cvs1:/tmp/cvs-serv14070/BookmarkLib

Modified Files:
      Tag: CLIENT_1_7_DEV
	BookmarkLib.vcproj 
Log Message:
* added PDB debugging files to release version

Index: BookmarkLib.vcproj
===================================================================
RCS file: /cvsroot/bookmarksync/client-windows/BookmarkLib/BookmarkLib.vcproj,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -w -r1.2 -r1.2.2.1
--- BookmarkLib.vcproj	24 Oct 2003 14:12:34 -0000	1.2
+++ BookmarkLib.vcproj	13 Jan 2004 08:44:51 -0000	1.2.2.1
@@ -35,6 +35,7 @@
 				ProgramDataBaseFileName=".\Release/"
 				WarningLevel="3"
 				SuppressStartupBanner="TRUE"
+				DebugInformationFormat="3"
 				CompileAs="0"/>
 			<Tool
 				Name="VCCustomBuildTool"/>

[BMSYNC-CVS] CVS: client-windows/SyncIT SyncIT.vcproj,1.2,1.2.2.1

From: Daniel G. <dge...@us...> - 2004-01-13 08:44:54

Update of /cvsroot/bookmarksync/client-windows/SyncIT
In directory sc8-pr-cvs1:/tmp/cvs-serv14070/SyncIT

Modified Files:
      Tag: CLIENT_1_7_DEV
	SyncIT.vcproj 
Log Message:
* added PDB debugging files to release version

Index: SyncIT.vcproj
===================================================================
RCS file: /cvsroot/bookmarksync/client-windows/SyncIT/SyncIT.vcproj,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -w -r1.2 -r1.2.2.1
--- SyncIT.vcproj	24 Oct 2003 14:12:35 -0000	1.2
+++ SyncIT.vcproj	13 Jan 2004 08:44:51 -0000	1.2.2.1
@@ -35,6 +35,7 @@
 				ProgramDataBaseFileName=".\Release/"
 				WarningLevel="3"
 				SuppressStartupBanner="TRUE"
+				DebugInformationFormat="3"
 				CompileAs="0"/>
 			<Tool
 				Name="VCCustomBuildTool"/>
@@ -44,6 +45,7 @@
 				OutputFile=".\Release/SyncIT.exe"
 				LinkIncremental="1"
 				SuppressStartupBanner="TRUE"
+				GenerateDebugInformation="TRUE"
 				ProgramDatabaseFile=".\Release/SyncIT.pdb"
 				SubSystem="2"
 				TargetMachine="1"/>

[BMSYNC-CVS] CVS: server-php-minimal client.php,1.7,1.8

From: Steffen S. <si...@us...> - 2003-11-28 16:56:44

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1:/tmp/cvs-serv17435

Modified Files:
	client.php 
Log Message:
FIXED: Issue 847620: Initial upload times out


Index: client.php
===================================================================
RCS file: /cvsroot/bookmarksync/server-php-minimal/client.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -w -r1.7 -r1.8
--- client.php	7 Nov 2003 17:47:37 -0000	1.7
+++ client.php	28 Nov 2003 16:56:41 -0000	1.8
@@ -142,6 +142,8 @@
           $content = substr($content,strlen($content)-(strlen($content)-$i-1));
         } while (true);
 
+        set_time_limit(10); // Now we have 10 seconds for cleanup
+
         // with our updates finished, we update the token and move on.
         my_mysql_query("update syncit_person set token = token+1, lastchanged = now() where personid='$ID'");
         $res = my_mysql_query("select token from syncit_person where personid='$ID'");
@@ -163,6 +165,7 @@
 // parses bookmark list line,
 // processes adds and deletes.
 function parseline($bm_row,$ID) {
+    set_time_limit(2);                           // For processing one line 2 seconds should be enough...
 
     debug("raw: $bm_row");                       // debugging love.
     if (get_magic_quotes_gpc() == 1) {           // auto-escape is on...

[BMSYNC-CVS] CVS: server-php-minimal view.php,1.5,1.6

From: Steffen S. <si...@us...> - 2003-11-17 09:16:44

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1:/tmp/cvs-serv19585

Modified Files:
	view.php 
Log Message:
FIXED: If there is no valid session index.php is shown instead of a
blank page.
FIXED: The URL is now enclosed in double quotes and thus can contain
single quotes (SF Bug 838258).
FIXED: Some minor fixes and improvements.


Index: view.php
===================================================================
RCS file: /cvsroot/bookmarksync/server-php-minimal/view.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -w -r1.5 -r1.6
--- view.php	15 Nov 2003 18:13:54 -0000	1.5
+++ view.php	17 Nov 2003 09:15:58 -0000	1.6
@@ -26,8 +26,12 @@
 // Modified:    $Date$, $Author$
 // ----------------------------------------------------------------------------
 session_start();
-?>
 
+$pid = (isset($_SESSION["pid"]))?$_SESSION["pid"]:"";
+if ($pid == "") {
+        header("Location: index.php");
+}
+?>
 <html>
 <head>
 <title>Your Bookmarks</title>
@@ -167,14 +171,11 @@
 <?php
 include 'db.php';
 
-$pid = (isset($_SESSION["pid"]))?$_SESSION["pid"]:"";
-if ($pid == "")
-	exit();
-
-if (!db_connect())
-	die();
+if (!db_connect()) {
+	die("Cannot connect database in view.php");
+}
 
-$debug = false; // set this to log SQL statements and client communication.
+$debug = false;
 
 $res  = mysql_query("select value from syncit_config where param='debug'");
 $data = mysql_fetch_assoc($res);
@@ -185,7 +186,10 @@
       $debug = true;
     }
 }
-if ($debug) { $debug_fh = @fopen("debug.log", "a"); }
+
+if ($debug) {
+        $debug_fh = @fopen("debug.log", "a");
+}
 
 {
 	$myurl = array();
@@ -197,10 +201,6 @@
 
 	$ID = $pid;
 
-	if (!db_connect()) {
-		die();
-        }
-
 	$target = $_SESSION['target'];
 
 	if ($target == "") {
@@ -212,7 +212,7 @@
 	$res = mysql_query($sql);
 
 	if (!$res) {
-		die("$sql<hr>Cannot retrieve data in view_ns.php");
+		die("$sql<hr>Cannot retrieve data in view.php");
         }
 
 	while ($data = mysql_fetch_assoc($res)) {
@@ -246,10 +246,10 @@
 
 		if ($is_folder == false){
 			if ($items > 1){
-				echo "<li><a target='" . $target . "' href='" . $data['url'] . "'>" . $line[$items-1] . "</a></li>\r\n";
+				echo "<li><a target='" . $target . "' href=\"" . $data['url'] . "\">" . $line[$items-1] . "</a></li>\r\n";
 			}
 			else {
-				$myurl[$url_idx++] = "<li><a target='" . $target . "' href='" . $data['url'] . "'>" . $line[0] . "</a></li>\r\n";
+				$myurl[$url_idx++] = "<li><a target='" . $target . "' href=\"" . $data['url'] . "\">" . $line[0] . "</a></li>\r\n";
 			}
 		}

[BMSYNC-CVS] CVS: server-php-minimal view.php,1.4,1.5

From: Steffen S. <si...@us...> - 2003-11-15 18:26:28

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1:/tmp/cvs-serv9037

Modified Files:
	view.php 
Log Message:
CHANGED: Folder view is now based on code provided by user 'fmunz' for
mozilla/firebird browser. Tested with mozilla 1.5.
FIXED: IE display bug. Tested with IE 5.0 and 6.0.
CHANGED/FIXED: The list creation from sql resultset has been rewritten
from scratch and should be correct and more robust.
NEW: Debug output.


Index: view.php
===================================================================
RCS file: /cvsroot/bookmarksync/server-php-minimal/view.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -w -r1.4 -r1.5
--- view.php	21 Oct 2003 20:49:00 -0000	1.4
+++ view.php	15 Nov 2003 18:13:54 -0000	1.5
@@ -30,76 +30,140 @@
 
 <html>
 <head>
-<base target=_blank>
 <title>Your Bookmarks</title>
-<style>
-.fi {
-    font-family: "MS Sans Serif", Arial, Helvetica, sans-serif;
-    font-size: 11px;
-    font-weight: normal;
-	list-style-image: url("images/f.gif");
-	cursor: hand;
-}
-
-.bi {
-	font-family: "MS Sans Serif", Arial, Helvetica, sans-serif;
-	font-size: 10px;
-	font-weight: normal;
-	list-style-image: url("images/a.gif");
-}
-.bi a:link {text-decoration: none; color: #000099; }
-.bi a:visited {text-decoration: none; color: #000099; }
-.bi a:hover {text-decoration: underline;color: #0000FF; }
+<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
+
+<style type="text/css">
+a {
+	font: normal 0.9em Verdana;
+	color: black;
+}
+
+ul.aqtree3clickable {
+	margin-left: 0;
+	padding-left: 0;
+	font: normal 0.9em Verdana;
+}
+
+/* Turn off list bullets */
+ul.aqtree3clickable li { list-style: none; }
+
+ul { padding-left: 0; margin-left: 25px; }
+/* Provide space for our own "bullet" inside the link */
+ul.aqtree3clickable li { padding-left: 20px; }
+
+/* Show "bullets" in the links, depending on the class of the
+   LI that the link's in */
+ul.aqtree3clickable li.aq3open {
+    background: url(images/o.gif) top left no-repeat;
+	text-decoration: none;
+	color: black;
+}
+ul.aqtree3clickable li.aq3closed {
+    background: url(images/f.gif) top left no-repeat;
+	text-decoration: none;
+	color: black;
+}
+ul.aqtree3clickable li.aq3bullet {
+    background: url(images/a.gif) top left no-repeat;
+	text-decoration: underline;
+	color: #009;
+}
+
+/* Actually show and hide sublists */
+ul.aqtree3clickable li.aq3open ul { display: block; }
+ul.aqtree3clickable li.aq3closed ul { display: none; }
 </style>
-</head>
-<script language="JavaScript">
+
+<script type="text/javascript">
 <!--
-var head="display:''"
-img1=new Image()
-img1.src="images/f.gif"
-img2=new Image()
-img2.src="images/o.gif"
+/*
+aqtree3clickable
 
-function nchange(f) {
-	f1.style.display='';
-	return false;
+Converts an unordered list to an explorer-style tree, with clickable
+icons
+
+http://www.kryogenix.org/code/browser/aqlists/
+
+Stuart Langridge, November 2002
+si...@kr...
+*/
+
+addEvent(window, "load", makeTreesC);
+
+function makeTreesC() {
+    // We don't actually need createElement, but we do
+    // need good DOM support, so this is a good check.
+    if (!document.createElement) return;
+
+    uls = document.getElementsByTagName("ul");
+    for (uli=0;uli<uls.length;uli++) {
+        ul = uls[uli];
+        if (ul.nodeName == "UL" && ul.className == "aqtree3clickable") {
+            processULELC(ul);
+        }
+    }
 }
 
-function change(){
-   if(!document.all) {
-      return
-     }
-   var noff,soff,myid;
-   myid=event.srcElement.id;
-   noff=5;soff=4;
-   //alert (myid);
-   if (myid =="fx1") {
-   	myid="fx";
-   	soff=0;noff=1;
-   }
-   if (myid=="fx") {
-      var srcIndex = event.srcElement.sourceIndex
-      var nested = document.all[srcIndex+noff]
-      if (nested.style.display=="none") {
-         document.all[srcIndex+soff].src="images/o.gif"
-         nested.style.display=''
-         //event.srcElement.style.listStyleImage="url(images/o.gif)"
+function processULELC(ul) {
+    if (!ul.childNodes || ul.childNodes.length == 0) return;
+    // Iterate LIs
+    for (var itemi=0;itemi<ul.childNodes.length;itemi++) {
+        var item = ul.childNodes[itemi];
+        if (item.nodeName == "LI") {
+            // Iterate things in this LI
+            var a;
+            var subul;
+        subul = "";
+            for (var sitemi=0;sitemi<item.childNodes.length;sitemi++) {
+                var sitem = item.childNodes[sitemi];
+                switch (sitem.nodeName) {
+                    case "A": a = sitem; break;
+                    case "UL": subul = sitem;
+                               processULELC(subul);
+                               break;
+                }
+            }
+            if (subul) {
+                associateELC(a,subul);
+            } else {
+                a.parentNode.className = "aq3bullet";
       }
-      else {
-         document.all[srcIndex+soff].src="images/f.gif"
-         nested.style.display="none"
-         //event.srcElement.style.listStyleImage="url(images/f.gif)"
       }
    }
 }
 
-document.onclick=change
+function associateELC(a,ul) {
+    a.parentNode.className = 'aq3closed';
+    a.onclick = function () {
+        this.parentNode.className = (this.parentNode.className=='aq3open') ? "aq3closed" : "aq3open";
+        return false;
+    }
+}
 
-//-->
+/*              Utility functions                    */
 
+function addEvent(obj, evType, fn){
+  /* adds an eventListener for browsers which support it
+     Written by Scott Andrew: nice one, Scott */
+  if (obj.addEventListener){
+    obj.addEventListener(evType, fn, true);
+    return true;
+  } else if (obj.attachEvent){
+    var r = obj.attachEvent("on"+evType, fn);
+    return r;
+  } else {
+    return false;
+  }
+}
+//-->
 </script>
 
+</head>
+
 <body>
+
+<ul class="aqtree3clickable">
 <?php
 include 'db.php';
 
@@ -110,103 +174,109 @@
 if (!db_connect())
 	die();
 
+$debug = false; // set this to log SQL statements and client communication.
+
+$res  = mysql_query("select value from syncit_config where param='debug'");
+$data = mysql_fetch_assoc($res);
+if (!$data) {
+    my_mysql_query("insert into syncit_config (param, value) values ('debug', 'false')");
+} else {
+    if ($data["value"] == 'true') {
+      $debug = true;
+    }
+}
+if ($debug) { $debug_fh = @fopen("debug.log", "a"); }
+
 {
-	$vlen = 0;
 	$myurl = array();
 	$url_idx = 0;
 	$last_line = array();
-	$last_items = 0;
+	$last_items = 1;
 	$items = 0;
+	$level = 1;
 
 	$ID = $pid;
 
-	if (!db_connect())
+	if (!db_connect()) {
 		die();
+        }
 
-	$MSIE = strpos($_SERVER['HTTP_USER_AGENT'],"MSIE");
-	$NS6 = strpos($_SERVER['HTTP_USER_AGENT'],"Netscape6");
-	$NS6 = false;
 	$target = $_SESSION['target'];
-	if ($target == "")
+
+	if ($target == "") {
 		$target = "_blank";
+        }
+
 	$sql = "select syncit_link.path,syncit_bookmarks.url from syncit_bookmarks right join syncit_link on syncit_bookmarks.bookid = syncit_link.book_id where syncit_link.person_id=" . $ID . " and syncit_link.expiration is null order by syncit_link.path";
 
 	$res = mysql_query($sql);
-	if (!$res)
-		die("$sql<hr>Cannot retrieve data in tree.php");
 
-	$delim = "";
-	$showit = true;
-	$level = 1;
-	$foldernum = 0;
+	if (!$res) {
+		die("$sql<hr>Cannot retrieve data in view_ns.php");
+        }
 
 	while($data = mysql_fetch_assoc($res)){
 
-		$is_folder = false;
-		if (!isset($data['url']))
+		if (!isset($data['url'])) {
 			$is_folder = true;
+                } else {
+        		$is_folder = false;
+                }
 
 		$line = explode("\\",substr($data['path'],1));
 		$items = count($line);
 
-		if ($is_folder == true){
+                debug("l: ". $data['path']);
+                debug("items: ".$items." last_items: ".$last_items." is_folder: ".$is_folder);
 
-			if ($items > $last_items){
-				for ($idx = 0; $idx < $items-1; $idx++){
-					if (!isset($last_line[$idx]) || $line[$idx] != $last_line[$idx]){
-						echo "<div id='fx' class='fi'><img src='images/s.gif' width='0'><img src='images/s.gif' width='0'><img src='images/s.gif' height=10 width=" . ($idx*15) . "><img id='fx1' src='images/f.gif'>" . $line[$idx] . "</div>\r\n";
-						echo "<div id='fl' style='display:none' style=&{head};>\r\n";
-					}
-				}
-			}
+                $level = $last_items - 1;
 
-			else if ($items <= $last_items){
-				for ($idx = 0; $idx < $last_items - $items +1; $idx++)
-					echo "</div>\r\n";
+                debug("level = ".$level." last_line[level-1] = >".$last_line[$level-1]."< line[level-1] = >".$line[$level-1]."<");
 
-				for ($idx = 0; $idx < $items-1; $idx++){
-					if ($last_line[$idx] != $line[$idx]){
-						echo "<div id='fx' class='fi'><img src='images/s.gif' width='0'><img src='images/s.gif' width='0'><img src='images/s.gif' height=10 width=" . ($idx*15) . "><img id='fx1' src='images/f.gif'>" . $line[$idx] . "</div>\r\n";
-						echo "<div id='fl' style='display:none' style=&{head};>\r\n";
-					}
-				}
+                while ($level > 0 && $last_line[$level-1] != $line[$level-1]) {
+                        echo "</ul>\r\n";
+                        $level = $level - 1;
 			}
 
-			$last_line = $line;
-			$last_items = $items;
+                while ($level < $items-1) {
+			echo "<li><a href=\"#\">" . $line[$level] . "</a>\r\n";
+			echo "<ul>\r\n";
+                        $level = $level + 1;
 		}
 
-		// else we differ on the link only so add a link in the current folder
-		else {
+		if ($is_folder == false){
 			if ($items > 1){
-				echo "<div class='bi'><img src='images/s.gif' width='0'><img src='images/s.gif' height=10 width=" . (($items-1)*15) . "><img src='images/a.gif'><a target='" . $target . "' href='" . $data['url'] . "'>" . $line[$items-1] . "</a></div>\r\n";
+				echo "<li><a target='" . $target . "' href='" . $data['url'] . "'>" . $line[$items-1] . "</a></li>\r\n";
 			}
 			else {
-				$myurl[$url_idx++] = "<div class='bi'><img src='images/s.gif' width='0'><img src='images/s.gif' height=10 width=" . (($items-1)*15) . "><img src='images/a.gif'><a target='" . $target . "' href='" . $data['url'] . "'>" . $line[0] . "</a></div>\r\n";
-			}
+				$myurl[$url_idx++] = "<li><a target='" . $target . "' href='" . $data['url'] . "'>" . $line[0] . "</a></li>\r\n";
 		}
 	}
 
-	for ($idx = 0; $idx < $items; $idx++)
-		echo "</div>\r\n";
+        	$last_line = $line;
+		$last_items = $items;
+	}
 
-	echo "</div>\r\n";
+        $level = $last_items - 1;
+        while ($level > 0) {
+                echo "</ul>\r\n";
+                $level = $level - 1;
+        }
 
 	if ($url_idx > 0){
 		for ($idx = 0; $idx < $url_idx; $idx++)
 			echo $myurl[$idx];
 	}
 } 
-	for ($idx = 0; $idx < $items; $idx++)
-		echo "</div>\r\n";
 
-	echo "</div>\r\n";
-
-	if ($url_idx > 0){
-		for ($idx = 0; $idx < $url_idx; $idx++)
-			echo $myurl[$idx];
+function debug($str) {
+    global $debug, $debug_fh;
+    if (!$debug) { return; }
+    $date = date("D M j G:i:s T Y");
+    fputs($debug_fh,  "[$date] $str\r\n");
 	}
 
 ?>
+</ul>
 </body>
 </html>

[BMSYNC-CVS] CVS: server-php-minimal CHANGELOG,1.7,1.8

From: Steffen S. <si...@us...> - 2003-11-07 22:21:07

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1:/tmp/cvs-serv1308

Modified Files:
	CHANGELOG 
Log Message:
NEW: Release 0.2.2


Index: CHANGELOG
===================================================================
RCS file: /cvsroot/bookmarksync/server-php-minimal/CHANGELOG,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -w -r1.7 -r1.8
--- CHANGELOG	21 Oct 2003 20:49:00 -0000	1.7
+++ CHANGELOG	7 Nov 2003 22:21:02 -0000	1.8
@@ -3,6 +3,29 @@
 # CHANGELOG                 http://www.sourceforge.net/projects/bookmarksync/ #
 ###############################################################################
 
+0.2.2 (released 2003-11-07)
+
+    NOTE: This is mostly a re-release of unoffical 0.2.1 release available
+    from berlios.de
+	
+  - more extensive and more user friendly debugging via new debug.php page.
+    After authentification (please change the current password 'secret' to
+    something really secret) the current debug.log is displayed together
+    with the current logging state (logging enabled or disabled).
+
+    A button toggles the logging state, another button refreshes the page
+    (to show new log entries) and with the truncate button it is possible
+    (after confirmation) to flush all log entries.
+  - Fixed SF bugs 830173 and 823312 (URLs containing quotes couldn't
+    inserted into the database.
+  - Fixed reg.php:SF Bug 817537 (REGEDIT4 and no trailing slash for root)
+    Blank line after copyright block broke header modification.
+  - All unnecessary tables and fields of the remaining tables in
+    bookmarksync.sql were removed (to make it minimal).
+  - Added new database table syncit_config which stores configuration
+    params. (currently used for debug output only, but other params like
+    master password etc. should be stored here)
+  
 0.2.0 (released October 21st, 2003)
   - all database tables prefixed with syncit_ now.
   - upgrade.php added to convert plaintext passwords to md5'd equivalents.

[BMSYNC-CVS] CVS: server-php-minimal client.php,1.6,1.7

From: Steffen S. <si...@us...> - 2003-11-07 17:47:41

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1:/tmp/cvs-serv13148

Modified Files:
	client.php 
Log Message:
FIXED: Trailing space in errormsg removed.


Index: client.php
===================================================================
RCS file: /cvsroot/bookmarksync/server-php-minimal/client.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -w -r1.6 -r1.7

Re: [BMSYNC-CVS] CVS: server-php-minimal reg.php,1.3,1.4

From: Morbus I. <mo...@di...> - 2003-11-07 14:59:48

 >-$reginfo = 'Windows Registry Editor Version 5.00
 >+$reginfo = 'REGEDIT4

Does the REGEDIT4 line work on Windows 2000 and up?


-- 
Morbus Iff ( i put the demon back in codemonkey )
Culture: http://www.disobey.com/ and http://www.gamegrene.com/
Mac OS X Hacks: http://amazon.com/exec/obidos/ASIN/0596004605/disobeycom
icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus

Re: [BMSYNC-CVS] CVS: server-php-minimal client.php,1.5,1.6

From: Morbus I. <mo...@di...> - 2003-11-07 14:58:29

 >+        my_echo("Invalid Bookmark Command: $cmd ");
 >         debug("Invalid Bookmark Command: [$cmd].");

Nitpicking in client.php - why a trailing space and no period for
the my_echo? (For historical purposes: As you may have surmised,
the brackets for the debug clarify whitespace issues.)


-- 
Morbus Iff ( i put the demon back in codemonkey )
Culture: http://www.disobey.com/ and http://www.gamegrene.com/
Mac OS X Hacks: http://amazon.com/exec/obidos/ASIN/0596004605/disobeycom
icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus

Re: [BMSYNC-CVS] CVS: server-php-minimal client.php,1.5,1.6

From: Morbus I. <mo...@di...> - 2003-11-07 14:55:52

 >+       $surl = addslashes(substr($url,7,55).substr($url,-200));
 >                  // MySQL indexes can only be 255.

Steffan - some concern over one. What happens when the substr returns 255 
characters from a large URL, and then addslashes adds more characters for 
escaping? Does the escaping character "count" as a character against the 
255 limit (even though it's a control char that is never truly seen)?


-- 
Morbus Iff ( i put the demon back in codemonkey )
Culture: http://www.disobey.com/ and http://www.gamegrene.com/
Mac OS X Hacks: http://amazon.com/exec/obidos/ASIN/0596004605/disobeycom
icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus

[BMSYNC-CVS] CVS: server-php-minimal bookmarksync.sql,1.3,1.4

From: Steffen S. <si...@us...> - 2003-11-07 12:33:37

Update of /cvsroot/bookmarksync/server-php-minimal
In directory sc8-pr-cvs1:/tmp/cvs-serv16911

Modified Files:
	bookmarksync.sql 
Log Message:
FIXED: All unnecessary tables and fields of the remaining tables were
removed.

NEW: Added new database table syncit_config which stores
configuration params. (currently used for debug output only, but other
params like master password etc. should be stored here)


Index: bookmarksync.sql
===================================================================
RCS file: /cvsroot/bookmarksync/server-php-minimal/bookmarksync.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -w -r1.3 -r1.4
--- bookmarksync.sql	7 Nov 2003 11:53:35 -0000	1.3
+++ bookmarksync.sql	7 Nov 2003 12:33:33 -0000	1.4
@@ -8,9 +8,6 @@
 CREATE TABLE syncit_bookmarks (
   bookid int(10) unsigned NOT NULL auto_increment,
   surl varchar(255) default NULL,
-  lastchecked datetime default NULL,
-  title varchar(255) default NULL,
-  status smallint(6) default NULL,
   url text,
   PRIMARY KEY  (bookid),
   UNIQUE KEY urlidx (surl)
@@ -18,98 +15,17 @@
 
 
 #
-# Table structure for table 'syncit_buttugly_redir'
-#
-
-DROP TABLE IF EXISTS syncit_buttugly_redir;
-CREATE TABLE syncit_buttugly_redir (
-  person_id int(11) default NULL,
-  publish_id int(11) default NULL,
-  book_id int(11) default NULL,
-  access datetime default NULL
-) TYPE=MyISAM;
-
-
-#
-# Table structure for table 'syncit_category'
-#
-
-DROP TABLE IF EXISTS syncit_category;
-CREATE TABLE syncit_category (
-  name varchar(50) default NULL,
-  categoryid int(11) NOT NULL auto_increment,
-  description varchar(50) default NULL,
-  PRIMARY KEY  (categoryid)
-) TYPE=MyISAM;
-
-
-#
-# Dumping data for table 'syncit_category'
-#
-
-INSERT INTO syncit_category VALUES("Computer", "1", "Computer");
-INSERT INTO syncit_category VALUES("Travel", "2", "Travel");
-INSERT INTO syncit_category VALUES("Finance", "3", "Finance");
-INSERT INTO syncit_category VALUES("International", "4", "International");
-INSERT INTO syncit_category VALUES("Develop", "5", "Develop");
-
-
-#
-# Table structure for table 'syncit_charsets'
-#
-
-DROP TABLE IF EXISTS syncit_charsets;
-CREATE TABLE syncit_charsets (
-  charsetid int(10) unsigned NOT NULL auto_increment,
-  charset varchar(16) default NULL,
-  PRIMARY KEY  (charsetid)
-) TYPE=MyISAM;
-
-
-#
-# Table structure for table 'syncit_images'
-#
-
-DROP TABLE IF EXISTS syncit_images;
-CREATE TABLE syncit_images (
-  imgid int(10) unsigned NOT NULL auto_increment,
-  src varchar(255) default NULL,
-  width int(11) default NULL,
-  height int(11) default NULL,
-  PRIMARY KEY  (imgid)
-) TYPE=MyISAM;
-
-
-#
-# Table structure for table 'syncit_invitations'
-#
-
-DROP TABLE IF EXISTS syncit_invitations;
-CREATE TABLE syncit_invitations (
-  invitationid int(10) unsigned NOT NULL auto_increment,
-  personid int(11) default NULL,
-  email varchar(50) default NULL,
-  publishid int(11) default NULL,
-  invited datetime default NULL,
-  PRIMARY KEY  (invitationid)
-) TYPE=MyISAM;
-
-
-#
 # Table structure for table 'syncit_link'
 #
 
 DROP TABLE IF EXISTS syncit_link;
 CREATE TABLE syncit_link (
-  link_id int(10) unsigned NOT NULL auto_increment,
+  link_id int(10) unsigned NOT NULL auto_increment,  # not used
   person_id int(11) NOT NULL default '0',
   book_id int(11) default NULL,
   access varchar(24) default NULL,
   path varchar(255) NOT NULL default '\\',
-  publish_id int(11) default NULL,
   expiration datetime default NULL,
-  openimg_id int(11) default NULL,
-  closeimg_id int(11) default NULL,
   PRIMARY KEY  (person_id,path),
   UNIQUE KEY linkdx (link_id),
   FULLTEXT KEY idxpath (path)
@@ -124,83 +40,23 @@
 CREATE TABLE syncit_person (
   personid int(10) unsigned NOT NULL auto_increment,
   name varchar(50) default NULL,
-  address1 varchar(50) default NULL,
-  address2 varchar(50) default NULL,
-  city varchar(50) default NULL,
-  state varchar(20) default NULL,
-  zip varchar(10) default NULL,
-  phone varchar(50) default NULL,
-  fax varchar(50) default NULL,
   email varchar(50) default NULL,
-  security int(11) default NULL,
-  description text,
-  wherefrom text,
   pass varchar(50) default NULL,
   registered datetime default NULL,
   lastchanged datetime default NULL,
-  lastread datetime default NULL,
-  country varchar(30) default NULL,
-  age int(11) default NULL,
-  gender char(1) default NULL,
   token int(11) default '0',
-  upsize_ts varchar(255) default NULL,
-  optin smallint(6) default NULL,
-  lastverified datetime default NULL,
-  refercnt int(11) default NULL,
   PRIMARY KEY  (personid),
   UNIQUE KEY idxemail (email)
 ) TYPE=MyISAM;
 
 
 #
-# Table structure for table 'syncit_publish'
+# Table structure for table 'syncit_config'
 #
 
-DROP TABLE IF EXISTS syncit_publish;
-CREATE TABLE syncit_publish (
-  publishid int(10) unsigned NOT NULL auto_increment,
-  user_id int(11) default NULL,
-  path varchar(255) default NULL,
-  category_id int(11) default NULL,
-  created datetime default NULL,
-  title varchar(50) default NULL,
-  description text,
-  token int(11) default NULL,
-  anonymous enum('True','False') default NULL,
-  PRIMARY KEY  (publishid)
+DROP TABLE IF EXISTS syncit_config;
+CREATE TABLE syncit_config (
+  param varchar(50) NOT NULL,
+  value varchar(50) default NULL,
+  PRIMARY KEY (param)
 ) TYPE=MyISAM;
-
-
-#
-# Table structure for table 'syncit_removed'
-#
-
-DROP TABLE IF EXISTS syncit_removed;
-CREATE TABLE syncit_removed (
-  name varchar(50) default NULL,
-  email varchar(50) default NULL,
-  bookmarks int(11) default NULL,
-  reason text,
-  registered datetime default NULL,
-  removed datetime default NULL,
-  lastchanged datetime default NULL,
-  token int(11) default NULL,
-  id int(11) NOT NULL auto_increment,
-  PRIMARY KEY  (id)
-) TYPE=MyISAM;
-
-
-#
-# Table structure for table 'syncit_subscriptions'
-#
-
-DROP TABLE IF EXISTS syncit_subscriptions;
-CREATE TABLE syncit_subscriptions (
-  subscriptionid int(10) unsigned NOT NULL auto_increment,
-  person_id int(11) default NULL,
-  publish_id int(11) default NULL,
-  created datetime default NULL,
-  vote smallint(6) default NULL,
-  PRIMARY KEY  (subscriptionid)
-) TYPE=MyISAM;
-

2 messages has been excluded from this view by a project administrator.

Flat | Threaded

1 2 3 4 > >> (Page 1 of 4)