Bringing PHPRivals To SMF!

[CFCParadox]

Hmm that was weird O_O

It seems to be working fine now.

I just got that error and it disappeared...

Anyways thanks Tyler!

[CFCParadox]

Okay when trying to add a clan, platform, season I get different codes but they are all similar when I submit it.

Here is what I got when I was trying to submit a clan:

Code Select Expand

EXCEPTION CLASS: db_mysql_exception

MESSAGE: SQL query has failed.

SQL: INSERT INTO rivals__clans (clan_name, clan_tag, clan_info, clan_joining, clan_tournaments, clan_leader) VALUES ('Cool', 'asdf', 'asdf', 1, '', 1537)

SQL Error: Table 'combatc1_smf1.rivals__clans' doesn't exist



[/home/combatc1/public_html/forums/rivals_app/core/dbal/db_mysql.php] (137)... db_mysql->sql_insert(rivals__clans,Array);

    * 142

         'clan_tournaments' => '',

    * 143

         'clan_leader' => ( $user_id == 0 ) ?

    * 144

          registry::$user->user_id :

    * 145

          $user_id )

    * 146

        );

    * 147

       }

    * 148


    * 149

       /*

    * 150

       * Edits a clan in the database.

    * 151

       */

    * 152

       public function edit_clan ( $clan_id, $data )


TRACE

    * 1

      [/home/combatc1/public_html/forums/rivals_app/core/rivals_clan.php] (147) db_mysql->sql_insert(rivals__clans,Array);

    * 2

      [/home/combatc1/public_html/forums/rivals_app/add_clan.php] (83) rivals_clan->add_clan(Array);

    * 3

      [/home/combatc1/public_html/forums/rivals_app/index.php] (99) add_clan->submit();



When I looked at the clan list there was nothing there too.

[TylerK]

Check your db see if there is a rivals_clans table.

[CFCParadox]

Yes there is a rivals_clans table.

[TylerK]

Its looking for rivals__, two underscores, whats TABLE_PREFIX value in your config.php?

[KensonPlays]

What do you suggest tyler? On my test forum it installed, but when I navigate to url through address bar in firefox  (URL IS: http://www.kcmartz.com/TestForum/r_a/) Try navigating, now I get a:

Failed to connect to database. Wrong host, username or password.

[CFCParadox]

Its looking for rivals__, two underscores, whats TABLE_PREFIX value in your config.php?

I'm using the rivals_ prefix.

Want me to change it?

[CFCParadox]

Okay I re-installed with the prefix of: rivals

It works ALMOST perfectly now! I just still get that clan error but going back to the main directory everything is fine.

Thanks Tyler. Hope the Portal comes soon

[CFCParadox]

What do you suggest tyler? On my test forum it installed, but when I navigate to url through address bar in firefox  (URL IS: http://www.kcmartz.com/TestForum/r_a/) Try navigating, now I get a:

Failed to connect to database. Wrong host, username or password.

Check you config.php

And how did you like it like that? I wanted to make mine: http://www.combatfps.com/forums/leagues/

[CFCParadox]

2 More Problems

1. How can you add a title to the index.php so I can make it say something like Combat FPS League.

2. Words do not fit: http://combatfps.com/forums/rivals_app/index.php?class=clan_profile&clan_id=2

Thanks

[CFCParadox]

1 More Problem

1. When you go to Manage Platforms > Add A Ladder ... It does not work and redirects you to a weird page...

http://combatfps.com/forums/rivals_app/index.php?class=acp/acp

Thanks

Edit: More Problems...

When you go to: http://combatfps.com/forums/rivals_app/index.php?class=add_clan and you already added a clan...

It says: Sorry, only one clan per user.

But then there's some overlapping and I can see another forum menu below that. It's really weird.

But PHPRivals is almost there for SMF!

[TylerK]

Please post all bugs to phprivals.com [nofollow] and read the HOWTO post a bug topic. Hard to keep track of them here, and btw a work around for the renaming of the folder.. for now you can URL rewrite it with mod_rewrite to fake it.

Thanks.

[CFCParadox]

I can't seem to register on your PHPBB Forum/site using Mozilla and IE...

Edit: Is is also possible to change what the portal says so I can put some temporary images and text there?

[TylerK]

Should be fixed now, and yes, for now edit templates/portal.html

[dangermouse13]

is this working with smf2.0...?

i am so hopeful of something like this for my community.
where is the download link for this, is it installed same as normal smf packages. anything different I have to do?

cheers for any help. 

[hcfwesker]

Ummmm.  I read page after page, and every post in this topic.  Where exactly is the download for this to use with smf 1.1.11?

All I've seen is a link to download phpRivals, and no list of smf compatibility.

[KensonPlays]

hcfwesker, go to phprivals.com, then download and download it. then extract, upload and go through install, "SMF" and "SMF 2" are choices for install...

[hcfwesker]

Thanx for replying.  Sad thing is I'm so new to this.  Only been on smf for a month.  So all this zipping and extracting is new to me.  I found this.

      1. Put the rivals_app folder into your root myBB directory.  <-- I'm assuming it meant to say SMF
      2. Run install/ in your browser window.


And when I extract, and just try to upload the rivals_app folder itself, uit won't let me, it just open the next folders; what's the trick to just uploading the folder.  The zip itself won't, so, now I'm lost.

Unless I have to manually create each folder, and upload each file 1 by 1

[Rav33n]

And when I extract, and just try to upload the rivals_app folder itself, uit won't let me, it just open the next folders; what's the trick to just uploading the folder.  The zip itself won't, so, now I'm lost.

Unless I have to manually create each folder, and upload each file 1 by 1

What FTP client are you using? Try CuteFTP or SmartFTP, they both allow simple drag n drop uploads which makes things very easy.

Alternatively try http://www.net2ftp.com, if memory serves me correctly, they allow folder uploads as well.

Gluck.

[hcfwesker]

I've never used FTP before.  I tried it, but I could never even get my actual files from my cPanel to show up, so I just handle everything in  the File Manager.

I have the SMFrivals MOD, it's a neat system, but it's really unorganized, and I heard PHPrivals is the better of the 2.

I'm just facing a brick wall right now on how to actually get it added.