[Fix] Perfect World 1.4.6 v80 BlackSky SQL File

If you were setting up v80 server using the files in MrKiller's thread, Procedures.sql may have produced an error while you imported it into your database. The error came from the fact that someone left out the keyword 'DELIMITER':

Code:

---

Original
use BlackSky$$



CREATE PROCEDURE...

Fixed
use BlackSky;


DELIMITER $$
CREATE PROCEDURE...

---

Download the fixed file and import it.
Attachment 134495

Cheers

RLY ?
http://i.imgur.com/F7ktqLH.jpg

Quote:

---

Originally Posted by Bola

RLY ?
http://i.imgur.com/F7ktqLH.jpg

---

I don't much about mysql syntax, so it wasn't very obvious to me.

eh well at least you took the time to learn it on your own instead of someone telling you, thats what matters most.

While this is not something hard, I do like how you try to help contain the famous 15 questions, which would no doubt have arisen over this topic. If I see somebody asking now, I can bitch at them as how this has already been posted. Yay!

Quote:

---

Originally Posted by Swoosh91

While this is not something hard, I do like how you try to help contain the famous 15 questions, which would no doubt have arisen over this topic. If I see somebody asking now, I can bitch at them as how this has already been posted. Yay!

---

Has anyone tried to ask what the famous 15 questions are?

Low version
pwAdmin not working
ptemplate.conf
General editing of *.data
VM -> Online
Getting released scripts to work
Mounting iso (343 release)
matrixpasswd cache
General backup questions
Server specs
pwAdmin getRole() timeout
GS down questions (when item faulty in elements)
...And others which I can't remember from top of my head.

Your procedures.sql

Code:

---

BEGIN
  DECLARE idtemp INTEGER;
    SELECT IFNULL(MAX(id), 16) + 16 INTO idtemp FROM users;
    INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( idtemp, name1, passwd1, prompt1, answer1, truename1, idnumber1, email1, mobilenumber1, province1, city1, phonenumber1, address1, postalcode1, gender1, birthday1, now(), qq1, passwd21 );
END$$

---

new procedures.sql

Code:

---

BEGIN
  DECLARE idtemp INTEGER;
    SELECT IFNULL(MAX(id), 1008) + 16 INTO idtemp FROM users;
    INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( idtemp, name1, passwd1, prompt1, answer1, truename1, idnumber1, email1, mobilenumber1, province1, city1, phonenumber1, address1, postalcode1, gender1, birthday1, now(), qq1, passwd21 );
END$$

---

http://forum.ragezone.com/f751/relea...-4-5-a-934164/
Allthough your procedures.sql will work, there is a new change to database that is worth considering.

aew bola sou novo aqui no forum e vim aqui porque fabiana falou que vc era o cara que fazia as coisas pw acontecer o.O , então vou logo fala o pro kkk queria saber se ar condições do cliente lug roda o pw 146 v80 pq tentei e ele so dar erros report bug ç.ç vlw

why u arent talk maybe hebrew or latin instead of Portuguese would more funny te istenverte fasztalicska <- that was hungarian

Quote:

---

Originally Posted by argonaut

Your procedures.sql

Code:

---

BEGIN
  DECLARE idtemp INTEGER;
    SELECT IFNULL(MAX(id), 16) + 16 INTO idtemp FROM users;
    INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( idtemp, name1, passwd1, prompt1, answer1, truename1, idnumber1, email1, mobilenumber1, province1, city1, phonenumber1, address1, postalcode1, gender1, birthday1, now(), qq1, passwd21 );
END$$

---

new procedures.sql

Code:

---

BEGIN
  DECLARE idtemp INTEGER;
    SELECT IFNULL(MAX(id), 1008) + 16 INTO idtemp FROM users;
    INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( idtemp, name1, passwd1, prompt1, answer1, truename1, idnumber1, email1, mobilenumber1, province1, city1, phonenumber1, address1, postalcode1, gender1, birthday1, now(), qq1, passwd21 );
END$$

---

http://forum.ragezone.com/f751/relea...-4-5-a-934164/
Allthough your procedures.sql will work, there is a new change to database that is worth considering.

---

I see, the new one have userids that start from 1024 right? I just used the file they included, didn't experience any problems but thanks for the info.

both version are work ... new 1024 is better for " new pwadmin " to show charname in dropdown ...

yup, like i posted the old still works somewhat...but if you look at my link and read the pwAdmin release you will see the importance of such a change...although it is not going to make any difference initially..only if you wish to use this posted release of pwAdmin.

Quote:

---

Originally Posted by Swoosh91

Low version
pwAdmin not working
ptemplate.conf
General editing of *.data
VM -> Online
Getting released scripts to work
Mounting iso (343 release)
matrixpasswd cache
General backup questions
Server specs
pwAdmin getRole() timeout
GS down questions (when item faulty in elements)
...And others which I can't remember from top of my head.

---

how to install
what client to use
..

(well, there's 2 more)

Quote:

---

Originally Posted by Psytrac

how to install
what client to use
..

(well, there's 2 more)

---

+ Server Network error