Pick a device below to manage themes for that target/screen size
+{elseif $user} +Pick a device below to manage your themes for that target/screen size
{else}Have you made a theme that is not listed on this site? Please read the theme guidelines and then upload your theme.
+Or login to the User area to manage your Themes.
{/if}All themes on this website can be downloaded and Index: private/templates/userlogin.tpl =================================================================== --- private/templates/userlogin.tpl (revision 0) +++ private/templates/userlogin.tpl (revision 0) @@ -0,0 +1,49 @@ +{include file="header.tpl" title="User area"} + +
{$msg}
{/if} + + + +{$regmsg}
{/if} + + + + + +{include file="footer.tpl"} Index: private/themesite.class.php =================================================================== --- private/themesite.class.php (revision 23878) +++ private/themesite.class.php (working copy) @@ -47,16 +47,17 @@ $this->db->query($sql); } - private function targetlist($orderby) { + private function targetlist($orderby,$onlyemail = '') { $sql = sprintf(" SELECT targets.shortname AS shortname, fullname, pic, targets.mainlcd AS mainlcd, depth, targets.remotelcd AS remotelcd, COUNT(themes.name) AS numthemes FROM targets LEFT OUTER JOIN (SELECT DISTINCT themes.name AS name,checkwps.target AS target FROM themes,checkwps - WHERE themes.rowid=checkwps.themeid AND checkwps.pass=1 AND approved=1 AND emailverification=1) themes + WHERE themes.rowid=checkwps.themeid AND checkwps.pass=1 AND approved=1 AND emailverification=1 %s) themes ON targets.shortname=themes.target GROUP BY targets.shortname||targets.mainlcd ORDER BY %s ", + $onlyemail, $orderby ); return $this->db->query($sql); @@ -71,6 +72,22 @@ return $ret; } + public function listusertargets($user,$orderby = 'LOWER(fullname) ASC') { + /* we match by email, so get the emil to the user */ + $sql = sprintf("SELECT email FROM users WHERE name='%s'", + db::quote($user) + ); + $result = $this->db->query($sql)->next(); + $onlyemail = sprintf("AND email='%s'",$result['email']); + + $targets = $this->targetlist($orderby,$onlyemail); + $ret = array(); + while ($target = $targets->next()) { + $ret[] = $target; + } + return $ret; + } + /* * Run checkwps on all our themes */ @@ -133,6 +150,15 @@ $result = $this->db->query($sql)->next(); return $result['count'] == 1 ? true : false; } + + public function userlogin($user, $pass) { + $sql = sprintf("SELECT COUNT(*) as count FROM users WHERE name='%s' AND pass='%s' AND emailverification='1'", + db::quote($user), + db::quote(md5($pass)) + ); + $result = $this->db->query($sql)->next(); + return $result['count'] == 1 ? true : false; + } public function target2fullname($shortname) { $sql = sprintf("SELECT fullname FROM targets WHERE shortname='%s'", @@ -188,7 +214,7 @@ return $theme; } - public function listthemes($target = false, $orderby = 'timestamp DESC', $approved = 'approved', $onlyverified = true) { + public function listthemes($target = false, $orderby = 'timestamp DESC', $approved = 'approved', $onlyverified = true, $user = '') { $ret = array(); switch($approved) { case 'any': @@ -209,6 +235,18 @@ $verified = ""; } + if($user == '') + { + $userclause = ""; + } + else + { + $sql = sprintf("SELECT email FROM users WHERE name='%s'", + db::quote($user) ); + $result = $this->db->query($sql)->next(); + $userclause = sprintf("AND email='%s'",$result['email']); + } + if ($target === false) { $sql = "SELECT DISTINCT themes.name AS name, author, timestamp, mainlcd, approved, reason, description, shortname, zipfile, sshot_wps, sshot_menu, emailverification = 1 as verified, themes.RowId as id FROM themes,checkwps WHERE themes.rowid=checkwps.themeid AND checkwps.pass=1 AND approved=1 AND emailverification=1 ORDER BY " . $orderby; } @@ -226,13 +264,14 @@ LEFT OUTER JOIN checkwps c ON (themes.rowid=c.themeid and c.version_type='current' and c.target='%s') LEFT OUTER JOIN checkwps r ON (themes.rowid=r.themeid and r.version_type='release' and r.target='%s') - WHERE 1 %s %s AND (current_pass=1 OR release_pass=1) + WHERE 1 %s %s %s AND (current_pass=1 OR release_pass=1) ORDER BY %s ", db::quote($target), db::quote($target), $verified, $approved_clause, + $userclause, $orderby ); } @@ -264,7 +303,61 @@ $result = $this->db->query($sql)->next(); return $result['count'] > 0 ? true : false; } + + public function usernameexists($name) { + $sql = sprintf("SELECT COUNT(*) as count FROM users WHERE name='%s'", + db::quote($name) + ); + $result = $this->db->query($sql)->next(); + return $result['count'] > 0 ? true : false; + } + public function useremailexists($name) { + $sql = sprintf("SELECT COUNT(*) as count FROM users WHERE email='%s'", + db::quote($name) + ); + $result = $this->db->query($sql)->next(); + return $result['count'] > 0 ? true : false; + } + + public function registeruser($name,$pass,$email) { + $token = md5(uniqid()); + $sql_f = "INSERT INTO users (name, pass, email, emailverification) VALUES ('%s', '%s', '%s', '%s')"; + $sql = sprintf($sql_f, + db::quote($name), + db::quote(md5($pass)), + db::quote($email), + $token + ); + $result = $this->db->query($sql); + $id = $result->insertid(); + $this->log(sprintf("Added user %d (email: %s)", $id, $email)); + + /* send email */ + $url = sprintf("%s%s/verify.php?t=%s", config::hostname, config::path, $token); + /* xxx: Someone rewrite this message to not sound horrible */ + $msg = <<Please click on the link in it to confirm your account.'); + } + else { + $t->assign('regmsg', 'Register failed. Please try again'); + } + } + else + { + $t->assign('regmsg', $err); + } +} + +/* If not logged in, show the login form */ +if (!isset($_SESSION['user'])) { + $template = 'userlogin.tpl'; +} +else { + /* figure out what todo */ + /* show theme list */ + if (isset($_REQUEST['target'])) { + if (isset($_REQUEST['changestatuses'])) { + changestatuses($site); + } + $approved = isset($_REQUEST['approved']) ? $_REQUEST['approved'] : 'any'; + $template = 'adminlist.tpl'; + $themes = $site->listthemes($_REQUEST['target'], 'timestamp DESC',$approved, $onlyverified = false,$_SESSION['user']); + $t->assign('themes', $themes); + $t->assign('approved', $approved); + $t->assign('user', true); + $t->assign('target', $site->target2fullname($_REQUEST['target'])); + } + /* Show a theme's details, possibly updating it as result of an admin + * submitting changes */ + elseif (isset($_REQUEST['edittheme'])) { + /* Update the theme TODO: check if it is really them which belongs to this user */ + if (isset($_REQUEST['themename'])) { + $site->updatetheme( + $_REQUEST['edittheme'], + $_REQUEST['themename'], + $_REQUEST['mainlcd'], + $_REQUEST['author'], + $_REQUEST['email'], + $_REQUEST['description'] + ); + } + $theme = $site->themedetails($_REQUEST['edittheme']); + $targets = array(); + foreach($site->listtargets() as $target) { + $targets[$target['shortname']] = $target['fullname']; + } + $t->assign('targets', $targets); + $t->assign('theme', $theme); + $t->assign('user', true); + $template = 'edittheme.tpl'; + } + /* Or just show the front page */ + if (!isset($template)) { + $t->assign('title', 'User'); + $t->assign('targets', $site->listusertargets($_SESSION['user'])); + $t->assign('user', true); + $template = 'frontpage.tpl'; + } +} + +$t->render($template); +?>