PDA

View Full Version : Edit Bug


The Notorious
04-20-2006, 07:53 PM
I'm not sure if it's a problem only on my board or if it's a bug but when you edit a post lets say to add more stuff: it adds points. Then you can edit the same post and remove stuff and it will STILL add points.:confused:

I'm also getting these errors in my e-mail:

Invalid SQL:

UPDATE user
SET
`vbbux` = `vbbux` + , vbp_history = 'a:19:{i:0;a:4:{s:6:\"itemid\";s:3:\"125\";s:9:\"finalcost\";d:786.018749999999954525264911353588104248046875; s:8:\"dateline\";i:1143861165;s:7:\"expires\";s:1:\"0\";}i:1;a:4:{s:6:\"itemid\";s:2:\"11\";s:9:\"finalcost\";d:419.2099999999999795363692101091146469116210937 5;s:8:\"dateline\";i:1143861535;s:7:\"expires\";s:1:\"0\";}i:2;a:4:{s:6:\"itemid\";s:1:\"6\";s:9:\"finalcost\";d:786.018749999999954525264911353588104248046875; s:8:\"dateline\";i:1143994116;s:7:\"expires\";s:1:\"0\";}i:3;a:4:{s:6:\"itemid\";s:2:\"14\";s:9:\"finalcost\";d:1063.47499999999990905052982270717620849609375; s:8:\"dateline\";i:1143994307;s:7:\"expires\";s:1:\"0\";}i:4;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:4:\"1000\";s:8:\"dateline\";i:1144169981;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:1:\"2\";s:10:\"tousername\";s:5:\"IsMaR\";s:6:\"reason\";s:71:\"Thief attempt was unsuccessful from <a href=\"member.php?u=2\">IsMaR</a>.\";}i:5;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144346827;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:2:\"79\";s:12:\"fromusername\";s:7:\"TROUBLE\";s:6:\"reason\";s:18:\"Cause Your Real...\";}i:6;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"50\";s:8:\"dateline\";i:1144641362;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6734\";s:12:\"fromusername\";s:7:\"kdelpre\";s:6:\"reason\";s:27:\"Thanks for R. Kelly song...\";}i:7;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144723906;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"6820\";s:10:\"tousername\";s:12:\"YoungGunna22\";s:6:\"reason\";s:51:\"fo da sig nigga ......soon i want a notha 1 :smoke:\";}i:8;a:7:{s:6:\"itemid\";s:2:\"27\";s:9:\"finalcost\";d:1058.325000000000045474735088646411895751953125 ;s:8:\"dateline\";i:1144963245;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"4206\";s:10:\"tousername\";s:17:\"Thepeopleschamp86\";s:6:\"reason\";s:17:\"LmAo....HaVe FuNn\";}i:9;a:7:{s:6:\"itemid\";s:2:\"27\";s:9:\"finalcost\";d:1058.325000000000045474735088646411895751953125 ;s:8:\"dateline\";i:1144963789;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"4206\";s:12:\"fromusername\";s:17:\"Thepeopleschamp86\";s:6:\"reason\";s:57:\"pussy mother++++er.get the ++++ outta here u little +++++\";}i:10;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1145110637;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7598\";s:12:\"fromusername\";s:5:\"dirty\";}i:11;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"15\";s:8:\"dateline\";i:1145120043;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7994\";s:12:\"fromusername\";s:6:\"Legend\";s:6:\"reason\";s:6:\"Themes\";}i:12;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:6:\"200.00\";s:8:\"dateline\";i:1145121013;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"2373\";s:12:\"fromusername\";s:12:\"badman shane\";s:6:\"reason\";s:24:\"thanks for scary movie 4\";}i:13;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:4:\"1.00\";s:8:\"dateline\";i:1145137603;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6494\";s:12:\"fromusername\";s:8:\"Lilc2006\";}i:14;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:5:\"20.00\";s:8:\"dateline\";i:1145232503;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"8759\";s:12:\"fromusername\";s:9:\"HotNizzle\";s:6:\"reason\";s:15:\"cuz he tha man!\";}i:15;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1145321756;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7598\";s:12:\"fromusername\";s:5:\"dirty\";}i:16;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1145321926;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7598\";s:12:\"fromusername\";s:5:\"dirty\";}i:17;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";d:300;s:8:\"dateline\";i:1145323553;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"7014\";s:10:\"tousername\";s:7:\"Remixed\";s:6:\"reason\";s:31:\"fo da tracks u hooked me up wit\";}i:18;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:0:\"\";s:8:\"dateline\";i:1145626841;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"9109\";s:12:\"fromusername\";s:5:\"Lcsh`\";}}'
WHERE userid = '4072';

