These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

phpBB 3.x API Registration Mod v6+

Author
Laverol Saisima
Caldari Provisions
Caldari State
#1121 - 2014-12-14 21:28:52 UTC  |  Edited by: Laverol Saisima
Is it possible to disable deactivation of accounts created by hand without the api?
//edit
Ok, I found it.
There is another problem. When someone form corp listed in cron settings have different forum group (which has turn immune option on) than cron assign to that corp member, it change default group to default corp group. It is possible to disable changing default group for members of immune group?
//edit2
Ok, i found it too :D
Is there any options to show users corporation in their profile?
Snitch Ashor
Republic Military School
Minmatar Republic
#1122 - 2014-12-17 12:32:23 UTC
Hi all!

I have updated the eveapi tables for Rhea:

eveapi_rhea.zip

it contains an sql file updating ships, items and systems as well as two faction images that go to the images/eve/races/ folder.

Maybe do a backup of eveapi_ships, _items and _systems before. If you encounter any errors, just let me know. They are created in a semi-automated way from the static data dump, so they are not fully tested.

Cheers.
Orunis Sobek
Center For Kids Who Can't Fly Good
Zoo Landers
#1123 - 2014-12-17 19:29:03 UTC
Anyone ever run into the following?

Made some changes to our theme but when I try to re-apply the Eve-Mod to the theme, it does not show up in the list of themes that I can apply eve-mod to. Is it possible to update/refresh that list?

John Wilder
Sons of Bendeguz
Phoenix Cartel.
#1124 - 2014-12-27 13:43:08 UTC
I cannot find the package on the eve-it.org website (no link). Can anyone give me a download link? (I cannot download the EVE bbcode either)

Michael Mach
Arx One
#1125 - 2014-12-29 01:40:33 UTC
John Wilder wrote:
I cannot find the package on the eve-it.org website (no link). Can anyone give me a download link? (I cannot download the EVE bbcode either)



https://github.com/Cyerus

Here you go sir.
John Wilder
Sons of Bendeguz
Phoenix Cartel.
#1126 - 2014-12-29 16:21:56 UTC
Michael Mach wrote:
John Wilder wrote:
I cannot find the package on the eve-it.org website (no link). Can anyone give me a download link? (I cannot download the EVE bbcode either)



https://github.com/Cyerus

Here you go sir.


Cheers mate! Have a Happy New Year! :)
Letto Atreides
Still Water Intergalactic Holdings
#1127 - 2014-12-30 14:53:41 UTC  |  Edited by: Letto Atreides
It doesn't look like the API package is complete on github has anyone had success installing it?

It looks like Cyerus is in the process (and has been since march) of splitting the API into separate packages. however the API package is incomplete and the lynx package doesnt' have the side scripts for ejabberd.

Can someone provide a link to the "old" allin one package? (EVE API 6.3.0 for phpBB 3.0.12)
John Wilder
Sons of Bendeguz
Phoenix Cartel.
#1128 - 2014-12-30 18:44:22 UTC
Letto Atreides wrote:
It doesn't look like the API package is complete on github has anyone had success installing it?

It looks like Cyerus is in the process (and has been since march) of splitting the API into separate packages. however the API package is incomplete and the lynx package doesnt' have the side scripts for ejabberd.

Can someone provide a link to the "old" allin one package? (EVE API 6.3.0 for phpBB 3.0.12)



EVE API 6.3.1 for phpBB 3.0.12
EVE-Online-BBcode-v1-0-0
Suun Ablehart
Parallax Shift
#1129 - 2015-01-03 06:28:26 UTC  |  Edited by: Suun Ablehart
fixed it :O

Parallax SHIFT // @SuunAblehart

Recruiting Pilots // Low-sec Pirate Corp

darthmoll Amatin
FAYN Industries
#1130 - 2015-01-05 11:55:32 UTC  |  Edited by: darthmoll Amatin
hey guys. i am setting up a forum with this mod. but it seems i am missing some files. can someone please tell me where to find the missing fils as they are not included in the package.

i am gettnig this error

