1.00.16 MU Server+Website+Webshop+SQL in 30 MINUTES!

Nice Guide kirka....and the video too...weird accelerator you have :P
9/10 this guide
Not ten coz you missed some stuff like what happen when ppl already have up the server anb just want use your website??? when them finish following your guide and try to up the website could be have this error:
MuWeb database loading failed! Error #118
An fuzzy error :P , is because they dont have the DB wich connect with your website in MSSQL, so to solve it (just that case) they must run this query to:
CREATE TABLE [MuWeb] (
[webtitle] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[resetmoney] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[pkmoney] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[resetlevel] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[servername] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[client] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[patch] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[launcher] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[serverwebsite] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[resetpoints] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[resetslimit] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[resetmode] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[levelupmode] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[announcements] [text] COLLATE Polish_CI_AS NULL ,
[forum] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[ads] [text] COLLATE Polish_CI_AS NULL ,
[clean_inventory] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[clean_skills] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[store_inbox] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[store_sent] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[msg_length] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[md5] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[show_gm] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[template] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[warp_zen] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[music] [varchar] (50) COLLATE Polish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [MuWeb_admin] (
[username] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[password] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[securitycode] [varchar] (100) COLLATE Polish_CI_AS NULL
) ON [PRIMARY]
GO


CREATE TABLE [MuWeb_events] (
[name] [varchar] (1000) COLLATE Polish_CI_AS NULL ,
[description] [text] COLLATE Polish_CI_AS NULL ,
[date] [varchar] (1000) COLLATE Polish_CI_AS NULL ,
[event_id] [char] (10) COLLATE Polish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [MuWeb_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 ,
[link_date] [varchar] (100) COLLATE Polish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [MuWeb_mail] (
[to_character] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[from_character] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[accountid] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[subject] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[mail_msg] [varchar] (1000) COLLATE Polish_CI_AS NULL ,
[inbox] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[sent] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[read_msg] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[date] [varchar] (100) COLLATE Polish_CI_AS NULL
) ON [PRIMARY]
GO


CREATE TABLE [MuWeb_mail_store] (
[accountid] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[store_inbox] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[store_sent] [varchar] (100) COLLATE Polish_CI_AS NULL
) ON [PRIMARY]
GO


CREATE TABLE [MuWeb_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_date] [varchar] (100) COLLATE Polish_CI_AS NULL ,
[news_id] [varchar] (100) COLLATE Polish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [MuWeb_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


CREATE TABLE [MuWeb_webshop] (
[item_name] [text] COLLATE Polish_CI_AS NULL ,
[item_description] [text] COLLATE Polish_CI_AS NULL ,
[item_price] [varchar] (1000) COLLATE Polish_CI_AS NULL ,
[payment_metod] [text] COLLATE Polish_CI_AS NULL ,
[item_id] [varchar] (1000) COLLATE Polish_CI_AS NULL ,
[item_image] [text] COLLATE Polish_CI_AS NULL ,
[item_date] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[item_class] [varchar] (50) COLLATE Polish_CI_AS NULL ,
[exchange_metod] [text] COLLATE Polish_CI_AS NULL ,
[contact] [text] COLLATE Polish_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

By the way excellentguide!! even a noob cant fail with it!!! bye!!

Quote:

---

Originally Posted by kirka121

or maybe its ur ass ;D

---

duroangelus find too a trojan Mr f***ing

Quote:

---

Originally Posted by kirka121

learn to add and erase mobs manually to the .txt
its same difference as making html pages in a text editor and with dreamweaver.. dreamweaver easier but sux ass.

as for the DB thingi, u need to edit CharPreview column

---

Thx for the information :D...but i don't know nothing about SQL programation...look this code:

Quote:

---

UPDATE [MuOnline].[dbo].[CharPreview]
SET [Name]=<Name,varchar(10),>, [cLevel]=<cLevel,int,>, [Class]=<Class,tinyint,>, [Inventory]=<Inventory,varbinary(84),>
WHERE <Search conditions,,>

---

where do i have to edit to set the points to 0?

i got this error when i try to execute that code:

Quote:

---

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '<'.

---

can u help me?...
thxx!!

just open MSSQL, databases -> muonline -> tables -> PreviewChar or w/e i said the table was. and change by licking with ur mouse
its easy as hell

dude who said i have troyan in a .rar
dude, ur just a noob XD i wont even bother explaining why what ur claiming is impossible

and elche27:
wooot? XD
in one of my vids i showed exactly from 0 to done how the website loads without rorres using the db i provided.
the code u made is kinda useless. unless u wana use that web for different server and db.. but then u just need to get any intall folder from any 0.8 muweb and install it properly.

Quote:

---

Originally Posted by juanmanuelsaad

Thx for the information :D...but i don't know nothing about SQL programation...look this code:



where do i have to edit to set the points to 0?

i got this error when i try to execute that code:



can u help me?...
thxx!!

---

Try run this Query in Analizer, this should finish with the extra point when you create a char....
Attached...copy and paste it on your analizer Good Luck!

Quote:

---

Originally Posted by kirka121

and elche27:
wooot? XD
in one of my vids i showed exactly from 0 to done how the website loads without rorres using the db i provided.
the code u made is kinda useless. unless u wana use that web for different server and db.. but then u just need to get any intall folder from any 0.8 muweb and install it properly.

---

Hahaha :P yes i know and it works 100% your guide but like i said this codes are to the ppl who use other DB [ like me ;) ] and want use your website...
One of the thing wich determinate your server from other server are DB (not as important as GS but....important hehehe)
After run that codes your web works 100%(until now..testing yet) with other DB :D

woot :)

Quote:

---

Originally Posted by elche27

Try run this Query in Analizer, this should finish with the extra point when you create a char....
Attached...copy and paste it on your analizer Good Luck!

---

thx...now, i see rabbits instead of elite yetis? is there some way to put back elite yetis?? o it's just an skin?

Quote:

---

Originally Posted by juanmanuelsaad

thx...now, i see rabbits instead of elite yetis? is there some way to put back elite yetis?? o it's just an skin?

---

Could be an skin or could be that the yetis are replaced for rabbits...
go to monstersetbase and put an elite yeti on lorencia...if you see a rabbit instead elite yeti...Skin (you must donwload an old client and replace the "Monster" folder) either way was replaced the elite yeti (change your devia's monster) :P:sweatdrop

Quote:

---

Originally Posted by elche27

Could be an skin or could be that the yetis are replaced for rabbits...
go to monstersetbase and put an elite yeti on lorencia...if you see a rabbit instead elite yeti...Skin (you must donwload an old client and replace the "Monster" folder) either way was replaced the elite yeti (change your devia's monster) :P:sweatdrop

---

thx man u saved me twice xD i'm going to try replacing monsters skins (easier way for a noob like me :))

Any time! Good luck!! :biggrinth

I have one error: http://www.iphoto.vn/photo/9121/1201345865_600.jpg.
who can help me fix it . I only see a picture of character

well i have redownloaded and reinstalled the MSSQL manager + service...
service is ON but still the local in manager cant connect....
i'm getting desperate now ( waiting for 5 days now )
so please help me.....
thnx in advance

Usefull ;)

Quote:

---

Originally Posted by Azusa

I have one error: http://www.iphoto.vn/photo/9121/1201345865_600.jpg.
who can help me fix it . I only see a picture of character

---

this error occurs when your video card sux... very rare but happens to all 1.4d mains

Thank you! Keep on doing good work!

Quote:

---

Originally Posted by darkelfofdoom

well i have redownloaded and reinstalled the MSSQL manager + service...
service is ON but still the local in manager cant connect....
i'm getting desperate now ( waiting for 5 days now )
so please help me.....
thnx in advance

---

I dont understand too much wich part dont work to you...is this one? take a look to the image...attached
i use:
MSSQL 2000
Window XP
SP2

Good Luck

yeah your right that doesnt connect but i dont know if its a problem but it isnt local here it is loca.... i will reinstall again and make sure it is local :D i will let u know
thnx anywayz

sorry for double post but i needed to show this in new post...

http://i27.tinypic.com/2z9cpqv.png

see?

Translation after the Reason :
The Sql-service doenst exist or the entry to it is refused

kill Vista man......

Hi, i just wanted to ask, what could be if i can't get out of crywolf? I somehow moved there and now can't leave. As i try to leave it by move or leaving map, it disconnects... And when i try to connect back on it says that user is connected... By the way, at first i couldn't even go to crywolf till i changed my ips in X:\MuServer\data\MapServerInfo.dat

Any ideas?

I have another problem =( look my cs_gs and normal Gs gets frozen and don't start...

http://img150.imageshack.us/img150/5...bujofk4.th.jpg

u r going to think that is imageshack web site, but guess what...it's my gs, it do that beacause it's frozen :S

Quote:

---

Originally Posted by juanmanuelsaad

I have another problem =( look my cs_gs and normal Gs gets frozen and don't start...

http://img150.imageshack.us/img150/5...bujofk4.th.jpg

u r going to think that is imageshack web site, but guess what...it's my gs, it do that beacause it's frozen :S

---

wow!! that is a tough one, could be a lot of posibility...

1) //371 2 0 212 63 2 // Elite Soldier this NPC crash your GS when is touch...take off him from monstersetbase
2)one GS from holy (wich was edited by o dont remeber who) crash yor GS when you try to make an alliance with other character
3) some part of your data is mess up (happened to that i change golden invasion place and the GS froze me each hour-time of the event)
4) your PC

i recommend you: make a backup of your data folder and delete it, change it for another withow edit (see if the GS keep frozen) if yes, change your bin folder..if continue, change your GS folder....this way ull find what is provoking your froze...remeber first get rid of that NPC "elite guardian"

Good Luck!!

Quote:

---

Originally Posted by darkelfofdoom

see?

Translation after the Reason :
The Sql-service doenst exist or the entry to it is refused

---

Did u make it work?? If not...try to use MSSQL 2000, like kirka121 show in his amazing guide!! to me is more reliabe!!

Quote:

---

Originally Posted by elche27

wow!! that is a tough one, could be a lot of posibility...

1) //371 2 0 212 63 2 // Elite Soldier this NPC crash your GS when is touch...take off him from monstersetbase
2)one GS from holy (wich was edited by o dont remeber who) crash yor GS when you try to make an alliance with other character
3) some part of your data is mess up (happened to that i change golden invasion place and the GS froze me each hour-time of the event)
4) your PC

i recommend you: make a backup of your data folder and delete it, change it for another withow edit (see if the GS keep frozen) if yes, change your bin folder..if continue, change your GS folder....this way ull find what is provoking your froze...remeber first get rid of that NPC "elite guardian"

Good Luck!!


Did u make it work?? If not...try to use MSSQL 2000, like kirka121 show in his amazing guide!! to me is more reliabe!!

---

thx dude, the problem was in the eventimebags...bad configured =S...same thing happened before just i didn't remember lol hahaa...thx!!

Quote:

---

Originally Posted by juanmanuelsaad

thx dude, the problem was in the eventimebags...bad configured =S...same thing happened before just i didn't remember lol hahaa...thx!!

---

LOL :P once it happened to me too :P bloody hours behind PC :sweatdrop