Raised This Month: $ Target: $400
 0% 

Reading flags from MYSQL database


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
aron9forever
Veteran Member
Join Date: Feb 2013
Location: Rromania
Old 08-17-2014 , 20:52   Re: Reading flags from MYSQL database
Reply With Quote #1

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



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