Oooohh! That simplifies things a bit. Thanks!

Not sharing a table does create another problem though... Since MySQL doesn't support triggers (at this point), how would I go about making sure that the two tables are synchronized automatically? I've considered loops and cron jobs, but I'm concerned about server overhead.

Thanks for the reply.

Wouldn't a Left Join require a primary key? The two tables share no common fields. I agree that this would be the prefered method vs. altering core files.

I was considering doing a mod based on what was done with the IPB module. It appends its fields into xoops_users.

Here's a few threads that my shed some light on the subject.

https://xoops.org/modules/newbb/viewtopic.php?topic_id=20690&forum=27#forumpost89650

https://xoops.org/modules/newbb/viewtopic.php?topic_id=20684&forum=7#forumpost89616

https://xoops.org/modules/newbb/viewtopic.php?topic_id=19898&forum=7#forumpost85760

https://xoops.org/modules/newbb/viewtopic.php?topic_id=19012&forum=7#forumpost82395

::bump::

Sorry, but this is something I'm really interested in doing.

I'm not looking for anyone to do it for me. I'm trying to find out if there are any good reasons why I shouldn't do it. I'm not the least bit afraid of tackling a challenge. I like challenges.

Anybody got anything?
Reasons?
Warnings?
Suggestions?
Probability?
Volunteers for teting?

There didn't seem to be a forum that this would fit under, so I figured the Q&A forum was the most fitting.

After searching the ends of the 'net to try to find a *clean* way of sharing user info between XOOPS and XOSC (osCommerce module), I've come to the conclusion that without editing the XOSC core files to share the same _user table as Xoops, it just isn't going to happen.

Originally, I thought that it would be possible to setup a script that performed a join function on xoops_users and xoops_shop_customers, but there is no primary key shared between the two tables, and I didn't see another way of doing it.

This leads me to the following questions...

1. Is there a verified functioning hack available for this module? (I've been looking for days and haven't seen the first sign of one.)

If not.....

2. I've already read plenty about the reason why this modification has not been implemented into the module (it would create problems with future upgrades of Xoops). That's understandable to an extent. However, it stands to reason that, as long as XOOPS doesn't change its user table name, the tables affecting XOSC could be reconstructed from backup after upgrade. Are there any other reasons why someone *shouldn't* perform this hack?

3. Shared user info seems to be an issue for the XOSC module, but not for the IPB module. Why is it issue for one and not the other?

4. I've done a little hacking on modules before, but nothing quite this large. Is there anyone who would want to help me with this hack?

5. If a successful hack can be put together, is there anyone who would want to beta test it?

Just seems like there is an aweful large group of people posting on several sites about the ability of XOOPS and XOSC to share user data. Seems kinda strange that some kind of workaround hasn't been developed yet. Or am I missing something?

Thanks for any replies.

Best Regards,

JMorris

While I will agree that the $4.99 package at 1and1 is not the best for Xoops, the business package (what I use), is well worth $9.99/mo.

Note: I am not an employee and the link is not an affiliate link.

The Following Features Are All Included:
Basic Features:

* Hosted on I/O optimized 1&1 Linux version
* 1000 MB web space
* 15 GB monthly transfer volume
* 5 FTP accounts
* SSI Server Side Includes

Domain Features:

* Includes 3 domains at no additional cost (.com, .net or .org only)
* No additional costs for domain transfers
* 50 subdomains
* DNS Management
* Point up to 100 external domains to 1&1 name servers
* Domain Contact Management
* Manage unlimited domains

E-mail Features:

* 150 POP3 e-mail accounts with 50 MB space each
* 500 e-mail aliases
* 1&1 WebMail
* Symantec virus scan protection for 3 POP3 accounts
* E-mail forwarding
* Auto-responders
* Catch-all e-mail addresses

Marketing Tools:

* 5 1&1 Chat channels
* In2site Live Dialogue
* 1&1 WebStatistics
* 1&1 Newsletter Tool
* Search Engine Tools

Site-Building Tools:

* WebsiteCreator with 18 pages
* 1&1 WebElements
* Ready- to-run CGI scripts
* Free CGI programming
* PHP3 & PHP4
* Cron Jobs
* FrontPage Extensions
* Software worth $550, including NetObjects Fusion 7.5

Database Features:

* 1&1 WebDatabase
* 1x MySQL databases (100MB is more than enough. Use prefixes)

Security Features:

* Daily backups of your website
* Continuously updated 1&1 firewall
* Optional Dedicated SSL certificate (QuickSSL Premium)
* SSL Secure Server
* SSH Secure Shell Access

Account Features:

* Access to log files
* 1&1 Control Panel

Guarantee:

* 90-Day Money Back Guarantee
* 99.9% uptime (100% has been my experience)

Support:

* Free 24/7 phone support
* Free 24/7 e-mail support
* Online FAQ

I have used several (more than you would believe) web hosts over the past few years and none (many mentioned in this thread) could remotely compare with the reliability, speed, and features of 1and1. I plug them so pasionately because they are that darn good!

The only downside I've found with 1and1 is that I had to install phpMyAdmin myself. To be quite honest, I prefer it that way because I can upgrade it. Many hosts use an outdated version that may have security holes. Besides, it takes 5 minutes to install.

If you want to make your site more search engine friendly., you could used the eXploZ XOOPS hack.

https://xoops.org/modules/news/article.php?storyid=1469

A splash page with a well written introduction that has good keyword saturation is always helpful for good placement. If you know anything at all about html, you can put together a decent splash page in a matter of hours. Redirect pages will kill your ranking.

It is quite a nice theme. 7dana Web Design is the original author. You can download the theme (and many others) from the following link.

http://www.7dana.com/download/pafiledb.php?action=file&id=25

The navigation system that particular theme uses is Javascript. If you open the theme.html you can see the code and all it's glory. The code is clean and easy to edit.

However, if you're not much of a coder, you can create a DHTML drop down menu that can easily be pasted into your site athttp://www.ecirce.com/dhtml/webmenus/. You'll need IE 5.5 to run the editor, but the resulting menus are cross-browser compatible.

One note though, the positioning of your menus is handled with offsets. In other words distance from top and left (x,y coordinates). You'll need to experiment with the offsets a little when you setup the menu. Also, you'll need to use the virtual URL (htt://www.yoursite/modules/newbb) instead of referencing <{$xoops_url}> with a target of _top or _self. Other than that, it's a straight forward WYSIWYG menu wizard.

Check the time scheduled and the time zone settings of your site.

I don't know why, but I had the same problem. I just had to start scheduling items from 1:00am - 11:59pm.

Would be nice if this glitch was work out in the next version though.

Just complete the form in the admin section. It's pretty cool like that.