[Release] Newly created Character with starting items [ SQL Query Script]

[ScriptKid]

always check your serial

 

[DooMDesigN]

no, create char and update inventory then
i use good. how's about your code?

it works just fine, tested on S6E3 with single db (MuOnline)

can someone post a code for summy and rf? kinda lazy to work with script and coding.

 

[the_surfer]

always check your serial

i got it working now.. the problem is on my item(new).txt

the weapons is not enabled on that char.. now my problem is on rage fighter.. i cant put items, even 1 xD

i did the same procedure..

 

[ScriptKid]

i got it working now.. the problem is on my item(new).txt

the weapons is not enabled on that char.. now my problem is on rage fighter.. i cant put items, even 1 xD

i did the same procedure..

please paste your code here. and ill check it

 

[DooMDesigN]

i got it working now.. the problem is on my item(new).txt

the weapons is not enabled on that char.. now my problem is on rage fighter.. i cant put items, even 1 xD

i did the same procedure..

you must only put the code of ragefighter's weapon to make it work.

 

[19871986]

can you explain a little pls , how items system working on DB,

for example a few items in vault how will be look ?
and whats mean FFFFF its empty ?

thats im asking for i want to make somethink with if vault have a few items how i will add new item to free slot ?

 

[ScriptKid]

FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF is Empty. You mean you want to have something in Vault?

 

[ScriptKid]

Bump bump bump

 

[lexa111]

one more way
Create new items for character Open Sql Query Analyze-MuOnline-User Tables
Open dbo.Character and Copy Inventory code
And Open dbo.DefaultClassType and To replace Inventory (and to replace a code, which dbo.Character)
Work 100 % ))

Add you post))

 

[Taurus2001]

How to make only first character created have item??? and How to make those item in inventory not in equipment???

This will work only for first created characters, on a new fresh DB, and the new characters will receive in inventory (not equipment) for eg: exe scale/plate set, 1 weapon,rings and pendant, with 3 opt and 3000 level up points if i remember correct, tested on Season3 Episode1, with mumaker 1.3, SQL2000. Here we go:
IMPORTANT : you must do the test after put this in your DB to see if the poop works.
1. Use some editor , example CzF editor, or mumaker(recommanded), make a new character BK or don't matter
2. Add the items that you want to have
3. Save the character
4. Go to Enterprise manager>MuOnline>Tables>Character>Inventory
5. Copy the script from your character (this will upgrade all BK's with the same items)
6. Insert the script in Query Analizer by changing this code down with your codes
7. Do the same thing for other classes!

I attached a text document for SQL, script that you must replace in your DB. This script will make all new born DW,DK,ELF,MG and DL with set, weapon+schield, rings+pendant and 3000 level up points for start (as i said if i remember correct).

PS : I don't know who to put in credits cuz i don't remember from where i got this info, so i leave the poop as it is for the moment. I hope many people will find this very useful and that is more important than credits. Good luck.

 

[ScriptKid]

nice script there

 

[OmnitrickS]

I made my code but when i try to move or use the items game disconnect by saying its duped.

Solution? This is the code

USE MuOnline
UPDATE DefaultClassType
SET Inventory = 0x01EF48C0B1A90060002000000000000001EF48C0B1A900600020000000000000056F4DC0B1A900480070000000000000056F4DC0B1A900480080000000000000056F4DC0B1A900480090000000000000056F4DC0B1A9004800A0000000000000056F4DC0B1A9004800B0000000000000026FE8C0B1A9004000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0B60003E93A9000000E00000000000000B60003E93A9000000E0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
WHERE Class = '16'

 

[Taurus2001]

I made my code but when i try to move or use the items game disconnect by saying its duped.

maybe you are using a noncompatible mu editor, or the sql script isn't good ... try mumaker 1.3

@ScriptKid - thanks

 

[blackdovevn]

I made my code but when i try to move or use the items game disconnect by saying its duped.

Solution? This is the code

Use special serial or u make a query in ur website : newbie gift code, a function for create random serial and replace original serial ( for no duplicate serial ).

my english is not good.

 

[ScriptKid]

as i said this items dont have a unique serial so if you put like 2 legendary sword make sure you make 2 serials

 

[ftewegw1]

I made my code but when i try to move or use the items game disconnect by saying its duped.

Solution? This is the code

ofc they are duped,what taurus suggested you did is stupid, you have to use a script that fills in serial numbers(weapons,etc) to the table attributes each time a table instance is created
that means you have to find out which bytes are different between same items (that would be the unique id of the item) and make an algorithm that generate different values for each of these items upon character table creation
what you did is make an item on a char(btw not only the item but also the char will have problems with this) and then copy paste the same data to the default data table format,thus generating the same item upon character creation, over and over again(efinition of duping i think?)
now advise: dont mess with the sql and the databases if you dont want everything to get f***** up
know what you're doing or dont do it at all

 

[ScriptKid]

my suggestion is create an item with -J so it cannot be trade.

 

[clerigz]

sir scriptkid do you have a query of Creating Dropable Rings for Starters i'm using TT 11.11.82....

because i getting some error when applying this tut http://forum.ragezone.com/f196/creating-dropable-rings-starters-154882/

because when i apply that all the iventory have a kris.

 

[ScriptKid]

Bump!

 

[clerigz]

me too when i create some script like this it will be dupe.. for example when you remove the items in your inventory and put it in the vault its become dupe.. this is my script

Use [MuOnline]
UPDATE DefaultClassType
SET Inventory = 0x0EE8615B5583002000000000000000000EE8615B5583002000000000000000000168735B5583002000700000000000000168735B5583002000800000000000000168735B5583002000900000000000000168735B5583002000A00000000000000168735B5583002000B00000000000000268E85B5583000000C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14101E000000000000D000000000000014081E000000000000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
WHERE Class = '16'