• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

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
http://saintcabal.com/upload/ragezone/1_db.png
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

  • 1697388299336 - How to make script (like 1234561 alz for nation) many extra opportunities - RaGEZONE Forums
    1697388299336.png
    3 KB · Views: 45
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
437
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
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

  • 1699685281175 - How to make script (like 1234561 alz for nation) many extra opportunities - RaGEZONE Forums
    1699685281175.png
    13.8 KB · Views: 28
Elite Diviner
Joined
Jun 18, 2023
Messages
437
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

  • 1699685786511 - How to make script (like 1234561 alz for nation) many extra opportunities - RaGEZONE Forums
    1699685786511.png
    10.4 KB · Views: 34
Back
Top