Date: 01/09/06 (PHP Community)    Keywords: php, templates, mysql, css, html, sql, java, spam

I've been hunting all around for a decent photo gallery. There seem to be quite a few different projects, some of which are still active, available. None of them seem to accomplish what I'm looking for, though. I have tested quite a few, but all are lacking. To this end, I thought I'd ask here if anyone has anything similar to what I've been looking for.

Major Features:
Abstracts image URLs - hides the path and filename to prevent direct access
Public/private flags - allows some images to stay hidden
Tags - I'd like to be able to tag the images ala del.icio.us, LJ, Flickr
Does not require gd - auto-thumbnails and watermarks can be disabled
Traverses directories - new images can be dropped in a subfolder or the root image folder and will be picked up automatically
Comments - allows for public (configurable) or private comments, either ties into phpbb or uses some sort of email validation/captcha scheme to reduce spam
EXIF - extracts all image data form the photographs and can display it
Uses simple cacheable CSS/XHTML templates
Does not store images in DB
Uses MySQL or abstraction layer that allows MySQL for comments, tags, etc
Takes reasonable measures to be secure and speedy

Minor Features:
Users can upload images
Temporary/expiring image URLs for sharing
Hotlinking configuration - allow all, deny all, allow specific sites
User-switchable templates
Javascript navigation and image pop-ups optional
Keeps stats on a pre image basis - top keywords, views, etc
All images can be watermarked automatically
Thumbnails may be re-generated automatically
Can assign/rename/describe multiple photos at once

I'm sure there are more details, but that should give a start. The scripts I've found so far are either too simple and don't have many features or too complex and require components and methods of use that I won't be using. There are a few others that store the images in the DB, which is something I'm definately against. I want to be able to FTP a directory of images and know that it will be online and ready to go as soon as the transfer is complete, or that it takes a simple click to do a rescan so they are available.

If I have to, I'll start from scratch... I was just hoping that there would be something available that I have not yet found that could serve as a foundation to build from.

Thanks

Source: http://www.livejournal.com/community/php/392436.html

Date: 01/10/06 (PHP Community)    Keywords: sql

Is there some possibility to sort this:
$sql = "SELECT band,cover1,cover1year,cover1title,cover2,cover2year,cover2title,cover3,cover3year,cover3title,cover4,cover4year,cover4title,cover5,cover5year,cover5title FROM referenzen ORDER BY band ASC";

by the count of covers (so the ones with 4+ are on top and the ones with only one are at the bottom)? (see this). Not all of the variables are always in use, I don't have any idea how to do this.

Source: http://www.livejournal.com/community/php/393297.html

Date: 01/11/06 (Asp Dot Net)    Keywords: sql

Hey guys and gals-
I am a .NET programmer in Birmingham, AL. I am looking for a different job in a cool city. Preferably stay in the Southeast, but don't have to. If any of you peeps know of any job opportunities at your workplace, please drop me a comment. Come on, I live in Alabama. Help a girl out.
I've got 2.5 years C#, VB.Net and SQL experience.
Thank you!

Source: http://www.livejournal.com/community/aspdotnet/53739.html

Date: 01/13/06 (Web Development)    Keywords: html, sql, java, web, yahoo, google

i'd like to add a calendar to my site. it doesn't need to be editable by visitors to the page, only by me.. but it does need to have functionality that would allow visitors to flip through different months and see what days i'm available. ideally it could also be colorcoded based on different categories (completely available, someone has requested me but nothing is confirmed, not at all available.)

i have come to ask the experts if you know a useful app for this purpose. i'm definitely not a true webdev person... i only know basic html and a little sql/javascript/etc. i googled, but most of the results were for calendars which remain on the site of the calendar's creator (e.g. calendar.yahoo.com) vs. ones which could integrate into my own site's design.

(to give you an idea of my preferences, some of my favorite web-based tools are flickr, allconsuming.net (and 43 things), dodgeball, yelp, etc.)

any advice would be greatly appreciated =]

Source: http://www.livejournal.com/community/webdev/285230.html

Date: 01/13/06 (PHP Community)    Keywords: php, mysql, html, database, sql, web

Hey Guys

I'm new to this community. I am starting a web design company, and although I used to be decent at PHP, that was a couple of years ago and my knowledge is now pretty much non-existent. I need a script coded for a band website and I was wondering if some of you would give me a price estimate on it.

