Mu-Online

Pentru a juca Mu-Online este recomandat un P3 800 mhz , 256 rami , GCard 32 mb 3D !

use muonline
if exists(select * from dbo.sysobjects where type='p' and name='WZ_GetItemSerial')
drop procedure WZ_GetItemSerial
go
CREATE procedure WZ_GetItemSerial
as
BEGIN
DECLARE @ItemSerial int
set nocount on
begin transaction
update GameServerInfo set @ItemSerial = ItemCount = (case when ItemCount < 0x7effffff then ItemCount+1
else 1
end )
if(@@error <> 0)
begin
rollback transaction
select-1
end
else
begin
commit transaction
select @ItemSerial
end
END
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trg_CheckSameID]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[trg_CheckSameID]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AllItemsLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AllItemsLog]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CopyLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CopyLog]
GO
CREATE TABLE [dbo].[AllItemsLog] (
[items_id] [int] IDENTITY (1, 1) NOT NULL ,
[items_type] [binary] (1) NOT NULL ,
[items_serial] [binary] (4) NOT NULL ,
[items_acid] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[CopyLog] (
[copy_id] [int] IDENTITY (1, 1) NOT NULL ,
[copy_acid] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[copy_whdata] [binary] (1200) NOT NULL ,
[copy_date] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AllItemsLog] ADD
CONSTRAINT [DF_CT_ITEM_item] DEFAULT (0) FOR [items_type],
CONSTRAINT [DF_CT_ITEM_itemid] DEFAULT (0) FOR [items_serial],
CONSTRAINT [DF_CT_ITEM_itemrole] DEFAULT ('\') FOR [items_acid]
GO
CREATE INDEX [IX_CT_ITEM] ON [dbo].[AllItemsLog]([items_type], [items_serial]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CopyLog] ADD
CONSTRAINT [DF_CopyLog_copy_date] DEFAULT (getdate()) FOR [copy_date]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE TRIGGER [dbo].[trg_CheckSameID] ON [dbo].[character]
FOR UPDATE
AS
BEGIN
IF UPDATE(inventory)
BEGIN
SET NOCOUNT ON
DECLARE
@wh_acid varchar(10),
@wh_data binary(1200),
@wh_type binary(1),
@wh_serial binary(4),
@cr_user varchar(10),
@cr_acid varchar(10),
@cr_data binary(760),
@cr_type binary(1),
@cr_serial binary(4),
@al_acid varchar(10),
@j int,
@k int,
@find bit
SELECT @cr_acid=i.accountid,
@cr_data=i.inventory
FROM inserted i
SET @j=0
SET @find=0
WHILE @j<76 AND @cr_data IS NOT NULL
BEGIN
SET @cr_type=SUBSTRING(@cr_data,@j*10+1,1)
SET @cr_serial=SUBSTRING(@cr_data,@j*10+4,4)
IF @cr_type<>0xFF AND @cr_serial<>0x00000000
BEGIN
SELECT @al_acid=items_acid FROM allitemslog WHERE items_type=@cr_type AND items_serial=@cr_serial

IF @al_acid IS NULL
INSERT INTO allitemslog (items_type,items_serial,items_acid) VALUES (@cr_type,@cr_serial,@cr_acid)
ELSE
BEGIN
UPDATE allitemslog SET items_acid=@cr_acid WHERE items_type=@cr_type AND items_serial=@cr_serial

SELECT @wh_data=items FROM warehouse WHERE accountid=@al_acid
SET @k=0
WHILE @k<120 AND @wh_data IS NOT NULL
BEGIN
SET @wh_type=SUBSTRING(@wh_data,@k*10+1,1)
SET @wh_serial=SUBSTRING(@wh_data,@k*10+4,4)
IF @wh_type=@cr_type AND @wh_serial=@cr_serial
SET @find=1
SET @k=@k+1
END
END
END
SET @j=@j+1
END
IF @find=1
BEGIN
INSERT INTO copylog (copy_whdata,copy_acid,copy_date) VALUES (@wh_data,@al_acid,getdate())
-- this is wer u can add more punishment like ban or lock characters
UPDATE Character SET CtlCode=1 WHERE accountid=@al_acid
END
SET NOCOUNT OFF
END
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
DECLARE @al_acid char(50)
set @al_acid = 'ASUS'
UPDATE Character SET CtlCode=1 WHERE accountid=@al_acid
go
select * from AllItemsLog
select * from CopyLog

astea se baga in sql

_________________
The best girl in the world!!!

[url=http://mu.dorin1.ro/tosamu/index.php?dir=MuOnline/Main/]Click here to see Main 97 99 1.0 etc..[/url]

_________________
The best girl in the world!!!

[url=http://mu.dorin1.ro/tosamu/index.php?dir=MuOnline/Protection/]Click here for protection[/url]

_________________
The best girl in the world!!!

SQL Server
SQL 2000 Trial
http://www.microsoft.com/downloads/details.aspx?FamilyID=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&DisplayLang=en
-
SQL Server 2000 Evoluation Edition Release A(267MB)
http://download.microsoft.com/download/e/6/e/e6ea2122-5c4d-4a0d-baa8-8138548f9973/SQLEVAL.exe
-
Microsoft SQL Server 2005 Express Edition
http://www.microsoft.com/downloads/info.aspx?na=46&p=3&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=220549b5-0b07-4448-8848-dcc397514b41&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2ff%2f1%2f0%2ff10c4f60-630e-4153-bd53-c3010e4c513b%2fSQLEXPR.EXE&oRef=http%3a%2f%2fwww.microsoft.com%2fsql%2fdownloads%2ftrial-software.mspx
-
Microsoft SQL Server 2005 Enterprise Edition
http://go.microsoft.com/fwlink/?LinkId=55909

_________________
The best girl in the world!!!

[url=http://mu.dorin1.ro/tosamu/index.php?dir=MuOnline/Server%20Editing/]Click here[/url]

_________________
The best girl in the world!!!

[url=http://mu.dorin1.ro/tosamu/index.php?dir=MuOnline/Server%20Admin/]Click here[/url]

_________________
The best girl in the world!!!

Am pus un film facut de mn despre cum sa faci server de mu .. [url=http://rapidshare.de/files/19333175/Cum_sa_faci_server_de_mu_film.avi.html]Click here[/url] am facut..versiunea 99b

http://www.uploadtemple.com/view.php/1155761994.rar - 1.1e
http://rapidshare.de/files/8985653/muserwer.rar.html - 99b
http://rapidshare.de/files/3257327/MuServer1.0.zip.html - 1.00

Continut
Setari ale serverului
-setari experienta
-Setari viata la monstrii
-Setari de drop
-Setari posibilitatea steergerii caracterului

===========[Setari ale serverului]================================

Urmatoarele lucruri se editeaza in D:\muserver\data\commonserver.cfg(deschis cu Notepad sau WordPAd)

Setari ale Experientei

AddExperience = AICI BAGI XP PE CARE O VREI ; % of xp per mob

Setari de viata ale monstrilor

MonsterHp = AICI BAGI VIATA MONSTRILOR 80 ; Daca *** este setat de ex 0 = atunci viata monstrilor este 100% , daca *** este setat la 80 =>viata monstrilor este de 100-80=20%

Aici cam se explica tot de la sine.

Setari ale dropurilor

Gasiti linia :"ItemDroPer".Veti vedea ceva de genu:

ItemDropPer = AICI ITI ALEGI CE DROP VREI SA AI (70 80 90) ; % of Item drops

In loc de *** veti gasi un numar...ala reprezinta dropul serverului...setati dropul cum doriti(daca dropul este setat la 100,pica doar iteme nu si zen!!)

Posibiliatea stergerii de caracter

Gasiti linia :"CharacterDeleteMinLevel".Veti vedea ceva de genu:

CharacterDeleteMinLevel = AICI BAGI LA CE LVL MINIM LA CARE UN CARACTER SA FIE STERS ; caracterele de lvl ***+1 se pot sterge.Ex daca CharacterDeleteMinLevel = 40 atunci caractere de lvl 41 se pot sterge

ATENTIE:Configuratia asta iti poate da serverul peste cap.Fa o copie la GameServer daca nu prea esti destept in ceea ce faci.Aceasta configuratie se face doar cu servu OFFLINE

_________________
The best girl in the world!!!

http://savefile.com/files/246059

_________________
The best girl in the world!!!

/move nick_char numarul_hartii:
Exemplu: /move Qwest 0 130 130 => am aparut in lorencia linga bar
Numerele Hartzilor:
0 = lorencia 125/125 (7-140 secret)
1 = dungeon Level 2: 233/126 Level 3: 3/85 (bullroom:119/46)
2 = dаvias 222/62
3 = noria 176/110
4 = losttower LT1: 208/78 LT3: 86/166 LT5: 130/53 LT7: 8/85
5 = Place of Exile (arata eroare)
6 = Arena 63/160
7 = Atlans 24/19
8 = Tarkan 187/58
9 = Devil Square
10 = Icarus (skycity) Start: 15/13 DPH: 47/205
11 = Blood Castle I Start: 15/13 End: 15/94
12 = Blood Castle II
13 = Blood Castle III
14 = Blood Castle IV
15 = Blood Castle V
16 = Blood Castle VI
17 = Blood Castle VII
18 = Chaos Catle (nu da move)
19 = Chaos Catle (nu da move)
20 = Chaos Catle (nu da move)
21 = Chaos Catle (nu da move)
22 = Chaos Catle (nu da move)
23 = Chaos Catle (nu da move)
24 = Kalima
25 = Kalima
26 = Kalima
27 = Kalima
28 = Kalima
29 = Kalima
30 = Land Of Loren
31 = Land Of Trials 115/135
32 = Devil Squere
33 = Aida
34 = Crywolf
Restul Comenzilor:
/Trace nick_char- va teleporteaza spre acest character
/SetBlock - BAN
/UnsetBlock - UNBAN
/disconnect nick_char - arunca characterul din joaca
/disablechat nick_char - characterul nu poate sa vorbeasca
/enablechat nick_char - characterul poate sa vorbeasca
/GuildMove - ?
/GuildDisconnect - arunca din joaca guildul
/GuildWarEnd - /GuildWarEnd GuildName
/GuildWarStart - /GuildWarStart GUildName
/GuildWarStop - /GuildWarStop GuildName
/Make - Unknown.
/RemainTime - ?
! - mesajul care il vad totzi
/onlinelist - ?
/onlinecount - ?
/whois - ?
/blockvault nick_char - parola la vaultul characterului
/unblockvault nick_char - scoaterea parolei de la vaultul characterului
/guildinfo GuildName informatzie despre acest guild
/kickall - arunca totzi jucatorii de pe server

_________________
The best girl in the world!!!

-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
Find Hack,Bug,Maps,etc..
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

http://www.uploadtemple.com/view.php/1155401423.rar - Find Hack
http://www.uploadtemple.com/view.php/1156288436.rar - Anti AFK
http://www.uploadtemple.com/view.php/1156288468.rar - Anti Blast
http://www.uploadtemple.com/view.php/1156633287.rar - AntiHackFilter+source code
http://www.uploadtemple.com/view.php/1156288680.rar - BigerStadium-Arena2
http://www.uploadtemple.com/view.php/1156632507.rar - Bug Report
http://www.uploadtemple.com/view.php/1156289624.rar - Exile Map
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
WebSites with Upload
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

[30MB] - http://www.uploadtemple.com
[60MB] - http://www.savefile.com
[70MB] - http://www.turboupload.com
[100MB] - http://www.rapidshare.de
[100MB] - http://www.filefront.com
[250MB] - http://www.megaupload.com

-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
Web Sites
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

http://www.uploadtemple.com/view.php/1155675988.rar -WebMu Green
http://www.uploadtemple.com/view.php/1156245810.rar -MuOnline SIlver Webpage
http://files.filefront.com/wwwrar/;5442486;;/fileinfo.html -www
http://www.uploadtemple.com/view.php/1156250875.rar -webcs
http://www.uploadtemple.com/view.php/1155676393.rar -NecroWeb
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------

_________________
The best girl in the world!!!