Jump to content

pkmaster

Member
  • Content count

    267
  • Joined

  • Last visited

  1. server side or website side? will u pay?
  2. [quote name='davidpaceway']I have the same issue at the moment, it worked before but it stopped, but I don't use xampp.[/QUOTE] i got the same problem
  3. which revision ill do it if u pay me =D
  4. u dont need to portfoward ur computer if u get a vps.only the place where the server is hosted needs to have portfowarded
  5. pkmaster

    Portforwarding

    hmm im on atm message me when u free?
  6. pkmaster

    Portforwarding

    itzmydest ill do it for u add me [email][email protected][/email]
  7. can u help me with the pm i sent u?

  8. [quote name='asaads']i got ready the codes put it dont works[/QUOTE] you have to remote ur mysql vis ur website for this to work.
  9. asdrftgyhj
  10. it should be this. [QUOTE]package com.rs.game.database; 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; /* *@Author RuneUnited/Ownster (Horrid Peace of coding) */ public class VoteStartup { 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="127.0.0.1"; String DB="Vote"; String User="Vote"; String Pass="Password"; con = DriverManager.getConnection("jdbc:mysql://"+IP+"/"+DB, User, Pass); stmt = con.createStatement(); } catch (Exception e) { destroyConnection(); System.err.println("Connection to Votes database failed"); //e.printStackTrace(); } } 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 checkVotes(String playerName) { try { String name2 = playerName.replaceAll("_", " "); Statement statement = con.createStatement(); String query = "SELECT * FROM Votes WHERE username = '" + name2 + "'"; ResultSet results = statement.executeQuery(query); while(results.next()) { int recieved = results.getInt("recieved"); if(recieved == 0) { return true; } } } catch(SQLException e) { e.printStackTrace(); } return false; } public static boolean voteGiven(String playerName) { try { String name2 = playerName.replaceAll("_", " "); query("UPDATE Votes SET recieved = 1 WHERE username = '" + name2 + "'"); } catch (Exception e) { e.printStackTrace(); return false; } return true; } public static void startVoteProcess(final Player player) {//All of this checks for votes then if the reward was already given createConnection(); //Starts Mysql Connection player.getPackets().sendGameMessage("<col=00FFCC>Checking Votes..."); if(checkVotes(player.getUsername())){ if(voteGiven(player.getUsername())) { player.setVotingPoints(player.getVotingPoints() + 1); player.getPackets().sendGameMessage("<col=00FFCC>Thank you for voting! Be Sure To Vote Again In 24 Hours!"); player.getPackets().sendGameMessage("<col=00FFCC>Go To the VoteShop at home to Get Your Reward!"); player.getPackets().sendGameMessage("<col=00FFCC>You Now Have " +player.getVotingPoints()+" Vote Points"); player.getPackets().sendGameMessage("<col=00FFCC>You Now Voted " +player.getTimesVoted()+" Times"); destroyConnection(); } else { player.getPackets().sendGameMessage("<col=00FFCC>You Have Already Voted/Recieved Award/Not Voted In The Past 24 Hours"); player.getPackets().sendGameMessage("<col=00FFCC>You Currently Have " +player.getVotingPoints()+" Vote Points"); destroyConnection(); } } else { player.getPackets().sendGameMessage("<col=00FFCC>You Have Already Voted/Recieved Award/Not Voted In The Past 24 Hours"); player.getPackets().sendGameMessage("<col=00FFCC>You Currently Have " +player.getVotingPoints()+" Vote Points"); destroyConnection(); } } }[/QUOTE]
  11. does any 1 knw how to fix the gpi on matrix source?
  12. [quote name='korasi pr0dx']dont think i got it. resend it. :)[/QUOTE] sent it again my inbox was full
  13. Dragon KK's Runescape Sprites Editor
×