| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 712 online users.
» 0 Member(s) | 708 Guest(s)
Applebot, Baidu, Bing, Google
|
| Latest Threads |
UserSpice Alpha Testing a...
Forum: News Center
Last Post: ivinsons
11-08-2024, 06:13 PM
» Replies: 13
» Views: 42,475
|
UserSpice 4.4 Development
Forum: News Center
Last Post: Amelie12
09-21-2024, 12:23 PM
» Replies: 4
» Views: 15,199
|
Welcome to the new UserSp...
Forum: News Center
Last Post: ivinsons
08-25-2024, 07:39 AM
» Replies: 2
» Views: 27,918
|
How to use hasPerm
Forum: UserSpice 4.4
Last Post: mudmin
07-20-2019, 02:45 PM
» Replies: 1
» Views: 13,755
|
Session issue? What I sho...
Forum: UserSpice 4.4
Last Post: Parth
07-17-2019, 05:06 PM
» Replies: 4
» Views: 14,502
|
Email Error
Forum: UserSpice 4.4
Last Post: Brandin
07-17-2019, 04:47 PM
» Replies: 1
» Views: 6,623
|
{ Missing Text } after up...
Forum: UserSpice 4.4
Last Post: Brandin
07-16-2019, 04:23 PM
» Replies: 22
» Views: 53,638
|
Best Practice Info
Forum: New to UserSpice?
Last Post: Brandin
07-16-2019, 11:55 AM
» Replies: 1
» Views: 13,490
|
Force to use 2FA -always-
Forum: UserSpice 4.4
Last Post: Brandin
07-12-2019, 12:43 PM
» Replies: 1
» Views: 6,636
|
e-mail not verifying
Forum: UserSpice 4.4
Last Post: LBC
07-10-2019, 11:34 AM
» Replies: 31
» Views: 76,232
|
|
|
| LOl |
|
Posted by: dave3460 - 10-15-2017, 01:12 PM - Forum: New to UserSpice?
- Replies (1)
|
 |
Just realised been here a while
And havent said Hello
Well Hey all Thanks for you Knowledge in forums and for Userspice
|
|
|
|
| Status Update 034 |
|
Posted by: Brandin - 10-14-2017, 07:39 PM - Forum: UserSpice 4.3 and Below
- No Replies
|
 |
Includes @Karsen's changed
UPDATES
users
admin_messages.php - added "Send Email" checkbox and PHP for Mass Mailing
maintenance.php - added redirect if site offline is 0
messages.php - added "Send Email" checkbox and PHP for Mass Mailing
includes
header.php - added maintenance loggers
views
_joinThankYou.php - added extra line break
join.php - added ucfirst to fname and lname only on db insert
admin_users.php - added ucfirst to fname and lname only on db insert
admin_user.php - added ucfirst to fname and lname
user_settings.php - added ucfirst to fname and lname
helpers
us_helpers.php - changed echouser no result from "-" to "Unknown" to be in line with echousername
43.sql - made admin user protected and force_pr 1
|
|
|
|
| Problem with custom pages |
|
Posted by: komodo - 10-13-2017, 04:13 PM - Forum: UserSpice 4.3 and Below
- Replies (2)
|
 |
Hello
I tried to add a custom page to the script. So I created a customPage.php and put it into /usersc/
Then I went to the admin panel to register the page in pages and it showed up correctly.
48 usersc/customPage.php Public
However if I want to load it following error appears:
Warning: require_once(init.php): failed to open stream: No such file or directory in /Applications/XAMPP/xamppfiles/htdocs/project/usersc/customPage.php on line 25
Fatal error: require_once(): Failed opening required 'init.php' (include_path='.:/Applications/XAMPP/xamppfiles/lib/php') in /Applications/XAMPP/xamppfiles/htdocs/project/usersc/customPage.php on line 25
Tile is clearly there. Any solutions?
|
|
|
|
| Hello |
|
Posted by: komodo - 10-13-2017, 03:36 PM - Forum: New to UserSpice?
- Replies (2)
|
|
Hello!
I've recently stumbled upon UserSpice while searching for suitable user management systems.
I've checked out the latest version and it seem to be great for people who are learning to code or are not pro programmers like me. Nice video tutorials!
Keep working on this project 
komodo
|
|
|
|
| $db->query not returning records |
|
Posted by: eer3 - 10-10-2017, 08:31 PM - Forum: UserSpice 4.3 and Below
- Replies (7)
|
 |
