Aide totale pour mon site

Résolu
baba37113711 -  
 skater -
Bonjour,
Je viens d'acquérir le script de mon futur site. Seulement je ne sais pas comment faire.
Il y a un fichier READ.ME qui dit :

- create the table with the database.txt dump info

- modify the config.php and /admin/config.php files

- Upload all the files


Et voilà. Je me retrouve avec ce fichier database.txt et un dossier script qui contient tout le script du site.

Je souhaiterais tout d'abord savoir ce que signifie create the table with the database.txt ? Que dois-je faire de ce fichier et surtout, en quoi le modifier ?

Ce fichier database.txt ressemble à celui-là :

-- phpMyAdmin SQL Dump
-- version 2.8.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 18-01-2008 a las 07:01:20
-- Versión del servidor: 5.0.21
-- Versión de PHP: 5.1.4
--
-- Base de datos: `22`
--

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

--
-- Estructura de tabla para la tabla `tb_ads`
--

CREATE TABLE `tb_ads` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(150) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
`tipo` varchar(150) collate latin1_general_ci NOT NULL,
`visitime` varchar(150) collate latin1_general_ci NOT NULL,
`ident` varchar(150) collate latin1_general_ci NOT NULL,
`fechainicia` varchar(150) collate latin1_general_ci NOT NULL,
`paypalname` varchar(150) collate latin1_general_ci NOT NULL,
`paypalemail` varchar(150) collate latin1_general_ci NOT NULL,
`plan` varchar(150) collate latin1_general_ci NOT NULL,
`bold` varchar(150) collate latin1_general_ci NOT NULL,
`highlight` varchar(150) collate latin1_general_ci NOT NULL,
`url` varchar(150) collate latin1_general_ci NOT NULL,
`description` varchar(150) collate latin1_general_ci NOT NULL,
`category` varchar(150) collate latin1_general_ci NOT NULL,
`members` varchar(150) collate latin1_general_ci NOT NULL default '0',
`outside` varchar(150) collate latin1_general_ci NOT NULL default '0',
`total` varchar(150) collate latin1_general_ci NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;

--
-- Volcar la base de datos para la tabla `tb_ads`
--

