Samurai Legend Posted October 23, 2015 Share Posted October 23, 2015 Run these SQLs to phpMyAdmin - You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Open up register.php and find the stock McCodes referral code and replace it with - You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Create a new file called referral.php and add the following code below - You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add this into cron_hour.php - You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. [ATTACH=CONFIG]n280863[/ATTACH] [ATTACH=CONFIG]n280864[/ATTACH] Feedback will be good and thanks Quote Link to comment Share on other sites More sharing options...
~Rob0t Posted October 23, 2015 Share Posted October 23, 2015 (edited) > Do you have Skype, MSN Messenger, Yahoo Messenger or any other instant messenger? Sorry buddy, this sweet girl died. My condolences. Note: Remember to either exclude the coins credit from cron_hour.php or create that column in your users table! Edited October 23, 2015 by ~Rob0t Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted October 23, 2015 Share Posted October 23, 2015 This looks awefully familiar I will have to look around so don't quote me on it Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted October 24, 2015 Share Posted October 24, 2015 It is the same concept and same base code but altered quite a bit Quote Link to comment Share on other sites More sharing options...
Samurai Legend Posted October 27, 2015 Author Share Posted October 27, 2015 [MENTION=68711]KyleMassacre[/MENTION] - may you send me the link please Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted October 27, 2015 Share Posted October 27, 2015 I actually don't know where to find it or who even made it. I have a copy of it on my computer but yours is fine. Quote Link to comment Share on other sites More sharing options...
jedigunz Posted January 13, 2016 Share Posted January 13, 2016 Anyone got the SQL for this ??? Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted January 19, 2016 Share Posted January 19, 2016 Anyone got the SQL for this ??? From what I can tell by reading the code You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
darkfelon Posted February 10, 2016 Share Posted February 10, 2016 the above sql didnt work :( it keeps giving me a critical error when i try to go to referrals.php Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted February 22, 2016 Share Posted February 22, 2016 the above sql didnt work :( it keeps giving me a critical error when i try to go to referrals.php If you feel like giving us the error message, we may be able to help you. Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted February 27, 2016 Share Posted February 27, 2016 Apparently the SQL bbcode still doesn't work so what you can do to get the correct SQLs is click the quote button of the initial post and it will show up: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
athena26 Posted May 13, 2021 Share Posted May 13, 2021 Keep getting a SQL error .. Query was INSERT INTO referrals VALUES('', 1, 48, unix_timestamp(),'31.22.201.70','141.94.1.96') Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted May 13, 2021 Share Posted May 13, 2021 For your first value in that query put NULL Quote Link to comment Share on other sites More sharing options...
athena26 Posted May 13, 2021 Share Posted May 13, 2021 I'm confused which query 😕 Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted May 14, 2021 Share Posted May 14, 2021 Can you post your full error? Quote Link to comment Share on other sites More sharing options...
Sim Posted May 14, 2021 Share Posted May 14, 2021 Looks like he's trying to '' instead of integer. First value should be # ?? 1 minute ago, Sim said: Looks like he's trying to '' instead of integer. First value should be # ?? '' should actually just be removed after looking at structure Quote Link to comment Share on other sites More sharing options...
newttster Posted May 14, 2021 Share Posted May 14, 2021 This is the table: CREATE TABLE IF NOT EXISTS `referrals` ( `refID` int(11) NOT NULL AUTO_INCREMENT, `refREFER` int(11) NOT NULL DEFAULT '0', `refREFED` int(11) NOT NULL DEFAULT '0', `refTIME` int(11) NOT NULL DEFAULT '0', `refREFERIP` varchar(15) NOT NULL DEFAULT '127.0.0.1', `refREFEDIP` varchar(15) NOT NULL DEFAULT '127.0.0.1', `refBONUS` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`refID`) This is the query: INSERT INTO referrals VALUES('', 1, 48, unix_timestamp(),'31.22.201.70','141.94.1.96') The table has 7 columns. The query is only inserting 6. I don't think the single quotes are affecting anything or that the first field needs to be NULL since it's an auto-incrementing number. Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted May 14, 2021 Share Posted May 14, 2021 That query expects the 1st param to be a number not a string. An empty string != NULL either. If you are not going to fill out all columns in your table you also need to specify the columns you want to fill out. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
athena26 Posted May 14, 2021 Share Posted May 14, 2021 😕 I think it's fixed Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.