avatar_Satoshi

DEW: проблема с установкой

Автор Satoshi, 2012 Март 20, 17:43

« назад - далее »

0 Пользователи и 1 гость просматривают эту тему.

Вниз Страницы1
Ключевые слова [SEO] mu onlinedewнастройкиустановкаdeathless engine web dew

Satoshi

2012 Март 20, 17:43 Последнее редактирование: 2023 Март 24, 12:22 от Everybody
При установке сайта пишет:
Спойлер
Can't create DEW_ban_log table
Can't create DEW_ban_ip table
Can't create DEW_mmotop table
Can't create MEMB_CREDITS table
Can't create DEW_market table
и тд..
[свернуть]
Данные таблицы в базе MuOnline отсутствуют как после установки, так и до неё.
Настройки к базе в config.php верные. Грешил на то, что файрвол не даёт поставить инсталлу таблицы в базу, отключил файрвол - проблема осталась.
Так же запускал и через localhost/webinstall.php - результат тот же..
Кто знает как исправить данную проблему - подскажите пожалуйста.

NexusMDMTeam

#1
2012 Март 20, 21:33


установи через паблик рилиз.

Axijlec

#2
2012 Июнь 08, 18:24
А перезалить можно?  Буду благодарен!

sovatar

#3
2012 Июль 03, 20:47
таже тема

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'DEW_ban_ip'. (severity 16) in C:xampphtdocsIncludesSQL.php on line 21

Warning: mssql_query() [function.mssql-query]: Query failed in C:xampphtdocsIncludesSQL.php on line 21

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:xampphtdocsIncludesSQL.php on line 33

токая пишыт

Ctrl

#4
2012 Июль 03, 21:33 Последнее редактирование: 2012 Июль 03, 21:36 от Ctrl
Таблиц у вас в базе не хватает. Я в ручную добавлял и все хорошо было.

sovatar

#5
2012 Июль 03, 23:11
ну блин    что не фватаит мы сами видим как их добавить )    (помог бы) хвастатся любой может  

Ctrl

#6
2012 Июль 04, 00:53
Цитата: sovatar от 2012 Июль 03, 22:11  ну блин  :P  что не фватаит мы сами видим как их добавить ) (tmi)   (помог бы) хвастатся любой может  :rolleyes:
К чему тут хвастаться? Ты не описал нечего какой у тебя Sql стоит и тому подобное. Я тебе похож на человека который через монитор знает о чем ты думаешь и что у тебя на компьютере установлено? Ты сначала опиши,а потом поговорим либо напиши в скайп opium-ua  помогу.

Desmond

#7
2012 Июль 24, 20:28
Руками из webinstall.php выполни запросы.

Sky_

#8
2012 Июль 25, 00:24
Цитата: xaoc1233 от 2012 Июль 24, 19:56  
Спойлер
<?
error_reporting(0);
ob_start('ob_gzhandler');
header('Cache-control: private');

include   'config.php';
class Security {}
class url { function ToArray() {} }
include   'Includes/SQL.php';
include   'Includes/DEW_DB/License.DEW';
?>
<!DOCTYPE HTML PUBLIC  "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="author" content="Deathless">
<meta name="description" content="MU Antrum is the best MU Online server ever! Enjoy your stay!">
<meta name="keywords" content="Deathless, x-mu, forum, mu, online, muonline, blue, mublue, exp, drop, socket, item, server, dark, season, 4, IV, full, 5, V, duel, system, new, best">
<meta name="robots" content="all">
<title>DEW Install</title>
<link rel="shortcut icon" href="favicon.ico">
</head>
<body bgcolor="black">
<table align="center" style="padding: 50px; border: 1px solid white;">
<tr>
<td align="center" style="font-family: Verdana; font-size: 20px; color: white;"><b><span style="color:red;">D</span>eathless <span style="color:red;">E</span>ngine <span style="color:red;">W</span>eb Installation</b></td>
</tr>
<tr>
<td align="center" style="padding: 30px; font-family: Verdana; font-size: 12px; color: white;">

