- main - earth.li

PHP/MySQL help please
by Tony 24 Feb '07

24 Feb '07

I have set up four websites for local charities but they want the same events to appear on all websites. The sites have all been set up using Joomla and are on the same server but different domains. A common connection to MySQL is not a problem. What I am trying to do is collect data from the MySQL database of the main site and send it to the other sites using PHP (will use a cron job when I get the script working). There is only one table that needs to be transfered. The script I have come up with so far is: <?php $db_host = "localhost"; $table1 = "jos_extcal_events"; $table2 = "jos_extcal_events"; $db_name1 = "midsuffo2"; $db_user1 = "user1"; $db_pw1 = "password1"; $db_name2 = "tbrn1"; $db_user2 = "user2"; $db_pw2 = "password2"; $resource1 = mysql_connect($db_host, $db_user1, $db_pw1)or die ('I cannot connect to the database because: ' . mysql_error());; //select query to get all the data from resource 1 mysql_select_db ($db_name1)or die("Unable to select database $db_name1"); $sql = "SELECT * FROM $table1"; $query = mysql_query($sql, $resource1); for ($i=0;$i<($result = mysql_fetch_assoc($query));$i++) //insert data into $resource2 $resource2 = mysql_connect($db_host, $db_user2, $db_pw2)or die ('I cannot connect to the database because: ' . mysql_error());; mysql_select_db ($db_name2)or die("Unable to select database $db_name2"); { mysql_query("INSERT INTO $table2"); } mysql_close($resource1); mysql_close($resource2); ?> Although it runs without error, it doesn't do anything! I would prefer to drop the old table and create a new one otherwise deleted events would stay on the client sites. Can anyone help or suggest an easier way of doing it? Many thanks Tony

2 1

RE: [ALUG] Syleham Kitmeet - Anyone for a frag?
by keith.jamieson＠bt.com 24 Feb '07

24 Feb '07

Keith Watson wrote: > Continuing the April Fools theme anyone fancy a quick deathmatch via > OpenArena <http://openarena.ws/>? > > We've been playing it at lunchtimes on some old kit here at work and it > runs a treat. Have also loaded it onto my Ubuntu Edgy Eft set-up and it > also runs fine on that. > I have been playing cube and sauerbraten for a while. Just downloaded openarena and cannot get it to run. I get this error message: ...loading libGL.so.1: Calling SDL_Init(SDL_INIT_VIDEO)... SDL_Init(SDL_INIT_VIDEO) passed. QGL_Init: Can't load libGL.so.1 from /etc/ld.so.conf or current dir: failed ----- CL_Shutdown ----- RE_Shutdown( 1 ) ----------------------- Sys_Error: GLimp_Init() - could not load OpenGL subsystem In fact libGL.so.1 is in usr/lib and ld.so.conf has a /usr/lib line in it. Any clues as to what is wrong? ___________________________ Ian Its the path, if the path is not specified in the conf file, you will need to add the lib path to the user who is running the process. Even if its a cronjod then that user needs this. HTH Keith

1 0

looking for webcam
by David Reynolds 23 Feb '07

23 Feb '07

Hi, I'm looking to test a particular model/range of webcam with a piece of software called Delicious Library [1] and wondered if anyone had one that I could borrow / buy for not much cash to see if it works. The type I'm looking for is a Logitech 4000 / Zoom. Basically from what I read it needs to be a Logitech with manual zoom. If anyone can help, it'd be much appreciated. Thanks, Dave [1] http://www.delicious-monster.com/ -- David Reynolds david(a)reynoldsfamily.org.uk

2 1

ALUG library new features
by Wayne Stallwood 23 Feb '07

23 Feb '07

Taking on board some of the things mentioned by Tracy regarding the Library I have now added the facility for members to offer their own books for loan. (you are not actually donating them to the library, you keep them on your bookshelf until someone wants to borrow them) As was pointed out on the list there are probably people sitting on useful books who certainly don't want to give them away to the library but would be willing to lend them out if there is some tracking in place. All existing member accounts have been upgraded, if you have an account the library should have already emailed you to tell you this. You should see a few new buttons when you log in (some of which only appear when you have added your first book) Use Add new Item to offer books for loan. When somebody reserves one of your books you will receive an email telling you who wants it. Once you have given the book to them you log in and mark it borrowed with the Item Check Out button. Once the item is returned use the Item Check in button to return it to your collection. You can specify a loan duration if you want and the Library will then alert both the lender and the borrower when books are overdue. The Library still welcomes additions to it's own collection. I want to make it clear at this point, The Librarian (me) and ALUG do not accept any responsibility for books lost. The agreement to safely return the books is between you and the borrower.

2 1

RE: [ALUG] Wiki
by Tracy Dickerson 22 Feb '07

22 Feb '07

