many errors in sql query.
does anyone make that webshop work?
dl cape, dl horse, raven missing
can you give alter sql script for that 3 items?
Not tested.can you provide us the php code for limit resets?
for example if my server is maximum 20reset then users cant buy from webshop more than 20reset..
so the php file has to check for reset maximum limit..forexample 1 user 15 reset will buy 6 resets but the maximum is 20..so php will check if resets + given number to buy = more than 20 then give an error..
or we can do it from sql query like
UPDATE Character
SET resets = ('20')
Where resets>20
but is better from php if someone knows the code...something like if ($resets + $buyresets = >20 then dont do it
or if we add on savoy webshop resets.php
If [Resets]+".$increase_resets." >20 then give an error..
anyway someone who knows can fix that
Not tested.
can you provide us the php code for limit resets?
for example if my server is maximum 20reset then users cant buy from webshop more than 20reset..
so the php file has to check for reset maximum limit..forexample 1 user 15 reset will buy 6 resets but the maximum is 20..so php will check if resets + given number to buy = more than 20 then give an error..
or we can do it from sql query like
UPDATE Character
SET resets = ('20')
Where resets>20
but is better from php if someone knows the code...something like if ($resets + $buyresets = >20 then dont do it
or if we add on savoy webshop resets.php
If [Resets]+".$increase_resets." >20 then give an error..
anyway someone who knows can fix that
Update 2:
- Security improvements