Inactive [WEB/SEC/ADMN] MCbb v.1.12 phpbb/mybb Forum White and Greylist Connection Server<->Forum[1.2.5]

Yes but user details are in a different table where do I input the table in the config? Also what to do with verifyuser, sorry I've never seen that before and I think anon login is disabled for me

 

Code:

23:11:10 [INFO] mcbb lookup [PLAYERNAME] -> Displays whether player has Forum Account or not
>mcbb lookup xxxxxxxx
23:11:23 [WARNING] Unexpected exception while parsing console command
org.bukkit.command.CommandException: Unhandled exception executing command 'mcbb' in plugin MCbb v1.8.0.0
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:42)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:386)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:382)
        at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:574)
        at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:551)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:435)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
Caused by: java.lang.NullPointerException
        at de.javakara.manf.software.ForumSoftware.getSoftwareObject(ForumSoftware.java:11)
        at de.javakara.manf.mcbb.MCbbCommands.onCommand(MCbbCommands.java:44)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
        ... 7 more

That was upon using the lookup command (as you can see). Doesn't bug me personally, because I doubt I'll be using that often. Nevertheless, I thought it would be useful to know. That's with the 1.9.1 dev.

 

Flobi i hate this command personally, because its complicates everything

aciid First the anon User was a test for phpbb users, but other scripts dont have something like this, you can change it to an existing user. The anonymous user can be changed to an any other user(even to yourself) , it just tests if it can connect to database, and looks for the username then. You just need to enter the field id(you can see that in the URL e.g.) its in the config a value you can change(field.id) You dont need to enter a database table by yourself

 

When trying to make a new group in phpbb i get this error:

Code:

General Error
SQL ERROR [ mysqli ]
 
Field 'servergroup' doesn't have a default value [1364]

How can i make the 'servergroup' field that was added have a default value?

 

Nick Hooper the fasted way is just remove servergroup and add it afterwards, i had a fix for this, but i have forgot which it was exactly

 

Sorry I'm still lost

I have the forum mysql database, in this there is
-table mybb_users containing usernames/passwords/uid/etc (fid = username, password, ip,regdate)
-table mybb_userfields containing custom profile input like minecraft name/youtube video/country/etc (fid = fid1, fid2, fid3)

How would that work?

 

aciid use id 1 in the config?

 

Hey blargh

I love how active you are!

But i hate how i can't get this to work LOL

Here is my problem... as mentioned above by other people... this is what i get when a player joins.

Code:

13:18:06 [INFO] agrro5 [/90.220.162.249:54576] logged in with entity id 134 at ([Industrial] -308.71875, 65.0, 684.25)
13:18:06 [SEVERE] Could not pass event org.bukkit.event.player.PlayerJoinEvent to MCbb
org.bukkit.event.EventException
    at org.bukkit.plugin.java.JavaPluginLoader$103.execute(JavaPluginLoader.java:1026)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:57)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:453)
    at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:133)
    at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:121)
    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61)
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:543)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:441)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.bukkit.plugin.java.JavaPluginLoader$103.execute(JavaPluginLoader.java:1024)
    ... 9 more
Caused by: java.lang.NullPointerException
    at de.javakara.manf.software.ForumSoftware.getSoftwareObject(ForumSoftware.java:11)
    at de.javakara.manf.mcbb.GreyPlayerListener.onPlayerJoin(GreyPlayerListener.java:32)
    ... 14 more

I have tried your stable 1.8 builds, I have tried 1.9, and even 1.9.1 and still get the same error.

I also updated PEX to the latest, happens on both older version and newest.

Here is my mcbb config file, but dont think it has something to do with that.

Code:

