[BaziCenter]

Originally Posted by MonkYZ

Well, i'm starting to get tons of Database errors:

PHP Code:

Invalid SQL:
INSERT INTO gxboxlive SET
                                        
                        userid = '9834',
                        gold = '0',
                        gamertag = 'I don't have an Xbox Console.',
                        avatar = 'http://image.xboxlive.com//global/t.FFFE07D1/tile/0/20000',
                        score = '--',
                        reputation = '<div class="Star Empty"></div><div class="Star Empty"></div><div class="Star Empty"></div><div class="Star Empty"></div><div class="Star Empty"></div>',
                        zone = '',
                        lastplayed = '',
                        updated = '1308933422'
                ,
                                        strikes = '0',
                                        error = '1',
                                        firstseen = '1308933422';

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't have an Xbox Console.',
                        avatar = 'http://image.xboxlive.com//global/t.FFFE' at line 5
Error Number  : 1064 


Did they change anything again?

It's beacuse the user has used ' in his/her gamertag. The gamertag is: I don't have an Xbox Console.
Use regex in first post to don't let users type an invalid string in your gamertag field.

Regular Expression: ^([A-Za-z0-9 ]+)?$ (regex not required)