1 Attachment(s)
[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
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
Quote:
Originally Posted by
Bola
I don't much about mysql syntax, so it wasn't very obvious to me.
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
eh well at least you took the time to learn it on your own instead of someone telling you, thats what matters most.
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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!
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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?
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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.
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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.
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
why u arent talk maybe hebrew or latin instead of Portuguese would more funny te istenverte fasztalicska <- that was hungarian
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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.
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
both version are work ... new 1024 is better for " new pwadmin " to show charname in dropdown ...
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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.
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
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)
Re: [Fix] Perfect World 1.4.6 v80 BlackSky SQL File
Quote:
Originally Posted by
Psytrac
how to install
what client to use
..
(well, there's 2 more)
+ Server Network error