svnno****@sourc*****
svnno****@sourc*****
2012年 3月 31日 (土) 21:21:16 JST
ForkRevision: 76
http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=76
Author: hryksbt
Date: 2012-03-31 21:21:15 +0900 (Sat, 31 Mar 2012)
Log Message:
-----------
お掃除
Added Paths:
-----------
branch/
tags/
tags/SmartUpload.20120331/
tags/SmartUpload.20120331/.buildpath
tags/SmartUpload.20120331/.project
tags/SmartUpload.20120331/.settings/
tags/SmartUpload.20120331/.settings/org.eclipse.php.core.prefs
tags/SmartUpload.20120331/auth.php
tags/SmartUpload.20120331/data/
tags/SmartUpload.20120331/data/OpenSangoksuhi.apk
tags/SmartUpload.20120331/data/Opening.xml
tags/SmartUpload.20120331/data/dump.sql
tags/SmartUpload.20120331/data/test.txt
tags/SmartUpload.20120331/data/test2.txt
tags/SmartUpload.20120331/download_file.php
tags/SmartUpload.20120331/include/
tags/SmartUpload.20120331/include/database.php
tags/SmartUpload.20120331/main.php
tags/SmartUpload.20120331/mod_user.php
tags/SmartUpload.20120331/upload_file.php
tags/SmartUpload.20120331/upload_form.php
tags/SmartUpload.20120331/user_add.php
tags/SmartUpload.20120331/user_form.php
trunk/src/
trunk/src/Android/
trunk/src/Engine/
trunk/src/Web/
trunk/src/iOS/
Removed Paths:
-------------
trunk/SmartUpload/
-------------- next part --------------
Added: tags/SmartUpload.20120331/.buildpath
===================================================================
--- tags/SmartUpload.20120331/.buildpath (rev 0)
+++ tags/SmartUpload.20120331/.buildpath 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<buildpath>
+ <buildpathentry kind="src" path=""/>
+ <buildpathentry kind="con" path="org.eclipse.php.core.LANGUAGE"/>
+</buildpath>
Added: tags/SmartUpload.20120331/.project
===================================================================
--- tags/SmartUpload.20120331/.project (rev 0)
+++ tags/SmartUpload.20120331/.project 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,22 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<projectDescription>
+ <name>SmartUpload</name>
+ <comment></comment>
+ <projects>
+ </projects>
+ <buildSpec>
+ <buildCommand>
+ <name>org.eclipse.wst.validation.validationbuilder</name>
+ <arguments>
+ </arguments>
+ </buildCommand>
+ <buildCommand>
+ <name>org.eclipse.dltk.core.scriptbuilder</name>
+ <arguments>
+ </arguments>
+ </buildCommand>
+ </buildSpec>
+ <natures>
+ <nature>org.eclipse.php.core.PHPNature</nature>
+ </natures>
+</projectDescription>
Added: tags/SmartUpload.20120331/.settings/org.eclipse.php.core.prefs
===================================================================
--- tags/SmartUpload.20120331/.settings/org.eclipse.php.core.prefs (rev 0)
+++ tags/SmartUpload.20120331/.settings/org.eclipse.php.core.prefs 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,5 @@
+#Sun Apr 17 00:12:11 JST 2011
+eclipse.preferences.version=1
+include_path=0;/SmartUpload
+phpVersion=php5.3
+use_asp_tags_as_php=false
Added: tags/SmartUpload.20120331/auth.php
===================================================================
--- tags/SmartUpload.20120331/auth.php (rev 0)
+++ tags/SmartUpload.20120331/auth.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,82 @@
+<?php
+/*
+ * SmartUpload/auth.php
+ * @author Hiroyuki Shibata
+ * 2011/05/15
+ * Rev 1.0
+ *
+ */
+ session_start();
+?>
+
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+
+<?php
+ require_once("include/database.php");
+
+ $userid = $_POST['id'];
+ $password = $_POST['pass'];
+
+ // ログインフォームを関数化
+ function login_form() {
+?>
+ <form name="login_form" action="auth.php" method="post">
+ ID（アカウント） ：<input type="text" name="id">
+ パスワード ：<input type="password" name="pass">
+ <input type="submit" value="ログイン" />
+ <input type="hidden" name="cmd" value="login"/>
+ </form>
+<?php
+ }
+
+ // メイン処理
+
+ if( isset($_POST['cmd']) && $_POST['cmd'] == "login" ) {
+
+ // ユーザ名＆パスワードチェック
+ $stmt = $db->prepare("SELECT * FROM user_info WHERE userid= ? AND password= ? ");
+ $stmt->execute(array($userid, $password));
+
+ // ログイン成功時
+ if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
+
+ $_SESSION["id"] = $_POST["id"];
+ print (htmlspecialchars($row["fullname"]."さん"));
+?>
+ <!-- ログアウトボタン -->
+ <form name="logout_form" action="auth.php" method="post">
+ <input type="submit" value="ログアウト">
+ <input type="hidden" name="cmd" value="logout"/>
+ </form>
+<?php
+ // ログイン失敗時
+ } else {
+
+ print (htmlspecialchars("ログインに失敗しました", ENT_QUOTES));
+ login_form();
+
+ }
+
+ // ログアウト完了後
+ } else if( isset($_POST['cmd']) && $_POST['cmd'] == "logout" ) {
+
+ print (htmlspecialchars("ログアウトしました", ENT_QUOTES));
+ session_destroy();
+ login_form();
+
+ } else {
+
+ // 未ログインの場合
+ login_form();
+
+ }
+
+ $pdo = null;
+?>
+</body>
+</html>
\ No newline at end of file
Added: tags/SmartUpload.20120331/data/OpenSangoksuhi.apk
===================================================================
(Binary files differ)
Property changes on: tags/SmartUpload.20120331/data/OpenSangoksuhi.apk
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: tags/SmartUpload.20120331/data/Opening.xml
===================================================================
--- tags/SmartUpload.20120331/data/Opening.xml (rev 0)
+++ tags/SmartUpload.20120331/data/Opening.xml 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="utf-8"?>
+<AbsoluteLayout
+android:id="@+id/widget32"
+android:layout_width="fill_parent"
+android:layout_height="fill_parent"
+xmlns:android="http://schemas.android.com/apk/res/android"
+>
+<Button
+android:id="@+id/Start_Button"
+android:layout_width="wrap_content"
+android:layout_height="wrap_content"
+android:text="開始"
+android:layout_x="130px"
+android:layout_y="312px"
+>
+</Button>
+<ImageView
+android:id="@+id/widget40"
+android:layout_width="wrap_content"
+android:layout_height="wrap_content"
+android:src="C:\Documents and Settings\Admin\デスクトップ\Sangokushi\trunk\images\logo.gif"
+android:layout_x="140px"
+android:layout_y="102px"
+>
+</ImageView>
+</AbsoluteLayout>
Added: tags/SmartUpload.20120331/data/dump.sql
===================================================================
--- tags/SmartUpload.20120331/data/dump.sql (rev 0)
+++ tags/SmartUpload.20120331/data/dump.sql 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,117 @@
+-- MySQL dump 10.13 Distrib 5.1.41, for Win32 (ia32)
+--
+-- Host: localhost Database: upload
+-- ------------------------------------------------------
+-- Server version 5.1.41
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `category`
+--
+
+DROP TABLE IF EXISTS `category`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `category` (
+ `cat_number` smallint(6) NOT NULL AUTO_INCREMENT,
+ `cat_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`cat_number`),
+ UNIQUE KEY `index_cat_name` (`cat_name`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `category`
+--
+
+LOCK TABLES `category` WRITE;
+/*!40000 ALTER TABLE `category` DISABLE KEYS */;
+INSERT INTO `category` VALUES (3,'application'),(1,'music'),(2,'photo');
+/*!40000 ALTER TABLE `category` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `data_info`
+--
+
+DROP TABLE IF EXISTS `data_info`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `data_info` (
+ `num` bigint(20) NOT NULL AUTO_INCREMENT,
+ `contentname` varchar(64) NOT NULL,
+ `filename` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
+ `uploaddate` datetime NOT NULL,
+ `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
+ `data_size` int(10) NOT NULL,
+ `rank` int(3) DEFAULT NULL,
+ `category` smallint(6) NOT NULL,
+ `comment` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`num`),
+ UNIQUE KEY `index_filename` (`filename`)
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `data_info`
+--
+
+LOCK TABLES `data_info` WRITE;
+/*!40000 ALTER TABLE `data_info` DISABLE KEYS */;
+INSERT INTO `data_info` VALUES (1,'','aaa.jpg','2011-04-18 00:00:00','a',666,NULL,0,'ああああああああ'),(2,'','bbb','2011-04-18 23:49:46','',777,NULL,0,''),(3,'','test.txt','2011-04-26 00:50:36','',20,NULL,0,''),(4,'3','test2.txt','2011-05-06 01:35:08','a',9092,NULL,3,'test2');
+/*!40000 ALTER TABLE `data_info` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `user_info`
+--
+
+DROP TABLE IF EXISTS `user_info`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_info` (
+ `num` bigint(20) NOT NULL AUTO_INCREMENT,
+ `userid` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+ `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+ `fullname` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+ `country_code` smallint(6) NOT NULL,
+ `add_date` datetime NOT NULL,
+ `change_date` datetime DEFAULT NULL,
+ `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ `frag` tinyint(1) NOT NULL DEFAULT '0',
+ `charge` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`num`),
+ UNIQUE KEY `index_email` (`email`)
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `user_info`
+--
+
+LOCK TABLES `user_info` WRITE;
+/*!40000 ALTER TABLE `user_info` DISABLE KEYS */;
+INSERT INTO `user_info` VALUES (1,'b','bbb','BBB',1,'2011-05-01 00:29:57',NULL,'',0,0),(2,'a','aaa','AAA',1,'2011-04-26 23:34:00',NULL,'aaa',0,0);
+/*!40000 ALTER TABLE `user_info` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2011-05-06 1:56:05
Added: tags/SmartUpload.20120331/data/test.txt
===================================================================
--- tags/SmartUpload.20120331/data/test.txt (rev 0)
+++ tags/SmartUpload.20120331/data/test.txt 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1 @@
+This is for testing.
\ No newline at end of file
Added: tags/SmartUpload.20120331/data/test2.txt
===================================================================
--- tags/SmartUpload.20120331/data/test2.txt (rev 0)
+++ tags/SmartUpload.20120331/data/test2.txt 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,122 @@
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
+aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
\ No newline at end of file
Added: tags/SmartUpload.20120331/download_file.php
===================================================================
--- tags/SmartUpload.20120331/download_file.php (rev 0)
+++ tags/SmartUpload.20120331/download_file.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,53 @@
+<?php
+/*
+ * SmartUpload/download_file.php
+ * @author Hiroyuki Shibata
+ * 2011/05/16
+ * Rev 1.0
+ *
+ */
+ session_start();
+?>
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+ <h2>ダウンロード</h2>
+ <?php
+
+ // メイン処理 //
+
+ require_once ("include/database.php");
+
+ $sql = $db->prepare('select * from data_info');
+ $sql->execute();
+ ?>
+ <!-- ダウンロードファイルリスト -->
+ <table border>
+ <tr>
+ <th>ファイル名</th>
+ <th>アップロード年月日＆時刻</th>
+ <th>サイズ</th>
+ <th>コメント</th>
+ </tr>
+ <?php
+ while($row = $sql->fetch(PDO::FETCH_ASSOC)) {
+ ?>
+ <tr>
+ <td><a href="./data/ <?php print(htmlspecialchars($row['filename'], ENT_QUOTES)); ?> ">
+ <?php print(htmlspecialchars($row['filename'], ENT_QUOTES)); ?></a>
+ </td>
+ <td><?php print(htmlspecialchars($row['uploaddate'], ENT_QUOTES)); ?></td>
+ <td><?php print(htmlspecialchars($row['data_size'], ENT_QUOTES)); ?> </td>
+ <td><?php print(htmlspecialchars($row['comment'], ENT_QUOTES)); ?></td>
+ </tr>
+ <?php
+ }
+
+ $pdo = null;
+ ?>
+ </table>
+</body>
+</html>
\ No newline at end of file
Added: tags/SmartUpload.20120331/include/database.php
===================================================================
--- tags/SmartUpload.20120331/include/database.php (rev 0)
+++ tags/SmartUpload.20120331/include/database.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,26 @@
+<?php
+/*
+ * SmartUpload/databases.php
+ * @author Hiroyuki Shibata
+ * 2011/04/26
+ * Rev 1.0
+ *
+ */
+
+ //PDOで接続
+
+ $dsn = 'mysql:dbname=upload;host=localhost';
+ $user = 'root';
+ $password = '******';
+
+ try{
+
+ $db = new PDO($dsn, $user, $password);
+ $db->query('SET NAMES utf8');
+
+ } catch (PDOException $e) {
+ print('Error:'.$e->getMessage());
+ die();
+ }
+
+?>
Added: tags/SmartUpload.20120331/main.php
===================================================================
--- tags/SmartUpload.20120331/main.php (rev 0)
+++ tags/SmartUpload.20120331/main.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,27 @@
+<?php
+/*
+ * SmartUpload/main.php
+ * @author Hiroyuki Shibata
+ * 2011/05/16
+ * Rev 1.0
+ *
+ */
+ session_start();
+?>
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+ <h1>Smart Upload</h1>
+ <?php require_once 'auth.php';?>
+ <form action="user_form.php" >
+ <input type="submit" value="ユーザ登録">
+ </form>
+ <?php
+ require_once 'download_file.php';
+ require_once 'upload_form.php';
+ ?>
+</body>
+</html>
\ No newline at end of file
Added: tags/SmartUpload.20120331/mod_user.php
===================================================================
--- tags/SmartUpload.20120331/mod_user.php (rev 0)
+++ tags/SmartUpload.20120331/mod_user.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,18 @@
+<?php
+/*
+ * SmartUpload/mod_user.php
+ * @author Hiroyuki Shibata
+ * 2011/05/5
+ * Rev 1.0
+ *
+ */
+ session_start();
+?>
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+</body>
+</html>
\ No newline at end of file
Added: tags/SmartUpload.20120331/upload_file.php
===================================================================
--- tags/SmartUpload.20120331/upload_file.php (rev 0)
+++ tags/SmartUpload.20120331/upload_file.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,108 @@
+<?php
+/*
+ * SmartUpload/upload_file.php
+ * @author Hiroyuki Shibata
+ * 2011/05/16
+ * Rev 1.0
+ *
+ */
+ session_start();
+?>
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+ <p>
+ <b>File Uploader</b>
+ </p>
+ <?php
+
+ // ファイル保存先のパス
+ $updir = "./data/";
+
+ // アップロードされたファイルの情報
+ $contentname = htmlspecialchars($_POST["contents"]);
+ $filename = htmlspecialchars($_FILES['upfile']['name']);
+ $filesize = htmlspecialchars($_FILES['upfile']['size']);
+ $category = $_POST["category"];
+ $comment = htmlspecialchars($_POST["comment"]);
+
+ if ($_FILES['upfile']['name']==null) {
+
+ print("アップロードは失敗しました。");
+ require_once("upload_form.php");
+
+ } else {
+
+ // ログインされてない場合
+ if (htmlspecialchars($_SESSION['id']=="", ENT_QUOTES)) {
+
+ require_once("include/database.php");
+
+ print("<b>$filename</b> is uploaded.<br />");
+ print("size = "."$filesize"." bytes<br />");
+
+ // データベース処理
+ $stmt = $db->prepare(
+ "INSERT INTO data_info (
+ contentname,
+ filename,
+ uploaddate,
+ data_size,
+ category,
+ comment
+ ) VALUES (?, ?, now() ,? ,? ,? )");
+
+ $stmt->bindParam(1, $contentname);
+ $stmt->bindParam(2, $filename);
+ $stmt->bindParam(3, $filesize);
+ $stmt->bindParam(4, $category);
+ $stmt->bindParam(5, $comment);
+ $stmt->execute();
+
+ print('<br>');
+
+ $pdo = null;
+
+ // ログイン済みの場合
+ } else {
+
+ require_once("include/database.php");
+
+ $username = $_SESSION["id"];
+
+ print("<b>$filename</b> is uploaded.<br />");
+ print("size = "."$filesize"." bytes<br />");
+
+ // データベース処理
+ $stmt = $db->prepare(
+ "INSERT INTO data_info (
+ contentname,
+ filename,
+ uploaddate,
+ username,
+ data_size,
+ category,
+ comment
+ ) VALUES (?, ?, now(),? ,? ,? ,? )");
+
+ $stmt->bindParam(1, $contentname);
+ $stmt->bindParam(2, $filename);
+ $stmt->bindParam(3, $username);
+ $stmt->bindParam(4, $filesize);
+ $stmt->bindParam(5, $category);
+ $stmt->bindParam(6, $comment);
+ $stmt->execute();
+
+ print('<br>');
+
+ $pdo = null;
+
+ }
+
+ }
+ ?>
+</body>
+</html>
Added: tags/SmartUpload.20120331/upload_form.php
===================================================================
--- tags/SmartUpload.20120331/upload_form.php (rev 0)
+++ tags/SmartUpload.20120331/upload_form.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,48 @@
+<?php
+/*
+ * SmartUpload/upload_form.php
+ * @author Hiroyuki Shibata
+ * 2011/05/16
+ * Rev 1.0
+ *
+ */
+ session_start();
+?>
+
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+ <h2>アップロード</h2>
+ <form method="post" enctype="multipart/form-data" action="upload_file.php">
+ <pre>
+コンテンツ名 ：<input type="text" name="contents"> ※ 全角32文字以内<br>
+カテゴリ ：<select name="category">
+<?php
+ require_once("include/database.php");
+
+ $value = 0;
+
+ $stmt = $db->prepare("SELECT * FROM category ORDER BY cat_number");
+ $stmt->execute();
+
+ while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
+?>
+ <option value="<?php print($row['cat_number']); ?>">
+ <?php print($row['cat_name']); ?>
+ </option>
+<?php
+ }
+
+ $pdo = null;
+?>
+ </select>
+コメント ：<textarea name="comment" rows=3 cols=50 wrap="virtual"></textarea> ※ 全角512文字以内<br>
+ファイル ：<input type="file" name="upfile"><br>
+<input type="submit" value="アップロード"> <input type="reset" value="リセット">
+ </pre>
+ </form>
+</body>
+</html>
Added: tags/SmartUpload.20120331/user_add.php
===================================================================
--- tags/SmartUpload.20120331/user_add.php (rev 0)
+++ tags/SmartUpload.20120331/user_add.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,233 @@
+<?php
+/*
+ * SmartUpload/user_add.php
+ * @author Hiroyuki Shibata
+ * 2011/09/25
+ * Rev 1.0
+ *
+ */
+session_start();
+?>
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+
+ <?php
+
+ // メイン処理 //
+
+ require_once("include/database.php");
+
+ try{
+
+ // 文字チェック関数
+ function check_string($value) {
+
+ if(preg_match("/[a-zA-Z0-9\.#_-]/", $value)) {
+
+ return(TRUE);
+
+ }
+ }
+
+ // 文字数チェック関数
+ function count_string($str) {
+
+ if (strlen($str) <= 32) {
+
+ return (TRUE);
+
+ }
+ }
+
+ // メイン処理 //
+ if (isset($_SESSION['id'])) {
+
+ print("すでにログインしています<br>");
+ ?>
+ <input type="button" value="戻る" onClick="history.back()">
+ <?php
+
+ } else {
+
+ $error = 0;
+
+ // id（アカウント）の未入力チェック
+ if (!(isset($_POST["id"]))) {
+
+ print('Error: ');
+ print("ID（アカウント）が入力されてません。<br>");
+
+ $error =1;
+
+ } else {
+
+ // id（アカウント）の入力文字チェック
+ if (!check_string($_POST["id"])) {
+
+ print('Error: ');
+ print("ID（アカウント）に不正な文字が含まれています。<br>");
+ print("※ ID（アカウント）には、半角英数字と、「-」ハイフン、「_」アンダースコアが利用できます。<br>");
+ print("<br>");
+
+ $error =1;
+
+ }
+
+ // id（アカウント）の文字数チェック
+ if (!count_string($_POST["id"])) {
+
+ print('Error: ');
+ print("ID（アカウント）の文字数オーバーです。<br>");
+ print("※ ID（アカウント）は、半角32文字以内です。<br>");
+ print("<br>");
+
+ $error =1;
+
+ }
+ }
+
+ // パスワードの未入力チェック
+ if (!(isset($_POST["pass"]))) {
+
+ print('Error: ');
+ print("パスワード`が入力されていません。<br>");
+
+ $error =1;
+
+ } else {
+
+ // パスワードの入力文字チェック
+ if (!check_string($_POST["pass"])) {
+
+ print('Error: ');
+ print("パスワードに不正な文字が含まれています。<br>");
+ print("※ パスワードには、半角英数字と、「-」ハイフン、「_」アンダースコアが利用できます。<br>");
+ print("<br>");
+
+ $error =1;
+
+ }
+
+ // パスワードの文字数チェック
+ if (!count_string($_POST["pass"])) {
+
+ print('Error: ');
+ print("パスワードの文字数オーバーです。<br>");
+ print("※ パスワードは、半角32文字以内です。<br>");
+ print("<br>");
+
+ $error =1;
+
+ }
+ }
+
+ // 氏名の未入力チェック
+ if (!(isset($_POST["name"]))) {
+
+ print('Error: ');
+ print("氏名が入力されていません<br>");
+
+ $error =1;
+
+ } else {
+
+ // 氏名の文字数チェック
+ if (strlen($_POST["name"]) > 64) {
+
+ print('Error: ');
+ print("氏名の文字数オーバーです。<br>");
+ print("※ 氏名は、全角32文字以内（半角64文字以内です。<br>");
+ print("<br>");
+
+ $error =1;
+
+ }
+
+ // メールアドレス入力チェック
+ if (!($_POST["mail"])) {
+
+ print('Error: ');
+ print ("メールアドレスが入力されていません。<br>");
+
+ $error =1;
+
+ } else {
+
+ // メールアドレスチェック
+ if (!preg_match("/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/", $_POST["mail"])) {
+
+ print('Error: ');
+ print ("メールアドレスに不正な文字が含まれています。<br>");
+ print("<br>");
+
+ $error =1;
+
+ }
+ }
+ }
+
+ if ($error = 1) {
+
+ require_once ("user_form.php");
+
+ } elseif ($error == 0) {
+ ?>
+ <p>
+ <b>登録完了</b>
+ </p>
+ <?php
+
+ // DBに登録 //
+ $stmt = $db->prepare(
+ "INSERT INTO user_info (
+ userid,
+ password,
+ fullname,
+ country_code,
+ add_date,
+ email,
+ frag
+ ) VALUES ( ?, ?, ?, ?, now(), ?, 0)"
+ );
+
+ $stmt->bindParam(1,$_POST["id"]);
+ $stmt->bindParam(2,$_POST["pass"]);
+ $stmt->bindParam(3,$_POST["name"]);
+ $stmt->bindParam(4,$_POST["country"]);
+ $stmt->bindParam(5,$_POST["mail"]);
+ $stmt->execute();
+
+ // 登録成功を表示 //
+ $stmt = $db->prepare('select fullname from user_info where userid = ?');
+ $stmt->execute(array($_POST["id"]));
+
+ $row = $stmt->fetch(PDO::FETCH_ASSOC);
+
+ print(htmlspecialchars($row['fullname']." "."さんのユーザ登録が完了しました。", ENT_QUOTES));
+
+ ?>
+ <form action="main.php">
+ <input type="submit" value="戻る">
+ </form>
+ <?php
+
+ }
+ }
+
+ } catch (PDOException $e) {
+
+ print('Error:'.$e->getMessage());
+ die();
+
+ }
+
+ $pdo = null;
+
+ ?>
+
+</body>
+</html>
Added: tags/SmartUpload.20120331/user_form.php
===================================================================
--- tags/SmartUpload.20120331/user_form.php (rev 0)
+++ tags/SmartUpload.20120331/user_form.php 2012-03-31 12:21:15 UTC (rev 76)
@@ -0,0 +1,101 @@
+<?php
+/*
+ * SmartUpload/user_form.php
+ * @author Hiroyuki Shibata
+ * 2011/05/28
+ * Rev 1.0
+ *
+ */
+ session_start();
+?>
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+ <?php
+
+ // ログイン済みの場合
+ if ( isset($_SESSION['id']) && $_SESSION["id"]) {
+
+ print("すでにログインしています<br>");
+ ?>
+ <input type="button" value="戻る" onClick="history.back()">
+ <?php
+
+// メイン処理 //
+ } else {
+ ?>
+ <h2>ユーザー登録</h2>
+ <form name="user_form" action="./user_add.php" method="post">
+ <pre>
+ID（アカウント） ：<input type="text" name="id" value="
+ <?php if (isset($_POST['id'])){ print ($_POST['id']); } ?>
+ "> ※ 半角英数字または「-」ハイフンと「_」アンダースコアを利用できます。（32文字以内）<br>
+パスワード ：<input type="password" name="pass"> ※ 半角英数字または「-」ハイフンと「_」アンダースコアを利用できます。（32文字以内）<br>
+氏名 ：<input type="text" name="name" value="
+ <?php if (isset($_POST['name'])){ print ($_POST['name']); } ?>
+ "> ※ 全角32文字以内（半角64文字以内）<br>
+国 ：<select name="country" >
+
+ <?php
+
+ require_once("include/database.php");
+
+ if ($_POST) {
+
+ // 選択されたリスト項目
+ $stmt = $db->prepare("SELECT * FROM country where num = ?");
+ $stmt->execute(array($_POST['country']));
+
+ $row = $stmt->fetch(PDO::FETCH_ASSOC);
+ ?>
+ <option value="<?php print($row["num"]); ?>" selected>
+ <?php print($row["country_name"]); ?>
+ </option>
+ <?php
+ // 選択されなかったリスト項目
+
+ $stmt2 = $db->prepare("SELECT * FROM country where not num = ? ORDER BY num");
+ $stmt2->execute(array($_POST['country']));
+
+ while ($row2 = $stmt2->fetch(PDO::FETCH_ASSOC)) {
+ ?>
+ <option value="<?php print($row2["num"]); ?>">
+ <?php print($row2["country_name"]); ?>
+ </option>
+ <?php
+ }
+
+ } else {
+
+ $stmt = $db->prepare("SELECT * FROM country ORDER BY num");
+ $stmt->execute();
+
+ while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
+ ?>
+ <option value="<?php print($row["num"]); ?>">
+ <?php print($row["country_name"]); ?>
+ </option>
+ <?php
+ }
+ }
+ ?>
+ </select>
+
+メールアドレス ：<input type="text" name="mail" value="
+ <?php if (isset($_POST['mail'])){ print ($_POST['mail']); } ?>
+"> ※ 半角64文字以内
+
+<input type="submit" class="update" value="登録" /> <input type="reset" value="リセット">
+ </pre>
+ </form>
+ <?php
+ }
+
+ $pdo = null;
+
+ ?>
+</body>
+</html>