[Release]Auto-rebirth with count system

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?

Quote:

---

Originally Posted by derekgabs

i got the same problem here

---

wew!

i have the same problem here..


what seems to be the problem??

please badly need your help guyz...

already gave you.... here

Code:

---

[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 have this problem...

Quote:

---

Originally Posted by dae67

Code:

---

[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 have this problem...

---

i have the same thing but it is [SQL] 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

[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

what do i do please help :grr:

why would you want auto rebirth... xD

POST 200 WOOT