ERROR in MySql

Page 1 of 2 1 2
08/23/2010 16:59 fotis007#1
Code:
REPLACE INTO `cq_action` VALUES ('950000', '950001', '0000', '0101', '0', 'Hello~There~%user_name~Its~Casino~Time!');
REPLACE INTO `cq_action` VALUES ('950001', '15003', '0000', '0102', '0', 'Are~You~New? 950002');
REPLACE INTO `cq_action` VALUES ('950002', '950003', '0000', '0101', '0', 'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich');
REPLACE INTO `cq_action` VALUES ('950003', '15003', '0000', '0102', '0', 'How~Do~I~Become~Rich? 950004');
REPLACE INTO `cq_action` VALUES ('950004', '950005', '0000', '0101', '0', 'Well~I~Get~10,000kcps~From~There~You~Have~Chaince~To~Lose~It~All,~Gain~Half,~Gain~Doubl,~Or~Hopefully~Hit~JackPot!');
REPLACE INTO `cq_action` VALUES ('950005', '15003, '0000', '0102', '0', 'Can~I~Try? 950006');
REPLACE INTO `cq_action` VALUES ('950006', '950007', '0000', '0101', '0', 'Sure~Thing~%user_name~Hand~Over~10,000[CPS]');
REPLACE INTO `cq_action` VALUES ('950007', '15003', '0000', '0102', '0', 'Here~You~Go! 950008');
REPLACE INTO `cq_action` VALUES ('950008', '950009', '951000', '1001', '0', 'e_money += -10000');
REPLACE INTO `cq_action` VALUES ('950009', '950010', '950011', '0121', '0', '25 125');
REPLACE INTO `cq_action` VALUES ('950010', '951002', '0000', '1001', '0', 'e_money += 50000');
REPLACE INTO `cq_action` VALUES ('950011', '950012', '950013', '0121', '0', '25 100');
REPLACE INTO `cq_action` VALUES ('950012', '0000', '0000', '1001', '0', 'e_money += 20000');
REPLACE INTO `cq_action` VALUES ('951000', '951001', '0000', '0101', '0', 'Ha!~You~Cant~Deceive~Me~%user_name~!~Come~Back~When~You~Have~Enough~[CPS]');
REPLACE INTO `cq_action` VALUES ('951001', '15003', '0000', '0102', '0', 'Sorry~Mr.Casino~Clerk 951003');
REPLACE INTO `cq_action` VALUES ('951002', '958000', '0000', '0125', '2011', 'Wow! %user_name Was So Lucky To Hit The JackPot Of 50,000 [CPS] At The Casino Clerk In Twin City (427,361)');
REPLACE INTO `cq_action` VALUES ('950013', '950014', '950015', '0121, '0', '25 40');
REPLACE INTO `cq_action` VALUES ('950014', '0000', '0000', '1001', '0', 'e_money += 5000');
REPLACE INTO `cq_action` VALUES ('950015', '950016', '950011', '0121', '0', '25 5');
REPLACE INTO `cq_action` VALUES ('950016', '0000', '0000', '1001', '0', 'e_money += 2500');
REPLACE INTO `cq_action` VALUES ('951003', '951004', '0000', '1003', '0', '1002 429 378');
REPLACE INTO `cq_action` VALUES ('951004', '951005', '0000', '0101', '0', 'This~Is~What~You~Get~For~Trying~To~Deceive~Me!~Get~To~Walking!');
REPLACE INTO `cq_action` VALUES ('951005', '15003', '0000', '0102', '0', 'It's~So~Hot! 0');
REPLACE INTO `cq_action` VALUES ('958000', '0000', '0000', '0314', '0', '');

REPLACE INTO `cq_npc` VALUES ('950100', '0', '0', 'Casino9', '0002', '4550', '-1', '1860', '0069', '0068', '950000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?®?‚', '0000', '00', '00', '0000', '00', '0000');

REPLACE INTO `cq_task` VALUES ('950000, 950000, 0000, '', '', 0, 0, 0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950001', '950001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950002', '950002', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950003', '950003', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950004', '950004', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950005', '950005', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950006', '950006', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950007', '950007', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950008', '950008', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950009', '950009', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950010', '950010', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950011', '950011', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950012', '950012', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950013', '950013', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950014', '950014', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950015', '950015', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('950016', '950016', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951000', '951000', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951001', '951001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951002', '951002', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951003', '951003', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951004', '951004', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('951005', '951005', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);
REPLACE INTO `cq_task` VALUES ('958000', '958000', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0);

Error:
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 've~Come~To~Make~You~Rich');
REPLACE INTO `cq_action` VALUES ('
[Err] REPLACE INTO `cq_action` VALUES ('950002', '950003', '0000', '0101', '0', 'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich');
REPLACE INTO `cq_action` VALUES ('950003', '15003', '0000', '0102', '0', 'How~Do~I~Become~Rich? 950004');
REPLACE INTO `cq_action` VALUES ('950004', '950005', '0000', '0101', '0', 'Well~I~Get~10,000kcps~From~There~You~Have~Chaince~To~Lose~It~All,~Gain~Half,~Gain~Doubl,~Or~Hopefully~Hit~JackPot!');
REPLACE INTO `cq_action` VALUES ('950005', '15003, '0000', '0102', '0', 'Can~I~Try? 950006');
[Msg] Finished - Unsuccessfully
08/23/2010 17:39 _DreadNought_#2
Biniarys?
08/23/2010 18:04 fotis007#3
yea
08/23/2010 19:27 tanelipe#4
I'm pretty sure the problem is at

PHP Code:
'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich'); 
and the "I've part" since it's using 's for strings. Thus cutting the string at 'Why~Yes~I~Am!~I' and the rest of the line gives the error.
08/23/2010 20:05 _DreadNought_#5
Quote:
Originally Posted by fotis007 View Post
yea
Not many people like to help people if they are using biniarys
08/24/2010 00:00 fotis007#6
and now what we do? =]
08/24/2010 01:49 Korvacs#7
Quote:
Originally Posted by tanelipe View Post
I'm pretty sure the problem is at

PHP Code:
'Why~Yes~I~Am!~I've~Come~To~Make~You~Rich'); 
and the "I've part" since it's using 's for strings. Thus cutting the string at 'Why~Yes~I~Am!~I' and the rest of the line gives the error.
And not only that but all of these:

PHP Code:
REPLACE INTO `cq_task` VALUES ('950001', '950001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0); 
08/24/2010 15:14 fotis007#8
Quote:
Originally Posted by Korvacs View Post
And not only that but all of these:

PHP Code:
REPLACE INTO `cq_task` VALUES ('950001', '950001', '0000, '', '', '0, '0', '0, -100000, 10000, 0000, 0000, 0, -1, 0); 

What i have to change then? =[
08/24/2010 16:18 Korvacs#9
Quote:
Originally Posted by fotis007 View Post
What i have to change then? =[
Here i googled the phrase "mysql replace syntax" for you and this was first on the list:

[Only registered and activated users can see links. Click Here To Register...]

Please learn to use google, its not that hard.
08/24/2010 18:47 fotis007#10
Ok let me try =] thx anw

Cant Fix it =[ who can fix for me take thanks =[
08/25/2010 13:35 .Beatz#11
Quote:
Originally Posted by fotis007 View Post
Ok let me try =] thx anw
Quote:
Originally Posted by fotis007 View Post
Cant Fix it =[ who can fix for me take thanks =[
#Reported - Double Posting

There is a handy button that says "edit" please use it next time.
08/25/2010 14:39 fotis007#12
Sry =[ my accident Who can fix the npc for me? i tryed but didnt make it
08/25/2010 20:52 .Beatz#13
Quote:
Originally Posted by fotis007 View Post
Sry =[ my accident Who can fix the npc for me? i tryed but didnt make it
Well this is not me telling you how to do it. But make a new Table add some names like UID, EXP, 1, 2, 3, 4 etc or whatever.
Once you have done this dump the Sql and have a look at the dumped file and compare it to your Sql file that will not execute.
You should see some changes ^^^ As above.
Use your brain a little bit and you can figure it out.
08/25/2010 22:51 fotis007#14
i tried all ' " and all this thinks and still broke my brain is going to BOOM
08/25/2010 23:19 .Beatz#15
Quote:
Originally Posted by fotis007 View Post
i tried all ' " and all this thinks and still broke my brain is going to BOOM
Read my post again....... It is not difficult to figure out.
Page 1 of 2 1 2