Difference between revisions of "ISFDB talk:Community Portal"

From ISFDB
Jump to navigation Jump to search
(→‎New WorldCat Tool: Titles versus RELEVANT titles)
(→‎Polish Mummy: new section)
 
(45 intermediate revisions by 17 users not shown)
Line 1: Line 1:
 +
This page is for discussing how the [[ISFDB:Community Portal]] page should be organized, or what should go on it. Actual subjects of general community discussion go on the project page itself.
 +
 
To leave a comment or question click the "+" that's the right of "edit" above. You will be prompted to enter a subject and your message. Please sign the end of your message with four tildes, <nowiki>~~~~</nowiki>, which will generate a name/date signature.
 
To leave a comment or question click the "+" that's the right of "edit" above. You will be prompted to enter a subject and your message. Please sign the end of your message with four tildes, <nowiki>~~~~</nowiki>, which will generate a name/date signature.
  
Line 5: Line 7:
 
__FORCETOC__
 
__FORCETOC__
  
−
== Wikiadmins and password changes ==
+
== archiving ==
−
 
 
−
Two of the robots are hitting pages that should not be protected
 
−
* [[User:WlxF1x]] is hitting [[User talk:Jprucher]] who is both active on ISFDB and not a moderator.
 
−
* [[User:MyiG1s]] is hitting [[ISFDB talk:Community Portal]] (this page) which should be writable by everyone.
 
−
Does anyone know how to change someone else's wiki-password? {{Marc Kupper}} 18:42, 19 Mar 2008 (CDT)
 
−
:From times when corrupted accounts showed up at wikipedia, that probably requires direct access to the wiki db. I know an ordinary admin can't do it. -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 06:02, 20 Mar 2008 (CDT)
 