[phpBB Debug] PHP Warning: in file [ROOT]/common.php on line 131: require(.//includes/eveapi/functions_eveapi.php): failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/common.php on line 131: require(.//includes/eveapi/functions_eveapi.php): failed to open stream: No such file or directory


EDIT: never mind. 2 posts above was the full file. its working now. my bad
darthmoll Amatin
FAYN Industries
#1131 - 2015-01-05 14:56:33 UTC
ke i have a issue. i followed the video tutorials on installing everything and setting it up. issue is with registration of new people.

i have corporation enabled to check but get a error when registration is completed. the user is registered tho.

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.



anyone have any info on this?
0mni Ca
Brutor Tribe
Minmatar Republic
#1132 - 2015-01-07 00:25:06 UTC
I modified the eveapi_setForumGroups, so that way it will take into account the REGISTERED user group and speciel group types. I found it rather annoying that it would modify the "Administrators" group by default, instead of allowing you to opt out. Anyway, take it or leave it :)

/**
* Sets character's Forum permissions
*/
function eveapi_setForumGroups($userId, $forumGroupsNew, $characterName = "---")
{
    global $db, $config, $user;
    
    if(!is_array($forumGroupsNew))
    {
        $forumGroupsNew = array();
    }

    // Grab all the forumgroups and put them into an array to be able to easily request values for EVE related stuffz
    $forumGroupInfo = array();
    $sql = "SELECT group_id, group_type, group_name, group_eveapi_special, group_eveapi_ts3, group_eveapi_jabber, group_eveapi_openfire
            FROM " . GROUPS_TABLE;
    $result = $db->sql_query($sql);

    while ($row = $db->sql_fetchrow($result))
    {
        $forumGroupInfo[$row['group_id']]['group_name'] = $row['group_name'];
        $forumGroupInfo[$row['group_id']]['group_type'] = $row['group_type'];
        $forumGroupInfo[$row['group_id']]['group_eveapi_special'] = $row['group_eveapi_special'];
        $forumGroupInfo[$row['group_id']]['group_eveapi_ts3'] = $row['group_eveapi_ts3'];
        $forumGroupInfo[$row['group_id']]['group_eveapi_jabber'] = $row['group_eveapi_jabber'];
        $forumGroupInfo[$row['group_id']]['group_eveapi_openfire'] = $row['group_eveapi_openfire'];
        
        // Check if the group name is actually a language identifier
        // If so, grab the correct language string from the language file instead
        // ( group prefix is G_ )
        if(isset($user->lang["G_" . $row['group_name']]))
        {
            $forumGroupInfo[$row['group_id']]['group_name'] = $user->lang["G_" . $row['group_name']];
        }

        // By default the REGISTERED group_id is 2, but that may not be the case 100% of the time.
        if($row['group_name'] == 'REGISTERED')
        {
            $registeredGroupID = (int) $row['group_id'];
        }
    }
    $db->sql_freeresult($result);

    $forumGroups = array();
    $sql = "SELECT group_id
            FROM " . USER_GROUP_TABLE . "
            WHERE user_id = " . (int) $userId;
    $result = $db->sql_query($sql);
   
    while ($row = $db->sql_fetchrow($result))
    {
        $forumGroups[] = $row['group_id'];
    }
    $db->sql_freeresult($result);

    // All active users are part of the REGISTERED group.
    $forumGroups[] = $registeredGroupID;

    // Set array for TeamSpeak groups if Forum Groups are set to immune.
    $returnGroups = array();
    
    // Set jabber access to default (just in case)
    $returnGroups["jabber"] = false;
    $returnGroups["openfire"] = array();
    $returnGroups["TS"] = array();

    // Add existing Special phpBB groups to new groups to ensure they are not removed.
    foreach($forumGroups as $currentForumGroup)
    {
        if ($forumGroupInfo[$currentForumGroup]['group_type'] == GROUP_SPECIAL)
        {
            $forumGroupsNew = $forumGroupsNew + array($currentForumGroup => false);
        }
    }

    // All active users are part of the REGISTERED group, so it is always "New"
    $forumGroupsNew = $forumGroupsNew + array($registeredGroupID => false);

    // Loop groups to determine if we need to remove some permissions
    foreach($forumGroups as $currentForumGroup)
    {
        // User should not be in this group, or is the special group? Hhmmm...
        if(!isset($forumGroupsNew[$currentForumGroup]) && !$forumGroupInfo[$currentForumGroup]['group_eveapi_special'])
        {
            group_user_del($currentForumGroup, $userId);
            cronlog("Removing user from Forum group -> " . $forumGroupInfo[$currentForumGroup]['group_name'], $characterName);
        }
        else
        {
            // User is part of this group, add the TeamSpeak groupId to the list if the group  >0
            if($forumGroupInfo[$currentForumGroup]['group_eveapi_ts3'])
            {
                $returnGroups["TS"][] = $forumGroupInfo[$currentForumGroup]['group_eveapi_ts3'];
            }
                
            // Add ejabberd access aswell
            if($forumGroupInfo[$currentForumGroup]['group_eveapi_jabber'])
            {
                $returnGroups["jabber"] = true;
            }
            
            // Add OpenFire access aswell
            if($forumGroupInfo[$currentForumGroup]['group_eveapi_openfire'] != "")
            {
                $returnGroups["openfire"][] = $forumGroupInfo[$currentForumGroup]['group_eveapi_openfire'];
            }
        }
    }

    // Maybe we need to add groups
    foreach($forumGroupsNew as $currentForumGroup => $defaultGroup)
    {
        if(!in_array($currentForumGroup, $forumGroups))
        {
            group_user_add($currentForumGroup, $userId, false, false, (($defaultGroup) ? true : false));
            cronlog("Adding user to Forum group -> " . $forumGroupInfo[$currentForumGroup]['group_name'], $characterName);
        }
        else
        {
            cronlog("User already part of Forum group -> " . $forumGroupInfo[$currentForumGroup]['group_name'], $characterName);
        }

        // User should be part of this group, add the TeamSpeak groupId to the list if the group  >0
        if($forumGroupInfo[$currentForumGroup]['group_eveapi_ts3'])
        {
            $returnGroups["TS"][] = $forumGroupInfo[$currentForumGroup]['group_eveapi_ts3'];
        }

        // Add ejabberd access aswell
        if($forumGroupInfo[$currentForumGroup]['group_eveapi_jabber'])
        {
            $returnGroups["jabber"] = true;
        }

        // Add OpenFire access aswell
        if($forumGroupInfo[$currentForumGroup]['group_eveapi_openfire'] != "")
        {
            $returnGroups["openfire"][] = $forumGroupInfo[$currentForumGroup]['group_eveapi_openfire'];
        }
    }
   
    return $returnGroups;
}
John Wilder
Sons of Bendeguz
Phoenix Cartel.
#1133 - 2015-01-08 00:01:26 UTC  |  Edited by: John Wilder
0mni Ca wrote:
I modified the eveapi_setForumGroups, so that way it will take into account the REGISTERED user group and speciel group types. I found it rather annoying that it would modify the "Administrators" group by default, instead of allowing you to opt out. Anyway, take it or leave it :)


