Copy of username and eMail to be sent to another table

[aymanati]

Hi;

I am using a mailing list application.
And I want the username and email of any user registering in my site to be added in the mailing list database.
So it’s like another copy of the username and email besides the original one in 4images database.

My mailing list tables are in another database than the 4images tables; under the same host.
For the time being; I exported all usernames and emails of my 4images users and successfully imported them in the mailing list table.

Did I explain my idea?

Any help would be really appreciated.

Thanks.

p.S. this is the mailing list I am using:
http://www.listmessenger.com 

[Nicky]

ok.
here we go

INSERT INTO YOUR_MAILING_DATABASE.YOUR_MAILING_TABLE (your_username_field, your_email_field)
SELECT user_name, user_email
FROM YOUR_4IMAGES_DATABASE.YOUR_PREFIX_users

OR

did you mean, when someone register in your 4images gallery should be automaticly added to you maillist database ?

[aymanati]

OR

did you mean, when someone register in your 4images gallery should be automaticly added to you maillist database ?

hi Nicky;
Thanks for teh reply 

And yes; I ment when someone register in my 4images gallery should be automaticly added to you maillist database.

You may need this info:
mailing list db name: lqtacom_email
mailing list user table name: lmuser_list
mailing list username field: user_name
mailing list user email field: user_address

Thanks

[aymanati]

any help?
 

[Nicky]

oups, sorry, i forgot this thread..

will look on it..

send me mysql dump of your mailling list database.. w.o. content
email -> 4images at nicky.net

[aymanati]

Hi Nicky;

Will a fresh .sql file of the mailing database work with you?
or it has to be the existing one?

[Chris]

mysql dump of your mailling list database.. w.o. content

I think that sums it up.  The database structure without content (data)

[aymanati]

ok here you go ..
This is the sql file ..

http://www.lqta.com/listmessenger/backups/backup.1113320036.1011111.lme.zip

is that what you need?

[Nicky]

huuuuuuuuuuuuuuuuuuuh....

what's this ---> backup.1113320036.1011111.lme ?

what should that be inside of the file

Code: [Select]

[version]1.0.0[/version]
[user_groups]
Mg== MA== MA== bHF0YSB1c2Vycw==
Mw== MA== MA== VGVzdA==
[/user_groups]


i need a mysql dump. AS SQL file

[aymanati]

Opss ..
Sorry .. that was from teh application itself  opened only by the application .. how could I miss that ..

this is the SQL Dump (Structure):

Code: [Select]

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 13, 2005 at 08:16 AM
-- Server version: 4.0.22
-- PHP Version: 4.3.10
--
-- Database: `lqtacom_email`
--

-- --------------------------------------------------------

--
-- Table structure for table `lmemail_messages`
--

CREATE TABLE `lmemail_messages` (
  `message_id` int(11) NOT NULL auto_increment,
  `template_id` int(11) NOT NULL default '0',
  `date` bigint(64) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `fromemail` varchar(255) NOT NULL default '',
  `replyemail` varchar(255) NOT NULL default '',
  `erroremail` varchar(255) NOT NULL default '',
  `priority` int(1) NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `text` longtext NOT NULL,
  `html` longtext NOT NULL,
  PRIMARY KEY  (`message_id`),
  KEY `date` (`date`),
  KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `lmemail_queues`
--

CREATE TABLE `lmemail_queues` (
  `queue_id` int(11) NOT NULL auto_increment,
  `date` int(11) NOT NULL default '0',
  `touch` int(11) NOT NULL default '0',
  `target` varchar(255) NOT NULL default '',
  `message_id` int(11) NOT NULL default '0',
  `is_on` int(11) NOT NULL default '0',
  `total` int(11) NOT NULL default '0',
  `status` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`queue_id`),
  KEY `date` (`date`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `lmemail_sending`
--

CREATE TABLE `lmemail_sending` (
  `email_id` int(11) NOT NULL auto_increment,
  `queue_id` int(11) NOT NULL default '0',
  `name` varchar(125) NOT NULL default '',
  `address` varchar(125) NOT NULL default '',
  `sent` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`email_id`)
) TYPE=MyISAM AUTO_INCREMENT=1071 ;

-- --------------------------------------------------------

--
-- Table structure for table `lmemail_templates`
--

CREATE TABLE `lmemail_templates` (
  `template_id` int(10) NOT NULL auto_increment,
  `template_name` varchar(255) NOT NULL default '',
  `template_description` text,
  `template_html` longtext NOT NULL,
  PRIMARY KEY  (`template_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `lmpreferences`
--

CREATE TABLE `lmpreferences` (
  `preference_id` int(10) NOT NULL auto_increment,
  `order_num` smallint(2) NOT NULL default '0',
  `is_required` int(2) NOT NULL default '0',
  `preference_name` varchar(150) NOT NULL default '',
  `preference_value` text NOT NULL,
  `type` varchar(25) NOT NULL default 'text',
  `visible` tinyint(2) NOT NULL default '1',
  `helptext` mediumtext,
  `section` varchar(25) NOT NULL default 'preferences',
  PRIMARY KEY  (`preference_id`),
  UNIQUE KEY `preference_id` (`preference_id`)
) TYPE=MyISAM AUTO_INCREMENT=47 ;

-- --------------------------------------------------------

--
-- Table structure for table `lmuser_groups`
--

CREATE TABLE `lmuser_groups` (
  `group_id` int(10) NOT NULL auto_increment,
  `group_type` int(10) NOT NULL default '0',
  `belongs_to` int(10) default NULL,
  `group_name` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`group_id`),
  UNIQUE KEY `group_id` (`group_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `lmuser_list`
--

CREATE TABLE `lmuser_list` (
  `user_id` int(10) NOT NULL auto_increment,
  `group_id` int(10) NOT NULL default '1',
  `user_name` varchar(150) NOT NULL default '',
  `user_address` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1062 ;

-- --------------------------------------------------------

--
-- Table structure for table `lmuser_queue`
--

CREATE TABLE `lmuser_queue` (
  `id` bigint(12) NOT NULL auto_increment,
  `date` bigint(12) NOT NULL default '0',
  `action` varchar(16) NOT NULL default '',
  `orgin_ip` varchar(26) NOT NULL default '',
  `orgin_url` text NOT NULL,
  `user_agent` varchar(255) NOT NULL default '',
  `user_name` varchar(150) NOT NULL default '',
  `user_email` varchar(150) NOT NULL default '',
  `user_groups` varchar(100) NOT NULL default '',
  `confirm_string` varchar(32) NOT NULL default '',
  `confirm_value` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1062 ;
       
is it what you need?

[Nicky]

ok, i will look on it..

[aymanati]

Thanks Nicky ..
I'll be waiting ..

[aymanati]

Any news Nicky?

[Nicky]

sorry.. was busy.. now going to vacation for 9 days...
hope u can wait so long.

[aymanati]

I'll be waiting ..