<?php

if($_GET['step'] == 2) {
$script = mssql_query("
CREATE TABLE [dbo].[DEW_ban_log] (
[memb___id] [nvarchar] (50) NOT NULL ,
[blocked_by] [nvarchar] (50) NOT NULL,
[block_time] [nvarchar] (50) NOT NULL ,
[unblock_time] [nvarchar] (50) NOT NULL ,
[block_reason] [nvarchar] (50) NOT NULL ,
) ON [PRIMARY]") OR print "Can't create DEW_ban_log table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_ban_ip] (
[ip] [nvarchar] (50) NOT NULL ,
[blocked_by] [nvarchar] (50) NOT NULL,
[block_time] [nvarchar] (50) NOT NULL ,
[block_reason] [nvarchar] (50) NOT NULL ,
) ON [PRIMARY]") OR print "Can't create DEW_ban_ip table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_mmotop](
[vote_id] [int] NULL,
[vote_time] [varchar](50) NULL,
[vote_ip] [varchar](50) NULL,
[vote_char] [varchar](50) NULL,
[vote_type] [int] NULL
) ON [PRIMARY]") OR print "Can't create DEW_mmotop table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[MEMB_CREDITS] (
[memb___id] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[credits] [int] NOT NULL ,
[sms] [int] not null default 0 ,
[all_cred] [int] not null default 0
) ON [PRIMARY]") OR print "Can't create MEMB_CREDITS table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_market] (
[cat_id] [int] NULL ,
[item_id] [int] NULL ,
[item] [varchar] (32) NULL ,
[serial] [varchar] (50) NULL ,
[price] [varchar] (50) NULL ,
[pay_type] [varchar] (50) NULL ,
[seller] [varchar] (50) NULL ,
[seller_acc] [varchar] (50) NULL ,
[comment] [text] NULL ,
[start_date] [varchar] (50) NULL ,
[end_date] [varchar] (50) NULL ,
[is_active] [varchar] (50) NULL ,
[is_spec_offer] [char] (1) NULL ,
[Warning] [int] not null default 0
) ON [PRIMARY]") OR print "Can't create DEW_market table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_market_history] (
[cat_id] [int] NULL ,
[item] [varchar] (32) NULL ,
[serial] [varchar] (50) NULL ,
[price] [varchar] (50) NULL ,
[pay_type] [varchar] (50) NULL ,
[seller] [varchar] (50) NULL ,
[seller_acc] [varchar] (50) NULL ,
[comment] [text] NULL ,
[start_date] [varchar] (50) NULL ,
[end_date] [varchar] (50) NULL ,
[is_active] [varchar] (50) NULL ,
[sold_date] [varchar] (50) NULL ,
[purchased_by] [varchar] (50) NULL ,
[purchased_by_acc] [varchar] (50) NULL ,
[is_sold] [varchar] (50) NULL ,
[Warning] [int] not null default 0
) ON [PRIMARY]")  OR print "Can't create DEW_market_history table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_smithy_history](
[memb___id] [nvarchar] (50) NOT NULL ,
[cat_id] [decimal](18, 0) NULL,
[item] [varchar](32) NULL,
[buy_date] [varchar](50) NULL,
[price] [varchar](50) NULL,
[pay_type] [varchar](50) NULL
) ON [PRIMARY]") OR print "Can't create DEW_smithy_history table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_profile] (
[username] [nvarchar] (50) NULL ,
[nick] [text] NULL ,
[country] [text] NULL ,
[day] [text] NULL ,
[month] [text] NULL ,
[year] [text] NULL ,
[*censored*] [text] NULL ,
[skype] [text] NULL ,
[icq] [text] NULL ,
[mail] [text] NULL ,
) ON [PRIMARY];")  OR print "Can't create DEW_profile table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_mail] (
[timeof] [nvarchar] (50) NOT NULL ,
[fromwho] [nvarchar] (50) NOT NULL ,
[fromwho_char] [nvarchar] (50) NOT NULL ,
[towho] [nvarchar] (50) NOT NULL ,
[towho_char] [nvarchar] (50) NOT NULL ,
[title] [text] NULL ,
[text] [text] NULL ,
[Readed] [Int] NULL ,
) ON [PRIMARY];")  OR print "Can't create DEW_mail table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_friends] (
[time] [nvarchar] (50) NOT NULL ,
[nick] [nvarchar] (50) NOT NULL ,
[friend_nick] [nvarchar] (50) NOT NULL ,
[text] [text] NULL ,
[accepted] [Int] NULL ,
) ON [PRIMARY];")  OR print "Can't create DEW_friends table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_vote_log] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[link_id] [int] NULL ,
[ip] [varchar] (50) NULL ,
[user_id] [varchar] (50) NULL ,
[click_date] [varchar] (50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_vote_log table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_votereward] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[votelink] [varchar] (50) NULL ,
[votedesc] [varchar] (50) NULL ,
[give_credits] [varchar] (50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_votereward table<br>";
$script=mssql_query("
CREATE TABLE [dbo].[DEW_warehouse](
[AccountID] [varchar](10) NOT NULL,
[Items] [varbinary](5760) NULL,
[number] [int] NULL DEFAULT (1),
) ON [PRIMARY]")  OR print "Can't create DEW_warehouse table<br>";
$script   = mssql_query("
CREATE TABLE [dbo].[DEW_vip](
[login] [varchar](10) NULL,
[end_date] [varchar](50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_vip<br>";

$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum] (
[id] [int] NULL ,
[forum_name] [nvarchar] (50) NULL ,
[last_post_date] [nvarchar] (50) NULL ,
[last_post_by] [nvarchar] (50) NULL ,
[last_topic_id] [int] NULL ,
[last_topic_name] [nvarchar] (50) NULL ,
[is_announce] [int] NULL
) ON [PRIMARY]")  OR print "Can't create DEW_forum table<br>";
$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum_posts] (
[id] [int] NULL ,
[topic_id] [int] NULL ,
[post] [text] NULL ,
[posted_by] [nvarchar] (50) NULL ,
[post_date] [nvarchar] (50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_forum_posts table<br>";
$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum_sys] (
[is_active] [int] NULL ,
[topic_id] [int] NULL
) ON [PRIMARY]")  OR print "Can't create DEW_forum_sys table<br>";
$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum_topics] (
[id] [int] NULL ,
[forum_id] [int] NULL ,
[topic_name] [text] NULL ,
[first_post] [text] NULL ,
[started_by] [nvarchar] (50) NULL ,
[start_date] [nvarchar] (50) NULL ,
[is_locked] [int] NULL ,
[last_post_date] [nvarchar] (50) NULL ,
[last_post_by] [nvarchar] (50) NULL ,
[last_post_id] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]")  OR print "Can't create DEW_forum_topics table<br>";

$script = mssql_query("alter table dbo.character add HideTime varchar(50) not null default 0") OR print "Can't add HideTime column<br>";
$script = mssql_query("alter table dbo.character add Resets int not null default 0") OR print "Can't add Resets column<br>";
$script = mssql_query("alter table dbo.character add Reset_limit int not null default 100") OR print "Can't add Reset_limit column<br>";
$script = mssql_query("alter table dbo.character add GR int not null default 0") OR print "Can't add GR column<br>";
$script = mssql_query("alter table dbo.character add GRTime nvarchar(50) not null default 0") OR print "Can't add GRTime column<br>";
$script = mssql_query("alter table dbo.Character add dynamic_last int not null default 0") OR print "Can't add dynamic_last column<br>";
$script = mssql_query("alter table dbo.Character add position_last int not null default 0") OR print "Can't add position_last column<br>";
$script = mssql_query("alter table dbo.Guild add G_Rating int not null default 0") OR print "Can't add G_Rating column<br>";
$script = mssql_query("alter table dbo.memb_stat add TotalTime int not null default 0") OR print "Can't add TotalTime column<br>";
$script = mssql_query("ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [DF_MEMB_CREDITS_credits] DEFAULT (0) FOR [credits]") OR print "Can't add DF_MEMB_CREDITS_credits column<br>";
$script = mssql_query("ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [PK_MEMB_CREDITS] PRIMARY KEY  CLUSTERED ([memb___id]) ON [PRIMARY]") OR print "Can't add PK_MEMB_CREDITS column<br>";
$script = mssql_query("alter table dbo.MEMB_CREDITS add all_cred int not null default 0") OR print "Can't add all_cred column<br>";
$script = mssql_query("alter table dbo.MEMB_CREDITS add sms int not null default 0") OR print "Can't add sms column<br>";
$script = mssql_query("alter table dbo.memb_info add avatar_link text null") OR print "Can't add avatar_link column<br>";
#$script = mssql_query("alter table dbo.memb_info add char_set nvarchar(100)") OR print "Can't add char_set column<br>";
#$script = mssql_query("alter table dbo.memb_info add date_online int not null default 0") OR print "Can't add date_online column<br>";
$script = mssql_query("alter table dbo.memb_info add ip nvarchar(15)") OR print "Can't add ip column<br>";
$script = mssql_query("alter table dbo.memb_info add blocked_by nvarchar(50) not null default 0") OR print "Can't add blocked_by column<br>";
$script = mssql_query("alter table dbo.memb_info add unblock_time nvarchar(50) not null default 0") OR print "Can't add unblock_time column<br>";
$script = mssql_query("alter table dbo.memb_info add block_reason nvarchar(50) not null default 0") OR print "Can't add block_reason column<br>";
$script = mssql_query("alter table dbo.memb_info add is_not_activated int null default 0") OR print "Can't add is_not_activated column<br>";
$script = mssql_query("alter table dbo.memb_info add activation_code varchar(50) null") OR print "Can't add activation_code column<br>";
$script = mssql_query("alter table dbo.memb_info add ref_acc varchar(100)") OR print "Can't add ref_acc column<br>";
$script = mssql_query("alter table dbo.memb_info add ref_check int not null default 0") OR print "Can't add ref_check column<br>";
$script = mssql_query("alter table dbo.memb_info add mmotop int not null default 0") OR print "Can't add mmotop column<br>";
$script = mssql_query("alter table dbo.memb_info add IsOnline int not null default 0") OR print "Can't add IsOnline column<br>";
$script = mssql_query("alter table dbo.warehouse add extMoney nvarchar(100) null") OR print "Can't add extMoney column<br>";

$insert_base = mssql_query("INSERT INTO DEW_forum_sys ([is_active],[topic_id]) VALUES (1,0)");
$insert_def_forums = mssql_query("DELETE DEW_forum;
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('1','News','1');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('2','Новости','1');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('3','Jaunumi','1');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('4','Events','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('5','Guides','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('6','Questions','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('7','Mistakes','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('8','Offers','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('9','Offtopic','0');");

echo '<div style="padding: 10px; font-family: Verdana; font-size: 14px; color: green;"><b>All needed tables were added!</b></div>';

?>

</td>
</tr>
<tr>
<td>
<form name="form" method="post" action="webinstall.php?step=3">
<table align="center">
<tr>
<td align="center"><input style="background-color: green; color: white; border: 2px solid springgreen; cursor: pointer;" type="submit" name="Submit" value="Delete webinstall.php"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>

<?php

die();
}
if($_GET['step'] == 3) {

?>

<b>webinstall.php was removed!</b>
</td>
</tr>
<tr>
<td align="center"><a style="font-family: tahoma; font-size: 16px; color: green; text-decoration: none;" href="https://<? echo $_SERVER['SERVER_NAME']; ?>/"><b>View installed web!</b></a></td>
</tr>
</table>
</body>
</html>

<?php

unlink("webinstall.php");
die();
}

?>

<form name="form1" method="post" action="webinstall.php?step=2">
<table>
<tr>
<td align="center" style="padding-top: 30px; font-family: Verdana; font-size: 14px; color: white;"><b>If you configured your config.php - click Start Installation</b></td>
</tr>
<tr>
<td align="center" style="padding-top: 20px;"><input style="background-color: green; color: white; border: 2px solid springgreen; cursor: pointer;" type="submit" name="Submit" value="Start Installation"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
<?
$DB->Close();
ob_end_flush();
?>
[свернуть]

пример 1 можна? Допустим как вот Этот Отдельна добавить в ручную -Can't create DEW_ban_log table
После
if($_GET['step'] == 2) {
$script = mssql_query("

допиши USE MuOnline.

Desmond

#9
2012 Июль 25, 00:55 Последнее редактирование: 2012 Июль 25, 00:55 от Desmond
Цитата: xaoc1233 от 2012 Июль 24, 20:56  
Спойлер
<?
error_reporting(0);
ob_start('ob_gzhandler');
header('Cache-control: private');

include   'config.php';
class Security {}
class url { function ToArray() {} }
include   'Includes/SQL.php';
include   'Includes/DEW_DB/License.DEW';
?>
<!DOCTYPE HTML PUBLIC  "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="author" content="Deathless">
<meta name="description" content="MU Antrum is the best MU Online server ever! Enjoy your stay!">
<meta name="keywords" content="Deathless, x-mu, forum, mu, online, muonline, blue, mublue, exp, drop, socket, item, server, dark, season, 4, IV, full, 5, V, duel, system, new, best">
<meta name="robots" content="all">
<title>DEW Install</title>
<link rel="shortcut icon" href="favicon.ico">
</head>
<body bgcolor="black">
<table align="center" style="padding: 50px; border: 1px solid white;">
<tr>
<td align="center" style="font-family: Verdana; font-size: 20px; color: white;"><b><span style="color:red;">D</span>eathless <span style="color:red;">E</span>ngine <span style="color:red;">W</span>eb Installation</b></td>
</tr>
<tr>
<td align="center" style="padding: 30px; font-family: Verdana; font-size: 12px; color: white;">

<?php

if($_GET['step'] == 2) {
$script = mssql_query("
CREATE TABLE [dbo].[DEW_ban_log] (
[memb___id] [nvarchar] (50) NOT NULL ,
[blocked_by] [nvarchar] (50) NOT NULL,
[block_time] [nvarchar] (50) NOT NULL ,
[unblock_time] [nvarchar] (50) NOT NULL ,
[block_reason] [nvarchar] (50) NOT NULL ,
) ON [PRIMARY]") OR print "Can't create DEW_ban_log table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_ban_ip] (
[ip] [nvarchar] (50) NOT NULL ,
[blocked_by] [nvarchar] (50) NOT NULL,
[block_time] [nvarchar] (50) NOT NULL ,
[block_reason] [nvarchar] (50) NOT NULL ,
) ON [PRIMARY]") OR print "Can't create DEW_ban_ip table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_mmotop](
[vote_id] [int] NULL,
[vote_time] [varchar](50) NULL,
[vote_ip] [varchar](50) NULL,
[vote_char] [varchar](50) NULL,
[vote_type] [int] NULL
) ON [PRIMARY]") OR print "Can't create DEW_mmotop table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[MEMB_CREDITS] (
[memb___id] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[credits] [int] NOT NULL ,
[sms] [int] not null default 0 ,
[all_cred] [int] not null default 0
) ON [PRIMARY]") OR print "Can't create MEMB_CREDITS table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_market] (
[cat_id] [int] NULL ,
[item_id] [int] NULL ,
[item] [varchar] (32) NULL ,
[serial] [varchar] (50) NULL ,
[price] [varchar] (50) NULL ,
[pay_type] [varchar] (50) NULL ,
[seller] [varchar] (50) NULL ,
[seller_acc] [varchar] (50) NULL ,
[comment] [text] NULL ,
[start_date] [varchar] (50) NULL ,
[end_date] [varchar] (50) NULL ,
[is_active] [varchar] (50) NULL ,
[is_spec_offer] [char] (1) NULL ,
[Warning] [int] not null default 0
) ON [PRIMARY]") OR print "Can't create DEW_market table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_market_history] (
[cat_id] [int] NULL ,
[item] [varchar] (32) NULL ,
[serial] [varchar] (50) NULL ,
[price] [varchar] (50) NULL ,
[pay_type] [varchar] (50) NULL ,
[seller] [varchar] (50) NULL ,
[seller_acc] [varchar] (50) NULL ,
[comment] [text] NULL ,
[start_date] [varchar] (50) NULL ,
[end_date] [varchar] (50) NULL ,
[is_active] [varchar] (50) NULL ,
[sold_date] [varchar] (50) NULL ,
[purchased_by] [varchar] (50) NULL ,
[purchased_by_acc] [varchar] (50) NULL ,
[is_sold] [varchar] (50) NULL ,
[Warning] [int] not null default 0
) ON [PRIMARY]")  OR print "Can't create DEW_market_history table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_smithy_history](
[memb___id] [nvarchar] (50) NOT NULL ,
[cat_id] [decimal](18, 0) NULL,
[item] [varchar](32) NULL,
[buy_date] [varchar](50) NULL,
[price] [varchar](50) NULL,
[pay_type] [varchar](50) NULL
) ON [PRIMARY]") OR print "Can't create DEW_smithy_history table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_profile] (
[username] [nvarchar] (50) NULL ,
[nick] [text] NULL ,
[country] [text] NULL ,
[day] [text] NULL ,
[month] [text] NULL ,
[year] [text] NULL ,
[*censored*] [text] NULL ,
[skype] [text] NULL ,
[icq] [text] NULL ,
[mail] [text] NULL ,
) ON [PRIMARY];")  OR print "Can't create DEW_profile table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_mail] (
[timeof] [nvarchar] (50) NOT NULL ,
[fromwho] [nvarchar] (50) NOT NULL ,
[fromwho_char] [nvarchar] (50) NOT NULL ,
[towho] [nvarchar] (50) NOT NULL ,
[towho_char] [nvarchar] (50) NOT NULL ,
[title] [text] NULL ,
[text] [text] NULL ,
[Readed] [Int] NULL ,
) ON [PRIMARY];")  OR print "Can't create DEW_mail table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_friends] (
[time] [nvarchar] (50) NOT NULL ,
[nick] [nvarchar] (50) NOT NULL ,
[friend_nick] [nvarchar] (50) NOT NULL ,
[text] [text] NULL ,
[accepted] [Int] NULL ,
) ON [PRIMARY];")  OR print "Can't create DEW_friends table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_vote_log] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[link_id] [int] NULL ,
[ip] [varchar] (50) NULL ,
[user_id] [varchar] (50) NULL ,
[click_date] [varchar] (50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_vote_log table<br>";
$script = mssql_query("
CREATE TABLE [dbo].[DEW_votereward] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[votelink] [varchar] (50) NULL ,
[votedesc] [varchar] (50) NULL ,
[give_credits] [varchar] (50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_votereward table<br>";
$script=mssql_query("
CREATE TABLE [dbo].[DEW_warehouse](
[AccountID] [varchar](10) NOT NULL,
[Items] [varbinary](5760) NULL,
[number] [int] NULL DEFAULT (1),
) ON [PRIMARY]")  OR print "Can't create DEW_warehouse table<br>";
$script   = mssql_query("
CREATE TABLE [dbo].[DEW_vip](
[login] [varchar](10) NULL,
[end_date] [varchar](50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_vip<br>";

$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum] (
[id] [int] NULL ,
[forum_name] [nvarchar] (50) NULL ,
[last_post_date] [nvarchar] (50) NULL ,
[last_post_by] [nvarchar] (50) NULL ,
[last_topic_id] [int] NULL ,
[last_topic_name] [nvarchar] (50) NULL ,
[is_announce] [int] NULL
) ON [PRIMARY]")  OR print "Can't create DEW_forum table<br>";
$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum_posts] (
[id] [int] NULL ,
[topic_id] [int] NULL ,
[post] [text] NULL ,
[posted_by] [nvarchar] (50) NULL ,
[post_date] [nvarchar] (50) NULL
) ON [PRIMARY]")  OR print "Can't create DEW_forum_posts table<br>";
$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum_sys] (
[is_active] [int] NULL ,
[topic_id] [int] NULL
) ON [PRIMARY]")  OR print "Can't create DEW_forum_sys table<br>";
$insert_base = mssql_query("
CREATE TABLE [dbo].[DEW_forum_topics] (
[id] [int] NULL ,
[forum_id] [int] NULL ,
[topic_name] [text] NULL ,
[first_post] [text] NULL ,
[started_by] [nvarchar] (50) NULL ,
[start_date] [nvarchar] (50) NULL ,
[is_locked] [int] NULL ,
[last_post_date] [nvarchar] (50) NULL ,
[last_post_by] [nvarchar] (50) NULL ,
[last_post_id] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]")  OR print "Can't create DEW_forum_topics table<br>";

$script = mssql_query("alter table dbo.character add HideTime varchar(50) not null default 0") OR print "Can't add HideTime column<br>";
$script = mssql_query("alter table dbo.character add Resets int not null default 0") OR print "Can't add Resets column<br>";
$script = mssql_query("alter table dbo.character add Reset_limit int not null default 100") OR print "Can't add Reset_limit column<br>";
$script = mssql_query("alter table dbo.character add GR int not null default 0") OR print "Can't add GR column<br>";
$script = mssql_query("alter table dbo.character add GRTime nvarchar(50) not null default 0") OR print "Can't add GRTime column<br>";
$script = mssql_query("alter table dbo.Character add dynamic_last int not null default 0") OR print "Can't add dynamic_last column<br>";
$script = mssql_query("alter table dbo.Character add position_last int not null default 0") OR print "Can't add position_last column<br>";
$script = mssql_query("alter table dbo.Guild add G_Rating int not null default 0") OR print "Can't add G_Rating column<br>";
$script = mssql_query("alter table dbo.memb_stat add TotalTime int not null default 0") OR print "Can't add TotalTime column<br>";
$script = mssql_query("ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [DF_MEMB_CREDITS_credits] DEFAULT (0) FOR [credits]") OR print "Can't add DF_MEMB_CREDITS_credits column<br>";
$script = mssql_query("ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [PK_MEMB_CREDITS] PRIMARY KEY  CLUSTERED ([memb___id]) ON [PRIMARY]") OR print "Can't add PK_MEMB_CREDITS column<br>";
$script = mssql_query("alter table dbo.MEMB_CREDITS add all_cred int not null default 0") OR print "Can't add all_cred column<br>";
$script = mssql_query("alter table dbo.MEMB_CREDITS add sms int not null default 0") OR print "Can't add sms column<br>";
$script = mssql_query("alter table dbo.memb_info add avatar_link text null") OR print "Can't add avatar_link column<br>";
#$script = mssql_query("alter table dbo.memb_info add char_set nvarchar(100)") OR print "Can't add char_set column<br>";
#$script = mssql_query("alter table dbo.memb_info add date_online int not null default 0") OR print "Can't add date_online column<br>";
$script = mssql_query("alter table dbo.memb_info add ip nvarchar(15)") OR print "Can't add ip column<br>";
$script = mssql_query("alter table dbo.memb_info add blocked_by nvarchar(50) not null default 0") OR print "Can't add blocked_by column<br>";
$script = mssql_query("alter table dbo.memb_info add unblock_time nvarchar(50) not null default 0") OR print "Can't add unblock_time column<br>";
$script = mssql_query("alter table dbo.memb_info add block_reason nvarchar(50) not null default 0") OR print "Can't add block_reason column<br>";
$script = mssql_query("alter table dbo.memb_info add is_not_activated int null default 0") OR print "Can't add is_not_activated column<br>";
$script = mssql_query("alter table dbo.memb_info add activation_code varchar(50) null") OR print "Can't add activation_code column<br>";
$script = mssql_query("alter table dbo.memb_info add ref_acc varchar(100)") OR print "Can't add ref_acc column<br>";
$script = mssql_query("alter table dbo.memb_info add ref_check int not null default 0") OR print "Can't add ref_check column<br>";
$script = mssql_query("alter table dbo.memb_info add mmotop int not null default 0") OR print "Can't add mmotop column<br>";
$script = mssql_query("alter table dbo.memb_info add IsOnline int not null default 0") OR print "Can't add IsOnline column<br>";
$script = mssql_query("alter table dbo.warehouse add extMoney nvarchar(100) null") OR print "Can't add extMoney column<br>";

$insert_base = mssql_query("INSERT INTO DEW_forum_sys ([is_active],[topic_id]) VALUES (1,0)");
$insert_def_forums = mssql_query("DELETE DEW_forum;
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('1','News','1');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('2','Новости','1');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('3','Jaunumi','1');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('4','Events','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('5','Guides','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('6','Questions','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('7','Mistakes','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('8','Offers','0');
INSERT INTO DEW_forum ([id],[forum_name],[is_announce]) VALUES ('9','Offtopic','0');");

echo '<div style="padding: 10px; font-family: Verdana; font-size: 14px; color: green;"><b>All needed tables were added!</b></div>';

?>

</td>
</tr>
<tr>
<td>
<form name="form" method="post" action="webinstall.php?step=3">
<table align="center">
<tr>
<td align="center"><input style="background-color: green; color: white; border: 2px solid springgreen; cursor: pointer;" type="submit" name="Submit" value="Delete webinstall.php"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>

<?php

die();
}
if($_GET['step'] == 3) {

?>

<b>webinstall.php was removed!</b>
</td>
</tr>
<tr>
<td align="center"><a style="font-family: tahoma; font-size: 16px; color: green; text-decoration: none;" href="https://<? echo $_SERVER['SERVER_NAME']; ?>/"><b>View installed web!</b></a></td>
</tr>
</table>
</body>
</html>

<?php

unlink("webinstall.php");
die();
}

?>

<form name="form1" method="post" action="webinstall.php?step=2">
<table>
<tr>
<td align="center" style="padding-top: 30px; font-family: Verdana; font-size: 14px; color: white;"><b>If you configured your config.php - click Start Installation</b></td>
</tr>
<tr>
<td align="center" style="padding-top: 20px;"><input style="background-color: green; color: white; border: 2px solid springgreen; cursor: pointer;" type="submit" name="Submit" value="Start Installation"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
<?
$DB->Close();
ob_end_flush();
?>
[свернуть]

пример 1 можна? Допустим как вот Этот Отдельна добавить в ручную -Can't create DEW_ban_log table

Код Выделить
USE MuOnline

CREATE TABLE [dbo].[DEW_ban_log] (
[memb___id] [nvarchar] (50) NOT NULL ,
[blocked_by] [nvarchar] (50) NOT NULL,
[block_time] [nvarchar] (50) NOT NULL ,
[unblock_time] [nvarchar] (50) NOT NULL ,
[block_reason] [nvarchar] (50) NOT NULL ,
) ON [PRIMARY]
Вверх Страницы1

Похожие темы (5)