OK, but where should I paste this code?

nvm found it.
redlinedracer
ASMODEUS INFINITE
#1134 - 2015-01-13 23:00:09 UTC
John Wilder wrote:
0mni Ca wrote:
I modified the eveapi_setForumGroups, so that way it will take into account the REGISTERED user group and speciel group types. I found it rather annoying that it would modify the "Administrators" group by default, instead of allowing you to opt out. Anyway, take it or leave it :)


OK, but where should I paste this code?

nvm found it.



Okay, to help others (like myself) where was it? haha
redlinedracer
ASMODEUS INFINITE
#1135 - 2015-01-14 00:19:38 UTC
oh, and do we have a new download link for this mod?

When i installed the mod using the link provided above (Not by the modder) it said it was successful but i didn't notice any additional options within the admin section of my forums.

Am i doing something wrong?

Thanks!
Snitch Ashor
Republic Military School
Minmatar Republic
#1136 - 2015-01-14 09:58:14 UTC
Hi all,

I just created the tables eveapi_ships, _items and _systems updated for proteus 1.0:

eveapi_proteus.sql.gz

As I don't really know what I'm doing you'd better have a backup, but at least for me it works.

Cheers,
Snitch
Snitch Ashor
Republic Military School
Minmatar Republic
#1137 - 2015-01-14 16:48:38 UTC
redlinedracer wrote:
oh, and do we have a new download link for this mod?

