Thread: [667] or [718] Auto Donations

Page 1 of 9 123 ... LastLast
Results 1 to 10 of 90
  1. #1 [667] or [718] Auto Donations 
    Banned

    Join Date
    Sep 2010
    Posts
    849
    Thanks given
    156
    Thanks received
    118
    Rep Power
    0
    SQL file -

    Code:
    CREATE TABLE IF NOT EXISTS `donation` (
      `username` char(50) DEFAULT NULL,
      `time` char(50) DEFAULT NULL,
      `productid` char(50) DEFAULT NULL,
      `price` int(50) DEFAULT NULL,
      `tickets` int(50) DEFAULT NULL
    )
    All the website files;
    https://dl.dropbox.com/u/8525638/donate.zip

    DonationManager.java -

    Code:
    package com.rs.utils;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    import com.rs.game.player.Player;
    import com.rs.utils.Misc;
    import com.rs.game.World;
    
    public class DonationManager {
    
    	public static Connection con = null;
    	public static Statement stmt;
    	public static boolean connectionMade;
    
    	
    	public static void createConnection() {
    		try {
    			Class.forName("com.mysql.jdbc.Driver").newInstance();
    		String IP="pkerz614.com";
            String DB="pker7901_donate";
            String User="pker7901_donate";
            String Pass="password001"; 
    			con = DriverManager.getConnection("jdbc:mysql://"+IP+"/"+DB, User, Pass);
    			stmt = con.createStatement();
    		System.out.println("Connection to Donation database successful!"); //You can take these system prints out. Get annoying sometimes.
    		} catch (Exception e) {
            System.out.println("Connection to Donation database failed");
            e.printStackTrace();
    		}
    	}
    	
    	public static void startProcess(final Player player) {  //Choose which payment options give which things.
    		createConnection();
    		if(checkDonation(player.getUsername())) {
    			if(player.getInventory().getFreeSlots() < 10) {
    				player.getPackets().sendGameMessage("<col=00FFCC>Create some more space in your inventory Before doing this!");			
    				return;
    			}
    			/*
    			*	READ THIS!!!
    			*   To Choose which item they would get simple edit the below product id's.
    			*   Example: If they chose option number 4 on the website, the product id would be 4.
    			*/
    			if(checkDonationItem(player.getUsername()) == 1) { //Productid 1 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Received : Regular Donator!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				if (!player.isDonator()) {
    					player.setDonator(true);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    				player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 2) { //Productid 2 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Received : Extreme Donator!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				if (!player.isDonator()) {
    					player.setDonator(true);
    				if (!player.issuperDonator()) {
    					player.setsuperDonator(true);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				}
    				}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 3) { //Productid 3
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Received : Super Extreme Donator!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				if (!player.isDonator()) {
    					player.setDonator(true);
    				if (!player.issuperDonator()) {
    					player.setsuperDonator(true);
    				if (!player.isextremeDonator()) {
    					player.setextremeDonator(true);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				}
    				}
    				}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 4) { //Productid 4 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : PartyHat Set!");
    				player.getInventory().addItem(1038, 1);
    				player.getInventory().addItem(1040, 1);
    				player.getInventory().addItem(1042, 1);
    				player.getInventory().addItem(1044, 1);
    				player.getInventory().addItem(1046, 1);
    				player.getInventory().addItem(1048, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 5) { //Productid 5
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : H'Ween Set!");
    				player.getInventory().addItem(1053, 1);
    				player.getInventory().addItem(1055, 1);
    				player.getInventory().addItem(1057, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 6) { //Productid 6
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Santa Hat!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				player.getInventory().addItem(1050, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 7) { //Productid 7
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Mystery Box's");
    				player.getInventory().addItem(6199, 10);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 8) { //Productid 8 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Torva Set!");
    				player.getInventory().addItem(20135, 1);
    				player.getInventory().addItem(20139, 1);
    				player.getInventory().addItem(20143, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 9) { //Productid 9
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Virtus Set!");
    				player.getInventory().addItem(20159, 1);
    				player.getInventory().addItem(20163, 1);
    				player.getInventory().addItem(20167, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 10) { //Productid 10
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Pernix!");
    				player.getInventory().addItem(20147, 1);
    				player.getInventory().addItem(20151, 1);
    				player.getInventory().addItem(20155, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    		}
    	}
    	
    	public static ResultSet query(String s) throws SQLException {
    		try {
    			if (s.toLowerCase().startsWith("select")) {
    				ResultSet rs = stmt.executeQuery(s);
    				return rs;
    			} else {
    				stmt.executeUpdate(s);
    			}
    			return null;
    		} catch (Exception e) {
    			destroyConnection();
    		}
    		return null;
    	}
    
    	public static void destroyConnection() {
    		try {
    			stmt.close();
    			con.close();
    		} catch (Exception e) {
    		}
    	}
    
    	public static boolean checkDonation(String playerName) {
       
            try {
    			String name2 = playerName.replaceAll("_", " ");
                Statement statement = con.createStatement();
                String query = "SELECT * FROM donation WHERE username = '" + name2 + "'";
                ResultSet results = statement.executeQuery(query);
    				while(results.next()) {
                        int tickets = results.getInt("tickets"); //tickets are "Recieved" technically. 0 for claimed, 1 for not claimed.
                            if(tickets == 1) {                     
                             return true;
                             }
                                    
                            }
                    } catch(SQLException e) {
                            e.printStackTrace();
                    }
    				
                    return false;
    				
            }
    	
    	public static int checkDonationItem(String playerName) {
            
            try {
    			String name2 = playerName.replaceAll("_", " ");
    			Statement statement = con.createStatement();
                String query = "SELECT * FROM donation WHERE username = '" + name2 + "'";
                ResultSet results = statement.executeQuery(query);
                    while(results.next()) {
                        int productid = results.getInt("productid");
                            if(productid >= 1) {				                          
    							return productid;
                                }
    								                               
                            }
                    } catch(SQLException e) {
                            e.printStackTrace();
                    }
    				
                    return 0;
    				
            }		
    	
    	public static boolean donationGiven(String playerName) {       
                  
    			  try
                    {
    				String name2 = playerName.replaceAll("_", " ");
    				query("DELETE FROM `donation` WHERE username = '"+name2+"';");
                           // query("UPDATE donations SET tickets = 0 WHERE username = '" + playerName + "'");
    						//query("UPDATE donations SET productid = 0 WHERE username = '" + playerName + "'");
    						
                    } catch (Exception e) {
                            e.printStackTrace();
    						
                            return false;
                    }
                    return true;
            }	
    	
    }
    Enjoy (:
    Credits:
    Demon Dillon
    Reply With Quote  
     

  2. Thankful users:


  3. #2  
    EpicMemer

    Join Date
    Oct 2011
    Posts
    221
    Thanks given
    32
    Thanks received
    27
    Rep Power
    4
    Very Nice, Well done.
    Reply With Quote  
     

  4. #3  
    Registered Member
    Tyluur's Avatar
    Join Date
    Jun 2010
    Age
    26
    Posts
    5,103
    Thanks given
    1,819
    Thanks received
    1,767
    Rep Power
    2438
    Is this for Paypal?
    Quote Originally Posted by blakeman8192 View Post
    Keep trying. Quitting is the only true failure.
    Spoiler for skrrrrr:

    Attached image
    Reply With Quote  
     

  5. #4  
    Banned
    Join Date
    Aug 2012
    Posts
    608
    Thanks given
    302
    Thanks received
    163
    Rep Power
    0
    Spoiler for Thanks..:
    Quote Originally Posted by Kendrick View Post
    SQL file -

    Code:
    CREATE TABLE IF NOT EXISTS `donation` (
      `username` char(50) DEFAULT NULL,
      `time` char(50) DEFAULT NULL,
      `productid` char(50) DEFAULT NULL,
      `price` int(50) DEFAULT NULL,
      `tickets` int(50) DEFAULT NULL
    )
    All the website files;
    https://dl.dropbox.com/u/8525638/donate.zip

    DonationManager.java -

    Code:
    package com.rs.utils;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    import com.rs.game.player.Player;
    import com.rs.utils.Misc;
    import com.rs.game.World;
    
    public class DonationManager {
    
    	public static Connection con = null;
    	public static Statement stmt;
    	public static boolean connectionMade;
    
    	
    	public static void createConnection() {
    		try {
    			Class.forName("com.mysql.jdbc.Driver").newInstance();
    		String IP="pkerz614.com";
            String DB="pker7901_donate";
            String User="pker7901_donate";
            String Pass="password001"; 
    			con = DriverManager.getConnection("jdbc:mysql://"+IP+"/"+DB, User, Pass);
    			stmt = con.createStatement();
    		System.out.println("Connection to Donation database successful!"); //You can take these system prints out. Get annoying sometimes.
    		} catch (Exception e) {
            System.out.println("Connection to Donation database failed");
            e.printStackTrace();
    		}
    	}
    	
    	public static void startProcess(final Player player) {  //Choose which payment options give which things.
    		createConnection();
    		if(checkDonation(player.getUsername())) {
    			if(player.getInventory().getFreeSlots() < 10) {
    				player.getPackets().sendGameMessage("<col=00FFCC>Create some more space in your inventory Before doing this!");			
    				return;
    			}
    			/*
    			*	READ THIS!!!
    			*   To Choose which item they would get simple edit the below product id's.
    			*   Example: If they chose option number 4 on the website, the product id would be 4.
    			*/
    			if(checkDonationItem(player.getUsername()) == 1) { //Productid 1 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Received : Regular Donator!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				if (!player.isDonator()) {
    					player.setDonator(true);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    				player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 2) { //Productid 2 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Received : Extreme Donator!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				if (!player.isDonator()) {
    					player.setDonator(true);
    				if (!player.issuperDonator()) {
    					player.setsuperDonator(true);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				}
    				}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 3) { //Productid 3
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Received : Super Extreme Donator!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				if (!player.isDonator()) {
    					player.setDonator(true);
    				if (!player.issuperDonator()) {
    					player.setsuperDonator(true);
    				if (!player.isextremeDonator()) {
    					player.setextremeDonator(true);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				}
    				}
    				}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 4) { //Productid 4 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : PartyHat Set!");
    				player.getInventory().addItem(1038, 1);
    				player.getInventory().addItem(1040, 1);
    				player.getInventory().addItem(1042, 1);
    				player.getInventory().addItem(1044, 1);
    				player.getInventory().addItem(1046, 1);
    				player.getInventory().addItem(1048, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 5) { //Productid 5
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : H'Ween Set!");
    				player.getInventory().addItem(1053, 1);
    				player.getInventory().addItem(1055, 1);
    				player.getInventory().addItem(1057, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 6) { //Productid 6
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Santa Hat!");
    				player.getPackets().sendGameMessage("<col=00FFCC>The donatorzone can be found by the portal at home or ::donatorzone");
    				player.getInventory().addItem(1050, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 7) { //Productid 7
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Mystery Box's");
    				player.getInventory().addItem(6199, 10);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 8) { //Productid 8 
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Torva Set!");
    				player.getInventory().addItem(20135, 1);
    				player.getInventory().addItem(20139, 1);
    				player.getInventory().addItem(20143, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 9) { //Productid 9
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Virtus Set!");
    				player.getInventory().addItem(20159, 1);
    				player.getInventory().addItem(20163, 1);
    				player.getInventory().addItem(20167, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    			if(checkDonationItem(player.getUsername()) == 10) { //Productid 10
    				player.getPackets().sendGameMessage("<shad=cc0ff><img=1>You Have Recieved Your : Pernix!");
    				player.getInventory().addItem(20147, 1);
    				player.getInventory().addItem(20151, 1);
    				player.getInventory().addItem(20155, 1);
    					for(Player p : World.getPlayers()) {
    						if (p ==null) {
    							continue; 
    						}
    					player.getPackets().sendGameMessage("Enjoy Your Donation, Thanks for Donating!!");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1>" + player.getUsername() + "has donated tell him thanks for contributing!<img=1>");
    				p.getPackets().sendGameMessage("<shad=cc0ff><img=1Donate at pkerz614.com!<img=1>");
    					}
    				donationGiven(player.getUsername());		
    			}
    		}
    	}
    	
    	public static ResultSet query(String s) throws SQLException {
    		try {
    			if (s.toLowerCase().startsWith("select")) {
    				ResultSet rs = stmt.executeQuery(s);
    				return rs;
    			} else {
    				stmt.executeUpdate(s);
    			}
    			return null;
    		} catch (Exception e) {
    			destroyConnection();
    		}
    		return null;
    	}
    
    	public static void destroyConnection() {
    		try {
    			stmt.close();
    			con.close();
    		} catch (Exception e) {
    		}
    	}
    
    	public static boolean checkDonation(String playerName) {
       
            try {
    			String name2 = playerName.replaceAll("_", " ");
                Statement statement = con.createStatement();
                String query = "SELECT * FROM donation WHERE username = '" + name2 + "'";
                ResultSet results = statement.executeQuery(query);
    				while(results.next()) {
                        int tickets = results.getInt("tickets"); //tickets are "Recieved" technically. 0 for claimed, 1 for not claimed.
                            if(tickets == 1) {                     
                             return true;
                             }
                                    
                            }
                    } catch(SQLException e) {
                            e.printStackTrace();
                    }
    				
                    return false;
    				
            }
    	
    	public static int checkDonationItem(String playerName) {
            
            try {
    			String name2 = playerName.replaceAll("_", " ");
    			Statement statement = con.createStatement();
                String query = "SELECT * FROM donation WHERE username = '" + name2 + "'";
                ResultSet results = statement.executeQuery(query);
                    while(results.next()) {
                        int productid = results.getInt("productid");
                            if(productid >= 1) {				                          
    							return productid;
                                }
    								                               
                            }
                    } catch(SQLException e) {
                            e.printStackTrace();
                    }
    				
                    return 0;
    				
            }		
    	
    	public static boolean donationGiven(String playerName) {       
                  
    			  try
                    {
    				String name2 = playerName.replaceAll("_", " ");
    				query("DELETE FROM `donation` WHERE username = '"+name2+"';");
                           // query("UPDATE donations SET tickets = 0 WHERE username = '" + playerName + "'");
    						//query("UPDATE donations SET productid = 0 WHERE username = '" + playerName + "'");
    						
                    } catch (Exception e) {
                            e.printStackTrace();
    						
                            return false;
                    }
                    return true;
            }	
    	
    }
    Enjoy (:
    Credits:
    Demon Dillon


    Thanks for this may use.
    Reply With Quote  
     

  6. #5  
    Aganoth Developer

    Aust1n's Avatar
    Join Date
    Aug 2012
    Posts
    1,857
    Thanks given
    280
    Thanks received
    406
    Rep Power
    60
    for some reason this looks like the one from Pwnerzscape




    Reply With Quote  
     

  7. #6  
    Registered Member
    Join Date
    Jun 2012
    Posts
    467
    Thanks given
    216
    Thanks received
    79
    Rep Power
    0
    This was released on rl for dementhium. This has only been converted which eclipse quick fix could do.
    Reply With Quote  
     

  8. #7  
    Ignorance is always an excuse

    Mikee's Avatar
    Join Date
    Nov 2009
    Posts
    2,370
    Thanks given
    732
    Thanks received
    490
    Rep Power
    656
    Nice contribution, might use this.



    The day Aj repped me, my life changed forever
    Quote Originally Posted by Aj View Post
    Rep++ for you
    Reply With Quote  
     

  9. #8  
    Super Donator


    Join Date
    Mar 2009
    Age
    28
    Posts
    1,388
    Thanks given
    316
    Thanks received
    408
    Rep Power
    608
    Quote Originally Posted by Mikee View Post
    Nice contribution, might use this.
    I wouldn't, it uses multiple queries when it can just use one, might wanna change it if you do though.
    Reply With Quote  
     

  10. Thankful user:


  11. #9  
    Ignorance is always an excuse

    Mikee's Avatar
    Join Date
    Nov 2009
    Posts
    2,370
    Thanks given
    732
    Thanks received
    490
    Rep Power
    656
    Quote Originally Posted by RuneCore View Post
    I wouldn't, it uses multiple queries when it can just use one, might wanna change it if you do though.
    Thanks I'll keep that in mind



    The day Aj repped me, my life changed forever
    Quote Originally Posted by Aj View Post
    Rep++ for you
    Reply With Quote  
     

  12. #10  
    Developer

    Holy Symbol's Avatar
    Join Date
    Dec 2011
    Age
    25
    Posts
    1,763
    Thanks given
    1,093
    Thanks received
    239
    Rep Power
    365
    Thank you
    Spoiler for big sig:


    Reply With Quote  
     

Page 1 of 9 123 ... LastLast

Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Auto donations help
    By ownerdivine in forum Help
    Replies: 8
    Last Post: 10-05-2012, 07:38 PM
  2. auto donations
    By Jazok in forum Buying
    Replies: 1
    Last Post: 01-13-2012, 07:51 AM
  3. Auto donations
    By Rainex in forum Help
    Replies: 4
    Last Post: 04-06-2011, 02:23 AM
  4. [PI] Auto Donations [50$]
    By HiImRusty in forum Requests
    Replies: 4
    Last Post: 02-27-2011, 10:11 AM
  5. [PI] Auto Donations [50$]
    By HiImRusty in forum Show-off
    Replies: 0
    Last Post: 02-25-2011, 03:11 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •