Lets say you want to limit the number of records users can add to the certain table. For example, if you run a classified ads website, and you want free users to be able to post up to 3 ads, basic plan users to add up to 10 ads, etc.
Sample database structure
Table1: users, userid, password, limit.
Table2: ads, id, userid, adtext.
Tables are linked via the userid field. It would also make sense to turn on Advanced security mode 'Users can see all data; can edit their own data only'.
Use the following code in the Add page: Before Record Added event.
Scenario 1. All users can add the same number of records
int limit = 3;
dynamic rs = DB.Query("select count(*) as c from ads where userid = " + XSession.Session["UserID"].ToString());
dynamic data = rs.fetchAssoc();
int count = data["c"];
if (count >= limit)
{
message = "Limit reached: " + count.ToString() + " records added already";
return false;
}
return true;
Scenario 2. Each user has it's own limit. Limits are stored in the userlimit field of users table
dynamic rs = DB.Query("select count(*) as c from ads where userid = " + XSession.Session["UserID"].ToString());
dynamic data = rs.fetchAssoc();
int count = data["c"];
dynamic rs2 = DB.Query("select " + CommonFunctions.AddFieldWrappers("userlimit").ToString() + " from users where userid = " + XSession.Session["UserID"].ToString());
dynamic data2 = rs2.fetchAssoc();
int limit = data2["userlimit"];
if (count >= limit)
{
message = "Limit reached: " + count.ToString() + " records added already";
return false;
}
return true;
See also:
•QueryResult object fetchAssoc()
