Register for your free account! | Forgot your password?

You last visited: Today at 21:05

  • Please register to post and access all features, it's quick, easy and FREE!

 

[SQL] Model Switch Procedure

Reply
 
Old   #1


 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,102
Received Thanks: 2,613
[SQL] Model Switch Procedure


How to make the models?
Create a 1:1 copy of the item, change the bsr path at the itemdata_*.txt

I wasn't going to release anything for a while since I am hella busy these days with some real life issues but, some guys wanted this and I saw that other shared stuff and the ideas people have in mind are absolutely giving no sense, I will share this. Whoever wants to use it, go ahead.
Just wanted to let all he goddamn nubs know that the stupid OldID - NewID in the way everyone is doing it, IS A COMPLETE FAIL.

PHP Code:
DECLARE @DEGREE VARCHAR(2) = '10' //ModelType

SELECT MS1.RefItemID
FROM   exBotConfigs
.._AvailableModelSwitchs MS
JOIN   Fayox_Shard
.._Items IT
ON     MS
.RefItemID IT.RefItemID
JOIN   exBotConfigs
.._AvailableModelSwitchs MS1
ON     
CASE 
       
WHEN (PATINDEX('%SKIN%',MS.CodeName128))= //Normal Item Detected
           
THEN (MS.CodeName128 '_SKIN_'[email protected]DEGREE)
       ELSE (
LEFT(MS.CodeName128,(PATINDEX('%SKIN%',MS.CodeName128)+ 4)) + @DEGREE//Previously Switched
           
END MS1.CodeName128   
WHERE ID64 
221347 
The tab looks like that
RefItemID CodeName128
1 ITEM_CODE

-Models must be in this form [NORMALCODE_SKIN_DEGREE]
Now turn this to an update statement and enjoy.
A peek from the table
You must register and activate your account in order to view images.
The whole idea was first made by Elamidas, thanks guys!
Credits: da indian hoe



​Exo is offline  
Thanks
8 Users
Old   #2
 
elite*gold: 0
Join Date: Oct 2014
Posts: 203
Received Thanks: 390
oOoH,i think your procedure better than this.(you made my day -_-)
just a kid trying to act like pro -_-
You must register and activate your account in order to view images.


Storxy_ is offline  
Old   #3


 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,102
Received Thanks: 2,613
Quote:
Originally Posted by Storxy_ View Post
oOoH,i think your procedure better than this.(you made my day -_-)
Actually this is mine, not his!
​Exo is offline  
Old   #4
 
elite*gold: 0
Join Date: Oct 2014
Posts: 203
Received Thanks: 390
Quote:
Originally Posted by Exo View Post
Actually this is mine, not his!
iknow that well, its a joke
You must register and activate your account in order to view images.


Storxy_ is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Aug 2013
Posts: 82
Received Thanks: 34
Quote:
Originally Posted by Aeron* View Post
@STORXY_ PLEASE LEARN
why do you ask stroxy to learn ? and you did it the same way he did it with alot of *****.
you made the same , Old>new -_-
_Miss_AngeL_ is offline  
Thanks
1 User
Old   #6


 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,102
Received Thanks: 2,613
Quote:
Originally Posted by _Miss_AngeL_ View Post
why do you ask stroxy to learn ? and you did it the same way he did it with alot of *****.
you made the same , Old>new -_-
The whole thing can't be done with out updating the RefID of course but, the way you built that table and that procedure is not the best way, the table is huge, the same procedure won't work when switching between models since you defined the id with the Item and not the model. Unlike mine, it will work with both normal/model items. Also your theory won't work in case you want to add more models, you will have to redesign the table and add another column and the new model ids again.
​Exo is offline  
Old   #7
 
elite*gold: 0
Join Date: Oct 2014
Posts: 203
Received Thanks: 390
Quote:
Originally Posted by _Miss_AngeL_ View Post
why do you ask stroxy to learn ? and you did it the same way he did it with alot of *****.
you made the same , Old>new -_-
trying to escape from his **** procedure
he removed the reply.
Storxy_ is offline  
Thanks
1 User
Old   #8


 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,102
Received Thanks: 2,613
@MissAngel, either you be more mature and discuss the whole thing in a proper way or you just ignore this thread and stop starting endless fights that won't get we anywhere.
​Exo is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Apr 2014
Posts: 77
Received Thanks: 13
storxy and exo tried to help the community so aeron what have you done? just giving some bullshits
temo152 is offline  
Thanks
1 User
Old   #10
 
elite*gold: 0
Join Date: Jul 2008
Posts: 66
Received Thanks: 13
Good job man keep that **** up
polizey112 is offline  
Old   #11
 
elite*gold: 0
Join Date: Aug 2013
Posts: 82
Received Thanks: 34
Quote:
Originally Posted by Royalblade* View Post
bahahahahhaahah this sucks so hard, words cannot describe.


Code:
UPDATE	IT
		SET		RefItemID = R1.ID
		FROM	SRO_VT_SHARD.dbo._Items IT
		JOIN	SRO_VT_ROYAL.dbo._MultiModelPossibleItems R
		ON		IT.RefItemID = R.ID
		JOIN	SRO_VT_ROYAL.dbo._MultiModelPossibleItems R1
		ON		CASE 
					WHEN (PATINDEX('%LOOK%',R.Codename128)) = 0 
						THEN (R.Codename128 + '_LOOK' + @NewDegree) 
					ELSE (LEFT(R.Codename128,(PATINDEX('%_LOOK%',R.Codename128)-1)) + '_LOOK' + @NewDegree)  
				END = R1.Codename128
		WHERE	ID64 = @ItemID
That's how I'm doing it. Codename based since its included in the index, thus it'll be in RAM anyways. Which makes it more than fast enough.
huh ? can you explain how those codes looked like the same of yours ?
actually you who coopied them from somewhere..
_Miss_AngeL_ is offline  
Old   #12


 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,102
Received Thanks: 2,613
Quote:
Originally Posted by _Miss_AngeL_ View Post
huh ? can you explain how those codes looked like the same of yours ?
actually you who coopied them from somewhere..
Who said I created the Model Switch thing? If I am not mistaking I saw it or smth like it while being in a meeting with Akasch. No, it's not copied, I don't copy stuff and would never copy akasch I owe him too much already. Just as I told you, this is the most logical way to do it this is why they match.

This is faster, more customizable and smaller than yours.

The whole code is just a simple join and a string replacement, there's nothing to copy there. The idea of doing it that way belongs to him, he was the first one to do it like that.
And in case you didn't notice, I gave credits to Akasch for the whole thing.
​Exo is offline  
Thanks
1 User
Old   #13
 
elite*gold: 0
Join Date: Mar 2015
Posts: 3
Received Thanks: 0
nice sharing thanks
_0x0000 is offline  
Old   #14
 
elite*gold: 480
Join Date: Jan 2012
Posts: 654
Received Thanks: 574
Nice work, thanks Exo.
Justin1337* is offline  
Old   #15
 
elite*gold: 85
Join Date: Feb 2014
Posts: 1,017
Received Thanks: 1,570
Quote:
Originally Posted by Exo View Post
Who said I created the Model Switch thing? If I am not mistaking I saw it or smth like it while being in a meeting with Akasch. No, it's not copied, I don't copy stuff and would never copy akasch I owe him too much already. Just as I told you, this is the most logical way to do it this is why they match.

This is faster, more customizable and smaller than yours.

The whole code is just a simple join and a string replacement, there's nothing to copy there. The idea of doing it that way belongs to him, he was the first one to do it like that.
And in case you didn't notice, I gave credits to Akasch for the whole thing.
This.


Royalblade* is offline  
Thanks
2 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
Procedure
resert skills > status > remove premium ? any one got right Procedure? ?
2 Replies - SRO PServer Ask the Experts
[Model Remove] Switch Lag Fix (Exult Flyff)
u mirin?
12 Replies - Flyff Hacks, Bots, Cheats, Exploits & Macros
Model viewer und model dateien finden und in cinema 4d importieren
Hallo Ich würde gerne mir die Aion Models fuer ein anderes Game nehmen und diese in cinema 4d importieren. Bisher habe ich die .pak datei...
1 Replies - Aion Main - Discussions / Questions
Weapon model switch problem...
Hallo :) Ich wollte mal etwas weiter editieren und habe versucht eine Dragunov in ein messer (m11/tracker knife/usw...) zu verwandeln, da man so kein...
6 Replies - Combat Arms



All times are GMT +1. The time now is 21:05.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.