MySQL Error : 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 ' vbp_history = 'a:19:{i:0;a:4:{s:6:\"itemid\";s:3:\"125\";s:9:\
Error Number : 1064

The Notorious
04-28-2006, 03:51 PM
So any help with this, I'm still getting those emails...

CMX_CMGSCCC
04-30-2006, 07:54 PM
Yuck, this problem I think stems from that a user in ur forums has a ` in their username. Do any programmers out there know if escape_string will convert that character to \` ? I think vbplaza uses escape_string now, but it seems that it thinks the `, is a MySQL character...

I'm not sure how to fix this at first thought, let me do some research on it.

-CMX

The Notorious
05-01-2006, 01:17 AM
Thanks for the reply. :)

I just checked and I don't think it's cuz of a ` in their username.
Error:

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user
SET
`vbbux` = `vbbux` + .abc, vbp_history = 'a:38:{i:0;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143696390;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:2:\"14\";s:12:\"fromusername\";s:12:\"Str8FromTheD\";s:6:\"reason\";s:79:\"Thief attempt was unsuccessful from <a href=\"member.php?u=14\">Str8FromTheD</a>.\";}i:1;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143697521;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:3:\"908\";s:12:\"fromusername\";s:7:\"kal_S23\";s:6:\"reason\";s:75:\"Thief attempt was unsuccessful from <a href=\"member.php?u=908\">kal_S23</a>.\";}i:2;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:1:\"5\";s:8:\"dateline\";i:1143734523;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"436\";s:10:\"tousername\";s:6:\"broham\";s:6:\"reason\";s:33:\"ill give u 5 for every soundscan \";}i:3;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:1:\"5\";s:8:\"dateline\";i:1143735122;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"2779\";s:10:\"tousername\";s:7:\"sure_wp\";s:6:\"reason\";s:76:\"Thief attempt was unsuccessful from <a href=\"member.php?u=2779\">sure_wp</a>.\";}i:4;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143736379;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"436\";s:10:\"tousername\";s:6:\"broham\";s:6:\"reason\";s:13:\"cuz ur awsome\";}i:5;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"50\";s:8:\"dateline\";i:1143743968;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7941\";s:12:\"fromusername\";s:4:\"mebe\";s:6:\"reason\";s:73:\"Thief attempt was unsuccessful from <a href=\"member.php?u=7941\">mebe</a>.\";}i:6;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:5:\"25.00\";s:8:\"dateline\";i:1143744106;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7941\";s:12:\"fromusername\";s:4:\"mebe\";s:6:\"reason\";s:73:\"Thief attempt was unsuccessful from <a href=\"member.php?u=7941\">mebe</a>.\";}i:7;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143746063;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"5371\";s:10:\"tousername\";s:3:\"MSC\";s:6:\"reason\";s:72:\"Thief attempt was unsuccessful from <a href=\"member.php?u=5371\">MSC</a>.\";}i:8;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1143839050;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"4892\";s:12:\"fromusername\";s:5:\"Quike\";s:6:\"reason\";s:17:\"keep it up mayne!\";}i:9;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"20\";s:8:\"dateline\";i:1143859603;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"2415\";s:12:\"fromusername\";s:8:\"DJ Spyda\";s:6:\"reason\";s:16:\"Cause You Got 1k\";}i:10;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:1:\"5\";s:8:\"dateline\";i:1143918153;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"182\";s:10:\"tousername\";s:5:\"Rayne\";s:6:\"reason\";s:4:\"News\";}i:11;a:4:{s:6:\"itemid\";s:2:\"14\";s:9:\"finalcost\";d:1063.47499999999990905052982270717620849609375; s:8:\"dateline\";i:1143919792;s:7:\"expires\";s:1:\"0\";}i:14;a:4:{s:6:\"itemid\";s:1:\"2\";s:9:\"finalcost\";d:209.6049999999999897681846050545573234558105468 75;s:8:\"dateline\";i:1143920206;s:7:\"expires\";s:1:\"0\";}i:15;a:4:{s:6:\"itemid\";s:1:\"4\";s:9:\"finalcost\";d:209.6049999999999897681846050545573234558105468 75;s:8:\"dateline\";i:1143920249;s:7:\"expires\";s:1:\"0\";}i:16;a:4:{s:6:\"itemid\";s:1:\"8\";s:9:\"finalcost\";d:209.6049999999999897681846050545573234558105468 75;s:8:\"dateline\";i:1143920311;s:7:\"expires\";s:1:\"0\";}i:17;a:4:{s:6:\"itemid\";s:2:\"10\";s:9:\"finalcost\";d:209.6049999999999897681846050545573234558105468 75;s:8:\"dateline\";i:1143920318;s:7:\"expires\";s:1:\"0\";}i:18;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143997231;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"4322\";s:12:\"fromusername\";s:5:\"joe86\";s:6:\"reason\";s:74:\"Thief attempt was unsuccessful from <a href=\"member.php?u=4322\">joe86</a>.\";}i:19;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1144110854;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6725\";s:12:\"fromusername\";s:10:\"Trackfresh\";s:6:\"reason\";s:79:\"Thief attempt was unsuccessful from <a href=\"member.php?u=6725\">Trackfresh</a>.\";}i:20;a:4:{s:6:\"itemid\";s:2:\"30\";s:9:\"finalcost\";d:5497.625;s:8:\"dateline\";i:1144338970;s:7:\"expires\";s:1:\"0\";}i:21;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:5:\"30.55\";s:8:\"dateline\";i:1144525593;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7598\";s:12:\"fromusername\";s:5:\"dirty\";s:6:\"reason\";s:5:\"propz\";}i:22;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144711578;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"1403\";s:12:\"fromusername\";s:8:\"creepsor\";}i:23;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"250\";s:8:\"dateline\";i:1144711682;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"1403\";s:10:\"tousername\";s:8:\"creepsor\";s:6:\"reason\";s:47:\"4 bein so kind as to give me 200 u get rewarded\";}i:24;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1144712210;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"1689\";s:12:\"fromusername\";s:7:\"rehmann\";}i:25;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144712633;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6169\";s:12:\"fromusername\";s:6:\"Krazye\";s:6:\"reason\";s:20:\"congratz on 5th logo\";}i:26;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1144946621;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"8614\";s:12:\"fromusername\";s:6:\"VBMisc\";s:6:\"reason\";s:10:\"Props mann\";}i:27;a:4:{s:6:\"itemid\";s:2:\"14\";s:9:\"finalcost\";d:1063.47499999999990905052982270717620849609375; s:8:\"dateline\";i:1144951587;s:7:\"expires\";s:1:\"0\";}i:28;a:4:{s:6:\"itemid\";s:1:\"5\";s:9:\"finalcost\";d:419.2099999999999795363692101091146469116210937 5;s:8:\"dateline\";i:1144951654;s:7:\"expires\";s:1:\"0\";}i:29;a:4:{s:6:\"itemid\";s:2:\"11\";s:9:\"finalcost\";d:419.2099999999999795363692101091146469116210937 5;s:8:\"dateline\";i:1144951699;s:7:\"expires\";s:1:\"0\";}i:30;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"500\";s:8:\"dateline\";i:1144982122;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"1403\";s:12:\"fromusername\";s:8:\"creepsor\";s:6:\"reason\";s:8:\"congratz\";}i:31;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144982589;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7676\";s:12:\"fromusername\";s:8:\"lildevil\";s:6:\"reason\";s:13:\"logo props!!!\";}i:32;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"400\";s:8:\"dateline\";i:1144983005;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:3:\"932\";s:12:\"fromusername\";s:16:\"Bi$hoP.of.MurdaH\";s:6:\"reason\";s:8:\"congratz\";}i:33;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"300\";s:8:\"dateline\";i:1144983161;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"4830\";s:12:\"fromusername\";s:17:\"OuttaMyFuccinMind\";s:6:\"reason\";s:8:\"congratz\";}i:34;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1145040282;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6169\";s:12:\"fromusername\";s:6:\"Krazye\";s:6:\"reason\";s:8:\"congratz\";}i:35;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1145043686;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"3156\";s:12:\"fromusername\";s:11:\"nevertakeaL\";s:6:\"reason\";s:35:\"Props on the sixth gfather logo man\";}i:36;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";d:150;s:8:\"dateline\";i:1145044376;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"1403\";s:10:\"tousername\";s:8:\"creepsor\";s:6:\"reason\";s:8:\"1k Posts\";}i:37;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";d:100;s:8:\"dateline\";i:1145461841;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"436\";s:10:\"tousername\";s:6:\"broham\";s:6:\"reason\";s:9:\"Soundscan\";}i:38;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";d:0;s:8:\"dateline\";i:1145733038;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"6560\";s:10:\"tousername\";s:5:\"Jakkc\";s:6:\"reason\";s:8:\"I <3 You\";}i:39;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:4:\".abc\";s:8:\"dateline\";i:1145740275;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6560\";s:12:\"fromusername\";s:5:\"Jakkc\";s:6:\"reason\";s:2:\":D\";}}'
WHERE userid = '3316';

MySQL Error : 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 ' vbp_history = 'a:38:{i:0;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"
Error Number : 1064
Date : Saturday, April 22nd 2006 @ 04:11:15 PM
Username : Jakkc
Classname : vb_database

EasyTarget
05-10-2006, 08:18 PM
I have the same problem... users are getting tons of points simply by editting their posts and also using the automerge hack.

EasyTarget
05-23-2006, 10:02 PM
apparently they click edit and then they add a bunch of stuff and erase what they originally wrote then click save as much as they can before the page loads. then they edit again to remove what they added. It puts a huge load on the server too when they do this.

davidw
05-23-2006, 11:15 PM
The Notorious,

You are currently showing up as unlicensed. To be able to download hacks and/or receive support here at vBulletin.org, we ask you to please click here (vB-germany users click here) and enter your email address, to show us that you are licensed.

You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive. The update of your account may take up to one hour.

Thank you.

CMX_CMGSCCC
06-20-2006, 04:50 PM
vbbux` = `vbbux` + .abc

Where did u enter .abc? Inside of the Donate option?

-CMX