Search found 103 matches

by Skills07
15 Feb 2017, 08:07
Forum: SFS2X Questions
Topic: Using send email
Replies: 11
Views: 10848

Re: Using send email

Ok Thanks it works

i need another simple question to you

how can i do a query with like and other parameters like this

Code: Select all

select * from users where name like ? and/or position = ?
by Skills07
10 Feb 2017, 08:19
Forum: SFS2X Questions
Topic: Using send email
Replies: 11
Views: 10848

Using send email

Hello I need to ask a question very very simple. I have created an handler in myextension that i want to use when a customer lose his password. This handler must send an email with a random string. I have created this: public class RandomString { /** * * @param str */ private String str = null; /** ...
by Skills07
02 Feb 2017, 07:55
Forum: SFS2X Questions
Topic: Get top 100 user's list
Replies: 11
Views: 10496

Re: Get top 100 user's list

Thanks for the help
by Skills07
01 Feb 2017, 12:19
Forum: SFS2X Questions
Topic: Get top 100 user's list
Replies: 11
Views: 10496

Re: Get top 100 user's list

Sorry Lapo my collaborator says in client side my array is null but if i see my smartfox consolle i have sfsobject.size = 1 because for my try i have 1 record set only in my db. the code is this public class TopClanHandler extends BaseClientRequestHandler{ Object obj = null; public void handleClient...
by Skills07
31 Jan 2017, 10:45
Forum: SFS2X Questions
Topic: Get top 100 user's list
Replies: 11
Views: 10496

Re: Get top 100 user's list

Sorry i have lost the command send.

Thanks for the help
by Skills07
31 Jan 2017, 08:58
Forum: SFS2X Questions
Topic: Get top 100 user's list
Replies: 11
Views: 10496

Re: Get top 100 user's list

sorry i have executed my code

but on the client, the query doesn't retrurn anything, and in the db i have 110 results.

There is something wrong on my query??
The code i have posted is correct??
by Skills07
27 Jan 2017, 14:14
Forum: SFS2X Questions
Topic: Get top 100 user's list
Replies: 11
Views: 10496

Re: Get top 100 user's list

Object obj = null; public void handleClientRequest(User user, ISFSObject params) { trace("Sto richiedendo al server i 100 migliori clan"); IDBManager dbmanager = getParentExtension().getParentZone().getDBManager(); try{ trace("Ho fatto l'accesso per richiedere al server la mia query&...
by Skills07
26 Jan 2017, 17:58
Forum: SFS2X Questions
Topic: Get top 100 user's list
Replies: 11
Views: 10496

Re: Get top 100 user's list

I need to send type of info

like name, total trophy, clan name etc etc
by Skills07
26 Jan 2017, 14:16
Forum: SFS2X Questions
Topic: Get top 100 user's list
Replies: 11
Views: 10496

Get top 100 user's list

Hello

i want to ask you a question!

On the server side i want to call an handler to take a list of the "top 100 users" of my db.

I can set the query but i want to say how can i send the result set on the client!

I have to return an SFSArray with all data???

Thanks for the suggest
by Skills07
24 Jan 2017, 08:01
Forum: SFS2X Questions
Topic: See if a mail is registred
Replies: 14
Views: 14423

Re: See if a mail is registred

solved thanks
by Skills07
23 Jan 2017, 15:20
Forum: SFS2X Questions
Topic: See if a mail is registred
Replies: 14
Views: 14423

Re: See if a mail is registred

Sorry I was convinced that he had solved but it is not so! i was trying to test my code but i have a problem, the query is executed correctly beacuse it print the result like [SFSArray, size : 1] so in the database i have found a recordset like the insert! but now i want to print a message because t...
by Skills07
23 Jan 2017, 13:38
Forum: SFS2X Questions
Topic: See if a mail is registred
Replies: 14
Views: 14423

Re: See if a mail is registred

solved by myself

the problem was the call of the first query

Code: Select all

obj = dbmanager.executeQuery("SELECT * FROM Users WHERE  email=?", new Object[] {email});
by Skills07
23 Jan 2017, 13:07
Forum: SFS2X Questions
Topic: See if a mail is registred
Replies: 14
Views: 14423

Re: See if a mail is registred

Sorry man i have control with smartfox consolle, the problem is that in any case the code never enter in the first try for executing the query! in smartconsolle i have the print with my error it prints("MySql update error") it is the message fixed for catching the exception! because i ve t...
by Skills07
23 Jan 2017, 11:55
Forum: SFS2X Questions
Topic: See if a mail is registred
Replies: 14
Views: 14423

Re: See if a mail is registred

Bax wrote:The code seems ok. Maybe you should print the error message returned by the SQLException, to understand what is going on.



to print is trace exactly???
by Skills07
23 Jan 2017, 11:02
Forum: SFS2X Questions
Topic: See if a mail is registred
Replies: 14
Views: 14423

Re: See if a mail is registred

I think the answer is already in your question: 1. Run the select query 2. Check the result in an "if" statement: if the select returns no result, run the insert query I don't understand what the issue is. Sorry but i have post my code.. Can you show me if is it correct?? Beacuse i have d...

Go to advanced search