How to create new column in Character table?
Printable View
How to create new column in Character table?
it dosnt work for me :(
it says some error with Reset or something and i dont know what to do i tried to use your hint... but dont got it :/
Hi lifestealer
I have had these problem for very long time! pls help me! I want to play Mu with my brothers, and I have downloaded frienzMu server and client patch! but when I run the server ( I have change ip from 1270.0.1 to local ip 192.168.100.222), it show that "skills files not found". And I don't know how to configure the client in order to connect to server. And pls tell me how to create account( also gm account).
I really need your help! pls pls pls help me!
Thanks in advance!
I'm needing Mu Launcher for 1.1e and guide to set up Mu Launcher!
for 99.62 works?
Quote:
Originally Posted by LifeStealer
THIS RESETS TYPE FOR 1.0N SERVER???? TNX CYA LATER
Left click on character => design table => in column Reset disagree box "alow nuls", and in table "columns" edit default value to "(0)"Quote:
Originally Posted by Zagzagel
Your reset column should be int with (0) as default value.Quote:
Originally Posted by Zagzagel
AutoReset (level 350-380) Script [SQL]
added reset level limit from LifeStealer guide: http://forum.ragezone.com/guides/gui...ls-137262.html
This Guide will show you how to make an AutoReset Script using SQL Server Agent.
Let's Start! Go And Create a new Job:
1)Start>All Programmes>Microsoft SQL Server>Enterprise Manager.
2)Then Find "Management" Double Click There.
3)And then double click to SQL Server Agent.
4)Then Right Click on "Jobs" and select "New Job...".
5)Name It "AutoReset" , Category: [Uncategorized (Local)] and Owner "sa" and Description: "AutoResetSciprt".
6)Then Click in "Steps" and press "New..." ,Then put as Step Name: "AutoReset" and Type: "Transact-SQL Script (TSQL) and Database: "MuOnline".
7)Then as Command you have to put the Codes given below.
8)After that you have inserted the Code press "Apply" and "Ok".
9)Then go to Schedules and Click "New Schedule..." ,as name put "AutoReset" and press "Change" then change it to occurs: "Daily" every "1 Day(s)",
10)And then select "Occurs every" and change "1 Hour(s) to 1 Minute(s)" 11)Then click on "Start Date" and select the Day Before the one that is there.For example if it 12/02/2006 you selest 11/02/2006.
12)And final leave the "No End Date" and Click "Ok" 2 times and then "Apply" and "Ok" again.And you are DONE!
Notes:
AutoReset Lvl=350 to 380 (level 381 to 400 AutoReset is disabled, intended for maxed stats Characters)
Additional Points(Per Reset)= 2094 (=6 points x 349 levels for DK,BK,DW,SM,ELF,ME), 2443 (=7 points x 349 levels for MG,DL)
Reset Cost=100Millions (Each Reset)
Reset Limit=100Resets
Stats=Goes Back To Normal
Character=AutoWarp to Lorencia/Noria
Character MagicSpellList=Stays (no need to buy scrolls again)
Character Inventory=Items Stays (no need to remove items on your inventory)
Additional Pk Clear (Each Character) is removed (Pk reset manually on the web)
Class 16 is Dark Kight
Class 17 is Blade Knight
Class 0 is Dark Wizard
Class 1 is Soul Master
Class 32 is Elf
Class 33 is Muse Elf
Class 48 is Magic Gladiator
Class 64 is Dark Lord
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2094 * (Resets + 1), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Chinese_PRC_CI_AS
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2094 * (Resets + 1), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2094 * (Resets + 1), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2443 * (Resets + 1), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE (class = 48) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 2443 * (Resets + 1), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Leadership = 26, Money = Money - (100000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE (class = 64) AND (clevel >= 350) AND (clevel <= 380) AND (Money >= (100000000)) AND (ConnectStat = 0) AND (Resets < 100);
my server version 1.01e+ its frienzmu files in my server dark-lord can not reset!!
the code for for all other character but dark lord dont work
This is a check if the char is online.Quote:
Originally Posted by serhio_forever
What i must write in "Command"?
please script for 6 DB..
nice... :))) tnx
10x man good guide
wow
Help me create script who need cleare all inventory - then reset
where is error?Code:UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Inventory = NULL);
Can someone create script where stat stays ??? Because all people in my mu don't like when they do reset and stats erasing
guys, i have a question about this
ConnectStat = 0
this means that the user will be resetted when he's not online, right
my question is if it is possible that the character will be resetted whether he is online or not by removing this ConnectStat = 0
so that the last part of the script will be
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (50000000)) AND (Inventory = NULL)
is this possible?
dude I have problem with ODBC...
gives mi this error:
'Character' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'Reset', table 'MuOnline.dbo.Tmp_Character'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
PLSS help...
Impossible.Quote:
Originally Posted by jduval
tnx for the info man..
Hmm, can someone please give me script for this one -> After reset stats goes back normal, 300 points 1st reset, 600 2nd and so on, Reset cost 200kk. ThanQ ;)
Edit: 1st res - 350 lvl, 2nd - 352, 3rd - 353, 4th - 354 and so on :P
SET clevel = 1, and SET clevel=('1'), are the same ??
How make auto reset script for 5DB? Me_Muonline And Muonline... Now I Have Memb_Info Bug :(