The script is for bands that want to add shows to their website. The script needs to do the following

- Allow a user to add / edit / delete shows to their website. The shows will be in 2 categories (which will be 2 HTML tables) which are Upcoming shows, and past shows.
- The user puts in information in a form and it's stored in a MySQL database. The most important information is displayed in an HTML table, and in the last cell of the table will have a link for more information. When a user clicks on this link it opens up a popup window and displays ALL the information of the show (eg. Date, time, venue, cost, directions, other notes yada yada yada) in another HTML table (within the pop-up window)

I realise that this is a pretty simple script (in comparison to what you guys have probably coded in the past, so I hope someone out there can code it for me at a reasonable price

Thanks in advance

Source: http://www.livejournal.com/community/php/394319.html

Date: 01/15/06 (MySQL Communtiy)    Keywords: php, mysql, sql

i'm trying to select some data from a table. this bit i'm doing quite well with, however it's returning two rows per 'primary key' based on a left join. i've tried using DISTINCT but that doesn't seem to effect it. i then i tried using GROUP BY and that did, so now i'm getting the one row per primary key i was originally after, but i seem to be getting this data without the data of the left join i so desperately need. upon further investigation, back when i was getting two rows per primary key, only the second row per primary key had the data i was after. is their anyway to make sure the query returns the second row as opposed to the first?

my initial idea was to add a clause, but not all rows in the table will have data in that column, i just want to make sure rows with data in that column will definately be returned.

any suggestions?




x-posted to mysql and php_mysql

Source: http://www.livejournal.com/community/mysql/81895.html

Date: 01/15/06 (SQL Server)    Keywords: sql

table_name
- column_name

utterance
- utteranceID
- speakerID

utteranceHistory
- utteranceHistoryID
- utteranceID
- speakerName
- workTypeDescription
- businessEntityDescription
- eventDate

speaker
- speakerID
- personID

person
- personID
- firstName
- lastName

the task: i need to collect all occurrences when a speakername had been changed in the system. returning in this query: the utteranceID, original speakerName, and final speakerName. I am using MS SQL Server, so i can't use a MINUS as i would have liked to.

-- here is what i tried
-- sadly this is lacking by not returning all of the rows where a speakerName change has occurred
select uh1.utteranceID,
uh1.speakerName AS originalSpearkerName,
uh2.speakerName AS finalSpearkerName
from utteranceHistory uh1 INNER JOIN utteranceHistory uh2
ON (uh1.locationId = uh2.locationId
AND uh1.utteranceID = uh2.utteranceID
AND uh1.utteranceHistoryID <> uh2.utteranceHistoryID)
WHERE uh1.speakerName <> uh2.speakerName
AND uh1.utteranceHistoryID = (SELECT MIN(utteranceHistoryID) FROM
utteranceHistory where utteranceID = uh1.utteranceID)
AND uh2.utteranceHistoryID = (SELECT MAX(utteranceHistoryID) FROM
utteranceHistory utteranceID = uh2.utteranceID)
ORDER BY uh1.utteranceID

-- here is what returns all the changes in the speakerName, however
-- returns two rows per utteranceId, which is really not easy to format
-- especially when the results i am working with are in the thousands.

SELECT utteranceID, speakerName
FROM utteranceHistory
WHERE utteranceID IN
(
SELECT utteranceID
FROM utteranceHistory
WHERE speakerName IS NOT NULL
GROUP BY utteranceid HAVING count(utteranceid) =2
)
and speakerName IS NOT NULL
ORDER BY utteranceid, eventdate

Source: http://www.livejournal.com/community/sqlserver/39957.html

Date: 01/17/06 (MySQL Communtiy)    Keywords: mysql, sql

I have a table that is all messed up so I ran 'repair table my_table'. The problem is that it never completed and didn't give me any error messages. The table is a little bit (a bit over 1 gig), but mysql is using 0.0% of the cpu so it doesn't look like it's doing anything. Does anyone have any ideas to help save my data?

Source: http://www.livejournal.com/community/mysql/82528.html

Date: 01/17/06 (WebDesign)    Keywords: php, programming, mysql, database, sql, java, postgresql, web, apache

I need some advice in regard to which language to use for developing a dynamic website. My wife and I are thinking about creating a LMAO website, which will allow people to organize various LMAO projects. The website will allow users to register, log in, create projects, join projects, upload pictures, and so on. It's not terribly large project, but still pretty complicated for people who haven't done any web development and little programming in general.

The first problem is deciding upon a language to use. The site will, at least in the beginning, run on our server at home, which is FreeBSD running Apache2 (or anything else we want, to be honest. I'm not giving up FreeBSD, though!). It looks like all major languages in the field, including PERL, Ruby (and Ruby on Rails), Python, and PHP work well with Apache, so that shouldn't be a problem. For the database back-end, we'll be using PostgreSQL or MySQL (if we have to), both of which are widely supported as well.

My wife doesn't have much experience in programming, so for her it will be new experience one way or the other. I have some, but still little. The only language I'm familiar with and can actually write something useful in is Common Lisp. There exists mod_lisp and a couple of web development frameworks, TBNL and UnCommon Web, but the process seems hacky -- from what I can tell -- unless one uses a commercial CL implementations that cost a lot.

I've looked briefly at Python and Ruby, as well as asked for opinions from various groups of people (programmers who prefer Lisp, Ruby, or Python), but it's all still looks like mambo-jumbo to me. The only thing they agree on is that one should refrain from using PHP for anything non-trivial, so I'm inclined to believe that. As far as PERL is concerned, I've always had a distaste for it, so am not all that keen on using it.

Could anyone recommend one of these language, or perhaps another one, that would be suitable for our needs? I've pretty much made up my mind in regards to PHP and PERL, so I'm not looking for a debate about why they're good. I also wish to stay away from Windows-based and Java-based solutions.

Source: http://www.livejournal.com/community/webdesign/1045210.html

Date: 01/17/06 (SQL Server)    Keywords: database, sql

A new product that might be of interest to users in this community: TextConverter

Synopsis:
- extraction of data from text files (from simple CSV to complex)
- script-enabled transformation
- load into any database including SQL Server

Any feedback would be greatly appreciated.

Source: http://www.livejournal.com/community/sqlserver/40315.html

Date: 01/17/06 (PHP Community)    Keywords: php, mysql, browser, database, sql

Ok, so I have the following code, meant to delete a category in a script I'm working on. It takes the category ID from the $_GET array, checks the database to make sure such a category ID exists, then deletes it if true or shows an error if false.

if ($_GET['categories'] == "deletecat") {
if (isset($_GET['delid'])) {
$idofd = cleaninput($_GET['delid'], 1);
$idofd = (int)$idofd;
$check_delete = mysql_fetch_assoc(mysql_query("SELECT * FROM table_cats WHERE cat_id = '" . $idofd . "' LIMIT 1", $connect));
if (empty($check_delete)) {
echo "

Error: There is no category with the ID number " . $idofd . ".

Source: http://www.livejournal.com/community/php/396330.html

Date: 01/18/06 (MySQL Communtiy)    Keywords: php, mysql, sql

good evening! has anybody ever seen mysql clients (mysql, php, check_mysql(nagios), etc) choke with an error similar to 'can't assign requested address' ? I've got over 30,000 connections listed in netstat with a status of TIME_WAIT. fairly basic php/mysql site (high traffic), no apparent cause.

possible causes I've thought of:

- maybe somebody initiated a connection but didn't close it.. thrwarted due to the mysql reporting otherwise.
- mysql being retarded? not likely, when the error occurs, no incoming connection is reached by the mysql server (via tcpdump/ngrep), resource usage on the server is fine. same with the process list.
- max files being reached?

any thoughts? :D

Source: http://www.livejournal.com/community/mysql/82879.html

Date: 01/18/06 (Java Web)    Keywords: database, sql, java

HSQLDB, the famous fast RDBMS written in Java, introduced a new feature which affects code ported over from previous versions. From version 1.7.2, in-process databases are no longer closed when the last connection to the database is explicitly closed via JDBC. Effectively your data is not written to disk even if you exit the program [...]

Source: http://blog.taragana.com/index.php/archive/hsqldb-database-connection-close-doesnt-write-to-disk-solution/

Date: 01/18/06 (SQL Server)    Keywords: sql

Hi all,

I'm looking for a way to update a table based upon a recordset returned from a stored procedure.

It appears as if you can't join on the results from a stored procedure nor loop over those records using a cursor.

I will be the first to admit, I often miss things when combing through documentation, but I was hoping to use a join in an update statement (which I could do, but I would prefer not to duplicate the logic that I've already got stored in this stored procedure)

If anyone can offer any suggestions, I would be most greatful.


--gryff

EDIT: I'm using SQL Server 2000

Source: http://www.livejournal.com/community/sqlserver/40866.html

Date: 01/19/06 (MySQL Communtiy)    Keywords: mysql, database, sql

These tech communities are mostly questions from those that need help which I often do :)
I thought it'd be fun to change the pace a little and post some info I think is good to know if your using mysql.

I've recently had problems with table crashes and running mysql in an environment with very little disk space. This has taught me a few things I did not know before hand. One of which is mysql's binary log (also known as the update log in older versions). It stores all statements that are run that could potentially modify data in the database which allows restores to work as best as possible (i.e. even if your backup is a bit old). For more info check the binary log docs

Source: http://www.livejournal.com/community/mysql/83396.html

Date: 01/11/06 (Asp Dot Net)    Keywords: sql

Hey guys and gals-
I am a .NET programmer in Birmingham, AL. I am looking for a different job in a cool city. Preferably stay in the Southeast, but don't have to. If any of you peeps know of any job opportunities at your workplace, please drop me a comment. Come on, I live in Alabama. Help a girl out.
I've got 2.5 years C#, VB.Net and SQL experience.
Thank you!

Source: http://community.livejournal.com/aspdotnet/53739.html

Date: 12/23/05 (Asp Dot Net)    Keywords: database, asp, sql, microsoft

I'm working on my first asp.net page and am running into some problems. I'm trying to read data from an MS Access database. I'd appreciate if anyone could point me in the right direction - I pretty much lifted the example code from w3schools. Thanks for any help, I'm feeling a bit lost!

The code below gives an error on line 4, character 5 - expected ";".

[%@ Import Namespace="System.Data.OleDb" %>
[script runat="server">
sub Page_Load
dim dbconn, dbcomm, dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=test.mdb")
dbconn.Open()
sql="SELECT * FROM values"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
value.DataSource=dbread
value.DataBind()
dbread.Close()
dbconn.Close()
end sub
[/script>


Database:
filename: test.mdb, resides in same directory as index.asp file.

table: values
fields: ID, key, value

read [s as <.

Source: http://community.livejournal.com/aspdotnet/52113.html

Date: 12/19/05 (Asp Dot Net)    Keywords: programming, sql

I just got a new computer and I'm setting it up so I can do my programming work at home. I still need to install a SQL server, and even though my company doesn't use it I'm looking at 2005 because quite frankly I don't feel like installing 2000 AND 2005 and having multiple instances running. I'm wondering between downloading either SQL Server 2005 developer edition or the Express Edition. Cost isnt' an issue since I have a MSDN license at work, I don't want to have to DL 2 CDs worth of data if I don't have to. Does anyone know more about the features of these 2 versions and whether or not I should really prepare for the future with a DEV edition or if I should just go with the lightweight Express edition. One thign is though that I'd like easy integration into the VS IDE, and I read that SQL Express integrates into VS Express, but my Version is the Professional Edition, so I don't know if they will integrate also. Its not a necessity but it would be a nice thing to have since everyone seems to be going that direction while I'm still manually writing SQL script. Any feedback would be appreciated. BTW computer power isnt' an issue either. I have an AMD 4400+ X2 with 1 gig of ram.

Source: http://community.livejournal.com/aspdotnet/51909.html

Date: 12/11/05 (Asp Dot Net)    Keywords: database, asp, sql

I've created 2 pages, one to display data from a database and another to insert data. I'm having trouble with the sql insert query.
The first page displays data fine, not in the format I'd like but one thing at a time.

How do I on the second page, create text boxes and the proper connections to insert data into my database. I'm pretty sure this is a simple basic step but I can not figure it out.

Any help or tutorials? I usually hit www.asp.net when I’m stuck and their tutorial is not helping on this one.



Thanks!

Source: http://community.livejournal.com/aspdotnet/51352.html

Date: 12/08/05 (Asp Dot Net)    Keywords: database, asp, sql, web

hello all.. ok here's the story...

i know some basic asp .. i've edited a database driven website fro a while.
I'm no trying to create a new site .. thats also database driven.

How do i connect to the server in order to pull info from it?

I tried following the trail from the site i currently update but i'm not sure what i'm seeing here...

Anyone know how to connect an asp site to a sql 2003 database?

Source: http://community.livejournal.com/aspdotnet/51038.html