When i installed the mod using the link provided above (Not by the modder) it said it was successful but i didn't notice any additional options within the admin section of my forums.

Am i doing something wrong?

Thanks!


The new options should show up in the left hand menu of the admin section at the very bottom.
0mni Ca
Brutor Tribe
Minmatar Republic
#1138 - 2015-01-15 01:25:45 UTC
I have converted all the bbcodes, from using the modified database entries, that need to be updated etc...

To use the standard database dumps from EVE. It also parses the bbcode evefit better than before, it is more forgiving for line entries and is not strict, such as having high slot items at the top etc...

Anyway, you can take a look at the bbcode changes here:
https://almostawesome.org/download/bbcode_eve.txt

You can grab the images from my server, just add the domain to the start of any image.

Example Image of the EVEFit
http://puu.sh/ewZ39/03a5819d32.jpg
Clean format of parssed text:
http://puu.sh/ewZbn/14b592b571.png

Compare what was posted in the thread with the above output:

[evefit][Confessor, Confessor - DNA Imported]

Coreli A-Type Small Armor Repairer
Damage Control II
Heat Sink II
Imperial Navy Energized Adaptive Nano Membrane
Nanofiber Internal Structure II

Faint Epsilon Warp Scrambler I
Federation Navy 10MN Afterburner
Small Capacitor Booster II, Navy Cap Booster 100

Small Energy Neutralizer II
Dual Light Pulse Laser II, Sanshas Ultraviolet S
Dual Light Pulse Laser II, Sanshas Ultraviolet S
Dual Light Pulse Laser II, Sanshas Ultraviolet S
Dual Light Pulse Laser II, Sanshas Ultraviolet S
Dual Light Pulse Laser II, Sanshas Ultraviolet S
Dual Light Pulse Laser II, Sanshas Ultraviolet S

Small Ancillary Current Router II
Small Auxiliary Nano Pump II
Small Nanobot Accelerator I
Imperial Navy Multifrequency S x6
Navy Cap Booster 400 x1[/evefit]
0mni Ca
Brutor Tribe
Minmatar Republic
#1139 - 2015-01-15 01:33:11 UTC  |  Edited by: 0mni Ca
I have also found out how to use the mod with openfire 3.9.3 and userservice v2+, the userservice plugin was modified so that the old system no longer worked, it used a RESTful system, similar to how CREST works.

Anyway, here is a copy of the post I replied to Cyerus on the openfire board:
https://community.igniterealtime.org/thread/53852
Quote:
Hey there, 0mni from EVE.

I just recently setup phpBB and used your mod as a starting base for our alliance's website.

You can see how I solved the problem with Openfire UserService plugin v2+.

https://almostawesome.org/download/openfire_userservice.txt

Keep in mind, that changes need to be made to functions_eveapi.php
If your savvy enough, you can figure it out :)

https://almostawesome.org/download/openfire_eve.txt

Oh yah, requires CURL and SimpleXMLElement support :)
Snitch Ashor
Republic Military School
Minmatar Republic
#1140 - 2015-01-15 10:30:42 UTC
0mni Ca wrote:
I have converted all the bbcodes, from using the modified database entries, that need to be updated etc...

To use the standard database dumps from EVE. It also parses the bbcode evefit better than before, it is more forgiving for line entries and is not strict, such as having high slot items at the top etc...

Anyway, you can take a look at the bbcode changes here:
https://almostawesome.org/download/bbcode_eve.txt

You can grab the images from my server, just add the domain to the start of any image.

Example Image of the EVEFit
http://puu.sh/ewZ39/03a5819d32.jpg
Clean format of parssed text:
http://puu.sh/ewZbn/14b592b571.png
...


Very nice work!

Just a few questions...

Do you use Steves conversion?

as fas as i see the only tables required are mapSolarSystems, dgmTypeAttributes and invTypes. And where exactly do you include your CSS? just for the Theme? As you also place all icons using CSS is the original Javascript still required?

Thanks, Snitch