System:
  lang:
    teach: 'Teaching MCbb '
  Validate:
    start: '[MCbb] Validating Configs'
    confSucess: '[MCbb] Configs validated'
    mysql:
      host: '[MCbb] Creating MySQL Host'
      port: '[MCbb] Creating MySQL Port'
      user: '[MCbb] Creating MySQL User'
      password: '[MCbb] Creating MySQL Password'
      database: '[MCbb] Creating MySQL Database'
      prefix: '[MCbb] Creating MySQL Prefix'
      testedSucess: '[MCbb] MySql was tested by User Verifikation Anonymous!'
  conf:
    loading: '[MCbb] Loading Configs'
    loadSucess: '[MCbb] Configs loaded'
  state:
    seton: '[MCbb] turned on'
    'on': '[MCbb] Plugin is currently activated'
    'off': '[MCbb] Plugin is currently deactivated'
    setoff: '[MCbb] turned off'
  info:
    registerFirst: '[MCbb] First register on the Forum!'
    auth: '[MCBB] Player <player> is authenticated!'
    kick: Server is Reloading; Please register on the Forum!
    whitelist: Not on Whitelist! Register on the Forum;
    newUpdate: '[MCbb] New Update!'
    greyActivated: '[MCbb] Greylist activated'
    whiteActivated: '[MCbb] Whitelist activated'
  error:
    unknownType: Type is unknown! Disabeling Plugin
    noPerm: '&2[MCbb] Permission error!'
  update:
    version: Version
    currversion: 'Current Version: '
    latestversion: 'Latest Version: '
    location: http://exo-network.de/manf/index.php
  misc:
    enabled: '[MCbb] loaded ->'
    disabled: '[MCbb] unloaded ->'
mysql:
  forumtyp: phpbb
  verifyuser: anonymous
  host: *******
  port: 3306
  user: *******
  password: *******
  database: *******
  prefix: *******
general:
  type: Greylist
  authType: Field
  syncGroups: 'false'
  greylist:
    protection:
      damageEntities: 'true'
      lootItems: 'true'
      dropItems: 'true'
      chat: 'true'
      interact: 'true'
      command: 'true'
field:
  id: 2
economy:
  moneyPerPost: '0'

 

What I meant is mybb_users contains the forum usernames
But I want to match the player login with the Minecraft username in mybb_userfields and the password from mybb_users

 

aciid what do you want with passwords oO
BigBenM Other plugins , do you have vault? and could you post a sql database of the User database and the field db

 

Oh I thought this plugin had /login password command, fuck lol so stoned

 

aciid this will be added if i fixed that weird bug cause by unknown reasons

 

Just to let you know, I'll try to finish the video for tomorrow. I am very busy... :/

 

blargh can you help me whit your plugin?? my skype name is danilonba22

 

As promised! The video for the setup of MCBB with phpbb (GroupSync). The instructions are in French. If someone could translate it into English, it would be very apreciate.

Code:

Prérequis :
MCbb
Vault
PermissionsEx (ou un autre plug-in de permission compatible avec superperms.)
Notepad++
 
 
1) Mettez dans le dossier Plugins : MCbb, Vault et PermissionsEX (ou un autre plug-in de permissions compatible avec superperms).
2) Démarrez le serveur pour générer les fichiers de configuration.
3) Ouvrez le fichier de configuration de MCbb avec Notepad++.
4) Modifiez les informations de la base de données MYSQL.
5) Changez le authType pour Username et SyncGroups à True.
6) Les protections de la greylist sont par défaut toutes à True. Libre à vous de les modifiés.
7) Enregistrez le fichier
8) Maintenant, allez modifier les permissions de PermissionsEx avec Notepad++ et créer vos groupes.
9) Ajoutez la permission : mcbb.user.join dans les groupes.
10) Enregistrez le fichier
11) Faites un Reload de vos plug-ins dans la console.
12) Allez dans PhpMyAdmin et cliquez sur la base de données du forum.
13) Cliquez ensuite sur SQL, en haut dans les onglets.
14) Tapez ce code : ALTER TABLE phpbb_groups ADD servergroup TEXT NOT NULL
15) Cliquez sur Go
16) Tapez ensuite ce code : UPDATE phpbb_groups set servergroup='default'
17) Cliquez sur Go
18) Allez dans la table phpbb_groups
19) Cliquez sur ADMINISTRATORS (Edit) et tapez dans le champ (server_group) : administrator
20) Cliquez ensuite sur Go
21) Faites la même chose pour GLOBAL_MODERATORS
22) Vous avez terminé! Lancez Minecraft pour essayer!
 
