WBB Connect 1.4.1 - Verbinde Server und Forum

Bubelbub · 15. August 2011

Echt gut gelungen.
Ich hab selber auch so ein Filterscript programmiert.

Nur diverse Sachen wurden nicht bedacht.
Aber die kann man ja noch nach "updaten".

Ich modde deins mal

AC/DC · 15. August 2011

Ich frage einfach nochmal:
wie kann ich deinem System Überprüfen ob er auf der Datenbank zugreift ?

Flojoe7 · 15. August 2011

Wie muss ich das im Gamemode einbinden

Im FS kann mann ja nicht die Daten für Mysql eintragen er muss ja die Daten wissen für Mysql

|-|auke · 15. August 2011

Dafür ist die Funktion "WBB_SetMySQLData" zuständig.

@AC/DC : Was meinst du damit?

AC/DC · 15. August 2011

Das Script muss ja mit mysql Verbinden aber wie bekomme ich raus das er sich damit Connecten hat um da was zu ändern ?

|-|auke · 15. August 2011

Schreib direkt über WBB_SetMySQLData
mysql_debug(1);
Und direkt unter deine includes schreibst du:

native mysql_debug(enable = 1);

Dann wird eine txt Datei erstellt, inder du lesen kannst ob die Verbindung erfolgreich ist.

8D · 15. August 2011

Sorry aber das widerspricht voll dem "Stil des WBB". Die Login Abfrage ist ja noch okay, aber der Rest sollte über Editor-Klassen wie PMEditor, UserEditor und Co. folgen, und nicht einfach nen paar Datenbankeinträge.

Also da hätte ich jetzt nen wenig Kommunikation mit den o.g Editoren erwartet.
Ist zwar ein wenig umständlicher, aber sorgfältiger. (Damit habe ich es damals bei BoB hinbekommen, threads und posts ingame zu schreiben und zu lesen).

Dennoch ist es besser, als wie von manch anderen.

Insgesammt gibt es hier ne 8/10.

/edit: paar Rechtschreibfehler beseitigt, der Rest bleibt drinnen.

AC/DC · 15. August 2011

Da drinne verstehe ich nur Bahnhof ?

PHP

[16:16:38]  


[16:16:38] ---------------------------


[16:16:38] MySQL Debugging activated (08/15/11)


[16:16:38] ---------------------------


[16:16:38]  


[16:17:06] >> mysql_connect( )


[16:17:06] CMySQLHandler::Connect() - Access denied for user 'mprlroot'@'ipetc' (using password: YES) (Error ID: 1045)


[16:17:06]  


[16:17:06] ---------------------------


[16:17:06] MySQL Debugging activated (08/15/11)


[16:17:06] ---------------------------


[16:17:06]  


[16:17:13] >> mysql_format( Connection handle: 1 )


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_store_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:17:13] >> mysql_fetch_row_format( Connection handle: 1 )


[16:17:13] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_free_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:17:13] >> mysql_format( Connection handle: 1 )


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_store_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:17:13] >> mysql_fetch_row_format( Connection handle: 1 )


[16:17:13] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_free_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:17:13] >> mysql_format( Connection handle: 1 )


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_store_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:17:13] >> mysql_fetch_row_format( Connection handle: 1 )


[16:17:13] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_free_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_store_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:17:13] >> mysql_fetch_row_format( Connection handle: 1 )


[16:17:13] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_free_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:17:13] >> mysql_format( Connection handle: 1 )


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_store_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:17:13] >> mysql_fetch_row_format( Connection handle: 1 )


[16:17:13] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_free_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:17:13] >> mysql_format( Connection handle: 1 )


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_store_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:17:13] >> mysql_fetch_row_format( Connection handle: 1 )


[16:17:13] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_free_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:17:13] >> mysql_format( Connection handle: 1 )


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_store_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:17:13] >> mysql_fetch_row_format( Connection handle: 1 )


[16:17:13] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:17:13] >> mysql_free_result( Connection handle: 1 )


[16:17:13] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:17:13] >> mysql_format( Connection handle: 1 )


[16:17:13] >> mysql_query( Connection handle: 1 )


[16:17:13] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

Alles anzeigen

8D · 15. August 2011

Er hat nicht connected.
Wahrscheinlich ist das PW falsch. Oder andere Zugangsdaten.

[NeS]ThomasTailor93 · 15. August 2011

Hey,

ich würde auch gerne dieses System in Anspruch nehmen, aber ich habe keine Ahnung, wie ich über das System eine Verbindung zur MySQL Datenbank lege, da ich mich auf diesem Gebiet bezüglich des PAWN-MySQL-Scriptings nicht auskenne. Wäre es möglich, dass mir jemand bei der Einrichtung hilft?

Grüße, ThomasTailor93

AC/DC · 15. August 2011

WBB_SetMySQLData ( "46.4.113.22" , "mprlroot" , "pw" , "mprl" , 0 ); so richtig (unter ongamemodeinit)

|-|auke · 15. August 2011

Es war ein kleiner Fehler im Code, der das Verursacht haben könnte. Versuch es mit dem neuen Paket bitte erneut.

Edit: Nun ist der richtige Link da. Ich habe eben versehentlich den alten als den neuen eingefügt..

AC/DC · 15. August 2011

Habe ich probiert immer noch ...

PHP

[16:39:35]  


[16:39:35] ---------------------------


[16:39:35] MySQL Debugging activated (08/15/11)


[16:39:35] ---------------------------


[16:39:35]  


[16:39:46] >> mysql_format( Connection handle: 1 )


[16:39:46] >> mysql_query( Connection handle: 1 )


[16:39:46] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:39:46] >> mysql_store_result( Connection handle: 1 )


[16:39:46] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:39:46] >> mysql_fetch_row_format( Connection handle: 1 )


[16:39:46] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:39:46] >> mysql_free_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:39:47] >> mysql_format( Connection handle: 1 )


[16:39:47] >> mysql_query( Connection handle: 1 )


[16:39:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_store_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:39:47] >> mysql_fetch_row_format( Connection handle: 1 )


[16:39:47] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_free_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:39:47] >> mysql_format( Connection handle: 1 )


[16:39:47] >> mysql_query( Connection handle: 1 )


[16:39:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_store_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:39:47] >> mysql_fetch_row_format( Connection handle: 1 )


[16:39:47] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_free_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:39:47] >> mysql_query( Connection handle: 1 )


[16:39:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_store_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:39:47] >> mysql_fetch_row_format( Connection handle: 1 )


[16:39:47] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_free_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:39:47] >> mysql_format( Connection handle: 1 )


[16:39:47] >> mysql_query( Connection handle: 1 )


[16:39:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_store_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:39:47] >> mysql_fetch_row_format( Connection handle: 1 )


[16:39:47] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_free_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:39:47] >> mysql_format( Connection handle: 1 )


[16:39:47] >> mysql_query( Connection handle: 1 )


[16:39:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_store_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:39:47] >> mysql_fetch_row_format( Connection handle: 1 )


[16:39:47] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_free_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:39:47] >> mysql_format( Connection handle: 1 )


[16:39:47] >> mysql_query( Connection handle: 1 )


[16:39:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_store_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)


[16:39:47] >> mysql_fetch_row_format( Connection handle: 1 )


[16:39:47] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Connection is dead)


[16:39:47] >> mysql_free_result( Connection handle: 1 )


[16:39:47] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


[16:39:47] >> mysql_format( Connection handle: 1 )


[16:39:47] >> mysql_query( Connection handle: 1 )


[16:39:47] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

Alles anzeigen

[NeS]ThomasTailor93 · 15. August 2011

Benötigt man für dieses System ein MySQL Include von StrickenKid oder G-Stylez?

[JaY] · 15. August 2011

THX!!!!!
bist echt der beste habe nicht damit gerechnet dass jz so eine "antwort" auf meinen thread kommt!!!
werde mir noch eine belohnung für dich einfallen lassen

MfG JaY

AC/DC · 15. August 2011

Okay Er will jetzt drauf nur er meint es gibt diese DAtenbank nicht aber das Forum läuft ja auch darüber ... -.-

[16:47:57] >> mysql_query( Connection handle: 1 )

[16:47:57] CMySQLHandler::Query(SELECT userID FROM `wcf0_user` WHERE email = 'email') - An error has occured. (Error ID: 1146, Table 'mprl.wcf0_user' doesn't exist)

[16:47:57] >> mysql_store_result( Connection handle: 1 )

|-|auke · 15. August 2011

@ThomasTailor93: Du brauchst keine include.
@AC/DC: 0 ist keine normale Installationsnummer. Versuch es mit 1

AC/DC · 15. August 2011

Geil es geht, dankeeeeee^^

[NeS]ThomasTailor93 · 15. August 2011

Hi,

ich habe jetzt in meinem GameMode oben die

#include <wbb_connect>

hinzugefügt und unter OnGameModeInit

WBB_SetMySQLData ( "127.0.0.1" , "admin" , "psw" , "ses_samp" , 1 );

hinzugefügt, aber wenn ich mich jetzt einlogge auf den Server created er keinen Account im Forum. Mache ich etwas falsch?

Grüße, ThomasTailor93

DarthXela · 15. August 2011

Das Script erkennt ja nicht, wann es einen Account erstellen soll -.-
Das musst du schon selbst scripten, dass es bspw. bei einem Befehl oder bei der Registrierung den User im Forum registrieren soll.