[Release]Auto-rebirth with count system

Since tons of ppl are PMing me to have it...i will release it here....

Code:

---

CREATE TRIGGER rebirth before UPDATE ON characters
FOR EACH ROW

begin
                if new.class=16 and new.level=120 then
                    set new.class=16;
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
                if new.class=17 and new.level=120 then
                    set new.class=17;
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
                if new.class=18 and new.level=120 then
                    set new.class=18;
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
                if new.class=19 and new.level=120 then
                    set new.class=19;
                    set new.level=60;
                    set new.rebirths  + 1;
                end if;
                if new.class=20 and new.level=120 then
                    set new.class=20;
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
                if new.class=21 and new.level=120 then
                    set new.class=21;
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
                if new.class=22 and new.level=120 then
                    set new.class=22;
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
                if new.class=23 and new.level=120 then
                    set new.class=23;
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
    end

---

To make it work you need to create a field in your character table

Name -> rebirths
Type ->int
Length -> 11
Decimals -> 0
Allow Null -> No
Default -> 0

then just create a new query....run it...and you are done!!!

Code:

---

if new.class=16 and new.level=120 then
                    set new.class=16;

---

If the class is 16, why set it to 16 again?


And why so long? This should do the same:

Code:

---

CREATE TRIGGER rebirth before UPDATE ON characters
FOR EACH ROW

begin
                if new.class>=16 and new.class<=23 and new.level=120 then
                    set new.level=60;
                    set new.rebirths + 1;
                end if;
    end

---

if you dont need it...dont take it...

This system, with count, release lmanso. The same script

i released it because many ppl are asking me....

i having Problem dud

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 1;
end if;
if new.class=17 and new.level=120 then
set new.class=' at line 8

i already follow ur instrction Sir but thats it

who wants ranking with rebirths???Say Me....Need Partners also..!!!PM mE!!!

i already have it

Alot of issues.
Also, give the credits to the real scripter.

Quote:

---

Originally Posted by hunter1989

who wants ranking with rebirths???Say Me....Need Partners also..!!!PM mE!!!

---

lol, the ranking wiith rebirths come with my userpanel, I released here:lol:

hello please help me i got an error in using this. sorry to say im still a newbie on this and im just trying to learn.

Where will i put this code??

in navicat at left part click queries...make a new one...paste....run...save...

Quote:

---

Originally Posted by Leimone

Alot of issues.
Also, give the credits to the real scripter.

---

actually idk who made this 1rst

Quote:

---

Originally Posted by zedawg

in navicat at left part click queries...make a new one...paste....run...save...

---

sir i will make a new connection??

no...do that in your current DB