vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Advanced Warning System (Beta Version) (https://vborg.vbsupport.ru/showthread.php?t=95921)

GoTTi 05-16-2006 12:31 PM

great news delphi. lemme ask u, i have te AWS from 3.0x world installed still im sure in the DB. do i need to do anything special to make sure it is completely out of my system so i dont have problems with this? is there a uninstall older version or upgrade tool wth this? lemme know thanks.

dai-kun 05-16-2006 11:20 PM

Quote:

Originally Posted by Delphiprogrammi
hi people,

Here it is.The system that uses phrases.To install import product-aws.xml(set overwrite to yes).Do the template edits (and other stuff) explained in readme.txt after that it should be ready to use

u forgot the product file in the new zip?

Gooses 05-17-2006 04:54 AM

Wait, so this works with vB 3.5.4?

Delphiprogrammi 05-17-2006 09:48 AM

Quote:

Originally Posted by dai-kun
u forgot the product file in the new zip?

no includes/xml/ ...

Delphiprogrammi 05-17-2006 09:48 AM

Quote:

Originally Posted by Gooses
Wait, so this works with vB 3.5.4?

yes it does

dai-kun 05-17-2006 10:15 PM

I have trouble running kill_alerts cron
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_user SER alerts='0' WHERE userid='39752';

MySQL Error : 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 'alerts='0' WHERE userid='39752'' at line 1
Error Number : 1064
Date : Wednesday, May 17th 2006 @ 04:12:29 PM
Script : http://domain.com/forum/admincp/cron...cron&cronid=40

I think
Code:

        $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SER alerts='{$alerts}' WHERE userid='{$warn['userid']}'");
should be:
Code:

        $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SET alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

Also.. for some reason, when the warnings expire, they do not show up anymore in the view warnings, but i can still see a "Warnings: 1" in their postbit. This been happening for a really long time and I just never brought it up :/

Delphiprogrammi 05-19-2006 03:54 PM

Quote:

Originally Posted by dai-kun
I have trouble running kill_alerts cron
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_user SER alerts='0' WHERE userid='39752';

MySQL Error : 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 'alerts='0' WHERE userid='39752'' at line 1
Error Number : 1064
Date : Wednesday, May 17th 2006 @ 04:12:29 PM
Script : http://domain.com/forum/admincp/cron...cron&cronid=40

I think
Code:

    $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SER alerts='{$alerts}' WHERE userid='{$warn['userid']}'");
should be:
Code:

    $vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."user SET alerts='{$alerts}' WHERE userid='{$warn['userid']}'");

Also.. for some reason, when the warnings expire, they do not show up anymore in the view warnings, but i can still see a "Warnings: 1" in their postbit. This been happening for a really long time and I just never brought it up :/

1)you are right about the MySQL query that's a typo.I have updated the zip package

2)i think that problem is caused by the username cache vbulletin uses the system isn't yet implemented to use that.I have no experience with it so kinda scared i mess up hehe

sv1cec 05-20-2006 07:50 AM

Delphi,

I have entered your name in the supporters/co-authors. So you should be able to update the distribution files. If not, please contact the administrators, you can edit the hack with my blessings!

Rgds

Marco van Herwaarden 05-20-2006 12:19 PM

Quote:

Originally Posted by Delphiprogrammi
hi people,

Here it is.The system that uses phrases.To install import product-aws.xml(set overwrite to yes).Do the template edits (and other stuff) explained in readme.txt after that it should be ready to use

zip file updated to include a fix for a typo in a MySQL query

Hi Delphiprogrammi,

Thank you very much for creating a new zip-file.

I have a few questions/remarks in your latest zip file:
- The updated files that are included in the thread start, are they still needed with your zip?
- The product file will with most installations never be uploaded to the forum directories. In the zip it is however located in includes/xml. Better move it outside of the upload directory.
- Readme is also most convenient if not between the files to upload, but on a higher level directory
- The includes/xml directory contain 2 files that i suppose shouldn't be there: vbulletin-adminhelp.xml & vbulletin-language.xml
- Is it correct that Warn.php start with an uppercase W?


If you are going to add your zip-file to the first post and have problems with that, sent me a PM please.

Delphiprogrammi 05-20-2006 01:18 PM

Quote:

Originally Posted by MarcoH64
Hi Delphiprogrammi,

Thank you very much for creating a new zip-file.

I have a few questions/remarks in your latest zip file:
- The updated files that are included in the thread start, are they still needed with your zip?
- The product file will with most installations never be uploaded to the forum directories. In the zip it is however located in includes/xml. Better move it outside of the upload directory.
- Readme is also most convenient if not between the files to upload, but on a higher level directory
- The includes/xml directory contain 2 files that i suppose shouldn't be there: vbulletin-adminhelp.xml & vbulletin-language.xml
- Is it correct that Warn.php start with an uppercase W?


If you are going to add your zip-file to the first post and have problems with that, sent me a PM please.

1)No all the files the system uses have changed.Also the update instructions for the warn_notes features are already included in the product
2)i moved readme.txt to a directory called "docs"
3)i removed those files from /includes/xml they indeed shouldn't be there.I also moved the product file outside of the upload directory
4)that file always started with an uppercase "W" (i'll look into changing that )
5)I already sended a pm to Xenon about being unable to edit the hack settings.I did before you posted in this thread.Let's wait and see what he got to say.Maybe it is because the system that handles that things is being changed ?


All times are GMT. The time now is 01:44 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02148 seconds
  • Memory Usage 1,757KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete