Raised This Month: $ Target: $400
 0% 

Reading flags from MYSQL database


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
devWaleed
Member
Join Date: Apr 2013
Location: Karachi, Pakistan
Old 08-17-2014 , 06:51   Reading flags from MYSQL database
Reply With Quote #1

PHP Code:
public SELECT_Handler(FailStateHandle:QueryError[], ErrcodeData[], DataSize){
    
    if(
FailState == TQUERY_CONNECT_FAILED){
        return 
set_fail_state("Couldn't connect to DB");        
    }else if(
FailState == TQUERY_QUERY_FAILED){
        return 
set_fail_state("Query failed");
    }    
    
    
//num     =    SQL_NumResults(Query);    
    
if(SQL_NumResults(Query) == 1){
        
num SQL_ReadResult(Query2);
                
client_print(0print_chat"Flag is %s"num);
    }
    return 
PLUGIN_CONTINUE;

Problem here is it is not printing what flags I have in MYSQL database.

On line 12: It prints "Flag is " and doesn't prints flags.

Database structure:
http://i.minus.com/ibpeuIuxaT1jGf.png
__________________
Steam: Waleedbaig2013
devWaleed is offline
Send a message via Skype™ to devWaleed
SpeeDeeR
Veteran Member
Join Date: Mar 2010
Location: Bulgaria
Old 08-17-2014 , 07:55   Re: Reading flags from MYSQL database
Reply With Quote #2

PHP Code:
/**
 * Retrieves the current result.
 * A successful query starts at the first result,
 *  so you should not call SQL_NextRow() first.
 * Passing no extra params - return int
 * Passing one extra param - return float in 1st extra arg
 * Passing two extra params - return string in 1st arg, max length in 2nd
 * Example:
 *  new num = SQL_ReadResult(query, 0)
 *  new Float:num2
 *  new str[32]
 *  SQL_ReadResult(query, 1, num2)
 *  SQL_ReadResult(query, 2, str, 31)
 */
native SQL_ReadResult(Handle:querycolumn, {Float,_}:...); 
Your flags must be a string.

Last edited by SpeeDeeR; 08-17-2014 at 08:00.
SpeeDeeR is offline
aron9forever
Veteran Member
Join Date: Feb 2013
Location: Rromania
Old 08-17-2014 , 20:52   Re: Reading flags from MYSQL database
Reply With Quote #3

Quote:
Originally Posted by devWaleed View Post
PHP Code:
public SELECT_Handler(FailStateHandle:QueryError[], ErrcodeData[], DataSize){
    
    if(
FailState == TQUERY_CONNECT_FAILED){
        return 
set_fail_state("Couldn't connect to DB");        
    }else if(
FailState == TQUERY_QUERY_FAILED){
        return 
set_fail_state("Query failed");
    }    
    
    
//num     =    SQL_NumResults(Query);    
    
if(SQL_NumResults(Query) == 1){
        
num SQL_ReadResult(Query2);
                
client_print(0print_chat"Flag is %s"num);
    }
    return 
PLUGIN_CONTINUE;

Problem here is it is not printing what flags I have in MYSQL database.

On line 12: It prints "Flag is " and doesn't prints flags.

Database structure:
http://i.minus.com/ibpeuIuxaT1jGf.png
there's so many things wrong with this
you're trying to print an int by the %String operator
this will only work if there's only one single row that applies to the query

if you want to save the flags as a string, make it SQL_ReadResult(Query, 2, szString, [len]);
__________________
Meanwhile, in 2050:
Quote:
Originally Posted by aron9forever
useless small optimizations
Quote:
Originally Posted by Black Rose View Post
On a map that is 512x512x128 units you end up with 3,355,443,200,000 different "positions". To store each one of those positions individually in the variable "user_or" you need 12 terabytes of memory.
aron9forever is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:57.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode