XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


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


31
tedsmith
Re: MyLinks module

  • 2007/12/17 22:05

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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
Topic | Forum


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

  • 2007/9/27 12:19

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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


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

  • 2007/9/27 12:14

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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
Topic | Forum


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

  • 2007/9/27 10:17

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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?
Topic | Forum


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

  • 2007/6/21 21:19

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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.
Topic | Forum


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

  • 2007/6/21 18:48

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


No one else had this?
Topic | Forum


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

  • 2007/6/20 16:12

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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 visitinghttp://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/viewtopic.php?topic_id=2050&forum=12&post_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
Topic | Forum


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

  • 2007/5/1 21:03

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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
Topic | Forum


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

  • 2007/5/1 19:04

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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
Topic | Forum


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

  • 2007/5/1 18:46

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


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(COLUMN, OLD_VALUE, NEW_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
Topic | Forum



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



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

183 user(s) are online (113 user(s) are browsing Support Forums)

Members: 0

Guests: 183

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits