MyMuWeb/install.php at master · Vaflan/MyMuWeb · GitHub

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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
<?PHP include('config.php'); $pg=preg_replace("/[^a-zA-Z0-9_-]/",'',$_GET['pg']);?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>MyMuWeb <?echo $mmw[version];?> Install by Vaflan</title>
</head>
<body style="background: #FFFFFF;">
<center>

<?
if($_SERVER[REMOTE_ADDR]!='127.0.0.1' && $_SERVER[REMOTE_ADDR]!=$_SERVER[SERVER_ADDR]) {
 die("$sql_die_start Install only For IP: 127.0.0.1 or LocalHost<br><a href='http://127.0.0.1/install.php'>Go To Normal Install</a> $sql_die_end");
}

// START PAGE
if($pg=='1' || $pg=='') {
 echo "$sql_die_start <small>Install Page 1</small> <br> <b>Welcome To Installer MMW $mmw[version]!</b> <Br> Next Page You Install Table's and Column's<br> <a href='install.php?pg=2'>Next -></a> $sql_die_end";
 $data = "<?PHP \n // MyMuWeb Installed Date \n \$mmw[installed] = '".time()."'; \n?>";
 $install_data = fopen("includes/installed.php",'w');
 fputs($install_data, $data);
 fclose($install_data);
}


// NEXT PAGE
elseif($pg=='2') {
 $md5_select[$mmw[md5]] = 'selected';
 $md5_check = "<select name='md5' title='Set MD5 Option' style='margin:0px;padding:0px;'><option value='yes' $md5_select[yes]>Yes</option><option value='no' $md5_select[no]>No</option></select>";
 $result = @mssql_query("SELECT data_type FROM information_schema.columns WHERE table_name='MEMB_INFO' AND column_name='memb__pwd'");
 $row = @mssql_fetch_row($result);
 if($row[0] == 'varbinary') {$md5_info = "<span style='color:red;'><b>DataBase use MD5 Column!</b></span><br>Please Choose MD5 - Yes.";}
 else {$md5_info = "<span style='color:red;'><b>DataBase don't support MD5!</b></span><br>Please Choose MD5 - No.";}
 echo "$sql_die_start <small>Install Page 2</small> <br> <form name='set_md5' method='post' action='install.php?pg=3'>In 'config.php' Now MD5: $md5_check</form>$md5_info<br> <a href='javascript://' onclick='document.set_md5.submit();'>Next -></a> $sql_die_end";
}


