Search found 56 matches

by Sigtran
27 Jan 2012, 08:53
Forum: SFS2X Questions
Topic: DB connection Manager
Replies: 17
Views: 4693

you should probably redesign... else, you can send an event to the server via AS or java or any other language SFS supports :) i.e. a change was made to db via a php script, a reply is sent to the user about the change sucess, user sends an event to sfs extension, which then looks at a change that w...
by Sigtran
24 Jan 2012, 23:05
Forum: SFS2X Questions
Topic: DB connection Manager
Replies: 17
Views: 4693

Update doesnt return anything from sql, so in short, no, you cant have the object that was just created in the database and sfs has no knowledge of, but as rjgtav suggested - you should probably redesign the way you are storing / distributing user data (i.e. if its not persistent data, you should pr...
by Sigtran
24 Jan 2012, 16:39
Forum: SFS2X Questions
Topic: DB connection Manager
Replies: 17
Views: 4693

no, more then likely its not possible, as your id is set to autoincrement, so you are just sending an sql query to add another record, thus while sql knows what it needs to add, your java server doesnt know what LAST_INSERT_ID() is... if that makes sense... and unless you know what LAST_INSERT_ID() ...
by Sigtran
24 Jan 2012, 16:04
Forum: SFS2X Questions
Topic: DB connection Manager
Replies: 17
Views: 4693

Ok, here is an example of what you should be doing and how to send it back to the client: String sql = "SELECT ID FROM MyTable ORDER BY ID DESC LIMIT 1"; try { // Obtain a resultset ISFSArray result = dbManager.executeQuery(sql); // Populate the response parameters ISFSObject ...
by Sigtran
24 Jan 2012, 15:04
Forum: SFS2X Questions
Topic: DB connection Manager
Replies: 17
Views: 4693

ehm.. yes, if you do SELECT first?
by Sigtran
24 Jan 2012, 12:28
Forum: SFS2X Questions
Topic: DB connection Manager
Replies: 17
Views: 4693

hellopaso, There no transactions with sfs, use some 3ed party, if you want the connection pool, or use the connector if you can afford to recreate the connection... generally you only need it for updates / bulk insert, so shouldnt be used too often imho. Im just using this: try { connection = d...
by Sigtran
27 Jun 2011, 09:59
Forum: SFS2X Questions
Topic: Production Server Howto Deploy Guide
Replies: 13
Views: 3617

@ aaulia yes, its sfs2x-service file. you need to edit line 13-14, here is an example: # Uncomment the following line to add additional VM parameters INSTALL4J_ADD_VM_PARAMS="-server -Xms1G -Xmx1G" add more parameters / change them / do whatever else you feel like. P.S. btw I didnt make an...
by Sigtran
09 Jun 2011, 09:34
Forum: SFS2X Questions
Topic: Connection Lost
Replies: 7
Views: 3228

ah, got the topic now:
viewtopic.php?p=1841
apparently its to do with how the OS is handling the sockets...
by Sigtran
08 Jun 2011, 12:19
Forum: SFS2X Questions
Topic: Connection Lost
Replies: 7
Views: 3228

Oleg_79 wrote:USER_RECONNECTION_TRY event DO NOT WORK ! ! !.


meh, I just checked and I too dont get any event fired up neither on the server side or the client side (if the user unplugs his internet connection). Report as a bug? Using version 2.0.0-RC2a
by Sigtran
08 Jun 2011, 07:19
Forum: SFS2X Questions
Topic: Get User Count in Every Zone
Replies: 2
Views: 1657

thanks mka, yeah, i guess ill do the scheduling task for the DB (its easier for me to use).
If there any other ways, please post them up. thank you.

EDIT: done the scheduled task & it works just perfect
by Sigtran
08 Jun 2011, 07:08
Forum: SFS2X Questions
Topic: Connection Lost
Replies: 7
Views: 3228

how do I catch an event when the user is off the internet? Catch USER_RECONNECTION_TRY event (just check and see if I was right & your "User Reconnection Timeframe" is above "0" value) SmartFoxServer 2X sees it as being connected to and off of Idle timeout. how to catch the ...
by Sigtran
07 Jun 2011, 13:46
Forum: SFS2X Questions
Topic: Connection Lost
Replies: 7
Views: 3228

Your "User Reconnection Timeframe" is set to none 0 value (set in the sfs2x admin tool).
I'd say check out SFSEventType API... (e.g. USER_RECONNECTION_TRY && USER_RECONNECTION_SUCCESS events)
by Sigtran
07 Jun 2011, 09:57
Forum: SFS2X Questions
Topic: User level for running SFS2X on Linux ?
Replies: 1
Views: 954

it works with a non-root account for my test server (ubuntu 10.10)... just make sure that the account holder owns SFS2X server folder and files I guess (also the socket you are using must be > 1024). I will be running it on my production server as a sudo user tho, as im too lazy to set it up otherwi...
by Sigtran
07 Jun 2011, 08:21
Forum: SFS2X Questions
Topic: Get User Count in Every Zone
Replies: 2
Views: 1657

Get User Count in Every Zone

Hi, I would like to limit the number of users in a zone to say 250 users (to not crowd the screens). I would like to create a "Zone" choice menu for users, which will have just a simple zone list (e.g. all zones are copies of the first zone and they all are using the same extensions). For ...
by Sigtran
07 Jun 2011, 07:43
Forum: SFS2X Questions
Topic: request for very simple SQL extension
Replies: 1
Views: 873

how did you determine that it doesnt work? e.g. did you print out the results / sent it to the client? You can try the following, if you like: on the server: addRequestHandler("getMuppets", GetMuppets.class); and create an extension: import java.sql.SQLException; import com.smartfo...

Go to advanced search