| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 272 online users.
» 0 Member(s) | 269 Guest(s)
Bing, Google, Yandex
|
| Latest Threads |
UserSpice 4.4 Development
Forum: News Center
Last Post: ehc.ankur
11-10-2021, 10:23 AM
» Replies: 1
» Views: 15,199
|
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
|
changes to navigation.php...
Forum: UserSpice 4.4
Last Post: mudmin
07-07-2019, 10:46 AM
» Replies: 2
» Views: 8,331
|
Duplicated files in /user...
Forum: UserSpice 4.4
Last Post: mudmin
07-07-2019, 10:44 AM
» Replies: 1
» Views: 6,582
|
|
|
| Steam Integration addon |
|
Posted by: clumsyzombie - 08-10-2016, 11:01 AM - Forum: UserSpice 4.3 and Below
- Replies (8)
|
 |
Hello,
Wanted to ask here I see there is all kind of addons people are making for this. I wanted to see if anyone has looked into a steam integration add on that would allow developers to utilize peoples steam community information and link there profiles to steam.
Wanted to check around and ask before I write one and reinvent the wheel.
|
|
|
|
| Display MySQL data |
|
Posted by: kang08 - 08-07-2016, 05:21 AM - Forum: Documentation
- Replies (8)
|
 |
Hi, I am new to user spice and just started working on PhP MYSQL as i'm building a blog system. Sorry for asking stupid question. How can i fetch all data from mysql and display it? Here is the error code:
<pre> Code: Fatal error: Uncaught Error: Call to a member function query() on null
<?php
try {
$stmt = $db->query('SELECT postID, postTitle, postDesc, postDate FROM blog_posts ORDER BY postID DESC');
while($row = $stmt->fetch()){
echo '<div>';
echo '<h1>.']'.$row['postTitle'].'</h1>';
echo '<p>Posted on '.date('jS M Y H:i ', strtotime($row['postDate'])).'</p>';
echo '<p>'.$row['postDesc'].'</p>';
echo '<p>.']Read More</p>';
echo '</div>';
}
}
?>
|
|
|
|
| valitation error mesage join page |
|
Posted by: joshuejess - 07-30-2016, 04:53 PM - Forum: UserSpice 4.3 and Below
- Replies (3)
|
 |
hi , i have this error in clean install .. i did install again and the error message is there …
Notice: Undefined offset: 1 in C:\wamp64\www\spice_limpio\users\helpers\helpers.php on line 75
Call Stack
# Time Memory Function Location
1 0.0005 285504 {main}( ) …\join.php:0
2 0.1010 791552 require( ‘C:\wamp64\www\spice_limpio\users\views\_join.php’ ) …\join.php:211
3 0.1011 791616 display_errors( ) …\_join.php:25
this happen if not checked the agreement checkbox in join page . … if agreement is cheked its work normal and insert the data in database . if a make a class =””checked no problem., its go on … but if the user uncheck the agreement show this eror . upside of error of validation message “Please read and accept terms and conditions” …. i need help to fix this problem thank you …. sorry for my english .
|
|
|
|
| agreement checkbox error |
|
Posted by: joshuejess - 07-30-2016, 04:07 AM - Forum: New to UserSpice?
- No Replies
|
|
hi , i have this error in clean install .. i did install again and the error message is there ...
Notice: Undefined offset: 1 in C:\wamp64\www\spice_limpio\users\helpers\helpers.php on line 75
Call Stack
# Time Memory Function Location
1 0.0005 285504 {main}( ) ...\join.php:0
2 0.1010 791552 require( 'C:\wamp64\www\spice_limpio\users\views\_join.php' ) ...\join.php:211
3 0.1011 791616 display_errors( ) ...\_join.php:25
this happen if not checked the agreement checkbox in join page . ... if agreement is cheked its work normal and insert the data in database . if a make a class =""checked no problem., its go on ... but if the user uncheck the agreement show this eror . upside of error of validation message "Please read and accept terms and conditions" .... i need help to fix this problem thank you .... sorry for my english .
|
|
|
|
| Mysql error |
|
Posted by: Mekaboo - 07-29-2016, 12:55 AM - Forum: Off-topic Discussions
- No Replies
|
 |
Hello there once again Im coning to you for an error help  This time I get this :mysqladmin access denied for user using password no
If anyone can help how do I fix this? You all have been really helpful with your advice!!
Mekaboo
|
|
|
|
| SQL Query |
|
Posted by: CuChulla1nn - 07-28-2016, 10:47 AM - Forum: UserSpice 4.3 and Below
- Replies (1)
|
 |
Hey there,
I have my website running with Userspice and I like it a lot. Now I want to display a table with data from a database. I understand how to execute basic querys but mine is a bit special. Could you help me transform it into the right format to fit into Userspice?
<pre> Code: SELECT
X.datum,
MAX(X.schicht1) AS schicht1,
MAX(X.schicht2) AS schicht2,
MAX(X.schicht3) AS schicht3,
MAX(X.schicht4) AS schicht4,
MAX(X.schicht5) AS schicht5,
MAX(X.schicht6) AS schicht6,
MAX(X.schicht7) AS schicht7,
MAX(X.schicht8) AS schicht8,
MAX(X.schicht9) AS schicht9,
MAX(X.schicht10) AS schicht10
FROM
(SELECT
datum,
CASE WHEN s.schichtID = 1 THEN u.username ELSE NULL
END AS schicht1,
CASE WHEN s.schichtID = 2 THEN u.username ELSE NULL
END AS schicht2,
CASE WHEN s.schichtID = 3 THEN u.username ELSE NULL
END AS schicht3,
CASE WHEN s.schichtID = 4 THEN u.username ELSE NULL
END AS schicht4,
CASE WHEN s.schichtID = 5 THEN u.username ELSE NULL
END AS schicht5,
CASE WHEN s.schichtID = 6 THEN u.username ELSE NULL
END AS schicht6,
CASE WHEN s.schichtID = 7 THEN u.username ELSE NULL
END AS schicht7,
CASE WHEN s.schichtID = 8 THEN u.username ELSE NULL
END AS schicht8,
CASE WHEN s.schichtID = 9 THEN u.username ELSE NULL
END AS schicht9,
CASE WHEN s.schichtID = 10 THEN u.username ELSE NULL
END AS schicht10
FROM
schichten s
LEFT JOIN users u
ON s.userID = u.id
) X
WHERE DATE
(datum) >= DATE(NOW())
GROUP BY X.datum
I would appreciate the help.
Best regards,
Yannick
|
|
|
|
| Additional Folders... |
|
Posted by: A.Long - 07-25-2016, 11:54 AM - Forum: UserSpice 4.3 and Below
- Replies (2)
|
 |
So I read the walk thru, and all was going well until the point of the admin_pages.php and to find the variable. There doesn't appear to be a $uspages variable, so adding your own custom to monitor additional pages seems to not work so well. US4.1 is the version I'm using. Any suggestions? I know I saw you mention that you were going to change the way it handles. Any details would be great.
|
|
|
|
|
