Webwereld

errors

Gestart doorJacmob8 reacties33 weergaven
Log in om mee te praten

9 berichten · pagina 1 van 1

Jacmob

Lid · Topicstarter

Berichten
916
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
ik krijg telkens zulke errors

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at reading initial communication packet, system error: 111 in /home/*ban.php on line 17

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user apache@localhost (using password: NO) in /home/*/ban.php on line 18

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/*ban.php on line 18

Warning: mysql_query() [function.mysql-query]: Access denied for user apache@localhost (using password: NO) in /home/*ban.php on line 20

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/*ban.php on line 20


me php : 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Ultra Banlist</title>
</head>
<body>
<h1>Ultra Banlist</h1>
[COLOR= #0000BB]<?php[/COLOR]

[COLOR= #FF8000]// change these things[/COLOR]

   [COLOR= #0000BB]$server[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"74.121.181.226"[/COLOR][COLOR= #007700];[/COLOR]
   [COLOR= #0000BB]$dbuser[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"root"[/COLOR][COLOR= #007700];[/COLOR]
   [COLOR= #0000BB]$dbpass[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"root"[/COLOR][COLOR= #007700];[/COLOR]
   [COLOR= #0000BB]$dbname[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"database"[/COLOR][COLOR= #007700];[/COLOR]
   
[URL="http://www.php.net/mysql_connect"]mysql_connect[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$server[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dbuser[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$dbpass[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$dbname[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM banlist ORDER BY id DESC"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #FF8000]//This will display the most recent by id edit this query how you see fit. Limit, Order, ect.[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<table width=100% border=1 cellpadding=3 cellspacing=0>"[/COLOR][COLOR= #007700];[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr style="font-weight:bold">
<td>Type</td>
<td>Name</td>
<td>Reason</td>
<td>Admin/Mod</td>
<td>Time</td>
<td>TimeTempBan</td>
<td>id</td>

</tr>"[/COLOR][COLOR= #007700];[/COLOR]

[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700])){[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$col[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]"#eeeeee"[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$col[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"#ffffff"[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$col[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"#eeeeee"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr bgcolor=$col>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"5"[/COLOR][COLOR= #007700]){[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Unban</td>"[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"3"[/COLOR][COLOR= #007700]){[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Kick</td>"[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"2"[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Warn</td>"[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Banned</td>"[/COLOR][COLOR= #007700];
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700]){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>IPBanned</td>"[/COLOR][COLOR= #007700];
                }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"4"[/COLOR][COLOR= #007700]){[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Fine</td>"[/COLOR][COLOR= #007700];
                    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"6"[/COLOR][COLOR= #007700]){[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Jailed</td>"[/COLOR][COLOR= #007700];
                        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]type[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"9"[/COLOR][COLOR= #007700]){[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Perma</td>"[/COLOR][COLOR= #007700];
                            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>Unknown</td>"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #FF8000]//Holy Epic If Statement Batman![/COLOR]
                            [COLOR= #007700]}
                        }
                    }
                }
            }
        }
    }
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]name[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]reason[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #FF8000]//Convert Epoch Time to Standard format[/COLOR]
[COLOR= #0000BB]$datetime[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"F j, Y, g:i a"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]time[/COLOR][COLOR= #007700]]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>$datetime</td>"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$dateconvert[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"F j, Y, g:i a"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]temptime[/COLOR][COLOR= #007700]]);[/COLOR]  
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]temptime[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700]){[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>None</td>"[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>$dateconvert</td>"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];
}[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"</table>"[/COLOR]

?>
</div>
Ban database provided by UltraBans.
</body></html>


wat is er fout ;c
0
Jef

Lid

Berichten
2.682
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik zou vooral eff je database wachtwoord weg halen...
0
Aarclay

Lid

Berichten
10.421
Reputatie
4
Punten
0,00
Lid sinds
Laatst gezien
Draai je dit bij een webhosting, of op een NAS/eigen server?

En verzin eens een betere titel...
0
Jacmob

Lid · Topicstarter

Berichten
916
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Jef schreef:
Ik zou vooral eff je database wachtwoord weg halen...
is hem niet =)
Aarclay schreef:
Draai je dit bij een webhosting, of op een NAS/eigen server?

En verzin eens een betere titel...
minecraft server -------> versio
0
Aarclay

Lid

Berichten
10.421
Reputatie
4
Punten
0,00
Lid sinds
Laatst gezien
Jacmob schreef:
Eerdere citaten tonen
Aarclay schreef:
Draai je dit bij een webhosting, of op een NAS/eigen server?
En verzin eens een betere titel...

minecraft server -------> versio
Dit gaat toch over MySQL, en niet over MineCraft? Neem anders eens contact met Versio op.
0
Jacmob

Lid · Topicstarter

Berichten
916
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Aarclay schreef:
Eerdere citaten tonen
Jacmob schreef:
Eerdere citaten tonen
Aarclay schreef:
Draai je dit bij een webhosting, of op een NAS/eigen server?
En verzin eens een betere titel...

minecraft server -------> versio
Dit gaat toch over MySQL, en niet over MineCraft? Neem anders eens contact met Versio op.
van minecraft mysql gaat hij naar me script op versio yummie ip is al whitelisted op versio etc
0
Aarclay

Lid

Berichten
10.421
Reputatie
4
Punten
0,00
Lid sinds
Laatst gezien
Dus Minecraft heeft er niks mee te maken.

Al gegoogled op: Lost connection to MySQL server at reading initial communication packet, system error: 111
0
Bramdv

Lid

Berichten
38
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Misschien wat off-topic, maar om up-to date te zijn, gebruik je best geen mysql() functie meer.
Nieuwe vind je hier.
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Bramdv schreef:
Misschien wat off-topic, maar om up-to date te zijn, gebruik je best geen mysql() functie meer.
Nieuwe vind je hier.
Mysql blijft nog lang goed hooremo
Mysqli heeft oop als voordeel.
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren