|
You last visited: Today at 20:39
Advertisement
help~casual
Discussion on help~casual within the EO PServer Hosting forum part of the Eudemons Online category.
08/19/2010, 16:43
|
#1
|
elite*gold: 0 
Join Date: May 2010
Posts: 39
Received Thanks: 39
|
help~casual
i need help.......how to make new casual........i had make a casual query....but when im batch it.....by db broke...
Code:
delete from cq_itemtype where id >= 199020;
delete from cq_itemtype where id >= 199000;
delete from cq_goods where id >= 1999821;
delete from cq_goods where id >= 1999822;
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`) VALUES
( '199020', 'GoldenCoat', '0', '0', '0', '1');
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`) VALUES
( '199000', 'WingRobe', '0', '0', '0', '1');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999821', '1207', '199020', '0');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999822', '1207', '199000', '0');
please check it.... it's correct or not...
|
|
|
|
08/19/2010, 17:31
|
#2
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
|
why not u check it by ur self? its make you learn more about it..
|
|
|
|
|
08/19/2010, 17:56
|
#3
|
elite*gold: 0
Join Date: Nov 2009
Posts: 522
Received Thanks: 628
|
Quote:
Originally Posted by mikhailtbd05
i need help.......how to make new casual........i had make a casual query....but when im batch it.....by db broke...
Code:
delete from cq_itemtype where id >= 199020;
delete from cq_itemtype where id >= 199000;
delete from cq_goods where id >= 1999821;
delete from cq_goods where id >= 1999822;
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`) VALUES
( '199020', 'GoldenCoat', '0', '0', '0', '1');
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`) VALUES
( '199000', 'WingRobe', '0', '0', '0', '1');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999821', '1207', '199020', '0');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999822', '1207', '199000', '0');
please check it.... it's correct or not... |
it should be like this
Code:
delete from cq_itemtype where id >= 199020;
delete from cq_itemtype where id >= 199000;
delete from cq_goods where id >= 1999821;
delete from cq_goods where id >= 1999822;
INSERT INTO `cq_itemtype` VALUES ('199020', 'GoldenCoat', '0', '0', '0', '1', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('199000', 'WingRobe', '0', '0', '0', '1', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999821', '1207', '199020', '0');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999822', '1207', '199000', '0');
|
|
|
|
|
08/20/2010, 11:37
|
#4
|
elite*gold: 0
Join Date: May 2010
Posts: 39
Received Thanks: 39
|
Quote:
delete from cq_itemtype where id >= 199020;
delete from cq_itemtype where id >= 199000;
delete from cq_goods where id >= 1999821;
delete from cq_goods where id >= 1999822;
INSERT INTO `cq_itemtype` VALUES ('199020', 'GoldenCoat', '0', '0', '0', '1', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('199000', 'WingRobe', '0', '0', '0', '1', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999821', '1207', '199020', '0');
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999822', '1207', '199000', '0');
|
when i batch it...
[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 'elete from cq_itemtype where id >= 199020' at line 1
[Err] elete from cq_itemtype where id >= 199020;
[Msg] Finished - Unsuccessfully
|
|
|
|
|
08/20/2010, 12:44
|
#5
|
elite*gold: 0
Join Date: Nov 2009
Posts: 522
Received Thanks: 628
|
Quote:
Originally Posted by mikhailtbd05
when i batch it...
[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 'elete from cq_itemtype where id >= 199020' at line 1
[Err] elete from cq_itemtype where id >= 199020;
[Msg] Finished - Unsuccessfully
|
Thats what i get when i run it
Code:
[SQL] delete from cq_itemtype where id >= 199020;
Affected rows: 1
Time: 0.266ms
[SQL]
delete from cq_itemtype where id >= 199000;
Affected rows: 1
Time: 0.000ms
[SQL]
delete from cq_goods where id >= 1999821;
Affected rows: 2
Time: 0.062ms
[SQL]
delete from cq_goods where id >= 1999822;
Affected rows: 0
Time: 0.000ms
[SQL]
INSERT INTO `cq_itemtype` VALUES ('199020', 'GoldenCoat', '0', '0', '0', '1', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Affected rows: 1
Time: 0.000ms
[SQL]
INSERT INTO `cq_itemtype` VALUES ('199000', 'WingRobe', '0', '0', '0', '1', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Affected rows: 1
Time: 0.000ms
[SQL]
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999821', '1207', '199020', '0');
Affected rows: 1
Time: 0.000ms
[SQL]
INSERT INTO `cq_goods` (`id`,`ownerid`,`itemtype`,`name`) VALUES ( '1999822', '1207', '199000', '0');
Affected rows: 1
Time: 0.000ms
so i think the problem is your navicat version or something like that..
|
|
|
|
|
08/20/2010, 12:48
|
#6
|
elite*gold: 0
Join Date: Jul 2008
Posts: 86
Received Thanks: 186
|
Quote:
Originally Posted by mikhailtbd05
when i batch it...
[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 'elete from cq_itemtype where id >= 199020' at line 1
[Err] elete from cq_itemtype where id >= 199020;
[Msg] Finished - Unsuccessfully
|
Why are you batching it? just query it, and btw you missed the d in delete...
|
|
|
|
|
08/20/2010, 14:39
|
#7
|
elite*gold: 0
Join Date: May 2010
Posts: 39
Received Thanks: 39
|
ooo....thanks....very helpfull
|
|
|
|
 |
Similar Threads
|
For the casual gamers..
07/23/2010 - Battle of the Immortals - 9 Replies
Alright if you are a casual player in this game, you know you will never get to see your toon with cool looking armors or the cool looking pets. So before you ragequit, might as well play around with the files.
Found this:
Harmless Modifying - BOI Wiki
Also there's a UI skin being worked on:
|
Casual Maker
05/19/2010 - EO Weapon, Armor, Effects & Interface edits - 21 Replies
ive been working 3 months on this Casual Maker!!! its 100% complete works perfectly with Vista,XP -- all you need to do is enter a picture with correct X,X and click legs,gloves,armor ect with the tool on the left and it will auto maticly resize and create a casual ready to use! #LinkRemoved - KA HAVE FUN!... if i helped add Thanks please~!!!
ive been working 3 months on this Casual Maker!!! its 100% complete works perfectly with Vista,XP -- all you need to do is enter a picture with correct...
|
[Help]Casual
05/01/2010 - EO PServer Hosting - 4 Replies
hello guys, i need help. i try to add casual at shopping mall, but my casual look refined? why? look like funny,hehehe.. hope you all can help me.. tQ..
|
[Help] About Casual
01/29/2010 - EO PServer Hosting - 15 Replies
who know what wrong with my file...
i think all complete...
but when i use it..
they become other casual..why??:confused:
http://img40.imageshack.us/img40/1305/15940014.jp ghttp://img6.imageshack.us/img6/8247/84087652.jpgh ttp://img138.imageshack.us/img138/9619/96178341.jp g
|
All times are GMT +1. The time now is 20:44.
|
|
![PraDevil[ELITE]'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar1857785_25.gif){kind=avatar}
