Gallery

From Eastnet
Revision as of 01:49, 8 July 2010 by Michael (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Gallery stuff

Installation

Migration

Setting Up

Theme is now back to Classic with Blue. Will note settings when I have settled on them.

Individual Galleries

Setup Notes for individual galleries - (bracket) number is position on main screen.

Signed Pictures (1)

Note: This one needs captions editing.

http://uknet.com/gallery2/Signedpics/

  • Edit Album:
    • General -> All default.
    • Album -> Ratings - All enabled
    • Theme -> All default.
    • Custom -> As imported (none in this case)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody
      • [Rating] All Access - Everybody
      • [checkout] Purchase item - Everybody


55-Fiction (2)

http://uknet.com/gallery2/55-Fiction/

  • Edit Album:
    • General -> All default.
    • Album -> Image Block -> Prevent and apply to subalbums.
    • Album -> Ratings - All enabled
    • Theme -> All default.
    • Custom -> As imported - Notes and (C)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody
      • [Rating] All Access - Everybody
      • [Comment] Add comments - Everybody
      • [Comments] View comments - Everybody


Ancient Computers (3)

http://uknet.com/gallery2/Museum/

  • Edit Album:
    • General -> All default.
    • Album -> Image Block -> Prevent and apply to subalbums.
    • Album -> Ratings - All enabled
    • Theme -> All default.
    • Custom -> As imported - S/N, Date, Tag
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody
      • [Rating] All Access - Everybody
      • [Comment] Add comments - Everybody
      • [Comments] View comments - Everybody


Animationart (4)

http://uknet.com/gallery2/Animationart/

  • Edit Album:
    • General -> All default.
    • Album -> Ratings - All enabled
    • Theme -> All default.
    • Custom -> As imported (none in this case)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody
      • [Rating] All Access - Everybody
      • [Comment] Add comments - Everybody
      • [Comments] View comments - Everybody


Ircnet.org (5)

http://uknet.com/gallery2/IRCnet-Operators/

  • Edit Album:
    • General -> All default.
    • Album -> Image Block -> Prevent and apply to subalbums.
    • Album -> Ratings - All enabled
    • Theme -> All default.
    • Custom -> As imported (none in this case)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody
      • [Rating] All Access - Everybody
      • [Comment] Add comments - Everybody
      • [Comments] View comments - Everybody

(Silence and Pyton also have various access to add stuff.)

Michael's Gallery (6)

http://uknet.com/gallery2/Michael/

  • Edit Album:
    • General -> All default.
    • Album -> Image Block -> Prevent and apply to subalbums.
    • Album -> Ratings - All enabled
    • Theme -> All default.
    • Custom -> As imported (none in this case)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody
      • [Rating] All Access - Everybody
      • [Comment] Add comments - Everybody
      • [Comments] View comments - Everybody

British Food (7)

Note: This one needs captions editing.

http://uknet.com/gallery2/BritishFood/

  • Edit Album:
    • General -> All default.
    • Album -> Image Block -> Prevent and apply to subalbums.
    • Album -> Ratings - All enabled
    • Theme -> All default.
    • Custom -> As imported (none in this case)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody
      • [Rating] All Access - Everybody
      • [Comment] Add comments - Everybody
      • [Comments] View comments - Everybody

Lorry.org (8)

http://uknet.com/gallery2/lorry/

  • Edit Album:
    • General -> All default.
    • Album -> Image Block -> Prevent and apply to subalbums.
    • Theme -> All default.
    • Custom -> As imported (none in this case)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody

Various sub albums - All inherit settings:

  • Lorry.org - Friends Page.
    • 01 Others
    • 02 Vanished People
    • 03 Graveyard
  • The Little Prince
  • Michael's Album

UKnet User Albums

http://uknet.com/gallery2/UKnet/

  • Edit Album:
    • General -> All default.
    • Album -> Image Block -> Prevent and apply to subalbums.
    • Theme -> All default.
    • Custom -> As imported (none in this case)
  • Edit Permissions:
    • Group Permissions:
      • [Core] View all versions - Everybody

Just Sofie now, really... So could delete this.


eCommerce or not to eCommerce

WAAAAaaaaaaaaaaaaaaaaa!

Manual Spam Deletion (SQL)

In the gallery2 home directory, create killspam.php and edit it to add what want in there - Case is not important. This one assumes that the table prefix is "uknet_" and the database is called "gallery2" on "localhost". User is "root" password is "PASSWORD".




<?
#connect to database
$connection = mysql_connect("localhost","root","PASSWORD") or die ("Didn't connect");
$db - mysql_select_db("gallery2",$connection) or die ("Couldn't connect to mysql");

#create temporary database - First we delete it just in case, error checking disabled.
$query = "DROP TABLE TEMPCOM";
$result = mysql_query($query);

$query = "CREATE TABLE TEMPCOM
SELECT g_id
FROM `uknet_Comment` gc
WHERE
g_subject like '%url%' or
g_subject like '%http%' or
g_subject like '%handbags%' or
g_subject like '%poker%' or
g_subject like '%blackjack%' or
g_subject like '%gambling%' or
g_subject like '%viagra%' or
g_subject like '%phentermine%' or
g_subject like '%casino%' or
g_subject like '%order%' or
g_subject like '%slots%' or
g_subject like '%Cialis%' or
g_subject like '%url%' or
g_host like '%98.67.145.115%' or
g_host like '%89.143.62.10%' or
g_host like '%62.2.78.194%' or
g_host like '%119.129.246.154%' or
g_host like '%85.181.179.115%' or
g_host like '%77.105%' or
g_host like '%85.183.149.212%' or
g_comment like '%http%' or
g_comment like '%handbags%' or
g_comment like '%poker%' or
g_comment like '%watches%' or
g_comment like '%blackjack%' or
g_comment like '%gambling%' or
g_comment like '%phentermine%' or
g_comment like '%Azithromycin%' or
g_comment like '%doryx%' or
g_comment like '%Zithromax%' or
g_comment like '%backlink%' or
g_comment like '%affiliate%' or
g_comment like '%viagra%' or
g_comment like '%stretch marks%' or
g_comment like '%franchise%' or
g_comment like '%dordogne%' or
g_comment like '%workout%' or
g_comment like '%smoker%' or
g_comment like '%Xnanax%' or
g_comment like '%something about this%' or
g_comment like '%could you explain%' or
g_comment like '%i agree with%' or
g_comment like '%i disagree with%' or
g_comment like '%penis%' or
g_comment like '%ramrod%' or
g_comment like '%forex' or
g_comment like '%exzema' or
g_comment like '%Gutschein%' or
g_comment like '%sextelefon%' or
g_comment like '%order%';";
$result = mysql_query($query) or die (mysql_error());

#select everything from temp table
$query = "SELECT * FROM TEMPCOM";
$result = mysql_query($query) or die (mysql_error());

#walk through temp table items
while ( $row = mysql_fetch_array($result)) {

#print item number that is being deleted
print "deleting " . $row[0] . "<BR>\n";

#delete from Entity table
$query1 = "DELETE FROM uknet_Entity WHERE g_id=$row[0]";
$result1 = mysql_query($query1) or die (mysql_error());


#delete from ChildEntity table
$query2 = "DELETE FROM uknet_ChildEntity WHERE g_id=$row[0]";
$result2 = mysql_query($query2) or die (mysql_error());


#delete from Comment table
$query3 = "DELETE FROM uknet_Comment WHERE g_id=$row[0]";
$result3 = mysql_query($query3) or die (mysql_error());

}
#delete temp table
$query4 = "DROP TABLE TEMPCOM";
$result4 = mysql_query($query4) or die (mysql_error());
print "DONE!"
?>


Links