#Request to remove
iknow that well. but i think it will be helpful for beginners.Quote:
Okay, you failed hard in this one, sorry, I am just being honest. In case you have models for everything, you won't be able to use this. As I said before, use some static code.
haven't a time to read this shits. but to your information the number of lines will be same ;)Quote:
why 192830912831092801 lines when you can make it in 3~5 lines?
wanna see mine? kai here you are.
this should be added to _AddLogItem [Stupids should use brain.exe to get it working]
1- Create table _ModelSwitcher (better than hitting _refobjcommon 129837192 time and cause the query to be slow as fuck)
Table should have 5 COLUMNS : (OLDITEM,NEWITEM,OldItemID,NewItemID,DESC)
add the following lines to _addlogitem
I didn't test this but if there is you tried it and found any mistake do not hesitate contacting me to fix it.
ps: you should add Desc in _ModelSwitcher table, use your brain to get this query working in other items [simple and easy]
@OP: It is procedure not producer ^^
oh you've to thank the person who told you that advice and used your brain.Quote:
this should be added to _AddLogItem [Stupids should use brain.exe to get it working]
so pro menzQuote:
(better than hitting _refobjcommon 129837192 time and cause the query to be slow as fuck)
i wasn't know that information thanks for telling me or telling himQuote:
@OP: It is procedure not producer ^^
too much useless codes ?:@Quote:
why 192830912831092801 lines when you can make it in 3~5 lines?
wanna see mine? kai here you are.
this should be added to _AddLogItem [Stupids should use brain.exe to get it working]
1- Create table _ModelSwitcher (better than hitting _refobjcommon 129837192 time and cause the query to be slow as fuck)
Table should have 5 COLUMNS : (OLDITEM,NEWITEM,OldItemID,NewItemID,DESC)
add the following lines to _addlogitem
I didn't test this but if there is you tried it and found any mistake do not hesitate contacting me to fix it.
ps: you should add Desc in _ModelSwitcher table, use your brain to get this query working in other items [simple and easy]
@OP: It is procedure not producer ^^
DECLARE @ID64 int =(SELECT ID64 FROM _Inventory WHERE CharID = @CharID and Slot = 13)
DECLARE @RefItemID int=(SELECT RefItemID FROM _Items WHERE ID64 = @ID64)
DECLARE @NewItemID int =(SELECT NewRefItemID From _5ara WHERE RefItemID = @RefItemID)
update _Items set RefItemID = @NewRefItemID WHERE ID64=@ID64
He gave the people the basic idea of it and he trying to help the people with procedures what is your problem ?Quote:
why 192830912831092801 lines when you can make it in 3~5 lines?
wanna see mine? kai here you are.
this should be added to _AddLogItem [Stupids should use brain.exe to get it working]
1- Create table _ModelSwitcher (better than hitting _refobjcommon 129837192 time and cause the query to be slow as fuck)
Table should have 5 COLUMNS : (OLDITEM,NEWITEM,OldItemID,NewItemID,DESC)
add the following lines to _addlogitem
I didn't test this but if there is you tried it and found any mistake do not hesitate contacting me to fix it.
ps: you should add Desc in _ModelSwitcher table, use your brain to get this query working in other items [simple and easy]
@OP: It is procedure not producer ^^
awh i felt sorry for you :rolleyes:Quote:
When i wrote it i was gonna make it 2 columns but i remembered that olditemid and newitemid should exist to make it better.
anyone told you that you're stupid before ? yes?Quote:
WHERE THE FUCK IS @NEWREFITEMID DECLARED? HOW THE HELL WILL THIS SHIT WORK? SELECT item which is in slot 13?
my stupid posts i know it hurts alot :(Quote:
What the hell is wrong with you? Why are you always following me with your stupid posts?
prove that, or yeah maybe because you don't have something to say :confused:Quote:
at least i know how to open srv files not like you asking how can i open them.
talking about the past you don't remember your old servers or when you was crying for me to add for you job system.Quote:
-I will not reply, your english will prove everything. At least i'm not a kid who learned english from forums. Don't you remember your past?