Pickpocket in Lesane Store

As promised It's new version of steal addon to the Lesane Store.
At last the crime on my board is under control.
I translated all templates, but It's not the best english version.
Hope the instruction is full and understandable.
Have a fun.

[Atian]

i get this error


Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,showsignature,iconid,messageread ,folderid,receipt) VALUES (NULL,17,17,DMINID,'Attempt of a robbery','Buddy! They try to steal your $1

You are lucky. They are not. You still keep your money.

',1026943290,'Final Fantasy Underground','',0,0,0)
mysql error: Unknown column 'DMINID' in 'field list'

mysql error number: 1054


when i try to steal from someone

[Atian]

and i cant run the last 2 queries i get these

SQL-query :

INSERT INTO store VALUES (NULL, '+++++', 'Safeguard', '100', '0', 'godfather.gif', 'We protect your money', 'Y')

MySQL said:

Column count doesn't match value count at row 1

[GenSec]

Absolutly.

DMINID is your admin userid.

For some (first) version of Lesane store

INSERT INTO store VALUES (NULL, 'mafia', 'Safeguard', '100', '0', 'godfather.gif', 'We protect your money', 'Y')

is right.

For the last should be

INSERT INTO store VALUES (NULL, 'mafia', 'Safeguard', '100', '0', 'godfather.gif', 'We protect your money', 'Y','0')

is right.

[Atian]

ah thanks,now it worked

[Night Owl]

What percentage of the time are robberies successful with this hack? And can I change that? If so, how?

[Night Owl]

I would also like for people to be able to steal from the admins. How do I do that?

Thanks!

[Stealthy]

Originally posted by Night Owl
What percentage of the time are robberies successful with this hack? And can I change that? If so, how?

GenSec, I would like to know that as well.

Also, I would like to make it so that a member has a greater chance of failure if trying to steal from a Moderator.

What would I need to do to add this?

[Night Owl]

Two of my members are getting this error when trying to steal. No one else is getting it. What does this mean?

Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE user SET storep=storep-80 points+78 WHERE userid=60
mysql error: You have an error in your SQL syntax near 'points+78 WHERE userid=60' at line 1

mysql error number: 1064

[Tara]

Attempting to modify the database and I receive this error:

SQL-query :

INSERT INTO store VALUES (NULL, 'steal', 'Crime and punishment', '0', '0', 'thief.gif', 'It is not caught - not the thief', 'Y')

MySQL said:


Column count doesn't match value count at row 1

Back

Help! :cry:

[Kasper_H]

Ha, sounds interesting! I think i'll try it out Good job!