Crime Formula

[ashbow97]

Does anyone have any advice (or even the formula) of the crime things? :) What I'm really looking for is something like Torn City's where you get better as you go on, you gain crimexp for completing tasks, and lose crimexp for losing them

thanks :D

[Coly010]

i'm not sure but you would run sql altering the user table to add crime exp first.

i dont know about how to make it easier for them to win it.

the way it is now, the bigger the will the more chance they have.

so if you could alter that to the crime exp then you're sweet.

this may be what the sql code should look like:

[mysql]

ALTER TABLE `users` ADD `crimeexp` DECIMAL ([something or other]) NOT NULL DEFAULT `10`;

[/mysql]

they need to have some exp so they can have a chance at winning

then the part where the crimeexp goes up in the crimeSTEXT(i think thats what it is) of the crime table in the database you would need to add

mysql_query("UPDATE users SET crimeexp=crimeexp + 10 WHERE userid=$userid,$c");

you have pulled it off

then for the crimeFTEXT

mysql_query("UPDATE users SET crimeexp=crimeexp - 10 WHERE userid=$userid,$c");

you have failed

 

you're using lite right?

i think that should work