Here's the full list... if anybody has any of the below that doesnt work, run the query for the ones that dont work:
Change Username
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:16:"vbplaza_use rname";s:9:"inputname";s:8:"username";s:10:"inputv alue";s:0:"";}}' WHERE `itemid` =1 LIMIT 1 ;[/sql]
Change User Title
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:17:"vbplaza_use rtitle";s:9:"inputname";s:9:"usertitle";s:10:"inpu tvalue";s:0:"";}}' WHERE `itemid` =14 LIMIT 1 ;[/sql]
Change Others User Title
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:2:{i:0;a:3:{s:10:"phrasename";s:16:"vbplaza_use rname";s:9:"inputname";s:8:"username";s:10:"inputv alue";s:0:"";}i:1;a:3:{s:10:"phrasename";s:17:"vbp laza_usertitle";s:9:"inputname";s:9:"usertitle";s: 10:"inputvalue";s:0:"";}}' WHERE `itemid` =15 LIMIT 1 ;[/sql]
Sticky Thread
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:23:"vbplaza_thr eadid_or_url";s:9:"inputname";s:8:"threadid";s:10: "inputvalue";s:0:"";}}' WHERE `itemid` =19 LIMIT 1 ;[/sql]
Unsticky Thread
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:23:"vbplaza_thr eadid_or_url";s:9:"inputname";s:8:"threadid";s:10: "inputvalue";s:0:"";}}' WHERE `itemid` =20 LIMIT 1 ;[/sql]
Close Thread
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:23:"vbplaza_thr eadid_or_url";s:9:"inputname";s:8:"threadid";s:10: "inputvalue";s:0:"";}}' WHERE `itemid` =22 LIMIT 1 ;[/sql]
Open Thread
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:23:"vbplaza_thr eadid_or_url";s:9:"inputname";s:8:"threadid";s:10: "inputvalue";s:0:"";}}' WHERE `itemid` =23 LIMIT 1 ;[/sql]
Bump Thread
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:23:"vbplaza_thr eadid_or_url";s:9:"inputname";s:8:"threadid";s:10: "inputvalue";s:0:"";}}' WHERE `itemid` =28 LIMIT 1 ;[/sql]
Debump Thread
[sql]UPDATE `vbplaza_item` SET `inputfields` = 'a:1:{i:0;a:3:{s:10:"phrasename";s:23:"vbplaza_thr eadid_or_url";s:9:"inputname";s:8:"threadid";s:10: "inputvalue";s:0:"";}}' WHERE `itemid` =29 LIMIT 1 ;[/sql]
Don't forget to run Rebuild Datastore in the vbPlaza Maintenance!
That's all of em! Hope I helped
MGM out