AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Codes not workin, anyone help? (https://forums.alliedmods.net/showthread.php?t=24895)

cssryan 03-04-2006 12:29

Codes not workin, anyone help?
 
OK well first off, this is a part of the code put into a plugin. Does anyone know WHY it won't work? And how to fix it?

Code:

                {
                        // Set 'username' in mYSQL
                        new uName[64], uSteam[64], uQuery[256], uQuery_2[256]
                        get_user_name(id, uName, 63)
                        get_user_authid(id, uSteam, 63)

                        format(uQuery,255,"SELECT username FROM money WHERE steamid='%s'", uSteam)
                        result = dbi_query(dbc, uQuery)
                        if( result == RESULT_NONE ) {
                                server_print( "[Bleh] No Username Found In mySQL!" )
                                server_print( "[Bleh] Debug Info: uName: %s  -  uSteam: %s", uName, uSteam )
                        } else if( result <= RESULT_FAILED ) {
                                server_print( "[Bleh] Setting Username In mySQL . . . FAILED !" )
                                server_print( "[Bleh] Debug Info: uName: %s  -  uSteam: %s", uName, uSteam )
                        } else {
                                format(uQuery_2,255,"UPDATE money SET username='%' WHERE steamid='%'", uName, uSteam)
                                result = dbi_query(dbc, uQuery_2)

                                server_print( "[Bleh] Setting Username In mySQL. . . COMPLETE!" )
                                server_print( "[Bleh] Debug Info: uName: %s  -  uSteam: %s", uName, uSteam )
                        }

                        dbi_free_result(result)
                        return PLUGIN_HANDLED
                }
        }

Any ideas?

P34nut 03-04-2006 12:47

you type:
Code:
format(uQuery_2,255,"UPDATE money SET username='%' WHERE steamid='%'", uName, uSteam)

change that to
Code:
format(uQuery_2,255,"UPDATE money SET username='%s' WHERE steamid='%s'", uName, uSteam)

Des12 03-04-2006 12:47

Code:

format(uQuery_2,255,"UPDATE money SET username='%s' WHERE steamid='%s'", uName, uSteam)

cssryan 03-04-2006 12:52

Thank you, I should look over my code next time :/


All times are GMT -4. The time now is 20:14.

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