forums.smartfoxserver.com

Code: Select all

		//-------------------------------<getPlots>--------------------\\
	if (cmd == "getPlots") {
		//Initialising the response object.  
		var response = {};
		//response object command executed trace.
		response._cmd = "getPlots";
		//response object result = false (Default).
		response.ok = false;
		//response object errmsg = Error Message if any.
		response.errmsg = "";
		//response object max block user count if any.
		response.max = 0;
		//checking if any relations exists with the player or not
		sql = "CALL stp_lkdrm_getPlots("+params.idBlock+");";
		var queryRes = dbase.executeQuery(sql);
		//response object district database data
		response.db = [];
		if (queryRes.size() != 0) {
			// Cycle through all records in the ResultSet
			for (var i = 0; i<queryRes.size(); i++) {
				// Get a record
				var tempRow = queryRes.get(i);
				// This object will hold the record data that we'll send to the client
				var item = {};
				var sTempPlotAddress = params.idDistrict+"."+params.idQuarter+"."+params.idZone+"."+params.idBlock+"."+tempRow.getItem("plot_id");
				for (var i in roomList) {
				//Checking if plot exists or not ... if yes then we get the usercount
				if (roomList[i].getName() == sTempPlotAddress) {
				// From the record object we can get each field value
				item.name = tempRow.getItem("plot_name");
				item.id = tempRow.getItem("plot_id");
				item.ucount = roomList[i].getUserCount();
				response.max += roomList[i].getUserCount();
				//Checking if the user is in the plot .... if yes we need 
				//to set the inRoom Property to true to render the plot map accordingly
				
				if (roomList[i].getId() == fromRoom) {
				item.inRoom = true;
				} else {
				item.inRoom = false;
				}
				} else {
				// From the record object we can get each field value
				item.name = tempRow.getItem("plot_name");
				item.id = tempRow.getItem("plot_id");
				item.ucount = 0;
				item.inRoom = false;
				}
				}				response.db.push(item);
			}
			response.ok = true;
		} else {
			response.errmsg = "Could not get the list of plots !";
			response.ok = false;
		}
		_server.sendResponse(response, -1, null, [user]);
		//-------------------------------</getPlots>--------------------\\

Code: Select all

aPlotList.sortOn("id", Array.NUMERIC | Array.DESCENDING);

Code: Select all

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
41