Search:

skilleffect.txt ( dont know why )

http://inpanic-community.net/InPic/?img=181588761273.jpg

If i am finish with my other works i will release the Item Switch there.

There is an Exemple from my Shikai to Bankai Switch Tool ( ofc you can also change it for Moon to Sun or any other items )

YouTube : https://www.youtube.com/watch?v=yIM4A297rVc&feature=youtu.be

yes its possible.

Lua Script:

InsertQuestMenuStringList :

"BASIC_MENUSTRING_NOT_PARTY", "SN_TALK_QNO_QUESTNAME_XX"

So you can accept the Quest only if you are in a share/share Party also the "Kill Count" of...

missing dashType ;)

No ! becuse if you create a new "account" and log in , the Server is going to the "Create Char Window" else to the "Character List"

So he got the "error" if CharCount > 0 , so the problem is the...

its 100% a SM_ and CM_ Packet problem ;)

i am sure you have a packet problem ;)

HINT : EU Opcode 0x27 ( for the Castspell Result )

yxc001

Ich glaube ich muss dir hier nix beweissen oder sonstiges es geht hier nur darum das das hier kein Release ist ... und gelöscht gehört , den Query welchen ich gepostet habe macht genau das...

Release ? nice joke thats just a "low query" and why you need 2 Querys ? just SET the CodeName and done ...


USE SRO_VT_SHARD

declare @ItemID int , codename varchar(128)

SET codename =...

sounds like you fucked up the sql-Links so i am sure u get a SQL error at the [Gameserver or another Module ] if yes copy this error there ;)

You need to delete all :

From _Items
With this Query you can see all Pick Pets from the Server


SELECT ID64 , RefItemID , CodeName128 , Data FROM _Items as i
left join _RefObjCommon as roc...

not possible ;)

Hi Murat :D

and ya allrdy Fixed ;)

btw Bad u sure u fix it ? can i try ? ^^

EventID = 19 [Kill Event Winner]
EventID = 20 [Kill Event Loser ]

-- EventID = 23 [Skill Update]
-- EventID = 95 Update (NickName16)
-- EventID = 93 Join Thief Job
-- EventID = 1 and Data1 = 0...

Sure this Bug comes with the Exp/Sp Splitter [ Random on a Levelup ] and a Player Count from 100+
i got the same :)

dont use exp/sp split tool ;)

and pets works without problems ..

No , u understand my Query ?




Update Query :

Update _RefObjChar
set MaxHP = '1000000000'
from _RefObjChar as roch

But you cant over a INT !!!

so max HP = 2.147.483.647

You got the Runetime becuse of a Bug where is Fixed 1-2 Years ago and the other thing is not enought RAM about the 10min Dc ... search for Agentserver xtrap fix ...

@Caosfox about ur idee its not possible Return Scrolls are not logged in the ItemLog :/ rly bad

Try this One



use SRO_VT_SHARD
update _RefObjItem
set Param4 = '20000' , Desc4_128 = 'COOLTIME:0x000000C8'
from _RefObjItem as roi
left join _RefObjCommon as roc on roc.Link = roi.ID...

BadFist you are right about the Crash but only if you add more slots as possible or use this public 5/5 Page Patch :)

But its easy to Fix , HP has nothing todo with Gameserver becuse its caped on...

@BadFist HP is not Based on a Item ;) its Based of _RefObjChar

ItemCode : ITEM_COS_T_WHITEELEPHANT_SCROLL
Cos : COS_T_WHITEELEPHANT_%



Update _RefObjChar
set MaxHP = '1000000000'
from...

@detCode :
He allrdy try but still need todo some edits at ShardManager :P



IF (@ret >= 4)
BEGIN RETURN -2;
END

show me ur _AddNewCos Proc

@magicsux yep i am sure this (trade) crash bug is easy to fix with a stored produce.

LG Kev ..

Nicht Gesendet von meinem Nexus 4 mit Tapatalk :laugh:

no way to change without ASM Skills ;)

its a methode like this

(if PlayerLevel > 9 : noDrops);

ya it works :)

means can create scroll with "all function" :D

ok i check ur idee soon if it works i send to ya ;)

@Caosfox

Thats a rly good idee ;) i write a proc soon hehe

if u got more let me know ^^


edit : maybe its not good becuse the log is creating after use ( so if u teleport fast ) its...

Kidding me ? u made my Day this Query is kida noob like ;)

Its set all Level 1 Chars to Delete ... HAHA what if some make a new Char for Storage Elix ? he will Del to :D

Real Time is the best way ;) ( like AddSilk )
by me it was just a bit "Testing" whats possible :P

some dont have :laugh:

import Brain.Service;

bzw better use some method like me :

[Guild Reset / Job Reset / Adv Remove / Premium Remove / Change Name ]
+ Upgrade Items 11 -> 12 and much...

This Item remove all Adv Elix from all Items !! ;)



/_AddTimedJob (Procedure)
-----------------------------
---------designed by krmfrnc--------------
if(@JobID= '36873') --...

Its so easy to make a Online System ..

Just Log ( Online / Offline ) Players via ( _LogEventChar ) in a Table .. after this Check if the Online Count is >= 60 exec addSilk + Log
...

i got the same problem but why u think about a Skill ? if the skill is enabled in the DB but not in the Client its Crash only Players in the Range but not the the whole Server .

And about Mobs i...

Easy to Fix but ..... last time i help u in a thread you dont say Thx ;)

Easy to Fix .

1. Use this Query :



-- Query by InPanic-Kev
-- www.InPanic-Community.net

Update Tab_RefNest set dwMaxTotalCount = '1' from Tab_RefNest as nest

There have fun put Item on 1. Slot [13] and Use this Query after this Teleport 1 Time ....



USE [SRO_VT_SHARD]
--by Kev / InPanic-Community.net

Declare @CharName Varchar (64)
Declare @Plus...

Good Luck but Open Source = 90% Leecher , dont like it ..

and after some weeks of Open Source i bet this Project goes Closed Source becuse of to much leecher :P
its not the first time .

32787 is not a smallint ! ;)

So u have a Key on JID ? me not :P
but listen if u use this Query


INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES (@UserJID, 600 , 0, 0);


its ok it...

@Aquilius
You are wrong ;) this add to all new players and make a overlap if u create more as 1 Char :P



-----------------------------------------------------------------------------
...

Cant start the Page without the Database ... ?? Where can i download a clean Database for this page ?

1. Fail is :



2. Some Opcodes are wrong ;)
3. Much Opcodes missing ;)

Hello RageZone Community ,

I dont found any Icons for the new Avatar "Steampunk" so i made some :

http://img6.imagebanana.com/img/vp8wme1n/CrazyShot_3.png

.ddj download :...

By Jupiter it is needed not ;)

You dont need [_LinkRefRegions] its not a Region with a Fortress so you dont need to Link it !!

If u Crash :

- Server to BAD ( not enought RAM )
- Wrong [_RefInstance_World_Region]
- missing...