[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

Quote:

---

Originally Posted by TyRoXx

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!!!

---

What About this code sir?? Where will I put it?? In the DB? the Site? or somewhere?

Sorry for really asking this much since im not really good at this yet

in navicat....in the left part....under your DB name....queries....click it.....create a new query....paste the rebirth code in it....run it...and save it...

Quote:

---

Originally Posted by shappy23

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

---

i got the same problem here

ok another error..........
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 " at line 1

did you copy the entire code?

yep from the word "begin" untill the word "end"

from CREATE TRIGGER

ok thanks. Finally got it working.. Wohooo.. Thanks Zedawg.. And thanks to the one who made it..

idk who made it...but i modified it ^^

mr. zedawg, do you have any code for the ranking of the rebirths?