well i am some unupdate :P this ver work with sql 2k or 2k5?
Printable View
well i am some unupdate :P this ver work with sql 2k or 2k5?
client where???
This thread needs an up! it's very usefull. sorry if you think it's spam.
i got a problem, it's not really a "problem" it's a DB bug or something like that, the poit is when i create a new character it has 200k of zen and 300 points...does some1 knows how to fix it?? Thx
I need a good monster and monstersetbase editor cuz the one i have is missing the pictures of the maps and it's hard for my to insert new mobs or erase them.
SRY FOR MY BAD ENGLISH! Thx..!!
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
I find a trojan maybe at connect server!
so i knew but just i wonder whats wrong everyone passed this point...
Nice release to the mu online community ! :)
or maybe its ur ass ;DQuote:
Originally Posted by DeaDWiZ
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!!
duroangelus find too a trojan Mr f***ingQuote:
Originally Posted by kirka121
Thx for the information :D...but i don't know nothing about SQL programation...look this code:Quote:
Originally Posted by kirka121
where do i have to edit to set the points to 0?Quote:
UPDATE [MuOnline].[dbo].[CharPreview]
SET [Name]=<Name,varchar(10),>, [cLevel]=<cLevel,int,>, [Class]=<Class,tinyint,>, [Inventory]=<Inventory,varbinary(84),>
WHERE <Search conditions,,>
i got this error when i try to execute that code:
can u help me?...Quote:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '<'.
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.
Try run this Query in Analizer, this should finish with the extra point when you create a char....Quote:
Originally Posted by juanmanuelsaad
Attached...copy and paste it on your analizer Good Luck!