Si un joueur n'est pas enregistré sur le forum, un message l'avertira de s'enregistrer (il ne pourra rien faire).
 
Les Modérateurs et Administrateurs seront automatiquement placés dans leur groupe avec leurs permissions.
 
Bon jeu à tous!

 

I Like this plugin but it doesnt seem to work with permission's 3 is there a way you could implement it into this plugin it would greatly be apreciated thank

 

@blargh I have sent you the phpBB3 database schema I am using.

 

KlaasT Im busy at the moment i will be more active on when i have more time
TwiztedPsyko No. Permisson3 is history, pex/bpermissions etc are the ones, that are active

 

blargh

If you could please please please upload the files you are using. I tried starting completely over with only the following:

Bukkit 1.1 R3
Vault 1.2.8
PEX 1.18 & 1.2 Dev
mcBB 1.9.0.1

I am still getting the

[SEVERE] Could not pass event org.bukkit.event.player.PlayerJoinEvent to MCbb org.bukkit.event.EventException

I tried re downloading Bukkit, fresh new install, not modded, no other plugins and still get the same error.

Maybe Francois can send me his entire package (minus the mcBB server info of course).

Someone please help!

EDIT: Ill even allow someone to log into my PC with Team Viewer to help me... I cannot figure this out and im usually very good with plugins and server stuff.

 

BigBenM, KlaasT yes im a fool....
I think i got that weired bug.
change mysql.forumtyp to mysql.forumtype
should work then
danilonba i cant help you specially, sorry if you ask a specific question, yes of course

 

You would be correct!!! yay... but now I get "Incative" when i use mcbb lookup... I think my field link is incorrect

Sorry one last help request:

I have 2 custom profile fields in phpBB.

I would like to use Minecraft name field... which is ID:2

I know this because when i log intot the database using phpmyadmin, and go to phpbb_profile_fields, the ID is 2. My config for mcbb is set to field: id: 2 even tried '2'... and still when i log on, it says i have to register in order to do anything....

I'm also pretty sure that my server connection setup is also accurate..

Anybody have any suggestions?

EDIT:

If i switch the type to Username, then it works and on playerjoin, I see Player Authenticated. and i can then interact with minecraft world...

Why is the custom profile field ID not working?? please see my post on page 9 of this thread for my config file.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

BigBenM could you trie just reconecting? dunno why but on my testserver it works then.

 

Nah, still doesn't work. Tried several attempts. Like I said, works with Username, but not custom field. You're sure you have it checking phpbb_profilefield table? Or what table do you query?

Yeah its strange... if I have Username as the type... and do mcbb lookup bigbenm it comes back saying active!

If i switch back to field type, and do lookup bigbenm it comes back inactive, even after restarting the server.

Do you have your source code up anywhere? maybe i can poke around and figure out why

I think i got it...

Took me 3 hours to dissect your code but i got it!

I will try to compare code to see what i changed... lol

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

blargh That would be a good idea to put the video in the first post. I'll make the instructions in English probably this weekend.

 

BigBenM yea would be pretty
FrancoisBerg it is in a spoiler on the top

 

So, now this plugin also works fine for me. Thank You! It was the thing with typ/type. But I just getting an error when I use the command "mcbb lookup".

Code:

>mcbb lookup test
20:44:37 [INFO] [MCbb] Permission error!

 

TheHandsomePete mcbb lookup is a bit bugged. You need the permissions btw

 

blargh Also when I use it via console?

 

TheHandsomePete idc. my testing server worked, but alot of people said there is a bug

Having some issues because i have no MC Account at the moment(myaccount went back to his original owner) will have to look how i get a new account

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Ok... I didn't even see that one Thanks. However now I've got a similar problem like BigBenM has .

I'll try to explain it. It doesn't matter if I've got my nick written in my board profile. When I've set a value to "true" that action isn't allowed for anyone. If it is set to "false" it is allowed for everyone. So currently it works as if it was a general permission setting.