INSERT INTO `tb_ads` VALUES (1, '', '', 'ads', '', '', '1195231256', '', 'lizaaard@gmail.com', '10000', '1', '1', 'http://www.yourownbux.info', 'Categoria 1', '1', '5', '0', '0');
INSERT INTO `tb_ads` VALUES (3, '', '', 'ads', '', '', '1195231395', '', 'nico@nico.com', '1000', '1', '1', 'http://hola.com', 'Categoria 2', '2', '1', '0', '0');
INSERT INTO `tb_ads` VALUES (6, '', '', 'ads', '', '', '1195493883', '', 'admin', '1000', '', '', 'http://wwwwwww.asdasdasd.comasdasdada', 'Categoria 3', '3', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (7, '', '', 'ads', '', '', '1195494307', '', 'admin', '1000', '', '', 'http://wwwwwww.asdasdasd.comasdasdada', 'Categoria 4', '4', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (8, '', '', 'ads', '', '', '1195494452', '', 'admin', '1000', '', '', 'http://wwwwwww.asdasdasd.comasdasdada', 'Categoria 5', '5', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (9, '', '', 'ads', '', '', '1195499546', '', '1', '30000', '1', '', '1', 'Categoria 6', '6', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (10, '', '', 'ads', '', '', '1195499547', '', '1', '30000', '1', '', '1', 'Categoria 7', '7', '1', '0', '0');
INSERT INTO `tb_ads` VALUES (11, '', '', 'ads', '', '', '1195499548', '', '1', '500', '', '', 'http://wwwwwwwwwwwwwwwwwwwwwww.comomo', 'Categoria 8', '8', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (12, '', '', 'ads', '', '', '1195499621', '', 'admin', '1000', '', '', '9', 'Categoria 9', '9', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (13, '', '', 'ads', '', '', '1195499622', '', 'admin', '1000', '', '', '10', 'Categoria 10', '10', '1', '1', '0');
INSERT INTO `tb_ads` VALUES (22, 'sol', '', 'visit', '1195673371', '21', '', '', '', '', '', '', '', '', '', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (23, 'admin', '', 'visit', '1196562956', '1', '', '', '', '', '', '', '', '', '', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (24, 'admin', '', 'ads', '', '', '', '', '', '1000', '1', '1', 'http://www.psiscofxp.com', 'PsicoFxp', '1', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (25, 'sol', '', 'visit', '1197057471', '1', '', '', '', '', '', '', '', '', '', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (26, '', '', 'ads', '', '', '1197057485', '', 'lizaaard@gmail.com', '30000', '1', '', 'http://www.www.com', 'asdaaa', '7', '0', '0', '0');
INSERT INTO `tb_ads` VALUES (27, '', '', 'ads', '', '', '1197057540', '', 'hola@qweqwe.com', '100000', '', '', 'http://www.lolaa.com', 'lolaaa', '1', '2', '1', '0');
INSERT INTO `tb_ads` VALUES (28, 'admin', '', 'visit', '1200639022', '27', '', '', '', '', '', '', '', '', '', '0', '0', '0');

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

--
-- Estructura de tabla para la tabla `tb_ads_categories`
--

CREATE TABLE `tb_ads_categories` (
`id` int(11) NOT NULL,
`catname` varchar(50) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Volcar la base de datos para la tabla `tb_ads_categories`
--

INSERT INTO `tb_ads_categories` VALUES (1, 'Arts & Entertainment');
INSERT INTO `tb_ads_categories` VALUES (5, 'Shopping & Free Offers');
INSERT INTO `tb_ads_categories` VALUES (2, 'Earn Money');
INSERT INTO `tb_ads_categories` VALUES (3, 'YourOwnBux Offers');
INSERT INTO `tb_ads_categories` VALUES (6, 'Society, Family & Relationships');
INSERT INTO `tb_ads_categories` VALUES (7, 'Charity & Non-profit Organisations');
INSERT INTO `tb_ads_categories` VALUES (8, 'Travelling');
INSERT INTO `tb_ads_categories` VALUES (10, 'Other');

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

--
-- Estructura de tabla para la tabla `tb_advertisers`
--

CREATE TABLE `tb_advertisers` (
`id` int(11) NOT NULL auto_increment,
`pname` varchar(150) collate latin1_general_ci NOT NULL,
`pemail` varchar(150) collate latin1_general_ci NOT NULL,
`plan` varchar(150) collate latin1_general_ci NOT NULL,
`url` varchar(150) collate latin1_general_ci NOT NULL,
`description` varchar(150) collate latin1_general_ci NOT NULL,
`category` varchar(150) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
`bold` varchar(150) collate latin1_general_ci NOT NULL,
`highlight` varchar(150) collate latin1_general_ci NOT NULL,
`tipo` varchar(150) collate latin1_general_ci NOT NULL,
`money` varchar(150) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=40 ;

--
-- Volcar la base de datos para la tabla `tb_advertisers`
--


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

--
-- Estructura de tabla para la tabla `tb_buyref`
--

CREATE TABLE `tb_buyref` (
`id` int(11) NOT NULL auto_increment,
`refnum` varchar(15) NOT NULL,
`sets` varchar(150) NOT NULL,
`customer` varchar(150) NOT NULL,
`amount` varchar(150) NOT NULL,
`refset` varchar(20) NOT NULL,
`pemail` varchar(150) NOT NULL,
`ip` varchar(15) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;

--
-- Volcar la base de datos para la tabla `tb_buyref`
--

INSERT INTO `tb_buyref` VALUES (1, '10', '18', 'admin', '', '', '', '');
INSERT INTO `tb_buyref` VALUES (1, '15', '2', 'admin', '', '', '', '');
INSERT INTO `tb_buyref` VALUES (1, '20', '1', 'admin', '', '', '', '');
INSERT INTO `tb_buyref` VALUES (1, '50', '1', 'admin', '', '', '', '');

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

--
-- Estructura de tabla para la tabla `tb_clickpack`
--

CREATE TABLE `tb_clickpack` (
`id` int(11) NOT NULL,
`item` varchar(150) collate latin1_general_ci NOT NULL,
`howmany` varchar(150) collate latin1_general_ci NOT NULL,
`price` varchar(150) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Volcar la base de datos para la tabla `tb_clickpack`
--

INSERT INTO `tb_clickpack` VALUES (1, 'hits', '1000', '1');

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

--
-- Estructura de tabla para la tabla `tb_config`
--

CREATE TABLE `tb_config` (
`id` int(11) NOT NULL auto_increment,
`item` varchar(15) collate latin1_general_ci NOT NULL,
`howmany` varchar(15) collate latin1_general_ci NOT NULL,
`price` varchar(150) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;

--
-- Volcar la base de datos para la tabla `tb_config`
--

INSERT INTO `tb_config` VALUES (1, 'click', '1', '0.01');
INSERT INTO `tb_config` VALUES (1, 'referalclick', '1', '0.01');
INSERT INTO `tb_config` VALUES (1, 'premiumclick', '1', '10');
INSERT INTO `tb_config` VALUES (1, 'premiumreferalc', '1', '25');
INSERT INTO `tb_config` VALUES (1, 'hits', '1000', '1');
INSERT INTO `tb_config` VALUES (1, 'hits', '2000', '2');
INSERT INTO `tb_config` VALUES (1, 'hits', '3000', '3');
INSERT INTO `tb_config` VALUES (1, 'hits', '5000', '5');
INSERT INTO `tb_config` VALUES (1, 'hits', '10000', '10');
INSERT INTO `tb_config` VALUES (1, 'payment', '1', '10.00');
INSERT INTO `tb_config` VALUES (1, 'upgrade', '1', '45.99');
INSERT INTO `tb_config` VALUES (1, 'hits', '500', '0.5');
INSERT INTO `tb_config` VALUES (1, 'hits', '20000', '20');
INSERT INTO `tb_config` VALUES (1, 'hits', '30000', '10');
INSERT INTO `tb_config` VALUES (1, 'hits', '50000', '50');
INSERT INTO `tb_config` VALUES (1, 'hits', '100000', '100');

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

--
-- Estructura de tabla para la tabla `tb_contact`
--

CREATE TABLE `tb_contact` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(150) collate latin1_general_ci NOT NULL,
`email` varchar(150) collate latin1_general_ci NOT NULL,
`topic` varchar(150) collate latin1_general_ci NOT NULL,
`subject` varchar(150) collate latin1_general_ci NOT NULL,
`comments` varchar(200) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6 ;

--
-- Volcar la base de datos para la tabla `tb_contact`
--


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

--
-- Estructura de tabla para la tabla `tb_history`
--

CREATE TABLE `tb_history` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(150) collate latin1_general_ci NOT NULL,
`date` varchar(150) collate latin1_general_ci NOT NULL,
`amount` int(150) NOT NULL,
`method` varchar(150) collate latin1_general_ci NOT NULL,
`status` varchar(150) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;

--
-- Volcar la base de datos para la tabla `tb_history`
--

INSERT INTO `tb_history` VALUES (1, 'admin', '', 0, 'paypal', '');

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

--
-- Estructura de tabla para la tabla `tb_messenger`
--

CREATE TABLE `tb_messenger` (
`id` int(11) NOT NULL auto_increment,
`sendfrom` varchar(11) collate latin1_general_ci NOT NULL,
`sendto` varchar(11) collate latin1_general_ci NOT NULL,
`date` varchar(35) collate latin1_general_ci NOT NULL,
`comments` varchar(150) collate latin1_general_ci NOT NULL,
`status` varchar(11) collate latin1_general_ci NOT NULL default 'unread',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;

--
-- Volcar la base de datos para la tabla `tb_messenger`
--

INSERT INTO `tb_messenger` VALUES (23, 'refadmin', 'admin', '09-01-08 03:24', 'hola mi amor', 'read');

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

--
-- Estructura de tabla para la tabla `tb_payme`
--

CREATE TABLE `tb_payme` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(150) collate latin1_general_ci NOT NULL,
`pasword` varchar(150) collate latin1_general_ci NOT NULL,
`email` varchar(150) collate latin1_general_ci NOT NULL,
`pemail` varchar(150) collate latin1_general_ci NOT NULL,
`country` varchar(150) collate latin1_general_ci NOT NULL,
`money` varchar(150) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;

--
-- Volcar la base de datos para la tabla `tb_payme`
--

INSERT INTO `tb_payme` VALUES (7, 'admin', '123456', 'lizaaard@gmail.com', 'lizaaard@gmail.com', '8', '10', '127.0.0.1');

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

--
-- Estructura de tabla para la tabla `tb_refset`
--

CREATE TABLE `tb_refset` (
`id` int(11) NOT NULL,
`howmany` int(5) NOT NULL,
`price` varchar(5) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Volcar la base de datos para la tabla `tb_refset`
--

INSERT INTO `tb_refset` VALUES (4, 50, '35');
INSERT INTO `tb_refset` VALUES (3, 20, '15');
INSERT INTO `tb_refset` VALUES (2, 15, '11');
INSERT INTO `tb_refset` VALUES (1, 10, '8');

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

--
-- Estructura de tabla para la tabla `tb_site`
--

CREATE TABLE `tb_site` (
`id` varchar(11) collate latin1_general_ci NOT NULL,
`sitename` varchar(30) collate latin1_general_ci NOT NULL,
`sitepp` varchar(30) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Volcar la base de datos para la tabla `tb_site`
--

INSERT INTO `tb_site` VALUES ('1', 'YourOwnBux', 'paypal@yourownbux.info');

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

--
-- Estructura de tabla para la tabla `tb_upgrade`
--

CREATE TABLE `tb_upgrade` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(150) NOT NULL,
`pemail` varchar(150) NOT NULL,
`email` varchar(150) NOT NULL,
`status` varchar(150) NOT NULL,
`date` varchar(150) NOT NULL,
`end` varchar(150) NOT NULL,
`ip` varchar(15) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;

--
-- Volcar la base de datos para la tabla `tb_upgrade`
--

INSERT INTO `tb_upgrade` VALUES (22, 'admin', 'lizaaard@gmail.com', 'lizaaard@gmail.com', 'upgraded', '07-01-2008', '07-01-2008', '127.0.0.1');

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

--
-- Estructura de tabla para la tabla `tb_users`
--

CREATE TABLE `tb_users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(15) collate latin1_general_ci NOT NULL,
`password` varchar(100) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
`email` varchar(150) collate latin1_general_ci NOT NULL,
`pemail` varchar(150) collate latin1_general_ci NOT NULL,
`referer` varchar(15) collate latin1_general_ci NOT NULL,
`country` varchar(150) collate latin1_general_ci NOT NULL,
`visits` varchar(150) collate latin1_general_ci NOT NULL default '0',
`referals` varchar(150) collate latin1_general_ci NOT NULL default '0',
`referalvisits` varchar(150) collate latin1_general_ci NOT NULL default '0',
`money` varchar(150) collate latin1_general_ci NOT NULL default '0.00',
`paid` varchar(150) collate latin1_general_ci NOT NULL default '0.00',
`joindate` varchar(150) collate latin1_general_ci NOT NULL,
`lastlogdate` varchar(150) collate latin1_general_ci NOT NULL,
`lastiplog` varchar(150) collate latin1_general_ci NOT NULL,
`account` varchar(150) collate latin1_general_ci NOT NULL,
`user_status` varchar(15) collate latin1_general_ci NOT NULL default 'user',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=20 ;

--
-- Volcar la base de datos para la tabla `tb_users`
--

INSERT INTO `tb_users` VALUES (1, 'admin', '123456', '127.0.0.1', 'lizaaard@gmail.com', 'lizaaard@gmail.com', '', 'Argentina', '0', '0', '0', '0', '0', '1184512264', '1200645980', '127.0.0.1', 'premium', 'admin');

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

--
-- Estructura de tabla para la tabla `users_online`
--

CREATE TABLE `users_online` (
`visitor` varchar(15) collate latin1_general_ci NOT NULL,
`lastvisit` int(14) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Volcar la base de datos para la tabla `users_online`
--

INSERT INTO `users_online` VALUES ('127.0.0.1', 1200646702);


Merci par avance si quelqu'un peut m'aider...
A voir également:

14 réponses

manu_dog Messages postés 518 Date d'inscription   Statut Membre Dernière intervention   41
 
faut que tu créer un tableau dans ta base de donnée mysql
1
manu_dog Messages postés 518 Date d'inscription   Statut Membre Dernière intervention   41
 
oui tu as plusieurs table à créer
1
Phpboost Messages postés 21 Date d'inscription   Statut Membre Dernière intervention   4
 
salut,
1/tu vas dans PHPmyadmin pour importer la base de donnée. Ton hébergeur a du te donner l'adresse. Une fois identifié dedans tu fait importer et tu importe le fichier database.txt . Ensuite les tables de ta base de données seront crées.

2/ Edite /admin/config.php et rentre les identifiants de ta base de donnée que ton hébergeurt'a fourni.

3/ envoie tous les fichiers sur ton serveur FTP

4/ va à l'adresse de ton site avec ton navigateur.

Voila :)
1
Phpboost Messages postés 21 Date d'inscription   Statut Membre Dernière intervention   4
 
ces paramètres te sont donnés par ton hébergeur, c'est ce que tu as utilisé pour te connecter à phpmyadmin., il faut que tu remplaces par les paramètres que t'a donné ton hébergeur localhost / username / password / database
Rien de plus compliqué.
1

Vous n’avez pas trouvé la réponse que vous recherchez ?

Posez votre question
baba37113711
 
Je précise qu'il parrait que ce script peut-etre mit online en quelques minutes...
Si quelqu'un peut m'aiguiller...ce serait simpa
0
baba37113711
 
Merci pour votre réponse manu_dog.

Qu'entendez vous par creer un tableau dans la base de donnée mysql ?
0
baba37113711
 
En gros je dois copier cela avec mes modif dans ma base de donee mysql ?
0
baba37113711
 
Merci pour vos réponses, je vais tenter de trouver comment importer mon fichier sur phpmyadmin...
0
kkdu1
 
quese qil fo pour devenir membre
0
baba37113711
 
Encore quelques questions... Je préfère etre sur que c'est bien comme cela qu'il faut faire....

Voici la page d'acceuil, je selectionne ma base :

<a href="https://app.photobucket.com/" target="_blank"><img src="http://i228.photobucket.com/albums/ee19/baptiste371/acceuilphpmyadmin.jpg" border="0" alt="Photobucket"></a>

Puis, je fait importer, mais le titre a-t-il de l'importance, et que signifie "champs" ??

<a href="https://app.photobucket.com/" target="_blank"><img src="http://i228.photobucket.com/albums/ee19/baptiste371/importphp.jpg" border="0" alt="Photobucket"></a>

Merci par avance, vous me sauvez la vie...
0
baba37113711
 
En fait ma question se pose plus particulierement sur champ... Combien dois-je en mettre et qu'est-ce que c'est ?
0
baba37113711
 
Ok, j'y suis arrivé.

Voici mon config.php

<?php

// Database configuration

$bd_host = "localhost";
$bd_usuario = "username";
$bd_password = "password";
$bd_base = "database";
$url = "https://yoursite.com/";
$con = mysql_connect($bd_host, $bd_usuario, $bd_password); mysql_select_db($bd_base, $con);

?>


Pouvez vous me dire ou faire les modifs et quoi mettre a ces endroits ???
0
baba37113711
 
Merci, mon site est online et marche...
0
skater
 
J'ai le même truc, est-ce que quelqu'un pourrait me dire ce que je fais avec le database.txt. J'ai essayé de le rentrer par phpadmin et voilà :

Erreur

Il semble qu'il y ait une erreur dans votre requête SQL. Le message ci-bas peut vous aider à en trouver la cause.

ERROR: Identificateur invalide @ 167
STR: 5.0.
SQL: -- phpMyAdmin SQL Dump
-- version 2.8.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generaci�n: 18-01-2008 a las 07:01:20
-- Versi�n del servidor: 5.0.21
-- Versi�n de PHP: 5.1.4
--
-- Base de datos: `22`
--

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

--
-- Estructura de tabla para la tabla `tb_ads`
--

CREATE TABLE `tb_ads` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(150) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
`tipo` varchar(150) collate latin1_general_ci NOT NULL,
`visitime` varchar(150) collate latin1_general_ci NOT NULL,
`ident` varchar(150) collate latin1_general_ci NOT NULL,
`fechainicia` varchar(150) collate latin1_general_ci NOT NULL,
`paypalname` varchar(150) collate latin1_general_ci NOT NULL,
`paypalemail` varchar(150) collate latin1_general_ci NOT NULL,
`plan` varchar(150) collate latin1_general_ci NOT NULL,
`bold` varchar(150) collate latin1_general_ci NOT NULL,
`highlight` varchar(150) collate latin1_general_ci NOT NULL,
`url` varchar(150) collate latin1_general_ci NOT NULL,
`description` varchar(150) collate latin1_general_ci NOT NULL,
`category` varchar(150) collate latin1_general_ci NOT NULL,
`members` varchar(150) collate latin1_general_ci NOT NULL default '0',
`outside` varchar(150) collate latin1_general_ci NOT NULL default '0',
`total` varchar(150) collate latin1_general_ci NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;


requête SQL:

-- phpMyAdmin SQL Dump -- version 2.8.1 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost -- Tiempo de generaci�n: 18-01-2008 a las 07:01:20 -- Versi�n del servidor: 5.0.21 -- Versi�n de PHP: 5.1.4 -- -- Base de datos: `22` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `tb_ads` -- CREATE TABLE `tb_ads` ( `id` int(11) NOT NULL auto_increment, `user` varchar(150) collate latin1_general_ci NOT NULL, `ip` varchar(15) collate latin1_general_ci NOT NULL, `tipo` varchar(150) collate latin1_general_ci NOT NULL, `visitime` varchar(150) collate latin1_general_ci NOT NULL, `ident` varchar(150) collate latin1_general_ci NOT NULL, `fechainicia` varchar(150) collate latin1_general_ci NOT NULL, `paypalname` varchar(150) collate latin1_general_ci NOT NULL, `paypalemail` varchar(150) collate latin1_general_ci NOT NULL, `plan` varchar(150) collate latin1_general_ci NOT NULL, `bold` varchar(150) collate latin1_general_ci NOT NULL, `highlight` varchar(150) collate latin1_general_ci NOT NULL, `url` varchar(150) collate latin1_general_ci NOT NULL, `description` varchar(150) collate latin1_general_ci NOT NULL, `category` varchar(150) collate latin1_general_ci NOT NULL, `members` varchar(150) collate latin1_general_ci NOT NULL default '0', `outside` varchar(150) collate latin1_general_ci NOT NULL default '0', `total` varchar(150) collate latin1_general_ci NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;

MySQL a répondu:Documentation
#1046 - No database selected


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

Pourquoi no database selected? J'ai carrément prit le fichier database.txt pourquoi sa ne marche pas
0