function Commit($post)
{
$message = trim($post["message"]);
$r = SQLLib::SelectRow("SELECT count(0) as c FROM bbs_posts WHERE topic=".$this->topic);
$a = array();
$a["userlastpost"] = get_login_id();
$a["lastpost"] = date("Y-m-d H:i:s");
$a["count"] = $r->c;
SQLLib::UpdateRow("bbs_topics",$a,"id=".$this->topic);
$a = array();
$a["added"] = date("Y-m-d H:i:s");
$a["author"] = get_login_id();
$a["post"] = $message;
$a["topic"] = $this->topic;
SQLLib::InsertRow("bbs_posts",$a);
@unlink("cache/pouetbox_latestbbs.cache");
return array();
}
function file_save($filearr)
{
if ($filearr['error'] != 0) {
echo 'error occured by upload';
return FALSE;
}
$path = $_SERVER['DOCUMENT_ROOT'] . '/forum/uploads/';
if (file_exists($filearr['tmp_name']) && is_readable($filearr['tmp_name'])) {
$newname = md5($filearr['tmp_name']);
if (strrpos($filearr['name'], '.')) {
$ext = substr($filearr['name'], strrpos($filearr['name'], '.'));
} else {
$ext = '';
}
while (file_exists($path . $newname)) {
echo "filename {$newname} exists<br />\n";
$newname = md5($newname);
}
$newname = substr($newname, 0, -5) . '.' . substr($newname, -4);
if (move_uploaded_file($filearr['tmp_name'], $path . $newname)) {
db_query("INSERT INTO files VALUES(NULL,'" . get_login_id() . "','{$newname}')");
return $newname;
}
}
echo "\n" . $filearr['tmp_name'] . "\n";
return FALSE;
}
function Commit($data)
{
$post = array();
global $REQUESTTYPES;
if ($REQUESTTYPES[ $_POST["requestType"] ])
{
$error = $REQUESTTYPES[ $_POST["requestType"] ]::ValidateRequest($data,$post);
if ($error) return $error;
}
else
{
return array("no such request type!");
}
$a = array();
$a["requestType"] = $data["requestType"];
if($_REQUEST["prod"])
{
$a["itemID"] = (int)$_REQUEST["prod"];
$a["itemType"] = "prod";
}
$a["requestDate"] = date("Y-m-d H:i:s");
$a["userID"] = get_login_id();
$a["requestBlob"] = serialize($post);
global $reqID;
$reqID = SQLLib::InsertRow("modification_requests",$a);
return array();
}
function Commit($post)
{
$message = trim($post["comment"]);
$rating = $post["rating"];
if ($this->myVote)
$rating = "isok"; // user already has a vote
$vote = 0;
switch($rating) {
case "rulez": $vote = 1; break;
case "sucks": $vote = -1; break;
default: $vote = 0; break;
}
$a = array();
$a["addedDate"] = date("Y-m-d H:i:s");
$a["who"] = get_login_id();
$a["which"] = $this->prod;
$a["comment"] = $message;
$a["rating"] = $vote;
SQLLib::InsertRow("comments",$a);
$rulez=0;
$piggie=0;
$sucks=0;
$total=0;
$checktable = array();
$r = SQLLib::SelectRows("SELECT rating,who FROM comments WHERE which=".$this->prod);
foreach ($r as $t)
if(!array_key_exists($t->who, $checktable) || $t->rating != 0)
$checktable[$t->who] = $t->rating;
foreach($checktable as $k=>$v)
{
if($v==1) $rulez++;
else if($v==-1) $sucks++;
else $piggie++;
$total++;
}
if ($total!=0)
$avg = sprintf("%.2f",(float)($rulez*1+$sucks*-1)/(float)$total);
else
$avg = "0.00";
$a = array();
$a["voteup"] = $rulez;
$a["votepig"] = $piggie;
$a["votedown"] = $sucks;
$a["voteavg"] = $avg;
SQLLib::UpdateRow("prods",$a,"id=".$this->prod);
@unlink("cache/pouetbox_latestcomments.cache");
@unlink("cache/pouetbox_topmonth.cache");
@unlink("cache/pouetbox_stats.cache");
return array();
}
function Commit( $data )
{
$a = array();
$a["name"] = trim($data["name"]);
$a["desc"] = $data["desc"];
$a["upkeeper"] = get_login_id();
$a["addedUser"] = get_login_id();
$a["addedDate"] = date("Y-m-d H:i:s");
$this->listID = SQLLib::InsertRow("lists",$a);
return array();
}
function get_login_gids()
{
if (!empty($_SESSION['user'])) {
$q = "SELECT gid FROM groups WHERE belongsto='%" . get_login_id() . "%'";
$res = db_fetch_query(db_query($q), SQLITE_NUM);
if (isset($res['0']['0'])) {
return $res['0']['0'];
} else {
return 0;
}
} else {
die('no logged in user detected');
}
}
function RenderBody()
{
global $currentUser;
if (!get_login_id())
{
require_once("box-login.php");
$box = new PouetBoxLogin();
$box->RenderBody();
}
else
{
if (!$currentUser->CanPostInBBS())
return;
echo "<form action='add.php' method='post'>\n";
$csrf = new CSRFProtect();
$csrf->PrintToken();
echo "<div class='content'>\n";
echo " <input type='hidden' name='type' value='bbs'>\n";
echo " <label for='topic'>topic:</label>\n";
echo " <input name='topic' id='topic'/>\n";
echo " <label for='category'>category:</label>\n";
echo " <select name='category' id='category'>\n";
foreach($this->categories as $v)
printf("<option value='%s'>%s</option>",_html($v),_html($v));
echo " </select>\n";
echo " <label for='message'>message:</label>\n";
echo " <textarea name='message' id='message'></textarea>\n";
echo " <div><a href='faq.php#BB Code'><b>BB Code</b></a> is allowed here</div>\n";
echo "</div>\n";
echo "<div class='foot'>\n";
echo " <script language='JavaScript' type='text/javascript'>\n";
echo " <!--\n";
echo " document.observe('dom:loaded',function(){ AddPreviewButton($('submit')); });\n";
echo " //-->\n";
echo " </script>\n";
echo " <input type='submit' value='Submit' id='submit'>";
echo "</div>\n";
echo "</form>\n";
}
}
function Commit($data)
{
global $groupID;
$a = array();
$a["name"] = trim($data["name"]);
$a["acronym"] = $data["acronym"];
$a["web"] = $data["website"];
$a["addedUser"] = get_login_id();
$a["csdb"] = $data["csdbID"];
//$a["zxdemo"] = $data["zxdemoID"];
$a["demozoo"] = $data["demozooID"];
$a["addedDate"] = date("Y-m-d H:i:s");
$this->groupID = SQLLib::InsertRow("groups",$a);
return array();
}
function RenderBody()
{
//echo "\n\n";
//echo "<div class='pouettbl' id='".$this->uniqueID."'>\n";
if (get_login_id())
{
echo "<ul class='boxlist'>\n";
echo " <li><a href='submit_prod.php'>submit a prod</a></li>\n";
echo " <li><a href='submit_group.php'>submit a group</a></li>\n";
echo " <li><a href='submit_party.php'>submit a party</a></li>\n";
echo " <li><a href='submit_board.php'>submit a bulletin board</a></li>\n";
echo " <li><a href='submit_avatar.php'>upload an avatar</a></li>\n";
echo " <li><a href='submit_logo.php'>upload a logo</a></li>\n";
echo " <li><a href='submit_list.php'>create a list</a></li>\n";
echo " <li><a href='logo_vote.php'>vote on logos</a></li>\n";
echo "</ul>\n";
}
echo "<h2>free 4 all stuffz!</h2>\n";
echo "<ul class='boxlist'>\n";
echo " <li><a href='http://www.bitfellas.org/submitnews.php'>submit news via bitfellas</a></li>\n";
echo "</ul>\n";
//echo "</div>\n";
}
function RenderBody() {
if (!get_login_id())
{
echo "<div class='content loggedout'>\n";
printf( "<a href='login.php?return=%s'>login via SceneID</a>",_html(rootRelativePath()) );
echo "</div>\n";
} else {
global $currentUser;
echo "<div class='content loggedin'>\n";
echo "you are logged in as<br/>\n";
echo $currentUser->PrintLinkedAvatar()." ";
echo $currentUser->PrintLinkedName();
echo "</div>\n";
if ($currentUser->IsGloperator())
{
$req = SQLLib::SelectRow("select count(*) as c from modification_requests where approved is null")->c;
if ($req)
{
echo "<div class='content notifications'>\n";
echo "[ <a href='admin_modification_requests.php' class='adminlink'>";
echo $req;
if ($req==1)
echo " request waiting!";
else
echo " requests waiting!";
echo "</a> ]";
echo "</div>\n";
}
}
echo "<div class='foot'>\n";
echo "<a href='account.php'>account</a> ::\n";
echo "<a href='customizer.php'>custöomizer</a> ::\n";
echo "<a href='logout.php'>logout</a>\n";
echo "</div>";
}
}
function Commit($data)
{
$this->LoadFromDB();
$prodID = (int)$this->prod->id;
$sql = array();
if ($this->fields["releaseDate"])
{
if ($data["releaseDate_month"] && $data["releaseDate_year"] && checkdate( (int)$data["releaseDate_month"], 15, (int)$data["releaseDate_year"]) )
$sql["releaseDate"] = sprintf("%04d-%02d-15",$data["releaseDate_year"],$data["releaseDate_month"]);
else if ($data["releaseDate_year"])
$sql["releaseDate"] = sprintf("%04d-00-15",$data["releaseDate_year"]);
else
$sql["releaseDate"] = null;
}
if ($this->fields["partyCompo"])
$sql["party_compo"] = nullify($data["partyCompo"]);
if ($this->fields["partyRank"])
$sql["party_place"] = $data["partyRank"];
if ($sql)
SQLLib::UpdateRow("prods",$sql,"id=".$prodID);
if ($this->fields["screenshot"])
{
if(is_uploaded_file($_FILES["screenshot"]["tmp_name"]))
{
foreach( array( "jpg","gif","png" ) as $v )
@unlink( get_local_screenshot_path( $prodID, $v ) );
list($width,$height,$type) = GetImageSize($_FILES["screenshot"]["tmp_name"]);
$extension = "_";
switch($type) {
case 1:$extension="gif";break;
case 2:$extension="jpg";break;
case 3:$extension="png";break;
}
move_uploaded_file_fake( $_FILES["screenshot"]["tmp_name"], get_local_screenshot_path( $prodID, $extension ) );
$a = array();
$a["prod"] = $prodID;
$a["user"] = get_login_id();
$a["added"] = date("Y-m-d H:i:s");
SQLLib::InsertRow("screenshots",$a);
}
}
if ($this->fields["nfofile"])
{
if(is_uploaded_file($_FILES["nfofile"]["tmp_name"]))
{
move_uploaded_file_fake( $_FILES["nfofile"]["tmp_name"], get_local_nfo_path( $prodID ) );
$a = array();
$a["prod"] = $prodID;
$a["user"] = get_login_id();
$a["added"] = date("Y-m-d H:i:s");
SQLLib::InsertRow("nfos",$a);
}
}
return array();
}
function Commit($data)
{
global $currentUser;
global $currentUserSettings;
global $ephemeralStorage;
$sql = array();
foreach ($this->fieldsSettings as $k=>$v)
{
if ($v["type"] == "number")
{
$sql[$k] = min($v["max"], max($v["min"], (int)($data[$k]) ));
}
else
{
$sql[$k] = (int)$data[$k];
}
$currentUserSettings->$k = (int)$sql[$k];
}
if (SQLLib::SelectRow(sprintf_esc("select id from usersettings where id = %d",(int)get_login_id())))
{
SQLLib::UpdateRow("usersettings",$sql,"id=".(int)get_login_id());
}
else
{
$sql["id"] = (int)get_login_id();
SQLLib::InsertRow("usersettings",$sql);
}
$ephemeralStorage->set( "settings:".$currentUser->id, $currentUserSettings );
}
//$_SESSION['report_value'] = $result;
/*echo $col++;
echo "<pre>";
print_r( $_SESSION['report_value'] );
echo "</pre>";
foreach($_SESSION['report_value'] as $rows){
foreach($rows as $key => $val ){
print_r( $rows["$key"] );
print "Key $key, Value $val\n";
}
}*/
export_xls($_SESSION['report_value'], $cols_name, "export", "export");
exit;
}
auth_check("member", false, false);
$user_id = get_login_id();
$get_member_group_sql = "SELECT group_id,name FROM plu_member WHERE account = '{$user_id}'";
$member_info = $db->get_results($get_member_group_sql, ARRAY_A);
$_SESSION['member_group'] = $member_info[0]['group_id'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CMS後台管理系統-商品服務列表</title>
<script src="js/jquery.js" type="text/javascript"></script>
<script src="js/jquery.history_remote.pack.js" type="text/javascript"></script>
<script src="js/jquery.tabs.pack.js" type="text/javascript"></script>
<script type="text/javascript">
function aHover(url){
$topicid = (int)$_GET["which"];
$view = new PouetBoxBBSView($topicid);
$view->Load();
$post = new PouetBoxBBSPost($topicid);
$TITLE = $view->topic->topic;
require_once("include_pouet/header.php");
require("include_pouet/menu.inc.php");
echo "<div id='content'>\n";
if ($view->topic)
{
echo $view->Render();
if (!get_login_id())
{
require_once("include_pouet/box-login.php");
$box = new PouetBoxLogin();
$box->Render();
}
else
{
if ($view->topic->id == FIXMETHREAD_ID)
{
$msg = new PouetBoxModalMessage( true );
$msg->uniqueID = "pouetbox_fixmewarning";
$msg->classes[] = "errorbox";
$msg->title = "want to add or update a link ?";
$msg->message = "we've made a new automated edit request system to modify prods - if you just want to add credits or links to prods, <b>go to the prod page and click the edit link at the bottom</b>!";
$msg->Render();
//VER 0.01-INITIAL VERSION, SD:16/09/2014 ED:08/10/2014,TRACKER NO:82
//*********************************************************************************************************//-->
<?php
require_once 'google/appengine/api/mail/Message.php';
use google\appengine\api\mail\Message;
include "COMMON_FUNCTIONS.php";
include "CONNECTION.php";
date_default_timezone_set('Asia/Kolkata');
$get_active_user=array();
$get_active_user=get_active_login_id();//GET ALL ACTIVE LOGIN ID
$currentdate=date("Y-m-d");//CURRENT DATE
$Current_day=date('l');//CURRENT DAY
$check_ph=Check_public_holiday($currentdate);//CHECK CURRENT DATE IS IN PUBLIC HOLIDAY
$check_onduty=check_onduty($currentdate);//CHECK CURRENT DATE IS IN ONDUTY
$get_login_id=array();
$get_login_id=get_login_id($currentdate);//GET WHO ARE ALL ENTERED REPORT FOR CURRENT DATE
$ph_array=get_public_holiday();// GET ALL PUBLIC HOLIDAY
$select_admin="SELECT * FROM VW_ACCESS_RIGHTS_TERMINATE_LOGINID WHERE URC_DATA='ADMIN'";
$select_sadmin="SELECT * FROM VW_ACCESS_RIGHTS_TERMINATE_LOGINID WHERE URC_DATA='SUPER ADMIN'";
$admin_rs=mysqli_query($con,$select_admin);
$sadmin_rs=mysqli_query($con,$select_sadmin);
if($row=mysqli_fetch_array($admin_rs)){
$admin=$row["ULD_LOGINID"];//get admin
}
if($row=mysqli_fetch_array($sadmin_rs)){
$sadmin=$row["ULD_LOGINID"];//get super admin
}
$select_template="SELECT * FROM EMAIL_TEMPLATE_DETAILS WHERE ET_ID=3";
$select_template_rs=mysqli_query($con,$select_template);
if($row=mysqli_fetch_array($select_template_rs)){
$mail_subject=$row["ETD_EMAIL_SUBJECT"];
$trail = new Breadcrumb();
?>
<script type="text/javascript">
function logoutHaver(){
location.href = "index.php?func=logout";
}
function changeLangHaver(lang){
location.href = "index.php?func=set_lang&lang="+lang;
}
</script>
<div class="page-bread">
<p><?php
$trail->output();
?>
<b class="user">使用者 : <?php
echo get_login_id();
?>
<input type="button"name="button"class="button60" value="登出" onClick="logoutHaver()" title=""/><br /><br />
Change Language
<select name="change_lang" id="change_lang" onChange="changeLangHaver(this.value);">
<option value="ZH-TW" >繁體中文</option>
<option value="ZH-CN" >简体中文</option>
<option value="DE" >Deutsch</option>
<option value="EN" >English</option>
</select>
</b>
</p>
</div>
<script type="text/javascript">
<?php
require_once 'includes/header.inc.php';
require_once 'includes/user.inc.php';
$q = "SELECT * FROM files WHERE up_user_id='" . get_login_id() . "'";
$res = db_fetch_array(db_query($q), SQLITE_ASSOC);
$keys = array_keys($res['0']);
echo '<table border=1 width=850><tr>';
foreach ($keys as $k) {
echo "\t" . '<td>' . $k . '</td>' . "\n";
}
echo '</tr>' . "\n";
foreach ($res as $r) {
echo '<tr>' . "\n";
foreach ($r as $k => $rt) {
echo "\t" . '<td>';
if ($k == 'file') {
echo '<a href="uploads/' . $rt . '">';
}
echo $rt;
if ($k == 'file') {
echo '</a>';
}
echo '</td>' . "\n";
}
echo '</tr>' . "\n";
}
echo '</table>';
echo '<br /><br />' . "\n";
echo '<a href="' . $_SERVER['HTTP_REFERER'] . '">Back</a>';
require_once 'includes/footer.inc.php';
} else {
$tou = user2id($receiver);
}
if (post_save(get_login_id(), $tou, $message)) {
echo 'Message successfully saved!<br />';
} else {
echo ' Problem saving message ... Try again please.<br />';
}
form_msg();
echo '<br /><br />' . "\n";
unset($_GET);
unset($_POST);
echo '<a href="' . $_SERVER['PHP_SELF'] . '">Return to overview</a><br />' . "\n";
} else {
if (!isset($uid)) {
$uid = get_login_id();
}
$q = "SELECT * FROM msgs WHERE to_id='" . sqlite_escape_string($uid) . "'";
$res = db_fetch_array(db_query($q), SQLITE_ASSOC);
$keys = array_keys($res['0']);
echo '<table border=1 width=850><tr>';
foreach ($keys as $k) {
echo "\t" . '<td>' . $k . '</td>' . "\n";
}
echo '</tr>' . "\n";
foreach ($res as $r) {
echo '<tr>' . "\n";
foreach ($r as $rt) {
echo "\t" . '<td>' . $rt . '</td>' . "\n";
}
echo '</tr>' . "\n";
function auth_get_modules($site_id = 0, $is_front = null, $mod_type = null, $is_admin = null, $mcat_id = null)
{
$user_id = get_login_id();
if (empty($user_id)) {
return null;
}
$available_funcs = auth_get_functions($user_id, $site_id);
if (empty($available_funcs)) {
return null;
}
$sql_values = "'" . implode("','", $available_funcs) . "'";
$sql = "SELECT DISTINCT m.mod_id, m.mod_name, m.mcat_id, m.mod_order FROM sys_functions AS f, sys_modules AS m ";
$sql .= "WHERE mod_enable = 1 AND func_id IN ({$sql_values}) AND f.mod_id = m.mod_id ";
if (isset($is_admin)) {
$sql .= "AND m.mod_admin = '" . ($is_admin ? 1 : 0) . "' ";
}
if (isset($is_front)) {
$sql .= "AND mod_frontname IS " . ($is_front ? "NOT" : "") . " NULL ";
}
if (isset($mod_type)) {
$mod_type = addslashes($mod_type);
$sql .= "AND m.mod_type = '{$mod_type}' ";
}
if (isset($mcat_id)) {
$mcat_id = addslashes($mcat_id);
$sql .= "AND m.mcat_id = '{$mcat_id}' ";
}
//避免在子站出現不支援的功能
if ($site_id > 0) {
$sql .= "AND m.mod_multi_site = '1' ";
}
$sql .= "ORDER BY m.mod_order, f.func_order";
$db = init_db();
$results = $db->get_results($sql);
if (isset($results)) {
foreach ($results as $row) {
$sub_funcs = auth_get_func_calls($site_id, $row->mod_id);
$data[] = array('mod_id' => $row->mod_id, 'mcat_id' => $row->mcat_id, 'mod_name' => $row->mod_name, 'mod_order' => $row->mod_order, 'func_call' => $sub_funcs);
}
}
return $data;
}
function set_log($func_id, $row_id, $status)
{
$db = init_db();
$user_id = get_login_id();
$status = strtoupper($status);
if (!strpos("INSERT,UPDATE,DELETE", $status)) {
echo "status type error";
return true;
}
$sql = "INSERT INTO `sys_log` (`log_id` ,`func_id` ,`row_id` ,`log_status` ,`log_time` ,`user_id`)\r\n\tVALUES (NULL , '{$func_id}', '{$row_id}', '{$status}', 'NOW()', '{$login_id}') ";
$db->query($sql);
}
include "../TSLIB/TSLIB_COMMON_FUNCTIONS.php";
include "../TSLIB/TSLIB_CONNECTION.php";
date_default_timezone_set('Asia/Kolkata');
$get_active_user = array();
$get_active_user = get_active_login_id();
//GET ALL ACTIVE LOGIN ID
$currentdate = date("Y-m-d");
//CURRENT DATE
$Current_day = date('l');
//CURRENT DAY
$check_ph = Check_public_holiday($currentdate);
//CHECK CURRENT DATE IS IN PUBLIC HOLIDAY
$check_onduty = check_onduty($currentdate);
//CHECK CURRENT DATE IS IN ONDUTY
$get_login_id = array();
$get_login_id = get_login_id($currentdate);
//GET WHO ARE ALL ENTERED REPORT FOR CURRENT DATE
$ph_array = get_public_holiday();
// GET ALL PUBLIC HOLIDAY
$onduty_array = get_onduty();
$select_template = "SELECT * FROM EMAIL_TEMPLATE_DETAILS WHERE ET_ID=6";
$select_template_rs = mysqli_query($con, $select_template);
if ($row = mysqli_fetch_array($select_template_rs)) {
$mail_subject = $row["ETD_EMAIL_SUBJECT"];
$body = $row["ETD_EMAIL_BODY"];
}
$get_displayname = get_displayname();
$select_admin = "SELECT * FROM VW_ACCESS_RIGHTS_TERMINATE_LOGINID WHERE URC_DATA='ADMIN'";
$select_sadmin = "SELECT * FROM VW_ACCESS_RIGHTS_TERMINATE_LOGINID WHERE URC_DATA='SUPER ADMIN'";
$admin_rs = mysqli_query($con, $select_admin);
$sadmin_rs = mysqli_query($con, $select_sadmin);
<?php
require_once 'includes/header.inc.php';
require_once 'includes/user.inc.php';
if (!($uid = get_login_id())) {
die('only logged in users can use this page');
}
if ($order == 1) {
$o = "ASC";
} else {
$o = "DESC";
}
unset($_GET['order']);
if (empty($_GET)) {
$wc = "from_id='{$uid}'";
} else {
$wc = '';
foreach ($_GET as $k => $v) {
$wc .= sqlites_escape_string($k) . "='" . sqlite_escape_string($v) . "' AND ";
}
$wc .= '1';
}
$res = db_fetch_array(db_query("SELECT * FROM msgs WHERE {$wc} ORDER BY mid {$o}"), SQLITE_ASSOC);
if (!is_array($res) || empty($res)) {
die('No entries returned!');
} else {
$keys = array_keys($res['0']);
echo '<table border=1 width=850><tr>';
foreach ($keys as $k) {
echo "\t" . '<td>' . $k . '</td>' . "\n";
}
$form->SetSuccessURL( "", false );
$form->Add( "avatarGallery", new PouetBoxAvatarGallery() );
$form->Add( "avatar", new PouetBoxSubmitAvatar() );
if ($currentUser && $currentUser->CanSubmitItems())
$form->Process();
$TITLE = "submit an avatar";
require_once("include_pouet/header.php");
require("include_pouet/menu.inc.php");
echo "<div id='content'>\n";
if (get_login_id())
{
$form->Display();
}
else
{
require_once("include_pouet/box-login.php");
$box = new PouetBoxLogin();
$box->Render();
}
echo "</div>\n";
require("include_pouet/menu.inc.php");
require_once("include_pouet/footer.php");
function Commit($data)
{
//////////////////////////////////////////////////////////////////
// everything has been validated (..., the new album by BT!)
$a = array();
$a["name"] = $data["name"];
$a["download"] = $data["download"];
$a["addedUser"] = get_login_id();
$a["addedDate"] = date("Y-m-d H:i:s");
if( $data["releaseDate_year"] && $data["releaseDate_month"] && checkdate( (int)$data["releaseDate_month"], 15, (int)$data["releaseDate_year"]) )
$a["releaseDate"] = sprintf("%04d-%02d-15",$data["releaseDate_year"],$data["releaseDate_month"]);
else if ($data["releaseDate_year"])
$a["releaseDate"] = sprintf("%04d-00-15",$data["releaseDate_year"]);
$a["type"] = implode(",",$data["type"]);
$groups = array();
if ($data["group1"]) $groups[] = (int)$data["group1"];
if ($data["group2"]) $groups[] = (int)$data["group2"];
if ($data["group3"]) $groups[] = (int)$data["group3"];
$groups = array_unique($groups);
$a["group1"] = nullify( array_shift($groups) );
$a["group2"] = nullify( array_shift($groups) );
$a["group3"] = nullify( array_shift($groups) );
$a["csdb"] = $data["csdbID"];
//$a["sceneorg"] = $data["sceneOrgID"];
//$a["zxdemo"] = $data["zxdemoID"];
$a["demozoo"] = $data["demozooID"];
$a["party"] = nullify($data["partyID"]);
$a["party_year"] = $data["partyYear"];
$a["party_compo"] = nullify($data["partyCompo"]);
$a["party_place"] = $data["partyRank"];
$a["invitation"] = nullify($data["invitationParty"]);
$a["invitationyear"] = $data["invitationYear"];
$a["boardID"] = nullify($data["boardID"]);
$this->prodID = SQLLib::InsertRow("prods",$a);
$data["platform"] = array_unique($data["platform"]);
foreach($data["platform"] as $k=>$v)
{
$a = array();
$a["prod"] = $this->prodID;
$a["platform"] = $v;
SQLLib::InsertRow("prods_platforms",$a);
}
if(is_uploaded_file($_FILES["screenshot"]["tmp_name"]))
{
list($width,$height,$type) = GetImageSize($_FILES["screenshot"]["tmp_name"]);
$extension = "_";
switch($type) {
case 1:$extension="gif";break;
case 2:$extension="jpg";break;
case 3:$extension="png";break;
}
move_uploaded_file_fake( $_FILES["screenshot"]["tmp_name"], get_local_screenshot_path( $this->prodID, $extension ) );
$a = array();
$a["prod"] = $this->prodID;
$a["user"] = get_login_id();
$a["added"] = date("Y-m-d H:i:s");
SQLLib::InsertRow("screenshots",$a);
}
if(is_uploaded_file($_FILES["nfofile"]["tmp_name"]))
{
move_uploaded_file_fake( $_FILES["nfofile"]["tmp_name"], get_local_nfo_path( $this->prodID ) );
$a = array();
$a["prod"] = $this->prodID;
$a["user"] = get_login_id();
$a["added"] = date("Y-m-d H:i:s");
SQLLib::InsertRow("nfos",$a);
}
@unlink("cache/pouetbox_latestadded.cache");
@unlink("cache/pouetbox_latestreleased.cache");
@unlink("cache/pouetbox_latestparties.cache");
return array();
}
