How to stop / start / restart Gearman Server
How to stop, start and restart Gearman server via command line took me a bit to find, so I figured I would post it for future reference…
First, know the path to gearmand and gearadmin, on my server it is:
|
1 2 |
/usr/bin/gearmand /usr/bin/gearadmin |
How to STOP Gearman Server
|
1 |
gearadmin --shutdown |
How to START Gearman Server
|
1 |
gearmand -d |
Note: If you are not using a database to queue Gearman worker jobs, that means all pending jobs are in memory, all pending jobs will be lost when you shutdown! If you do use a database, your pending jobs will be available upon restart and will not be lost.
Hope this helps!
How to integrate Kiip ads into Cocos2d
Here is a quick example of how to integrate Kiip rewards into your Cocos2d game.
If you have questions or updates, please post them in the comments below, thanks!
Required:
Kiip Account: http://www.kiip.com/
Cocos2d: http://www.cocos2d-iphone.org/
Kiip SDK: http://docs.kiip.com/en/downloads/
AppDelegate.h
1. Add #import <KiipSDK/KiipSDK.h>
2. Add KiipDelegate to the AppController interface
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
#import <UIKit/UIKit.h> #import "cocos2d.h" #import <KiipSDK/KiipSDK.h> // Added only for iOS 6 support @interface MyNavigationController : UINavigationController <CCDirectorDelegate> @end @interface AppController : NSObject <UIApplicationDelegate, KiipDelegate> { UIWindow *window_; MyNavigationController *navController_; CCDirectorIOS *director_; // weak ref } @property (nonatomic, retain) UIWindow *window; @property (readonly) MyNavigationController *navController; @property (readonly) CCDirectorIOS *director; @end |
AppDelegate.m
1. Add Kiip init code at the end of the didFinishLaunchingWithOptions method just above the return YES;
Note: You will need to get your “KEY” and “SECRET” from your Kiip dashboard.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions { //---- Towards End ----// //Kiip Start// Kiip *kiip = [[Kiip alloc] initWithAppKey:@"1234" andSecret:@"1234"]; kiip.delegate = self; [Kiip setSharedInstance:kiip]; //Kiip End// return YES; } |
HelloWorldLayer.h
1. Add #import <KiipSDK/KiipSDK.h>
2. Add <KiipDelegate> to interface
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
#import <KiipSDK/KiipSDK.h> // When you import this file, you import all the cocos2d classes #import "cocos2d.h" // HelloWorldLayer @interface HelloWorldLayer : CCLayer <KiipDelegate> { } // returns a CCScene that contains the HelloWorldLayer as the only child +(CCScene *) scene; @end |
HelloWorldLayer.m
1. Added Kiip rewards call inside a CCMenuItem block call ( you would make your own method and triggers to call Kiip rewards )
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
// Default font size will be 28 points. [CCMenuItemFont setFontSize:28]; // Achievement Menu Item using blocks CCMenuItem *kiipAchievement = [CCMenuItemFont itemWithString:@"Kiip Achievement" block:^(id sender) { [[Kiip sharedInstance] saveMoment:@"Finishing Level One!" withCompletionHandler:^(KPPoptart *poptart, NSError *error) { if (error) { NSLog(@"something's wrong"); // handle with an Alert dialog. } if (poptart) { [poptart show]; } if (!poptart) { // handle logic when there is no reward to give. } }]; }]; CCMenu *menu = [CCMenu menuWithItems:kiipAchievement, nil]; [menu alignItemsHorizontallyWithPadding:20]; [menu setPosition:ccp( size.width/2, size.height/2 - 50)]; // Add the menu to the layer [self addChild:menu]; |
That’s it, if you have questions or comments, write them below!
How to Integrate AppLovin rewarded video ads into Cocos2d
Here is a quick basic example of how to start showing rewarded video ads from AppLovin using Cocos2d 2.x.
NOTE: This is just a base template, there are several bits to be improved like:
+ Handling auto load for next video
+ Handling prompting player after the video box is closed
+ Whatever you guys can think of…
Hope this helps gets you guys started with making some money using AppLovin in your apps.
If you do update the code, post it in the comments and I will update the code here, thanks!
REQUIRED:
+ AppLovin Account: https://www.applovin.com/developers
+ Cocos2d 2.x
+ AppLovin SDK 2.4.0
======
AppDelegate.m
#import "AppDelegate.h"
#import "ALSdk.h"
....
- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions
{
....
//towards end of method
[ALSdk initializeSdk];
return YES;
}
HelloWorldLayer.h
//APPLOVIN
#import "ALIncentivizedInterstitialAd.h"
#import "ALAdRewardDelegate.h"
@interface HelloWorldLayer: CCLayer <ALAdLoadDelegate, ALAdRewardDelegate>{
bool appLovinVideoLoaded;
....
}
@property (strong, nonatomic) ALAd* cachedAd;
@property (assign, atomic, getter=isVideoAvailable) BOOL videoAvailable;
HelloWorldLayer.m
#import "HelloWorldLayer.h"
// Needed to obtain the Navigation Controller
#import "AppDelegate.h"
#pragma mark - HelloWorldLayer
// HelloWorldLayer implementation
@implementation HelloWorldLayer
@synthesize cachedAd;
// Helper class method that creates a Scene with the HelloWorldLayer as the only child.
+(CCScene *) scene
{
// 'scene' is an autorelease object.
CCScene *scene = [CCScene node];
// 'layer' is an autorelease object.
HelloWorldLayer *layer = [HelloWorldLayer node];
// add layer as a child to scene
[scene addChild: layer];
// return the scene
return scene;
}
// on "init" you need to initialize your instance
-(id) init
{
// always call "super" init
// Apple recommends to re-assign "self" with the "super's" return value
if( (self=[super init]) ) {
// create and initialize a Label
CCLabelTTF *label = [CCLabelTTF labelWithString:@"AppLovin Cocos2d Demo" fontName:@"Marker Felt" fontSize:64];
// ask director for the window size
CGSize size = [[CCDirector sharedDirector] winSize];
// position the label on the center of the screen
label.position = ccp( size.width /2 , size.height/2 );
// add the label as a child to this Layer
[self addChild: label];
// Default font size will be 28 points.
[CCMenuItemFont setFontSize:28];
// AppLovin
CCMenuItem *appLovin = [CCMenuItemFont itemWithString:@"Show AppLovin Video" block:^(id sender) {
[self showAppLovinVideo];
}];
CCMenu *menu = [CCMenu menuWithItems:appLovin, nil];
[menu alignItemsHorizontallyWithPadding:20];
[menu setPosition:ccp( size.width/2, size.height/2 - 50)];
// Add the menu to the layer
[self addChild:menu];
//AppLovin
appLovinVideoLoaded = NO;
[self setupAppLovin];
}
return self;
}
// on "dealloc" you need to release all your retained objects
- (void) dealloc
{
// in case you have something to dealloc, do it in this method
// in this particular example nothing needs to be released.
// cocos2d will automatically release all the children (Label)
// don't forget to call "super dealloc"
[super dealloc];
}
/////////////////////////
// AppLovin Start
/////////////////////////
-(void)setupAppLovin
{
//LOAD
[ALIncentivizedInterstitialAd preloadAndNotify: self];
}
-(void)showAppLovinVideo
{
if (appLovinVideoLoaded == NO)
{
[self showVideoNotReady];
[self setupAppLovin];
}
else
{
[ALIncentivizedInterstitialAd showOver: [[UIApplication sharedApplication] keyWindow] andNotify: self];
appLovinVideoLoaded = NO;
}
}
-(void) showVideoNotReady
{
//Handle video not ready message...
}
#pragma mark AppLovin Custom Event Handling
-(void) rewardValidationRequestForAd:(ALAd *)ad didSucceedWithResponse:(NSDictionary *)response
{
// AppLovin servers validated the reward. Refresh user balance from your server.
// We will also pass the number of coins awarded and the name of the currency.
// However, ideally, you should verify this with your server before granting it.
// NSString *currencyName = [response objectForKey: @"currency"];
// NSString *amountGivenString = [response objectForKey: @"amount"];
// NSNumber *amountGiven = [NSNumber numberWithFloat: [amountGivenString floatValue]];
NSLog(@"APPLOVIN rewardValidationRequestForAd didSucceedWithResponse");
}
-(void) rewardValidationRequestForAd:(ALAd *)ad didExceedQuotaWithResponse:(NSDictionary *)response
{
// User watched video but has already earned the maximum number of coins you specified in the UI.
NSLog(@"APPLOVIN rewardValidationRequestForAd didExceedQuotaWithResponse");
}
-(void) rewardValidationRequestForAd:(ALAd *)ad wasRejectedWithResponse:(NSDictionary *)response
{
// The user's reward was marked as fraudulent, they are most likely trying to modify their balance illicitly.
NSLog(@"APPLOVIN rewardValidationRequestForAd wasRejectedWithResponse");
}
-(void) rewardValidationRequestForAd:(ALAd *)ad didFailWithError:(NSInteger)responseCode
{
// We were unable to contact the server. Grant the reward, or don't, as you see fit.
NSLog(@"APPLOVIN rewardValidationRequestForAd didFailWithError");
}
-(void) userDeclinedToViewAd: (ALAd*) ad
{
// When prompted, the user decided they did not want to view a rewarded video.
NSLog(@"APPLOVIN userDeclinedToViewAd");
}
-(void) adService:(ALAdService *)adService didLoadAd:(ALAd *)ad
{
cachedAd = ad;
appLovinVideoLoaded = YES;
NSLog(@"APPLOVIN didLoadAd");
}
-(void) adService:(ALAdService *)adService didFailToLoadAdWithError:(int)code
{
appLovinVideoLoaded = NO;
NSLog(@"APPLOVIN didFailToLoadAdWithError");
}
/////////////////////////
// AppLovin End
/////////////////////////
@end
MySQL SQL Cheat Sheet
While coding I tend to write or find great SQL scripts from around the web. Below will be a growing collection of SQL that I have found to be useful, time saving or hard to find. Mostly to save me from having to remember, search again for hours or dig through old bookmarks. If any of the scripts below help you out, leave me a comment or do the social sharing thing thanks!
Delete Duplicates
Got a bunch of duplicates in a table that you want to clear out? Here is an easy way to do it…
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
//STEP 1 - MAKE NEW EMPTY TABLE CREATE TABLE new_table_tmp LIKE current_table; //STEP 2 - ADD UNIQUE KEY CONSTRAINTS ALTER TABLE new_table_tmp ADD UNIQUE (id, version); //STEP 3 - COPY DATA INTO NEW TABLE WITHOUT DUPLICATES INSERT INTO new_table_tmp SELECT * FROM current_table ON DUPLICATE KEY UPDATE id = id; //STEP 4 - RENAME OLD TABLE AND NEW TABLE RENAME TABLE current_table TO old_table_deleteme, new_table_tmp TO current_table; STEP 5 - DELETE OLD TABLE DROP TABLE old_table_deletme; |
Copy Table Data
Easy way to update a table from another another table.
Option #1 – If both tables have identical columns.
|
1 |
INSERT INTO destination_table SELECT * FROM source_table; |
Option #2 – If tables do not have identical columns or you just some of the data.
|
1 2 3 4 |
UPDATE destination_table d, source_table s SET d.this = s.this WHERE d.id = s.id AND d.that = ''; |
Update Column With MD5 Hash
Easy way to update a column with a unique has based on existing row data.
NOTE: MD5 has been well documented as not being the most secure for encryption. Since this was used harmless unique hash and not to protect sensitive data, I used MD5. This ran in 1.5 seconds for 200k rows, much faster than looping via PHP.
|
1 2 3 |
UPDATE table AS t SET t.hash = MD5(t.column_name) WHERE t.hash = ''; |
App Store Optimization with Appkpi.com
Launched appkpi.com today at 360iDev conference in Denver Colorado! Appkpi.com is an App Store keyword optimization tool that helps your app rank for highly searched terms within iTunes.
So the question is, can I find your iPhone or iPad app when I search for it on iTunes? Without using your app title?
What is App Store Optimization?
Let’s say you have an iPhone or iPad app in the iTunes App Store. People who want an app like yours will search on iTunes, NOT by your app name but instead by popular keywords! If your app doesn’t show up in the results, then you are missing sales!
You can use Appkpi to find highly searched keywords with little to no competitors and get your app to return for those specific keywords in iTunes search.
How Appkpi can help you!
1) Add any iPhone or iPad app to your appkpi.com account, even if it’s not yours! No need for an apple username or password like some other sites require.
2) Search for keywords that relate to your app. Appkpi returns competitors, keyword search volume and your current app rank for the keyword.
Appkpi also returns related keywords along with competitors, keyword search volume and your apps current rank. Personally I love the related keywords, you would be amazed at some huge search volume keywords that have NO APPS!
Note: Who would of thought football picks would be so wide open?
3.) Once you have selected the keywords you want to rank for, Appkpi will give you instruction on how to update your app.
4.) Track the results of your new your new keywords. Once your app and keywords are approved by Apple, your app will begin to show up in search results for the keywords approved.
More about Appkpi.com
To learn more about App Store Optimization, go to http://appkpi.com
Who is Cesar Serna?
Located in Southern California, I am a WordPress developer, iOS Game Developer and on rare occasion a Flamenco guitarist.