aide totale pour mon siteRésolu/Fermé

Question

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 &amp  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...

baba37113711 · Answer

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

manu_dog · Answer

faut que tu créer un tableau dans ta base de donnée mysql

baba37113711 · Answer

Merci pour votre réponse manu_dog.

Qu'entendez vous par creer un tableau dans la base de donnée mysql ?

baba37113711 · Answer

En gros je dois copier cela avec mes modif dans  ma base de donee mysql ?

manu_dog · Answer

oui tu as plusieurs table à créer

Phpboost · Answer

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 :)

baba37113711 · Answer

Merci pour vos réponses, je vais tenter de trouver comment importer mon fichier sur phpmyadmin...

kkdu1 · Answer

quese qil fo  pour devenir membre

baba37113711 · Answer

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 :

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

Merci par avance, vous me sauvez la vie...

baba37113711 · Answer

En fait ma question se pose plus particulierement sur champ... Combien dois-je en mettre et qu'est-ce que c'est ?

baba37113711 · Answer

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

Phpboost · Answer

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é.

baba37113711 · Answer

Merci, mon site est online et marche...

skater · Answer

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&#65533;n: 18-01-2008 a las 07:01:20
-- Versi&#65533;n del servidor: 5.0.21
-- Versi&#65533;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&#65533;n: 18-01-2008 a las 07:01:20 -- Versi&#65533;n del servidor: 5.0.21 -- Versi&#65533;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

Aide totale pour mon site

14 réponses

Discussions similaires

Newsletters