−
:Once we have a newer version of media-wiki, we should be able to block the robot accounts, and perhaps semi-protect such pages if need be. (semi-protection prevents an account from editing a page unlesss that account has exsited for a certian minimum period (4 days by default) and has made a minimum number of edits (I think 25 or 50 by default). Both numbers can be configured. -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 08:57, 20 Mar 2008 (CDT)
 
−
::According to http://www.mediawiki.org/wiki/Manual:FAQ#How_do_I_reset_a_password.3F there is a script to do this. From what Al has said in the past about such scripts, he can't run them on the TAMU server, but he may be able to extract from the script the SQL code needed to do the same thing directly. -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 10:40, 20 Mar 2008 (CDT)
 
−
::The mediawiki site also says:
 
−
:::You can also use the old way, by modifying the database directly. Assuming that <var>$wgPasswordSalt</var> is set to true (the default), you can use the following SQL query for '''MySQL''':
 
−
 
 
−
<code>
 
−
UPDATE user SET user_password = MD5(CONCAT(user_id, '-',
 
−
  MD5('somepass'))) WHERE user_name = 'someuser';
 
−
</code>
 
−
:::Where obviously "somepass" is changed to the password you want to set and "someuser" is changed to the user name as it is listed in the table "user".
 
−
 
 
−
:::'''Note''': The <tt>user_id</tt> in the CONCAT string is a column name and is not meant to be replaced with 'someuser'
 
−
 
 
−
:::'''Note''': If you obtain a 'dbname.user table does not exist' error, please check the LocalSettings.php file, and double-check the value for the $wgDBprefix variable. If that variable is not empty, try repeating the command, replacing  <tt>$wgDBPrefix_user</tt> instead of <tt>user</tt> in the <tt>UPDATE</tt> clause of the SQL statement.
 
−
 
 
−
:::If using '''PostGreSQL''', use this query instead:
 
−
<code>
 
−
  UPDATE mwuser SET user_password =
 
−
    md5(user_id || '-' || md5('somepass')) WHERE user_name='someuser';
 
−
</code>
 
−
 
 
−
:::You can also try the '''Extension:Password Reset'''
 
−
 
 
−
::I hope this is helpful. -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 10:51, 20 Mar 2008 (CDT)
 
−
 
 
−
== Reviews linking to shortfiction ==
 
−
 
 
−
Amongst all the verbiage I did not find a mention of this - in at least one case I found reviews linked to a shortfiction piece rather than a novel of the same name by the same author.--[[User:Swfritter|swfritter]] 22:17, 2 June 2008 (UTC)
 
−
:I have been entering reviews (for example those in {{P|THSSTHNDST1974|name=''The Issue at Hand''}} that are explicitly of shortfiction works, and linking them appropriately. i don't see any problem with this. Of course, in soem cases, mistakes will happen. -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 23:20, 2 June 2008 (UTC)
 
−
::Just something to keep an eye on and perhaps projectize. And there are probably cases where there are reviews of both a short story and a novel with the same title. It also means it's a good idea to check any new reviews we put in.--[[User:Swfritter|swfritter]] 00:17, 3 June 2008 (UTC)
 
−
 
 
−
== getpub.cgi shows less info than expected. ==
 
−
 
 
−
I've developed a simple book getter using the API but noticed that the getpub.cgi proc returns less data in the query than the example for submission shows.
 
−
 
 
−
Notably, the image link is left out (and there may be others that I am not aware of).
 
−
 
 
−
Will the image link be returned in the API eventually? I realise the links are quite often old or misleading but they would be useful.
 
−
 
 
−
Thanks, Gary.
 
−
 
 
−
P.s. I tested the getpub.cgi using the isbn from the submission example (which did have an image link) and getpub returned no image link. {{Unsigned|Fangles|01:56, 31 May 2008}}
 
−
 
 
−
:Image and tag info are now returned. [[User:Alvonruff|Alvonruff]] 11:52, 31 May 2008 (UTC)
 
  
−
:Thank you, this is much appreciated!  {{Unsigned|Fangles|04:56, 1 June 2008}}
+
I ageree that the CP needed to be archived, but I think that threads that had discussion within, say, the last week might reasoanbly have been allowed to reamain un archived. -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 00:56, 23 July 2008 (UTC)
  
−
== New WorldCat Tool ==
+
: I used to look at and think about every thread when archiving but that time figured I'd just whack out everything that was not actively under discussion. One week seems reasonable though.  I thought there was a auto-archive thing that can do this? I'd like to unleash it on CP plus all of the main discussion areas listed at the top of CP. Note, I no longer have time to patrol the recent-changes meaning I only notice and end up replying to things like this by chance. <span style="border: 1px solid #f0f; border-bottom: none; padding: 0 2px">[[User:Marc Kupper|Marc&nbsp;Kupper]]&nbsp;([[User talk:Marc Kupper|talk]])</span> 08:07, 10 August 2008 (UTC)
 +
::There are auto-archive bots active on wikipedia. i don't hsve the scripts to any. They might or might not be adaptable here, but I really don't think we need them. -[[User:DESiegel60|DES]] <sup>[[User talk:DESiegel60|Talk]]</sup> 21:06, 1 September 2008 (UTC)
  
−
Has anyone else noticed the wonderful tool that Al's added to the menu on the publication listing page?  If you click on the WorldCat link, you're taken directly to the WorldCat page for this pub based on its ISBN.  Great tool! Thanks, Al. [[User:Mhhutchins|MHHutchins]] 00:22, 4 June 2008 (UTC)
+
== Online/Offline status ==
  
−
:Oh yes, I was going to add it to "What's New" once we reach 300,000 titles and have another reason to celebrate :) [[User:Ahasuerus|Ahasuerus]] 03:59, 4 June 2008 (UTC)
+
For those that might have been wondering where I have been recently, I thought I would try to add a comment to address that (I am not sure this is the right place for such a thing and to be honest I am not sure I am in the best state of mind to care much at the moment). In the middle of last week I was notified I was being cut from my job and I have been dealing with that and in not much of a state of mind for working on ISFDB. I do hope to get back to such things but it might take me a while to get to such a place (however if I cannot find a replacement job soon it might mean I have more time here--we shall see). Thanks. [[User:Uzume|Uzume]] 22:53, 4 April 2011 (UTC)
  
−
:: Yes, looks good to me too. Ahasuerus, which title TYPES are you counting? As we're at 315,635 titles in general already... [[User:BLongley|BLongley]] 18:09, 4 June 2008 (UTC)
+
: It's probably the wrong place, but as I've been in a similar position for a year now you have my sympathies. [[User:BLongley|BLongley]] 23:04, 4 April 2011 (UTC)
  
−
:::The [http://www.isfdb.org/cgi-bin/stats.cgi ISFDB Statistics page] has 299,570 non-variant Title records at the moment. We have about 15,000 variant titles, which presumably accounts for the difference :) [[User:Ahasuerus|Ahasuerus]] 19:47, 4 June 2008 (UTC)
+
:: Sorry to hear that! Good luck finding a job and don't worry about ISFDB -- it will be here when you have time for it! [[User:Ahasuerus|Ahasuerus]] 05:52, 5 April 2011 (UTC)
  
−
:::: Ah, OK. I don't find that page useful myself. Well, except that "None: 0" and "CHAPTERBOOK: 5" are good signs of Entropy. [[User:BLongley|BLongley]] 21:57, 4 June 2008 (UTC)
+
== Polish Mummy ==
−
:::: I'm not interested in "COVERART: 42856" as it seems people are unwilling to merge them and I'm sure we really don't have that many actual artwork differences. "INTERIORART: 23619" - well, that's not Speculative FICTION, is it? Nor are "NONGENRE: 1018", by definition.    "ESSAY: 41632" might be useful for SF purposes, but might not be fiction-related, as might "NONFICTION: 3989" - I know some are Bibliographies or Encyclopedias of SF and good things like that. "INTERVIEW: 1174" - good background material I presume, but not Fiction. (OK, I suppose it depends who you interview.) "SERIAL: 2739" - I suspect most of those are duplicated by actual Novels or Novellas at least, and even if they aren't, it probably takes two or three of them to make one proper SF work. "OMNIBUS: 1908" - well, those are just confirmation of proper titles mostly. Same with "REVIEW: 26343". "EDITOR: 2004" just confirms magazines, not contents, and I know we have loads of missing Editor Records. "COLLECTION: 4807" and "ANTHOLOGY: 4703" cover shortfiction (hopefully, although I appreciate they may cover shortfiction we haven't got yet). "POEM: 8985" - not my cup of tea really, but they count for short-fiction. [[User:BLongley|BLongley]] 21:57, 4 June 2008 (UTC)
 
  
−
:::: So it comes down to "NOVEL: 48423" and "SHORTFICTION: 85364". I keep finding Dups of shortfiction whenever I try to find the Dups ''I've'' just created by adding another anthology or collection, so that's probably overstated as well. Still, the figures suggest there's enough SF already created that I can stay happy for the rest of my expected lifespan, even if we don't separate out the Fantasy and Horror I'm unlikely to read, so don't be disheartened with these stats! I think I'll be happier with seeing "edit number 1,000,000" though, rather than "300,000 titles". [[User:BLongley|BLongley]] 21:57, 4 June 2008 (UTC)
+
https://www.isfdb.org/cgi-bin/view_submission.cgi?5446490; After working on Carl Dreadstone books recently and fixing/adding a bunch of stuff (I'm still waiting for Ramsey Campbell to reply to my tweet about the Bride of Frankenstein page count) I completely randomly came across this, https://www.isfdb.org/cgi-bin/view_submission.cgi?5446490. I made a sad attempt at entering it but I'm not fluent in the language so after it's approved somebody who is may want to "enhance" it. Thanks in advance. --[[User:Username|Username]] ([[User talk:Username|talk]]) 16:02, 7 October 2022 (EDT)

Latest revision as of 16:02, 7 October 2022

This page is for discussing how the ISFDB:Community Portal page should be organized, or what should go on it. Actual subjects of general community discussion go on the project page itself.

To leave a comment or question click the "+" that's the right of "edit" above. You will be prompted to enter a subject and your message. Please sign the end of your message with four tildes, ~~~~, which will generate a name/date signature.

For old discussions, see the archives


archiving

I ageree that the CP needed to be archived, but I think that threads that had discussion within, say, the last week might reasoanbly have been allowed to reamain un archived. -DES Talk 00:56, 23 July 2008 (UTC)

I used to look at and think about every thread when archiving but that time figured I'd just whack out everything that was not actively under discussion. One week seems reasonable though. I thought there was a auto-archive thing that can do this? I'd like to unleash it on CP plus all of the main discussion areas listed at the top of CP. Note, I no longer have time to patrol the recent-changes meaning I only notice and end up replying to things like this by chance. Marc Kupper (talk) 08:07, 10 August 2008 (UTC)
There are auto-archive bots active on wikipedia. i don't hsve the scripts to any. They might or might not be adaptable here, but I really don't think we need them. -DES Talk 21:06, 1 September 2008 (UTC)

Online/Offline status

For those that might have been wondering where I have been recently, I thought I would try to add a comment to address that (I am not sure this is the right place for such a thing and to be honest I am not sure I am in the best state of mind to care much at the moment). In the middle of last week I was notified I was being cut from my job and I have been dealing with that and in not much of a state of mind for working on ISFDB. I do hope to get back to such things but it might take me a while to get to such a place (however if I cannot find a replacement job soon it might mean I have more time here--we shall see). Thanks. Uzume 22:53, 4 April 2011 (UTC)

It's probably the wrong place, but as I've been in a similar position for a year now you have my sympathies. BLongley 23:04, 4 April 2011 (UTC)
Sorry to hear that! Good luck finding a job and don't worry about ISFDB -- it will be here when you have time for it! Ahasuerus 05:52, 5 April 2011 (UTC)

Polish Mummy

https://www.isfdb.org/cgi-bin/view_submission.cgi?5446490; After working on Carl Dreadstone books recently and fixing/adding a bunch of stuff (I'm still waiting for Ramsey Campbell to reply to my tweet about the Bride of Frankenstein page count) I completely randomly came across this, https://www.isfdb.org/cgi-bin/view_submission.cgi?5446490. I made a sad attempt at entering it but I'm not fluent in the language so after it's approved somebody who is may want to "enhance" it. Thanks in advance. --Username (talk) 16:02, 7 October 2022 (EDT)

Retrieved from "https://isfdb.org/wiki/index.php?title=ISFDB_talk:Community_Portal&oldid=646759"