What I meant was that if you edit the HTML rather than use the GUI, the HTML is all bunched up and not spaced out so that it is easy to read for those of us out there that are rookies and will struggle anyway. Sorry that I was not that clear the first time. Tracy x -----Original Message----- From: main-bounces(a)lists.alug.org.uk [mailto:main-bounces@lists.alug.org.uk] On Behalf Of Brett Parker Sent: 22 February 2007 11:00 To: main(a)lists.alug.org.uk Subject: Re: [ALUG] Wiki On Thu, Feb 22, 2007 at 10:46:33AM -0000, Tracy Dickerson wrote: > Hello, > > >From a non technical point of view (i.e. mine) I am finding the Wiki > >a > very difficult place to edit. > > I just had to ask one of the kind fellas here at work to help me add > my name to the 'Whos Who' list as there was not a option in the 'Edit > (GUI)' tab to add a line as it is not active. OK - from the Edit (GUI) type link, to add a row to the table, right click in any cell, hit Insert Row - works very similar to any other editor that does tables :) (Just checked that it worked as I expected, because I'm a "Edit (Text)" person, I like wiki markup and find it quicker and easier than using the GUI). > Please can we make this Wiki user friendly to people who cannot use > HTML. Or can we order the HTML page views so that someone like me has > a hope in hell of understanding it with a book. What do you mean by "order the HTML page views"? I'm not entirely sure that I follow! Thanks, -- Brett Parker _______________________________________________ main(a)lists.alug.org.uk http://www.alug.org.uk/ http://lists.alug.org.uk/mailman/listinfo/main Unsubscribe? See message headers or the web site above!

7 9

open document petition
by tom potts 22 Feb '07

22 Feb '07

http://petitions.pm.gov.uk/OpenDocument/ Tom ___________________________________________________________ The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider. http://uk.docs.yahoo.com/nowyoucan.html

1 0

'locate' isn't always helpful, how to do better?
by Eur Ing Chris Green 22 Feb '07

22 Feb '07

While the 'locate' command is very useful at times, especially if you have lost a specific file it's much less useful when looking for, for example, a directory which has a rather common name. E.g. I was just trying to find where I have bits of vmware installed, doing a 'locate vmware' just produces zillions of lines of output. I don't (in this case) want to know all the files which are located somewhere below a 'vmware' directory, I just want to know the location of the directory. I know I can use an RE in locate but it's not all *that* simple to come up with an RE to do it. I could also use 'find' which would get me exactly the result I want with a fairly straightforward command, but it would take ages. What I really want is a 'find' that uses the locate database, I'm surprised no one has written one - or have they? -- Chris Green

4 8

Wiki / Webmaster hours
by Matthew 22 Feb '07

22 Feb '07

Hi all, I introduced myself the other day but foolishly forgot to include a Subject. If you missed that mail and have questions, just ask. MJ Ray wrote: > ... lugmasters have been looking > at merging/co-hosting dynamic sites, to ease maintenance: there just > aren't enough webmaster-hours to go round. If iPlug has spare > webmaster-hours, please share them! I should probably commit them for one-time projects and events rather than for the continuing running of things, but I have some spare webmaster-hours here and there. I can update static and dynamic things, install and administrate CMSs and the like, and various other things that you shouldn't trust people with when you know them as well as you know me. If anyone has a surplus of project and the cause is good, drop me a mail to say what's required and I'll tell you whether I can help. I'll keep and eye on the Wiki and see if I can be useful there. Matthew

1 0

How to check a directory is empty (probably in bash)?
by Eur Ing Chris Green 22 Feb '07

22 Feb '07

What's the simplest (and/or most concise) way to check for an empty directory? I can't just do a rmdir as I need to check three directories are empty before I can do anything drastic (like removing the directory). Not to mention that for one application of this I don't want to remove the empty directory anyway. As you've probably guessed this is to check if a maildir mailbox is empty - to do this you need to check if all three subdirectories of the maildir are empty. I can see various rather clumsy ways of doing it but nothing neat and elegant. A Google search didn't turn up much either, just some rather arcane zsh ways of doing it which were arcane enough to be zsh only I suspect. I might get carried away and write a little 'C' utility do do it if nothing sensible turns up. -- Chris Green

6 15

RE: [ALUG] Wiki
by Tracy Dickerson 22 Feb '07

22 Feb '07

Hello, >From a non technical point of view (i.e. mine) I am finding the Wiki a very difficult place to edit. I just had to ask one of the kind fellas here at work to help me add my name to the 'Whos Who' list as there was not a option in the 'Edit (GUI)' tab to add a line as it is not active. Please can we make this Wiki user friendly to people who cannot use HTML. Or can we order the HTML page views so that someone like me has a hope in hell of understanding it with a book. Thank you in advance Tracy x -----Original Message----- From: main-bounces(a)lists.alug.org.uk [mailto:main-bounces@lists.alug.org.uk] On Behalf Of Brett Parker Sent: 21 February 2007 23:02 To: main(a)lists.alug.org.uk Subject: Re: [ALUG] Wiki On Wed, Feb 21, 2007 at 10:37:19PM +0000, samwise wrote: > Anyway, I'm finding myself struggling a bit with the limitations of > markup inside tables. It appears there's a macro to address this sort > of thing. Is there any chance someone could install this: Markup in tables?! Hnnng?! You're not planning on using tables for layout purposes are you? (as apposed to tabular data...) -- Brett Parker _______________________________________________ main(a)lists.alug.org.uk http://www.alug.org.uk/ http://lists.alug.org.uk/mailman/listinfo/main Unsubscribe? See message headers or the web site above!

3 2