I have a local Userspice install and database queries work fine. I tried to create a brand new, clean install in my hosted environment and the installation works, logins work, everything looks good. But, when trying to query data (for example the users table), no actual results are ever returned. I have listed a sample of php that I am using to test with and provided the results from the failing - and the successful - servers. These are both untouched installations (no modifications to any files or database, except to dump the users query). What is the next step that I can take to troubleshoot what the issue is with the hosted environment? Great product by the way!
Here's the php:
<pre> Code: <?php
$users = $db->query("SELECT * FROM USERS");
dnd($users);
?>
Here's the result on the failing server:
object(DB)#2 (8) {
["_pdo":"DB":private]=>
object(PDO)#3 (0) {
}
["_query":"DB":private]=>
object(PDOStatement)#6 (1) {
["queryString"]=>
string(19) "SELECT * FROM USERS"
}
["_error":"DB":private]=>
bool(true)
["_results":"DB":private]=>
array(1) {
[0]=>
object(stdClass)#9 (3) {
["id"]=>
string(2) "47"
["page"]=>
string(22) "users/project_root.php"
["private"]=>
string(1) "0"
}
}
["_resultsArray":"DB":private]=>
array(1) {
[0]=>
array(3) {
["id"]=>
string(2) "47"
["page"]=>
string(22) "users/project_root.php"
["private"]=>
string(1) "0"
}
}
["_count":"DB":private]=>
int(1)
["_lastId":"DB":private]=>
string(1) "0"
["_queryCount":"DB":private]=>
int(11)
}
Here's the result on the successful server:
C:\wamp64\www\demo\users\helpers\helpers.php:216:
object(DB)[2]
private '_pdo' =>
object(PDO)[3]
private '_query' =>
object(PDOStatement)[6]
public 'queryString' => string 'SELECT * FROM USERS' (length=19)
private '_error' => boolean false
private '_results' =>
array (size=2)
0 =>
object(stdClass)[8]
public 'id' => string '1' (length=1)
public 'email' => string 'userspicephp@gmail.com' (length=22)
public 'username' => string 'admin' (length=5)
public 'password' => string '$2y$12$1v06jm2KMOXuuo3qP7erTuTIJFOnzhpds1Moa8BadnUUeX0RV3ex.' (length=60)
public 'fname' => string 'Dan' (length=3)
public 'lname' => string 'Hoover' (length=6)
public 'permissions' => string '1' (length=1)
public 'logins' => string '47' (length=2)
public 'account_owner' => string '1' (length=1)
public 'account_id' => string '0' (length=1)
public 'company' => string 'UserSpice' (length=9)
public 'stripe_cust_id' => string '' (length=0)
public 'billing_phone' => string '' (length=0)
public 'billing_srt1' => string '' (length=0)
public 'billing_srt2' => string '' (length=0)
public 'billing_city' => string '' (length=0)
public 'billing_state' => string '' (length=0)
public 'billing_zip_code' => string '' (length=0)
public 'join_date' => string '2016-01-01 00:00:00' (length=19)
public 'last_login' => string '2017-10-10 22:10:10' (length=19)
public 'email_verified' => string '1' (length=1)
public 'vericode' => string '322418' (length=6)
public 'title' => string '' (length=0)
public 'active' => string '0' (length=1)
public 'custom1' => string '' (length=0)
public 'custom2' => string '' (length=0)
public 'custom3' => string '' (length=0)
public 'custom4' => string '' (length=0)
public 'custom5' => string '' (length=0)
public 'oauth_provider' => string '' (length=0)
public 'oauth_uid' => string '' (length=0)
public 'gender' => string '' (length=0)
public 'locale' => string '' (length=0)
public 'gpluslink' => string '' (length=0)
public 'picture' => string '' (length=0)
public 'created' => string '0000-00-00 00:00:00' (length=19)
public 'modified' => string '1899-11-30 00:00:00' (length=19)
public 'fb_uid' => string '' (length=0)
public 'un_changed' => string '0' (length=1)
1 =>
object(stdClass)[10]
public 'id' => string '2' (length=1)
public 'email' => string 'noreply@userspice.com' (length=21)
public 'username' => string 'user' (length=4)
public 'password' => string '$2y$12$HZa0/d7evKvuHO8I3U8Ff.pOjJqsGTZqlX8qURratzP./EvWetbkK' (length=60)
public 'fname' => string 'Sample' (length=6)
public 'lname' => string 'User' (length=4)
public 'permissions' => string '1' (length=1)
public 'logins' => string '5' (length=1)
public 'account_owner' => string '1' (length=1)
public 'account_id' => string '0' (length=1)
public 'company' => string 'none' (length=4)
public 'stripe_cust_id' => string '' (length=0)
public 'billing_phone' => string '' (length=0)
public 'billing_srt1' => string '' (length=0)
public 'billing_srt2' => string '' (length=0)
public 'billing_city' => string '' (length=0)
public 'billing_state' => string '' (length=0)
public 'billing_zip_code' => string '' (length=0)
public 'join_date' => string '2016-01-02 00:00:00' (length=19)
public 'last_login' => string '2017-02-20 12:14:10' (length=19)
public 'email_verified' => string '1' (length=1)
public 'vericode' => string '970748' (length=6)
public 'title' => string '' (length=0)
public 'active' => string '1' (length=1)
public 'custom1' => string '' (length=0)
public 'custom2' => string '' (length=0)
public 'custom3' => string '' (length=0)
public 'custom4' => string '' (length=0)
public 'custom5' => string '' (length=0)
public 'oauth_provider' => string '' (length=0)
public 'oauth_uid' => string '' (length=0)
public 'gender' => string '' (length=0)
public 'locale' => string '' (length=0)
public 'gpluslink' => string '' (length=0)
public 'picture' => string '' (length=0)
public 'created' => string '0000-00-00 00:00:00' (length=19)
public 'modified' => string '0000-00-00 00:00:00' (length=19)
public 'fb_uid' => string '' (length=0)
public 'un_changed' => string '0' (length=1)
private '_resultsArray' =>
array (size=2)
0 =>
array (size=39)
'id' => string '1' (length=1)
'email' => string 'userspicephp@gmail.com' (length=22)
'username' => string 'admin' (length=5)
'password' => string '$2y$12$1v06jm2KMOXuuo3qP7erTuTIJFOnzhpds1Moa8BadnUUeX0RV3ex.' (length=60)
'fname' => string 'Dan' (length=3)
'lname' => string 'Hoover' (length=6)
'permissions' => string '1' (length=1)
'logins' => string '47' (length=2)
'account_owner' => string '1' (length=1)
'account_id' => string '0' (length=1)
'company' => string 'UserSpice' (length=9)
'stripe_cust_id' => string '' (length=0)
'billing_phone' => string '' (length=0)
'billing_srt1' => string '' (length=0)
'billing_srt2' => string '' (length=0)
'billing_city' => string '' (length=0)
'billing_state' => string '' (length=0)
'billing_zip_code' => string '' (length=0)
'join_date' => string '2016-01-01 00:00:00' (length=19)
'last_login' => string '2017-10-10 22:10:10' (length=19)
'email_verified' => string '1' (length=1)
'vericode' => string '322418' (length=6)
'title' => string '' (length=0)
'active' => string '0' (length=1)
'custom1' => string '' (length=0)
'custom2' => string '' (length=0)
'custom3' => string '' (length=0)
'custom4' => string '' (length=0)
'custom5' => string '' (length=0)
'oauth_provider' => string '' (length=0)
'oauth_uid' => string '' (length=0)
'gender' => string '' (length=0)
'locale' => string '' (length=0)
'gpluslink' => string '' (length=0)
'picture' => string '' (length=0)
'created' => string '0000-00-00 00:00:00' (length=19)
'modified' => string '1899-11-30 00:00:00' (length=19)
'fb_uid' => string '' (length=0)
'un_changed' => string '0' (length=1)
1 =>
array (size=39)
'id' => string '2' (length=1)
'email' => string 'noreply@userspice.com' (length=21)
'username' => string 'user' (length=4)
'password' => string '$2y$12$HZa0/d7evKvuHO8I3U8Ff.pOjJqsGTZqlX8qURratzP./EvWetbkK' (length=60)
'fname' => string 'Sample' (length=6)
'lname' => string 'User' (length=4)
'permissions' => string '1' (length=1)
'logins' => string '5' (length=1)
'account_owner' => string '1' (length=1)
'account_id' => string '0' (length=1)
'company' => string 'none' (length=4)
'stripe_cust_id' => string '' (length=0)
'billing_phone' => string '' (length=0)
'billing_srt1' => string '' (length=0)
'billing_srt2' => string '' (length=0)
'billing_city' => string '' (length=0)
'billing_state' => string '' (length=0)
'billing_zip_code' => string '' (length=0)
'join_date' => string '2016-01-02 00:00:00' (length=19)
'last_login' => string '2017-02-20 12:14:10' (length=19)
'email_verified' => string '1' (length=1)
'vericode' => string '970748' (length=6)
'title' => string '' (length=0)
'active' => string '1' (length=1)
'custom1' => string '' (length=0)
'custom2' => string '' (length=0)
'custom3' => string '' (length=0)
'custom4' => string '' (length=0)
'custom5' => string '' (length=0)
'oauth_provider' => string '' (length=0)
'oauth_uid' => string '' (length=0)
'gender' => string '' (length=0)
'locale' => string '' (length=0)
'gpluslink' => string '' (length=0)
'picture' => string '' (length=0)
'created' => string '0000-00-00 00:00:00' (length=19)
'modified' => string '0000-00-00 00:00:00' (length=19)
'fb_uid' => string '' (length=0)
'un_changed' => string '0' (length=1)
private '_count' => int 2
private '_lastId' => string '0' (length=1)
private '_queryCount' => int 11
|
|
|
|
| Status Update 033 |
|
Posted by: Brandin - 10-09-2017, 05:30 PM - Forum: UserSpice 4.3 and Below
- Replies (3)
|
|
I fixed the conflicts with Dan's push.
New SQL dump required.
UPDATES
users
admin.php - Removed {} around ifs and else for viewing purposes
views
_admin_stats.php - Indented "Statistics" h2
_admin_site_settings.php - Added tooltips
_admin_register_settings.php - Added tooltips, changed recommends to selects instead of inputs
_admin_login_settings.php - Changed hyperlink to docs to have a target attribute of blank to open in new tab/window
_admin_css_settings.php - Changed notes to tooltips
_join.php - Changed hyperlink to be nounderline for viewing purposes, "confirm" ID was being used twice, corrected this, made label wrap agreement_checkbox
_verify_resend.php - Removed jumbotron to match the other pages, added <br> after form
Removed all jumbotrons from the forgot_password and verify views
Added nounderline class to all links
admin_users.php
-Add User Form: added password generator for when force_pr=1, also makes the input readonly, includes the show password and reason why you can't edit
admin_user.php - made all checkboxes surrounded by non-bolded labels (adding class "normal") and cleaned up a bit
view_all_users.php, profile.php, edit_profile.php - few minor changes for appearance, changed ucfirst to echouser.
user_settings.php - added show password and reason why you can't edit username if applicable, moved () info to popover
admin_permission.php - added labels to all checkboxes to make the label clickable
|
|
|
|
| Status Update 032 |
|
Posted by: mudmin - 10-09-2017, 02:29 PM - Forum: UserSpice 4.3 and Below
- No Replies
|
 |