// NEXT PAGE
elseif($pg=='3') {

 if($_POST[md5] != $mmw[md5]) {
  $cfg_file = 'config.php';
  $cfg_open = fopen($cfg_file, "r");
  $cfg_db = fread($cfg_open,filesize($cfg_file));
  fclose($cfg_open);

  $cfg_db = str_replace("\$mmw[md5] = '$mmw[md5]';","\$mmw[md5] = '$_POST[md5]';",$cfg_db);
  $mmw[md5] = $_POST[md5];

  $cfg_write = fopen($cfg_file, "w");
  fwrite($cfg_write, stripslashes($cfg_db));
  fclose($cfg_write);
 }

 echo "$sql_die_start <small>Install Page 3</small> <br> <b>Table's and Column's Install End!</b> [<a href='javascript://' onclick='document.getElementById(\"install_log\").style.display=\"\"'>Show</a>] <Br> Next Page You Create Admin <br> <a href='install.php?pg=4'>Next -></a> $sql_die_end";

 echo "<div style='display:none;' id='install_log' align='center'><textarea style='width: 300px; height: 120px;'>";

 //// CREAT TABLES
 $load_db_mmw = implode('', @file('includes/db_mmw.sql'));

 //// DECODE DATABASE
 $decode_database = "ALTER DATABASE $mmw[database] COLLATE SQL_Latin1_General_CP1251_CI_AS";

 //// INSERT INTO TABLES
 $add_news = "INSERT INTO MMW_news(news_title,news_autor,news_category,news_date,news_row_1,news_row_2,news_id) VALUES ('MyMuWeb $mmw[version] by Vaflan','Vaflan','NEWS','".time()."','[color=red]This Is MyMuWeb $mmw[version] By Vaflan.[/color][br]If you see news, Your site works.[br][i]Thanks For the Use of MyMuWeb![/i]','[color=green]Этот MyMuWeb $mmw[version] От Vaflan.[/color][br]Если ты видишь новость, Твой Сайт Работает.[br][i]Спасибо За Использование MyMuWeb![/i]','MyMuWeb')";
 $add_server = "INSERT INTO MMW_servers(name,experience,drops,gsport,ip,display_order,version,type,maxplayer) VALUES ('Server 1','500x','75%','55901','127.0.0.1','1','1.02k','PVP','100')";
 $add_link = "INSERT INTO MMW_links(l_name,l_address,l_description,l_id,l_size,l_date) VALUES ('MuOnline Media Main','media/main.mp3','This Is Test Link','MyMuWeb','1,13 MB','".time()."')";

 //// PROFILE ADD COLUMNS
 $add_profile = array(
  "ALTER TABLE memb_info add memb__pwd2 varchar(10)",
  "ALTER TABLE memb_info add country int not null default 0",
  "ALTER TABLE memb_info add gender varchar(10)",
  "ALTER TABLE memb_info add age int not null default 0",
  "ALTER TABLE memb_info add y varchar(100)",
  "ALTER TABLE memb_info add msn varchar(100)",
  "ALTER TABLE memb_info add icq varchar(100)",
  "ALTER TABLE memb_info add skype varchar(100)",
  "ALTER TABLE memb_info add avatar varchar(100)",
  "ALTER TABLE memb_info add hide_profile int not null default 0",
  "ALTER TABLE memb_info add ref_acc varchar(10)",
  "ALTER TABLE memb_info add ref_check int not null default 0",
  "ALTER TABLE memb_info add block_date int not null default 0",
  "ALTER TABLE memb_info add blocked_by varchar(100)",
  "ALTER TABLE memb_info add unblock_time int not null default 0",
  "ALTER TABLE memb_info add block_reason nvarchar(100)",
  "ALTER TABLE memb_info add ip nvarchar(15)",
  "ALTER TABLE memb_info add mmw_status int not null default 0",
  "ALTER TABLE memb_info add mmw_coin int not null default 0",
  "ALTER TABLE warehouse add extMoney bigint not null default 0",
  "ALTER TABLE Guild add G_union int not null default 0",
  "ALTER TABLE GuildMember add G_status int not null default 0",
  "ALTER TABLE Character add leadership int not null default 0",
  "ALTER TABLE Character add Reset int not null default 0"
 );

 //// CHANGE COLUMN DATA TYPE
 $change_column = array(
  "ALTER TABLE memb_info ALTER COLUMN memb_name varchar(20)",
  "ALTER TABLE memb_info ALTER COLUMN gender varchar(10)",
  "ALTER TABLE warehouse ALTER COLUMN extMoney bigint not null"
 );


 //Install DataBase
 if(@mssql_query("Use $mmw[database]")){echo "use_$mmw[database] - Done! \n";} else {echo "use_$mmw[database] - Error! \n";}
 if(@mssql_query("$decode_database")){echo "decode_database - Done! \n";} else {echo "decode_database - Error! \n";}
 echo " ----- \n";
 if(@mssql_query($load_db_mmw)){echo "load_db_mmw - Done! \n";} else {echo "load_db_mmw - Error! \n";}
 echo " ----- \n";
 if(@mssql_query($add_news)){echo "add_news - Done! \n";} else {echo "add_news - Error! \n";}
 if(@mssql_query($add_server)){echo "add_server - Done! \n";} else {echo "add_server - Error! \n";}
 if(@mssql_query($add_link)){echo "add_link - Done! \n";} else {echo "add_link - Error! \n";}
 echo " ----- \n";
 for($i=0; $i < count($add_profile); $i++) {
  if(@mssql_query($add_profile[$i])){echo "add_profile_$i - Done! \n";} else {echo "add_profile_$i - Error! \n";}
 }
 echo " ----- \n";
 for($i=0; $i < count($change_column); $i++) {
  if(@mssql_query($change_column[$i])){echo "change_column - Done! \n";} else {echo "change_column - Error! \n";}
 }


 if($mmw['md5']==yes) {
  echo " ----- \n";
  $exec_md5_dll = "exec sp_addextendedproc 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'";
  $md5_encrypt_create = "CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
  RETURNS BINARY(16) AS
  BEGIN
  DECLARE @hash BINARY(16)
  EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
  RETURN @hash
  END";

  if(@mssql_query($md5_encrypt_create)){echo "md5_encrypt_create - Done! \n";} else {echo "md5_encrypt_create - Error! \n";}
  if(@mssql_query("Use master")){echo "use_master - Done! \n";} else {echo "use_master - Error! \n";}
  if(@mssql_query($exec_md5_dll)){echo "exec_md5_dll - Done! \n";} else {echo "exec_md5_dll - Error! \n";}
  echo " ----- \n";
  if(@mssql_query("Use $mmw[database]")){echo "use_$mmw[database] - Done! \n";} else {echo "use_$mmw[database] - Error! \n";}
 }

 echo '</textarea><br>[<a href="javascript://" onclick="document.getElementById(\'install_log\').style.display=\'none\'">Close</a>]</div>';
}


