Problème query création de tables sous PHP

[DjSoulz]

Bonjours,

j'essai de faire un script d'installation pour un cms mais le probleme c'est que lorsque je l'execute il ne fait que la premiere query et ensuite il dit qu'il y a une erreur alors que la query est bien executé, alors, les autres ne se fond pas.

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
IF ($_GET['step'] == "3") {
require('../config.php3');
echo '<center>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
echo '<br>';
mssql_connect($config['KalWeb']['servername'], $config['KalWeb']['username'], $config['KalWeb']['password']) OR exit('Unable to etablish a connexion');
mssql_select_db($config['KalWeb']['dbname']) OR exit('Can\'t select the database');
mssql_query("CREATE TABLE [kalweb_about] (
		[id] [int] IDENTITY (1, 1) NOT NULL ,
	[content] [varchar] (8000) COLLATE Danish_Norwegian_BIN NULL
) ON [PRIMARY]") OR die('<b>Query Error, line 98');
mssql_query("CREATE TABLE [dbo].[kalweb_config] (
	[webtitle] [varchar] (100) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[client] [varchar] (100) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[patch] [varchar] (100) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[forum] [varchar] (50) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[ads] [varchar] (250) COLLATE Korean_Wansung_CS_AS NOT NULL ,
	[show_gm] [tinyint] NOT NULL 
) ON [PRIMARY]
GO") OR die('<b>Query Error, line 102');
mssql_query("CREATE TABLE [dbo].[kalweb_news] (
	[news_title] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[news_autor] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[news_category] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[news_context] [text] COLLATE Polish_CI_AS NULL ,
	[news_id] [varchar] (100) COLLATE Polish_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO") OR die('<b>Query Error, line 111');
mssql_query("CREATE TABLE [dbo].[kalweb_links] (
	[link_name] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[link_address] [text] COLLATE Polish_CI_AS NULL ,
	[link_description] [text] COLLATE Polish_CI_AS NULL ,
	[link_id] [varchar] (100) COLLATE Polish_CI_AS NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO") OR die('<b>Query Error, line 119');
mssql_query("CREATE TABLE [dbo].[kalweb_servers] (
	[name] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[experience] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[drops] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[gsport] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[ip] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[display_order] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[version] [varchar] (100) COLLATE Polish_CI_AS NULL ,
	[type] [varchar] (50) COLLATE Polish_CI_AS NULL 
) ON [PRIMARY]
GO") OR die('<b>Query Error, line 126');
mssql_query("CREATE TABLE [kalweb_download] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[link] [varchar] (50) COLLATE Korean_Wansung_CS_AS NULL ,
	[name] [varchar] (60) COLLATE Korean_Wansung_CS_AS NULL ,
	[version] [varchar] (50) COLLATE Korean_Wansung_CS_AS NULL ,
	[descr] [varchar] (1000) COLLATE Danish_Norwegian_BIN NULL 
) ON [PRIMARY]") OR die('<b>Query Error, line 137');
mssql_query("CREATE TABLE [kalweb_rules] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[content] [text] COLLATE Danish_Norwegian_BIN NULL 
) ON [PRIMARY]") OR die('<b>Query Error, line 144');
}

[ETI-trian]

je vais peut etre dire une connerie , mais pourquoi tu ne fais pas tout dans un seul mysql_query ?
sinon je pense que le probleme vient du code SQL.

[DjSoulz]

c'est mssql et non mysql,
grosse différence entre les 2

[ETI-trian]

ca reste du SQL ? non ?
et les fonctions sont les memes hors mis quelque différences ...