SQL Error Fix for v117 Public Source (SourceDEV)

[zPsychotic]

Find :

PreparedStatement psa = con.prepareStatement("INSERT INTO wz_itemadddata(itemid, `key`, value1, value2) VALUES (?, ?, ?, ?)");

Replace

PreparedStatement psa = con.prepareStatement("INSERT INTO wz_itemadddata(itemid, `key`, `subKey`, `value`) VALUES (?, ?, ?, ?)");

this should fix any items dump error,have no idea why it was like this it might be noob proof to stop noob who dont know Java..

I dont give any ratass about the what goes on anymore it is boring and full of leechers..

 

[avivii12345]

Very simple..

 

[smashman186]

Where do i search for this? I cant find preparedstatement psa anywhere...In the sql, or in the scr folder or in the dist folders (Inside every file also)

 

[mintdc12]

Where do i search for this? I cant find preparedstatement psa anywhere...In the sql, or in the scr folder or in the dist folders (Inside every file also)

I have the same problem i cant find "preparedstatement"

 

[EhDaPRo]

Very simple..

Even if its Very Simple, Some Beginners maybe need this uhh

Keep Up The Simple Work
Good Job

I have the same problem i cant find "preparedstatement"

You May find it on \src\tools\wztosql\dumpitems.java
Have Fun With that

 

[mintdc12]

Thanks but now i have this error

[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 '' at line 1
[Err] CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,`cl`.`offense` AS `offense`,`cl`.`count` AS `count`,`cl`.`lastoffensetime` AS `lastoffensetime`,`cl`.`param` AS `param` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (`a`.`banned` = 0) ;
[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 'group by `cl`.`id` order by sum(`cl`.`count`) desc' at line 1
[Err] CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `readable_last_hour_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,sum(`cl`.`count`) AS `numrepos` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (timestampdiff(HOUR,`cl`.`lastoffensetime`,now() < 1) and (`a`.`banned` = 0) group by `cl`.`id` order by sum(`cl`.`count`) desc ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

[EhDaPRo]

Umm But lol you dont need to edit sql in this fix lol