// NEXT PAGE
elseif($pg=='4') {
 $sql = mssql_query("Select memb___id FROM mEMB_INFO");
 $users = "<option value='register'>Need Register</option>";

 for($i=0; $i < mssql_num_rows($sql); ++$i) {
	$row = mssql_fetch_row($sql);
	$users = $users."<option value='$row[0]'>$row[0]</option>";
 }
 echo "$sql_die_start <small>Install Page 4</small> <br> <b>Select User For Admin!</b> <br> <form name='admin' method='post' action='install.php?pg=5'><select name='user'><option value=''>Please Select</option>$users</select> <input type='submit' value='Okey'></form> $sql_die_end";
}


// NEXT PAGE
elseif($pg=='5') {
 $login = $_POST['user'];
 $password = $_POST['pass'];

 if(empty($login)) {
  echo "$sql_die_start <small>Install Page 5</small> <br> <b>No Selected!</b> <br> If you need Admin, go Back <br> <a href='install.php?pg=4'>Back</a> $sql_die_end";
 }
 elseif($login!='register') {
	if($mmw['md5'] == yes && isset($password)) {
		mssql_query("INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,memb__pwd2,fpas_ques,fpas_answ,country,gender,hide_profile,ref_acc) VALUES ('$login',[dbo].[fn_md5]('$password','$login'),'Admin','1234','admin@mmw.net',GETDATE(),GETDATE(),'2008-12-20','2008-12-20','1','0','0','$password','WhoYouAre','admin','0','male','0','0')");
	}
	elseif($mmw['md5'] == no && isset($password)) {
		mssql_query("INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,memb__pwd2,fpas_ques,fpas_answ,country,gender,hide_profile,ref_acc) VALUES ('$login','$password','Admin','1234','admin@mmw.net',GETDATE(),GETDATE(),'2008-12-20','2008-12-20','1','0','0','$password','WhoYouAre','admin','0','male','0','0')");
		mssql_query("INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name,memb_guid,sno__numb,Bill_Section,Bill_value,Bill_Hour,Surplus_Point,Surplus_Minute,Increase_Days) VALUES ('2005','1',1234,'$login','$login',1,'7','6','3','6','6','2003-11-23 10:36:00','0' )");
	}
  mssql_query("UPDATE MEMB_INFO SET [mmw_status]='10' WHERE memb___id='$login'");
  echo "$sql_die_start <small>Install Page 5</small> <br> <b>Admin Created!</b> <br> Now $login is Admin in MyMuWeb <br> <a href='.'>Go To WebSite</a> $sql_die_end";
 }
 else {
  echo "$sql_die_start <small>Install Page 5</small> <br> <form name='admin' method='post' action=''><input name='user' type='text' size='10' maxlength='10' value='Acc'> <input name='pass' type='text' size='10' maxlength='10' value='Pass'> $rowbr <input type='submit' value='New Account'> </form> $sql_die_end";
 }
}
// ERROR
else {
 echo "$sql_die_start Total ErroR! $sql_die_end";
}
?>

</center>
</body>
</html>