xoops forums

Forum Index


Board index » All Posts (tedsmith)




tedsmith

Home away from home
Posted on: 2007/12/17 22:05
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#31

Re: MyLinks module

Having just updated our server to PHP5 we had problems with Polls and MyLinks. The updates from the XOOPS Addons site has fixed both of these issues!!! Great link and great site,

Ted


tedsmith

Home away from home
Posted on: 2007/9/27 12:19
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#32

Re: SmartClient - Directing users to a clients profile page as opposed to their website homepage?

I have just tried it now, in fact. And yes - that has worked!! Thanks so much.


tedsmith

Home away from home
Posted on: 2007/9/27 12:14
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#33

Re: SmartClient - Directing users to a clients profile page as opposed to their website homepage?

Thanks a lot DB. I was on the right lines. I'd adjusted that value with the URL of profile page but I think I'd messed the syntax up which made it work incorrectly and made me assume I was looking in the wrong place! You have demonstrated how it is supposed to look so I'll try that tonight and let you know how I get on.

Thanks a lot for taking the time to help.

Ted


tedsmith

Home away from home
Posted on: 2007/9/27 10:17
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#34

SmartClient - Directing users to a clients profile page as opposed to their website homepage?

Also asked here but how and what file or template do I edit so that when a user clicks a client image they are taken to the clients description page (i.e. the 'Read more...' page of the client in the module) as opposed to their actual homepage website?


tedsmith

Home away from home
Posted on: 2007/6/21 21:19
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#35

Re: WF-Downloads 3.2 RC1 - Recent Downloads date showing as seconds since Unix Epoch as integers

Date format is set d-M-Y as required (http://uk.php.net/date). But those settings are just the PHP rendering of the converted and calculated dates. In this case the integer values are not being converted intoa date at all.


tedsmith

Home away from home
Posted on: 2007/6/21 18:48
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#36

Re: WF-Downloads 3.2 RC1 - Recent Downloads date showing as seconds since Unix Epoch as integers

No one else had this?


tedsmith

Home away from home
Posted on: 2007/6/20 16:12
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#37

WF-Downloads 3.2 RC1 - Recent Downloads date showing as seconds since Unix Epoch as integers

The latest upgrade from 2.05 to 3.2 RC1 of WF-Downloads ic causing me a problem in my 'Recent Downloads' block. Basically, the date is being displayed as the integer based value as seconds passed from the Unix Epoch date value as opposed to the normal human readable date format. For example, '1182189976' is shown instead of 18/06/07. Screenshot Illustrates (this is confirmed by visiting http://www.unixtimestamp.com).

My template values for wfdownloads_block_new.html read as follows :

<ul>
  <{foreach 
item=download from=$block.downloads}>
    <
li>[<{$download.date}>] <a href="<{$xoops_url}>/modules/<{$download.dirname}>/singlefile.php?cid=<{$download.cid}>&amp;lid=<{$download.id}>"><{$download.title}></a> </li>
  <{/foreach}>
</
ul>


The obvious value here being <{$download.date}> which I assume is a PHP function call to a date converter in Smarty? The value for the news module by comparison is working fine and can be seen in the same screenshot at the bottom. It uses [<{$news.date}>]. To add insult to injury, since updating the template for the 'Recent Downloads' block (to see if that helped) they are now all shown in a bizarre order - not in date order as they were before (whereas before they were still listed in date order even though the date conversion was not taking place).

I have requested support at The Smart Factory here if anyone wants to post there : http://smartfactory.ca/modules/newbb/ ... ost_id=8273#forumpost8273

XOOPS 2.0.16
Software server : Zeus/4.3
PHP version : 4.4.7
MySql version : 4.1.22-standard-log

Cheers

Ted


tedsmith

Home away from home
Posted on: 2007/5/1 21:03
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#38

Re: MySQL Experts read this...how to restore from a 'find and replace' tradgedy??

Got my commercial provider to restore the MySQL dump file for me. So panic over.

Would still be intrigued to have answers though for future reference


tedsmith

Home away from home
Posted on: 2007/5/1 19:04
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#39

Re: MySQL Experts read this...how to restore from a 'find and replace' tradgedy??

If it helps, I have managed to extract (from a CSV backup of the database) all the e-mail addresses of each unique username into a spreadhseet with two columns named as follows:

UserName   E-MailAddress
Joe Blog   joebloggs
@joebloggs.com


etc

How can I tell MySQL to to import the appropriate e-mail address for each username (the username column is 'uname' in table databaseprefix_users and the e-mail column is 'email')? I don't know the syntax and blindly panicked and so can't work it out!

Thanks

Ted


tedsmith

Home away from home
Posted on: 2007/5/1 18:46
tedsmith
tedsmith (Show more)
Home away from home
Posts: 1151
Since: 2004/6/2 1
#40

MySQL Experts read this...how to restore from a 'find and replace' tradgedy??

Hi

I've got a rather major problem. I tried to save some time by using a MySQL statement to 'Find and Replace' a load of e-mail values because I had to update about 20 users with a different address and did not want to do it one at a time.

I needed to change :

user1@mysite.com
user2@mysite.com
etc

to

user1@myothersite.com
user2@myothersite.com
etc

I read
here and here that the best way to do that is like this :
update TABLE set COLUMN replace(COLUMNOLD_VALUENEW_VALUE);


So I entered this into the SQL area of phpMyAdmin :

update databaseprefix_users set email replace(email, @mysite.com, @myothersite.com);


Assuming it would find all the e-mail addresses that ended in @mysite.com and replace them with @myothersite.com. But no. It's wiped out every single e-mail address in my database!!! Now none of my users have an e-mail address associated with their account!!!

So

Q1) What went wrong?
Q2) How can I easily restore these values from my SQL backup? I don't want to risk trying to restore the entire database in case of further damage. All I want to do is restore the ..._users table, more specifically, the e-mail column of it and repopulate them with the e-mail addresses in the backup.

Any thoughts? I am rather desperate as this makes me look like a total idiot.

Thanks a lot

Ted



TopTop
« 1 2 3 (4) 5 6 7 ... 103 »