Needs new SQL Dump.
Note: There were merge conflicts with Brandin, but I think I got it all together. We should double check though.
Added a feature that logs the unique ips your users login with. This is used if people bump into tomfoolery issues when they're not logged in. If multiple users login from the same ip address, the last one is recorded currently.
Ability to add blacklisted and whitelisted ips. Ability to delete them.
Ability to blacklist an ip from the tomfoolery page. Automatically ignores ::1 and 127.0.0.1.
Banned IP addresses show up red in tomfoolery.
Note that I didn't add automatic banning of IPs yet.
|
|
|
|
| Status Update 031 |
|
Posted by: Brandin - 10-08-2017, 08:42 PM - Forum: UserSpice 4.3 and Below
- Replies (5)
|
|
New SQL dump required.
Added {{hr}} in DB-driven nav for dropdowns
Changed the whole DB-driven nav to match the current format and style of the non DB-driven nav
Added {{username}} to the itemString prepare in the menus.php file
Added {{notifications}} and {{messages}} to the db-driven navbar
The navbar was using checkMenu on the ID of the nav item which was causing non-master users to see only menu items with IDs within their perm levels...e.g. menu ID 2 was showing up for non-master admins. I migrated the function to hasPerm and added the appropriate criteria which resolved the issue.
Had to repair the logic on admin_menu_item.php for permissions. There was no value attribute on the checkboxes which was causing the updates to be the Array ID which would be in order (e.g. 1, 2, 3) but if you selected Perm 0 and 2, it would add for 0 and 1 due to the array ID. I added a value and removed the array_keys.
There was no logic for checking permissions within a dropdown. It simply inherited whatever the dropdown was...I added user_id logic and checking from the database nav file into the menu helpers.
Added a show for both recapatchas on the admin panel for anyone within the master account.
I switched the nav back to match the Divs of the non-db driven nav so it works right with the bootstrap corrections and the msg box does not show up above the navbar.
I fixed the email_settings page there was no query so it was dying. I removed the redirect when you are not testing and fixed the error by adding isset(). I also added the errors and successes block.
Added PHP and HTML for notif_daylimit and added the notifications on/off setting. I didn't bother wrapping the settings but just rather did the button in the menu.
Added the custom file for settings on admin_user.php and added the checks to hide/show the button and put an example of the custom file.
|
|
|
|
| Status Update 30 |
|
Posted by: mudmin - 10-08-2017, 02:42 PM - Forum: UserSpice 4.3 and Below
- Replies (1)
|
|
New dump required.
Misc bugfixes and new ip whitelist and blacklist features.
Whitelist overrides blacklist. Right now you have to add ip's from the db, but that will get sorted tomorrow unless either of you get bored and want to add the functionality.
The banned message (for both manual user blocking and ip ban) is now in usersc/scriptes/banned.php so users can customize their banhammer experience.
|
|
|
|
| UserSpice Discord Server |
|
Posted by: Brandin - 10-08-2017, 02:27 PM - Forum: News Center
- No Replies
|
|
Hello everyone!
Connect with us on Discord! Click the link below to chat with admins, mods, and other community members! Get involved in the UserSpice Alpha development or just get help! Give us your feedback! We want to connect with you on a regular basis.
https://discord.gg/j25FeHu
You can also download the Discord Mobile App, Desktop App or use the web version!
If you have any questions or concerns, please feel free to reply.
|
|
|
|
|
