Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

How to make script (like 1234561 alz for nation) many extra opportunities

Trying to be developer ^^
Loyal Member
Joined
Jul 21, 2010
Messages
1,072
Reaction score
360
Small tutorial how to make auto script in game use
Probably you think, what this idiot dens is talking about? hehe
As you know there are small scripts like for auto nation which work on current value of alz in inventory or warehouse. Most of you probably know how it works and how to change it, but anyway i'll made this tut.

Well ok, all of those scripts will be placed in database in Stored Procedure Server01.dbo.set_cabal_character

As you see on screen, all of our scripts we paste below "SET NOCOUNT ON" and Before "DECLARE ***".
How it works? This procedure is being loaded everytime you login to game, so all what you put here will be executed everytime somene login to game :D Nice yea?

Let's prepare our first function, for ex. when someone will have in inventory 1234561 alz then his nation will be Capella, if 1234562 then Procyon. (this script will be to multiple use, not just when you are without nation)

Code:
IF(@ALZ=1234561)
BEGIN
 SET   [USER=2000193478]Nation[/USER]=1
END
ELSE IF(@ALZ=1234562)
BEGIN
 SET   [USER=2000193478]Nation[/USER]=2
END

It's clear code, should be understandable.

Now click ! Execute and test it in game ;)
By this way u can made many nice things in game for ex nice reset system:
if warehouse alz = 1b then add + 5 dex/int/str points and remove this 1b from warehouse.
If you just use ur mind u can do everything :)
If any problem or question, just ask - i am here to help you guys.
Good luck! :)
 
Last edited:
Elite Diviner
Joined
Jan 3, 2014
Messages
461
Reaction score
49
Re: How to made script (like 1234561 alz for nation) many extra opportunities

can we make like this code for t-point to? example every log out t-point will reset and convert to ecoin.
 
Trying to be developer ^^
Loyal Member
Joined
Jul 21, 2010
Messages
1,072
Reaction score
360
Re: How to made script (like 1234561 alz for nation) many extra opportunities

Yes, you can :)
If first post reach more then 10 likes I will share some awesome scripts :p
And I'll make new tutorial :x
 
Elite Diviner
Joined
Jan 3, 2014
Messages
461
Reaction score
49
Re: How to made script (like 1234561 alz for nation) many extra opportunities

ok i will create 10 id xD
 
Trying to be developer ^^
Loyal Member
Joined
Jul 21, 2010
Messages
1,072
Reaction score
360
Re: How to made script (like 1234561 alz for nation) many extra opportunities

ok i will create 10 id xD

hahah don't be like that :p I don't want those likes because I want to have them more. I don't really care about them. I just want to see that someone really want this, and respect that I trying to share all what I know.
 
Newbie Spellweaver
Joined
Sep 13, 2023
Messages
32
Reaction score
2
Does anyone know how to explain this part, mine is giving me an error
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Sep 13, 2023
Messages
32
Reaction score
2
IF(@ALZ=1234561)
BEGIN
SET Nation=1
END
ELSE IF(@ALZ=1234562)
BEGIN
SET Nation=2
END
keeps giving this error when running the query in sql

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@ALZ".
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '='.
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@ALZ".
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '='.
 
Elite Diviner
Joined
Jun 18, 2023
Messages
436
Reaction score
245
keeps giving this error when running the query in sql

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@ALZ".
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '='.
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@ALZ".
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '='.
Did you put it on the SP? Server01.dbo.set_cabal_character I think you just copy/paste and execute it the New Query.
 
Newbie Spellweaver
Joined
Sep 13, 2023
Messages
32
Reaction score
2
Yes, I did this procedure and it didn't work, it gave me an error! Could you print the correct shape?
 
Newbie Spellweaver
Joined
Jul 19, 2012
Messages
20
Reaction score
0
Guys, I ran it on server01 and it's giving me this error, can anyone help?
 

Attachments

You must be registered for see attachments list
Elite Diviner
Joined
Jun 18, 2023
Messages
436
Reaction score
245
Guys, I ran it on server01 and it's giving me this error, can anyone help?
First, you should know how to read instead of just skipping those information in this thread.

1699641516208 - How to make script (like 1234561 alz for nation) many extra opportunities - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Jul 19, 2012
Messages
20
Reaction score
0
truly friend, I know how to read, but it's not working, I did everything as stated in the topic creator's text. That's why I asked my question to someone who can help me without judging.
 

Attachments

You must be registered for see attachments list
Elite Diviner
Joined
Jun 18, 2023
Messages
436
Reaction score
245
truly friend, I know how to read, but it's not working, I did everything as stated in the topic creator's text. That's why I asked my question to someone who can help me without judging.
It is because you copied from the source which forum made changes due to mention try this instead.

IF(@ALZ=1234561)
BEGIN
SET Nation=1
END
ELSE IF(@ALZ=1234562)
BEGIN
SET Nation=2
END
 
Newbie Spellweaver
Joined
Jul 19, 2012
Messages
20
Reaction score
0
It is because you copied from the source which forum made changes due to mention try this instead.

IF(@ALZ=1234561)
BEGIN
SET Nation=1
END
ELSE IF(@ALZ=1234562)
BEGIN
SET Nation=2
END
I understand, I'm still the same
 

Attachments

You must be registered for see attachments list
Back
Top