1
wizanda
Just made 1656 randomquotes for mysql.sql file how to add them?
  • 2004/10/14 13:36

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


I have just edited 1656 quotes yet my site at the moment have stopped importing of MySQL databases

Plus also a lot of XOOPS users are not exsperinced with mysql

What i need is how and what is the coding to add the INSERT into Citas database

To make it so that all people have todo is reinstall the randomquotes with the new inserted quotes in the mysql.sql file

i tried doing it under the exsisting intro yet it say it cant install it

so what do i need to make it so this works plz

2
JasonMR
Re: Just made 1656 randomquotes for mysql.sql file how to add them?
  • 2004/10/14 15:42

  • JasonMR

  • Just can't stay away

  • Posts: 655

  • Since: 2004/6/21


I am assuming you are using the module with folder name "randomquote".

This is a snippet of the sql file it uses, when the module is installed:

Quote:

...
CREATE TABLE citas (
id int(11) NOT NULL auto_increment,
texto varchar(255) NOT NULL default '',
autor varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY id (id)
) TYPE=MyISAM;


You can see that we have 3 columns: ID/Quote Text/Quote Author; created during install.

If you want to have quotes also installed at the same time, you will need to add something like this at the end:

Quote:

INSERT INTO `citas` VALUES (1, 'QUOTETEXT1', 'AUTHOR1');
INSERT INTO `citas` VALUES (2, 'QUOTETEXT2', 'AUTHOR2');
INSERT INTO `citas` VALUES (3, 'QUOTETEXT3', 'AUTHOR3');
...


This should do the trick, if I understood your request correctly.

3
wizanda
Re:Just made 1656 randomquotes for mysql.sql file how to add them?
  • 2004/10/14 16:05

  • wizanda

  • Home away from home

  • Posts: 1585

  • Since: 2004/3/21


Just tryed that yet it dosent seem to work

4
JasonMR
Re:Just made 1656 randomquotes for mysql.sql file how to add them?
  • 2004/10/14 17:01

  • JasonMR

  • Just can't stay away

  • Posts: 655

  • Since: 2004/6/21


You've changed the sql file, and if you install the module, it doesn't have the quotes you wrote into the include-statements inserted into the database?

That would be strange....

Login

Who's Online

261 user(s) are online (84 user(s) are browsing Support Forums)


Members: 0


Guests: 261


more...

Donat-O-Meter

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

Latest GitHub Commits